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

Excel has a number of financial functions revolving around the periodic interest rate, which business owners may occasionally need to determine on certain investments.

The PMT function in Excel is a financial function used to calculates the payment of a loan based on payments and interest rates. The formula for the PMT function is PMT (rate,nper,pv, [fv], [type]).