How to Calculate Loan Analysis
Full loan analysis: monthly payment, total cost, total interest, and interest percentage.
The Formula
P*(r*(1+r)^n)/((1+r)^n-1)The loan analysis formula uses the mathematical relationship: P*(r*(1+r)^n)/((1+r)^n-1). Each variable in the formula represents a measurable quantity that affects the final result.
What Each Variable Means
Every value in the loan analysis formula, what it measures, and the value used in the worked example on this page:
| Variable | Type | Example value |
|---|---|---|
| Loan Amount | Input (you provide) | $250,000 |
| Annual Interest Rate | Input (you provide) | 6.5 % |
| Loan Term (Months) | Input (you provide) | 360 |
| Monthly Payment | Result (calculated) | — |
| Total Payment | Result (calculated) | — |
| Total Interest Paid | Result (calculated) | — |
| Interest as % of Principal | Result (calculated) | — |
Step-by-Step Method
- 1Write down the values you know: Loan Amount, Annual Interest Rate, Loan Term (Months).
- 2Substitute your known values into the formula: P*(r*(1+r)^n)/((1+r)^n-1).
- 3Work through the arithmetic in the standard order of operations — parentheses first, then exponents, then multiplication and division, then addition and subtraction.
- 4Check that your result carries the correct unit and falls in a reasonable range for the problem.
- 5Verify your answer with the interactive Loan Analysis Calculator — it solves the same formula instantly.
Worked Example
Take a concrete case: loan amount = $100,000, with the other inputs at the typical values from the variables table above. Substituting into the formula gives monthly payment = 632.07, total payment = 227544.49, total interest paid = 127544.49, interest as % of principal = 127.5. These numbers are solved by the same engine that powers the Loan Analysis calculator, so you can reproduce them exactly by entering the same inputs there.
| Loan Amount | Monthly Payment | Total Payment | Total Interest Paid | Interest as % of Principal |
|---|---|---|---|---|
| $1,000 | 6.32 | 2275.44 | 1275.44 | 127.5 |
| $100,000 | 632.07 | 227544.49 | 127544.49 | 127.5 |
| $200,000 | 1264.14 | 455088.98 | 255088.98 | 127.5 |
| $300,000 | 1896.20 | 682633.47 | 382633.47 | 127.5 |
| $400,000 | 2528.27 | 910177.95 | 510177.95 | 127.5 |
| $500,000 | 3160.34 | 1137722.44 | 637722.44 | 127.5 |
| $600,000 | 3792.41 | 1365266.93 | 765266.93 | 127.5 |
| $800,000 | 5056.54 | 1820355.91 | 1020355.91 | 127.5 |
| $1,000,000 | 6320.68 | 2275444.88 | 1275444.88 | 127.5 |
How each result changes as loan amount changes, holding the other inputs constant.
Practice Problems
1. 30-yr mortgage: You enter Loan Amount $250,000, Annual Interest Rate 6.5%, Loan Term (Months) 360 — what does the calculator return?
Answer: With Loan Amount $250,000, Annual Interest Rate 6.5%, Loan Term (Months) 360, the results are Monthly Payment $1,580.17, Total Payment $568,861.22, Total Interest Paid $318,861.22, Interest as % of Principal 127.5%.
2. With Loan Amount $312,500, Annual Interest Rate 6%, Loan Term (Months) 180, what are the results?
Answer: Entering Loan Amount $312,500, Annual Interest Rate 6%, Loan Term (Months) 180 gives Monthly Payment $2,637.05, Total Payment $474,669.47, Total Interest Paid $162,169.47, Interest as % of Principal 51.9%.
Frequently Asked Questions
What is the formula for loan analysis?
The formula is: P*(r*(1+r)^n)/((1+r)^n-1). Full loan analysis: monthly payment, total cost, total interest, and interest percentage.
What values do I need to calculate loan analysis?
You need loan amount, annual interest rate, loan term (months). The calculator produces monthly payment, total payment, total interest paid, interest as % of principal from those inputs.
What is the loan analysis when loan amount is $100,000?
With loan amount = $100,000, the result is monthly payment = 632.07, total payment = 227544.49, total interest paid = 127544.49, interest as % of principal = 127.5. This is worked through in full in the example on this page.
Related Topics
Use the Interactive Calculator
Skip the manual math — get instant results with our free Loan Analysis calculator.
