Calculation guide
For borrowers checking repayment costs and timing under their entered terms.
Rates are entered annual nominal rates converted to the stated payment period. Payments occur at period ends. Principal and interest are kept separate, and the final payment reconciles the remaining balance. Fees are included only where entered. Comparing different terms also shows remaining balances at a common horizon. These are product assumptions, not lender approval or universal statutory APR calculations.
Inputs
Periodic payment
Regular repayment amount; the final payment can be smaller than this amount.
Annual interest / discount rate
Annual interest or discount rate; the selected frequency determines its periodic rate.
Months
Duration in months. Payment frequency may divide this into different repayment periods.
Payments per year
Number of payments in one year; use 12 for monthly payments.
Worked example
| Input | Value |
|---|---|
| Periodic payment | 10,000 |
| Annual interest / discount rate | 10% |
| Months | 60 |
| Payments per year | 12 |
Formula:
P = C(1−(1+r)^(−N))/r; r=0 ⇒ P=CN
Supported principal = 470653.690237521
Period = 1.00000000000000; Opening balance = 470653.690237521; Periodic payment = 10000.0000000000; Interest = 3922.11408531267; Principal paid = 6077.88591468733; Balance = 464575.804322834
Period = 60.0000000000000; Opening balance = 9917.35537190219; Periodic payment = 10000.0000000000; Interest = 82.6446280991849; Principal paid = 9917.35537190082; Balance = 1.37151801027358e-9
| Result | Value |
|---|---|
| Supported principal | 470,653.690238 |
| Total interest | 129,346.309762 |
| Total paid | 600,000 |
Interpreting the result
Loan principal supported by the entered repayment amount, rate and duration.
Total interest earned or charged over the modeled period, separate from original principal.
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 |
|---|---|---|---|---|---|
| Periodic payment | 10,000 | 11,000 | Supported principal | 470,653.690238 | 517,719.059261 |
| Annual interest / discount rate | 10% | 11% | Supported principal | 470,653.690238 | 459,930.338334 |
| Months | 60 | 66 | Supported principal | 470,653.690238 | 506,080.576009 |
| Payments per year | 12 | 1 | Supported principal | 470,653.690238 | 37,907.867694 |
