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.
Payments per year
Number of payments in one year; use 12 for monthly payments.
Interest only months
Initial months when payments cover interest without repaying the original principal.
Worked example
| Input | Value |
|---|---|
| Principal | 500,000 |
| Annual interest / discount rate | 10% |
| Months | 60 |
| Payments per year | 12 |
| Interest only months | 12 |
Formula:
C_t=Pr (t≤N_IO); C_t=PMT(P,r,N−N_IO) (t>N_IO)
Periodic payment = 12681.2917173736
Period = 1.00000000000000; Opening balance = 500000.000000000; Periodic payment = 4166.66666666667; Interest = 4166.66666666667; Principal paid = 0.00000000000000; Balance = 500000.000000000
Period = 60.0000000000000; Opening balance = 12576.4876535940; Periodic payment = 12681.2917173740; Interest = 104.804063779950; Principal paid = 12576.4876535940; Balance = 0.00000000000000
| Result | Value |
|---|---|
| Periodic payment | 12,681.291717 |
| Total interest | 158,702.002434 |
| Total paid | 658,702.002434 |
| Remaining balance | 0 |
| Interest only payment | 4,166.666667 |
Interpreting the result
Scheduled payment for the indicated loan or card scenario; interest, timing and fees follow that scenario.
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 |
|---|---|---|---|---|---|
| Principal | 500,000 | 550,000 | Periodic payment | 12,681.291717 | 13,949.420889 |
| Annual interest / discount rate | 10% | 11% | Periodic payment | 12,681.291717 | 12,922.761306 |
| Months | 60 | 66 | Periodic payment | 12,681.291717 | 11,536.203693 |
| Payments per year | 12 | 1 | Periodic payment | 12,681.291717 | 157,735.401853 |
| Interest only months | 12 | 13 | Periodic payment | 12,681.291717 | 12,900.985832 |
