Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please do it in excel Zenix Corporation has a machine that either should be repaired or should be replaced soon. You have recently been hired

image text in transcribed

Please do it in excel

Zenix Corporation has a machine that either should be repaired or should be replaced soon. You have recently been hired by Zenix and one of your assignments is to help decide whether replacing the machine, or repairing it is in the best interest of your company. Investment required for repairing the machine is only $1,500,000 and cost to replace the machine is $9,000,000. Repairing the machine will cut down on the number of returns from customers and increase cash flows, while replacing the machine may increase the number of units sold. Zenix has evaluated and calculated additional cash flows that will be generated under the two scenarios over the next five years as follows: Year Cash flow (if repaired) 557,000 607,000 478.000 1513.000 387,000 Cash Flow (if replaced) 5,613,000 3,485.000 2.878,100 1.697,800 1.157.000 Zenix does not accept projects that will pay back in more than 3 years, or any projects that will not maximize shareholder wealth. So, you will need to use all capital budgeting techniques you've learnt in your Finance class to ensure that the right option is chosen. Cost of capital for the project (repair or replacement) could be anywhere from 10% to 14%, so you will conduct your analyses at various weighted average cost of capital (WACC) or Required rate of return points including at least five at 9.0%, 11%, 13%, and 15% for both scenarios, and also draw an NPV profile for both situation using your calculations. Use your knowledge of capital budgeting and time value of money to decide which of the options is better for Zenix. All analysis must be done in Excel Your excel model should be such that it can be used by Zenix for other similar capital budgeting situations - 50 anyone can change any numbers and use the model again. This would require all calculations to be using cell references and excel functions. You must write a memo to your boss, explaining the situation, your analysis, and your conclusion. You must also explain the drawbacks of your techniques if there are any. Make sure that all your submissions have your full name, class, and section number included. Zenix Corporation has a machine that either should be repaired or should be replaced soon. You have recently been hired by Zenix and one of your assignments is to help decide whether replacing the machine, or repairing it is in the best interest of your company. Investment required for repairing the machine is only $1,500,000 and cost to replace the machine is $9,000,000. Repairing the machine will cut down on the number of returns from customers and increase cash flows, while replacing the machine may increase the number of units sold. Zenix has evaluated and calculated additional cash flows that will be generated under the two scenarios over the next five years as follows: Year Cash flow (if repaired) 557,000 607,000 478.000 1513.000 387,000 Cash Flow (if replaced) 5,613,000 3,485.000 2.878,100 1.697,800 1.157.000 Zenix does not accept projects that will pay back in more than 3 years, or any projects that will not maximize shareholder wealth. So, you will need to use all capital budgeting techniques you've learnt in your Finance class to ensure that the right option is chosen. Cost of capital for the project (repair or replacement) could be anywhere from 10% to 14%, so you will conduct your analyses at various weighted average cost of capital (WACC) or Required rate of return points including at least five at 9.0%, 11%, 13%, and 15% for both scenarios, and also draw an NPV profile for both situation using your calculations. Use your knowledge of capital budgeting and time value of money to decide which of the options is better for Zenix. All analysis must be done in Excel Your excel model should be such that it can be used by Zenix for other similar capital budgeting situations - 50 anyone can change any numbers and use the model again. This would require all calculations to be using cell references and excel functions. You must write a memo to your boss, explaining the situation, your analysis, and your conclusion. You must also explain the drawbacks of your techniques if there are any. Make sure that all your submissions have your full name, class, and section number included

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Global Financial Crisis What Have We Learnt

Authors: Steven Kates

1st Edition

0857934228, 978-0857934222

More Books

Students also viewed these Finance questions

Question

What is a BIM model?

Answered: 1 week ago