The steps you will follow for this projoct are as follows: BEFORE YOU EXI. If you do not sove your assignment, the next lime jou enter, you may see a different company and sef of data) 2) Perform the ceguirements on the data file. 3) Check your work in the Excel file with these sheck fouces. 4) Use your Excel fie to answer the six multiple choice questions below. (You wil have bo scrol down to see alt of the questions.) Resources A) Information on how to updole Excei and office 365 . B) It you do not have Ollice 365 , dick here lo leam how to get is for free c) Troubloshooting FAO Thls project only has one attempt. Fieview the check figures with your data fie results beflore answering the questions. If your check figures do not mateh, da not proceed with answenng the questions undil you have asked for aswistance from your instructor. A. $2,000 8. 51,500 C. $1,200 D. 10,800 Using your Eacel workaheat, what is the quick ratio for Scales to Tals Velorinary Supdiy on 12/31/20237 A. 1.36 B. 2.11 c. 0.9 D. 75.40 Using your Excel worksheet, what is the debt ratio for Scales to Tails Veterinary Supply on 12/31/2021? A. 1.15% B. 646,43% C. 55.80% D. 86.60% Using your Excel worksheet, what is the times-interest-earned ratio for Scales to Tails Veterinary Supply on 12/31/2022? A. 2.15 B. 0.70 C. 3.15 D. 1.44 Using your Excel worksheet, what is the gross margin percentage for Scales to Tails Veterinary Supply on 12/31/2023? A. 31.18% B. 7.23% C. 12.52% D. 8.94% Using your Excel worksheet, what is the return on sales for Scales to Tails Veterinary Supply on 12/31/2023 ? A. 7.23% B. 8.94% C. 31.18% D. 12.52% \begin{tabular}{|c|c|c|c|c|} \hline & A & B & C & D \\ \hline 1 & \multicolumn{4}{|c|}{ Scales to Tails Veterinary Supply Co. } \\ \hline 2 & \multicolumn{4}{|c|}{ Income Statements } \\ \hline 3 & & \multicolumn{3}{|c|}{ For years ending } \\ \hline 4 & 3 & 12/31/21 & 12/31/22 & 12/31/23 \\ \hline 5 & & & & \\ \hline 6 & Sales & 85,500 & $101,200 & $128,600 \\ \hline 7 & Cost of goods sold & 65,100 & 78,000 & 88,500 \\ \hline 8 & Gross margin & 20,400 & 23,200 & 40,100 \\ \hline 9 & General and administrative expenses & 17,600 & 19,100 & 24,000 \\ \hline 10 & Operating income & 2,800 & 4,100 & 16,100 \\ \hline 11 & Interest expense & 1,100 & 1,300 & 1,400 \\ \hline 12 & Income before taxes & 1,700 & 2,800 & 14,700 \\ \hline 13 & Tax expense & 1,200 & 930 & 3,200 \\ \hline 14 & Net income & 500 & 1,870 & 11,500 \\ \hline 15 & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline & A & B & C & D \\ \hline 1 & \multicolumn{3}{|c|}{ Scales to Tails Veterinary Supply Co. } & \\ \hline 2 & \multicolumn{3}{|c|}{ Statement of Retained Earnings } & \\ \hline 3 & & & years ending & \\ \hline 4 & & 12/31/21 & 12/31/22 & 12/31/23 \\ \hline 5 & Beginning retained earnings & 2,500 & 800 & 470 \\ \hline 6 & Net income & 500 & 1,870 & 11,500 \\ \hline 7 & Less dividends & (2,200) & (2,200) & (2,200) \\ \hline 8 & Ending retained earnings & 800 & 470 & 9,770 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & & B & & C & D \\ \hline 1 & \multicolumn{6}{|c|}{ Scales to Tails Veterinary Supply Co. } \\ \hline 2 & \multicolumn{6}{|c|}{ Balance Sheets } \\ \hline 3 & \multicolumn{6}{|c|}{ As of December 31,2023,2022, and 2021} \\ \hline 4 & & & & & & \\ \hline 5 & & & 12/31/21 & & 12/31/22 & 12/31/23 \\ \hline 6 & Assets & & & & & \\ \hline 7 & Cash & $ & 1,500 & $ & 4,900 & 15,500 \\ \hline 8 & Accounts receivable & & 4,500 & & 4,800 & 6,500 \\ \hline 9 & Inventory & & 10,900 & 8 & 12,600 & 12,200 \\ \hline 10 & Total current assets & & 16,900 & & 22,300 & 34,200 \\ \hline 11 & Property, plant \& equip & & 400 & & 3,970 & 10,770 \\ \hline 12 & Intangible assets & & 1,100 & & 1,200 & 1,600 \\ \hline 13 & Other long-term assets & & 2,500 & & 1,500 & 1,400 \\ \hline 14 & Total long-term assets & & 4,000 & & 6,670 & 13,770 \\ \hline 15 & Total assets & $ & 20,900 & $ & 28,970 & 47,970 \\ \hline 16 & P & & & & & \\ \hline 17 & Liabilities and Equity & & & & & \\ \hline 18 & Liabilities & & & & & \\ \hline 19 & Accounts payable & $ & 10,100 & $ & 14,500 & 16,200 \\ \hline 20 & Long-term loans payable & & 8,000 & & 12,000 & 20,000 \\ \hline 21 & Total liabilities & & 18,100 & & 26,500 & 36,200 \\ \hline 22 & Equity & 7 & 1 & & & 111 \\ \hline 23 & Common stock & & 2,000 & & 2,000 & 2,000 \\ \hline 24 & Retained earnings & & 800 & & 470 & 9,770 \\ \hline 25 & Total equity & 1 & 2,800 & & 2,470 & 11,770 \\ \hline 26 & Total liabilities and equity & $ & 20,900 & $ & 28,970 & 47,970 \\ \hline 27 & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline & \multicolumn{1}{|c|}{ A } & B & C & D & E \\ \hline 1 & & Scales to Tails Veterinary Supply Co. & \\ \hline 2 & & Ratios & \\ \hline 3 & & 12/31/21 & 12/31/22 & 12/31/23 \\ \hline 4 & Working capital & & \\ \hline 5 & Current ratio & & \\ \hline 6 & Quick ratio & & \\ \hline 7 & Debt ratio & & \\ \hline 8 & Times-interest-earned ratio & & \\ \hline 9 & Gross margin percentage & & \\ \hline 10 & Return on sales & & \\ \hline 11 & & & \\ \hline 12 & & & \\ \hline 13 & & & \\ \hline 14 & & & \\ \hline \end{tabular} Check Figures