The Excel DOLLARFR function converts a dollar price in a regular decimal number format to a dollar price in a particular fractional notation used for securities where pricing is given to the nearest 1/8, 1/16, 1/32, etc. The DOLLARDE function does the opposite conversion.
For example,...Read more
The DOLLARDE function is a financial function which converts values pricing entered with a particular fractional notation into an equivalent decimal number. It can be used for securities where pricing is given to the nearest 1/8, 1/16, 1/32, etc.
For example, to convert the price "3 and...Read more
The DDB function calculates the depreciation of an asset in a given period using the double-declining balance method. The double-declining balance method computes depreciation at an accelerated rate – depreciation is highest in the first period and decreases in each successive period. To ...Read more
The Excel DB function returns the depreciation of an asset for a specified period using the fixed-declining balance method. The calculated depreciation is based on initial asset cost, salvage value, the number of periods over which the asset is depreciated and, optionally, the number of months...Read more
The Excel IMPOWER function returns a complex number raised to a given power. The complex number is input as text, and must be in the form x + yi or x + yj.
For example:
=IMPOWER("1+2i",2) // returns "-3+4i"
In the example shown,...Read more
The FIXED function converts a number to text, rounding to a given number of decimals. Like the Number format available on the home tab of the ribbon, the FIXED function will round the number as needed using the given number of decimal places. The main difference between applying a number format...Read more
The FORECAST.ETS function predicts a value based on existing values that follow a seasonal trend. FORECAST.ETS can be used to predict numeric values like sales, inventory, expenses, etc. with a seasonal pattern.
To calculate predicted values, FORECAST.ETS uses something called triple...Read more
The RRI function returns an equivalent interest rate for the growth of an investment. For example, to use RRI to calculate equivalent annual compound interest for a 1000 investment worth 1200 after five years you can use a formula like this:
=RRI(5,1000,1200...Read moreThe Excel SYD function returns the "sum-of-years" depreciation for an asset in a given period. The calculated depreciation is based on initial asset cost, salvage value, and the number of periods over which the asset is depreciated.
For example, for an asset with an initial cost of $10,...Read more
The Excel SLN function returns the depreciation of an asset for one period, calculated with a straight-line method. The calculated depreciation is based on initial asset cost, salvage value, and the number of periods over which the asset is depreciated.
For example, for an asset with an...Read more