50.1K

Verified Solution

Link Copied!

Hi if you can do working in excel sheet and attah i would really appreciate it . with all forumla for calculations in excel. Thank you so much

Required

a) What is the working capital amount for 2019 and for 2018

b) Compute the current ratio for 2019 and 2018, which is the better

c) Compute the acid test ratio for 2019 and 2018 which is better

d) Compute debt to equity ratio for 2019 and 2018 which is the better

e) Concisely comment on the above as to the business performance and/or risk

Data for Michelle, Inc. follow: Michelle, Inc. Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Assets Current Assets: Cash Accounts Receivable, Net $12,000 16.100 $10,200 16.800 Merchandise Inventory 45,000 31,000 Prepaid Expenses Total Current Assets Property. Plant, and Equipment Net Total Assets 6,500 3.900 79,600 61.900 265.000 $233.000 $344 600W 294,900 Liabilities Total Current Liabilities Long-term Liabilities Total Liabilities $9.900 60,000 69.900 11.200 50.000 61,200 Stockholders' Equity Preferred Stock. 3%, $50 par Common Stockholders Equity, no par 175,000 199.00 75.000 358.700 Total Liabilities and Stockholders' Equity $244 600 $294.900 Data for Michelle, Inc. follow: Michelle, Inc. Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Assets Current Assets: Cash Accounts Receivable, Net $12,000 16.100 $10,200 16.800 Merchandise Inventory 45,000 31,000 Prepaid Expenses Total Current Assets Property. Plant, and Equipment Net Total Assets 6,500 3.900 79,600 61.900 265.000 $233.000 $344 600W 294,900 Liabilities Total Current Liabilities Long-term Liabilities Total Liabilities $9.900 60,000 69.900 11.200 50.000 61,200 Stockholders' Equity Preferred Stock. 3%, $50 par Common Stockholders Equity, no par 175,000 199.00 75.000 358.700 Total Liabilities and Stockholders' Equity $244 600 $294.900

Answer & Explanation Solved by verified expert

See Answer