by Naiyer Jawaid | Jan 4, 2016 | Finance
Many a time I'm requested to explain the relationship between shareholder loan and equity IRR. Should shareholder loan be part of equity IRR calculation? And if there are more than one equity investor, what should we do! Shareholder loan is... by Naiyer Jawaid | Oct 5, 2015 | Excel, Finance, Formulas
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... by Naiyer Jawaid | Sep 13, 2015 | Finance, Real Estate
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... by Naiyer Jawaid | Aug 19, 2015 | Excel, Finance, Formulas
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.... by Naiyer Jawaid | Jun 11, 2015 | Excel, Finance
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...
