How Does Excel Calculate IRR?

Have you ever wondered how does Excel calculate irr (internal rate of return)? I never gave it a second thought until I wrote a post on the issues with NPV calculation in Excel. Our reader, Deyan, pointed out that a similar type of issue can exist with the IRR...

Rental Yield and Project IRR [Video]

Rental Yield and Project IRR Are Rental Yield and Project IRR related? Can we calculate the project IRR, if we know the rental yield? In the video, we discussed the relationship between rental yield & project IRR. If you have any thoughts, use the comment section...

Future Value Calculation in Excel

Future value calculation in Excel can be done either by using Excel FV formula or by manual calculation. Before we get into the calculations, let's review the concept of future value. We have discussed the time value of money earlier. To remind ourselves, the basic...

IRR Calculation in Excel [video]

IRR calculation can be done very easily. It can be calculated using three different formulas - IRR, XIRR and MIRR. We have discussed the syntax and specific use of each formulas in a previous post. On the request of our readers, we did a video on IRR calculation in...