Prepare the calculations requested by your client in Case C using excel. Be sure to show all of your work, including detailed calculations and formulas, as well as explanations for each calculation and items not included in your calculation. The memo should include a calculation of net income for tax purposes, including all sources of income and any applicable deductions, using the Section 3 format. Remember that the individual in Case C was upset with their previous accountant for not explaining their taxes, therefore it is important that your memo includes any formulas used in the calculations (include in cell in excel spreadsheet), a description of any assumptions made as well as explanation of any items not included in your calculation.

Case C: You, CPA, are the tax partner in your own small accounting firm, You CPA LLP. You have just finished meeting with a new client, Ronald Wong , who is a commission salesperson working for Golden Arches Food ("GAF"), a Canadian controlled private corporation (CCPC). Ronald was unhappy with his previous accountant, who never explained anything and was always filing his tax returns late. During the meeting, Ronald provided you with a copy of his previous year's income tax return as well as an overview of his earnings and deductions for the current year. He would like you to prepare a preliminary calculation of net income for tax purposes for him for the 2020 taxation year. Applicable information from the previous year's tax return, as summarized by your assistant, is included in Exhibit II. Your assistant's notes from meeting with Ronald regarding his 2020 earnings are included in Exhibit I. Exhibiti 2020 Tax Information for Ronald During 2020 Ronald's gross salary from his sales job at GAF, not including commissions or allowances, was $114,159 . His commissions for the totalled $ 1,501 . All of this information has been taken from Ronald's year end paystub as he has not received a T4 slip for the year yet. The following amounts were withheld by GAF from Ronald's gross salary according to the paystub: Federal income tax deducted 36,531 Canada Pension Plan (CPP) 2,898 Employment Insurance (EI) 856 Registered pension plan contributions (Note 1) 5,708 Pension adjustment Payments for personal use of company car (Note 2) Union dues (Note 3) Interest paid on employer provided loan (Note 4) Life insurance premiums (Note 5) 11,416 412 457 402 884 Note 1: GAF made a matching contribution to Ronald's pension plan. Note 2: GAF provides Ronald with a vehicle that was purchased several years ago. The current fair market value of the vehicle is $ 14,294 . The vehicle was originally purchased for $ 17,152 , including GST. The vehicle is available for personal and employment use for Ronald .During the current year, the vehicle was driven a total of 22,702 km's of which 10,897 are personal in nature. GAF paid all of the operating costs of the car, a total of $ 4,288 for the current year. While Ron was on vacation for one month, he returned the company car to GAF, even though the employer did not require him to return the car during his absence. Note 3: GAF is a unionized company and therefore Ronald must pay union dues each year. Note 4: On January 1, of the current year, GAF provided Ronald with a low interest loan with a principal amount of 42,881 . The loan requires principal repayments of 4,288 on the first day of each calendar quarter, starting on April 1, The loan does not qualify as a home purchase or home relocation loan. 2020 Note 5: GAF made a matching premium payments towards Ronald's life insurance. Other Information: (a) On March 1, of the current year, Ronald received stock options from GAF to acquire 57.1745 shares for $ 25.73 per share. At the time the options are issued the shares are trading at $ 25.73 per share. In June of the current year, the shares have increased in value to $ 27.01 per share when Mr. Wong exercises his options to acquire 57 shares. On December 31, he sells all of the shares for $ 30.87 per share. (b) Mr. Wong incurred the following sales expenses related to his commission income: Meals (while out of town) $ 1,715 Lodging $ 2,144 Entertainment $ 772 Total Expenses $ 4,631 to a safety in the workplace course. The cost of tuition (c) Ronald's employer sent him for this course was $ 156. (d) Ronald's employer provided him with a gift certificate for his birthday with a value of $ 234. (e) GAF provides Mr. Wong with a membership at the local golf and country club, Seven Oaks. The annual membership costs $ 4,502 and Mr. Wong uses the membership primarily (more than 50% of the time) for golfing with friends. (f) GAF declared bonuses to all of its employees on December 15, of the current year. Ronald's bonus of $9,133 was included with his regular payroll electronic transfer on Jan.3, 2021. 3,300 (g) Mr. Wong purchased a residential property in Edmonton in the prior year. For the current year, the income and expenses related to the rental property are as follows: Rental income per month $ Property tax per month $ 133 Insurance per month S 87 Mortgage payments per month $ 3,170 Principal portion of payments $ 951 Repair to floor damaged by bathroom flood $ 6,770 Closing UCC balance from prior year for Class 1 $ 137,219 (h) Mr. Wong received the following amounts from his investment account with TD Waterhouse: (all amounts in Canadian dollars) Dividends received from CCPC subject to low rates of tax $ Dividends received from foreign corporations $ Interest payment received on December 31, 2020 (Notei) $ 2,698 1,349 3,678 Note (i): The corporate bond has a maturity value of $ 85,762 and an annual interest rate of 1.72% . This bond was issued on July 1, 2018 and will mature ten years later on June 30 2028 . The above mentioned payment is the interest payment for the first 2.5 years of the bond, the remaining interest will be paid with the principal on the maturity date. (i) Ronald incurred the following interest expense amounts during the current year: Interest on the mortgage for Ronald's personal home Interest paid on Ronald's credit card balance Interest on a loan used to purchase investments with TD Waterhouse $ $ $ 4,438 403 1,115 (i) In addition to investing using traditional methods, such as purchasing stocks and bonds, Ronald also liked to invest some of his savings into local businesses. In the previous year, he invested funds into a local food truck business. In the current year, the food truck had a net business loss (for tax purposes) of $ 2,968 . As one of two partners in the business, Ronald's share of the business loss is $ 1,484. Exhibit Il Prior Year Tax Information for Ronald Wong Ronald is 47 years old in the current year. Ronald was previously married. The divorce agreement, which was issued in 2017 requires Ronald to make monthly spousal support payments to the former spouse in the amount of $ 459 . He made all of the required support payments during the current year. Case C: You, CPA, are the tax partner in your own small accounting firm, You CPA LLP. You have just finished meeting with a new client, Ronald Wong , who is a commission salesperson working for Golden Arches Food ("GAF"), a Canadian controlled private corporation (CCPC). Ronald was unhappy with his previous accountant, who never explained anything and was always filing his tax returns late. During the meeting, Ronald provided you with a copy of his previous year's income tax return as well as an overview of his earnings and deductions for the current year. He would like you to prepare a preliminary calculation of net income for tax purposes for him for the 2020 taxation year. Applicable information from the previous year's tax return, as summarized by your assistant, is included in Exhibit II. Your assistant's notes from meeting with Ronald regarding his 2020 earnings are included in Exhibit I. Exhibiti 2020 Tax Information for Ronald During 2020 Ronald's gross salary from his sales job at GAF, not including commissions or allowances, was $114,159 . His commissions for the totalled $ 1,501 . All of this information has been taken from Ronald's year end paystub as he has not received a T4 slip for the year yet. The following amounts were withheld by GAF from Ronald's gross salary according to the paystub: Federal income tax deducted 36,531 Canada Pension Plan (CPP) 2,898 Employment Insurance (EI) 856 Registered pension plan contributions (Note 1) 5,708 Pension adjustment Payments for personal use of company car (Note 2) Union dues (Note 3) Interest paid on employer provided loan (Note 4) Life insurance premiums (Note 5) 11,416 412 457 402 884 Note 1: GAF made a matching contribution to Ronald's pension plan. Note 2: GAF provides Ronald with a vehicle that was purchased several years ago. The current fair market value of the vehicle is $ 14,294 . The vehicle was originally purchased for $ 17,152 , including GST. The vehicle is available for personal and employment use for Ronald .During the current year, the vehicle was driven a total of 22,702 km's of which 10,897 are personal in nature. GAF paid all of the operating costs of the car, a total of $ 4,288 for the current year. While Ron was on vacation for one month, he returned the company car to GAF, even though the employer did not require him to return the car during his absence. Note 3: GAF is a unionized company and therefore Ronald must pay union dues each year. Note 4: On January 1, of the current year, GAF provided Ronald with a low interest loan with a principal amount of 42,881 . The loan requires principal repayments of 4,288 on the first day of each calendar quarter, starting on April 1, The loan does not qualify as a home purchase or home relocation loan. 2020 Note 5: GAF made a matching premium payments towards Ronald's life insurance. Other Information: (a) On March 1, of the current year, Ronald received stock options from GAF to acquire 57.1745 shares for $ 25.73 per share. At the time the options are issued the shares are trading at $ 25.73 per share. In June of the current year, the shares have increased in value to $ 27.01 per share when Mr. Wong exercises his options to acquire 57 shares. On December 31, he sells all of the shares for $ 30.87 per share. (b) Mr. Wong incurred the following sales expenses related to his commission income: Meals (while out of town) $ 1,715 Lodging $ 2,144 Entertainment $ 772 Total Expenses $ 4,631 to a safety in the workplace course. The cost of tuition (c) Ronald's employer sent him for this course was $ 156. (d) Ronald's employer provided him with a gift certificate for his birthday with a value of $ 234. (e) GAF provides Mr. Wong with a membership at the local golf and country club, Seven Oaks. The annual membership costs $ 4,502 and Mr. Wong uses the membership primarily (more than 50% of the time) for golfing with friends. (f) GAF declared bonuses to all of its employees on December 15, of the current year. Ronald's bonus of $9,133 was included with his regular payroll electronic transfer on Jan.3, 2021. 3,300 (g) Mr. Wong purchased a residential property in Edmonton in the prior year. For the current year, the income and expenses related to the rental property are as follows: Rental income per month $ Property tax per month $ 133 Insurance per month S 87 Mortgage payments per month $ 3,170 Principal portion of payments $ 951 Repair to floor damaged by bathroom flood $ 6,770 Closing UCC balance from prior year for Class 1 $ 137,219 (h) Mr. Wong received the following amounts from his investment account with TD Waterhouse: (all amounts in Canadian dollars) Dividends received from CCPC subject to low rates of tax $ Dividends received from foreign corporations $ Interest payment received on December 31, 2020 (Notei) $ 2,698 1,349 3,678 Note (i): The corporate bond has a maturity value of $ 85,762 and an annual interest rate of 1.72% . This bond was issued on July 1, 2018 and will mature ten years later on June 30 2028 . The above mentioned payment is the interest payment for the first 2.5 years of the bond, the remaining interest will be paid with the principal on the maturity date. (i) Ronald incurred the following interest expense amounts during the current year: Interest on the mortgage for Ronald's personal home Interest paid on Ronald's credit card balance Interest on a loan used to purchase investments with TD Waterhouse $ $ $ 4,438 403 1,115 (i) In addition to investing using traditional methods, such as purchasing stocks and bonds, Ronald also liked to invest some of his savings into local businesses. In the previous year, he invested funds into a local food truck business. In the current year, the food truck had a net business loss (for tax purposes) of $ 2,968 . As one of two partners in the business, Ronald's share of the business loss is $ 1,484. Exhibit Il Prior Year Tax Information for Ronald Wong Ronald is 47 years old in the current year. Ronald was previously married. The divorce agreement, which was issued in 2017 requires Ronald to make monthly spousal support payments to the former spouse in the amount of $ 459 . He made all of the required support payments during the current year