Answer:
IRR = 11.65%
Explanation:
Period Cash Flow
0 -400,000
1 110,000
2 110,000
3 110,000
4 110,000
5 110,000
We could list the annual cash inflow and solve using the excel formula
IRR 0.11649
Or if we aren't allowed to do so, use maths
The way to obtain the present value would be:
Annuity x factor = PV
If we know know the rate we can look into the table doing:
factor = PV/annuity
We know Project Soup is 5 year so we look into this row:
400,000/110,000 = 3.6363
The rate wold be between 11% 3.696 and 12% 3.605
Those rate are close to our goal of 3.6363
We could solve an approximation doing excel or working with math:
[tex]\left[\begin{array}{cc}X&Y&\\x_0 = 3.696&y_0 = 0.11&x=3.6363&?&x_1=3.605&y_1 =0.12\end{array}\right][/tex]
[tex]y = y_0 +\frac{y_1-y_0}{x_1-x_0} (x-x_0)[/tex]
We got from the table, the 2 rates which are close to our goal, and thetwo factor close to our goal. we post each value into the formula and solve:
[tex]y = 0.11 +\frac{.12-.11}{3.696-3.605} (3.6363-3.605)[/tex]
[tex]y = 0.11 +\frac{0.01}{0.091} (0.0313)[/tex]
y= 0.1165 = 11.65%