The following information was gathered from a company's balance sheet and income statement.
Current Previous
Cash $ $
Accounts receivable
Inventory
Longterm assets
Total assets $ $
Current Previous
Current liabilities $ $
Longterm liabilities
Total liabilities
Stockholders equity
Total liabilities and equity $ $
Current
Net sales $
Cost of goods sold
Operating expenses
Interest expense
Income tax expense
Net income $
Required:
Use the information above to calculate the financial ratios listed below.
After you complete column D ratio values will autopopulate in column F
Navigation:
Use the Open Excel in New Tab button to launch this question.
When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.
