This assignment requires us to use excel functionality/ formulas to solve the questions.

62 63 64 65 66 67 68 69 70 71 Cash Accounts Receivable Inventory Other Current Assets Fixed Assets, net Investments Total Assets Liabilities and Equity: Accounts Payable 1 BUS333 - Week 5 2 Chapter 3 (Working with Financial Statements); Chapter 4 (Long-Term Financial Planning) 3 39 40 41 BALANCE SHEET: 42 Assets: 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 INCOME STATEMENT: Other Current Liabilities Long-term Debt Other Noncurrent Liabilities Common Stock Retained Earnings Total Liabilities and Equity Revenue Cost of Goods Sold General and Administrative D Depreciation Expense Earnings Before Interest and Taxes Interest Expense Pretax Net Income Income Taxes Net Income 2022 $66,301 45.995 3,986 12,057 41,304 233,082 $402,725 $55,888 51,416 106,519 48,209 30,293 E 110,400 $402,725 2023 $71,250 47,063 4,220 13,191 52,025 240,161 $427,910 $60,262 53,942 100,686 50,377 30,293 132,350 $427,910 FY2023 F $299,660 175,432 16,243 15,004 92,981 3,605 89,376 20,915 $68,461 G H J K