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 Q2Q4 of year 1 and Q1 of year 2. Note you cant answer this for Q1 of Year 1 because you dont 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.

B DE 2 Magic entry amounts by quarter 3 Amounts in thousands of US dollars Q1 Year 1 1,000 Q2 Year 1 600 Q3 Year 1 500 Q4 Year 1 1,100 Q1 Year 2 800 4 5 Question #1 (fill in the blank cells) 8 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 $ 39,000 $ 33,000 $ 34,600 9,000 9,000 9,100 9,100 8,000 7,000 8,500 7,900 1,000 2,000 600 1,200 Q3 Year 1 (Sept 30) Before your After your magic entry magic entry $ 35,000 $ 37,100 8,900 8,900 8,600 8,100 300 800 Q4 Year 1 (Dec 31) Before your After your magic entry magic entry $ 36,000 $ 39,200 8,700 8,700 8,900 7,800 (200) 900 Q1 Year 2 (March 31) Before your After your magic entry magic entry $ 37,000 $ 41,000 8,800 8,800 8,200 7,400 600 1,400 Amounts in thousands of US dollars 9 Property & Equipment, net 10 Sales Revenue 11 Operating Expenses 12 Income from Operations (before taxes) 13 14 15 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) 22