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 eld}. 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. 1'. 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 Positive $537,146 Sources of income Cell F10