by Naiyer Jawaid | Aug 18, 2013 | Excel, Finance, Formulas
A 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 loan amortization schedule using... 
by Naiyer Jawaid | Aug 12, 2013 | Finance, Formulas
MIRR Formula 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 don't we always calculate... 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 in general, you must see this post NVP &... by Naiyer Jawaid | Jun 15, 2013 | Excel, Finance
Sometimes calculating project IRR and equity IRR can be tricky, and in this post we will discuss the reasons for the same. The internal rate of return (IRR) can be defined as the rate of return that makes the net present value (NPV) of all cash flows equal to zero. In... 
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 shocked.... by Naiyer Jawaid | Jan 31, 2013 | Excel, Finance
Defining Feasibility Analysis Feasibility analysis can mean different things to different people. Let's first define the term feasibility. The word "feasibility" is derived from "feasible", which simply means capable of being done or accomplished. And feasibility...
