Specifically, each group is required to construct a trend analysis (3 years) and based on their liquidity, activity, profitability, leverage and market position

PLS HELP ME TO DO MY ASSIGMENT TO CULCULATE CALCULATION FOR LIQUIDITY RATIOS ON BELOW TABLE TQ

Title	30 Jun 2021	30 Jun 2020	30 Jun 2019	Trend
Accounts Payable	3,552.00	2,918.00	3,165.00	Bars with all positive values
Accounts Receivable - Trade, Net	2,843.00	2,679.00	2,799.00	Bars with all positive values
Accrued Expenses	1,691.00	1,338.00	1,435.00	Bars with all positive values
Accumulated Depreciation, Total	(3,500)	(3,196)	(3,100)	Bars with all negative values
Additional Paid-In Capital	2,602.00	--
Capital Lease Obligations	1,506.00	1,438.00	2.00	Bars with all positive values
Cash	1,124.00	1,106.00	1,046.00	Bars with all positive values
Cash and Short Term Investments	2,489.00	1,694.00	1,723.00	Bars with all positive values
Common Stock, Total	9,302.00	9,300.00	9,299.00	Bars with all positive values
Current Port. of LT Debt/Capital Leases	439.00	385.00	5.00	Bars with all positive values
Deferred Income Tax	307.00	331.00	289.00	Bars with all positive values
Goodwill, Net	267.00	252.00	225.00	Bars with all positive values
Intangibles, Net	1,362.00	1,344.00	1,259.00	Bars with all positive values
Long Term Debt	373.00	110.00	176.00	Bars with all positive values
Long Term Investments	1,641.00	1,662.00	1,951.00	Bars with all positive values
Minority Interest	377.00	416.00	405.00	Bars with all positive values
Notes Payable/Short Term Debt	1,416.00	2,112.00	2,392.00	Bars with all positive values
Other Current Assets, Total	71.00	81.00	96.00	Bars with all positive values
Other Current liabilities, Total	2,666.00	2,885.00	2,587.00	Bars with all positive values
Other Equity, Total	619.00	181.00	44.00	Bars with all positive values
Other Liabilities, Total	277.00	343.00	347.00	Bars with all positive values
Other Long Term Assets, Total	590.00	716.00	938.00	Bars with all positive values
Prepaid Expenses	673.00	423.00	563.00	Bars with all positive values
Property/Plant/Equipment, Total - Gross	11,763.00	11,601.00	8,827.00	Bars with all positive values
Property/Plant/Equipment, Total - Net	8,263.00	8,405.00	5,727.00	Bars with all positive values
Retained Earnings (Accumulated Deficit)	5,962.00	5,516.00	5,370.00	Bars with all positive values
Short Term Investments	1,365.00	588.00	677.00	Bars with all positive values
Tangible Book Value per Share, Common Eq	2.10	1.97	1.95	Bars with all positive values
Total Assets	28,487.00	27,273.00	25,516.00	Bars with all positive values
Total Common Shares Outstanding	6,802.54	6,801.00	6,801.00	Bars with all positive values
Total Current Assets	15,950.00	14,618.00	15,068.00	Bars with all positive values
Total Current Liabilities	9,764.00	9,638.00	9,584.00	Bars with all positive values
Total Debt	3,734.00	4,045.00	2,575.00	Bars with all positive values
Total Equity	15,883.00	14,997.00	14,713.00	Bars with all positive values
Total Inventory	8,320.00	8,346.00	8,538.00	Bars with all positive values
Total Liabilities	12,604.00	12,276.00	10,803.00	Bars with all positive values
Total Liabilities & Shareholders' Equity	28,487.00	27,273.00	25,516.00	Bars with all positive values
Total Long Term Debt	1,879.00	1,548.00	178.00	Bars with all positive values
Total Receivables, Net	4,397.00	4,074.00	4,148.00	Bars with all positive values
Unrealized Gain (Loss)	0.00	0.00	3.00	Bars with all positive values
Note Receivable - Long Term	414.00	276.00	348.00