$1$

EOC #$5$ CCA Question Page $1$

EOC #$5-$ CCA Excel $(15$ marks$)$

Create an Excel tab for Capital Assets or CCA adapted from T$2125.$ Include the separate charts for

Acquisition of Assets for $2023$ and add in the Personal$/$Business calculation part and the

Depreciation Worksheet. Ensure it is done with formulae and you did not just type in the numbers.

$(10$ marks$)$

Note: Please use the adapted T$2125$ format found in Week $7$ where we discussed assets and capital

cost allowance. There is also an example in the Week $11$ slide deck.

This Year $-$ Insert the following factors to calculate the capital cost allowance $($CCA$).$ UCC at the start

of the year $=0$ for both items.

a$)$ Buy Dishes on August $19$th $,$ for $$145,000$

Personal Usage is $0\%$

Class $8$ and Class rate is $100\%$

b$)$ Purchase computer hardware January $10$th $,$ for $$22,500$

Personal Usage is $25\%$

Class $50$ and Class rate is $55\%$

Overall Formatting for the Excel Worksheet $(5$ marks$)$

$*$ One mark off for each spelling mistake

$*$ The tab will be formatted to fit on one page in Landscape mode. Position it for easy readability.

$*$ Custom Footer will be set up with: Your Name $/$ Tab Name $/$ Page # of Pages $($use field codes for

the last $2)$

$*$ Please shade each cell that can be changed by the user. $($Make sure the numbers are easily

readable$)$

$*$ No Hard Coding that will hinder the correct recalculation of the sheet with new factors

$*$ When saving the file, ensure you have it saved in Normal View plus, it opens at the top left corner

$($A$1$ cell$)$ of the sheet, so it presents nicely when the file is opened.

$*$ Rename the tab to something appropriate.

$*$ You are aiming to create a professional looking workbook. If in doubt, read the Overall Notes of

the Chocolate Shop Case.

$*$ See the adapted T$2125$ examples in the slide decks for weeks $7$ and $11.$

Total: $/15$