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 Q2Q4 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. Q1 Year 2 Magic entry amounts by quarter Amounts in thousands of US dollars Q1 Year 1 1,000 02 Year 1 600 Q3 Year 1 500 Q4 Year 1 1,100 800 Question #1 (fill in the blank cells) Amounts in thousands of US dollars Property & Equipment, net Sales Revenue Operating Expenses Income from Operations (before taxes) Q1 Year 1 Q2 Year 1 (March 31) (June 30) Before your After your Before your After your magic entry magic entry magic entry magic entry $ 38,000 39000 $ 33,000 34600 9,000 9,000 9,100 9,100 8,000 7000 8,500 7900 1,000 2000 600 1200 Q3 Year 1 Q4 Year 1 Q1 Year 2 (Sept 30) (Dec 31) (March 31) Before your After your Before your After your Before your After your magic entry magic entry magic entry magic entry magic entry magic entry $ 35,000 37100 S 36,000 39200 S 37,000 41000 8,900 8,900 8,700 8,700 8,800 8,800 8,600 8100 8,900 7800 8,200 7400 300 800 (200) 900 600 1400 Question #2 (fill in the blank cells) 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, across the applicable quarters Fixed Asset Turnover AFTER the magic entries using average Property and Equipment, Net, across the applicable quarters Net profit margin BEFORE the magic the entries (une income from operations before taxes divided by sales) Net profit margin AFTER the magic the entries (une income from operations before taxes divided by sales)