PLESAE enter in CELL FORMAT
cell "=AVERAGE(B4,B5,C4,C5)" was entered, the formula would output the result of averaging these four cells, or 116,75 7 X 5 - Calculate Select Ratios and using Excel's SUM, AVERAGE and Basic Math Functions ... ? 5 6 nts FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Calibri 11 A A % Paste BIU- A- Alignment Number Cells Conditional Format as Cell Formatting Table Styles Styles eBook Clipboard Font A1 V Condensed financial statements for Games Galore are summarized below: Print A D E B 129,100 $ 29 Net Income 30 31 Required: 32 Compute the following liquidity ratios for 2016. 33 references 34 to to times days times days times 35 Current ratio 36 Acid-test or quick ratio 37 Receivables turnover ratio 38 Average collection periodo 39 Inventory turnover ratio 40 Average days in inventory** 41 42 Compute the following Solvency Ratios for 2016 43 44 Debt to equity ratio 45 Times interest earned ratio 46 47 *This is also called Days to Collect 48 **This is also called Days to Sell 49 50 Compute the following Profitability Ratios for 2016. 51 52 Return on Equity 53 Return on Assets 54 Financial Leverage Percentage 55 Net Profit Margin 56 57 58 59 Sheet1 + 10% READY Attempt(s) cell AVCKAUC104,03,C4,C5 was Emereu, le commuia would output the result of averaging these four cells, or 116,75 7 X H5 - Calculate Select Ratios and using Excel's SUM, AVERAGE and Basic Math Functions ... ? 5 6 nts FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Calibri 11 AA % Paste BIU- A- Alignment Number Cells Conditional Format as Cell Formatting Table Styles Styles eBook Clipboard Font A1 X f Condensed financial statements for Games Galore are summarized below: Print D E "eferences B Condensed financial statements for Games Galore are summarized below: 2 3 Balance Sheet 2016 2015 4 Cash $ 185,000 $ 143,000 5 Accounts Receivable, Net 80,000 59,000 6 Inventory 104,000 134,000 7 Prepaid Insurance 11.900 5.880 8 Total Current Assets 380.900 341,880 9 Property and Equipment, Net 514,500 407,000 10 Total Assets $ 895.400 $ 748.880 11 12 Current Liabilities $ 85,300 $ 96.800 13 Long-term Liabilities 284,000 224,000 14 Total Liabilities 369,300 320.800 15 Contributed Capital 299,000 299,000 16 Retained Earnings 227,100 129,080 17 Total Stockholders' Equity 526,100 428.080 18 Total Liabilities and Stockholders' Equity $ 895,400 $ 748.880 19 20 Income Statement 21 Net Sales (all on account) $ 3,031,000 22 Cost of Goods Sold 1,949,000 23 Gross Profit 1,082,000 24 Operating Expenses 891,400 25 Income from Operations 190.600 26 Interest Expense 14,500 27 Income before Income Tax Expense 176,100 28 Income Tax Expense 47,000 29 Net Income $ 129,100 30 31 Required: 32 Compute the following liquidity ratios for 2016. Sheet1 + 10% READY Attempt(s)
