When clients ask "which loan actually saves me the most money?", Total Payment Analysis is the tool that answers it. This view calculates and compares the complete cost of every loan scenario you've built, factoring in principal, interest, mortgage insurance, and cash to close across the entire loan term. Instead of focusing on monthly payment differences, this analysis reveals the big picture, showing clients how tens of thousands of dollars can separate one option from another over 15, 20, or 30 years.
Before You Start
Requirement | Details |
Loan scenarios created | You need at least two loan options already built in Deal Details with completed pricing (rate, points, loan amount, etc.) |
Pricing completed | Each scenario should have a locked or quoted rate so the analysis reflects accurate figures |
Same property/loan amount | For a meaningful comparison, your scenarios should share the same sales price, LTV, and loan amount with different rate/point combinations |
Step-by-Step: Running a Total Payment Analysis
1. Open the Loan Comparison View
Navigate to your deal and open the loan comparison screen where your scenarios are displayed side by side
2. Select the Analysis Tab
Click the Analysis tab at the top of the comparison view
3. Switch to Total View
You will see different analysis modes available. Click Total instead of Cumulative
This switches the display from a rolling monthly view to the full life-of-loan calculation
4. Review the Breakdown
The Total Payment Analysis displays the following line items for each scenario:
Line Item | What It Shows |
Number of Remaining Payments | How many months are left on the loan (e.g., 360 for a 30-year term) |
Total of All Payments | The grand total your client will pay over the life of the loan |
Total Principal | The base loan amount repaid (same across scenarios with equal loan amounts) |
Total Interest | The cumulative interest paid over the full term |
Total Mortgage Insurance | The total MI cost, which varies slightly between scenarios because lower rates amortize faster and hit the cancellation threshold sooner |
Total Cash Investment at Closing | Upfront costs including down payment, closing costs, and any discount points purchased |
5. Compare the Scenarios
Look at the Total of All Payments row to see the overall cost difference between options
Note how paying discount points increases your closing costs but can dramatically reduce total interest paid
Pay attention to the mortgage insurance line; lower rates cause MI to drop off slightly sooner, adding a small extra savings
⚠️ Important: The total principal will be identical across scenarios that share the same loan amount. The real differences show up in interest, mortgage insurance, and closing costs. Make sure your clients understand that a lower rate with points may cost more upfront but save significantly over time.
Presenting the Analysis to Clients
Expanded vs. Contracted View
View | When to Use |
Expanded | Use when walking a client through the full breakdown during a consultation so they can see every line item |
Contracted | Use for a cleaner, summary-level view when the client just wants the bottom line |
The view you choose (expanded or contracted) is exactly what will appear on both the PDF export and in the client's online account.
6. Generate the Client-Facing PDF
Toggle the view to expanded or contracted based on what you want the client to see
Export or generate the PDF from the comparison screen
The PDF will mirror the exact layout shown on your screen
7. Verify in the Client Account
Refresh the client's account view to confirm the Total Payment Analysis is displaying
The client will see the analysis formatted exactly as you presented it in Deal Details
💡 Tip: Refresh the client portal after making changes to ensure the most current version of your analysis is visible to the borrower.
Quick Reference
Open Loan Comparison → Click Analysis Tab → Select "Total" → Review Full Breakdown → Choose Expanded/Contracted View → Export PDF or Share via Client Account
Tips for Success
Lead with the bottom line — Clients respond best when you start with the total cost difference between options, then walk backward into the details
Use equal loan amounts for clean comparisons — Keeping the sales price, LTV, and loan amount the same across scenarios isolates the true impact of rate and point differences
Highlight the interest savings in dollars — Saying "you'll save $53,000 over the life of the loan" is far more powerful than quoting a rate difference of half a percent
Remember MI varies slightly between options — A lower rate amortizes the balance faster, which means mortgage insurance cancels sooner and adds a small additional savings most borrowers overlook
Match the view to your audience — Use the expanded view for detail-oriented clients and the contracted view for borrowers who just want the summary