Loan Calculator

This calculator finds the level monthly payment that amortizes a fixed loan, then builds a schedule of interest, principal, and remaining balance.

Formula and assumptions

The payment formula divides principal by an annuity discount factor based on monthly rate and payment count. Each month charges interest on the opening balance before applying payment.

Rates, timing, and compounding

Enter nominal APR used to calculate periodic interest. Fees included in a regulatory APR may require a separate cash flow method and can differ from the note rate.

Payments occur at month end. Paying earlier or making extra principal payments reduces later interest.

The nominal APR is divided across 12 monthly payment periods. Effective annual cost is higher than nominal APR when the positive rate compounds monthly.

A step by step interpretation

Begin with monthly payment as the contractual principal and interest amount under the entered fixed terms. Compare it with available monthly cash flow, but do not stop there. Total interest shows the cost of using borrowed principal over time, and total paid combines principal with that interest. Effective annual cost converts the nominal note rate into an annual compounding measure; it does not include omitted fees. Read the amortisation table at month one, the midpoint, and the final payment. Early payments often contain more interest because opening balance is high. As principal falls, monthly interest falls and more of the fixed payment reduces balance. Confirm that the last balance is zero and that the final payment may be smaller due to exact payoff. A low monthly payment can result from a long term and can coexist with high total interest, so affordability and total cost must be interpreted together.

Sensitivity analysis

Hold loan amount constant and change term first. A longer term lowers monthly payment but usually raises total interest because the balance remains outstanding longer. Then restore the term and raise or lower nominal APR to see both payment and interest sensitivity. Test a smaller principal representing a larger upfront payment. Record monthly payment, total interest, total paid, and the balance after one year for each case. Add known origination or service charges outside the calculator to compare full money cost. A useful stress case raises the rate when an offer is not yet fixed or reduces available monthly income without changing the payment. Do not compare a low rate with fees against a higher rate without fees using the displayed effective cost alone. Sensitivity should show the tradeoff between immediate payment burden and long term cost, while also revealing whether a small rate change could make the payment unaffordable.

Formula verification

Calculate monthly rate as nominal APR divided by twelve and payment count as years times twelve. The standard payment equals principal times monthly rate divided by one minus one plus monthly rate raised to the negative payment count. At zero rate, use straight division. Verify the first table row: interest equals opening principal times monthly rate, principal paid equals payment minus interest, and closing balance equals opening balance minus principal paid. Repeat the relationship for a later row. Sum row interest to reproduce total interest and sum payments to reproduce total paid. The final closing balance should be zero, with the last payment reduced if necessary. Raising principal or rate should not lower payment under the same term. Extending term should lower payment but ordinarily raise total interest. These checks verify amortisation mechanics, not fees or contractual accuracy.

Use the schedule to compare affordable payment levels with total cost, and assess how term or rate changes affect both.

What the estimate leaves out

• Origination, service, insurance, and late fees are not included. Add them when comparing the full cost of offers.
• No tax effect is included. Interest deductibility and tax treatment depend on purpose and location.
• Inflation is not included. Fixed payments may become easier in real terms over time, but that does not reduce the contractual money paid.
• The schedule is exact only for a fixed rate and payments made as assumed. Variable rates, missed payments, or fees change the outcome.

Compare scenarios carefully

Compare total paid, fees, term, and effective cost across offers. The smallest monthly payment is not necessarily the least expensive loan.

The model assumes a fixed rate, monthly payments, no fees, no extra payments, and no payment interruptions.

Realistic use cases

The calculator can screen fixed repayment offers for a vehicle, equipment, personal expense, or other single advance with monthly payments. It can compare terms for the same principal and note rate, estimate how a larger upfront payment reduces interest, or provide a schedule for a fixed rate quote. A budget review can use the monthly payment alongside existing obligations before an application. A borrower can compare the balance after several years when considering a sale or refinance, provided the real agreement follows the same amortisation method. The table can also explain why early settlement saves future interest even though past interest is already paid. A small organisation can use it for a preliminary fixed instalment comparison before incorporating fees and tax treatment. The result is an estimate based on entered contract terms, not an approval, affordability assessment, or lender disclosure.

When this model is unsuitable

Do not use this model for variable rates, irregular payment dates, interest only periods, balloon payments, daily interest contracts, payment holidays, fees financed into the balance, or products with changing instalments. It cannot calculate a regulatory APR from cash flows and charges. It is unsuitable for judging affordability from payment alone because it does not know income, essential spending, other debt, emergency reserves, or payment risk. The schedule should not replace a lender statement, payoff quotation, or contract. Do not use a nominal note rate from one offer against an all inclusive APR from another as if they were the same input. The calculator also cannot evaluate collateral risk, repossession terms, insurance requirements, early payment penalties, or whether borrowing is appropriate for the purchase. A revolving credit balance with continued purchases belongs in a different model.

A consistent comparison method

Set one common amount borrowed and proposed start date. For each offer, record note rate, payment frequency, number of payments, monthly instalment, total interest, and total paid. Add origination, documentation, service, insurance, and mandatory account charges separately, including whether each fee is paid upfront or financed. Keep term constant when isolating rate and rate constant when isolating term. Compare effective annual cost only when it is calculated on the same basis. Record early settlement rules, collateral, late charges, variable rate clauses, and payment date. Assess payment against a cautious cash flow budget and total cost against the value and useful life of the purchase. A cheaper monthly payment created by extending beyond the useful life may be a poor comparison outcome. Rank offers using full cost, payment resilience, flexibility, and contract risk rather than one headline rate.

Data and source checklist

Use the amount actually financed, not purchase price before deposits, trade value, rebates, or upfront fees. Obtain the nominal note rate used to calculate payments and confirm whether it is fixed. Record exact payment count and frequency from the proposed agreement. List every fee, insurance charge, tax, service package, and optional product, noting whether it is financed. Check the first payment date, late payment terms, early repayment rules, collateral conditions, and any final balloon. Gather current income and essential spending separately for affordability. Confirm currency and whether rate quotation is nominal APR or a broader disclosed measure. If comparing offers, request data on the same loan amount and term. Retain the quotation date because rates can expire. Reconcile the calculator payment with the lender schedule before relying on it, and investigate differences in timing, fees, or rounding.

Edge cases to inspect

At zero interest, payment equals principal divided by payment count and total interest is zero. A zero principal produces a zero payment. A very short term creates a high payment and low interest, while a long term reverses that tradeoff. At high rates, a large share of early payments is interest. The formula assumes a positive integer payment count and monthly frequency. Rounding the displayed payment down can leave a small final balance, while the internal calculation retains precision. A final payment may be lower than the regular amount. Fees financed into principal should increase the entered balance, while fees paid upfront should remain separate. If an agreement contains a balloon, the standard schedule will incorrectly assume full amortisation. Negative rates and payment holidays require contract rules outside this implementation. A term longer than the asset's useful life can create a balance after the item has little practical value.

Decision framework

Define the purchase need, maximum amount financed, and maximum payment supported by a cautious monthly budget. Compare offers at the same principal and term, then calculate a shorter and longer term to expose the payment and interest tradeoff. Add all mandatory fees and evaluate whether the financed item is likely to remain useful through the term. Preserve an emergency margin rather than setting payment equal to all apparent monthly surplus. Review collateral and late payment consequences, early settlement flexibility, and rate change clauses. If the only affordable case relies on a very long term, reconsider amount, timing, or purchase scope. Do not improve apparent affordability by omitting fees or using gross income without essential expenses. The calculation supports a choice after terms are known; it does not determine credit eligibility or whether the wider financial consequences of borrowing are acceptable.

Relevant risk limitations

Borrowing risk includes income interruption, rate changes where the contract is not fixed, late fees, collateral loss, and refinancing difficulty. A payment that fits current cash flow may become difficult after housing, care, health, or family costs change. Total interest can exceed expectations when the term is extended or fees are financed. The item purchased may depreciate faster than principal, leaving negative equity. Insurance or maintenance can raise the true monthly cost. Early repayment may carry a charge, while missed payments can affect future access to credit under local systems. Inflation may reduce the real burden of a fixed payment but does not help if income fails to keep pace. Use a cash flow stress case and read the agreement. The calculator assumes every payment is made exactly and cannot model consequences when that assumption fails.