The Cherry Corporation, a merchandising business, has been in business for several years. Following are selected data for the Cherry Corporation:

Additional Information: Total Assets at $12/3120$x$3$ was $$210$; Total stockholders$$ equity at $12/3120$x$3$ was $$144.$

Required:

$($a$)$ Compute the following ratios for both $20$x$5$ and $20$x$4$:

Current ratio

Debt Ratio

Net Profit Margin Ratio

Gross Profit Ratio

Return on Equity

Dividend Yield Ratio

Use the following formulas for this problem:

Current ratio $=$ Current Assets$/$Current Liabilities

Debt to Equity Ratio $=$ Average Total Liabilities$/$Average Stockholders' Equity

Net Profit Margin Ratio $=$ Net Income$/$Net Sales

Gross Profit Ratio $=$ Gross Profit$/$Net Sales

Return on Equity $=$ Net Income$/$Average Stockholders' Equity

Dividend Yield Ratio $=$ Dividends per Share$/$Market Price per Share

$($b$)$ Enter the ratios calculated in parts $($a$)$ above in the table on the Excel Template

and comment on the company$$s overall performance and trends from $20$x$4$ to $20$x$5.$