Select Page

How to Create Loan Amortization Schedule in Excel?

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...

Why we don’t use Excel’s 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 MIRR or use...

IRR Calculation in Excel: Formulae and Use

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...

Project IRR and Equity IRR: A Curious Connection

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...

Product Mix Optimization

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....

NPV & IRR – Key Metrics of a Feasibility Analysis

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...
WAIT
I have a FREE gift for you

Do you want FREE Beginners' Guide to Real Estate Financial Terms?