by Naiyer Jawaid | Aug 17, 2015 | 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,... 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 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 | Nov 14, 2014 | Excel, Real Estate
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...
