Please show work on excel thank you
MAD Inc.'s Board was so impressed with Sharon Meadows' analysis that they expanded her financial analysis department. Sharon has hired your team to help her evaluate a potential new project for the company. The company just finished a project in a manufacturing plant that could be modified and used for this new project manufacturing materials for microprocessor chips used in automobiles and computers. MAD Inc. sees this as a 4-year project to help fill the national and world-wide microprocessor chip shortage. Initial costs (t=0) include plant modification and equipment costs totaling $3,500,000. The company estimates that they will have more than sufficient operating income to write off (expense) the cost of the project which allows the project to qualify for immediate 100% Bonus Depreciation. Also, the project would require and initial increase in net operating working capital of $400,000. Last year, the company spent $250,000 repairing some damage caused by the previous project in the manufacturing plant that would be used by this proposed project. Some members of MAD's accounting and treasury department suggest that this repair cost which has already been paid and expensed for tax purposes should be charged against this microprocessor materials project. Their rationale is that the company would have to spend this $250,000 to make the plant suitable for the proposed new project. In terms of annual operating cash flows, the company forecasts the following sales price & variable cost per unit and unit sales. The company forecasts fixed costs of $200,000 annually and a tax rate of 25%. The company forecasts fixed costs of $200,000 annually and a tax rate of 25%. At the end of the 4-year life of the project, the equipment has an expected salvage value of $300,000 and the initial increase in net operating working capital would be liquidated (recovered). Susan and her staff has estimated a 13% WACC for this project. Part II Questions 1. Should the $250,000 spent last year to repair the manufacturing plant be included in the project analysis? 2. Suppose another manufacturer expressed interest in leasing the plant for $500,000 a year. Explain how this information would be incorporated in the analysis if this were true (in fact it was not)? 3. What is MAD's Year 0 total initial investment outlay for the proposed project? 4. Estimate the project's operating cash flows for years 1 through 4. 5. What is the expected non-operating (terminal) cash flow when the project is terminated at the end of Year 4 ? 6. Using the project's WACC of 13%, what is the project's NPV and IRR? Should the project be undertaken? MAD Inc.'s Board was so impressed with Sharon Meadows' analysis that they expanded her financial analysis department. Sharon has hired your team to help her evaluate a potential new project for the company. The company just finished a project in a manufacturing plant that could be modified and used for this new project manufacturing materials for microprocessor chips used in automobiles and computers. MAD Inc. sees this as a 4-year project to help fill the national and world-wide microprocessor chip shortage. Initial costs (t=0) include plant modification and equipment costs totaling $3,500,000. The company estimates that they will have more than sufficient operating income to write off (expense) the cost of the project which allows the project to qualify for immediate 100% Bonus Depreciation. Also, the project would require and initial increase in net operating working capital of $400,000. Last year, the company spent $250,000 repairing some damage caused by the previous project in the manufacturing plant that would be used by this proposed project. Some members of MAD's accounting and treasury department suggest that this repair cost which has already been paid and expensed for tax purposes should be charged against this microprocessor materials project. Their rationale is that the company would have to spend this $250,000 to make the plant suitable for the proposed new project. In terms of annual operating cash flows, the company forecasts the following sales price & variable cost per unit and unit sales. The company forecasts fixed costs of $200,000 annually and a tax rate of 25%. The company forecasts fixed costs of $200,000 annually and a tax rate of 25%. At the end of the 4-year life of the project, the equipment has an expected salvage value of $300,000 and the initial increase in net operating working capital would be liquidated (recovered). Susan and her staff has estimated a 13% WACC for this project. Part II Questions 1. Should the $250,000 spent last year to repair the manufacturing plant be included in the project analysis? 2. Suppose another manufacturer expressed interest in leasing the plant for $500,000 a year. Explain how this information would be incorporated in the analysis if this were true (in fact it was not)? 3. What is MAD's Year 0 total initial investment outlay for the proposed project? 4. Estimate the project's operating cash flows for years 1 through 4. 5. What is the expected non-operating (terminal) cash flow when the project is terminated at the end of Year 4 ? 6. Using the project's WACC of 13%, what is the project's NPV and IRR? Should the project be undertaken
