Making tax accounting depreciation calculations for return preparation or tax planning purposes?? Microsoft Excel can help. Excel’s VBD, or variable rate depreciation, function lets you easily calculate variable declining balance s depreciation amounts, including those based on the MACRS depreciation convention. The VDB function calculates declining balance depreciation for an asset given the cost, its salvage value, estimated economic life, the starting accounting period and the ending accounting period for which depreciation is being calculated, the factor at which the balancem declines, and, optionally, a switch-to-straight-line switch which is set to either TRUE or FALSE. If you set this switch to TRUE, Excel doesn’t switch to straight-line at the point when straight-line depreciation exceeds declining balance depreciation. If you set this value to FALSE, Excel does switch to straight-line. If you don’t set the optional switch-to-straightline switch to TRUE, Excel sets this value to FALSE.
Need to work with binomial probability distributions? Don’t forget that Microsoft Excel supplies powerful tools for performing just this sort of statistical analysis. A binomial distribution describes the outcome of a multi-step experiment, consisting of n identical trials, where each trial ends in either a success or a failure and the probability of a success p does not change from trial to trial. This useful statistical analysis can be performed relatively easily using Microsoft Excel using the Excel BINOMDIST, CRITBINOM and NEGBINOMDIST functions.
Need to make Beta Probability calculations? Microsoft Excel supplies two useful statistical functions for making just these sorts of calculations, BETADIST and BETAINV. Microsoft Excel supplies two useful statistical functions for making beta probability calculations, BETADIST and BETAINV. Perhaps surprisingly, neither function is difficult to use as long as understand the inputs that supply data to the function. Understanding the beta probability density function, BETADIST The BETADIST function returns the cumulative beta probability density function. Statisticians often use the cumulative beta probability density function to study variation across samples, such as when comparing two groups of people performing the same task to see whether they have the same success rate.
Need to count the cells in a worksheet range that contain data averages? Microsoft Excel supplies several easy-to-use functions for just such a purpose says bestselling computer book If you select a range of cells, you can have Excel find how many cells are in that range using the count functions. This sounds a little goofy, but a handful of easy-to-understand examples show how this works–and suggest when you might want to use the “cell counting” functions. COUNT
Need to count the cells in a worksheet range that contain data averages? Microsoft Excel supplies several easy-to-use functions for just such a purpose says bestselling computer book If you select a range of cells, you can have Excel find how many cells are in that range using the count functions. This sounds a little goofy, but a handful of easy-to-understand examples show how this works–and suggest when you might want to use the “cell counting” functions. COUNT |
|
author Stephen L. Nelson
