by Naiyer Jawaid | Nov 17, 2013 | Finance
Use of debt financing is a standard practice in the real estate investing; and is often referred to as leveraging. Debt financing is used by the equity holders to enhance the equity return; however, debt financing can also magnify the severity of capital loss if the...
by Naiyer Jawaid | Sep 14, 2013 | Asset Management, Finance, Real Estate
Effective Rent is defined as the remaining cash the landlord receives after paying all expenses for operating the property, and any costs for tenant work to get the space ready for occupancy. Effective rent is also often referred to as Net Effective Rent (NER).... by Naiyer Jawaid | Aug 30, 2013 | Finance, Real Estate
Financial calculator is a must have for any real estate analyst. It should be kept in mind that you are more likely to use spreadsheets (or custom software) for more advanced analysis. Excel is far more powerful than any hand-held financial calculator; and while doing... by Naiyer Jawaid | Aug 19, 2013 | Finance
Net present value (NPV) is defined as the sum of the present values of the individual cash flows (both incoming and outgoing) of a series of cash flows. In other words, it is the current worth of a future sum of money or stream of cash flows at a certain discount... 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...