50.1K

Verified Solution

Link Copied!

can someone help me? Based on the enclosed Income Statement, Statement of Retained Earnings, Balance Sheet, and additional information, please determine all the firms ratios as discussed in Module 3 for both 2022 and 2021. it should be done in excel.

find these ratios:

- liquity ratios

- current ratios

- quick ratios

- activity ratios

- leverage ratios

- profitability ratios

- market ratios

FINANCE 301 Mary Rose's Leotard Company Income Statements Year Ended 2022 and 2021 \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ Year Ended 12/31 } \\ \hline 2022 & 2021 \\ \hline & \\ \hline \end{tabular} Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses Selling expense General and administrative expenses Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes Less: Taxes (29\% Rate) Net profits after taxes \begin{tabular}{|r|r|} \hline$50,000 & $43,000 \\ \hline 37,500 & 30,100 \\ \hline$12,500 & $12,900 \\ \hline & \\ \hline$1,000 & $800 \\ \hline 2,000 & 1,400 \\ \hline 500 & 500 \\ \hline$3,500 & $2,700 \\ \hline$9,000 & $10,200 \\ \hline 2,000 & 2,100 \\ \hline$7,000 & $8,100 \\ \hline 2,030 & 2,349 \\ \hline$4,970 & $5,751 \\ \hline \end{tabular} Finance 301 Mary Rose's Leotard Company Statement of Retained Earnings Net Income Less: Preferred Dividends Net Income to Common Equity Less: Common Dividends Net Income to Retained Earnings Plus: Beginning Retained Earnings Ending Retained Earnings \begin{tabular}{|r|r|} \hline Year Ended 12/31 \\ \hline 2022 & 2021 \\ \hline$4,970 & $5,751 \\ \hline 250 & 250 \\ \hline 4,720 & 5,501 \\ \hline$1,201 & $1,355 \\ \hline 3,519 & 4,146 \\ \hline 15,401 & 11,255 \\ \hline$18,920 & $15,401 \\ \hline \end{tabular} Finance 301 Mary Rose's Leotard Company Balance Sheets \begin{tabular}{:c:c:} \hline \multicolumn{2}{c|}{ Year Ended 12/31 } \\ \hline 2022 & 2021 \\ \hdashline \end{tabular} Assets Current Assets Cash Marketable Securities Accounts Receivable Inventories Total Current Assets \begin{tabular}{|r|r|} \hline$5,905 & $4,825 \\ \hline 1,105 & 856 \\ \hline 8,180 & 6,115 \\ \hline 5,592 & 5,027 \\ \hline$20,782 & $16,822 \\ \hline \end{tabular} Gross fixed assets Land and buildings Machinery and equipment Furniture and fixtures Vehicles Other Total gross fixed assets Less: Accumulated depreciation Net fixed assets Total Assets \begin{tabular}{|r|r|} \hline$33,700 & $31,876 \\ \hline 30,350 & 28,359 \\ \hline 5,825 & 5,293 \\ \hline 4,475 & 5,259 \\ \hline 2,487 & $1,608 \\ \hline$76,837 & $72,395 \\ \hline 37,330 & 34,439 \\ \hline$39,507 & $37,956 \\ \hline$60,289 & $54,778 \\ \hline \end{tabular} Liabilities and Stockholders' Equity Liabilities Current liabilities Accounts payable Notes payable Accruals Total Current Liabilities Long-Term Debt Total Liabilities Stockholders' Equity Preferred stock-cumulative 5%,$10 par, 500 shares authorized and issued Common stock- $2.50 par, 7,000 shares authorized Paid-in capital in excess of par on common stock Retained earnings Total Stockholders' Equity \begin{tabular}{|r|r|} \hline$6,784 & $6,785 \\ \hline & \\ \hline$16,869 & $14,878 \\ \hline \end{tabular} Total Liabilities and Stockholders' Equity \begin{tabular}{|l|l|} \hline$60,289 & $54,778 \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer