Excel formula for calculating depreciation

  old fogey 10:44 22 Jun 05
Locked

Can anyone help with a problem Ive been given and that is I want to calculate the depreciation of equipment (office machines) and I dont know the formula to use in excel.

  Rand Al Thor 11:12 22 Jun 05

Type Depreciation into the help. There are a number of functions there.

  old fogey 11:20 22 Jun 05

Rand Al Thor
Thanks I have looked in the excel help but could not find the formula

  Durko 11:43 22 Jun 05

Have a look at this site might be of some help.

click here

D

  old fogey 11:55 22 Jun 05

Durko
Thanks thats just what I was looking for

  VoG II 11:58 22 Jun 05

=DB(PurchasePrice,SalvageValue,Life,PeriodToCalculate,FirstYearMonth)
The FirstYearMonth is the month in which the item was purchased during the first financial year. This is an optional value, if it not used the function will assume 12 as the value.

This thread is now locked and can not be replied to.

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch