3 1. Use ratios to analyze a company's liquidity and solvency. Calculate Select Ratios - Excel 76 REVIEW VIEW Sign In FILE HOME INSERT PAGE LAYOUT FORMULAS DATA Calibri 11 AA 96 Paste BIU A Alignment Number Conditional Format as Cell Cells Clipboard Font 2 Formatting Table Styles Styles A40 1 Condensed financial statements for Games Galore are summarized below 3 Balance Sheet 4 Cash 5 Accounts Receivable, Net 6 Inventory Prepaid Insurance 8 Total Current Assets 9 Property and Equipment, Net 10 Total Assets 11 12 Current Liabilities 13 Long term Liabilities 14 Total Liabilities 35 Contributed Capital 16 Retained Earnings 17 Total Stockholders' Equity 2016 2015 185,000 $ 143,000 80.000 59,000 104,000 134,000 11,900 5,880 380,900 341,880 514.500 407,000 S 895,400 5 748,880 85,300 $ 96.800 284000 224,000 369,300 320,800 299.000 299,000 227,100 129.080 526.300 428.080 18 Total Liabilities and Stockholders' Equity 395 400 S 748,880 25 20 Income Statement 21 Net Sales (all on account) 22 Cost of Goods Sold 23 Gross Prof 24 Onector. Ex READY Attempt(s) Sheet1 3031.000 1.949.000 082,000 991.400