I need help inputting the ratios wIth the correct equations in excel. As i keep getting the wrong answer. A step by step of each equation used would be helpful. The correct answers are

Current ratio $=1\mathrm{.}58$

quickratio $=0\mathrm{.}98$

Net margin $=15\mathrm{.}1\%$

Gross margin $=40\%$

As seen i have the asner just do not understand how to get thw right answer using equations in excel.

The proper equations formulas say:

Current ratio$=$ current asset$/$current liabilities

Quick ratio$=$ current assets $-$ inventory $/$ current liabilities

Gross margin $=$ net sales$-$COS $/$ net sales

Net profit margin $=$ Net profit$/$net sales

THANK YOU