by Naiyer Jawaid | Aug 18, 2013 | Excel, Finance, Formulas
Loan amortization schedule in Excel can be created either by using a template or creating a custom schedule - the easiest method will be using the template which is already in your Excel package. Alternatively, we can create a custom... 
by Naiyer Jawaid | Aug 12, 2013 | Finance, Formulas
In the previous post we discussed various excel formulas to calculate IRR, and we know for sure that the modified internal rate of return (MIRR) is a better performance indicator than the internal rate of return (IRR). But why... by Naiyer Jawaid | Jul 22, 2013 | Challenge, Excel, Finance, Formulas
IRR calculation in Excel can be done using three different formulae - IRR, XIRR and MIRR. In this post we will be discussing syntax and specific use of each formula. If you want to understand the basic of IRR calculation... 
by Naiyer Jawaid | Feb 1, 2013 | Asset Classes, Excel, Finance, Formulas, Real Estate
Product Mix Optimization for real estate developments can be tricky; we often come across this type of discussions in the board room: "I want more retail space!", shouted the retail director frantically. Everyone in the meeting was silent and somewhat...
