Loan Amortization Table in Excel

how to do amortization schedule in excel

Download an amortization spreadsheet or calculator for Microsoft® Excel®

Believe it or not, a loan amortization spreadsheet was the very first Excel template I downloaded from the internet. Since then, I've discovered the great boost in productivity that can come from not having to start from scratch, and hopefully this page will help you get a head start. This page lists the best places to find an Excel amortization spreadsheet for creating your own amortization table or schedule .

Advertisement

Loan Amortization Table - Templates

Simple Interest Loan Amortization

Advertisement

Creating an Amortization Table

My article "Amortization Calculation " explains the basics of how loan amortization works and how an amortization table or "schedule" is created. You can delve deep into the formulas used in my Loan Amortization Schedule template listed above, but you may get lost, because that template has a lot of features and the formulas can be complicated.

To get started. I would recommend downloading the Simple Amortization Chart template.

If you are wanting to create your own amortization table, or even if you just want to understand how amortization works, I'd recommend you also read about Negative Amortization. In that article, I explain what happens when a payment is missed or the payment is not enough to cover the interest due.

More Free Loan Amortization Spreadsheets

Listed below are other spreadsheets by Vertex42.com that use an amortization

table to both display results and perform calculations.

  • Balloon Payment Loan Calculator - This template is unique in that the amortization table ends after a specified number of payments. The final payment, or balloon payment, is the amount required to pay off in full.
  • Line of Credit - For a revolving line of credit (such as a credit card or HELOC), interest normally accrues daily, so this spreadsheet is like the "simple interest loan" calculator except that it allows you to include additional draws besides the initial loan amount.
  • Extra Payment Mortgage Calculator - Compares making extra payments to investing.
  • Adjustable Rate Mortgage (ARM) Calculator - I created this one prior to the home mortgage calculator listed above, but this one may be easier to dig into if you are interested in the formulas.
  • Home Equity Loan Amortization Calculator
  • Auto Loan Amortization Calculator
  • Amortization Calculator (web-based)

Loan Amortization Resources and References

You can also find a free excel loan amortization spreadsheet in Microsoft's very own directory of free Office templates. They offer templates in Word, PowerPoint, Publisher, and of course Excel. Browse for templates at Microsoft .

Microsoft has at least 5 different templates related to Excel loan amortization calculations. Some of them use some pretty fancy Excel formulas for creating the amortization table and making it possible to manipulate the schedule by including extra payments.

Source: www.vertex42.com

Category: Bank

Similar articles: