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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

The Pantone Colour of the Year 2017 is Green

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…