Question

In: Finance

An electric utility company is considering a new power plant in northern New Mexico. Electricity generated...

An electric utility company is considering a new power plant in northern New Mexico. Electricity generated at the plant would be sold in the Albuquerque market where it is badly needed. The firm has the possibility of building a plant that will meet their production needs for the next several years that will cost $300 M. They also have the option of building a larger facility that will have a higher production capacity and will allow them to sell some excess power to another utility company under a long-term contract. The larger facility will cost $600M. The anticipated cash flows for each plant are as follows:

Year

Small Facility Cash Flow in Millions

Large Facility Cash Flow in Millions

1

$150

$200

2

$175

$225

3

$200

$250

4

$225

$275

5

$250

$300

6

$275

$325

7

$300

$350

8

$300

$375

9

$300

$400

10

$300

$450

At the end of ten years, both facilities will need significant upgrades and the company plans to conduct further analysis at that time. The risk adjusted cost of capital for this project is 12 percent.

1. Choose a course of action for the company and justify your decision for the managers of the company.

Solutions

Expert Solution

Select the Project with higher NPV.

NPV = PV of Cah inflows - PV of Cash Outflows

Small Project:

Year CF PVF @12% Disc CF
0 $ -300.00     1.0000 $   -300.00
1 $ 150.00     0.8929 $    133.93
2 $ 175.00     0.7972 $    139.51
3 $ 200.00     0.7118 $    142.36
4 $ 225.00     0.6355 $    142.99
5 $ 250.00     0.5674 $    141.86
6 $ 275.00     0.5066 $    139.32
7 $ 300.00     0.4523 $    135.70
8 $ 300.00     0.4039 $    121.16
9 $ 300.00     0.3606 $    108.18
10 $ 300.00     0.3220 $      96.59
NPV $ 1,001.61

Large Project:

Year CF PVF @12% Disc CF
0 $ -600.00     1.0000 $   -600.00
1 $ 200.00     0.8929 $    178.57
2 $ 225.00     0.7972 $    179.37
3 $ 250.00     0.7118 $    177.95
4 $ 275.00     0.6355 $    174.77
5 $ 300.00     0.5674 $    170.23
6 $ 325.00     0.5066 $    164.66
7 $ 350.00     0.4523 $    158.32
8 $ 375.00     0.4039 $    151.46
9 $ 400.00     0.3606 $    144.24
10 $ 450.00     0.3220 $    144.89
NPV $ 1,044.45

Large Project is selected as it has Higher NPV.


Related Solutions

An electric utility is considering a new power plant in northern Arizona. Power from the plant...
An electric utility is considering a new power plant in northern Arizona. Power from the plant would be sold in the Phoenix area, where it is badly needed. Because the firm has received a permit, the plant would be legal; but it would cause some air pollution. The company could spend an additional $40 million at Year 0 to mitigate the environmental problem, but it would not be required to do so. The plant without mitigation would cost $269.63 million,...
An electric utility is considering a new power plant in northern Arizona. Power from the plant...
An electric utility is considering a new power plant in northern Arizona. Power from the plant would be sold in the Phoenix area, where it is badly needed. Because the firm has received a permit, the plant would be legal; but it would cause some air pollution. The company could spend an additional $40 million at Year 0 to mitigate the environmental problem, but it would not be required to do so. The plant without mitigation would require an initial...
An electric utility is considering a new power plant in northern Arizona. Power from the plant...
An electric utility is considering a new power plant in northern Arizona. Power from the plant would be sold in the Phoenix area, where it is badly needed. Because the firm has received a permit, the plant would be legal; but it would cause some air pollution. The company could spend an additional $40 million at Year 0 to mitigate the environmental problem, but it would not be required to do so. The plant without mitigation would require an initial...
An electric utility is considering a new power plant in northern Arizona. Power from the plant...
An electric utility is considering a new power plant in northern Arizona. Power from the plant would be sold in the Phoenix area, where it is badly needed. Because the firm has received a permit, the plant would be legal; but it would cause some air pollution. The company could spend an additional $40 million at Year 0 to mitigate the environmental problem, but it would not be required to do so. The plant without mitigation would require an initial...
An electric utility is considering a new power plant in northern Arizona. Power from the plant...
An electric utility is considering a new power plant in northern Arizona. Power from the plant would be sold in the Phoenix area, where it is badly needed. Because the firm has received a permit, the plant would be legal; but it would cause some air pollution. The company could spend an additional $40 million at Year 0 to mitigate the environmental problem, but it would not be required to do so. The plant without mitigation would require an initial...
An electric utility is considering a new power plant in northern Arizona. Power from the plant...
An electric utility is considering a new power plant in northern Arizona. Power from the plant would be sold in the Phoenix area, where it is badly needed. Because the firm has received a permit, the plant would be legal; but it would cause some air pollution. The company could spend an additional $40 million at Year 0 to mitigate the environmental problem, but it would not be required to do so. The plant without mitigation would require an initial...
An electric utility is considering a new power plant in northern Arizona. Power from the plant...
An electric utility is considering a new power plant in northern Arizona. Power from the plant would be sold in the Phoenix area, where it is badly needed. Because the firm has received a permit, the plant would be legal; but it would cause some air pollution. The company could spend an additional $40 million at Year 0 to mitigate the environmental problem, but it would not be required to do so. The plant without mitigation would cost $270.11 million,...
An electric utility is considering a new power plant in northern Arizona. Power from the plant...
An electric utility is considering a new power plant in northern Arizona. Power from the plant would be sold in the Phoenix area, where it is badly needed. Because the firm has received a permit, the plant would be legal; but it would cause some air pollution. The company could spend an additional $40 million at Year 0 to mitigate the environmental problem, but it would not be required to do so. The plant without mitigation would cost $239.88 million,...
An electric utility is considering a new power plant in northern Arizona. Power from the plant...
An electric utility is considering a new power plant in northern Arizona. Power from the plant would be sold in the Phoenix area, where it is badly needed. Because the firm has received a permit, the plant would be legal; but it would cause some air pollution. The company could spend an additional $40 million at Year 0 to mitigate the environmental problem, but it would not be required to do so. The plant without mitigation would require an initial...
An electric utility is considering a new power plant in northern Arizona. Power from the plant...
An electric utility is considering a new power plant in northern Arizona. Power from the plant would be sold in the Phoenix area, where it is badly needed. Because the firm has received a permit, the plant would be legal; but it would cause some air pollution. The company could spend an additional $40 million at Year 0 to mitigate the environmental problem, but it would not be required to do so. The plant without mitigation would require an initial...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT