Galaxy Satellite Co. is attempting to select the best group of independent proje
ID: 2765910 • Letter: G
Question
Galaxy Satellite Co. is attempting to select the best group of independent projects competing for the firm's fixed capital budget of $10,000,000. Any unused portion of this budget will earn less than its 20 percent cost of capital. A summary of key data about the proposed projects follows.
Project
PV of Inflows
Initial Investment
IRR
A
$3,050,000
$3,000,000
21%
B
$9,320,000
$9,000,000
25%
C
$1,060,000
$1,000,000
24%
D
$7,350,000
$7,000,000
23%
Use the NPV approach to select the best group of projects. (Note that just the PV of inflows is given, you must subtract the initial investment to find the NPV.)
Use the IRR approach to select the best group of projects. (Note that the discount rate or the cost of capital is 20%.)
Which projects should the firm implement based on your analysis of both techniques and given the capital rationing amount? Write an email to your boss, Andy Fast, the CFO, explaining your rationale proving the choices based on the considerations of shareholder value and the maximum investment budget. Keep in mind that you are less concerned with using the whole budget than with maximizing the total return to Galaxy satellite.
Project
PV of Inflows
Initial Investment
IRR
A
$3,050,000
$3,000,000
21%
B
$9,320,000
$9,000,000
25%
C
$1,060,000
$1,000,000
24%
D
$7,350,000
$7,000,000
23%
Explanation / Answer
1
NPV approach to select the best group of projects:
Project
PV of Inflows
Initial Investment
NPV
Ranking
A
B
A-B
A
$ 3,050,000
$ 3,000,000
$ 50,000
4
B
$ 9,320,000
$ 9,000,000
$320,000
2
C
$ 1,060,000
$ 1,000,000
$ 60,000
3
D
$ 7,350,000
$ 7,000,000
$350,000
1
Selection of Projects:
Investment in
Amount
Project D
$ 7,000,000
Project A
$ 3,000,000
Total
$ 10,000,000
2
IRR approach to select the best group of projects
Project
Initial Investment
IRR
Ranking
A
$ 3,000,000
21%
4
B
$ 9,000,000
25%
1
C
$ 1,000,000
24%
2
D
$ 7,000,000
23%
3
Selection of Projects:
Investment in
Amount
Project B
$ 9,000,000
Project C
$ 1,000,000
Total
$ 10,000,000
1
NPV approach to select the best group of projects:
Project
PV of Inflows
Initial Investment
NPV
Ranking
A
B
A-B
A
$ 3,050,000
$ 3,000,000
$ 50,000
4
B
$ 9,320,000
$ 9,000,000
$320,000
2
C
$ 1,060,000
$ 1,000,000
$ 60,000
3
D
$ 7,350,000
$ 7,000,000
$350,000
1
Selection of Projects:
Investment in
Amount
Project D
$ 7,000,000
Project A
$ 3,000,000
Total
$ 10,000,000
2
IRR approach to select the best group of projects
Project
Initial Investment
IRR
Ranking
A
$ 3,000,000
21%
4
B
$ 9,000,000
25%
1
C
$ 1,000,000
24%
2
D
$ 7,000,000
23%
3
Selection of Projects:
Investment in
Amount
Project B
$ 9,000,000
Project C
$ 1,000,000
Total
$ 10,000,000
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.