HOME Paste 1 2 3 4 5 6 7 8 CO 9 CLICK HERE TO SAVE...

Transcribed Image Text:

HOME Paste 1 2 3 4 5 6 7 8 CO 9 CLICK HERE TO SAVE YOUR WORK 10 12 * Cut 18 DATA 19 20 21 20 Copy application software 11 office desk E14 A Class 1 [6%] Class 8 Class 10 BMW-100% business use class VIEW K < > Font Name - Sample CCA Dennis is the owner of Aloha Bakery [a proprietorship] which has a year end of December 31. He has the following UCC balances at January 1, 2022 B i Sheet1 B The following additions were made in 2022 250,000 45,000 25,000 Font Size - 3,500 20,000 C 85,000 New. U A car which cost $29,000 was sold for $26,000. UCC opening additions TabStop S D 13 14 15 16 Required: using the CCA schedule below, determine Dennis' maximum CCA claim for 2022. 17 2Wrap Text Overling Saving your work for grading: E disposals Merge Cell F balance half year G Accll Insert Column Remember to press the yellow button to save your work. A link to your spreadsheet will be placed in the clipboard. Click the Moodle tab and follow the instructions to paste your link for grading. If you make changes to your spreadsheet, click the yellow button to save. There is no need to paste another link to your spreadsheet. 3 Insert Row H "Delete Column CCA base >Delete Row I rate ly CCA Conditional Formatting Remove Conditional Formats K UCC ending L M Table N Moodle XQ E Paste 1 HOME 2 3 4 5 6 7 9 DATA * Cut Copy CLICK HERE TO SAVE YOUR WORK X VIEW Font Name - H14 A Sample net income Sheet1 Bi HO AUS New Tab B New! Font Size - TabStop C D 10 Required: Determine Dennis' net employment income 11 12 13 14 15 16 17 18 19 20 21 22 23 24 X New Tab 2 Wrap Text Overline E Dennis is an employee of XYZ Inc. In 2022 he earned salary of $75,000 XYZ provided Dennis with a Acura RDX which costed them $60,000 to purchase. The car was available for the entire year. Dennis drove a total of 20,000 km of which 5,000 were for employment purposes. XYZ paid for all of the operating costs. Union dues of $1,000, CPP and El of $3,992, and income tax of 15,000 were deducted from his paycheque. Merge Cell F X G Insert Column Insert Row H Delete Column Saving your work for grading: Remember to press the yellow button to save your work. A link to your spreadsheet will be placed in the clipboard. Click the Moodle tab and follow the instructions to paste your link for grading. If you make changes to your spreadsheet, click the yellow button to save. There is no need to paste another link to your spreadsheet. >Delete Row hw J Conditional Formatting Remove Conditional Formats K Table M N O HOME Paste 1 2 3 4 5 6 7 8 CO 9 CLICK HERE TO SAVE YOUR WORK 10 12 * Cut 18 DATA 19 20 21 20 Copy application software 11 office desk E14 A Class 1 [6%] Class 8 Class 10 BMW-100% business use class VIEW K < > Font Name - Sample CCA Dennis is the owner of Aloha Bakery [a proprietorship] which has a year end of December 31. He has the following UCC balances at January 1, 2022 B i Sheet1 B The following additions were made in 2022 250,000 45,000 25,000 Font Size - 3,500 20,000 C 85,000 New. U A car which cost $29,000 was sold for $26,000. UCC opening additions TabStop S D 13 14 15 16 Required: using the CCA schedule below, determine Dennis' maximum CCA claim for 2022. 17 2Wrap Text Overling Saving your work for grading: E disposals Merge Cell F balance half year G Accll Insert Column Remember to press the yellow button to save your work. A link to your spreadsheet will be placed in the clipboard. Click the Moodle tab and follow the instructions to paste your link for grading. If you make changes to your spreadsheet, click the yellow button to save. There is no need to paste another link to your spreadsheet. 3 Insert Row H "Delete Column CCA base >Delete Row I rate ly CCA Conditional Formatting Remove Conditional Formats K UCC ending L M Table N Moodle XQ E Paste 1 HOME 2 3 4 5 6 7 9 DATA * Cut Copy CLICK HERE TO SAVE YOUR WORK X VIEW Font Name - H14 A Sample net income Sheet1 Bi HO AUS New Tab B New! Font Size - TabStop C D 10 Required: Determine Dennis' net employment income 11 12 13 14 15 16 17 18 19 20 21 22 23 24 X New Tab 2 Wrap Text Overline E Dennis is an employee of XYZ Inc. In 2022 he earned salary of $75,000 XYZ provided Dennis with a Acura RDX which costed them $60,000 to purchase. The car was available for the entire year. Dennis drove a total of 20,000 km of which 5,000 were for employment purposes. XYZ paid for all of the operating costs. Union dues of $1,000, CPP and El of $3,992, and income tax of 15,000 were deducted from his paycheque. Merge Cell F X G Insert Column Insert Row H Delete Column Saving your work for grading: Remember to press the yellow button to save your work. A link to your spreadsheet will be placed in the clipboard. Click the Moodle tab and follow the instructions to paste your link for grading. If you make changes to your spreadsheet, click the yellow button to save. There is no need to paste another link to your spreadsheet. >Delete Row hw J Conditional Formatting Remove Conditional Formats K Table M N O