Create Presentation
Download Presentation

Download Presentation
## Valuation using cash flows

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -

**Valuation using cash flows**By jenniferkellner (Discount, Variety Stores Industry)**Discount, Variety stores industry**Target Dollar General Wal-Mart Costco *Costco is least comparable**Objective: estimate the intrinsic value of target**• To do so, we use the Discounted Cash Flow model: • STEPS • Review assumptions & multiyear forecasts from Module 4 • Determine FCF 2014 – 2017 using the above • Discounted cash flow model • = Enterprise Value ?**Step: Review forecasts and assumptions**• Security breach, lower 2014 forecasted sales • Use this as a basis to determine FCF • NOTE: FCF = EPAT – ΔNEA • *A central assumption for our model**Step 2: determine FCF**(Using: FCF = EPAT – ΔNEA) • Note that ΔNEA is positive above in each year & expected to keep increasing • Target expansion via Canada, SuperTarget remodeling, additional city stores • Note also that Target owns most stores (fewer operating leases)**Step 3: discounted cash flow model**Discount Rate (Bloomberg Terminal): 6.80% • 2,766 = First yrof growing perpetuity grown at 4.6% • Divide this by the DR less sales growth rate • Discount back 4 years (assumed B.O.Y.) = 96,638 • Add Sum of PV cash flows to arrive at value of the firm**Target:**• 105,248 Enterprise Value of the firm**Uncertainties**• Why this value is likely inaccurate • Discount rate • Still an assumption, can change value dramatically • Sales growth rate • Also an assumption • Justifiable but lacks accuracy • Especially: current Target business env’t • 2013 sales are forecasted • 2013 10K not released yet