How Do You Find An Irr On An Initial Investment Of $300,000.00?

IRR is the discount rate where all the present/future cash inflows are equal to the future cash outflows. In this case, you have mentioned your initial investment. But you have to compare it with the future return(cash inflows) that you are going to receive out of this investment.
You find IRR by comparing all the future cash inflows and outflows that are expected in the future when you undertake a project.You need to calculate NPV or the net present value of investment first. Initial investment is always taken as negative. NPV is calculated by using the following formula
NPV = n
NPV(C, t, d) = Sum Ci/(1+d)^ti
i=0
Where
Ci = i-th cash flow
C0= 1st cashflow
Cn = last cashflow
d = assumed discount rate.
Ti = time between the 1st and the and the i-th cashflow.

If the NPV is positive, you can go for this investment.
Caluclate IRR for it by interpolation method. That is, use a hypothetical discount rate for which the NPV is positive but close to zero. Then again, use another discount rate for which the value of NPV is negative, but again close to zero. Now you have got two discount rates (assumed). Use interpolation to get the real IRR.
Or you can also solve the NPV equation, with assumed discount rates, until you get Zero NPV. That discount rate will be equal to IRR.

Add Comment

Report