14 Requirements for the Excel analysis 1. There are some transactions not from the current taxation year in the data set (see the Date field). Remove any tansactions from another taxation year and adjust the Janary income 15 depout based on the taxpayer's accounts receivable information. 16 1. Analyze the taxpayer's income by location using a pivot table. Analyze the income by inserting a pivot chart that shoes the total income by cation 17 3. Analyse the home office expenses using a pivot table. 18 4. Analyze the motor vehicle expenses using a pivot table. 19 5. Analyze the travel expenses ining a pivot table. 20 6. Analyze the conference expenses ssing a pivot table 21 7. Analyze the administrative expenses, including suy rebates, using a pivot table 22. Analyze the capital asset purchases and calculate the maximum Capital Cost Allowance available wing the table provided 23 24 CHECK FIGURES Unity Bill Payment-Electricity 25 Requirement 2 Requirement 2 Oil change and her service 27 Requirement 3 Accommodations Winnipeg Requirement 4 P 2 Requirement 5 CCA Balance C 589066 545801 $4130 $46023 Requirement 6 Income Tax Retuna Total Positive Soences 1506137 30 of Income Cell F10 21 4 Using the pivot table you created for Dr. Bertuzzi, what is the total deductible home office expenses for the current taxation year? 5 A. $ 2,443.38 6 B. $ 1,328.28 7 C. $ 13,282.80 8 D. $ 1,514.13 9 Using the pivot table you created for Dr. Bertuzzi, what is the total deductible motor vehicle expenses for the current taxation year? 10 11 A. $ 5,700.90 12 B. $ 1,361.08 13 C $ 5,300.90 14 D. $ 1,033.60 15 16 Using the pivot table you created for Dr. Bertuzzi, what is the total deductible travel expenses for the current taxation year? 17 A $6,159.64 18 B. $5,181.44 19 C. $ 6,509.62 20 D. $6,234.71 21 Using the pivot table you created for Dr. Bertuzzi, what is then net administrative expenses for the current taxation year? 22 23 A $ 11,582.20 24 $ 18,385.00 25 C $ 8,635.00 26 D $ 21,332.20 27 Using the pivot table you created for Dr. Bertuzzi, what is the maximum CCA deduction for the current taxation year? 28 29 A $ 3,621.76 30 $ 5,064.16 21 C $ 7,750.00 32 D 33 $ 935.92 34 After completion of the tax return, what is the taxable income for Dr. Bertuzzi and Sandra, respectively, in the current taxation year? 35 A $557,637 and 528,325 368 5561,812 and $23,500 37 C $562,137 and $2.3825 38 0 $586,137 and 529,525 39