Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Benex Solutions is considering neplacing one of their old capying meschines to incresse ssales and decrease input costs. The new machine will oast the compary
Benex Solutions is considering neplacing one of their old capying meschines to incresse ssales and decrease input costs. The new machine will oast the compary R22125 000. All other cosis to get the machine ready for use will amount to R2 212500 . The new machine's ectimaled useful life is 10 years, and deprecialion will be witten off using the straight-line method. The machine's extimaied seling price at the end of its useful life amounts to R5531250 The cument machine has a useful life of 10 years, of which 5 years remain. At the end of the machine's useful life, the market value will be R1 100250 , while the current machine's total cost price amounts to R12 168750 . Benex Solutions has a potential buyer for the existing machine, and the buyer is willing to pay R4 425000 . Benes Solutions estimate sales to increase by R5 520 a30 and operational cost to decrease by R2 212500. The company has a required rate of retum of 13%, and the tax rate is 28%. REQUIRED: 1.1) Prepare a replacement anslysis in an Excel workbook based on the information supplied. Make sure to include the following: - Cash flow anslysis to il ustrate the effect of replacing the asset (machine) with a new one. - You need to apply your Excel skills and knowledge to creste the analysis - Include a calculation of - the replacement anslysis' Net Fresent Value, - Internal Rate of Retum ano - Payback Period. You need to provide your Excel workbook as an answer, and marks awarded as follow - Nomal view (15 marks) - Formula view (15 marks) 2) Once done with replacement analysis in 1.1, prepare a detsiled report discussing each periods movement and transactions, as well ss the effect the replacement will have on each period. Concluoe the report by advising whether or not Benex Solutions should invest in the new machine. (15 merks)
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