Free Loan Amortization Spreadsheet

A loan amortization is a common discounted cash flow (DCF) application that consumers encounter in their everyday lives. Amortization schedules apply to all types of finance loans. The amortization of a finance loan usually involves a fixed number of payments (e.g., 60 monthly payments). An amortization schedule shows two components:

Interest: the amount of interest only on the finance loan balance; and,

Principal Repayment: the actual reduction in the finance loan balance.

The Loan Amortization Spreadsheet provides a breakdown of payments for any finance loan. The amortization spreadsheet shows the amount of interest and principal paid for each period. The Finance Loan Amortization Table requires three inputs: initial finance loan balance, amortization period, and interest rate (on a semiannual compound basis).

finance loan amortization spreadsheet

Download Spreadsheet (MS Excel)

Not running Microsoft Excel? No problem! Your browser can view this spreadsheet directly using this URL for Non-Excel Users (EditGrid file).

Have Fun!

- Mark ( )

DCF-models.com respects your right to personal privacy. For details on how personal information is collected and used, please visit our Privacy Policy.