Question
PLEASE DEAR SIR/MA'AM HELP HOW DO I SOLVE THIS IN M.S EXCEL ZebraTechnologyLtd.isamanufacturingfirmspecializingintheproductionofsophisticatedproduct components.Thecompanyisconsideringthepurchaseofanewpiece ofequipment. TheequipmentwouldcostCAD 141,000andhaveasalvagevalueofCAD 18,000attheendofitssix-yearlife.ThenewequipmentwouldreplaceexistingdevicesthatarefullydepreciatedbuthaveacurrentmarketvalueofCAD 10,000.Iftheoldequipmentiskeptforanother sixyears,it would have asalvage value ofzero.
PLEASE DEAR SIR/MA'AM HELP HOW DO I SOLVE THIS IN M.S EXCEL
ZebraTechnologyLtd.isamanufacturingfirmspecializingintheproductionofsophisticatedproduct components.Thecompanyisconsideringthepurchaseofanewpiece ofequipment.
TheequipmentwouldcostCAD 141,000andhaveasalvagevalueofCAD 18,000attheendofitssix-yearlife.ThenewequipmentwouldreplaceexistingdevicesthatarefullydepreciatedbuthaveacurrentmarketvalueofCAD 10,000.Iftheoldequipmentiskeptforanother sixyears,it would have asalvage value ofzero.
ZebraTechnologyiscurrentlyselling50,000unitsayear.Thenewequipmentshouldallowittosell 15,000additionalunitsper yearoverthe next sixyears.
EachunitsellsforCAD 12.00andthisisnotexpectedtochangeoverthenextsixyears.VariablecostsofproductionareCAD 7.50perunit,butthisshouldfalltoCAD 5.75perunitwith the more efficient machine.FixedcostsareexpectedtofallbyCAD 10,000peryear. Thenewequipment will alsoreducetherequiredinvestment inNWCbyCAD 30,000.
ZebraTechnologyhasanRRR of11.5% after tax.Thesetwopiecesofequipmentareboth in a CCA poolwitha rate of20%.The marginal taxrate is31%. Theinflationrateisnegligible.
REQUIRED:
- Should Zebra Technology buy this new equipment?
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