View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jay Jay is offline
external usenet poster
 
Posts: 671
Default Automotive 5 Year Depreciation

Hey Guys:

Can one of yuz take a look at this formula related to a 5 Year Automotive
depreciation factor?

Here it is:

21,000 Initial cost =A12
2,100 Salvage value = 10% =A13
5 Lifetime in years =A14
Description (Result) are based on a purchase in July
$3,907.75 1 Yr =DB(A$12,A$13,A$14,1,7)
$5,452.43 2 Yr =DB(A$12,A$13,A$14,2,7)
$3,713.10 3 Yr =DB(A$12,A$13,A$14,3,7)
$2,528.62 4 Yr =DB(A$12,A$13,A$14,4,7)
$1,721.99 5 Yr =DB(A$12,A$13,A$14,5,7)

Test them out! Are these numbers accurate? I need yuz to verify if they are?
If they are not do yuz have suggestions or examples?

Thanks,...