Matilda Bracken Excel Problem Ms. Matilda Bracken is a Certified Financial Planner (CFP) with many years of successful experience. In 2017, she decided that she was not adequately appreciated in her current position with a large financial institution in Windsor, Ontario. Given this, she resigned on November 1, 2017. After several months of investigation, she decided to take a position with Retirement Planners Ltd. (RPL), a Canadian controlled private corporation located in London, Ontario. She commenced working for RPL on May 1, 2018. She owned a home in Windsor which she had acquired several years ago for $375,000. Because of the depressed real estate market in this area, she was eventually forced to sell the property for $275,000 in October 2018, resulting in a $100,000 loss on this property. Because of the uncertainty surrounding the sale of her Windsor property, she moved into an apartment when she arrived in London on May 1, 2018. The apartment was rented on a monthly basis until November 30, 2018. After she accepts an offer to purchase her Windsor house, she finds a home in London that she purchases on November 1, 2018 for $420,000. She moves into this new home on December 1, 2018. Other Information: 1. Because of her strong professional reputation, RPL paid her a signing bonus of $12,000. The signing bonus was paid on June 1, 2018. 2. During the period May 1, 2018 through December 31, 2018, Matilda earned salary of $124,000. Of these earnings, $120,125 was paid during the period with the remainder paid in the first pay period of 2019. The company withheld the following amounts from her salary: Income taxes $18,650 CPP 2,564 836 RPP Contributions 3,700 Payment for personal use of automobile 880 3. RPL contributed $3,500 on Matilda's behalf to the Company's RPP 4. RPL provides group medical coverage to all of its employees. The private health plan premiums paid by RPL on Matilda's behalf cost $562 for the year. 5. On December 12, 2018, a bonus of $10,600 was accrued for Matilda. Matilda received $5,300 of this bonus on December 29, 2018, with the remainder being paid on January 17, 2019. 6. During the year, Matilda received two non-cash gifts, a birthday gift worth $350 and a Christmas gift worth $300. 7. Because of the need to invest some of her additional income, RPL provided Matilda with financial counseling services. The value of these services as $1,200. 8. In order to assist her move, RPL agreed to compensate her for one-half of the $100,000 loss on the sale of her Windsor home. The $50,000 payment was made on December 1, 2018 9. In order to help Matilda with financing her new London residence, RPL provided her with a $220,000 interest free housing loan. The funds are provided to Matilda on November 1, 2018. Assume that the prescribed rate for all of 2018 is 2 percent. 10. RPL has a stock option plan for its employees. Under this plan, employees are permitted to acquire a limited number of option shares at 10 percent below their fair market value on December 1 of each year. The company hires valuators to determine the fair market value at each of those dates. Matilda acquires 200 shares on December 1, 2018 for cash of $7,200. On December 15, she sells 100 of these shares for $4,100. 11. Matilda paid $1,600 in CFP dues in 2018. RPL's policy is to reimburse 50 percent of such professional dues. RPL reimbursed her $800 in December, 2018. 12. RPL provides its professional employees with a membership in the London Curling Club. They believe this is a useful venue for entertaining clients of the Company. The cost of this annual membership was $1,300. 13. RPL provides Matilda with a vehicle that was purchased in 2018 for $45,200, including HST. The vehicle was used by Matilda for all months during the period May 1, 2018 through December 31, 2018. During this period, she drove the vehicle a total of 52,000 kilometers, of which 40,000 were related to her employment duties. RPL pays all operating and maintenance costs, a total of $8,900 during the period that Matilda used the car. RPL withheld $110 per month from her salary to pay for her personal use of the vehicle. 14. Matilda's new job requires her to meet with clients outside of regular office hours throughout the week. RPL will sign a T2200 stating that she is required to pay for certain employment expenses without reimbursement and use a portion of her home for work. Matilda has set aside a separate room in her apartment to be used exclusively to meet the clients. She used this office space between May 1 and November 30, 2018. This home office occupied 150 square feet of the 1,250 square feet available in her apartment. The home office in the residence she moved into on December 1, 2018 will not be available for use until 2019. RPL has agreed to let Matilda use head office space as needed during December. Home office related costs are as follows: $2,200 3,400 896 Monthly rent Office furniture Computer purchase Stationary and office supplies purchased Monthly phone line charge (7 months) Employment related long distance calls (7 months) Electricity charge (7 months) Paint for apartment Property insurance (7 months) 147 210 110 350 175 15. Matilda received an allowance of $325 per month for 7 months to cover the costs of maintaining a workspace in her home. Required: Determine Matilda's net employment income for 2018. Your homework assignment SSP3-14 is very similar to this assignment. You should do that one first. There are also numerous video demonstrations posted on Brightspace (see Carol's Demos) to help you with some of the calculations. 6 Each line item corresponds to a number in the question from the textbook. 7 If there are multiple adjustments within one item, please show details in area provided below chart 0 Item Marks Explanation Amount Salary Appropriate deductions: Please list them Net Employment Income for Tax Purposes 28 Total 0 35 10. Stock Option Plan: 13. Automobile Benefit: Standby Charge: Operating charge: 14. Home office costs: Matilda Bracken Excel Problem Ms. Matilda Bracken is a Certified Financial Planner (CFP) with many years of successful experience. In 2017, she decided that she was not adequately appreciated in her current position with a large financial institution in Windsor, Ontario. Given this, she resigned on November 1, 2017. After several months of investigation, she decided to take a position with Retirement Planners Ltd. (RPL), a Canadian controlled private corporation located in London, Ontario. She commenced working for RPL on May 1, 2018. She owned a home in Windsor which she had acquired several years ago for $375,000. Because of the depressed real estate market in this area, she was eventually forced to sell the property for $275,000 in October 2018, resulting in a $100,000 loss on this property. Because of the uncertainty surrounding the sale of her Windsor property, she moved into an apartment when she arrived in London on May 1, 2018. The apartment was rented on a monthly basis until November 30, 2018. After she accepts an offer to purchase her Windsor house, she finds a home in London that she purchases on November 1, 2018 for $420,000. She moves into this new home on December 1, 2018. Other Information: 1. Because of her strong professional reputation, RPL paid her a signing bonus of $12,000. The signing bonus was paid on June 1, 2018. 2. During the period May 1, 2018 through December 31, 2018, Matilda earned salary of $124,000. Of these earnings, $120,125 was paid during the period with the remainder paid in the first pay period of 2019. The company withheld the following amounts from her salary: Income taxes $18,650 CPP 2,564 836 RPP Contributions 3,700 Payment for personal use of automobile 880 3. RPL contributed $3,500 on Matilda's behalf to the Company's RPP 4. RPL provides group medical coverage to all of its employees. The private health plan premiums paid by RPL on Matilda's behalf cost $562 for the year. 5. On December 12, 2018, a bonus of $10,600 was accrued for Matilda. Matilda received $5,300 of this bonus on December 29, 2018, with the remainder being paid on January 17, 2019. 6. During the year, Matilda received two non-cash gifts, a birthday gift worth $350 and a Christmas gift worth $300. 7. Because of the need to invest some of her additional income, RPL provided Matilda with financial counseling services. The value of these services as $1,200. 8. In order to assist her move, RPL agreed to compensate her for one-half of the $100,000 loss on the sale of her Windsor home. The $50,000 payment was made on December 1, 2018 9. In order to help Matilda with financing her new London residence, RPL provided her with a $220,000 interest free housing loan. The funds are provided to Matilda on November 1, 2018. Assume that the prescribed rate for all of 2018 is 2 percent. 10. RPL has a stock option plan for its employees. Under this plan, employees are permitted to acquire a limited number of option shares at 10 percent below their fair market value on December 1 of each year. The company hires valuators to determine the fair market value at each of those dates. Matilda acquires 200 shares on December 1, 2018 for cash of $7,200. On December 15, she sells 100 of these shares for $4,100. 11. Matilda paid $1,600 in CFP dues in 2018. RPL's policy is to reimburse 50 percent of such professional dues. RPL reimbursed her $800 in December, 2018. 12. RPL provides its professional employees with a membership in the London Curling Club. They believe this is a useful venue for entertaining clients of the Company. The cost of this annual membership was $1,300. 13. RPL provides Matilda with a vehicle that was purchased in 2018 for $45,200, including HST. The vehicle was used by Matilda for all months during the period May 1, 2018 through December 31, 2018. During this period, she drove the vehicle a total of 52,000 kilometers, of which 40,000 were related to her employment duties. RPL pays all operating and maintenance costs, a total of $8,900 during the period that Matilda used the car. RPL withheld $110 per month from her salary to pay for her personal use of the vehicle. 14. Matilda's new job requires her to meet with clients outside of regular office hours throughout the week. RPL will sign a T2200 stating that she is required to pay for certain employment expenses without reimbursement and use a portion of her home for work. Matilda has set aside a separate room in her apartment to be used exclusively to meet the clients. She used this office space between May 1 and November 30, 2018. This home office occupied 150 square feet of the 1,250 square feet available in her apartment. The home office in the residence she moved into on December 1, 2018 will not be available for use until 2019. RPL has agreed to let Matilda use head office space as needed during December. Home office related costs are as follows: $2,200 3,400 896 Monthly rent Office furniture Computer purchase Stationary and office supplies purchased Monthly phone line charge (7 months) Employment related long distance calls (7 months) Electricity charge (7 months) Paint for apartment Property insurance (7 months) 147 210 110 350 175 15. Matilda received an allowance of $325 per month for 7 months to cover the costs of maintaining a workspace in her home. Required: Determine Matilda's net employment income for 2018. Your homework assignment SSP3-14 is very similar to this assignment. You should do that one first. There are also numerous video demonstrations posted on Brightspace (see Carol's Demos) to help you with some of the calculations. 6 Each line item corresponds to a number in the question from the textbook. 7 If there are multiple adjustments within one item, please show details in area provided below chart 0 Item Marks Explanation Amount Salary Appropriate deductions: Please list them Net Employment Income for Tax Purposes 28 Total 0 35 10. Stock Option Plan: 13. Automobile Benefit: Standby Charge: Operating charge: 14. Home office costs