Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can some body help me with this question, is an excel question One of Contact Manufacturing Ltd's main competitor, Torres Coffee Roaster is considering replacing
can some body help me with this question, is an excel question
One of Contact Manufacturing Ltd's main competitor, Torres Coffee Roaster is considering replacing one of its existing machine. Torres bought t basis (prime cost method) over a 15-year life. The machine could be sold today for $30,000. The new, highly efficient machine costs $95,000. The new machine's depreciable life is 10 years and it can be sold for $14,000 at the end of ye (prime cost) method. Last year, Torres's current coffee roasting machine accounted for annual sale revenues of $50,000 and has annual costs of $25,000. The new m also increase operating costs by $3,000 per year. The corporate tax rate is 40%. The additional savings and costs are forecasted to increase b Torres has an equity beta of 0.5. Its capital structure consists of equal amounts of equity and debt. The risk free rate is 6%. The debt has a pr Using the inputs suggested in the proposed investment, design an Excel financial model that can help to evaluate the replacement project. The and forecast the net cash flows. 5 marks will be allocated for the presentation and clarity of your model (e.g., if there are clear headings, clea flexibility, generate warning messages for wrong user inputs, etc.). Answer the following questions using your Excel financial model: a. (5 marks) What is Torres Coffee Roaster's weighted average cost of capital (WACC)? b. (10 marks) Estimate the free cash flows of the replacement project. Prepare the cash flows of the old and new machine in the same financial model. c. (10 marks) What is the net present value (NPV) and internal rate of return (IRR) of the replacement investment? Should Torres Coffee Roaster replace the o Do both NPV and IRR lead to the same decision? d. (10 marks) Draw a line graph to explain the sensitivity of the NPV to changes in WACC? The graph should have a chart title, as well as x- and y-axis labels. ht the machine 5 years ago for $90,000. It is being depreciated on a straight-line year 10. The new machine will be depreciated to zero over 10 years via straight line w machine will increase the sale revenues to $65,000 per year. The new machine will e by inflation rate of 3% each year. pre-tax yield of 10% and the expected rate of return on the market index is 18%. The model should enable Torres Coffee Roaster to consider the replacement project ear arrangement for input cells, appropriate use of colors, have some degree of he old machine with the new, highly efficient machine based on NPV? How about IRR? ls
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