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 30, 2013 | Uncategorized
This post talks about Excel Errors that are costing billions to businesses. We have all read about the Harvard economists Reinhart and Rogoff's most famous finding that countries with a debt exceeding 90 per cent of their annual GDP experienced slower growth than... 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 | Jul 15, 2013 | Real Estate
In this post, we will discuss the 10 things you should always remember while doing feasibility study Feasibility study is a critical part of a new development project. The purpose of the feasibility study is to determine whether the development is technically and...
