Excel FORECAST.ETS Function

Excel FORECAST.ETS Function

The FORECAST.ETS function is a Statistical function that predicts a future value by using existing values with a seasonal pattern. The function is using the AAA version (additive error, additive trend, and additive seasonality) of the Exponential Smoothing (ETS)...

Excel FORECAST.LINEAR Function

Excel FORECAST.LINEAR Function

The FORECAST.LINEAR function is a Statistical function that predicts a future value by using existing values along a linear trend (linear regression). You can use a forecasting function to predict future sales, inventory requirements, or consumer trends. In this...

Excel FORECAST Function

Excel FORECAST Function

FORECAST The FORECAST function is a Statistical function that predicts a future value by using existing values along with a linear trend (linear regression). You can use the forecasting function to predict future sales, inventory requirements, or consumer trends. In...

Excel AMORDEGRC Function

Excel AMORDEGRC Function

The AMORDEGRC function is a Finance function used in French accounting system that returns the depreciation for each accounting period, on a prorated basis. The prorated depreciation is considered when an asset is purchased in the middle of the accounting period. In...

Excel VDB Function

Excel VDB Function

The VDB function is a Finance function that calculates the depreciation of an asset on the double-declining balance or another basis for a specified period. The VDB stands for variable declining balance and the function switches to straight-line depreciation when...

Excel DDB Function

Excel DDB Function

The DDB function is a Finance function that calculates the depreciation of an asset on the double-declining balance or another basis for a specified period. In this guide, we’re going to show you how to use the DDB function and go over some tips and error handling...

Excel DB Function

Excel DB Function

DB The DB function is a Finance function that calculates the depreciation of an asset on the fixed-declining balance basis for a specified period. In this guide, we’re going to show you how to use the DB function and go over some tips and error handling methods....

Excel SYD Function

Excel SYD Function

The SYD function is a Finance function that calculates the depreciation of an asset on the sum-of-years' digits basis for a specified period. In this guide, we’re going to show you how to use the SYD function and go over some tips and error handling methods. Supported...

Excel SLN Function

Excel SLN Function

The SLN function is a Finance function that calculates the depreciation of an asset on a straight-line basis for one period. In this guide, we’re going to show you how to use the SLN function and go over some tips and error handling methods. Supported versions All...