ngenuity Corporation has been quite successful since its inception three years ago. It is now poised to enter high growth supported by several strong...
This question has been answered
Question

ngenuity 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 finance 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. Evaluate the returns for each project and determine the best capital structure to support its high growth plans.
Cash Flows:
(dollars in thousands)
Project 1 Project 2 Project 3
Year 0 (30,000) (30,000) (20,000)
Year 1 8,000 500 3,000
Year 2 8,000 20,000 5,000
Year 3 10,000 10,000 12,000
Year 4 10,000 10,000 12,000
Year 5 5,000 2,000 -----


There are no terminal values for the projects.
Current debt is $100 million (at 7%) and current equity is $300 million.
Treasury rate 4%. AAA rated bonds are trading at 7%, company tax rate is 35%, and current levered beta is 1.40.
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 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.


Show via spreadsheet:
Determine Ingenuity's current WACC and its potential WACC under each the three funding scenarios.
Calculate a 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?


Please show excel formulas

Answered by Expert Tutors

trices ac magna. Fu

itur laoreet. Nam risus a

inia pulvinar tortor nec faci

Fusce dui lectus, congue vel lao

, dictum vitae odio. Donec aliquet. Lorem

gue

ec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fu

Step-by-step explanation

fficitur laoreet. Nam risus ante, dapibus a molestie consequat

ctum vitae od

16287618

at, ultrices a

16287626

ng elit. Nam lacinia pulvinar tortor nec

gue

et, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec f

ctum vitae od

16287630

at, ultrices a

16287643

a molestie consequat, ultrices

gue

or nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus

ctum vitae od

16287652

at, ultrices a

16287663

or nec facilisis. Pellentesque dapibus effic

gue

or nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, da

ctum vitae od

16287670

pulvinar tor

16287680

congue vel laoreet ac, dictum vitae od

gue

ce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliq

ctum vitae od

16287690

pulvinar tor

16287695

s a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit am

m ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec

Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ip

, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesqu

gue

lestie consequat, ultrices ac magna. Fusce dui lectus, congue vel l

ctum vitae od

16287710

at, ultrices a

16287714

ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus a

icitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusc

trices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet

Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ip

gue

congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ips

ctum vitae od

16287737

at, ultrices a

16287750

s a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit am

ia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus a

Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum do

ipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur l

itur la

16287768

e vel laoreet

ng elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur la

gue

15 Attachments
1.png
png
10.png
png
11.png
png
12.png
png
13.png
png
14.png
png
15.png
png
2.png
png
3.png
png
4.png
png
5.png
png
6.png
png
7.png
png
8.png
png
9.png
png
Subject: Business, Finance
Get unstuck

487,593 students got unstuck by Course
Hero in the last week

step by step solutions

Our Expert Tutors provide step by step solutions to help you excel in your courses