How to Create an Amortization Table in Excel?


To create an amortization table in excel, use the loan APR, amount and term in Excel's 'PMT' function to calculate the monthly payment. Give the amortization table a heading and in cell a3, type 'unpaid balance.' in cell a4, type the initial loan value. For the previous example, you would type '200000.' calculate the interest on the first month's payment. Calculate the principal on the first payment. Calculate the second month's unpaid balance. Copy the methods down each column till the table is done. For more information, visit
Q&A Related to "How to Create an Amortization Table in Excel?"
1. Click on the "Office" button in Excel 2007 and select "New. NOTE: If you do not have Excel 2007, click the "Excel Amortization Schedule Template" link
1 Launch Microsoft Excel and open a new spreadsheet. Ad 2 Create labels in cells A1 down through A4 as follows: Loan Amount, Interest Rate, Months and Payments. 3 Include the information
I need to make an amortization table, but I cannot figure out how to write the formulas. The loan is for 5000, with an annual interest of 15% for 5 years. Please Help! Thanks! here
An amortization table is used when trying to calculate your loan payment,payoff time on a morgage. It can show the impact of making extra payments as well.
1 Additional Answer Answer for: excel amortization table
How to Make an Amortization Table in Excel
A Loan Amortization schedule can be made using the Amortization Template for Excel. Download and save the template and users may input loan information to create an Amortization Schedule. Excel 2007 includes the Amortization Schedule pre-loaded as a... More »
Difficulty: Moderate
About -  Privacy -  Careers -  Ask Blog -  Mobile -  Help -  Feedback  -  Sitemap  © 2014