2. In cell B22, input the cash amount. (1 point) 3. In cell B23, input the accounts receivable. (1 point) 4. In cell B24, input the inventories. (1 point) 5. In cell B25, input the other current assets. (1 point) 6. In cell B26, input the function SUM to calculate the total current assets. (1 point) 7. In cell B27. input the gross fixed assets. (1 point) 8. In cell B28. input the accumulated depreciation. Note: The output of the expression or function you typed in this cell is expected as a positive number. (1 point) 9. In cell B29, calculate the net fixed assets. (1 point) 10. In cell B30, input the other assets. (1 point) 11. In cell B31, calculate the total assets. (1 point) 12. In cell B33. input the notes payable amount. (1 point) 13. In cell B34, input the accounts payable amount. (1 point) 14. In cell B35, calculate the total current liabilities. (1 point) 15. In cell B36, input the long-term debt amount. (1 point) 16. In cell B37, calculate the total liabilities. (1 point) 17. In cell B38, input the common stock amount. (1 point) 18. Since the balance sheet must balance, input the total liabilities and equity amount in cell B41 by making a cell reference to the total assets. (1 point) 19. In cell B40, calculate the total equity amount. (1 point) 20. In cell B39, calculate the retained earnings amount. (1 point) 21. In cell B43, calculate the net working capital. (1 point) 22. In cell B44, calculate the debt ratio. (1 point) DATA Cash Account receivables Accounts payable Short-term notes payable Inventories Gross fixed assets Other current assets Long-term debt Common stock Other assets Accumulated depreciation Retained earnings $50,000 42,700 23,000 10.500 40.000 1.280.000 5.000 200.000 490.000 15,000 312.000 ? $50,000 42,700 40.000 5.000 SOLUTION Balance Sheet: Cash Accounts receivable Inventories Other current assets Total current assets Gross fixed assets Accumulated depreciation Net fixed assets Other assets Total assets Notes payable Accounts payable Total current liabilities Long-term debt Total liabilities Common stock Retained earnings Total equity Total liabilities and equity Net Working Capital Debt Ratio Requirements: 1. Start Excel. Download and open the workbook named: Keown_Martin_Petty_Problem_3-4_Start