Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi if you can do working in excel sheet and attah i would really appreciate it . with all forumla for calculations in excel. Thank
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.900Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started