Use this free calculator to create an Amortization Schedule in Excel. Create an amortization schedule and loan payment schedule in Excel using this free amortization calculator. Unlike some other amortization calculators, this one takes rounding into account, and still makes the end balance zero. You just enter the loan amount, the interest rate, the term of the loan, date of first payment, and the payment frequency. Investigate how making extra payments or balloon payments will affect the total interest paid and determine how soon you can pay off the loan. Apply to consumer loans, car loans, and home mortgages.
The Amortization Schedule for Excel spreadsheet creates an amortization schedule or payment schedule for a fixed-rate loan, with optional extra payments. The payment frequency can be annual, semi-annual, quarterly, bi-monthly, monthly, semi-monthly, bi-weekly, or weekly. Values are rounded to the nearest cent, or the rounding can be turned off. The last payment is adjusted to bring the balance to zero. The compound period can be set based on US or Canadian mortgages. You can select whether payments are due at the end or beginning of the payment period.
This spreadsheet-based calculator creates an amortization schedule for a fixed-rate loan, with optional extra payments. The payment frequency can be annual, semi-annual, quarterly, bi-monthly, monthly, bi-weekly, or weekly. Values are rounded to the nearest cent. The last payment is adjusted to bring the balance to zero.
No Installation, No Macros - Just a simple spreadsheet

The license of this software is Freeware, you can free download and free use this personal finance software.