CalcUnit Logo

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:

VariableTypeExample value
Loan AmountInput (you provide)$250,000
Annual Interest RateInput (you provide)6.5 %
Loan Term (Months)Input (you provide)360
Monthly PaymentResult (calculated)—
Total PaymentResult (calculated)—
Total Interest PaidResult (calculated)—
Interest as % of PrincipalResult (calculated)—

Step-by-Step Method

  1. 1Write down the values you know: Loan Amount, Annual Interest Rate, Loan Term (Months).
  2. 2Substitute your known values into the formula: P*(r*(1+r)^n)/((1+r)^n-1).
  3. 3Work through the arithmetic in the standard order of operations — parentheses first, then exponents, then multiplication and division, then addition and subtraction.
  4. 4Check that your result carries the correct unit and falls in a reasonable range for the problem.
  5. 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 AmountMonthly PaymentTotal PaymentTotal Interest PaidInterest as % of Principal
$1,0006.322275.441275.44127.5
$100,000632.07227544.49127544.49127.5
$200,0001264.14455088.98255088.98127.5
$300,0001896.20682633.47382633.47127.5
$400,0002528.27910177.95510177.95127.5
$500,0003160.341137722.44637722.44127.5
$600,0003792.411365266.93765266.93127.5
$800,0005056.541820355.911020355.91127.5
$1,000,0006320.682275444.881275444.88127.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

loan analysisamortizationtotal interestmonthly payment

Use the Interactive Calculator

Skip the manual math — get instant results with our free Loan Analysis calculator.

Open Calculator

Related Calculators