Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For Starbucks Corporation: Complete a thorough analysis of the firms financial statements for the 3 most current years. Income Statement Balance Sheet Statement of Cash

For Starbucks Corporation:

Complete a thorough analysis of the firms financial statements for the 3 most current years.

Income Statement

Balance Sheet

Statement of Cash Flows

Analysis includes changes (deltas) for each line item for the 3 most current years for the Starbucks Corporation.

Also, analyze ratios from the most current and available 3 years with deltas and analysis.

Balance Sheet:

image text in transcribedimage text in transcribed

Income Statement: image text in transcribed

Statement of Cash Flows:

image text in transcribedimage text in transcribed Ratios:

image text in transcribed

Breakdown 9/30/2019 9/30/2018 9/30/2017 9/30/2016 Assets Current Assets Cash Cash And Cash Equivalents 2,686,600 8,758,300 2.462,300 2.128,800 Short Term Investments 70,500 181,500 228,600 134.400 Total Cash 2,757.100 8,937,800 2,890,900 2,263,200 Net Receivables 879,200 893,100 870,400 768.800 Inventory 1,529,400 1.400,500 1,384,000 1,378,500 Other Current Assets 350,000 358,100 5,283,400 Total Current Assets 5,853,900 12.494,200 4,780,500 Non-current assets Property, plant and equip... Gross property, plant and e... 13,197,100 11,584,000 10,573,300 Accumulated Depreciation -7,268,000 -8,884,500 -8,039,500 Net property, plant and eq.. 6.431,700 5,929,100 4,919,500 4,533,800 Equity and other investments 616,000 602.400 1,496,200 1,023,900 1,539,200 Goodwill 3.490,800 3,541,600 1.719,800 Intangible Assets 781,800 1,042,200 441.400 516,300 Other long-term assets 479,600 412,200 362,800 417,700 Total non-current assets 13,565,700 11,682,200 9,082,200 9,589,000 Total Assets 19,219,800 24,158,400 14,365.600 14,329,500 Current Liabilities Total Revenue 349,900 400,000 Accounts Payable 1,189,700 1,179,300 782,500 730,600 Taxes payable Acorued liabilities 3,499,500 2,298,400 1,934,500 1,999,100 Deferred revenues 1,269,000 1,642,900 1,288,500 1,171,200 Other Current Liabilities 1,503,700 1.417,200 Total Current Liabilities 6,188,700 5,684,200 4,220,700 4,546,900 Non-current liabilities Long Term Debt 11,167,000 9,090,200 3 ,932,600 3,202,200 Deferred taxes liabilities Deferred revenues 6.744,400 6,775,700 Other long-term liabilities 1,370,500 1,430,500 889,700 755,300 4,887,900 Total non-current liabilities 19,281,900 17,296,400 3,891,900 Total Liabilities 25,450.600 22.980,600 8,908,600 3,438,800 Stodholders' Equity Common Stock 1,200 1,300 1,400 1,500 Retained Earnings -5,771,200 1,457,400 5,563,200 5.949,800 Accumulated other compreh... -503,300 -330,300 -155,800 -108,400 Total stockholders' equity -6,232.200 1,169,500 5.450,100 5,884,000 Total liabilities and stockholde... 19,219,600 24,156,400 14.385,600 14,329,500 Breakdown 9/30/2017 22,388,800 9/30/2016 21,315,900 Total Revenue TTM 28.085,200 18,578,800 7,488,600 9/30/2019 28,508,800 19,020,500 7.488,100 9/30/2018 24,719,500 17,387,700 7,351,800 Cost of Revenue 15,531,500 6,855,300 14,575,400 6,740,500 Gross Profit Operating Expenses Research Development Selling General and Administrat... 1,824,100 Total Operating Expenses 3.572,400 1,380,000 2,888,800 3,853,700 81,300 Operating Income or Loss 3.915,700 Interest Expense 331,000 Total Other Income Expenses Net 318,200 1,879,200 3,680,300 3,828,300 299,200 750,400 4,393,900 345,800 3,548,300 3,551,900 3,551,900 785,000 4.488,200 1,759,000 3.545,300 3,808,500 170,300 1,952,400 5,780,000 1,282,000 4,518,000 4,518,300 4,518,300 1,393,300 2,958,500 3,896,800 92,500 237,900 4,317,500 1,432,800 2.884,900 2,884,700 2,884,700 Income Before Tax 4,198,800 Income Tax Expense 871,800 1,379,700 Income from Continuing Operations 3,594,800 2,818,900 Net Income 3,599,200 2,817,700 Net Income available to common... 3,599,200 2,817,700 Reported EPS Basic 3.45 3.24 2.00 1.97 1.92 1.90 Diluted Weighted average shares outs... Basic 1,309,100 1,431,800 1,481,500 Diluted 1,394,800 7,258,200 1,460,500 1,488,700 5,310,000 EBITDA 6,248,500 5.477,100 Breakdown TTM 390/2019 5630/2018 9/30/2017 330/2016 Cash flows from operating active Net Income 3.551.900 3.599 200 4.518,300 2.884.700 2.817,700 Depreciation & amortization 1.449 300 1,305.900 1057.100 1,030,100 Deferred Income taxes -1 292 300 -1,495.400 714.900 95,100 265,700 Stock based compensation 320.700 308.000 250.300 176.000 218.100 Change in working capital 8.819.900 1.648.700 6.913.400 89,700 353,000 Accounts receivable 75,800 - 197,700 131,000 -96.800 -55,600 Inventory - 160 200 -173.000 -41.200 -67.500 14,000 46,400 Accounts Payable 304,100 31.900 46.900 391,600 9.961.400 Other working capital 10.522.900 3.240.400 2654.900 3,134.800 Other non-cash Tems 184.600 187.900 -1.287.400 -24600 39,000 Net cash provided by operatin... 12.372 200 5.047.000 11,937,800 4.174.300 4.575.100 Cash flows from investing activiti... Investments in property, plant and... -1.849,300 -1.805.600 -1519.400 1.440,300 -1976400 -1.311.300 Acquisitions, net Purchases of investments -298.700 -190 400 -191.900 674.400 -1,585 700 Sales Maturities of investments 361.700 358100 504300 Other investing activites -69 200 -56.200 5.600 1204.100 54.300 -350,000 708,600 24.900 -2.222.900 Net cash used for investing ac... -1.171.300 -1010.800 -2.361,500 Cash flows from financing activ... Debt repayment -350,000 -350,000 -400,000 Common stock issued 380,500 409,800 153,900 150.800 160,700 Common stock repurchased -11,044,500 -10,222,300 -7,133,500 -1,995,600 -2,042,500 -1.450,400 Dividends Paid -1,813,900 -1,761,300 -1,743,400 -1,178,000 Other financing activites -153,600 - 129,100 -103,900 -9,700 8.400 Net cash used privided by (us... -3,297,900 -10,056,900 -3,242,800 -3,001,800 -1,750,000 Net change in cash 2.871,200 -6,069,700 6,294,000 333,500 598.700 Cash at beginning of period 1,892, 100 8.758,300 2,462,300 2,128,800 1,530,100 Cash at end of period 4,795,100 2,686,600 8.758,300 2.462,300 2.128,800 Free Cash Flow Operating Cash Flow 12,372,200 5,047.000 11,937,800 4,174,300 4,575.100 Capital Expenditure -1,976,400 -1,440,300 -1,849,300 10,522,900 -1,806,600 3,240,400 -1,519,400 2,854,900 Free Cash Flow 9,981,400 3,134,800 Annual Data 2018-09-30 2017-09-30 2016-09-30 2015-09-30 2.1981 0.8855 1.2518 0.4188 1.0464 0.351 1.0885 0.2874 8.0287 0.7207 0.6086 0.4034 59.6445 60.0814 59.3612 18.4694 19.5718 18.4694 19.5718 58.8402 15.7095 15.7095 20.9923 23.3824 18.2783 1.0233 18.7917 18.7917 23.6647 24.4043 23.236 19.2859 19.697 20.3677 14.3894 12.8857 1.5584 Current Ratio Long-term Debt / Capital Debt/Equity Ratio Gross Margin Operating Margin EBIT Margin EBITDA Margin Pre-Tax Profit Margin Net Profit Margin Asset Turnover Inventory Turnover Ratio Receiveable Turnover Days Sales In Receivables ROE - Return On Equity Return On Tangible Equity ROA - Return On Assets ROI - Return On Investment Book Value Per Share Operating Cash Flow Per Share Free Cash Flow Per Share EE E E E E E E E E E E EE EEEEEE 1.5434 5.961 7.2649 35.6651 6.6234 25.7201 14.1912 26.6519 10.2341 13.6951 384.249 52.866 47.4123 13.2188 1.4893 6.1727 27.7262 13.1644 47.8534 77.1287 19.6954 31.0588 4.0333 3.16 2.1912 -132.5705 82.9853 74.0951 18.7031 20.082 22.2232 30.7244 33.7847 3.8118 3.9188 44.0094 0.8982 8.56 7.1428 2.9092 2.4773 1.8696 1.6217 Breakdown 9/30/2019 9/30/2018 9/30/2017 9/30/2016 Assets Current Assets Cash Cash And Cash Equivalents 2,686,600 8,758,300 2.462,300 2.128,800 Short Term Investments 70,500 181,500 228,600 134.400 Total Cash 2,757.100 8,937,800 2,890,900 2,263,200 Net Receivables 879,200 893,100 870,400 768.800 Inventory 1,529,400 1.400,500 1,384,000 1,378,500 Other Current Assets 350,000 358,100 5,283,400 Total Current Assets 5,853,900 12.494,200 4,780,500 Non-current assets Property, plant and equip... Gross property, plant and e... 13,197,100 11,584,000 10,573,300 Accumulated Depreciation -7,268,000 -8,884,500 -8,039,500 Net property, plant and eq.. 6.431,700 5,929,100 4,919,500 4,533,800 Equity and other investments 616,000 602.400 1,496,200 1,023,900 1,539,200 Goodwill 3.490,800 3,541,600 1.719,800 Intangible Assets 781,800 1,042,200 441.400 516,300 Other long-term assets 479,600 412,200 362,800 417,700 Total non-current assets 13,565,700 11,682,200 9,082,200 9,589,000 Total Assets 19,219,800 24,158,400 14,365.600 14,329,500 Current Liabilities Total Revenue 349,900 400,000 Accounts Payable 1,189,700 1,179,300 782,500 730,600 Taxes payable Acorued liabilities 3,499,500 2,298,400 1,934,500 1,999,100 Deferred revenues 1,269,000 1,642,900 1,288,500 1,171,200 Other Current Liabilities 1,503,700 1.417,200 Total Current Liabilities 6,188,700 5,684,200 4,220,700 4,546,900 Non-current liabilities Long Term Debt 11,167,000 9,090,200 3 ,932,600 3,202,200 Deferred taxes liabilities Deferred revenues 6.744,400 6,775,700 Other long-term liabilities 1,370,500 1,430,500 889,700 755,300 4,887,900 Total non-current liabilities 19,281,900 17,296,400 3,891,900 Total Liabilities 25,450.600 22.980,600 8,908,600 3,438,800 Stodholders' Equity Common Stock 1,200 1,300 1,400 1,500 Retained Earnings -5,771,200 1,457,400 5,563,200 5.949,800 Accumulated other compreh... -503,300 -330,300 -155,800 -108,400 Total stockholders' equity -6,232.200 1,169,500 5.450,100 5,884,000 Total liabilities and stockholde... 19,219,600 24,156,400 14.385,600 14,329,500 Breakdown 9/30/2017 22,388,800 9/30/2016 21,315,900 Total Revenue TTM 28.085,200 18,578,800 7,488,600 9/30/2019 28,508,800 19,020,500 7.488,100 9/30/2018 24,719,500 17,387,700 7,351,800 Cost of Revenue 15,531,500 6,855,300 14,575,400 6,740,500 Gross Profit Operating Expenses Research Development Selling General and Administrat... 1,824,100 Total Operating Expenses 3.572,400 1,380,000 2,888,800 3,853,700 81,300 Operating Income or Loss 3.915,700 Interest Expense 331,000 Total Other Income Expenses Net 318,200 1,879,200 3,680,300 3,828,300 299,200 750,400 4,393,900 345,800 3,548,300 3,551,900 3,551,900 785,000 4.488,200 1,759,000 3.545,300 3,808,500 170,300 1,952,400 5,780,000 1,282,000 4,518,000 4,518,300 4,518,300 1,393,300 2,958,500 3,896,800 92,500 237,900 4,317,500 1,432,800 2.884,900 2,884,700 2,884,700 Income Before Tax 4,198,800 Income Tax Expense 871,800 1,379,700 Income from Continuing Operations 3,594,800 2,818,900 Net Income 3,599,200 2,817,700 Net Income available to common... 3,599,200 2,817,700 Reported EPS Basic 3.45 3.24 2.00 1.97 1.92 1.90 Diluted Weighted average shares outs... Basic 1,309,100 1,431,800 1,481,500 Diluted 1,394,800 7,258,200 1,460,500 1,488,700 5,310,000 EBITDA 6,248,500 5.477,100 Breakdown TTM 390/2019 5630/2018 9/30/2017 330/2016 Cash flows from operating active Net Income 3.551.900 3.599 200 4.518,300 2.884.700 2.817,700 Depreciation & amortization 1.449 300 1,305.900 1057.100 1,030,100 Deferred Income taxes -1 292 300 -1,495.400 714.900 95,100 265,700 Stock based compensation 320.700 308.000 250.300 176.000 218.100 Change in working capital 8.819.900 1.648.700 6.913.400 89,700 353,000 Accounts receivable 75,800 - 197,700 131,000 -96.800 -55,600 Inventory - 160 200 -173.000 -41.200 -67.500 14,000 46,400 Accounts Payable 304,100 31.900 46.900 391,600 9.961.400 Other working capital 10.522.900 3.240.400 2654.900 3,134.800 Other non-cash Tems 184.600 187.900 -1.287.400 -24600 39,000 Net cash provided by operatin... 12.372 200 5.047.000 11,937,800 4.174.300 4.575.100 Cash flows from investing activiti... Investments in property, plant and... -1.849,300 -1.805.600 -1519.400 1.440,300 -1976400 -1.311.300 Acquisitions, net Purchases of investments -298.700 -190 400 -191.900 674.400 -1,585 700 Sales Maturities of investments 361.700 358100 504300 Other investing activites -69 200 -56.200 5.600 1204.100 54.300 -350,000 708,600 24.900 -2.222.900 Net cash used for investing ac... -1.171.300 -1010.800 -2.361,500 Cash flows from financing activ... Debt repayment -350,000 -350,000 -400,000 Common stock issued 380,500 409,800 153,900 150.800 160,700 Common stock repurchased -11,044,500 -10,222,300 -7,133,500 -1,995,600 -2,042,500 -1.450,400 Dividends Paid -1,813,900 -1,761,300 -1,743,400 -1,178,000 Other financing activites -153,600 - 129,100 -103,900 -9,700 8.400 Net cash used privided by (us... -3,297,900 -10,056,900 -3,242,800 -3,001,800 -1,750,000 Net change in cash 2.871,200 -6,069,700 6,294,000 333,500 598.700 Cash at beginning of period 1,892, 100 8.758,300 2,462,300 2,128,800 1,530,100 Cash at end of period 4,795,100 2,686,600 8.758,300 2.462,300 2.128,800 Free Cash Flow Operating Cash Flow 12,372,200 5,047.000 11,937,800 4,174,300 4,575.100 Capital Expenditure -1,976,400 -1,440,300 -1,849,300 10,522,900 -1,806,600 3,240,400 -1,519,400 2,854,900 Free Cash Flow 9,981,400 3,134,800 Annual Data 2018-09-30 2017-09-30 2016-09-30 2015-09-30 2.1981 0.8855 1.2518 0.4188 1.0464 0.351 1.0885 0.2874 8.0287 0.7207 0.6086 0.4034 59.6445 60.0814 59.3612 18.4694 19.5718 18.4694 19.5718 58.8402 15.7095 15.7095 20.9923 23.3824 18.2783 1.0233 18.7917 18.7917 23.6647 24.4043 23.236 19.2859 19.697 20.3677 14.3894 12.8857 1.5584 Current Ratio Long-term Debt / Capital Debt/Equity Ratio Gross Margin Operating Margin EBIT Margin EBITDA Margin Pre-Tax Profit Margin Net Profit Margin Asset Turnover Inventory Turnover Ratio Receiveable Turnover Days Sales In Receivables ROE - Return On Equity Return On Tangible Equity ROA - Return On Assets ROI - Return On Investment Book Value Per Share Operating Cash Flow Per Share Free Cash Flow Per Share EE E E E E E E E E E E EE EEEEEE 1.5434 5.961 7.2649 35.6651 6.6234 25.7201 14.1912 26.6519 10.2341 13.6951 384.249 52.866 47.4123 13.2188 1.4893 6.1727 27.7262 13.1644 47.8534 77.1287 19.6954 31.0588 4.0333 3.16 2.1912 -132.5705 82.9853 74.0951 18.7031 20.082 22.2232 30.7244 33.7847 3.8118 3.9188 44.0094 0.8982 8.56 7.1428 2.9092 2.4773 1.8696 1.6217

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

Recommended Textbook for

Cases In Healthcare Finance

Authors: Louis C. Gapenski, George H. Pink

4th Edition

1567933424, 978-1567933420

More Books

Students also viewed these Finance questions