In: Finance
Pro Physical Therapy is considering purchasing a new machine that will allow them to do preliminary MRIs for their patients. This project will require an initial outlay of $78,635. The machine will have an expected life of 5 years and will generate additional cash flows to the company as a whole of $21,500 at the end of each year over its 5 year life. In addition to the $21,500 cash flow from operations, during the 5th and final year there will be additional cash flow of $13,200 at the end of the 5th year associated with the salvage value of the machine, making the cash flow in year 5 equal to $34,700. Given a required rate of return of 12%, calculate the following: a) IRR (6pts) b) NPV (6pts) c) PI (6pts) d) Is the project acceptable and why? (2pts)
a
Project | ||||||
IRR is the rate at which NPV =0 | ||||||
IRR | 19.80% | |||||
Year | 0 | 1 | 2 | 3 | 4 | 5 |
Cash flow stream | -78635.000 | 21500.000 | 21500.000 | 21500.000 | 21500.000 | 56200.000 |
Discounting factor | 1.000 | 1.198 | 1.435 | 1.720 | 2.060 | 2.468 |
Discounted cash flows project | -78635.000 | 17945.900 | 14979.317 | 12503.131 | 10436.276 | 22770.376 |
NPV = Sum of discounted cash flows | ||||||
NPV Project = | 0.000 | |||||
Where | ||||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||
Discounted Cashflow= | Cash flow stream/discounting factor | |||||
IRR= | 19.80% |
b
Project | ||||||
Discount rate | 12.000% | |||||
Year | 0 | 1 | 2 | 3 | 4 | 5 |
Cash flow stream | -78635 | 21500 | 21500 | 21500 | 21500 | 56200 |
Discounting factor | 1.000 | 1.120 | 1.254 | 1.405 | 1.574 | 1.762 |
Discounted cash flows project | -78635.000 | 19196.429 | 17139.668 | 15303.275 | 13663.639 | 31889.389 |
NPV = Sum of discounted cash flows | ||||||
NPV Project = | 18557.40 | |||||
Where | ||||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||
Discounted Cashflow= | Cash flow stream/discounting factor |
c
PI= (NPV+initial inv.)/initial inv. |
=(18557.4+78635)/78635 |
1.24 |
d
Accept project as IRR is more than discount rate |
Accept project as NPV is positive |
Accept project as PI is more than 1 |