WIL JIUUU AU Q2 TAL UPCIUS CAPISCS WUUU ULICUULUU JUUU. 2. Complete the second table in the Excel document on D2L using both before and after the magic entry numbers. You will need to compute the fixed asset turnover ratio (rounded to three decimal places) for the periods ended Q2-Q4 of year 1 and Q1 of year 2. Note you can't answer this for Q1 of Year 1 because you don't have beginning Property and Equipment, Net. For these same 4 quarters also calculate the net profit margin before and after the magic entry. Discuss in 2-4 sentences in a text box what you notice about the ratios. 5 Question #1 (fill in the blank cells) Amounts in thousands of US dollars 9 Property & Equipment, net 10 Sales Revenue 11 Operating Expenses 12 Income from Operations (before taxes) Q1 Year 1 Q2 Year 1 Q3 Year 1 Q4 Year 1 Q1 Year 2 (March 31) (June 30) (Sept 30) (Dec 31) March 31) Before your magic Before your After your Before your After your Before your After your Before your After your magic entry entry magic entry magic entry magic entry magic entry magic entry magic entry magic entry magic entry $ 38,000 $ 39,000 $ 33,000 $ 34,600 $ 35,000 $ 37,100 $ 36,000 $ 39,200 $ 37,000 $ 41,000 9,000 10,000 9,100 10,700 8,900 11,000 8,700 11,900 8,800 12,800 8,000 7,000 8,500 7,900 8,600 8,100 8,900 7,800 8,200 7,400 1,000 2,000 600 1,200 300 800 (200) 900 1,400 600 13 16 Question #2 (fill in the blank cells) 17 Q2 Year 1 Q3 Year 1 Q4 Year 1 Q1 Year 2 Fixed Asset Turnover BEFORE the magic entries using average Property and Equipment, Net, 18 across the applicable quarters Fixed Asset Turnover AFTER the magic entries using average Property and Equipment, Net, 19 across the applicable quarters Net profit margin BEFORE the magic the entries (une income from operations before taxes 20 divided by sales) Net profit margin AFTER the magic the entries (une income from operations before taxes 21 divided by sales)