Excel can quickly calculate amortization. Microsoft Excel is a widely used spreadsheet program that can use formulas to compute and display values.

Note that because this is a payment, Excel will display this number in parenthesis and red font. To avoid that, insert a "-" sign in front of the PMT formula, like below.

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

How to Calculate Annuities Using Excel. Annuities represent a loan or investment which offer monthly fixed payments until the account is depleted or paid off. Whether you are investing or ...

Last month, we used Goal Seek to determine the most reasonable mortgage payment within a specific budget. This month, we continue with the mortgage example using Scenario Manager. We’ll generate ...