LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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,...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup returns wrong value motorjobs Excel Worksheet Functions 5 June 21st 06 11:49 PM
holiday dates bucci Excel Worksheet Functions 4 June 15th 06 09:35 AM
How do I get Excel to automatically calculate salaries actually received in financial year? Kei Excel Discussion (Misc queries) 0 March 3rd 06 10:26 AM
How do you compute partial year depreciation using DDB, SYD, SLN,V Prof D Excel Worksheet Functions 1 February 13th 06 12:30 PM
Depreciation function inconsistencies Philip J Smith Excel Worksheet Functions 0 February 13th 06 11:42 AM


All times are GMT +1. The time now is 08:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"