April 5, 2016
Incremental IRR is a way to analyze the financial return when there are two competing investment opportunities involving different amounts of initial investment. In this post we will explore how to calculate incremental IRR and how it helps in deciding between two projects with different investment. Let’s consider a project with ...

Read More »

March 29, 2016
Negative IRR indicates that the sum of post-investment cash flows is less than the initial investment; i.e. the non-discounted cash flows add up to a value which is less than the investment. So yes, both in theory and practice negative IRR exists, and it means that an investment loses money ...

Read More »

January 5, 2016
Hatched charts in Excel look beautiful. They look cool and professional. Hatching or shading between plotted lines enhances charts and helps to convey the story. Creating hatched charts in Excel is rather easy (I’m using Excel 2013). For this illustration we will be using following set of data: First hatched ...

Read More »

January 4, 2016
Many a time I’m requested to explain the relation between shareholder loan and the 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 a debt-like form of financing provided by the shareholders. ...

Read More »

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

Read More »

September 8, 2015
Transcript Residual land value is a land valuation tool based on simple economic concept that the land value is the surplus after development cost and profit have been deducted from the value of the completed development. So, Residual Land Value (RLV) = Value of the completed development – development costs ...

Read More »

August 19, 2015
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 premise of time value of ...

Read More »

August 17, 2015
Replacing links with values in Excel is a very useful tool. On many occasions before sharing our workbooks with external parties we prefer to replace the links with values. Links can be tricky - links to other workbooks can be in formulas, names, charts, text boxes, and other objects, both ...

Read More »

Stay in touch!


Hello There!

Feasibility Pro Hello! and welcome to my blog. This is so exciting you are here.

I blog about Real Estate Finance, Investment and Excel on Feasibility.pro.

I love to meet new people and share knowledge. Mail me if you would like to get connected, or read more about me.

Or ask me anything about real estate onQuora Real Estate

Or connect with me on Linkedin View Naiyer Jawaid's profile on LinkedIn