June 11, 2015

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

May 26, 2015

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 study. Definition Feasibility study is an objective and ...

May 24, 2015

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 functions. ROUND ROUNDUP ROUNDDOWN MROUND ...

April 21, 2015

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 held in rental income portfolio ...

April 20, 2015

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 up to current time period and ...

December 1, 2014

How to explain IRR to anyone? [video]

Explaining IRR (internal rate of return) to someone from non-finance background can be difficult. In the post on IRR, I explained the theory and calculation of IRR in much detail. However, many a time, when I talk to people from different disciplines I find it difficult to explain. Watch this ...

November 30, 2014

Real Estate Analyst Interview: Questions & Answers

Almost a year back I wrote the post about real estate analyst interview; it mostly covered the questions being asked. Many readers asked to provide the answer, but my job kept me busy and I was not able to write this post earlier. Thanks to Alexander Curry of Tarantino Properties, Inc, who ...

November 14, 2014

Does it make financial sense to invest in a property for AirBnB listing Income?

The short answer is “yes, it does make financial sense to invest in a property for AirBnB listing Income”, and the long answer will follow in this post. Be advised that this post is not about how to maximize profit or optimize your AirBnB listing. There are many authors who ...

November 13, 2014

Can Equity IRR be lower than Project IRR?

The post about Project IRR and Equity IRR became one of the most commented posts on this blog. Apart from the comments, I still receive tons of email asking me what the other circumstances are when the equity IRR will be lower than project IRR. In that post we considered ...

February 9, 2014

Discounted Cash Flow Analysis and Discount Rate

I have a funny story to tell – once I was explaining the result of a project feasibility analysis to our development team and one guy asked me to explain the calculation of net present value. So, I started explaining him in the simplest way possible. He was curious, so ...

Hello There!

Hello! and welcome to my blog. This is so exiting you are here.

I work as an investment analyst and here I blog about Real Estate Finance and Investment. I'm passionate about real estate and photography.

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

Or connect with me on Linkedin
• Featured Posts
• Popular Posts

Sign-up and Get Free Feasibility Reports

60 real-life feasibility study reports!