2020 2019 2018 2017 2016 2015 2016 2013 ASSETS CURRENT ASSETS Cash and cash equivalents Short-term investments Trade receivables, net of allowances for doubtful accounts of $7,867 and 510,228, respectively Deferred income taxes Prepaid expenses and other current sets Total current assets Property and equipment, net Goodwill Purchased and other intangibles, net Investment in case receivable Other assets Total assets LIABILITIES AND STOCKHOLDERS' EQUITY Current abilities Trade payable Accrued expense Debt and capital lease obligations Accrued restructuring Income taxes payable Deferred revenue Total current liabilities 4478000 2,650,221 1642775 23060721011315 876560 1117400 J4556 1514000 1,526,755 15861871513702 37498851111524 2622091 2339196 1398000 1534,809 1,315,578 1217968 833033 6722006 591800 599820 1370000 95229 102247 256000 783,140 312,499 210071 245445 161802 175758 170110 8146000 6494,925 4,857,0397247813 5839774 4821892 46023284045929 1517000 1.293.015 1,075,072 99 816264 787421 785123 659774 10742000 10,691,199 105.811.048 5821561 5406474 5366881 47219621771981 1359000 1,720,565 2,069,001 385658 414405 510007 469662 605254 48200 H0419 80139 80439 207219 661000 562,692 TH522 143548 149758 159832 126315 90121 24284000 20,762,400 18,768,682 14535556 12707114 11726472 10785829 10380298 93307 300000 1422000 209499 1398548 3149343 186758 1163185 11353 993771 28924 739610 68377 62096 68 656939 603229 14676 17120 6171 23920 10222 1097923 275544 2494415152568 6000 3629000 5512000 55562 337796 8190938 1520 35709 14196 38362 6165 2915974 2405950 1945619 1434200 43011263521457 28116352211556 3620 3.377986 55120008190938 M N 291994 20950 1943619 14347001091973729544 4101126 1577457 2811635 2211556 NOS 152560 411700 130000 1227 S2000 636100 102 1800 221000 12105 11020000 10211245 4126800 180101 1907068 1997231 136 2 5101 1210 10 1730 1941 256129 45700 29141 100700 1200 11 92100 0 5327972 911066149997 500 526 5194 7717 125746 132545 HIS 1796 6115 00966 18 Deleted revenue 69 Totalrent abilities 70 Long term liabilities: 71 Debt and capitale obligations 72 Deferred 73 Accrued restructuring 74 Income taxes payable 75 Defred income to 76 Other labi 7 Totallibilities Ja Commitments and contingudes Stockholiquity 31 Preferred stock, 50.0001 par value 2,000 shares authore, non med 2 common stock. 50.0001 par valor; 900,000 shares authorised, 600,634 shares 497 AM and 496,761 shares outstandin.mpectively 4 Additional paid in capital Retained earnings 36 Accumulated other comprehenvincess H7 Treasury stock, at cou (103,350 and 104,573 shares, respect to reces Total stockholderseguit 09 25000 60000 19615000 1420 DO 183034 115.000 10615234 112 10 10155 24284000 2000 61 61 61 51 61 337 SGD14616 15 177695339216 1181597 70 314517 725141 1249005 10 111803 173603160 46103 2990 2510 511342 06775 391853641190 930211 S00150140 264 1876831651555612307116 1172647 10 29 100 2.4 208 2.09 0.44 1.95 DOS 2.39 141 2.81 DES 91 CURRENT RATIO 92 SOLVENCY RATIOS: 9 CASH RATIO Sheet1 045 0.4 Calculate all liquidity and solvency ratios of the company for all seven years 5 Select one liquidity and one solvency ratio, create a visual (graph/chart) in Excel that communicates the intended information to the reader
