How to Create an Amortization Schedule in Excel to Pay Off a Mortgage Loan

In this video I show you an easy way to create an amortization schedule for a mortgage loan on a real estate property. An amortization schedule is extremely helpful to determine how much of your mortgage does towards your prinical amount and interest. Investors commonly use an amortization schedule as a tool to help determine their Return on Investment (ROI) when they sell their property.

An amortization schedule can also be used to help you plan how long it will take to pay off your loan. I used microsoft excel 2016 to create my amortization. Excel will help you input formulas that make an amortization table easier to create.

If you have an questions or comments please feel free to leave a comment below and subscribe for future excel tutorials