In: Finance
roject L requires an initial outlay at t = 0 of $69,922, its expected cash inflows are $11,000 per year for 11 years, and its WACC is 11%. What is the project's IRR? Round your answer to two decimal places.
%_______________
IRR is the rate at which NPV is zero.
Lets compute NPV at 10% as shown below:
= - $ 69,922 + $ 11,000 / 1.101 + $ 11,000 / 1.102 + $ 11,000 / 1.103 + $ 11,000 / 1.104 + $ 11,000 / 1.105 + $ 11,000 / 1.106 + $ 11,000 / 1.107 + $ 11,000 / 1.108 + $ 11,000 / 1.109 + $ 11,000 / 1.1010 + $ 11,000 / 1.1011
= $ 1,523.671057
Lets compute NPV at 11% as shown below:
= - $ 69,922 + $ 11,000 / 1.111 + $ 11,000 / 1.112 + $ 11,000 / 1.113 + $ 11,000 / 1.114 + $ 11,000 / 1.115 + $ 11,000 / 1.116 + $ 11,000 / 1.117 + $ 11,000 / 1.118 + $ 11,000 / 1.119 + $ 11,000 / 1.1110 + $ 11,000 / 1.1111
= - $ 1,650.331421
It means the IRR lies between 10% and 11% since the initial investment of $ 69,922 is recovered between them and same is shown below:
= Lower rate + [ (Lower rate NPV / (Lower rate NPV - Higher rate NPV) ] x (Higher rate - lower rate)
= 10 + [ ($ 1,523.671057) / ($ 1,523.671057 - (- $ 1,650.331421) ] x (11 - 10)
= 10.47% Approximately
Feel free to ask in case of any query relating to this question