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.

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 ...