forecasting amortization values for 1 year(monthly)

  • Thread starter Thread starter moris
  • Start date Start date
M

moris

i have a system of fixed assets that can forecast your depreciatio
expense amount for several years.
this is good, but it doesn't give a depreciation amount by month.
anybody has an excel function that can solve this problem, in othe
words give a monthly breakdown of that forecasted amount.
Example:

Forecast (1year) = 100

i need this 100 dollars to be allocated over the year..

Jan Feb Mar Apr
18 16 14 1
 
Hi Moris!

See Help for the particular depreciation function used:

=DB(cost,salvage,life,period,month)
Cost: is the initial cost of the asset.
Salvage is the value at the end of the depreciation (sometimes
called the salvage value of the asset).
Life is the number of periods over which the asset is being
depreciated (sometimes called the useful life of the asset).
Period is the period for which you want to calculate the
depreciation. Period must use the same units as life
Month is the number of months in the first year. If month is
omitted, it is assumed to be 12.

There's no essential reason why the Life should be measured in years
or that the period should be a year or number of years. The Month
argument though is only relevant if Life and Period arte measured in
years.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top