how to figure out amortization schedule in excel

Here's a quick look at what the first few rows of your amortization schedule would look like: You're taking out $100,000 at a 7% interest rate and will pay it back monthly over the course of 10 years. Want to see one in action? Imagine that you're taking out a business loan for new product development. What does an amortization schedule look like?Īn amortization schedule is actually a pretty simple table with several columns and then a row for every single loan payment you need to make (which is usually monthly with most loans). For that reason, you might also hear it referred to as a loan amortization schedule. The amortization schedule displays your beginning balance, principal, interest, payment amount, and ending balance over the life of the loan. Put simply, it shows your loan repayment schedule. What is an amortization schedule?Īn amortization schedule is a table used to see and track payments on a loan.

Here are the details on what these schedules are, why they matter, and how you can create your own. We have your simple and straightforward guide to amortization schedules. It's worth understanding (at least at a high level) what it is and how it works so that you can keep a better eye on your money.Īlready cringing? Don't worry. Well, take a few blinks - because an amortization schedule is something you're highly likely to encounter at some point in your life. Unless you're a whiz with financial mathematics, 'amortization schedule' is probably one of those terms that immediately makes your eyes glaze over.

How to figure out amortization schedule in excel