In: Finance
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.
%
| 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% |