please complete ED-21 and all requirments in excel with excel formulas.

thanks

ing Objective 4 ED-21 Analyzing the ability to pay Liabilities Big Bend Photo Shop has asked you to determine whether the company's ability to pay current liabilities and total liabilities improved or deteriorated during 2016. To answer this question, you gather the following data: d. 2016 0.61 2016 2015 Cash Short-term Investments Net Accounts Receivable Merchandise Inventory Total Assets Total Current Liabilities Long-term Notes Payable Income from Operations Interest Expense $ 56,000 31,000 134,000 257,000 540,000 285,000 46,000 170,000 54,000 $ 51,000 0 136,000 297.000 550,000 202.000 58,000 178,000 45,000 Compute the following ratios for 2016 and 2015, and evaluate the company's ability to pay its current liabilities and total liabilities: a. Current racio d. Debe ratio b. Cash ratio e. Debe to equity ratio c. Acid-cest ratio