Question Related to Ratio (Joshua & White Technologies: December 31 Balance Sheets)

Please fill the blanks in the given excel sheet. And also mention the math you did to get the answer in the near column. Thanks

Joshua & White Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets Cash and cash equivalents Short-term investments Accounts Receivable Inventories Total current assets Net fixed assets Total assets 2019 $21,000 3,759 52,500 84,000 $161,259 223,097 $384,356 Liabilities and equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained Earnings Total common equity Total liabilities and equity $33,600 12,600 19,929 $66,129 67,662 $133,791 178,440 72,125 $250,565 $384,356 Joshua & White Technologies December 31 Income Statements (Thousands of Dollars) 2019 Sales $420,000 COGS except excluding depr. and amort 300,000 Depreciation and Amortization 19,660 Other operating expenses 27,600 EBIT $72,740 Interest Expense 5,740 EBT $67,000 Taxes (25%) 16,750 Net Income $50,250 Common dividends Addition to retained earnings $18,125 $32,125 Other Data Year-end Stock Price # of shares (Thousands) Lease payment (Thousands of Dollars) Sinking fund payment (Thousands of Dol 2019 $90.00 4,052 $20,000 $5,000 Ratio Analysis 2019 Liquidity Ratios Current Ratio Quick Ratio Asset Management Ratios Inventory Turnover (Total COGS/Inventories) Days Sales Outstanding Fixed Assets Turnover Total Assets Turnover Debt Management Ratios Debt Ratio (Total debt-to-assets) Liabilities-to-assets ratio Times-interest-earned ratio EBITDA coverage ratio Profitability Ratios Profit Margin Basic Earning Power Return on Assets Return on Equity Market Value Ratios Earnings per share Price-to-earnings ratio Cash flow per share Price-to-cash flow ratio Book Value per share Market-to-book ratio