Which Excel loan template do you need?
Our loan templates range from free calculators for planning a loan to statement templates that track an existing loan the way a bank does.
If you are planning a loan, start with a calculator. If you already have a loan and want to check the bank's figures or track extra repayments, use a statement template.
Quick answer: which template should you choose?
- Loan Amortization Template: choose it if you only need a monthly repayment schedule for a loan.
- Home Loan Calculator Template: choose it if you are buying a home and want to work out repayments, affordability and the effect of rate changes or higher instalments.
- Loan Account Statement Template: choose it if you need a bank-style statement for an existing loan with daily interest, without a forecast.
- Loan Calculation & Analysis Template: choose it if you want the loan statement plus a forecast of the remaining balance and the interest saved by extra repayments.
Feature comparison
| Feature | Loan Amortization | Home Loan Calculator | Loan Account Statement | Loan Calculation & Analysis |
|---|---|---|---|---|
| Free download | ✓Yes | ✓Yes | –No | –No |
| Monthly amortization table | ✓Yes | Monthly and annual | –No | ✓Yes |
| Affordability and interest rate sensitivity | –No | ✓Yes | –No | –No |
| Record actual repayments and interest rate changes | –No | –No | ✓Yes | ✓Yes |
| Interest on daily balances, capitalised monthly | –No | –No | ✓Yes | ✓Yes |
| Interest saved by extra repayments | –No | ✓Yes | –No | ✓Yes |
The templates in detail
Loan Amortization Template
Create a monthly loan amortization table for up to 30 years.
- Best for:
- Anyone who needs a quick monthly repayment schedule for a loan of up to 30 years
- Not suitable for:
- Loans with daily interest, interest rate changes or extra repayments (use Loan Calculation & Analysis)
View the Loan Amortization template
Home Loan Calculator Template
Home loan calculator with monthly & annual amortization.
- Best for:
- Home buyers working out repayments, affordability and the effect of a higher instalment or rate change
- Not suitable for:
- Tracking an existing home loan with daily interest and actual transactions (use Loan Calculation & Analysis)
View the Home Loan Calculator template
Loan Account Statement Template
Compile loan account statements for any type of loan.
- Best for:
- Lenders and borrowers who need a bank-style statement for a loan with daily interest
- Not suitable for:
- Forecasting the remaining loan balance or interest saved by extra repayments (use Loan Calculation & Analysis)
View the Loan Account Statement template
Loan Calculation & Analysis Template
Loan account statements with future loan balance forecast.
- Best for:
- Home loan and other borrowers who want a bank-style statement and a forecast of interest saved by extra repayments
- Not suitable for:
- Loans longer than 30 years, or when only a statement is needed (use the simpler Loan Account Statement)