Calculation guide
End-of-month payments and a fixed nominal annual rate divided by twelve. No fees or early settlement charges.
Principal = price−down; regular instalment amortizes over full term; balloon = outstanding principal immediately after the last regular instalment.
Inputs
Purchase price
Example entry 200000 (in the selected currency). Minimum 0.01.
Cash down payment
Example entry 40000 (in the selected currency).
Nominal annual interest rate
Example entry 5 %. Allowed range 0 to 100.
Original term in months
Example entry 240. Allowed range 1 to 600. Use whole numbers.
Regular payments before balloon
Example entry 60. Allowed range 1 to 600. Use whole numbers.
Worked example
| Input | Value |
|---|---|
| Purchase price | 200,000 |
| Cash down payment | 40,000 |
| Nominal annual interest rate | 5% |
| Original term in months | 240 |
| Regular payments before balloon | 60 |
| Result | Value |
|---|---|
| Balloon due after regular instalment | 133,527.781085 |
| Regular monthly instalment | 1,055.929183 |
| Seller gross cash receipts | 236,883.532049 |
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 |
|---|---|---|---|---|---|
| Purchase price | 200,000 | 220,000 | Balloon due after regular instalment | 133,527.781085 | 150,218.75372 |
| Cash down payment | 40,000 | 44,000 | Balloon due after regular instalment | 133,527.781085 | 130,189.586558 |
| Nominal annual interest rate | 5% | 6% | Balloon due after regular instalment | 133,527.781085 | 135,839.357515 |
| Original term in months | 240 | 264 | Balloon due after regular instalment | 133,527.781085 | 137,300.75685 |
| Regular payments before balloon | 60 | 66 | Balloon due after regular instalment | 133,527.781085 | 130,499.003799 |
