Question
*I need help on making an analysis statement based on the financial analysis I conducted for Starbucks. ( if possible, can you respond via an
*I need help on making an analysis statement based on the financial analysis I conducted for Starbucks. ( if possible, can you respond via an image instead of text?)
***Per the instructor's requirements: *****
A financial analysis means more than presenting the financial ratio calculations. In essence, what is the driving the results of the financial ratios? How does the firm compare to the industry? What are the trends? (e.g. year-over-year)? You must articulate what the analysis revealed. By simply executing the financial analysis numbers you are only demonstrating the Application level of Bloom's Taxonomy. Be sure to analyze not summarize.
FY 2017 1 Starbucks Financial Analysis 2 (data in millions, excluding per share data and financial ratios) 3 FY 2021 FY 2020 4 Revenue $ 29,060.60 $ 23,518.00 $ 5 Cost of Revenue $ 8,738.70 $ 7,694.90 $ 6 Gross Profit $ 20,321.90 $ 15,823.10 $ 7 Gross Profit Margin $ 0.70 $ 0.67 $ 8 EBIT $ 4,872.100 $ 1,561.699 $ 9 Income Tax $ 1,156.60 $ 239.70 $ 10 NOPAT (Net Operating Profit After Taxes) $ 3,715.50 $ 1,322.00 $ 11 Net Income (includes discontinued operations) $ 4,199.30 $ 928.30 $ 12 13 Diluted Weighted Average Shares 1186.00 1182 14 Dividends per Share $ 0.49 $ 0.45 $ 15 Diluted Normalized EPS (continuing operations) 3.55 0.77 16 FY 2019 26,508.60 $ 8,526.90 $ 17,981.70 $ 0.68 $ 4,077.900 $ 871.60 $ 3,206.30 $ 3,599.20 $ FY 2018 24,719.50 $ 7,930.70 $ 16,788.80 $ 0.68 $ 3,883.301 $ 1,262.00 $ 2,621.30 $ 4,518.30 $ 22,386.80 7,065.80 15,321.00 0.68 4,134.701 1,432.60 2,702.10 2,884.70 1233 0.41 $ 2.93 1395 0.36 $ 3.21 1462 0.30 1.97 Cash Cycle Revenue per day Accounts Receivable Receivable Days Inventory Inventory Days Accounts Payable Payable Days Cash Cycle (days) $ $ $ $ $ $ $ $ FY 2021 79.62 $ 940.00 $ 11.81 $ 1,603.90 $ 20.14 $ 1,211.60 $ 15.22 $ 16.73 $ FY 2020 64.43 $ 883.40 $ 13.71 $ 1,551.40 $ 24.08 $ 997.90 $ 15.49 $ 22.30 $ FY 2019 72.63 $ 879.20 $ 12.11 $ 1,529.40 $ 21.06 $ 1,189.70 $ 16.38 $ 16.78 $ FY 2018 67.72 $ 693.10 $ 10.23 $ 1,400.50 $ 20.68 $ 1,179.30 $ 17.41 $ 13.50 $ FY 2017 61.33 870.40 14.19 1,364.00 22.24 782.50 12.76 23.67 FY 2017 77,550.00 53.04 1.97 26.93 0.19 0.20 Key Ratios Market Value of Book Equity Price per share Earnings per share (continuing operations) P/E Ratio Return on Invested Capital Return on Assets Return on Equity Return on Revenue Total Assets Current Assets Current Liabilities Current Ratio Total Debt Debt/Equity Ratio Total Equity (book value) Shareholders' Equity (minority interests) Market to Book Value $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ FY 2021 131,860.00 $ 111.18 $ 3.55 $ 31.32 $ 0.12 $ 0.13 $ (0.79) $ 0.14 $ 31,392.60 $ 9,756.40 $ 8,151.40 $ 1.20 $ 36,707.10 $ (6.91) $ (5,314.50) $ 6.70 $ (24.81) $ FY 2020 100,440.00 $ 84.97 $ 0.77 $ 110.36 $ 0.05 $ 0.03 $ (0.12) $ 0.04 $ 29,374.50 $ 7,806.40 $ 7,346.80 $ 1.06 $ 37,173.90 $ (4.77) $ (7,799.40) $ 5.70 $ (12.88) $ FY 2019 104,740.00 $ 84.95 $ 2.93 $ 28.99 $ 0.17 $ 0.19 $ (0.58) $ 0.14 $ 19,219.60 $ 5,653.90 $ 6,168.70 $ 0.92 $ 25,450.60 $ (4.08) $ (6,231.00 $ 1.20 $ (16.81) $ FY 2018 76,680.00 $ 54.97 $ 3.21 $ 17.12 $ 0.11 $ 0.19 $ 3.84 $ 0.18 $ 24,156.40 $ 12,494.20 $ 5,684.20 $ 2.20 $ 22,980.60 $ 19.54 $ 1,175.80 $ 6.30 $ 65.22 $ 0.53 0.13 14,365.60 5,283.40 4,220.70 1.25 8,908.60 1.63 5,457.00 6.90 14.21 FY 2017 1 Starbucks Financial Analysis 2 (data in millions, excluding per share data and financial ratios) 3 FY 2021 FY 2020 4 Revenue $ 29,060.60 $ 23,518.00 $ 5 Cost of Revenue $ 8,738.70 $ 7,694.90 $ 6 Gross Profit $ 20,321.90 $ 15,823.10 $ 7 Gross Profit Margin $ 0.70 $ 0.67 $ 8 EBIT $ 4,872.100 $ 1,561.699 $ 9 Income Tax $ 1,156.60 $ 239.70 $ 10 NOPAT (Net Operating Profit After Taxes) $ 3,715.50 $ 1,322.00 $ 11 Net Income (includes discontinued operations) $ 4,199.30 $ 928.30 $ 12 13 Diluted Weighted Average Shares 1186.00 1182 14 Dividends per Share $ 0.49 $ 0.45 $ 15 Diluted Normalized EPS (continuing operations) 3.55 0.77 16 FY 2019 26,508.60 $ 8,526.90 $ 17,981.70 $ 0.68 $ 4,077.900 $ 871.60 $ 3,206.30 $ 3,599.20 $ FY 2018 24,719.50 $ 7,930.70 $ 16,788.80 $ 0.68 $ 3,883.301 $ 1,262.00 $ 2,621.30 $ 4,518.30 $ 22,386.80 7,065.80 15,321.00 0.68 4,134.701 1,432.60 2,702.10 2,884.70 1233 0.41 $ 2.93 1395 0.36 $ 3.21 1462 0.30 1.97 Cash Cycle Revenue per day Accounts Receivable Receivable Days Inventory Inventory Days Accounts Payable Payable Days Cash Cycle (days) $ $ $ $ $ $ $ $ FY 2021 79.62 $ 940.00 $ 11.81 $ 1,603.90 $ 20.14 $ 1,211.60 $ 15.22 $ 16.73 $ FY 2020 64.43 $ 883.40 $ 13.71 $ 1,551.40 $ 24.08 $ 997.90 $ 15.49 $ 22.30 $ FY 2019 72.63 $ 879.20 $ 12.11 $ 1,529.40 $ 21.06 $ 1,189.70 $ 16.38 $ 16.78 $ FY 2018 67.72 $ 693.10 $ 10.23 $ 1,400.50 $ 20.68 $ 1,179.30 $ 17.41 $ 13.50 $ FY 2017 61.33 870.40 14.19 1,364.00 22.24 782.50 12.76 23.67 FY 2017 77,550.00 53.04 1.97 26.93 0.19 0.20 Key Ratios Market Value of Book Equity Price per share Earnings per share (continuing operations) P/E Ratio Return on Invested Capital Return on Assets Return on Equity Return on Revenue Total Assets Current Assets Current Liabilities Current Ratio Total Debt Debt/Equity Ratio Total Equity (book value) Shareholders' Equity (minority interests) Market to Book Value $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ FY 2021 131,860.00 $ 111.18 $ 3.55 $ 31.32 $ 0.12 $ 0.13 $ (0.79) $ 0.14 $ 31,392.60 $ 9,756.40 $ 8,151.40 $ 1.20 $ 36,707.10 $ (6.91) $ (5,314.50) $ 6.70 $ (24.81) $ FY 2020 100,440.00 $ 84.97 $ 0.77 $ 110.36 $ 0.05 $ 0.03 $ (0.12) $ 0.04 $ 29,374.50 $ 7,806.40 $ 7,346.80 $ 1.06 $ 37,173.90 $ (4.77) $ (7,799.40) $ 5.70 $ (12.88) $ FY 2019 104,740.00 $ 84.95 $ 2.93 $ 28.99 $ 0.17 $ 0.19 $ (0.58) $ 0.14 $ 19,219.60 $ 5,653.90 $ 6,168.70 $ 0.92 $ 25,450.60 $ (4.08) $ (6,231.00 $ 1.20 $ (16.81) $ FY 2018 76,680.00 $ 54.97 $ 3.21 $ 17.12 $ 0.11 $ 0.19 $ 3.84 $ 0.18 $ 24,156.40 $ 12,494.20 $ 5,684.20 $ 2.20 $ 22,980.60 $ 19.54 $ 1,175.80 $ 6.30 $ 65.22 $ 0.53 0.13 14,365.60 5,283.40 4,220.70 1.25 8,908.60 1.63 5,457.00 6.90 14.21Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started