Revenue Sales Revenue Interest Income Other Income TOTAL INCOME Costs and Expenses Advertising Inventory Purchases Lease Computer Equipment Internal Use Software CHWY INC.: Operating Budget Q3 Budget Projection Next TOTAL EXPENSES NET PROFIT/LOSS Net Earnings Before Taxes (Gain or Loss) Income Tax Expense(benefit) Net Earnings After Taxes Q2 2023 Q2 2023 Ratio Analysis (Choose a minimum of two) Profitability Ratio (ROI% operating) Liquidity Ratio (Current ratio) Var +/- Budget Projection Next Var +/- Q Q2 2023 Proj. Q. Var % Var % Change For this Interactive Assignment, you are going to look at the financial statements for the company you selected and, using the previous quarter's financial data, interpret the data and propose a budget for the next Quarter based on your current and previous analysis of company performance. Complete the budget template using this Operating Budget Template: List your current sales, discounts and allowances, net sales, margins, operating costs, and earning before and after taxes. Choose a minimum of two financial ratios (below) and include in your analysis. Prepare the next quarter's budget based on your interpretation of past data. 5 6 Income Statement Exchange rate used is that of the Year End 7 reported date 789 As Reported Quarterly Income 10 Statement 11 Report Date 12 13 Currency 14 Audit Status 15 Consolidated 16 Scale 17 Net sales 18 Cost of goods sold 19 Total revenues 20 Gross profit (loss) 21 Selling, general & administrative 22 Advertising & marketing 23 Total operating expenses 24 Income (loss) from operations 25 Interest income 26 Interest expense 27 Interest income (expense), net 28 Other expense, net 29 Income (loss) before income tax provision 30 Income tax provision 31 Net income (loss) 32 Net income (loss) attributable to common 33 Weighted average common shares used in 34 Weighted average common shares used in 35 Year end shares outstanding 36 Net income (loss) per share attributable to 37 Net income (loss) per share attributable to 38 Other income, net 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 07/30/2023 2nd Quarter USD Unaudited Yes Thousands 2777769 1990996 2777769 786773 619202 185491 -17920 9824 896 8928 20250 1304 18946 18946 428618 431576 429718.479 0.04 0.04 29242 Balance Sheet Exchange rate used is that of the Year End reported date As Reported Quarterly Balance Sheet Report Date Currency Audit Status Consolidated Scale Cash & cash equivalents Marketable securities Accounts receivable Inventories Prepaid expenses & other current assets Total current assets Furniture, fixtures & equipment Computer equipment Internal-use software Leasehold improvements Construction in progress Property & equipment, gross Less: accumulated depreciation & amortization Property & equipment, net Operating lease right-of-use assets Goodwill Other non-current assets Total assets Trade accounts payable Outbound fulfillment Advertising & marketing Payroll liabilities Accrued expenses & other current liabilities Accrued expenses & other current liabilities Accrued expenses and other Operating Accrued expenses and other - Balancing value Total current liabilities Operating lease liabilities Other long-term liabilities Total liabilities Class A common stock Class B common stock Additional paid-in capital Retained earnings (accumulated deficit) Class B common stock, $ 0.0 par value per share, 95,00 Class A common stock, $ 0.01 par value per share, 1,50 Total stockholders' equity (deficit) 07/30/2023 2nd Quarter USD Unaudited Yes Thousands 457103 448323 162681 738204 48080 1854391 907 72141 158067 300951 84193 792259 280504 511755 434805 39442 63621 2904014 1119316 491847 114581 71318 - 880072 202326 28522 173804 1999388 488767 51230 2539385 - 2280748 -1920416 3112 1185 364629