This assignment requires us to use excel functionality/ formulas to solve the questions. 62 63 64 65

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

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

To solve the questions using Excel functionalityformulas youll need to perform various calculations ... View the full answer