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
Principal
Original deposit or outstanding loan amount before this calculation adds interest.
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.
Costs
Entered transaction or offer charges. Only the costs you enter are included.
Worked example
Loan offers
| Principal | Annual interest / discount rate | Months | Costs |
|---|---|---|---|
| 500,000 | 10% | 60 | 5,000 |
| 500,000 | 9% | 60 | 3,000 |
Formula:
K_j = Σ C_{j,t}+B_{j,H}+F_j
Scenario 1 = 642411.341338048
Scenario = 1.00000000000000; Periodic payment = 10623.5223556341; Total interest = 137411.341338048; Costs = 5000.00000000000; Paid at horizon = 637411.341338048; Remaining balance = 0.00000000000000; Lifetime total = 642411.341338048
Scenario = 2.00000000000000; Periodic payment = 10379.1776131770; Total interest = 122750.656790620; Costs = 3000.00000000000; Paid at horizon = 622750.656790619; Remaining balance = 0.00000000000000; Lifetime total = 625750.656790619
| Result | Value |
|---|---|
| Scenario 1 | 642,411.341338 |
| Scenario 2 | 625,750.656791 |
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 |
|---|---|---|---|---|---|
| Annual interest / discount rate (row 1) | 10% | 11% | Scenario 1 | 642,411.341338 | 657,272.692179 |
| Months (row 1) | 60 | 66 | Scenario 1 | 642,411.341338 | 655,378.81604 |
| Costs (row 1) | 5,000 | 5,500 | Scenario 1 | 642,411.341338 | 642,911.341338 |
