Just need help on the formulas to use in excel to get the answers

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 2018 $21,000 3,759 52,500 84,000 $161,259 218,400 $379,659 2017 $20,000 3,240 48,000 56,000 $127,240 200,000 $327,240 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 183,793 62,075 $245,868 $379,659 $32,000 12,000 6,480 $50,480 58,320 $108,800 178,440 40,000 $218.440 $327,240 Joshua & White Technologies December 31 Income Statements (Thousands of Dollars) 2018 2017 Sales $420,000 $400,000 COGS except excluding depr. and amort. 300,000 298,000 Depreciation and Amortization 19,660 18,000 Other operating expenses 27,600 22,000 EBIT $72,740 $62,000 Interest Expense 5,740 4,460 EBT $67,000 $57,540 Taxes (40%) 26,800 23,016 Net Income $40,200 $34,524 Common dividends Addition to retained earnings $18,125 $22,075 $17,262 $17,262 Other Data Year-end Stock Price # of shares (Thousands) Lease payment (Thousands of Dollars) Sinking fund payment (Thousands of Dollai 2018 $90.00 4,052 $20,000 $5,000 2017 $96.00 4,000 $20,000 $5,000 2018 2017 Industry Avg 2.58 1.53 Ratio Analysis (15 points) Liquidity Ratios Current Ratio Quick Ratio Asset Management Ratios Inventory Turnover (Total COGS/Inventories) Days Sales Outstanding Fixed Assets Turnover Total Assets Turnover 7.69 47.45 2.04 1.23