Excel Loan Calculator

This excel loan calculator spreadsheet template will create a loan payment schedule. This excel loan calculator 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 loan calculator 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 Excel Loan Calculator

Loan Calculators