Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CASE STUDY-UNIT 5 - Cash Flows (dollars in millions) There are no terminal values for the projects Current debt is $100 million (at 7%) and

image text in transcribed

CASE STUDY-UNIT 5

-

Cash Flows

(dollars in millions)

There are no terminal values for the projects

Current debt is $100 million (at 7%) and current equity is $300 million.

The treasury rate is 4%, AAA rated bonds are trading at 7%, the company tax rate is 35%, and current levered beta is 1.40.

The company will either fund the projects completely through debt (new bonds at 10% interest), completely through equity (new stock issuance), or will fund half through debt (new bonds at 10% interest) and half through new stock issuance.

If the company funds 100% through debt, the new levered beta will be 1.35. If it chooses to fund 100% through equity, the new levered beta will be 1.15, and if it funds 50% through debt and 50% through equity, the new levered beta will be 1.25.

Required:

Please submit a spreadsheet with the following items:

  • Determine Ingenuity's current WACC andits potential WACC under each the three funding scenarios.
  • Calculate and prepare table showing the NPV, IRR, and Payback metrics for each of the projects utilizing the company WACC for funding scenario.
  • Which funding option should the corporate finance department recommend? Why?

image text in transcribed
CASE STUDY UNIT 5 Ingenuity Corporation has been quite successful since its inception three years ago. It is now poised to enter high growth supported by several strong project opportunities which the company needs to fund. It must now decide how to fund the projects. The corporate nance department has been charged with evaluating project returns and recommending the best capital structure to fund them. Ingenuity Corp. plans to pursue all three projects being evaluated. Using the information below, utilize learnings 'om Units 3 and 4 to help Ingenuity evaluate the returns for each project and determine the best capital structure to support its high growth plans. Key Facts: fdoars in millions) Year Proi. 1 Proi. 2 Proi. 3 0 (30,000) (30,000) (20,000) 1 8,000 500 3,000 2 8,000 20,000 5,000 3 10,000 10,000 12,000 4 10,000 10,000 12,000 5 5,000 2,000 - 0 There are no terminal values for the projects 0 Current debt is $100 million (at 7%) and current equity is $300 million. 0 The treasury rate is 4%, AAA rated bonds are trading at 7%, the company tax rate is 35%, and current levered beta is 1.40. o The company will either fund the projects completely through debt (new bonds at 10% interest), completely through equity (new stock issuance), or will fund half through debt (new bonds at 10% interest) and half through new stock issuance. o If the company funds 100% through debt, the new levered beta will be 1.35. If it chooses to fund 100% through equity, the new levered beta will be 1.15, and if it funds 50% through debt and 50% through equity, the new levered beta will be 1.25. Required

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_2

Step: 3

blur-text-image_3

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

Corporate Finance

Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe, Gordon Roberts, Hamdi Driss

8th Canadian Edition

01259270114, 9781259270116

More Books

Students also viewed these Finance questions