Last version published: 05/10/2016 13:47
Publication number: ELQ-10246-2
View all versions & Certificate
Discounted Cash Flow (DCF) Analysis with IRR and NPV
Several spreadsheets that can be used for the analysis of a real estate investment from various perspectives
The cash flow module includes the cash flow module inputs which provide the output summarized on the acquisition info, cash flow proforma for up to 10 years, sales proceeds and yields. The yields are provided as IRRs, internal rates of return. There is also a NPV, net present value page based upon a required rate of return and assuming a reasonable mortgage value as provided.
The IRR and NPV results are not realistic if the mortgage assumptions don't make sense. That is the analyst must be able to meet the objectives of the investor, lender, and tenants.
Investor objectives might include a target required rate of return, a given cash on cash return in the early or later years, a certain dollar NPV or other criteria.
Lender objectives might include a reasonable minimum DCR, debt coverage ratio, in the first year and beyond, and a reasonable LTV, loan to value ratio.
Tenant objectives are usually related to occupancy cost, minimizing the present value of occupancy but non- quantitative objectives may also come into play.
Developer objectives, not directly considered here, may be related to wealth creation where value exceeds costs.
If the investor is typical in terms of market parameters, such as tax rates, interest rates, LTV and required yields then the resulting values using discounted cash flow models should be similar to the values using the appraisal techniques. If they are not then the assumptions of one or the other don't make sense.
- Prof. Norm Miller, PhD, Jan 2011
This business tool includes
1 Excel Model Spreadsheet
Prof. Norm Miller PhD offers you this business tool for free!
download for free
Add to bookmarks
- Steven King(last updated: 20/06/2018 21:50)
- Peter Lu(last updated: 17/06/2018 08:19)
- Ulisses Correia(last updated: 14/06/2018 03:25)
- Kevin Soon(last updated: 12/06/2018 10:43)
- JIHUAN HU(last updated: 10/06/2018 23:48)
- Paya Danesh(last updated: 10/06/2018 07:57)
- Emmanuel Dasi(last updated: 05/06/2018 04:20)
- Carlos Anaya Garay(last updated: 29/05/2018 04:16)
- Jason Robbie(last updated: 27/05/2018 15:09)
- YUQI LIU(last updated: 22/05/2018 09:59)
- 兆基 邓(last updated: 22/05/2018 09:54)
- Earnest Prashanth Sikhamani(last updated: 16/05/2018 03:02)
- Francis Kunina(last updated: 15/05/2018 09:00)
- K.M.FARHAD ALAM(last updated: 14/05/2018 10:01)
- Tony Intal(last updated: 10/05/2018 09:03)
- Ralph Martelly(last updated: 09/05/2018 19:59)
- Daelan Subban(last updated: 28/04/2018 08:25)
- DW(last updated: 22/04/2018 07:38)
- J Vincent(last updated: 15/04/2018 08:57)
- Kunle Ogundijo(last updated: 05/04/2018 14:40)
- Mohammed Halaseh(last updated: 27/03/2018 09:05)
- Bernice King(last updated: 21/03/2018 14:56)
- Mohammed Ali Moten(last updated: 03/03/2018 18:30)
- Stanley WU(last updated: 17/02/2018 18:16)
- Matteo Cattaneo(last updated: 25/01/2018 08:39)
- Pratik Balijepalli(last updated: 19/01/2018 15:43)
- Alfonso Cioffi(last updated: 31/12/2017 14:15)
- Waskito Adinugroho(last updated: 13/12/2017 09:50)
- Mamadou Dr. Bass(last updated: 29/09/2017 09:38)
- Hong Nhat Tran(last updated: 17/08/2017 11:32)
People using this tool also downloaded
Real-Estate Investment Excel CalculatorThis tool will help newcomers to real-estate investment evaluate and analyse their potential real-estate investments.npvirrdcfreal estatereal estate financereal estate investmentproperty portfolioreal estate metricsreal estate beginner508 remove_red_eyefreeby Teddy Smith
Leveraged Buyout LBO Model - DCFA comprehensive LBO model in excel of business acquisitionacquisitionbusinessfinanceleveraged buyoutirrcash flowsdcfcapmlbo analysislbo model1,697 remove_red_eye
Sensitivity Analysis Using ExcelIn this video you will learn how to carry out sensitivity analysis using Excel.analysisfinancesensitivitydcfsensitivity analysisdiscounted cash flowexcel123 remove_red_eye
DCF Valuation Model TemplateThis template provides you with a foundation to build your own discounted cash flow model with different assumptions.financedcffinancial modeldiscounted cash flowdcf modeldiscounted cash flow model436 remove_red_eye
Discounted Cash Flow (DCF) ModelA step by step Discounted Cash Flow Analysis Tutorial (DCF model)analysisfinancevaluationdcfprivate equityinvestment bankingdiscounted cash flowvalue of a businessdcf model16,315 remove_red_eye
Cash Flow Waterfall ModelA cash flow model for Real Estate based on a waterfall structurefinancecash flowreal estatewaterfallinvestordeveloper5,284 remove_red_eye
Quarterly Leveraged Buyout LBO ModelAn LBO model illustrating a number of detailed analytical techniques to construct an acquisition LBO model with historyacquisitionmergerfinanceleveraged buyoutdcflbom&atransactionsbooklbo analysis758 remove_red_eye
NPV and IRR CalculationA model for calculating Net Present Value and Internal Rate of Return.financenpvirrfinancial modelnet present valuecalculationinternal rate of return1,242 remove_red_eye
Business Valuation Excel Model with Economic Value AddedBusiness and investment valuation model with economic value added (EVA) calculations.financevaluationdcfevaeconomic value addeddiscounted cash flow205 remove_red_eye
Calculating Discounted Cash Flow in ExcelThis video takes you through a DCF Excel model to show you how to calculate Discounted Cash Flow.financevaluationstockassetsdcfwaccdiscounted cash flowliabilitiesdcf modelfcf212 remove_red_eye
Discussion feed for Discounted Cash Flow (DCF) Analysis With IRR And NPV
The user community and author are here to help. Go ahead!
- Can someone help me understand row 48? What is the line and the computation doesn't make sense for me.arrow_drop_uparrow_drop_downReply reply
- Does anyone have a DCF/Proforma that incorporates a construction period loan and then a refinanced stabilized period? Would like to incorporate a hurdle rate into the waterfall if possible. Please advise.arrow_drop_uparrow_drop_downReply reply