Page 1 of 2 > Note: Please create your own Excel file to conduct the project...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Page 1 of 2 > Note: Please create your own Excel file to conduct the project analysis and make sure of showing all necessary calculation processes to receive credits. Turn-in your Excel file via Blackboard. Good luck! Cohering Corporation (CC) is a global leader in implantable hearing solutions. They specialize in the design, manufacture, and distribution of cochlear implants, bone conduction implants, and associated hearing products. Suppose the company hired you as a financial consultant to consider expending its business internationally. The plan is to build a new manufacturing facility in Guangdong, China where the company bought some land back 2020 for $6.25 million. If the land were sold today, the net proceeds would be $9.45 million after taxes. The company wants to build its new manufacturing facility on this land; the facility will cost $42 million to build and production equipment would demand anther 2.3 million to acquire and be installed. The company is also planning to use the facility to produce the new generation of Bone Conduction Implants: Baha System for next five years and projects unit sales for the new generation follows: Year Unit sales 2025 73,200 2026 86,200 2027 105,250 2028 97,300 2029 67,400 Production of the implants will require $1.55 million net working capital to start and additional net working capital investments each year equal to 10 percent of the projected sales increase for the following year. Total fixed costs are $3,3 million per year, variable production costs are $22,000 per unit, and the units are priced at $25,500 each. And this equipment is considered industrial machinery and thus qualifies as seven-year MACRS property. The tax rate is 21 percent. Property Class Year 7-year 1 14.29% 2 24.49% 3 17.49% 4 12.49% 5 8.93% 6 8.92% 7 8.93% 8 4.46% Page 2 of 2 > The company currently sells 86,900 units of its existing model per year on average. If the new model is introduced, sales of the existing model will fall to 75,600 units per year on average. The model retails for $23,100 and variable costs are 53 percent of sales. The following market data on CC's securities are current: Debt 1: 15,000 zero coupon American bonds outstanding, 10 years to maturity, selling for 63 percent of par. Debt 2: 11,000 6 percent coupon American bonds outstanding, $1,000 par value, 27 years to maturity, selling for 108 percent of par. Common stock: 440,000 shares outstanding, selling for $79 per share; beta is 1.24. Preferred stock: 19,000 shares of 3.8 percent preferred stock outstanding, currently selling for $83 per share. The par value is $100 per share. Market: 13.8 percent of the market expected return and 4.8 percent risk-free rate. Question1. The new project is somewhat riskier than a typical project for CC, primarily because the plant is being located overseas. Management has told you to use an adjustment factor of +2.7 percent to account for this increased riskiness. What is the appropriate discount rate to use when evaluating CC's project (12.5 Points) Question 2. At the end of the project, the equipment can be sold for about 22.5 percent of its acquisition cost. What is the after-tax salvage value of this equipment? (2.5 points) Question 3. What is the annual operating cash flow, OCF, from this project? (7.5 Points) Question 4. What is the NPV of this project? What is the project's IRR? (7.5 Points) Question 5. Both variable costs and unit price are estimated to be accurate +/-6 percent, therefore, you would like to conduct an Optimistic and the Pessimistic scenarios analysis on the projected NPV and IRR of this investment. What are the Optimistic and the Pessimistic scenarios of NPV and IRR? Have to use the Excel Scenario Manager function to solve the problem. (10 Points) Question 6. After scenarios analysis was presented to the company, the CEO of the company also interested to know which factor has the most significant impact on financial performance and where management's attention should be focused to mitigate risks or capitalize on opportunities. So how sensitive is the NPV to changes in the variable costs? And how sensitive is the NPV to changes in the unit price? Have to use Excel Scenario Function manager to solve the problem. (10 Points) Page 1 of 2 > Note: Please create your own Excel file to conduct the project analysis and make sure of showing all necessary calculation processes to receive credits. Turn-in your Excel file via Blackboard. Good luck! Cohering Corporation (CC) is a global leader in implantable hearing solutions. They specialize in the design, manufacture, and distribution of cochlear implants, bone conduction implants, and associated hearing products. Suppose the company hired you as a financial consultant to consider expending its business internationally. The plan is to build a new manufacturing facility in Guangdong, China where the company bought some land back 2020 for $6.25 million. If the land were sold today, the net proceeds would be $9.45 million after taxes. The company wants to build its new manufacturing facility on this land; the facility will cost $42 million to build and production equipment would demand anther 2.3 million to acquire and be installed. The company is also planning to use the facility to produce the new generation of Bone Conduction Implants: Baha System for next five years and projects unit sales for the new generation follows: Year Unit sales 2025 73,200 2026 86,200 2027 105,250 2028 97,300 2029 67,400 Production of the implants will require $1.55 million net working capital to start and additional net working capital investments each year equal to 10 percent of the projected sales increase for the following year. Total fixed costs are $3,3 million per year, variable production costs are $22,000 per unit, and the units are priced at $25,500 each. And this equipment is considered industrial machinery and thus qualifies as seven-year MACRS property. The tax rate is 21 percent. Property Class Year 7-year 1 14.29% 2 24.49% 3 17.49% 4 12.49% 5 8.93% 6 8.92% 7 8.93% 8 4.46% Page 2 of 2 > The company currently sells 86,900 units of its existing model per year on average. If the new model is introduced, sales of the existing model will fall to 75,600 units per year on average. The model retails for $23,100 and variable costs are 53 percent of sales. The following market data on CC's securities are current: Debt 1: 15,000 zero coupon American bonds outstanding, 10 years to maturity, selling for 63 percent of par. Debt 2: 11,000 6 percent coupon American bonds outstanding, $1,000 par value, 27 years to maturity, selling for 108 percent of par. Common stock: 440,000 shares outstanding, selling for $79 per share; beta is 1.24. Preferred stock: 19,000 shares of 3.8 percent preferred stock outstanding, currently selling for $83 per share. The par value is $100 per share. Market: 13.8 percent of the market expected return and 4.8 percent risk-free rate. Question1. The new project is somewhat riskier than a typical project for CC, primarily because the plant is being located overseas. Management has told you to use an adjustment factor of +2.7 percent to account for this increased riskiness. What is the appropriate discount rate to use when evaluating CC's project (12.5 Points) Question 2. At the end of the project, the equipment can be sold for about 22.5 percent of its acquisition cost. What is the after-tax salvage value of this equipment? (2.5 points) Question 3. What is the annual operating cash flow, OCF, from this project? (7.5 Points) Question 4. What is the NPV of this project? What is the project's IRR? (7.5 Points) Question 5. Both variable costs and unit price are estimated to be accurate +/-6 percent, therefore, you would like to conduct an Optimistic and the Pessimistic scenarios analysis on the projected NPV and IRR of this investment. What are the Optimistic and the Pessimistic scenarios of NPV and IRR? Have to use the Excel Scenario Manager function to solve the problem. (10 Points) Question 6. After scenarios analysis was presented to the company, the CEO of the company also interested to know which factor has the most significant impact on financial performance and where management's attention should be focused to mitigate risks or capitalize on opportunities. So how sensitive is the NPV to changes in the variable costs? And how sensitive is the NPV to changes in the unit price? Have to use Excel Scenario Function manager to solve the problem. (10 Points)
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
An employee of Gus's Restaurant sustains a work-related injury. The owner of the restaurant is liable for the injury, however, the employee is not covered under the state's workers' compensation...
-
Celestial Artistry Company is developing departmental overhead rates based on direct-labor hours for its two production departments, Etching and Finishing. The Etching Department employs 20 people...
-
Sherman Lawn Service, Inc., has been open for one year, and Hannah Sherman, the owner, wants to know whether the business earned a net income or a net loss for the year. First, she must identify the...
-
George Company purchased land for use as its corporate headquarters. A small factory that was on the land when it was purchased was torn down, and before the new buildings foundation could be...
-
Draft a closing argument based on the facts below Tim has commenced an action for battery against Dylan, alleging injuries suffered from stab wounds inflicted by Dylan, and seeking damages. At the...
-
1. (Expected rate of return and risk) Summerville Inc. is considering an investment in one of two common stocks. Given the information that follows, which investment is better, based on the risk (as...
-
How can organizations establish and maintain a culture of continuous learning and knowledge sharing to facilitate employee development and organizational resilience in the face of rapid technological...
-
Suppose that a lemonade stand's lemonade recipe consists of 2 cups of sugar, 3 cups of lemon juice, and 5 cups of water per batch. a) How much sugar and water should be added if they only use 1 cup...
-
1. Solve the following systems of congruences or explain why they do not have solutions. In case there are solutions they must be given in the modulus that is the LCM of the congruence modulus. (a)...
-
The Assembling Department of Patchwork, Inc. had 10,300 units in process on December 1 and received 30,600 units from the Sewing Department. During the month, it completed 20,800 units and...
-
A baseball player hits a home run. He hits the ball with a speed of 45.1 m/s and a launch angle of 23.3. Ignoring the height above the ground the ball was hit (assume it was ground level), calculate:...
Study smarter with the SolutionInn App