1 / 11

Valuation using cash flows

Valuation using cash flows. By jennifer kellner (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:

peers
Download Presentation

Valuation using cash flows

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Valuation using cash flows By jenniferkellner (Discount, Variety Stores Industry)

  2. Discount, Variety stores industry Target Dollar General Wal-Mart Costco *Costco is least comparable

  3. 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 ?

  4. 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

  5. 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)

  6. ...from the 10k

  7. 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

  8. Target: • 105,248 Enterprise Value of the firm

  9. 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

  10. Questions?

More Related