XYZ Company

Income Statement

For the Years Ending $12/31/23$ & $12/31/22$

$12/31/202312/31/2022$

Sales $($All on Account$)$ $ $10,000,000$ $ $11,000,000$

Cost of Goods Sold $6,000,0006,400,000$

Gross Margin $4,000,0004,600,000$

Operating Expenses $2,200,0002,500,000$

Income Before Interest and Taxes $1,800,0002,100,000$

Interest Expense $100,000150,000$

Income Before Taxes $1,700,0001,950,000$

Income Taxes $300,000500,000$

Net Income $ $1,400,000$ $ $1,450,000$

ABC Company

Balance Sheet

As of $12/31/2023,12/31/2022,$ and $12/31/21$

$12/31/202312/31/202212/31/2021$

Cash $ $500,000$ $ $450,000$ $ $400,000$

Accounts Receivable, Net $180,000160,000220,000$

Inventory $800,000700,0001,000,000$

Prepaid Rent $50,00040,00030,000$

Prepaid Insurance $30,00030,00030,000$

Total Current Assets $1,560,0001,380,0001,680,000$

Plant, Property & Equipment, Net $640,000680,000480,000$

Note Receivable $---$

Total Long$-$Term Assets $640,000680,000480,000$

Total Assets $ $2,200,000$ $ $2,060,000$ $ $2,160,000$

Accounts Payable $ $120,000$ $ $140,000$ $ $160,000$

Interest Payable $50,00040,00030,000$

Total Current Liabilites $170,000180,000190,000$

Note Payable $400,000320,000360,000$

Total Liabilities $570,000500,000550,000$

Common Stock $400,000380,000360,000$

Preferred Stock $50,00050,00050,000$

Retained Earnings $1,180,0001,130,0001,200,000$

Total Stockholder's Equity $1,630,0001,560,0001,610,000$

Total Liabilities and Stockholder's Equity $ $2,200,000$ $ $2,060,000$ $ $2,160,000$

Additional Information Needed

Common Stock Shares Outstanding $50,00045,00040,000$

Market Price Per Share $ $50$ $ $30$ $ $28$

Preferred Dividend $ $5,000$ $ $5,000$ $ $5,000$

Dividends Per Share $ $3\mathrm{.}60$ $ $3\mathrm{.}80$ $ $2\mathrm{.}60$

$12/31/2022$

Current Ratio

Acid$-$Test Ratio

Accounts Receivable Turnover

Days Sales Uncollected

Inventory Turnover

Days Sales in Inventory

Asset Turnover

Debt Ratio

Debt to Equity Ratio

Equity Ratio

Number of Times Interest Earned

Gross Margin Ratio

Profit Margin

Return on Total Assets

Return on Equity $($ROE$)$

Earnings Per Share

Price$-$Earnings Ratio

Dividend Yield