Compute ratios - Liquidity and Solvency Ratios and an Appendix for those Ratios. (2020 & 2021)

(I already did the Profitability Ratios but I need help with the Liquidity and Solv

Ratio Analysis	2021	2020			Ratio Appendix
Liquidity Analysis	Current Year	Prior Year	Comparison		Ratio	Computation	Current Year	Prior Year
Current Ratio					Current ratio	current assets/current liabilities
Acid-test ratio (quick ratio					Acid-test ratio (quick ratio)	cash+marketable securities+current receivables / current liabilities
Cash flow from operations to current liabilities ratio					Cash flow from operations to current liabilities ratio	net cash calses/average accounts receivable
Accounts Receivable turnover ratio					accounts receivable turnover ratio	Net credit sales / average accounts receivable
Number of days sales in receivables					number of days sales in receivables	number of days in the period/accounts receivable turnover
inventory turnover ratio					inventory turnover ratio	cost of goods sold/average inventory
Number of days sales in inventory					number of days sales in inventory	number of days in the period/inventory turnover
Solvency Analysis					Solvency Analysis
debt-to-equity ratio					Debt-to-equity ratio	total liabilities/shareholder equity
times interest earned ratio					times interest earned ratio	net income + interest expense = income tax expense / interest expense

ency part)

I made a template for the Ratios and Included the Income and Balance sheet.

Breakdown 3/31/2021 3/31/2020 3/31/2019 3/31/2018 62,267,140,000 52,680,436,000 51,936,949,000 50,308,249,000 37,978,811.000 31,942,754,000 31,869,812,000 30,878,147,000 24,288,329,000 20,737,682,000 20,067,137,000 19,430,102,000 36,538,351,000 30,753,516,000 29,899,097,000 28,742,356,000 23,404,547,000 20,060,618,000 19,348,152.000 18,735,982,000 > Total Assets > Total Liabilities Net Minority Int... > Total Equity Gross Minority Inte... Total Capitalization Common Stock Equity Capital Lease Obligations Net Tangible Assets Working Capital Invested Capital Tangible Book Value Total Debt 360,891,000 22,295,913,000 20.060,618,000 19,348,152.000 18,735,982.000 1,316,334.000 740,154,000 652,299,000 355,765,000 48,703,290,000 40,613,587.000 39,498,331,000 38,083,546,000 22,295,913,000 20,060,618,000 19,348,152.000 18,735,982.000 25,659,634,000 20,552,969,000 20,150,179.000 19,347,564,000 Net Debt 20,197,886,000 16,362,451,000 16,575,475,000 16,295,295,000 3,262,997 3,262,997 3,262,997 3,262,997 Share Issued Ordinary Shares Number 2,795.949 2,766,153 2,832,439 2,909,924 Treasury Shares Number 467,049 496,845 430,558 353,074 Breakdown 3/31/2021 3/31/2020 3/31/2019 3/31/2018 > Total Revenue 27.214,593,000 29.929.992.000 30,225,681,000 29,379,510,000 Cost of Revenue 22,382.220,000 24,522,364,000 24,781,785,000 23,889,153,000 4,832,373.000 5,407,628,000 5,443,896,000 5,490,357,000 2,634.625.000 2,964,759,000 2.976,351.000 3,090,495,000 2,197.748.000 2,442,869,000 2,467,545,000 2,399.862.000 298,854,000 200.653,000 197.417.000 151,955,000 435,751,000 -88,915,000 -379,497.000 68,612,000 2.932.354.000 2,554,607,000 2,285,465,000 2,620,429.000 Gross Profit > Operating Expense Operating Income > Net Non Operating interest Inc. > Other Income Expense Pretax Income Tax Provision Earnings from Equity Interest Net... > Net Income Common Stockhold. Average Dilution Earnings Diluted Ni Available to Com Stockh... Basic EPS Diluted EPS 649,976,000 683.430,000 659.944.000 504,406,000 271.152.000 360.066.000 470,083,000 2,257.830,000 2,058.899,000 1,868,085,000 2,481,692.000 12,569.000 17.284.000 14,788,000 12,287.000 2.257.830,000 2,076,183,000 1,882.873,000 2,493.979.000 1.47k 130k 1.68% 1.46k 1.29 1.67K Basic Average Shares 1,399,459 1,435,767 1.473,683 1,423,009 1,459,337 1.497,383 2,197,748,000 2,442,869,000 2,467,545,000 2,399.862.000 25,016,845,000 27,487.123.000 27,758,136.000 26,979,648,000 Diluted Average Shares Total Operating Income as Reported Total Expenses Net Income from Continuing & Dis... Normalized Income Interest Income Interest Expense 2,245.261,000 2,076,183,000 1,882,873,000 2,493.983.000 2,164.365.338 2,152,032,840 2,116,545,994 2.475.670.488 105,600,000 232,870,000 225.495.000 179,541,000 42,421,000 32.217.000 28,078,000 27.586.000 Net Interest Income 298,854,000 200,653,000 197,417,000 151,955,000 EBIT 2,974,775.000 2,586,824,000 2,313,543,000 2,648,015.000 EBITDA Reconciled Cost of Revenue 22,382.220,000 24,522,364.000 24,781.785,000 23,889,153,000 1,644.290.000 1,605,383,000 1,792.375,000 1,734.033.000 2.245.261,000 2,076,183,000 1,882.873,000 2,493.983.000 103,979,000 -103,620,000 -328,654,000 22,664,000 Reconciled Depreciation Net Income from Continuing Oper... Total Unusual Items Excluding Go... Total Unusual Items Normalized EBITDA Tax Rate for Calcs Tax Effect of Unusual Items 103,979,000 -103,620,000 -328,654,000 22.664,000 4.515.086.000 4,295,827,000 4,434,572,000 4,359,384.000 0 0 0 0 23.083,338 -27,770,160 -94.981,006 4.351.488