Week 1 assignment

BUS629Starbucks1.xlsx

Home >Business & Finance homework help >Week 1 assignment

Sheet1

name	ttm	3/31/20	6/30/20	difrence	% change	pro forma projection	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	173,461,000	96,415,000	77,046,000	44.416900629	139239554.741412	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	153,093,000	86,123,000	66,970,000	43.7446519436	54,123,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	142,949,000	72,513,000	70,436,000	49.2735171285	76,345,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	30,512,000	23,902,000	6,610,000	21.6636077609	62,894,555	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	54,052,000	35,899,000	18,153,000	33.5843262044	35,899,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	operating expenses would are bound to vary from the last quarter as its projected to be decreasing
SellingGeneralAndAdministration	103,477,000	34,271,000	18,998,000	15,273,000	44.5653759739	34,271,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	selling administrations would are bound to vary from the last quarter as its projected to be decreasing
GeneralAndAdministrativeExpense	103,477,000	34,271,000	18,998,000	15,273,000	44.5653759739	18,998,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	general expenses would are bound g vary from the last quarter as its projected to be decreasing
SalariesAndWages				0
OtherGandA	103,477,000	34,271,000	18,998,000	15,273,000	44.5653759739	18,998,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,486,000	14,300,000	186,000	1.2839983432	13,900,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,486,000	14,300,000	186,000	1.2839983432	13,900,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	5,295,000	2,601,000	2,694,000	50.8781869688	2,601,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	-23,540,000	-11,997,000	-11,543,000	49.0356839422	-11879000	-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	10,715,000	-2,338,000	13,053,000	121.8198786748	10,715,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	other income expense may also vary but the fact is its presumed to decrease in the next quarter.
GainOnSaleOfSecurity	6,755,000	-1,292,000	62,000	-1,354,000	104.7987616099	-1,292,000	62,000	-1,292,000	3,217,000	3,476,000	400,939,000	9,407,000
EarningsFromEquityInterest	52,098,000	16,612,000	2,586,000	14,026,000	84.4329400433	16,612,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	-5,823,000	-4,783,000	-1,040,000	17.860209514	-5,823,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				0					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	1,708,000	4,783,000	-3,075,000	-180.0351288056		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		4,115,000	100	4,115,000		4,115,000	27,256,000			468,000	6,920,000	911,000	2,164,000	372,000
GainOnSaleOfBusiness				0
OtherNonOperatingIncomeExpenses	-1,006,000	-74,000	-203,000	129,000	-174.3243243243	-217000	-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	-12,825,000	-14,335,000	1,510,000	-11.7738791423	-16,540,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	60,000	28,000	32,000	53.3333333333	22,000	28,000	60,000	115,000	84,000	214,000	25,000	429,000	137,000	128,000	121,000
EarningsFromEquityInterestNetOfTax				0
NetIncomeCommonStockholders	-98,389,000	-21,450,000	-23,335,000	1,885,000	-8.7878787879	-22392500	-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	-15,576,000	-17,461,000	1,885,000	-12.1019517206	-16518500	-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	-12,885,000	-14,363,000	1,478,000	-11.4707023671	-13624000	-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	-12,885,000	-14,363,000	1,478,000	-11.4707023671	-13624000	-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				0		0							-79,353,000	5,409,000	56,895,000	17,048,000
NetIncomeExtraordinary				0		0
NetIncomeFromTaxLossCarryforward				0		0
MinorityInterests	-10,749,000	-2,691,000	-3,098,000	407,000	-15.1244890375	-2894500	-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	0	0	5874000	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				0		0
AverageDilutionEarnings				0		0			2,250,000		2,250,000	0	-6,750,000		2,250,000	2,250,000
DilutedNIAvailtoComStockholders	-93,889,000	-21,450,000	-23,335,000	1,885,000	-8.7878787879	-22392500	-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.28	-0.31	0	-10.7142857143	-0.295	-0.31	-0.28		-0.12	5.67	-0.26		-0.28	0.63	0.39
DilutedEPS		-0.28	-0.31	0	-10.7142857143	-0.295	-0.31	-0.28		-0.12	4.55	-0.26		-0.28	0.54	0.35
BasicAverageShares		77,444,000	76,232,000	1,212,000	1.5650018078	76838000	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		77,444,000	76,232,000	1,212,000	1.5650018078	76838000	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	197,001,000	108,412,000	88,589,000	44.9688072649	152706500	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	-15,576,000	-17,461,000	1,885,000	-12.1019517206	-16518500	-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	-11,325,210	-14,014,670	2,689,460	-23.747550818	-12669940	-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

Summary In summary, company would try reducing the expenses and the related costs to iincrease the amount of income for the projected quarter. the total revenue for the quarter are projected to increase with 44.42% for the quarter. the projected sales amount would be 139239554.7. The income projection for the company would be 16518500 which is slightly lower compared to the the last quarters amount.