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

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

Launch Excel. Create a loan table with Loan Amount, Interest Rate, Term in months, and Monthly Payment. Use the PMT function to calculate the Monthly Payment Now, we will use Goal Seek.

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