In: Finance
A project has annual cash flows of $4,000 for the next 10 years and then $10,000 each year for the following 10 years. The IRR of this 20-year project is 11.63%. If the firm's WACC is 11%, what is the project's NPV?
Also, please show steps as to how to compute this problem using the BA II Plus financial calculator. Thank you!
Step-1, Calculation of Initial Investment Cost for the Project
The question has given he Internal Rate of Return [IRR] as 11.63%, IRR is the rate at which the present value of the annual cash flow equals to the initial Investment or it can say that at IRR, the present value of the annual cash flow = Initial Investment, or at IRR, NPV will be Zero
Initial Investment = Present Value of the annual cash inflows discounted at 11.63%
Year |
Annual Cash Flow ($) |
Present Value factor at 11.63% |
Present Value of Cash Flow ($) |
1 |
4,000 |
0.895817 |
3,583.27 |
2 |
4,000 |
0.802487 |
3,209.95 |
3 |
4,000 |
0.718881 |
2,875.53 |
4 |
4,000 |
0.643986 |
2,575.94 |
5 |
4,000 |
0.576893 |
2,307.57 |
6 |
4,000 |
0.516790 |
2,067.16 |
7 |
4,000 |
0.462949 |
1,851.80 |
8 |
4,000 |
0.414718 |
1,658.87 |
9 |
4,000 |
0.371511 |
1,486.04 |
10 |
4,000 |
0.332806 |
1,331.22 |
11 |
10,000 |
0.298133 |
2,981.33 |
12 |
10,000 |
0.267072 |
2,670.72 |
13 |
10,000 |
0.239248 |
2,392.48 |
14 |
10,000 |
0.214322 |
2,143.22 |
15 |
10,000 |
0.191993 |
1,919.93 |
16 |
10,000 |
0.171991 |
1,719.91 |
17 |
10,000 |
0.154072 |
1,540.72 |
18 |
10,000 |
0.138020 |
1,380.20 |
19 |
10,000 |
0.123641 |
1,236.41 |
20 |
10,000 |
0.110760 |
1,107.60 |
TOTAL |
42,039.88 |
||
“The Initial Investment cost will be $ 42,039.88”
Step-2, Calculation of the Net Present Value (NPV) of the Project
Year |
Annual Cash Flow ($) |
Present Value factor at 11.00% |
Present Value of Cash Flow ($) |
1 |
4,000 |
0.900901 |
3,603.60 |
2 |
4,000 |
0.811622 |
3,246.49 |
3 |
4,000 |
0.731191 |
2,924.77 |
4 |
4,000 |
0.658731 |
2,634.92 |
5 |
4,000 |
0.593451 |
2,373.81 |
6 |
4,000 |
0.534641 |
2,138.56 |
7 |
4,000 |
0.481658 |
1,926.63 |
8 |
4,000 |
0.433926 |
1,735.71 |
9 |
4,000 |
0.390925 |
1,563.70 |
10 |
4,000 |
0.352184 |
1,408.74 |
11 |
10,000 |
0.317283 |
3,172.83 |
12 |
10,000 |
0.285841 |
2,858.41 |
13 |
10,000 |
0.257514 |
2,575.14 |
14 |
10,000 |
0.231995 |
2,319.95 |
15 |
10,000 |
0.209004 |
2,090.04 |
16 |
10,000 |
0.188292 |
1,882.92 |
17 |
10,000 |
0.169633 |
1,696.33 |
18 |
10,000 |
0.152822 |
1,528.22 |
19 |
10,000 |
0.137678 |
1,376.78 |
20 |
10,000 |
0.124034 |
1,240.34 |
TOTAL |
44,297.89 |
||
Therefore, the Net Present Value (NPV) of the Project = Present Value of annual cash inflows – Initial Investment
= $44,297.89 - $42,039.88
= $2,258.01
“Hence, the Project’s Net Present Value (NPV) will be $2,258.01”
NOTE
The Formula for calculating the Present Value Factor is [1/(1 + r)n], Where “r” is the Discount/Interest Rate and “n” is the number of years.