Calculation guide
End-of-month payments and a fixed nominal annual rate divided by twelve. No fees or early settlement charges.
Inputs
Principal outstanding
Example entry 200000 (in the selected currency).
Lump-sum principal payment
Example entry 30000 (in the selected currency).
Nominal annual interest rate
Example entry 5 %. Allowed range 0 to 100.
Months remaining
Example entry 240. Allowed range 1 to 600. Use whole numbers.
Worked example
| Input | Value |
|---|---|
| Principal outstanding | 200,000 |
| Lump-sum principal payment | 30,000 |
| Nominal annual interest rate | 5% |
| Months remaining | 240 |
| Result | Value |
|---|---|
| New monthly payment | 1,121.924757 |
| Previous monthly payment | 1,319.911478 |
| Monthly payment reduction | 197.986722 |
Calculation steps
New monthly payment = payment((Principal outstanding − Lump-sum principal payment), Nominal annual interest rate, Months remaining)
payment((200,000 − 30,000), 5, 240) = 1,121.924757
Previous monthly payment = payment(Principal outstanding, Nominal annual interest rate, Months remaining)
payment(200,000, 5, 240) = 1,319.911478
Monthly payment reduction = (Previous monthly payment − New monthly payment)
(1,319.911478 − 1,121.924757) = 197.986722
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 |
|---|---|---|---|---|---|
| Principal outstanding | 200,000 | 220,000 | New monthly payment | 1,121.924757 | 1,253.915905 |
| Lump-sum principal payment | 30,000 | 33,000 | New monthly payment | 1,121.924757 | 1,102.126084 |
| Nominal annual interest rate | 5% | 6% | New monthly payment | 1,121.924757 | 1,217.932799 |
| Months remaining | 240 | 264 | New monthly payment | 1,121.924757 | 1,062.977283 |
