TAXATION I Data Analytics Assignment Fall 2021 Enter your name or group number here Section Marks Available | Marks Earned] Multiple Choice 6 Supporting calculations 30 Income Statement 10 Income Tax Returns 20 Total Marks 66 Requirements for the Excel analysis (see detailed instructions for further details on these requirements) 1. There are some transactions not from the current taxation year in the data set (see the Date field). Remove any transactions from another taxation year and adjust the January income deposit based on the taxpayer's accounts receivable information. 2. Analyze the taxpayer's income by location using a pivot table. Analyze the income by inserting a pivot chart that shows the total income by location. 3. Analyze the home office expenses using a pivot table. 4. Analyze the motor vehicle expenses using a pivot table. 5. Analyze the travel expenses using a pivot table. 6. Analyze the conference expenses using a pivot table. 7. Analyze the administrative expenses, including any rebates, using a pivot table. 8. Analyze the capital asset purchases and calculate the maximum Capital Cost Allowance available using the table provided. CHECK FIGURES: Requirement 1 Utility Bill Payment - Electricity $942.95 Requirement 2 Oil change and filter service $391.53 Requirement 3 Accommodations - Regina $2,193.72 Requirement 4 Travel - Cab Montreal $28.84 Requirement 5 CCA - Balance - Cell E2 $7,875.94 Requirement 6 Income Tax Returns - Total $537,146 Positive Sources of Income - CellLocation Information: The doctor's home town, where he works at the local hospital and clinic: Toronto, Ontario The doctor travels for work to: Regina, Saskatchewan The doctor attends a medical conference during the year in: Montreal, Quebec Undepreciated Capital Cost [UCC) at December 31, of the prior year: Class 12 = $1,800 Class 50 = $2,200 Class 8 = $7,500 RRSP Contribution Room, per prior year's Notice of Assessment: Or. Cranston = $37,900 Carrie = $48,700 RRSP contribution receipts: Dr. Cranston (contributor) Amount = $15,500; Date of contribution = July 22, of the current year. Carrie Cranston (contributor) Amount = $1,200; Date of contribution = August 20, of the current year. Accounts Receivable: $3,651.70 Condo: Office square feet: 150 Total condo square feet: 1,500 Personal Internet usage: 75% Vehicle: Business use kilometres: 2,850 Total kilometres: 11,400 Carrie: Contract income: $22,100 Bookkeeping services: $7,500 Medical: $1,100 Investment information: Counsel fees: $350 T5: $320 T3: $480Use the dropdown boz provided to select one letter. Using the pivot table you created for Or. Cranston, what is the total deductible home office expenses for the current taxation year? 13,881.69 B. 1,388.17 C. 1,570.87 2.484.37 Using the pivot table you created for Dr. Cranston, what is the total deductible motor vehicle expenses for the current taxation year? A. 5,405.80 B. 6,605.80 C. 1,651.45 2,551.45 Using the pivot table you created for Or. Cranston, what is the total deductible travel expenses for the current taxation year? $ 6,994.18 B. $ 5,994.84 C. 7,057.16 7,330.16 Using the pivot table you created for Or. Cranston, what is the deductible conference expenses for the current taxation year? A. $ 1,429.91 B. 1,343.29 C. 1,268.29 830.45 Using the pivot table you created for Or. Cranston, what is the maximum CCA deduction for the current taxation A. 1.039.13 B. 11,500.00 C. 7.456.31 5,082.82 After completion of the tax return, what is the taxable income for Or. Cranston and Carrie, respectively, in the current taxation year? A. $516,726 and $28,625 B. $537,146 and $29,825 C. $521,421 and $23,480 $521,646 and $23,705Dr. Doug Cranston Income Statement For the Year Ended December 31, 2021 (Unaudited) 2021 Professional Income - Expenses Administrative expenses Clinic fees Travel expenses Capital Cost Allowance Bookkeeping services Conference expenses Motor vehicle expenses Home office expenses Business use cellphone Office supplies S Professional Income (loss) - Agrees to T2125 Schedule