In: Finance
29. The Steel Factory is considering a project that will produce cash inflows of $44,400 a year for five years. What is the internal rate of return if the initial cost of the project is $135,000?
15.45 percent 19.25 percent 11.95 percent 17.65 percent 13.15 percent
15.Chance, Inc. is considering a project with an initial cost of $1.02 million. The project will not produce any cash flows for the first two years. Starting in year 3, the project will produce cash inflows of $663,000 a year for 5 years. This project is risky, so the firm has assigned it a discount rate of 23.9 percent. What is the net present value?
Solution:- | ||||||
29) | Ans:- IRR of prject = 19.25% | |||||
Claculation of project IRR | ||||||
We have taken 19% and 20% discount factor for hit and trial method. | ||||||
Year | cash flow | PVF at 19% | Present value | PVF at 20% | Present value | |
A | B | C | D=B*C | E | F=B*E | |
1 | $44,400.00 | 0.84033613 | $37,310.92 | 0.833333 | $37,000.00 | |
2 | $44,400.00 | 0.70616482 | $31,353.72 | 0.694444 | $30,833.33 | |
3 | $44,400.00 | 0.59341581 | $26,347.66 | 0.578704 | $25,694.44 | |
4 | $44,400.00 | 0.49866875 | $22,140.89 | 0.482253 | $21,412.04 | |
5 | $44,400.00 | 0.41904937 | $18,605.79 | 0.401878 | $17,843.36 | |
Total | $135,758.99 | $132,783.18 | ||||
We have to use hit and trial method. | ||||||
PV of cash inflow at 19% =$135,758.99 | ||||||
PV of cash inflow at 20%= $132,783.179 | ||||||
The IRR of the project can be calculated as follows:- | ||||||
IRR=Lower DR+ Difference b/w DRs{[PVCF of lower DR-initial investment]/Absolute difference B/w DRs cash flow.} | ||||||
Where, DR stands for discount rate | ||||||
PV stands for present value | ||||||
B/W stands for between. | ||||||
Now substituting values we get | ||||||
= 19%+1%{(135,758.99-135,000)/(135,758.99-132883.179) | ||||||
=19%+0.25% | ||||||
=19.25% | ||||||
15) | Calcualtion of NPV | |||||
Year | cash flow | PVF at 23.9% | Present value | |||
A | B | C | D=B*C | |||
0 | -$1,020,000.00 | 1 | -$1,020,000.00 | |||
1 | $0.00 | 0.8071025 | $0.00 | |||
2 | $0.00 | 0.65141445 | $0.00 | |||
3 | $663,000.00 | 0.52575823 | $348,577.71 | |||
4 | $663,000.00 | 0.42434078 | $281,337.94 | |||
5 | $663,000.00 | 0.34248651 | $227,068.56 | |||
6 | $663,000.00 | 0.27642172 | $183,267.60 | |||
7 | $663,000.00 | 0.22310066 | $147,915.74 | |||
NPV | $168,167.54 | |||||
NPV of project = PV of inflows -PV of souflows | ||||||
=$168,167.54 ( as calculated above) | ||||||
Please feel free to ask if you have nay query in the comment section. |