AutoSave OFF APO ... 22 ACC 215 Week Seven Serial Problem Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Bady) v 12 X X G ~ APA Wrap Text Percentage AY 3 Insert v Delete w Format : v Paste B 1 I U UV Av = = = Y Merge & Center V 99 Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data Sensitivity F24 fy A B C C D F F G H T I K L M N 0 P Q R S T U W Y 7 Name: Section: in the cells highlighted in grey, enter the appropiate amount or percentage in those cells. When the correct amount or percentage is entered the cell will change color. Use the following selected data from Business Solutions's income statement for the three months ended March 31, 2018, ard from its March 31, 2018 balance sheet to complete the requirements below: computer services revenue, $25,307; net sales (of goods), $18,693: total sales and revenue, $44,000; cast of goods sold, S14,052; nct income, $19,833; quick assets, $90,924; current assets, S95,568 total assets, $120.268; current liabilities, $875; total liabilities, $875; and total equity. $119,393. 10 11 12 Required: 1. Compute the gross margin ratio (both with and without services revenue) and ret profit margin ratio. (Round your percentage answers to 1 decimal place.) 2. Compute the current ratio and acid-test ratio [Round your answers to 1 decimal place.) 3. Compute the debt ratio and equity ratio. (Round your percentage answers to 1 decimal place. 13 14 15 16 17 12 19 20 21 22 23 24 4. What percent of its assets are current what percent are long term (Round your answers to the nearest whole percentage.) 1. With Service Revenue Without Service Revenus Gross margin ratio Net profit mar in ratio 29 30 Current ratio Acid test ratio 32 32 33 34 Debt ratio Equity ratio 36 37 38 39 40 Current assets Lori -term assets 41 42 43 44 Chapter 13 + Ready , 100%