A loan amortization schedule can be very helpful when calculating the cost of a home loan. You can follow these steps to create an Excel 2010 amortization schedule.
Start Excel 2010.
Choose File, New
Enter “Amortization” in the search box and then press enter.
A list of templates will be displayed.
Select the “Loan amortization schedule” template and click Download.
The template will be soon displayed in Excel.
Fill in the template with the details of the proposed loan.
For example, in the screen shot below, I entered in the values for a 30 year, $200,000 loan with a 4% annual interest rate starting in December of 2013.
Excel quickly calculates the numbers and displays the updated amortization schedule.
To learn more tips and tricks like these, please join our online newsletter community at www.TheTechMentors.com. Upon subscribing, you will receive a free copy of our Excel Functions Presentation.