In: Finance
(NPV,PI, and IRR calculations) Fijisawa Inc. is considering a major expansion of its product line and has estimated the following cash flows associated with such an expansion. The initial outlay would be $1,850,000,and the project would generate incremental free cash flows of $700,000 per year for 6 years. The appropriate required rate of return is 9 percent.
a. Calculate the NPV.
b. Calculate the PI.
c. Calculate the IRR.
d. Should this project be accepted?
| Fijisawa | |||||||
| Discount rate | 9.000% | ||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
| Cash flow stream | -1850000 | 700000 | 700000 | 700000 | 700000 | 700000 | 700000 |
| Discounting factor | 1.000 | 1.090 | 1.188 | 1.295 | 1.412 | 1.539 | 1.677 |
| Discounted cash flows project | -1850000.000 | 642201.835 | 589175.995 | 540528.436 | 495897.648 | 454951.970 | 417387.129 |
| NPV = Sum of discounted cash flows | |||||||
| a. NPV Fijisawa = | 1290143.01 | ||||||
| Where | |||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||||
| Discounted Cashflow= | Cash flow stream/discounting factor | ||||||
| b. PI= (NPV+initial inv.)/initial inv. | |||||||
| =(1290143.01+1850000)/1850000 | |||||||
| 1.7 | |||||||
| Fijisawa | |||||||
| IRR is the rate at which NPV =0 | |||||||
| IRR | 30.00% | ||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
| Cash flow stream | -1850000.000 | 700000.000 | 700000.000 | 700000.000 | 700000.000 | 700000.000 | 700000.000 |
| Discounting factor | 1.000 | 1.300 | 1.690 | 2.197 | 2.856 | 3.713 | 4.826 |
| Discounted cash flows project | -1850000.000 | 538469.730 | 414213.785 | 318630.836 | 245104.372 | 188544.692 | 145036.585 |
| NPV = Sum of discounted cash flows | |||||||
| NPV Fijisawa = | 0.000 | ||||||
| Where | |||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||||
| Discounted Cashflow= | Cash flow stream/discounting factor | ||||||
| c. IRR= | 30.00% | ||||||
Accept project as NPV is positive