Equipment for manufacturing vegetable oil products is purchased from Alfa. Items such as oil expellers, filter presses, and a steam generator are purchased for $1.2 million.These devices are expected to be used for 11 years with no salvage value at that time. Compare Modified Accelerated Cost Recovery System (MACRS) to traditional depreciation methods by calculating yearly depreciation allowances,present worth of the depreciation allowances, and book value for each year using each of thefollowing (MARR is 11%):

a)MACRS- General Depreciation System(GDS) as is proper over its property class depreciation life

b)200 percent Declining Balance Method (DBH) with deductions in years 1 through 11

c)Double-declining-balance depreciation method (DDB) taking a full deduction in the first year, with the last deduction in year 10

d)Double-declining-balance depreciation method (DDB) switching to straight line straight line depreciation (SLN) taking a full deduction in the first year, with the last deduction in year 10

f)Draw a graph in excel for depreciation values for each method and compare the depreciation methods.

(Solve using Excel only and show your work in Excel)