ACC EXCEL

Starbucks-ForecastandDataReadyforBudget1.xlsx

Income Statement Screenshot

						"=abs(number)"		2nd Quarter Budgeted Sales*
Date	Week Day	Closing Price	Opening Price	Change in Price	Multiplier 100	Absolute Value		July	August	September	October
5/18/20	Monday	82.38	77.92	4.46	446	446	July Sales	$ 1,207.00	$ 1,218.00	$ 1,274.00	$ 1,233.00
5/19/20	Tuesday	78.6	82.32	-3.72	-372	372
5/20/20	Wednesday	79.67	79.29	0.38	38	38
5/21/20	Thursday	76.19	77.74	-1.55	-155	155
5/22/20	Friday	75.34	73.38	1.96	196	196
5/25/20	Monday	70.83	70.58	0.25	25	25	August Sales
5/26/20	Tuesday	74.87	72.62	2.25	225	225
5/27/20	Wednesday	68.16	72.72	-4.56	-456	456
5/28/20	Thursday	62.1	62.95	-0.85	-85	85
5/29/20	Friday	69.92	65.65	4.27	427	427
6/1/20	Monday	58.59	60.32	-1.73	-173	173	September Sales
6/2/20	Tuesday	58.98	59.55	-0.57	-57	57
6/3/20	Wednesday	56.33	55.38	0.95	95	95
6/4/20	Thursday	61.41	56.23	5.18	518	518
6/5/20	Friday	58.03	62.34	-4.31	-431	431
						October Sales = Average of July, August, September
		Revenues	$ 26,508.60	$ 2,209.05

Starbucks Balance Sheet from Annual Report
September 29th, 2019
(In millions USD)
Current Assets
Cash & Cash Equivalents	$ 2,686.60
Short-Term Investments	$ 70.50
Accounts Receivable	$ 879.20
Inventories	$ 1,529.40
Prepaid Expenses	$ 488.20
Total Current Assets	$ 5,653.90
Long-Term Investments	$ 220.00
Equity Investments	$ 396.00
PPE	$ 6,431.70
Deferred Income Taxes	$ 1,765.80
Other Long-Term Assets	$ 479.60
Other Intangible Assets	$ 781.80
Goodwill	$ 3,490.80
Total Assets	$ 19,219.60
Current Liabilities
Accounts Payable	$ 1,189.70
Accrued Liabilities	$ 1,753.70
Accrued Payroll & Benefits	$ 664.60
Income Taxes Payable	$ 1,291.70
Stored Value Card Liability	$ 1,269.00
Total Current Liabilities	$ 6,168.70
Long-Term Debt	$ 11,167.00
Deferred Revenue	$ 6,744.40
Other Long-Term Liabilities	$ 1,370.50
Total Liabilities	$ 25,450.60
Shareholders' Equity/Deficit
Common Stock	$ 1.20
Additional Paid-In Capital	$ 41.10
Retained Earnings	$ (5,771.20)
Accumulated Other Comprehensive Loss	$ (503.30)
Total Shareholders' Deficit	$ (6,232.20)
Non-Controlling Interests	$ 1.20
Total Shareholders' Deficit	$ (6,231.00)
Total Liabilities & Shareholders' Deficit	$ 19,219.60

Starbucks Income Statement From Annual Report			May	June	July	August	Sept	Oct.
Assume Ending Date is March 31st 2020			$ 2,209	$ 2,209	$ 1,207	$ 1,218	$ 1,274	$ 1,233
(In millions USD)		Monthly Avg.			Quarterly Budget
Revenues	$ 26,508.60	$ 2,209.05
Cost of Sales	$ 8,526.90		Other information from the statements necessary to make the budget						Calculation
Gross Profit	$ 17,981.70		1) Cost of Sales are 32.17% of Sales						32.17%
Store Operating Expenses	$ 10,493.60		2) Variable Expenses (Store Operations + Other Operations)/Revenues = 40.99%						40.99%
Other Operating Expenses	$ 371.00		3) Fixed Expenses are $163.33 per month						$ 163.33
Depreciation/Amortization	$ 1,377.30		4) Income tax rate is 19.52% (Income Tax Expense/Earnings before Taxes)						19.52%
General & Admin	$ 1,824.10		5) Depreciation = $114.78/month						$ 114.78
Restructuring & Impairments	$ 135.80		6) Interest Rate is ~3% per year (Interest Expense/Long Term Debt)						2.96%
Total Operating Expenses	$ 14,201.80
Income from Equity Investees	$ 298.00
Operating Income	$ 4,077.90					Cash Inflow	Sales you collect cash
Gain resulting form divestiture of opeartions	$ 622.80					Cash Outflow	Paying for COGS and Operating Expenses
Interest Income	$ 96.50
Interest Expense	$ 331.00
Earnings before taxes	$ 4,466.20
Income tax Expense	$ 871.60
Net Earnings including non-controlling interest	$ 3,594.60
Net Loss from non-controlling interest	$ 4.60
Net Earnings attributable to Starbucks	$ 3,599.20
Other Comprehensive Income	$ (173.00)
Comprehensive Income Attributable to Starbucks	$ 3,426.20