70.2K

Verified Solution

Link Copied!

To answer this question, you will need to reference the case study which can be found in the URL below: please reference this URL here I have provided to view the case study which you will use to answer the questions. The natural gas below, the numbers for that are found in the article and thats how you will also find the answer to the others. You NEED to click the URL so that you can download the article. the data is in that URL. Its a 7 page case study.

URL: https://www.imanet.org/-/media/a099d3d3475b4f7d939bc32c1a67d1a5.ashx

a)Evaluate the five alternative production projects using traditional discounted cash flow analysis:

What is the appropriate cost of capital for this case? Support your reasoning.

Note that the marginal cost of capital is the appropriate input for capital budgeting decisions. This rate should best estimate of the current cost of raising additional debt of similar risk.

Year	Natural Gas Plant Cash Flows (In Millions $)	Nuclear Plant Cash Flows (In Millions $)	Wind Plant Cash Flows (In Millions $)	Solar Plant Cash Flows (In Millions $)	Coal Plant Cash Flows (In Millions $)
0	(650)
1	0
2	0
3	42.5
4	85
5	85
6	85
7	85
8	85
9	85
10	85
11	85
12	85
13	85
14	85
15	85
16	85
17	85
18	85
19	85
20	85
21	0
22	0
23	0
24	0
25	0
26	0
27	0
28	0
29	0
30	0

WACC = ? MUST ENTER Cost of Capital for NPV computations in spreadsheet below to calculate. I have provided Natural gas below, fill out the remaining.

NPV	$837.50
IRR	7.99%

d)

b) Fill in the following operating characteristics of each of the production alternatives? I have completed the first one for you - Natural Gas Useful Life Expected Annual Cash Flows In Millions S 85 Plant Type Natural Gas Nuclear Wind Solar Coal Cost (In Millions S 650 ears 20 30 20 20 30 Calculate the net present value (NPV) and internal rate of return (IRR) for each of the alternatives: natural gas plant, nuclear plant, wind plant, solar plant and coal plant. Use the excel template Iposted to Moodle to complete this I have completed the first one for you - Natural Gas. Be sure, however, to enter the cost ojf capital you determined in part a as the WACC (weighted average cost ofcapital). This will change the NPVfor Natural Gas c) b) Fill in the following operating characteristics of each of the production alternatives? I have completed the first one for you - Natural Gas Useful Life Expected Annual Cash Flows In Millions S 85 Plant Type Natural Gas Nuclear Wind Solar Coal Cost (In Millions S 650 ears 20 30 20 20 30 Calculate the net present value (NPV) and internal rate of return (IRR) for each of the alternatives: natural gas plant, nuclear plant, wind plant, solar plant and coal plant. Use the excel template Iposted to Moodle to complete this I have completed the first one for you - Natural Gas. Be sure, however, to enter the cost ojf capital you determined in part a as the WACC (weighted average cost ofcapital). This will change the NPVfor Natural Gas c)

Answer & Explanation Solved by verified expert

See Answer