how to solve this on excel

6 Directions: Complete the following balance sheet and missing ratios using the information given. 7 Show all of your calculations. Round account balances to the nearest dollar. 8 9 10 Balance Sheet Income Statement 11 12 Cash $14,000 Sales $100,000 13 Cost of Goods Sold $60,000 14 Accounts Receivable Operating Expenses $20,000 15 Interest Expense $15,000 16 Inventory Taxes $5,000 17 Net Income $16,000 18 Net Fixed Assets 19 20 Total Assets Ratios 21 22 Accounts Payable Net Profit Margin 16% 23 24 Short-term Notes Payable $20,000 Return on Common Equity 20% 25 26 Long-term Debt Return on Total Assets 8% 27 28 Common Stock $10,000 Average Payment Period 29 (average daily purchases = $500) 30 Retained Earnings 31 Current Ratio 1.8 32 Total Liabilities and Equity 33 Average Collection Period 36.5 34 35 Times Interest Earned 36 37 Debt Ratio 38 39 40 days A