AccountdesqFinancial intelligence
Finance Calculator

Loan Calculator

This loan calculator uses the standard amortisation formula to compute your exact monthly payment and generates a full schedule showing how each payment splits between principal and interest. Use it for business loans, mortgages, equipment finance, vehicle finance, or personal loans. Understanding the amortisation schedule helps you plan prepayments to save on interest.

Read the full guide
No data stored - 100% browser-based Free forever - no account required PDF & Excel export

How it works

Enter the loan principal, annual interest rate, and loan term in years. The calculator instantly shows your monthly payment, total interest paid over the life of the loan, total repayment amount, and a month-by-month amortisation schedule for the first 12 months.

Loan Details

188.71
Monthly Payment
1322.74
Total Interest
11322.74
Total Repayment

Amortization Schedule (First 12 months)

MonthPaymentPrincipalInterestBalance
1188.71147.0541.679852.95
2188.71147.6641.059705.30
3188.71148.2740.449557.02
4188.71148.8939.829408.13
5188.71149.5139.209258.62
6188.71150.1338.589108.48
7188.71150.7637.958957.72
8188.71151.3937.328806.34
9188.71152.0236.698654.32
10188.71152.6536.068501.66
11188.71153.2935.428348.37
12188.71153.9334.788194.45

Common Mistakes to Avoid

  • Comparing loans only by monthly payment - always compare total interest cost
  • Not accounting for fees (origination fees, early repayment penalties) in the true cost
  • Borrowing for the maximum term to minimise payments - this maximises total interest paid

Best Practices

  • Make even small extra principal payments - they have an outsized impact on total interest
  • Compare APR (not just interest rate) when shopping for loans
  • Fix your rate when rates are low; choose variable when rates are high and likely to fall

Why use this tool?

Most people focus only on the monthly payment - but the total interest paid can be 30–60% of the loan principal. Seeing the full amortisation helps you make better borrowing decisions and plan early repayments.

Frequently Asked Questions

Monthly payment = P × [r(1+r)^n] / [(1+r)^n-1], where P = principal, r = monthly interest rate (annual rate ÷ 12), n = number of payments.

Related Tools

View all tools

Disclaimer: Accountdesq provides this Loan Calculator for informational and convenience purposes only. Output is not a substitute for professional accounting, legal, or tax advice. No data entered is transmitted to or stored on our servers - all calculations happen locally in your browser. Accountdesq accepts no liability for errors in generated documents. Always consult a qualified accountant or tax professional for compliance matters.