Four- 5: (Comprehensive Tax Payable) Use Excel or Numbers to complete this problem and submit it in the Assignments folder in the Assignments section of this course. This assignment is due by the end of this module. Ms. Tanja Umstead is 46 years old and lives in Richmond, British Columbia. She is in good health and works in the sales department of a large publicly traded company with gross revenues of $722 million. Tanjas Personal Information: 1. She is divorced from her husband and has custody of her 11 year old daughter, Cynthia. The daughter is sufficiently disabled that she qualifies for the disability tax credit. The daughter has 2023 Net Income For Tax Purposes of $6,425, largely made up of interest on bonds purchased from an inheritance. 2. Tanjas 68 year old mother lives with her and provides care for Cynthia on a full time basis. She is active and healthy. As she receives no compensation for this work, Tanja has no child care costs during 2023. The mothers 2023 Net Income For Tax Purposes is $13,460. 3. Because of a 2023 decrease in Cynthias mobility, Tanja has had to install access ramps in several locations in her home. The cost of these ramps was $14,600. 4. During 2023, Tanja worked nearly 300 hours as a volunteer search and rescue volunteer. She received $200 in compensation for this work. 5. Tanjas 2023 medical expenses are as follows: Various Prescription Drugs Including Medical Marijuana (Tanja And Cynthia) $ 3,465 Various medical Specialist Treatments For Cynthia 10,490 Prescription Sunglasses For Tanja And Cynthia 875 Liposuction For Tanja To Reduce Fat On Her Thighs 2,463 Dentist Fees for Tanjas Mother 3,300 Dentures For Tanjas Mother 1,325 6. During 2023, Tanja contributes $3,500 to Unplanned Parenthood, a registered Canadian charity. Employment Information: 1. Tanjas salary compensation for 2023 is $93,500. In addition, she was awarded a year end bonus of $12,000, all of which is payable in January 2024. 2. Tanjas employer sponsors a defined benefit registered pension plan (RPP). During 2023, Tanja and her employer each contribute $4,150 to the plan. In addition, her employer withheld maximum El contributions of $1,002 and maximum CPP contributions of $3,754. 3. Tanja is taking an intensive course in spoken Chinese at a British Columbia university. The tuition fee for the course is $3,600, all of which is paid for by her employer. The tuition payment is to be included in her employment income as a taxable benefit. The duration of the course is eight months. 4. Tanja is provided with disability insurance by an employer sponsored plan. During 2023, as a consequence of an automobile accident, she was unable to go to work for one month and receives benefits of $6,500. Starting in 2021, Tanja has been contributing $340 per year for the plans coverage. Her employer makes a matching contribution each year. 5. Tanjas employer provides her with an automobile that was purchased several years ago at a cost of $39,500. During 2023, the car is driven 41,000 kilometres, 34,000 of which were for employment-related travel and 7,000 for personal use. Tanja is required to pay her own operating costs, which for 2023 totaled $7,240. Except for the one month that she was off from work, the car was available to Tanja throughout the year. During the one month that she was off, the car was left in her employers garage. as required by her employer's policy. 6. Tanjas employer provides all of its employees with financial counseling services. The cost to the company of the services provided to Tanja was $450. 7. As a result of winning a sales contest, Tanja received a one week trip to Las Vegas. The value of this trip in Canadian dollars was $5,620. 8. In April 2021, Tanja received options to acquire 250 shares of her employers common stock at a price of $25 per share. When the options were granted, the shares were trading at $25 per share. During 2023, Tanja exercises all of these options. On the exercises date, the shares are trading at $32 per share. Tanja is still holding the shares at the end of the year. Required: Calculate, for the 2023 taxation year, Tanjas minimum Taxable Income and federal Tax Payable. Ignore GST and PST considerations