Free Loan Amortization Schedule and Calculator #auto #loan #amortization

#auto loan amortization

Loan Amortization Schedule

Loan Amortization Schedule


This spreadsheet-based calculator creates an amortization schedule for a fixed-rate loan, with optional extra payments .

Start by entering the total loan amount, the annual interest rate, the number of years required to repay the loan, and how frequently the payments must be made. Then you can experiment with other payment scenarios such as making an extra payment or a balloon payment. Make sure to read the related blog article to learn how to pay off your loan earlier and save on interest.

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.

Version 1.6 lets you make multiple copies of the Schedule worksheet within the same workbook, to compare different loans and scenarios.

related blog articles

Loan Amortization Schedule – Commercial Version 1.6

The Commercial Version allows you to use this spreadsheet in your loan or financial advisory business. The spreadsheet is unlocked (i.e. not password protected) which allows you to see the calculations and customize the spreadsheet.

The header includes a place for the borrower’s name and your company info. View Screenshot. You could customize the header to create a prepared by section and include your logo if you wanted: Click Here to see an example .

The Vertex42 logo and copyright are outside the print area so that they don’t show up when you print the schedule.

60-DAY MONEY-BACK Guarantee

Try it out! If you don’t think it was worth the cost, I will refund your purchase.

Leave a Reply

Your email address will not be published. Required fields are marked *