by Naiyer Jawaid | Sep 8, 2015 | Real Estate, Valuation
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... 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. To remind ourselves, the basic... 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 readers, we did a video on IRR calculation in... 
by Naiyer Jawaid | May 26, 2015 | Finance, Real Estate
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 it. Definition... 
by Naiyer Jawaid | Apr 21, 2015 | Asset Classes, Asset Management, Excel, Real Estate
In the previous post on product mix optimization we learned to use the 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... by Naiyer Jawaid | Apr 20, 2015 | Excel, Finance, Formulas
Cash flow forecast is an important component of 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...
