Excel-Skills.com

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?

Feature comparison

Feature Loan AmortizationHome Loan CalculatorLoan Account StatementLoan 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)

View the Loan Calculation & Analysis template

Frequently Asked Questions

What is the difference between the Loan Account Statement and Loan Calculation & Analysis templates?
Both produce a loan account statement with daily interest. The Loan Calculation & Analysis template adds a forecast for the remaining loan period and calculates the interest saved by extra repayments.
How is interest calculated in the loan statement templates?
Interest is calculated on daily balances and capitalised monthly, the same method most banks use. Interest rate changes and ad hoc repayments are recorded as transactions.
Are the loan amortization and home loan calculators free?
Yes. The Loan Amortization template and the Home Loan Calculator are free downloads.
What is the maximum loan period?
The Loan Amortization and Loan Calculation & Analysis templates handle loan periods of up to 30 years (360 months).