Financial Analysis $$ Isaac and David Tractors, Inc. Based on the enclosed Income Statement, Statement of Retained Earnings, Balance Sheet, and additional information, please determine all the firm$$s ratios

for both $2022$ and $2021.$ The assignment should be done in Excel

FINANCE $301$

Mary Rose's Leotard Company Income Statements

Year Ended $2022$ and $2021$

Year Ended $12/31$

$20222021$

Sales revenue $$50,000$ $$43,000$

Less: Cost of goods sold $37,50030,100$

Gross profits $$12,500$ $$12,900$

Less: Operating expenses

Selling expense $$1,000$ $$800$

General and administrative expenses $2,0001,400$

Depreciation expense $500500$

Total operating expense $$3,500$ $$2,700$

Operating profits $$9,000$ $$10,200$

Less: Interest expense $2,0002,100$

Net profits before taxes $$7,000$ $$8,100$

Less: Taxes $(29\%$ Rate$)2,0302,349$

Net profits after taxes $$4,970$ $$5,751$

Finance $301$

Mary Rose's Leotard Company

Statement of Retained Earnings

Year Ended $12/31$

$20222021$

Net Income $$4,970$ $$5,751$

Less: Preferred Dividends $250250$

Net Income to Common Equity $4,7205,501$

Less: Common Dividends $$1,201$ $$1,355$

Net Income to Retained Earnings $3,5194,146$

Plus: Beginning Retained Earnings $15,40111,255$

Ending Retained Earnings $$18,920$ $$15,401$

Finance $301$ Mary Rose's Leotard Company Balance Sheets Year Ended $12/3120222021$ Assets Current Assets Cash $$5,905$ $$4,825$ Marketable Securities $1,105856$ Accounts Receivable $8,1806,115$ Inventories $5,5925,027$ Total Current Assets $$20,782$ $$16,822$ Gross fixed assets Land and buildings $$33,700$ $$31,876$ Machinery and equipment $30,35028,359$ Furniture and fixtures $5,8255,293$ Vehicles $4,4755,259$ Other $2,487$ $$1,608$ Total gross fixed assets $$76,837$ $$72,395$ Less: Accumulated depreciation $37,33034,439$ Net fixed assets $$39,507$ $$37,956$ Total Assets $$60,289$ $$54,778$ Liabilities and Stockholders' Equity Liabilities Current liabilities Accounts payable $$6,215$ $$4,524$ Notes payable $1,2851,660$ Accruals $2,5851,909$ Total Current Liabilities $$10,085$ $$8,093$ Long$-$Term Debt $$6,784$ $$6,785$ Total Liabilities $$16,869$ $$14,878$ Stockholders' Equity Preferred stock$--$cumulative $5\%,$ $$10$ par, $500$ shares authorized and issued $$5,000$ $$5,000$ Common stock$--$$$2\mathrm{.}50$ par, $7,000$ shares authorized $$17,50017,500$ Paid$-$in capital in excess of par on common stock $2,0002,000$ Retained earnings $18,92015,401$ Total Stockholders' Equity $$43,420$ $$39,901$ Total Liabilities and Stockholders' Equity $$60,289$ $$54,778$

Basic Information $$ Mary Rose's Leotards Company Item Shares Issued Par Value Market Prices: $2022$ Market Prices: $2021$ Common Stock $7,000$ $$2\mathrm{.}50$ $$15\mathrm{.}00$ $$14\mathrm{.}50$ Preferred Stock $500$ $$10$ $$12\mathrm{.}00$ $$11\mathrm{.}00$ Preferred Dividends Par Value X Dividend $\%=$ Dividend Per share $=$ $$10$ X $\mathrm{.}05=$ $$\mathrm{.}50/$share Total Preferred Dividends $=$ Shares X Dividend Per share Total Preferred Dividends $=500$ shares $=$$$250\mathrm{.}00$ Common Dividends $2022$: $$1,201$ Common Dividends $2021$: $$1,355$ Common Equity Total Equity $$ Preferred Equity $2022$: $$43,420-$ $$5,000=$ $$38,4202021$: $$39,901-$ $$5,000=$ $$34,901.$