Please include equations for excel! thank you!

For the Year Ended Dec. 31 2020 As of Dec. 31 2020 2020 Assets 2020 Sales 3,074,000 2,088,000 Cash Accounts Receivable Cost of Goods Sold 431,000 503,000 289,000 Gross Profit 986.000 Inventories Selling and G&A Expenses 294,000 Total Current Assets 1,223,000 Fixed Expenses 35,000 4,669,000 Depreciation Expense 239,000 2,295,000 Gross Fixed Assets Accumulated Depreciation Net Fixed Assets Total Assets EBIT 418,000 2,374,000 3,597,000 Interest Expense 93,000 Earnings Before Taxes 325,000 Liabilities and Owners' Equity Taxes 94,000 231,000 Net Income Accounts Payable Short-term Notes Pershi Accrued Expenses Total Current 382,000 79,000 159,000 620,000 1,023,000 1,643,000 819,000 1,135,000 (a) Please calculate all the ratios given below for Year 2020 (b) Benchmark each ratio using the Industry Average given below. [Bench marking means comparing each ratio with Industry Average and stating whether it is good or poor.] c) Calculate 2 score for the firm assuming it to be a private firm. Long-term Debt Total Liabilities Common Stock Retained Earnings Total Shareholder's Equity Total Liabilities and Owners' Equity 1,954,000 3,597,000 Ratio Current Ratio Quick Ratio Inventory Tumover Ratio Accounts Receivable Tumover Ratio Average Collection Period Total Asset Turnover Industry Value Firm Value 2.00x 0.60x 6.50x 12.00 30.00 days 2.00x Ratio Industry Value Firm Value Debt to Equity 0.90x Times Interest Earned 2.50x Cash Coverage Ratio 3.50x Net Profit Margin 5.00% Return on Total Assets 5.00% Retum on Equity 8.00% Return on Common 10.00% Equity Total Debt Ratio 50.00%