The following information was gathered from a company's balance sheet and income statement.
	Current	Previous
Cash	$60,000	$50,000
Accounts receivable	$30,000	$35,000
Inventory	$35,000	$45,000
Long-term assets	$250,000	$160,000
Total assets	$375,000	$290,000
	Current	Previous
Current liabilities	$50,000	$70,000
Long-term liabilities	$90,000	$80,000
Total liabilities	$140,000	$150,000
Stockholders equity	$235,000	$140,000
Total liabilities and equity	$375,000	$290,000
	Current
Net sales	$360,000
Cost of goods sold	$170,000
Operating expenses	$61,000
Interest expense	$12,000
Income tax expense	$22,000
Net income	$95,000
Required:
Use the information above to calculate the financial ratios listed below.
After you complete column D, ratio values will auto-populate in column F.

HELP ME WITH EXCEL CELL FORMULAS