Question

JSU has decided to improve the Engineering Department. The improvement base costs are attached to your J-Number with the life and salvage values indicated. The president asked you, as the design engineer, to analyze and compare the difference between STRAIGHTLINE, MACRS and DDB in a tabular form using Excel spreadsheet. You are to complete the analysis using excel functions, print out the results and bring it to class (to be submitted) to complete problems 2- 4 of Part "B" of the exam. (50pts)

base value= 358,978

salvage value= 25,128

life,yr= 5

Answer 1

	DDB	MACRS	Straight Line	MACRS %
1	$143,591.20	$71,795.60	$66,770.00	20.00%
2	$86,154.72	$114,872.96	$66,770.00	32.00%
3	$51,692.83	$68,923.78	$66,770.00	19.20%
4	$31,015.70	$41,354.27	$66,770.00	11.52%
5	$18,609.42	$41,354.27	$66,770.00	11.52%