Using Excel’s built-in amortization table
Excel function tutorials, Housing
Thanks to our nascent house hunt, I’ve been trying to back into figures on mortgages and monthly payments. Luckily, Excel has a handy built-in amortization template just perfectly suited for this purpose.
Here’s how you get to the template in Excel 2007 (which according to my recent poll is the version most readers use, if only by a hair).
In Excel 2007, go to the “menu” button (the goofy-looking windows symbol in a circle) in the upper left-hand corner. Click on “New”. This will bring up the following window: