Select Page

# NPV Calculation in Excel: Why the Numbers do not Match!

NPV calculation in Excel can be tricky. I have written few posts on this subject - NVP & IRR – Key Metrics of a Feasibility Analysis and Net Present Value and Returns to the Equity Holders. I recommend that you read them too. The basics of net present value (NPV)...

# Rental Yield and Project IRR [Video]

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

# Residual Land Value [Video]

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...

# 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...

# Replacing Links with Values in Excel

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,...

# IRR Calculation in Excel [video]

IRR calculation in Excel 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 requests of our readers we did a video on IRR...

# Feasibility Study: Technical Notes & Discussion

Feasibility study is the assessment, analysis and evaluation of a planned project to determine if it is technically feasible within the estimated cost and will be financially profitable. In this post we will discuss everything under the sun related to the feasibility...

# Excel Round Function: All You Need to Know

Excel Round Functions are used on daily basis by every Excel users. In this post we will discuss various Excel round functions, their syntaxes and uses. You can download the Excel workbook from the link at the bottom which contains the examples of Excel round...

# Product Mix Optimization for Rental Properties

In the previous post on product mix optimization we learned to use Excel solver tool to optimize mixed-use real estate development. The main assumption in that post was that the products will be sold. Many readers asked a similar model where the properties will be...

# Cash Flow Forecast: Adjusting for Actuals

Cash flow forecast is an important component of the project finance modeling. Properly done cash flow forecast enables the firm to manage its fund and search for external funding in case of shortage. As the project progresses, we update the projections for the actuals...

#### Hello There!

Hello! and welcome to my blog. This is so exciting you are here.
I blog about Real Estate Development, 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 on Quora Or connect with me on Linkedin You can contribute to this blog by participation in our forum or by writing for us.

## Wait

### I want to teach you how to conduct feasibility studies!

Enter you email to know more!