Details Riverlea Limited is a company that specializes in the production of quality farm gates. the production process relies on the use machinery as well in order to expedite some of the tasks.The company is considering the replacement of one of its machines, which it has purchased three years ago for $850,000. This machine still has a remaining useful life of seven years, management believes that it is out-dated, and inefficient when compared to new available technologies. The existing machine has been depreciated using the straight-line method at the rate of 10% per annum. If the existing machine is disposed of now, it is expected to sell for $400,000 before taxes. However, if the company decides to keep the existing machine for its remaining useful life of seven years, and dispose of it at the end of its useful life, it is expected to be worth nothing.If the company decides to replace the existing machine, the new one is expected to cost$1,800,000 with an additional $20,000 to install it. The new machine is expected to have a useful life of seven years, and it will be depreciated over its useful life using the straight-line method. It is expected that the new machine can be sold for $200,000 at the end of its useful life but the chief financial officer has decided to ignore the residual value when setting the depreciation amount per annum.If the company decides to replace the existing machine, it is expected that operating costs would drop from $620,000 per annum down to $200,000 per annum. Moreover, there would be an initial investment of $40,000 in stock and debtors, offset by an increase of $20,000 in creditors.The company requires you to calculate an appropriate discount rate from the market information below. The Company tax rate is 30% tax per annum.The Chief Executive Officer (CEO) is hesitant about the decision because of uncertainty in relation to some of the expected cash flows. Accordingly, the CEO suggests conducting sensitivity analysis as follows: allow for a 30% probability that operating costs for the new machine would be lower than expected by 20% in each of the fifth ,sixth and seventh years; also, allow for a 10% probability that operating costs for the new machine would be higher than expected by 20% in each of the fifth, sixth and seventh years.RequiredYou are to prepare a spread sheet, to present to the CEO, showing the various cash flows based on the different scenarios; assuming that the company decides to replace the existing machine with a new one.Use Excel to prepare a full analysis, evaluating whether or not the existing machine should be replaced with a new one, taking into consideration the various scenarios.Show all formulae, adjacent to the corresponding calculated amounts in the spread sheet.Write a report of no more than 1,000 words, stating any assumptions made, and explaining the bases for your recommendation as to whether or not the company should replace its existing machine with a new one.MarkingMarks will be awarded for:• Setting up of spread sheet for the Surf Wavesi. Ease of reading spread sheetii. Use of formulae in spread sheetiii. Correct application of theoretical model• Setting up the spread sheet for deriving the discount rate• Writing of reportiv. Statement of assumptionsv. Correct recommendation based on analysesvi. Coherence of argumentsvii. Presentation, grammatical structure, referencing, etc.viii. Discussion of the appropriateness of the discount rateRefer to the corresponding marking rubric on the Black Board site for this Unit.
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.