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
Reference:
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 http://www.ehow.com/how_6778881_make-amortization-...
 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 http://www.wikihow.com/Prepare-Amortization-Schedu...
 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 https://answers.yahoo.com/question/index?qid=20080...
 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. http://wiki.answers.com/Q/What_is_an_amortization_...