1 ABC BCD DCB KFA UDF IDK 6,325 8,894 16,334 2,602 1,258 11,113 801 1,785 314 (455) 345 (688) 484 1,531 321 1,009 146 589 1,621 218 416 1,088 285 1,919 189 123 303 254 423 1,825 1,699 4,314 1,757 1,977 1,132 21,266 428 12,138 4,138 11,411 1,577 8,132 2,975 350 1,278 7,032 11,438 12,357 497 9,224 3,713 313 2 Revenues 8,310 16,148 70,209 3 Cost of revenues 6,657 11,849 45,301 4 EBIT 2,149 3,918 5 Interest expenses 48 220 620 6 Net income 1,285 2,114 7 Cash & marketable securities 459 679 8 Account receivable 72 2,047 9 inventories 1,603 12,231 10 accounts payable 3,040 8,039 11 current assests 793 4,852 13,828 12 PP&E 2,453 6,859 17,432 13 intangible assets 2,109 1,274 285 14 current liabilites 1,274 6,336 13,297 15 debt 1,083 7,235 15,823 16 equity 2,243 15 3,234 17 dividends 351 1,275 1,320 18 19 Use the data above to calculate the Balance Sheet ratios below. 20 21 Insert the correct formula for Company 1 (column E) and calculate the answer 22 23 Correctly copy formulas from Company 1 (column E) to Company 2-6 (columns E-J) 24 25 ABC BCD DCB KFA 26 Days of inventory (DIO) 27 Receivable days (DSO) 28 Days Payable outstanding (DPO) 29 Current ratio 30 Cash to current liabilities 31 Acid test ratio 32 Interest coverage 33 Debt/equity UDF IDK 24