1. Prepare a 2022 income statement for XYZ Co. using the data below. Also calculate the...

Transcribed Image Text:

1. Prepare a 2022 income statement for XYZ Co. using the data below. Also calculate the profitability ratios? Show your work. Revenue $6,000,000, variable expenses $1,200,000, salaries $2,000,000, selling expenses $700,000, rent $500,000, depreciation $450,000, interest expense $90,000. Tax 30%. 1,000,000 shares of stock outstanding. 50% dividend payout. What are the profitability ratios? 2. What is the profitability trend (increasing, decreasing or stable) for each ratio? The 2020 and 2021 profitability ratios for XYZ are listed below. 2020 2021 2022 Gross profit margin 81.4% 80.4% Operating profit 19% 19.1% margin Net profit margin 12.3% 12.31% Trend Income (sales, revenue) -COGS (cost of goods sold)(variable costs) Gross Profit -Operating expenses (fixed expenses like salaries, rent, etc.) -Depreciation expense Operating profit or EBIT (earnings before int. & tax) -Interest expense EBT (earnings before tax) Use for tax calc Tax 30% EAT or Net Profit Dividends paid Retained earnings EPS Earnings per share Common Stock Outstanding Dividends per share DPS Profitability ratios a b p. C d e f q. g h j. r. k I. m. n. 0. 1. Prepare a 2022 income statement for XYZ Co. using the data below. Also calculate the profitability ratios? Show your work. Revenue $6,000,000, variable expenses $1,200,000, salaries $2,000,000, selling expenses $700,000, rent $500,000, depreciation $450,000, interest expense $90,000. Tax 30%. 1,000,000 shares of stock outstanding. 50% dividend payout. What are the profitability ratios? 2. What is the profitability trend (increasing, decreasing or stable) for each ratio? The 2020 and 2021 profitability ratios for XYZ are listed below. 2020 2021 2022 Gross profit margin 81.4% 80.4% Operating profit 19% 19.1% margin Net profit margin 12.3% 12.31% Trend Income (sales, revenue) -COGS (cost of goods sold)(variable costs) Gross Profit -Operating expenses (fixed expenses like salaries, rent, etc.) -Depreciation expense Operating profit or EBIT (earnings before int. & tax) -Interest expense EBT (earnings before tax) Use for tax calc Tax 30% EAT or Net Profit Dividends paid Retained earnings EPS Earnings per share Common Stock Outstanding Dividends per share DPS Profitability ratios a b p. C d e f q. g h j. r. k I. m. n. 0.