Question

2 3393 3746 24 263 10646 2125 2365 2867 201 99 PP 29 Net Sales COGS Net Income Accounts Receivable Inventory Current Assets Fixed Assets Total Assets Current Liabilities Long-Term Debt Total Liabilities Shareholder's Equity Number of Shares Outstanding 14 7469 4869 12338 2553 242 2795 9543 1993 377 1103 1480 317 351 668 812 102 25 75 17 54

Answer 1

Sen = answer - Excel 0 - Sign in 0 x & Share Formulas Data Review View Tell me what you want to do... General AutoSum - A File Home Insert Page Layout Cut Calibri Le Copy Paste Format Painter BIU- Clipboard Font 11 - AA === A EE Wrap Text Merge & Center, B AutoSum " Ay E E D. % $ 8,98 Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Clear Sort & Find & Filter Select Editing Alignment Number Cells C36 E F company 1 company 2 company 3 3 current rario= current asset/current liability 4 current asset 5 current liability 7469 2553 377 88 317 25 2.93 3.52 7 current ratio = 8 9 quick ratio = (current asset-inventories)/current liabilty 10 11 current asset 12 current liability 13 inventories 14 15 quick ratio = 16 7469 2553 377 317 29 2.93 1.10 17 2867 18 debtors days=(year end trade debtors/sales)*number of days 19 20 debtors 21 sales 22 doltare du T Sheet1 € Ready 10646 365 263 3393 365 15 201 Activate Wi26Sows Ge te Settings to activate Windows 9 - - + 21:56 7 100% о в ее соха ^ E 105/03/2020

Sen = answer - Excel 0 x 2. Share Formulas Data Review View Tell me what you want to do... Η General File Home Insert Page Layout Cut Calibri Le Copy Paste Format Painter BIU- Clipboard 11 - AA === A EE Wrap Text Merge & Center, 0 - Sign in Σ AutoSum ' Α 9 Sort & Find & Clear Filter Select Editing E E D. % $ 8,98 Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Alignment Number Cells C36 A Ε Τ Ε 18 debtors days=(year end trade debtors/sales)*number of days 19 20 debtors 21 sales 2867 10646 365 98 263 3393 365 28 15 201 365 27 23 debtors days = 2125 25 26 inventory holding period 27 365/inventory turnoverratio 28 inventoryturnoverratio=cost of goods sold/inventory 29 cost of goods sold 30 inventory 31 inventoryturnoverratio= 32 no of days 33 inventory holding period= (days) 34 1 3746 29 129.17 365 3 99 18 5.50 2125.00 365 0 365 66 36 answers 37 question 1 38 question 2 39 question 3 o lauoction company 3 company 2 company 3 Sheet1 – Activate Windows Go to Settings to activate Windows @ - - + 21:56 Ready 100% lo Bi e a x 9 x ^ E 105/03/2020

Sen = answer - Excel 0 x 2. Share Formulas Data Review View Tell me what you want to do... Η General File Home Insert Page Layout Cut Calibri Le Copy Paste Format Painter BIU- Clipboard Font 11 - AA === A EE Wrap Text Merge & Center, 0 - Sign in Σ AutoSum ' Α 9 Sort & Find & Clear Filter Select Editing E E D. % $ 8,98 Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Alignment Number Cells C36 V foc E F 20 debtors 21 sales 2867 10646 365 98 263 3393 365 28 15 201 365 27 23 debtors days = 24 2125 26 inventory holding period 27 365/inventory turnoverratio 28 inventoryturnoverratio=cost of goods sold/inventory 29 cost of goods sold 30 inventory 31 inventoryturnoverratio= 32 no of days 33 inventory holding period= (days) 34 1 3746 29 129.17 365 3 99 18 5.50 2125.00 365 0 365 66 36 answers 37 question 1 38 question 2 39 question 3 40 question 4 company 3 company 2 company 3 company 3 41 Sheet1 Activate Windows Go to Settings to activate Windows 0 -A 21:56 ^ 105/03/2020 Ready o e D 9 x] E
please do a like for my rating if you like the answer .