ABC Company

Income Statement

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

$12/31/202312/31/2022$

Sales $ $4,000,000$ $ $3,600,000$

Cost of Goods Sold $2,000,0001,800,000$

Gross Margin $2,000,0001,800,000$

Operating Expenses $600,000480,000$

Income Before Interest and Taxes $1,400,0001,320,000$

Interest Expense $80,00080,000$

Income Before Taxes $1,320,0001,240,000$

Income Taxes $320,000300,000$

Net Income $ $1,000,000$ $ $940,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 $ $240,000$ $ $200,000$ $ $120,000$

Accounts Receivable, Net $120,000100,000140,000$

Inventory $150,000170,000120,000$

Prepaid Rent $30,00025,00030,000$

Prepaid Insurance $25,00020,00015,000$

Total Current Assets $565,000515,000425,000$

Plant, Property & Equipment, Net $350,000300,000320,000$

Note Receivable $50,00050,000-$

Total Long$-$Term Assets $400,000350,000320,000$

Total Assets $ $965,000$ $ $865,000$ $ $745,000$

Accounts Payable $ $100,000$ $ $80,000$ $ $120,000$

Interest Payable $10,00010,00010,000$

Total Current Liabilites $110,00090,000130,000$

Note Payable $160,000120,000180,000$

Total Liabilities $270,000210,000310,000$

Common Stock $230,000200,000180,000$

Preferred Stock $30,00030,00030,000$

Retained Earnings $435,000425,000225,000$

Total Stockholder's Equity $695,000655,000435,000$

Total Liabilities and Stockholder's Equity $ $965,000$ $ $865,000$ $ $745,000$

Additional Information Needed

Common Stock Shares Outstanding $22,00020,00018,000$

Market Price Per Share $ $40$ $ $28$ $ $25$

Preferred Dividend $ $6,000$ $ $6,000$ $ $6,000$

Dividends Per Share $ $1\mathrm{.}80$ $ $1\mathrm{.}60$ $ $1\mathrm{.}20$

$12/31/202212/31/2021$

Current Ratio

Quick Ratio

Accounts Receivable Turnover

Average Days to Collect Receivables

Inventory Turnover

Average Days to Sell Inventory

Debt to Assets

Debt to Equity

Number of Times Interest Earned

Plant Assets to Long$-$Term Liabilities

Net Margin $($Return on Sales$)$

Asset Turnover

Return on Investment $($ROI$)$

Return on Equity $($ROE$)$

Earnings Per Share

Book Value Per Share

Price$-$Earnings Ratio

Dividend