finance

profileAAABJ
1.xlsx
Home>Business & Finance homework help>finance

Sheet1

Company Name Starbucks McDonald's Apple Microsoft T-Mobile AT&T Alibaba Amazon Nike Under Armour
Trade Symbol SBUX.OQ MCD APPL MSFT TMUS T BABA AMZN NKE UAA
Current Stock Price $ 84.82 $ 193.12 $ 259.45 $ 149.31 $ 78.01 $ 37.55 $ 194.90 $ 1,769.96 $ 92.46 $ 16.63
EPS $ 2.92 $ 7.62 $ 11.89 $ 5.30 $ 3.89 $ 2.23 $ 3.50 $ 22.57 $ 2.68 $ 0.25
Number of Shares Outstanding (In Millions) 1,181 753.1 4443.24 7628.81 855.57 7305 23,369.82 495.8 1561.05 451.57
P/E Ratio 29.05 25.35 21.82 28.17 20.05 16.83 55.73 78.43 34.53 67.06
Long-Term Growth Rate 10.50% 5.05% 14.30% 14.50% 21.15% 3.97% 3.66% 72% 16.82% 35.90%

Starbucks

Income Statement
Revenue 9/29/19 9/30/18 10/1/17 10/2/16
Total Revenue 26,508,600 24,719,500 22,386,800 21,315,900
Cost of Revenue 19,020,500 17,402,900 15,552,200 14,573,300
Gross Profit 7,488,100 7,316,600 6,834,600 6,742,600
Operating Expenses
Research Development - - - -
Selling General and Administrative 1,824,100 1,704,600 1,408,400 1,408,900
Non Recurring - - - -
Others 371,000 554,900 518,000 499,200
Total Operating Expenses 22,592,900 20,909,400 18,490,000 17,462,200
Operating Income or Loss 3,915,700 3,810,100 3,896,800 3,853,700
Income from Continuing Operations
Total Other Income/Expenses Net 550,500 1,969,900 420,700 344,900
Earnings Before Interest and Taxes 3,915,700 3,810,100 3,896,800 3,853,700 2019 2018 2017 Average
Interest Expense -331,000 -170,300 -92,500 -81,300 EBIT 3,915,700 3,810,100.00 3,896,800 3,874,200
Income Before Tax 4,466,200 5,780,000 4,317,500 4,198,600 Tax Rate 0.1951547177 0.2183391003 0.3318123914 0.2484354
Income Tax Expense 871,600 1,262,000 1,432,600 1,379,700 Property plant and equipment 6,431,700 5,929,100 4,919,500 5,760,100
Minority Interest 1,200 6,300 6,900 6,700 Depreciation/ property plant and equipment 1,449,300 1,305,900 1,067,100 1,274,100
Net Income From Continuing Ops 3,594,600 4,518,000 2,884,900 2,818,900 Net Workinng capital/sales -514,800 6,810,000 1,062,700 2,452,633
Non-recurring Events
Discontinued Operations - - - -
Extraordinary Items - - - - Year 2019 2020 2021 2022 2023 2024
Effect Of Accounting Changes - - - - Total Revenue 26,508,600 29292003 32367663.315 35766267.963075 39521726.0991979 43671507.3396137
Other Items - - - - EBIT 3,874,200 4,370,097.60 4,929,470.09 5,560,442.26 6,272,178.87 7,075,017.77
Net Income Property plant and equipment 5,760,100 6497392.8 7329059.0784 8267178.6404352 9325377.5064109 10519025.8272315
Net Income 3,599,200 4,518,300 2,884,700 2,817,700 Depreciation 1,274,100 1437184.8 1621144.4544 1828650.9445632 2062718.26546729 2326746.2034471
Preferred Stock And Other Adjustments - - - - Net Working Capital 2,452,633 2,766,570.40 3,120,691.41 3,520,139.91 3,970,717.82 4,478,969.70
Net Income Applicable To Common Shares 3,599,200 4,518,300 2,884,700 2,817,700 Free Cash Flow 2,919,991.94 1,783,825.24 1,844,779.95 1,895,962.49 1,934,276.73 1,956,036.44
Horizon Enterprise Value 41,714,184.84 25,483,232.01 26,354,013.55 27,085,192.74 27,632,538.93 27,943,391.98
Balance Sheet Enterprise Value 100,875,000.00 111,466,875.000 123,170,896.875 136,103,841.047 150,394,744.357 166,186,192.514
Period Ending 9/29/19 9/30/18 10/1/17 10/2/16 Stock Price $ 91.83 94.46 104.38 115.34 127.45 140.84
Current Assets Stock price from P/E $ 79.42
Cash And Cash Equivalents 2,686,600 8,756,300 2,462,300 2,128,800
Short Term Investments 70,500 181,500 228,600 134,400
Net Receivables 1,020,300 1,648,500 938,400 768,800
Inventory 1,529,400 1,400,500 1,364,000 1,378,500
Other Current Assets 12,600 24,500 13,400 27,700
Total Current Assets 5,653,900 12,494,200 5,283,400 4,757,900
Long Term Investments 634,300 602,400 1,023,900 1,496,200
Property, plant and equipment 6,431,700 5,929,100 4,919,500 4,533,800
Goodwill 3,490,800 3,541,600 1,539,200 1,719,600
Intangible Assets 781,800 1,042,200 441,400 516,300
Accumulated Amortization - - - -
Other Assets 2,227,100 546,900 1,158,200 1,288,700
Deferred Long Term Asset Charges 1,765,800 134,700 795,400 885,400
Total Assets 19,219,600 24,156,400 14,365,600 14,312,500
Current Liabilities
Accounts Payable 1,189,700 1,179,300 782,500 730,600
Short/Current Long Term Debt - 349,900 - 399,900
Other Current Liabilities 3,750,300 2,936,500 2,547,200 2,522,000
Total Current Liabilities 6,168,700 5,684,200 4,220,700 4,546,800
Long Term Debt 11,169,600 9,122,700 3,932,600 3,185,300
Other Liabilities 8,049,600 8,173,700 755,300 689,700
Deferred Long Term Liability Charges - - - -
Minority Interest 1,200 6,300 6,900 6,700
Negative Goodwill - - - -
Total Liabilities 25,450,600 22,980,600 8,908,600 8,421,800
Stockholders' Equity
Misc. Stocks Options Warrants - - - -
Redeemable Preferred Stock - - - -
Preferred Stock - - - -
Common Stock 1,200 1,300 1,400 1,500
Retained Earnings -5,771,200 1,457,400 5,563,200 5,949,800
Treasury Stock -503,300 -330,300 -155,600 -108,400
Capital Surplus 41,100 41,100 41,100 41,100
Other Stockholder Equity -503,300 -330,300 -155,600 -108,400
Total stockholders' equity -6,232,200 1,169,500 5,450,100 5,884,000
Net Tangible Assets -10,504,800 -3,414,300 3,469,500 3,648,100
Cash Flow
Period Ending 9/29/19 9/30/18 10/1/17 10/2/16
Net Income 3,599,200 4,518,300 2,884,700 2,817,700
Operating Activities, Cash Flows Provided By or Used In
Depreciation 1,449,300 1,305,900 1,067,100 1,030,100
Adjustments To Net Income -1,650,200 -800,100 210,300 497,100
Changes In Accounts Receivables -197,700 131,000 -96,800 -55,600
Changes In Liabilities 1,400 7,501,000 177,200 227,300
Changes In Inventories -173,000 -41,200 14,000 -67,500
Changes In Other Operating Activities 780,900 -823,100 87,200 248,800
Total Cash Flow From Operating Activities 5,047,000 11,937,800 4,251,800 4,697,900
Investing Activities, Cash Flows Provided By or Used In
Capital Expenditure -1,806,600 -1,976,400 -1,519,400 -1,440,300
Investments 167,700 312,400 529,700 -877,100
Other Cash flows from Investing Activities -56,200 5,600 54,300 24,900
Total Cash Flows From Investing Activities -1,010,800 -2,361,500 -850,000 -2,222,900
Financing Activities, Cash Flows Provided By or Used In
Dividends Paid -1,761,300 -1,743,400 -1,450,400 -1,178,000
Sale Purchase of Stock - - - -
Net Borrowings 1,646,000 5,584,100 350,200 1,254,500
Other Cash Flows from Financing Activities -17,500 -41,200 -4,400 -8,400
Total Cash Flows From Financing Activities -10,056,900 -3,242,800 -3,079,100 -1,872,800
Effect Of Exchange Rate Changes -49,000 -39,500 10,800 -3,500
Change In Cash and Cash Equivalents -6,069,700 6,294,000 333,500 598,700