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.
Upfront fee
One-off charge included in this scenario. It reduces savings, available money or net proceeds.
Recurring fee
Additional charge at each payment cycle; this is separate from interest.
Worked example
| Input | Value |
|---|---|
| Principal | 500,000 |
| Annual interest / discount rate | 10% |
| Months | 60 |
| Payments per year | 12 |
| Upfront fee | 5,000 |
| Recurring fee | 0 |
Formula:
Σ CF_t/(1+r)^t=0; EAC=(1+r)^m−1
Effective annual cost = 10.9487101507205%
Period = 1.00000000000000; Opening balance = 500000.000000000; Periodic payment = 10623.5223556341; Interest = 4166.66666666667; Principal paid = 6456.85568896746; Balance = 493543.144311033
Period = 60.0000000000000; Opening balance = 10535.7246502161; Periodic payment = 10623.5223556345; Interest = 87.7977054184673; Principal paid = 10535.7246502161; Balance = 0.00000000000000
| Result | Value |
|---|---|
| Effective annual cost | 10.94871% |
| Net proceeds | 495,000 |
| Total fees | 5,000 |
| Total paid | 642,411.341338 |
Interpreting the result
Annualized cost implied by net loan proceeds and payments including entered recurring fees.
Money received after the charges included in this scenario.
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 | Effective annual cost | 10.94871% | 10.90495% |
| Annual interest / discount rate | 10% | 11% | Effective annual cost | 10.94871% | 12.058309% |
| Months | 60 | 66 | Effective annual cost | 10.94871% | 10.909805% |
| Payments per year | 12 | 1 | Effective annual cost | 10.94871% | 10.394614% |
| Upfront fee | 5,000 | 5,500 | Effective annual cost | 10.94871% | 10.99693% |
| Recurring fee | 0 | 1 | Effective annual cost | 10.94871% | 10.9532% |
