Calculation guide
End-of-month payments and a fixed nominal annual rate divided by twelve. No fees or early settlement charges.
Inputs
New loan principal
Example entry 250000 (in the selected currency). Minimum 0.01.
Old loan payoff quote
Example entry 180000 (in the selected currency).
Fees
Example entry 5000 (in the selected currency).
Nominal annual interest rate
Example entry 6 %. Allowed range 0 to 100.
Months remaining
Example entry 240. Allowed range 1 to 600. Use whole numbers.
Worked example
| Input | Value |
|---|---|
| New loan principal | 250,000 |
| Old loan payoff quote | 180,000 |
| Fees | 5,000 |
| Nominal annual interest rate | 6% |
| Months remaining | 240 |
| Result | Value |
|---|---|
| Net cash received at closing | 65,000 |
| New monthly payment | 1,791.077646 |
| New lifetime interest cost | 179,858.635087 |
| New interest plus closing fees | 184,858.635087 |
Calculation steps
Net cash received at closing = ((New loan principal − Old loan payoff quote) − Fees)
((250,000 − 180,000) − 5,000) = 65,000
New monthly payment = payment(New loan principal, Nominal annual interest rate, Months remaining)
payment(250,000, 6, 240) = 1,791.077646
New lifetime interest cost = ((New monthly payment × Months remaining) − New loan principal)
((1,791.077646 × 240) − 250,000) = 179,858.635087
New interest plus closing fees = (New lifetime interest cost + Fees)
(179,858.635087 + 5,000) = 184,858.635087
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| New loan principal | 250,000 | 275,000 | Net cash received at closing | 65,000 | 90,000 |
| Old loan payoff quote | 180,000 | 198,000 | Net cash received at closing | 65,000 | 47,000 |
| Fees | 5,000 | 5,500 | Net cash received at closing | 65,000 | 64,500 |
| Nominal annual interest rate | 6% | 7% | New monthly payment | 1,791.077646 | 1,938.247339 |
| Months remaining | 240 | 264 | New monthly payment | 1,791.077646 | 1,707.686124 |
