Submit your synthesis of financial data related to long-term financing needs for an organization, to include the following:
Part 3: Long-Term Working Capital Considerations: CAPM, Stock Valuation, and Project Evaluation Tools (1–2 pages, plus calculations in Excel)
• CAPM and Required Return: The company has a beta of 1.1, and the closest competitor has a beta of 0.30. The required return on an index fund that holds the entire stock market is 11%. The risk-free rate of interest is 4.5%. By how much does your company’s required return exceed your competitor’s required return?
• Constant Growth Valuation: The company is expected to pay a $1.80 per share dividend at the end of the year (i.e., D1 = $1.80). The dividend is expected to grow at a constant rate of 4% a year. The required rate of return on the stock, rs, is 10%. What is the stock’s current value per share?
• Nonconstant Growth Valuation: The company recently paid a dividend, D0, of $2.75. It expects to have nonconstant growth of 18% for 2 years followed by a constant rate of 6% thereafter. The firm’s required return is 12%.
o How far away is the horizon date?
o What is the firm’s horizon, or continuing, value?
o What is the firm’s intrinsic value today, P0?
• Weighted Average Cost of Capital: The company has a target capital structure of 35% debt and 65% common equity, with no preferred stock. Its before-tax cost of debt is 8%, and its marginal tax rate is 40%. The current stock price is P0 = $22.00. The last dividend was D0 = $2.25, and it is expected to grow at a 5% constant rate. What is its cost of common equity and its WACC?
• Capital Budgeting Criteria: The company has an 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows:
o What is each project’s NPV?
o What is each project’s IRR?
o What is each project’s MIRR? (Hint: Consider Period 7 as the end of Project B’s life.)
o From your answers to parts a, b, and c, which project would be selected? If the WACC was 18%, which project would be selected?
o Construct NPV profiles for Projects A and B.
o Calculate the crossover rate where the two projects’ NPVs are equal.
o What is each project’s MIRR at a WACC of 18%?
Executive Summary (page 1 of your report)
Provide the company owner with a 1-page executive summary of your findings and recommendations. Address the following in your executive summary:
• Briefly identify the purpose of your report.
• Concisely summarize the results of your financial analysis of the company’s short- and long-term capital budget needs.
• Synthesize your recommendations for how the company can raise money in the short-term and long-term to continue to add value to the organization.
