The table shows all the financial functions that are added to the Insert Function dialog box when the Analysis ToolPak is activated.

As you can see from this table, the Analysis ToolPak financial functions are varied and quite sophisticated.

AMORDEGRC and AMORLINC return the depreciation for each accounting period.

AMORDEGRC works like AMORLINC except that it applies a depreciation coefficient in the calculation that depends upon the life of the assets.

The type argument is 0 when the payment is made at the end of the period and 1 when its made at the beginning of the period.

He began teaching business users about computers back in the 1980s, and has been a dedicated educator ever since.

Exponential smoothing is used to smooth out irregularities (peaks and valleys) to easily recognize trends.

Excel cannot calculate the smoothed value for the first data point because there is no previous data point.

The smoothed value for the second data point equals the previous data point.

The larger alpha (smaller the damping factor), the closer the smoothed values are to the actual data points.

How To Find Analysis Toolpak In Excel For Mac 2016