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 Property & Equipment, net Sales Revenue Operating Expenses Income from Operations before taxes 9 10 91 Year 1 March 31) Before your magie mapicantry entry 38,000 33,000 9,000 10,000 7.000 2,000 Q2 Year 1 Q3 Year 1 Uune 30 (Sept 30 Before your Alter your Before your After your magic entry magic entry mapc entry magic entry 33,000 34,600 S 35,000 + 37.100 9,100 10,700 8,900 11,000 8.500 7,500 8.600 8.100 600 1200 300 800 Q4 Year 1 Q1 Year 2 (Dec 31) (March 31) Before your After your Before your After your magic entry magic entry magic entry magic entry S 36,000 39,200 S 37,000 $ 41,000 8,700 11,900 8,800 12,800 8.900 7,800 3,200 7400 (200) 900 600 1400 12 0.000 1,000 16 Question 2 il in the blank cells) Q2 Year Ol Year1 94 Year1 91 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. across the applicable quarters Net profit margin BEFORE the magic the entries fune income from operations before taxes 20 divided by sales) Net profit margin AFTER the magic the entries June income from operations before taxes 21 divided by sales