Excel spreadsheet amortization schedule template
This article provides details of the Excel template spreadsheet amortization schedule that you can download now.
Microsoft Excel software under a Windows environment is required to use this template
These Excel template spreadsheet amortization schedule work on all versions of Excel since 2007.
Examples of a ready-to-use spreadsheet: Download this table in Excel (.xls) format, and complete it with your specific information.
To be able to use these models correctly, you must first activate the macros at startup.
The file to download presents three templates Excel spreadsheet amortization schedule
- Simple Excel template Loan Amortization Schedule
This loan amortization template enables users to create amortization schedules for multiple loans and to review interest, capital repayments and outstanding balances based on any user defined date. The template is suitable for any loan which is repaid on a monthly basis and accommodates variable monthly interest rates.
- Excel template Loan Amortization Schedule (Mortgage Loan Payments)
- Advanced Excel template loan amortization schedule
This workbook produces a loan amortization schedule that calculates total interest and total payments & includes the option for extra payments