Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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,... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup returns wrong value | Excel Worksheet Functions | |||
holiday dates | Excel Worksheet Functions | |||
How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) | |||
How do you compute partial year depreciation using DDB, SYD, SLN,V | Excel Worksheet Functions | |||
Depreciation function inconsistencies | Excel Worksheet Functions |