Loan Amortization Table in Excel

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.

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.

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