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
- 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)
- Raffaella Pirrello(last updated: 02/05/2017 14:10)
- lmao atyou(last updated: 20/03/2017 02:53)
People using this tool also downloaded
Leveraged Buyout LBO Model - DCFA comprehensive LBO model in excel of business acquisitionacquisitionbusinessfinanceleveraged buyoutirrcash flowsdcfcapmlbo analysislbo model1,390 remove_red_eye
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 beginner59 remove_red_eyefreeby Teddy Smith
Quarterly Leveraged Buyout LBO ModelAn LBO model illustrating a number of detailed analytical techniques to construct an acquisition LBO model with historyacquisitionmergerfinanceleveraged buyoutdcflbom&atransactionsbooklbo analysis596 remove_red_eye
NPV and IRR CalculationA model for calculating Net Present Value and Internal Rate of Return.financenpvirrfinancial modelnet present valuecalculationinternal rate of return25 remove_red_eye
Cash Flow Waterfall ModelA cash flow model for Real Estate based on a waterfall structurefinancecash flowreal estatewaterfallinvestordeveloper3,790 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 model6,677 remove_red_eye
The Discounted Free Cash Flow (DCF) ModelA full discounted cash flow excel model for a complete businessfinancevaluationpresent valueassetsdcfdiscounted cash flowcomplete business1,190 remove_red_eye
Conversion of rent to the minimum affordable home or condo priceDetermine the price of a home/condo that would be equivalent to the after tax cost of paying a rentfinancereal estatepersonal financeinvestingconversionhomecondorent157 remove_red_eye
Discounted Cash Flow (DCF) Model (Academic Quality)A simple DCF model serving as an academic exercise to understand how financial modeling works.financevaluationcorporate financedcfdiscounted cash flowmbamergers and acquisitions1,006 remove_red_eyefreeby Joshua Wong
Planeamatic: Financial modeling made easyPowerful, flexible, reliable and friendly financial models in minutescash flowvaluation modelirrdcfscenariosfinancial modelproject valuationfinancial modelingbreak-even pointfinancial models116 remove_red_eyefreeby Jose Corona
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