please help with the green boxes

The balance sheet and income statement for the J P. Robard Mfg Company are as follows: 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 green cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. Given Data: J.P. Robard Mfg., Inc. Balance Sheet (5000) Cash $500.00 Accounts receivable $2,000.00 Inventories $1,000.00 Current assets $3,500.00 Net fixed assets $4,500.00 Total assets $8,000.00 Accounts payable Accrued expenses Short-term notes payable Current liabilities Long-term debt Owners' equity Total liabilities and owners' equity $1,100.00 S600.00 $300.00 $2,000.00 $2,000.00 $4,000.00 $8,000.00 3 4 5 6 17 J. P. Robard Mfg., Inc. Income Statement ($000) Net sales (all credit) Cost of goods sold Gross profit Operating expenses (includes $500 depreciation) Net operating income Interest expense Earnings before taxes Income taxes (40%) Net income 9 $8,000.00 ($3,300.00) $4,700.00 ($3,000.00) $1,700.00 ($367.00) $1,333.00 ($533.00) $800.00 0 Days in a year 365 Calculate the following ratios: Current ratio Times interest earned Inventory turnover Total asset turnover Operating profit margin Operating return on assets Debt ratio Average collection period Fixed asset turnover Return on equity