**Defining Feasibility Analysis**

**Feasibility analysis** can mean different things to different people. Let’s first define the term feasibility. The word “feasibility” is derived from “feasible”, which simply means capable of being done or accomplished. And feasibility studies aim to logically find the strengths and weaknesses of a proposed project, opportunities and the resources required to carry through, and ultimately the prospects for success.

There can be various types of feasibility studies - Technical, Economic, Legal, Operational and Scheduling. It is represented by the acronym TELOS.

When we talk about the feasibility analysis of a real estate project, we mostly talk about economic feasibility or financial feasibility. It is not so that we ignore the other factors in a real estate feasibility study. Most often we incorporate all of them in the economic feasibility. The final result of a real estate feasibility analysis is inclusive of technical, legal, operational and scheduling feasibility studies.

**Key Metrics of a Feasibility Analysis **

When we look at the final outcome of a feasibility analysis we look at the key metrics to judge the project’s merit. What should be included in the key metrics depends on the type of project, funding strategy and legal structure. The most common metrics include Net Present Value (NPV), Internal Rate of Return (IRR), Developer’s Margin and Return on Equity (RoE).

In this post we are going to cover the most basic of them - Net Present Value (NPV) and Internal Rate of Return (IRR).

**What are NPV and IRR? **

NPV and IRR are two very basic metrics of a feasibility analysis. They are easy to understand and it is fun to work with them.

The Net Present Value (NPV) is defined as the sum of the present values of the individual cash flows (both incoming and outgoing) of a series of cash flows. And then we ask what the Present Value is. The Present Value is defined as the current worth of a future sum of money or stream of cash flows at a certain discount rate.

Ok, then what is the discount rate? Discount rate is a rate at which we discount the future cash flows to find present value. It can be your cost of capital, cost of equity, desired rate of return, hurdle rate or even the interest rate a central bank charges depository institutions. We will have a separate post entirely dedicated to discount rate.

And what is IRR then? IRR is a rate of return at which the project’s NPV becomes zero.

**What if you are a New Comer?**

It may all sound very confusing if you are a new comer. When I explain these terms, some people complain that it is like a circular reference in Excel.

Worry not. The professor who taught us finance is a very interesting person. When the class was over, he asked us to define NPV and IRR. Most of us gave definitions similar to the above. He said, “Think as if I am your grandmother and now explain it to me”.

So I’m going to take same approach.

Suppose you have 100 $. You can either consume it or save it for future consumption. When you choose to save it for future consumption, you will deposit it with a bank. Bank will be paying you some interest. Assume that bank is paying 5% interest annually and you will be withdrawing the interest payouts. Your cash flow will looks like this:

You deposited 100$ and after one year you got 105$. What does it mean? It means that 105$ next year is worth 100$ today.

This is the concept of present value. Calculating present value means finding the worth of future cash flow as of today.

And the interest rate we used here is referred to as “Discount Rate” in present value calculation.

What is Net Present Value? It is the sum of present value less the initial outlay.

Now suppose you deposited this 100$ in a deposit scheme where the interest rate is 5%, the term is 5 years and there will be usual interest payout. What will be the present value and what will be the net present value?

First, let’s understand IRR. Assume a residential building project of cost 100$. The project is constructed in a year and from the next year we are receiving rental income of 7$. We will be selling the building at the end of 5^{th} year for 130$. What is the IRR?

Your cash flows will look like this:

We will now find the present value of each cash flow. We will assume a discount rate of r%.

Initial Year (Amount -100$): = -100/(1+r)^0

1^{st} Year (Amount 7$): = 7/(1+r)^1

2^{nd} Year (Amount 7$): = 7/(1+r)^2

3^{rd} Year (Amount 7$): = 7/(1+r)^3

4^{th} Year (Amount 7$): = 7/(1+r)^4

5^{th} Year (Amount 7$): = 7/(1+r)^5

