please show work or how to enter formula in excel. ty

PREPARING A BALANCE SHEET Prepare a balance sheet from the following information. What is the net working capital and debt ratio? a Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. DATA Cash $50,000 Account receivables 42,700 Accounts payable 23,000 Short-term notes payable 10,500 Inventories 40,000 Gross fixed assets 1,280,000 Other current assets 5,000 Long-term debt 200,000 Common stock 490,000 Other assets 15,000 Accumulated depreciation 312,000 Retained earnings 2 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 $50,000 42,700 23,000 10,500 40,000 1,280,000 5.000 200,000 490,000 15,000 312,000 2 6 DATA 7 Cash 8 Account receivables 9 Accounts payable 10 Short-term notes payable 11 Inventories 12 Gross fixed assets 13 Other current assets 14 Long-term debt 15 Common stock 16 Other assets 17 Accumulated depreciation 18 Retained earnings 19 20 SOLUTION 21 Balance Sheet: 22 Cash 23 Accounts receivable 24 Inventories 25 Other current assets 26 Total current assets 27 Gross fixed assets 28 Accumulated depreciation 29 Net fixed assets 30 Other assets 31 Total assets 32 33 Notes payable 34 Accounts payable 35 Total current liabilities 36 Long-term debt 37 Total liabilities 38 Common stock 39 Retained earnings 40 Total equity 41 Total liabilities and equity 42 43 Net Working Capital 44 Debt Ratio 45 46 Requirements