This spreadsheet is used to create an amortization schedule for loans with fixed payments. It provides a detailed breakdown of each payment, including how much goes toward interest and principal, and tracks the remaining balance over time.
Loan Details: Enter loan amount, annual interest rate, loan term, and payment frequency.
Amortization Schedule: A detailed table showing each payment date, payment amount, principal portion, interest portion, and remaining balance.
Summary: Provides an overview of total interest paid, total payments, and loan payoff details.
Šaltinis: Custom Calculator
Click the following icon to open the full workbook viewer in a new tab, allowing you to easily edit and save.
Click the following icon to download the spreadsheet, allowing you to save the file on your computer along with edits.