BUS 629 Week 1 Assigment

profilejocelynb14
BUS629Starbucks.xlsx
Home>Business & Finance homework help>BUS 629 Week 1 Assigment

Sheet1

name ttm 6/30/20 3/31/20 12/31/19 9/30/19 6/30/19 3/31/19 12/31/18 9/30/18 6/30/18 3/31/18
TotalRevenue 544,101,000 96,415,000 173,461,000 128,888,000 145,338,000 98,468,000 106,802,000 140,166,000 122,141,000 171,571,000 364,245,000
OperatingRevenue 482,941,000 86,123,000 153,093,000 116,658,000 127,068,000 88,418,000 91,989,000 121,775,000 94,333,000 150,748,000 348,925,000
CostOfRevenue 439,478,000 72,513,000 142,949,000 106,207,000 117,810,000 75,026,000 86,966,000 113,257,000 91,620,000 163,576,000 304,769,000
GrossProfit 104,623,000 23,902,000 30,512,000 22,681,000 27,528,000 23,442,000 19,836,000 26,909,000 30,521,000 7,995,000 59,476,000
OperatingExpense 175,501,000 35,899,000 54,052,000 51,044,000 34,504,000 41,131,000 36,670,000 34,022,000 41,792,000 52,887,000 39,069,000
SellingGeneralAndAdministration 103,477,000 18,998,000 34,271,000 26,097,000 24,110,000 27,303,000 21,099,000 18,480,000 21,613,000 23,228,000 28,814,000
GeneralAndAdministrativeExpense 103,477,000 18,998,000 34,271,000 26,097,000 24,110,000 27,303,000 21,099,000 18,480,000 21,613,000 23,228,000 28,814,000
SalariesAndWages
OtherGandA 103,477,000 18,998,000 34,271,000 26,097,000 24,110,000 27,303,000 21,099,000 18,480,000 21,613,000 23,228,000 28,814,000
DepreciationAmortizationDepletionIncomeStatement 57,659,000 14,300,000 14,486,000 14,673,000 14,199,000 13,718,000 15,668,000 16,842,000 19,979,000 10,767,000 11,110,000
DepreciationAndAmortizationInIncomeStatement 57,659,000 14,300,000 14,486,000 14,673,000 14,199,000 13,718,000 15,668,000 16,842,000 19,979,000 10,767,000 11,110,000
OtherOperatingExpenses 14,365,000 2,601,000 5,295,000 10,274,000 -3,805,000 110,000 -97,000 -1,300,000 200,000 18,892,000 -855,000
OperatingIncome -70,878,000 -11,997,000 -23,540,000 -28,363,000 -6,976,000 -17,689,000 -16,834,000 -7,113,000 -11,271,000 -44,892,000 20,407,000
OtherIncomeExpense 11,519,000 -2,338,000 10,715,000 -7,544,000 10,686,000 391,594,000 9,889,000 -18,133,000 -2,833,000 48,631,000 -2,306,000
GainOnSaleOfSecurity 6,755,000 62,000 -1,292,000 3,217,000 3,476,000 400,939,000 9,407,000
EarningsFromEquityInterest 52,098,000 2,586,000 16,612,000 25,283,000 7,617,000 3,640,000 5,309,000 -426,000 -635,000 60,599,000 3,332,000
SpecialIncomeCharges -46,328,000 -4,783,000 -5,823,000 -35,722,000 0 -1,102,000 -4,319,000 -142,851,000 -1,900,000 -8,252,000 -4,472,000
ImpairmentOfCapitalAssets 8,466,000 0 1,102,000 3,851,000 135,931,000 989,000 6,088,000 4,100,000
WriteOff 14,957,000 4,783,000 1,708,000 8,466,000 0 1,102,000 3,851,000 135,931,000 989,000 6,088,000 4,100,000
OtherSpecialCharges 31,371,000 4,115,000 27,256,000 468,000 6,920,000 911,000 2,164,000 372,000
GainOnSaleOfBusiness
OtherNonOperatingIncomeExpenses -1,006,000 -203,000 -74,000 -322,000 -407,000 -11,883,000 -508,000 -860,000 -298,000 -3,716,000 -1,166,000
PretaxIncome -59,359,000 -14,335,000 -12,825,000 -35,907,000 3,710,000 373,905,000 -6,945,000 -25,246,000 -14,104,000 3,739,000 18,101,000
TaxProvision 286,000 28,000 60,000 115,000 84,000 214,000 25,000 429,000 137,000 128,000 121,000
EarningsFromEquityInterestNetOfTax
NetIncomeCommonStockholders -98,389,000 -23,335,000 -21,450,000 -46,260,000 -7,343,000 362,715,000 -17,565,000 -115,455,000 -18,984,000 42,873,000 26,809,000
NetIncome -70,394,000 -17,461,000 -15,576,000 -38,137,000 781,000 370,839,000 -9,441,000 -107,332,000 -10,860,000 50,997,000 34,933,000
NetIncomeIncludingNoncontrollingInterests -59,645,000 -14,363,000 -12,885,000 -36,022,000 3,626,000 373,691,000 -6,970,000 -105,028,000 -8,832,000 60,506,000 35,028,000
NetIncomeContinuousOperations -59,645,000 -14,363,000 -12,885,000 -36,022,000 3,626,000 373,691,000 -6,970,000 -25,675,000 -14,241,000 3,611,000 17,980,000
NetIncomeDiscontinuousOperations -79,353,000 5,409,000 56,895,000 17,048,000
NetIncomeExtraordinary
NetIncomeFromTaxLossCarryforward
MinorityInterests -10,749,000 -3,098,000 -2,691,000 -2,115,000 -2,845,000 -2,852,000 -2,471,000 -2,304,000 -2,028,000 -9,509,000 -95,000
PreferredStockDividends 27,995,000 5,874,000 5,874,000 8,123,000 8,124,000 8,124,000 8,124,000 8,123,000 8,124,000 8,124,000 8,124,000
OtherunderPreferredStockDividend
AverageDilutionEarnings 2,250,000 2,250,000 0 -6,750,000 2,250,000 2,250,000
DilutedNIAvailtoComStockholders -93,889,000 -23,335,000 -21,450,000 -44,010,000 -7,343,000 364,965,000 -17,565,000 -122,205,000 -18,984,000 45,123,000 29,059,000
BasicEPS -0.31 -0.28 -0.12 5.67 -0.26 -0.28 0.63 0.39
DilutedEPS -0.31 -0.28 -0.12 4.55 -0.26 -0.28 0.54 0.35
BasicAverageShares 76,232,000 77,444,000 62,168,000 64,019,000 67,747,000 67,975,000 67,932,000 67,913,000
DilutedAverageShares 76,232,000 77,444,000 62,168,000 80,259,000 67,747,000 67,975,000 83,694,000 83,670,000
TotalExpenses 614,979,000 108,412,000 197,001,000 157,251,000 152,314,000 116,157,000 123,636,000 147,279,000 133,412,000 216,463,000 343,838,000
NetIncomeFromContinuingAndDiscontinuedOperation -70,394,000 -17,461,000 -15,576,000 -38,137,000 781,000 370,839,000 -9,441,000 -107,332,000 -10,860,000 50,997,000 34,933,000
NormalizedIncome -41,505,710 -14,014,670 -11,325,210 -14,408,350 -2,616,298.11 -28,769,158.13 -13,155,240 76,302,230 -14,882,000 2,071,503.08 22,327,105.96