Please use the attached spreadsheet!!! Thank you!!!
Wind Power Inc. builds and operates wind frames that generate electrical power using windmills. The firm has wind farms throughout the Southwest, including Texas, New Mexico, and Oklahoma. In the spring of 2007 the firm was considering an investment in a new monitoring system that cost $6 million per wind farm to install. The new system is expected to contribute to firm EBITDA via annual savings of $4.25 million in Year 1, $2.9 million in Year 2, and $1 million in Year 3.
Wind Power's chief financial officer is interested in investing in the new system but is concerned that the savings from the system are such that the immediate impact of the project is so accretive to the firm's earnings that the individual unit managers will adopt the investment even though it may not be expected to earn a positive NPV. Moreover, the firm has just moved to an economic profit-based bonus system, and the CFO fears that the project may also make the individual economic profits improve dramatically in the short term-a development that would provide an added incentive for the wind farm managers to take on the project.
a. Calculate the project's expected NPV and IRR assuming that the cost of capital for the project is 15%, the firm faces a 30% marginal tax rate, it uses straight-line depreciation for the new investment over a three-year project life, and that it has a zero slavage value.
b. Calculate the annual economic profits for the investment for Years 1 through 3. What is the present value of annual economic profit measures discounted using the project's cost of capital?
What potential problems do you see for the project?
c. Calculate the economic depreciation for the project and use it to calculate a revised economic profit measure following the procedure laid out in Table 9-8 (see attached spreadsheet). What is the present value of all the revised economic profit measures when discounted using the project's cost of capital? (Hint: First, revise the initial NOPAT estimate from your answer to question a by subtracting the economic depreciation estimate from project free cash flow calculated in question a. Next, calculate the capital charge for each year based on invested capital less economic depreciation.)
d. Using your analysis in asnwering questions b and c, calculate the return on invested capital (ROIC) for Years 1 through 3 as the ratio of NOPAT for Year t to invested capital for Year t-1. Compare the two
sets of calculations and discuss how the use of economic depreciation affects the ROIC estimate for the project.
Calculate the economic depreciation for the project and use it to calculate a revised economic profit measure following the procedure laid out in Table 9-8 (see attached spreadsheet).
Riscalla Company has two divisions, A and B. The following information is available:
1. Riscalla Company has two divisions, A and B. The following information is available:
Invested capital: $100,000
Cost of capital: 20%
Invested capital: $150,000
Cost of capital: 15%
Calculate the residual income for each Division.
2. Division E had an ROI last year of 15%. The division's minimum required rate of return is 10%. If the division's invested capital last year was $450,000, what was the division's residual income last year?
3. The following data is available for the North Division of Blueride Products, Inc., and the single product it makes:
Unit selling price: $20
Variable cost per unit: $12
Annual fixed costs $280,000
Invested capital: $1,500,000
a. How many units must South sell each year to have an ROI of 16%?
b. If South wants a residual income of $50,000, and the minimum required rate of return is 10%, what is the capital turnover?
4. Sales and invested capital for Division 1 and Division 2 are given below:
Invested Capital: $8,000
Invested Capital: $10,000
What is the return on sales that each division will have to earn in order to generate a return on investment of 20%?View Full Posting Details