- A B D E F G I H I 1 2 3 4 5 6 3 Months Ended Percent 3 Months Ended Oct 3 2021 Of Rev Jan 2 2022 Assumptions 8 146 7 1 (153.86 KiB) Viewed 42 times
PROFORMA BALANCE SHEET Oct. 3, 2021 Jan. 2, 2022 Assumptions 162.2 6,455.70 162.2 940 1,603.90 594.6 9,756.40 281.7 268.5 6,369.50 8,236 1,874.80 578.5 349.9 3,677.30 31,392.60 281.7 268.5 6,369.50 8203.4 1859.7 578.5 349.9 3,677.30 1,211.60 1,973.20 Starbucks Condensed Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cash and cash equivalents Short-term investments Accounts receivable, net Inventories Prepaid expenses and other current Total current assets Long-term investments Equity Investments Property, plant and equipment, net Operating Lease, Right-of-Use Asset Deferred income taxes, net Other long-term assets Other intangible assets Goodwill TOTAL ASSETS Current liabilities: Accounts payable Accrued liabilities Insurance Reserves Accrued payroll and benefits Income taxes payable Operating Lease, Liability, Current Stored value card liability and current portion of deferred revenue Short-term Debt Current portion of long-term debt Total current liabilities Long-term debt Deferred Revenue Operating Lease, Liability, Noncurrent Other long-term liabilities Total liabilities Shareholders' equity: Common stock ($0.001 par value) authorized, 2,400.0 shares; issued and outstanding, 1,457.2 shares and 1,460.5 shares, respectively Additional paid-in capital Retained deficit Accumulated other comprehensive income/(loss) Total shareholders' equity/deficit Noncontrolling interests Total equity/(deficit) TOTAL LIABILITIES AND EQUITY/(DEFICIT) Authorized shares of common stock Par value of common stock 772.3 348 1,251.30 772.3 811.5334704 1,253.30 1,596.10 998.9 13,616.90 998.9 8,151.40 13,616.90 6,463.00 7,738.00 737.8 36,707.10 7,738.00 737.8 1.2 846.1 -6,315.70 1.2 846.1 -4,672.46 147.2 -5,321.20 6.7 -5,314.50 $31,392.60 147.2 -3,679.16 6.7 -3,672.46
Q4, 20NN Q1, 20NN AMOUNT PO LINE ITEM Enter your line item PERCENT VARIANCE #DIV/01 0 6,455.70 162.2 940 1,603.90 $3,969.40 $ 87.4 1,031.10 1,637.10 0 -2486.3 -74.8 91.1 33.2 #DIV/01 ! -0.385132519 -0.461159063 0.096914894 0.020699545 594.6 9,756.40 281.7 268.5 6,369.50 8,236 530.1 7.255.10 299.6 251.9 6,398.00 8,203.40 1,859.70 500 588 302.5 3,675.70 $28.833.90 1,874.80 578.5 349.9 3,677.30 31,392.60 -64.5 -2501,3 DULE 17.9 - 16.6 28.5 -32.6 -15.1 9.5 -47.4 -1.6 -2558.7 0 0 77.8 471.1 0 -0.108476287 -0.256375302 0.063542776 -0.061824953 0.004474449 -0.003958232 -0.008054192 0.01642178 -0.135467276 -0.000435102 -0.08150647 #DIV/0! 0.064212611 0.23874924 #DIV/0! -0.140100997 -1 2 0.001598338 1,211.60 1.973,20 $1,289.40 2.444.30 664.1 772.3 348 1,251.30 108.2 -348 2 1.253.30 Current assets: : Cash and cash equivalents Short-term investments Accounts receivable, net Inventories Prepaid expenses and other current assets Total current assets Long-term investments Equity Investments Property, plant and equipment, net Operating Lease, Right-of-Use Asset Deferred income taxes, net Other long-term assets Other intangible assets Goodwill TOTAL ASSETS Current liabilities: Accounts payable Accrued liabilities Insurance Reserves Accrued payroll and benefits Income taxes payable Operating Lease, Liability, Current Stored value card liability and current portion of deferred revenue Short-term Debt Cho Current portion of long-term debt - Total current liabilities Long-term debt Deferred Revenue Operating Lease, Liability, Noncurrent Other long-term liabilities Total liabilities Shareholders' equity: Common stock ($0.001 par value) - authorized, 2,400.0 shares; issued and outstanding, 1,457.2 shares and 1,460.5 shares, respectively Additional paid-in capital Retained deficit Accumulated other comprehensive income/(los) Total shareholders' equity/deficit Noncontrolling interests Total equity/(deficit) TOTAL LIABILITIES AND EQUITY/ (DEFICIT) Authorized shares of common stock Par value of common stock 1,596.10 ! 998.9 8,151.40 13,616.90 6,463.00 7,738.00 737.8 36,707.10 2,070.70 200 999.3 8,921.10 13,586.30 6.447.70 7.708.00 621.1 37,284.20 474,6 200 0.4 769.7 -30.6 -15.3 -30 -116.7 577.1 0 0 0.29734979 #DIV/01 0.00040044 0,094425497 -0.002247208 -0.002367322 -0.003876971 -0.158172947 0.015721754 #DIV/0! 0 0 1.2 846.1 -6,315.70 1.2 41.1 -805 -2437.3 -0.951424182 0.3859113 -8.753.00 147.2 -5,321.20 6.7 -5,314.50 253.5 -8.45720 6.9 -8,450.30 106.3 -3136 0.2 -3135.8 0.722146739 0.58934075 0.029850746 0.5900461 $31,392.60 $28.833.90 -2558.7 -0.08150647 ome St... Proforma Balance S... Variance Analysis IS Variance Analysis BS
LINE ITEM Q4, 20NN Q1, 20NN AMOUNT PERCENT VARIANCE #DIV/0! Enter your line item 0 8,146.70 2,491.10 3,273.40 108.6 8,050.40 2,526.90 3,400.00 101.7 -96.3 35.8 126.6 -6.9 #DIV/0! -0.011820737 0.014371161 0.038675383 -0.063535912 354.7 366 11.3 24.6 0.031857908 0.049082203 501.2 525.8 55.5 -7.5 -63 -1.135135135 0.018925492 6,784.50 120 6,912.90 40.3 128.4 -79.7 -304.4 -0.664166667 -0.205370395 1,482.20 1,177.80 -1 864.5 21.5 -0.1 -864.5 -21.6 5.3 -120.6 2,247.60 483 -115.3 1,062.40 246.3 -1.004651163 -0.043946932 -0.527318028 -0.490062112 -1185.2 -236.7 Revenues Cost of Goods and Services Sold Store operating expenses Other operating expenses Depreciation and amortization expenses General and administrative expenses Restructuring, Settlement and Impairment Provisions Total operating expenses Income from equity investees Operating income Net gain resulting from divestiture of certain operations Interest income and other, net Interest expense Earnings before income taxes Income Tax Expense (Benefit) Net earnings including noncontrolling interests Net earnings/(loss) attributable to noncontrolling interests Net earnings attributable to Starbucks Earnings per share - basic Net earnings per common share - diluted Weighted average shares outstanding: Basic Diluted Cash dividends declared per share Company-operated stores (Member) Revenues Licensed stores (Member) Revenues Product and Service, Other (Member) Revenues 1,764.60 816.1 -948.5 -0.537515584 0.2 0.2 0 0 1,764.40 $1.50 $815.90 $0.70 -948.5 -0.8 -0.537576513 -0.533333333 $1.49 $0.69 -0.8 -0.536912752 0 - 10.4 1,180.00 1,187.90 0.49 1,169.60 1,176.60 #DIV/0! -0.008813559 -0.009512585 -1 -11.3 -0.49 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 rma Income St... Proforma Balance S... Variance Analysis IS