Excel Amortization

This page contains loan excel amortization spreadsheets for various purposes.

Excel Loan Amortization

This excel loan amortization spreadsheet template will create a loan payment schedule. This excel loan amortization template takes rounding into account, and still makes the end balance zero. Also investigate how making extra payments (called balloon payments) will affect when you can pay off the loan and the total interest paid. Apply to consumer loans, car loans, and home mortgages. This excel amortization spreadsheet creates a amortization schedule for a fixed-rate loan, with optional extra payments. The payment frequency can be annual, semi-annual, quarterly, bi-monthly, or monthly. Values are rounded to the nearest cent. Also, this excel spreadsheet does not require macros.
Download Now

Baloon Payment Calculater Spreadsheet

A balloon loan is one in which you plan to pay off your loan in a big chunk after a number of small monthly payments. This Excel Amortization spreadsheet calculates monthly payments, total interest, and the amount of the baloon payment for a simple loan. This includes an amortization and payment schedule suitable for auto and mortgage loans.
Download Now

Simple Interest Excel Amortization Spreadsheet

This free Excel template creates an amortization table for a simple interest loan. You just enter the loan amount, the interest rate, and period. The excel amortization calculator can be used to get initial estimates for car loans and home mortgages. This Excel amortization spreadsheet calculates the required payments and total interest paid for a simple fixed-rate loan. Also, create a basic amortization table and a chart that compares the cumulative interest vs. principal.
Download Now

You can also use some of the microsoft's amoritzation templates.