5^{th} Year (Amount 130$): = 130/(1+r)^5

Net present value will be the sum of all of these.

Net Present Value = -100/(1+r)^0 + 7/(1+r)^1 + 7/(1+r)^2 + 7/(1+r)^3 + 7/(1+r)^4 + 7/(1+r)^5 + 130/(1+r)^5

Equating this to zero and solving for r will give us the IRR.

0 = -100/(1+r)^0 + 7/(1+r)^1 + 7/(1+r)^2 + 7/(1+r)^3 + 7/(1+r)^4 + 7/(1+r)^5 + 130/(1+r)^5

r = 11.75%

This is the IRR

Note that IRR is independent of discount rate. In fact it is a discount rate at which NPV becomes zero.

**Calculating NPV and IRR in Excel**

We use NPV and IRR functions in Excel and we will use the above example for the same.

First we will calculate the present value manually i.e. using the formula PV = A/(1+r)^t. The sum of the all the present value will give us the Net Present Value.

Now we will use NPV formula of Excel. You can either type =npv in a cell or go to insert>Formulas>Insert Functions

Once you clicked Insert Functions, the function window will appear. Select Financial, and from the list select NPV and press OK.

Now the NPV formula window will appear. In the rate box, select the cell containing the discount rate. And in the value 1, you can select the cell range containing the cash flows. Don’t include the initial cash out lay. It will give you 107.26$ as the formula result.

Now subtract the initial layout i.e. the project cost by going to the cell.

Now, let us find IRR by using Excel IRR function. Go to insert>Formulas>Insert Functions; Select Financial, and from the list select IRR and press OK.

In the value field, select the cash flow range including the initial layout. Leave the Guess field empty, Excel will assume 10% by default.

Press ok and now you have the IRR.

Calculating IRR in Excel is much easier as compared to solving the above equation for “r”.

Hope you enjoyed the post. In coming weeks we will discuss some advance topic related to NPV and IRR.

What do you think, use the comment section below.

naman says

beautifully explained..!

thank you

ysurender says

Simple crisp fantastic explanation !

Ali Pourbozorgi says

Dear Sir

Thank you for your invaluable explanations. I just have one question, on the first example of NPV , should the NPV be equal to zero or $25?

Thank you in advanced

Ali

Ali says

Beautifully explained!!!!

Muhammad Ijaz says

Thank you sir, nicely explained.

Saravanan says

Excellent!! Anybody can understand about IRR and NPV with your above article.

Thanks

Deepti says

Thanks Naiyer…Key Metrics Simplified… Cheers Deepti

Chris Albert says

wonderful.. will be using this article in my study as i prepare for financial projections of my dad’s business.

PS says

Naiyer, when you are finding the present value of each cash flow in your example, should it not be

“5th Year (Amount 130$): = 130/(1+r)^5”, rather than “5th Year (Amount 130$): = 7/(1+r)^5”

I.e. 130 not 7?

Cheers

Naiyer Jawaid says

Thanks PS. Corrected.

amrita says

hi,

can you please also explain how can you calculate IRR in excel

Regards,

Amrita

Naiyer Jawaid says

It is explained in this post itself Amrita. If you any specific question, please let me know.

Sandip Tiwari says

very well explained sir!

Abu V says

Simple explanation and well presented

Ayman says

In feasibility study IRR

In the case of the Project financing by loan we must added the loan value in cash inflows or not please explan

Ashi says

Really helpful lesson

thank you very much

naresh says

excellent explanation ……

Ruhul amin says

Dear sir

Thanks for good explanation.

Regards

Ruhul amin

Adeel Rehman says

Simple but Excellent explanation. I wish you to explain using complex situations.

Thanks A Lot.

RAJENDRA JAIN says

Sir,

Hi I got great understanding from your Blog.I Came to know that interest during construction period (IDC) should not be included in PROJECT COST while calculating project IRR .

I have just query why IDC is excluded and reason for the same