Question

In: Finance

The Pinkerton Publishing Company is considering two mutually exclusive expansion plans. Plan A calls for the...

The Pinkerton Publishing Company is considering two mutually exclusive expansion plans. Plan A calls for the expenditure of $56 million on a large-scale, integrated plant that will provide an expected cash flow stream of $9 million per year for 20 years. Plan B calls for the expenditure of $12 million to build a somewhat less efficient, more labor-intensive plant that has an expected cash flow stream of $3.8 million per year for 20 years. The firm's cost of capital is 11%.

Calculate each project's NPV. Round your answers to the nearest dollar.

Project A $
Project B $


Calculate each project's IRR. Round your answers to two decimal places.

Project A %
Project B %



Set up a Project ? by showing the cash flows that will exist if the firm goes with the large plant rather than the smaller plant.

Year Project ? Cash Flows
0 $
1-20 $


What is the NPV for this Project ?? Round your answer to the nearest dollar.

$


What is the IRR for this Project ?? Round your answer to two decimal places.
%

Solutions

Expert Solution

1] NPV of Project A = -56,000,000+9,000,000*(1.11^20-1)/(0.11*1.11^20) = $       1,56,69,953
NPV of Project B = -12,000,000+3,800,000*(1.11^20-1)/(0.11*1.11^20) = $       1,82,60,647
2] IRR is that discount rate for which NPV = 0. It has to be
found out by trial and error.
Project A:
0 = -56000000+9000000*PVIFA(irr,20)
Solving for IRR.
PVIFA(irr,20) = 56000000/9000000 = 6.2222
PVIFA for n = 20 and r = 14% = 6.5504
for r = 15% = 6.1982
IRR = 14%+1%*(6.5504-6.2222)/(6.5504-6.1982) = 14.93%
Project B:
0 = -12000000+3800000*PVIFA(irr,20)
Solving for IRR.
PVIFA(irr,20) = 12000000/3800000 = 3.1579
PVIFA for n = 20 and r = 31% = 3.2112
for r = 31% = 3.1129
IRR = 31%+1%*(3.2112-3.1579)/(3.2112-3.1129) = 31.54%
3] SETTING UP A PROJECT:
Year 0 - Project cash flows = 56,000,000-12,000,000 = $     -4,40,00,000
Year 1-20 - Project cash flows = 9,000,000-3,800,000 = $          52,00,000
NPV = -44000000+5200000*(1.11^20-1)/(0.11*1.11^20) = $         -25,90,694
IRR:
PVIFA(irr,20) = 44000000/5200000 = 8.4615
PVIFA for n = 20 and r = 10% = 8.5136
for r = 11% = 7.9633
IRR = 10%+1%*(8.5136-8.4615)/(8.5136-7.9633) = 10.09%

Related Solutions

The Pinkerton Publishing Company is considering two mutually exclusive expansion plans. Plan A calls for the...
The Pinkerton Publishing Company is considering two mutually exclusive expansion plans. Plan A calls for the expenditure of $50 million on a large-scale, integrated plant that will provide an expected cash flow stream of $8 million per year for 20 years. Plan B calls for the expenditure of $15 million to build a somewhat less efficient, more labor-intensive plant that has an expected cash flow stream of $3.4 million per year for 20 years. The firm's cost of capital is...
The Pinkerton Publishing Company is considering two mutually exclusive expansion plans. Plan A calls for the...
The Pinkerton Publishing Company is considering two mutually exclusive expansion plans. Plan A calls for the expenditure of $50 million on a large-scale, integrated plant that will provide an expected cash flow stream of $8 million per year for 20 years. Plan B calls for the expenditure of $15 million to build a somewhat less efficient, more labor-intensive plant that has an expected cash flow stream of $3.4 million per year for 20 years. The firm’s cost of capital is...
The Pinkerton Publishing Co. is considering two mutually exclusive expansion plans. Plan A calls for the...
The Pinkerton Publishing Co. is considering two mutually exclusive expansion plans. Plan A calls for the expenditure of $50 million on a large-scale, integrated plant that will provide an expected cash flow stream of $8 million per year for 20 years. Plan B calls for the expenditure of $15 million to build a somewhat less efficient, more labor-intensive plant that has an expected cash flow stream of $3.4 million per year for 20 years. The cost of capital is 10%....
The Pinkerton Publishing Company is considering two independent expansion plans. Plan A calls for the expenditure...
The Pinkerton Publishing Company is considering two independent expansion plans. Plan A calls for the expenditure of $50 million on a large-scale, integrated plant that will provide an expected cash flow stream of $9 million per year for 8 years. Plan B calls for the expenditure of $28 million to build a somewhat less efficient, more labor-intensive plant that has an expected cash flow stream of $ 5 million per year for 8 years. The firm’s cost of capital is...
A company is considering two mutually exclusive expansion plans. Plan A requires a $41 million expenditure...
A company is considering two mutually exclusive expansion plans. Plan A requires a $41 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.55 million per year for 20 years. Plan B requires a $12 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.69 million per year for 20 years. The firm's WACC is 11%. The data has been collected in the Microsoft Excel Online file...
A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure...
A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.23 million per year for 20 years. Plan B requires a $12 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.69 million per year for 20 years. The firm's WACC is 10%. The data has been collected in the Microsoft Excel Online file...
A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure...
A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.39 million per year for 20 years. Plan B requires a $13 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.91 million per year for 20 years. The firm's WACC is 11%. Calculate each project's NPV. Enter your answers in millions. For example,...
A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure...
A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.39 million per year for 20 years. Plan B requires a $11 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.47 million per year for 20 years. The firm's WACC is 11%. a. Calculate each project's NPV. Round your answers to two decimal...
A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure...
A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.39 million per year for 20 years. Plan B requires a $11 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.47 million per year for 20 years. The firm's WACC is 9%. The data has been collected in the Microsoft Excel Online file...
A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure...
A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.39 million per year for 20 years. Plan B requires a $11 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.47 million per year for 20 years. The firm's WACC is 11%. Calculate each project's NPV. Enter your answers in millions. For example,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT