Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Starbucks Corp (ticker SBUX) Q1: obtain the past dividend distributions information and the systematic risk factor beta to estimate the discount rate (both type of

  • Starbucks Corp (ticker SBUX)

Q1: obtain the past dividend distributions information and the systematic risk factor beta to estimate the discount rate (both type of information can be obtained from either Finance Yahoo! or MorningStar) Then use the Dividend Discount Model (DMM) to estimate the fundamental stock price with the following four assumptions, respectively:

  1. Assuming that future annual dividends will remain the same as the current dividend.
  2. Assuming that each year future annual dividends will grow at a rate consistent with the companys earnings growth rate from financial analysis.
  3. Assuming that each year future annual dividends will grow at an average rate of past dividend growth rates.
  4. Assuming that, each year of the next five years, dividends will grow at a non-constant rate and then achieve stable annual growth after 5 years.

Compare the DDM estimated stock price under each assumption to the actual stock price on the market. Explain the difference between your projected stock price and the actual stock price under each assumption if there is any.

Q2: estimate the stock price using Residual Income Model (RIM) with the information of past annual earnings per share (EPS) of book value per share (BPS) of your stock.

Compare the RIM estimated stock price to the actual stock price on the market. Explain the difference between the two stock prices if there is any.

Q3: obtain historical earnings per share (EPS), price/earnings ratio (P/E), price/book value ratio (P/B), book value per share (BPS), price/sales ratio (P/B), price/cash flows (P/CF) and other key financial information from MorningStar. Estimate stock price and explain price differences with actual trading price by using price ratio analysis on

  1. price/earnings ratio (P/E)
  2. price/book value ratio (P/B)
  3. price/sales ratio (P/S)
  4. price/cash flows (P/CF)

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Valuation Measures Annual Quarterly Monthly Current 3/31/2020 12/31/2019 9/30/2019 6/30/2019 3/31/2019 Market Cap (intraday) 5 89.91B 76.79B 103.26B 104.74B 101.53B 92.45B Enterprise Value 3 110.21B 94.31B 111.67B 111.07B 108.62B 96.59B Trailing P/E 27.49 21.55 30.11 31.35 35.98 32.61 Forward P/E 1 28.01 23.47 28.90 28.65 27.25 27.47 PEG Ratio (5 yr expected) 1 2.75 2.24 2.53 2.48 2.41 2.47 Price/Sales (ttm) 3.46 2.97 4.09 4.30 4.30 3.97 Price/Book (mra) N/A N/A N/A N/A N/A N/A Enterprise Value/Revenue 3 4.13 15.73 15.73 16.46 15.92 15.32 Enterprise Value/EBITDA 6 18.18 108.77 69.58 75.80 51.15 76.26 Financial Highlights Trading Information Fiscal Year Fiscal Year Ends Stock Price History Beta (5Y Monthly) Sep 29, 2019 0.80 Most Recent Quarter (mra) Mar 29, 2020 52-Week Change -7.19% S&P500 52-Week Change 3 5.10% Profitability Profit Margin 3 52 Week High 99.72 12.71% 52 Week Low 3 Operating Margin (ttm) 13.72% 50.02 50-Day Moving Average 3 76.96 Management Effectiveness Return on Assets (ttm) 200-Day Moving Average ? 79.72 10.13% Return on Equity (ttm) N/A Share Statistics Return on Equity (ttm) N/A Share Statistics Avg Vol (3 month)? 14.23M Income Statement Revenue (ttm) 16.25M 26.66B Avg Vol (10 day) 3 5 Shares Outstanding 1.17B Revenue Per Share (ttm) 22.42 Float 1.13B Quarterly Revenue Growth (yoy) -4.90% % Held by Insiders 1 0.23% Gross Profit (ttm) 7.49B % Held by Institutions 1 70.28% EBITDA 5.13B Shares Short (May 29, 2020) 4 20.45M Net Income Avi to Common (ttm) 3.39B Short Ratio (May 29, 2020) 4 1.86 Diluted EPS (ttm) 2.82 Short % of Float (May 29, 2020) 4 1.75% Quarterly Earnings Growth (yoy) -50.50% Short % of Shares Outstanding (May 29, 2020) 4 1.75% Balance Sheet Total Cash (mra) Shares Short (prior month Apr 30, 2020) 4 18.9M 2.63B Total Cash Per Share (mra) 2.25 Dividends & Splits Balance Sheet Total Cash (mra) Shares Short (prior month Apr 30, 2020) 18.9M 2.63B Total Cash Per Share (mra) 2.25 Dividends & Splits Forward Annual Dividend Rate 4 1.64 Total Debt (mra) 22.99B Forward Annual Dividend Yield 4 2.13% Total Debt/Equity (mra) N/A Trailing Annual Dividend Rate 3 1.59 Current Ratio (mra) 0.70 2.07% Book Value Per Share (mra) Trailing Annual Dividend Yield 3 -6.45 5 Year Average Dividend Yield 4 1.67 Cash Flow Statement Operating Cash Flow (ttm) Payout Ratio 55.00% 2.75B Dividend Date May 22, 2020 Levered Free Cash Flow (ttm) 1.22B Ex-Dividend Date May 07, 2020 Last Split Factor 2 2:1 Last Split Date 3 Apr 09, 2015 Previous Close 76.96 90.52B Open 78.79 Market Cap Beta (5Y Monthly) PE Ratio (TTM) 0.80 Bid 77.64 x 1000 27.34 Ask 77.63 x 1200 EPS (TTM) 2.82 Day's Range 52 Week Range 76.39 - 78.92 Earnings Date Jul 28, 2020 Forward 50.02 -99.72 Dividend & Yield 1.64 (2.13%) 8,318,280 Ex-Dividend Date May 07, 2020 Volume Avg. Volume 14,227,451 1y Target Est 80.43 Time Period: Jun 16, 2019 - Jun 16, 2020 Show: Dividends Only Frequency: Daily Currency in USD Date Dividends May 07, 2020 0.41 Dividend Feb 05, 2020 0.41 Dividend Nov 12, 2019 0.41 Dividend Aug 07, 2019 0.36 Dividend *Close price adjusted for splits. **Adjusted close price adjusted for both dividends and splits. Valuation Measures Annual Quarterly Monthly Current 3/31/2020 12/31/2019 9/30/2019 6/30/2019 3/31/2019 Market Cap (intraday) 5 89.91B 76.79B 103.26B 104.74B 101.53B 92.45B Enterprise Value 3 110.21B 94.31B 111.67B 111.07B 108.62B 96.59B Trailing P/E 27.49 21.55 30.11 31.35 35.98 32.61 Forward P/E 1 28.01 23.47 28.90 28.65 27.25 27.47 PEG Ratio (5 yr expected) 1 2.75 2.24 2.53 2.48 2.41 2.47 Price/Sales (ttm) 3.46 2.97 4.09 4.30 4.30 3.97 Price/Book (mra) N/A N/A N/A N/A N/A N/A Enterprise Value/Revenue 3 4.13 15.73 15.73 16.46 15.92 15.32 Enterprise Value/EBITDA 6 18.18 108.77 69.58 75.80 51.15 76.26 Financial Highlights Trading Information Fiscal Year Fiscal Year Ends Stock Price History Beta (5Y Monthly) Sep 29, 2019 0.80 Most Recent Quarter (mra) Mar 29, 2020 52-Week Change -7.19% S&P500 52-Week Change 3 5.10% Profitability Profit Margin 3 52 Week High 99.72 12.71% 52 Week Low 3 Operating Margin (ttm) 13.72% 50.02 50-Day Moving Average 3 76.96 Management Effectiveness Return on Assets (ttm) 200-Day Moving Average ? 79.72 10.13% Return on Equity (ttm) N/A Share Statistics Return on Equity (ttm) N/A Share Statistics Avg Vol (3 month)? 14.23M Income Statement Revenue (ttm) 16.25M 26.66B Avg Vol (10 day) 3 5 Shares Outstanding 1.17B Revenue Per Share (ttm) 22.42 Float 1.13B Quarterly Revenue Growth (yoy) -4.90% % Held by Insiders 1 0.23% Gross Profit (ttm) 7.49B % Held by Institutions 1 70.28% EBITDA 5.13B Shares Short (May 29, 2020) 4 20.45M Net Income Avi to Common (ttm) 3.39B Short Ratio (May 29, 2020) 4 1.86 Diluted EPS (ttm) 2.82 Short % of Float (May 29, 2020) 4 1.75% Quarterly Earnings Growth (yoy) -50.50% Short % of Shares Outstanding (May 29, 2020) 4 1.75% Balance Sheet Total Cash (mra) Shares Short (prior month Apr 30, 2020) 4 18.9M 2.63B Total Cash Per Share (mra) 2.25 Dividends & Splits Balance Sheet Total Cash (mra) Shares Short (prior month Apr 30, 2020) 18.9M 2.63B Total Cash Per Share (mra) 2.25 Dividends & Splits Forward Annual Dividend Rate 4 1.64 Total Debt (mra) 22.99B Forward Annual Dividend Yield 4 2.13% Total Debt/Equity (mra) N/A Trailing Annual Dividend Rate 3 1.59 Current Ratio (mra) 0.70 2.07% Book Value Per Share (mra) Trailing Annual Dividend Yield 3 -6.45 5 Year Average Dividend Yield 4 1.67 Cash Flow Statement Operating Cash Flow (ttm) Payout Ratio 55.00% 2.75B Dividend Date May 22, 2020 Levered Free Cash Flow (ttm) 1.22B Ex-Dividend Date May 07, 2020 Last Split Factor 2 2:1 Last Split Date 3 Apr 09, 2015 Previous Close 76.96 90.52B Open 78.79 Market Cap Beta (5Y Monthly) PE Ratio (TTM) 0.80 Bid 77.64 x 1000 27.34 Ask 77.63 x 1200 EPS (TTM) 2.82 Day's Range 52 Week Range 76.39 - 78.92 Earnings Date Jul 28, 2020 Forward 50.02 -99.72 Dividend & Yield 1.64 (2.13%) 8,318,280 Ex-Dividend Date May 07, 2020 Volume Avg. Volume 14,227,451 1y Target Est 80.43 Time Period: Jun 16, 2019 - Jun 16, 2020 Show: Dividends Only Frequency: Daily Currency in USD Date Dividends May 07, 2020 0.41 Dividend Feb 05, 2020 0.41 Dividend Nov 12, 2019 0.41 Dividend Aug 07, 2019 0.36 Dividend *Close price adjusted for splits. **Adjusted close price adjusted for both dividends and splits

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions