Question
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
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started