. (20) ) : 313305 - 2024/2023 : : 3 BUILD YOUR EXCEL SHEETS, THEN ANSWER...

Transcribed Image Text:

. (20) ) : 313305 - 2024/2023 : : 3 BUILD YOUR EXCEL SHEETS, THEN ANSWER THE FOLLOWING QUESTIONS. First Question: following financial statements for SUNBILL CO. Then answer the questions: (10 Marks) Operating expenses * EBIT 50000 46000 (19000) (22000) 31000 24000 Income statement For the ended 31/12/2023 Sales (80% credit) Cost of Goods Sold Gross Profit 2023 2022 90000 70000 (40000) (24000) Cash and Equivalents Accounts Receivable Inventory Statement of financial position As of 31/12/2023 Property, Plant & Equipment(net) Total Assets 10000 8000 5000 54000 40000 2023 2022 8000 5000 15000 80000 60000 Total Current Liabilities 15000 8000 Interest Expense (2000) (1000) Long-term Debt 27000 24000 Earnings Before Taxes 29000 23000 Common Stock 25000 25000 Taxes @30% (8700) (6900) Treasury shares (5000) (5000) Net Income 20300 16100 Retained Earnings 18000 8000 Total Liabilities and Owner's Equity 80000 60000 *Additional information: Depreciation expense $5000. First question- SUNBILL co. for 2023 and for 2022 if you can. 1. Analyze horizontally &vertically the following items: sales, inventory, cost of goods sold, gross profit, net income, and long-term debts. Then, put short comments for each item. 2. Compute: ratios to analyze all liquidity analysis, solvency analysis & profitability analysis. Then, put a short comment for each ratio. 3. Summarize all ratios, then put your conclusion about the profitability center, liquidity center, and solvency position for SUNBILL Co. 4. Put your advice to the managers of this corporation. 5. If the company sells from its inventory costs $3000, by $ 5000 on accounts, what are the effects on the following ratios: current ratio, quick ratio, and accounts receivables. Important note: put all your formulas and all calculation and use Excel for requirements above. 1 . (20) ) : 313305 - 2024/2023 : : 3 BUILD YOUR EXCEL SHEETS, THEN ANSWER THE FOLLOWING QUESTIONS. First Question: following financial statements for SUNBILL CO. Then answer the questions: (10 Marks) Operating expenses * EBIT 50000 46000 (19000) (22000) 31000 24000 Income statement For the ended 31/12/2023 Sales (80% credit) Cost of Goods Sold Gross Profit 2023 2022 90000 70000 (40000) (24000) Cash and Equivalents Accounts Receivable Inventory Statement of financial position As of 31/12/2023 Property, Plant & Equipment(net) Total Assets 10000 8000 5000 54000 40000 2023 2022 8000 5000 15000 80000 60000 Total Current Liabilities 15000 8000 Interest Expense (2000) (1000) Long-term Debt 27000 24000 Earnings Before Taxes 29000 23000 Common Stock 25000 25000 Taxes @30% (8700) (6900) Treasury shares (5000) (5000) Net Income 20300 16100 Retained Earnings 18000 8000 Total Liabilities and Owner's Equity 80000 60000 *Additional information: Depreciation expense $5000. First question- SUNBILL co. for 2023 and for 2022 if you can. 1. Analyze horizontally &vertically the following items: sales, inventory, cost of goods sold, gross profit, net income, and long-term debts. Then, put short comments for each item. 2. Compute: ratios to analyze all liquidity analysis, solvency analysis & profitability analysis. Then, put a short comment for each ratio. 3. Summarize all ratios, then put your conclusion about the profitability center, liquidity center, and solvency position for SUNBILL Co. 4. Put your advice to the managers of this corporation. 5. If the company sells from its inventory costs $3000, by $ 5000 on accounts, what are the effects on the following ratios: current ratio, quick ratio, and accounts receivables. Important note: put all your formulas and all calculation and use Excel for requirements above. 1