In: Finance
You are considering a project with an initial cash outlay of $85,000 and expected free cash flows of $20,000 at the end of each year for 5 years. The required rate of return for this project is 9 percent.
a. What is the project's payback period?
b. What is the project's
NPV?
c. What is the project's
PI?
d. What is the project's
IRR?
a. The project's payback period is _____years. (Round to two decimal places.)
b. The project's NPV is $______ .(Round to the nearest cent.)
c. The project's PI is ? (Round to three decimal places.)
d. The project's IRR is ______%.
(Round to two decimal places.)
(a)-Project's payback period
Project's payback period = Initial Investment cost / Annual cash inflow
= $85,000 / $20,000
= 4.25 Years
(b)-Project's Net Present Value (NPV)
Year |
Annual Cash Flow ($) |
Present Value factor at 9% |
Present Value of Cash Flow ($) |
1 |
20,000 |
0.917431 |
18,348.62 |
2 |
20,000 |
0.841680 |
16,833.60 |
3 |
20,000 |
0.772183 |
15,443.67 |
4 |
20,000 |
0.708425 |
14,168.50 |
5 |
20,000 |
0.649931 |
12,998.63 |
TOTAL |
77,793.03 |
||
Net Present Value = Present value of annual cash inflows – Initial investment cost
= $77,793.03 - $85,000
= -$7,206.97
(c)-Project's Profitability Index (PI)
Project's Profitability Index (PI) = Present value of annual cash inflows / Initial investment cost
= $77,793.03 / $85,000
= 0.915
(d)-Project's Internal Rate of Return (IRR)
The Present Value factor for determining IRR = Net Initial Investment / Net Annual Cash Inflow
= $85,000 / $20,000
= 4.25000
From the Present Value Annuity Factor Table (PVAIF Table), the discount rate (IRR) corresponding to the factor of 4.25000 for 5 Years is 5.67%
“Hence, the Internal Rate of Return (IRR) for the Project will be 5.67%”
NOTE
The formula for calculating the Present Value Inflow Factor (PVIF) is [1 / (1 + r)n], where “r” is the Discount Rate/Cost of capital and “n” is the number of years.