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 | May 24, 2015 | Excel, Formulas
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 their uses. You can download the Excel workbook from the link at the bottom which contains the examples of Excel round...
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... by Naiyer Jawaid | Dec 1, 2014 | Finance
In the post, I have explained the theory and calculation of IRR in detail. However, many a time, when I talk to people from different disciplines I find it difficult to explain. Explaining the internal rate of return to someone from a non-finance background can be...