320 likes | 483 Views
Introduction to Discounted Cash Flow Analysis. by James R. DeLisle, Ph.D. March 18, 2014. Lecture Preview. DCF Prelude: Frontdoor /Backdoor. The Value Proposition: Value => Cost?. Value ??. Value = Income Rate. Land & Hard Costs. Known Soft Costs & Fee Costs.
E N D
Introduction to Discounted Cash Flow Analysis byJames R. DeLisle, Ph.D.March 18, 2014
The Value Proposition: Value => Cost? Value ?? Value = Income Rate Land & Hard Costs Known Soft Costs & Fee Costs $’s Cost = Create Value Unknown Fees TRCm TRCm = Total Replacement Cost market
FD/BD Value Proposition: Cost < >Value ? Value * Rate = Income User Value * Rate Income Frontdoor Backdoor Value<= Income Rate Value * Rate => Income
Frontdoor Model: Sequence TRCm * Wcc GIr NIr / NIR Land Hard & Soft Costs NIR = 1 – (Er + Ptx + Vr) TRCm
Backdoor Model: Reverse Engineered TRCj /Wcc GIm / NIR NIm Land NIR = 1 – (Er + Ptx + Vr) Hard & Soft Costs TRCj
M a r k e t Backdoor to Unleveraged DCF Analysis TRCm / Wcc GIm * NIR NIm Land Hard & Soft Costs TRCm
Frontdoor/Backdoor vs. DCF Frontdoor/Backdoor Discounted Cash Flow Non-annuitized Leveraged/Unleveraged Present Value (TVM) After-tax After Sale • Annuitized • Leveraged/Unleveraged • Constant Dollars • Before Tax • Before Sale
Equity Justified: PV of CF + PV Net Reversion PV CF + NIr GIr
Net Reversion Sales Price - Sales Exp Net Sales Price CG Appr x 15% Appreciation TRCm Land Value Depreciation CG Depr x 25% Mortgage Amortization Net Reversion Stabilized NOI Pb NIr GIr
Equity Justified: PV of CF + PV Net Reversion - Sales Exp - Tax on Sale - Mtg. Bal. Sales Price = Ej Net Reversion PV NR PV CF + NIr GIr
Cash Flow: The One Key Word GI NI TI BT AT NR Gross Income Net Income Taxable Income Before Tax Cash Flow After Tax Cash Flow Net Reversion
DeprLife 39 CGTxR 15.00% CGTxV 25.00% Selling Expense Exit Cap Rate Cash Flow Variables and TRC/FD/BD Inputs
Discounted Cash Flow and Financial Ratios • Schedule I: Cash Flow • Schedule II: Depreciation • Schedule III: Loan Amortization • Schedule IV: Net Reversion • Schedule V: Capital Gain Tax • Schedule VI: Financial Ratios
Schedule II: Depreciation $3,436,567*(1/39) = $88,117
Schedule III: Loan Amortization Calculate Payment Calc. Principal Balance Calc. Prin. Reduction Calc. Interest
Schedule I: BTCF to ATCF If TI > 0, -TI * MtxR If TI < 0, TI * MtxR
Schedule IV-V: CGTaxes on Sale & AT Proceeds Schedule IV: AT Proceeds Schedule V: Capital Gain Tax On Sale If, CapGain * 15% AccDepr * 25%
DCR: 1.3 Target Debt Coverage Ratio • Interpretation • DCR provides a measure of the safety of the mortgage position, indicates the cushion between required payments and NOI. • DCR’s should normally be 1.2 or more • Equation