please answer me as soon as possible and it should be clear and correct because its reslly important for me.

tructions: If there is no tax impact, leave the answer cell blank. (These are the blue Answer" boxes below) If an amount reduces net employment income, enter as a negative, Please use formulas for your answers. Do not calculate these outside of excel, and hardcode them You can copy and paste your answer into the supporting calculations box and put on apostrophe in front, so that I can see the formula, Example (this is NOT a part of the question). Supporting Calculation Answer Mr. Craig Webber is provided with a car that is leased by his employer. The monthly Lease Standby charge payments for 2021 are $600. During 2021, he drives the automobile a total of 30,000km of 1,920 60012*2/3)*8000/166712 which 22,000km are employment related. The automobile is available for the entire year. His Operating cost benefit is the employer paid a total of $9,200 in operating costs. Calculate Mt. Webber's minimum 2021 lesser of 1,920 x 1/2 or taxable benefit for the use of the automobile, 960 8000 x $0.27 Maris Available duvanced mountaineer and outdoor adventure specialist In 2021, a headhunting firm connected her with Whitehorse petons Ltd. (WEL) a public Canadian company. Wel was looked for another person to join their expanding company 1 5 Other information relevant to 2021 is as follows: 16 Answet Supporting to 1 Lauren put her house on the market on January 5, 2021, and at the urgin of the listing agent, 798001/2 she accepted an offer resulting in a loss on this property. We agreed to compensate her for one-half of any loss on the sale of her home. The payment was made on May 30, 2021 17 209.000 18 Proceeds on sale of home 317,700 19 Original cost of home 397,500 20 Gain (loss) (29.8001 2 In order to help Lauren with the purchase of her new townhouse, WEL provided her with a $150,000, 0.5% housing loan. The funds are provided to lauren on March 1, 2021. Assume that the prescribed rate for all of 2021 is 1 percent. Use the number months to calculate the low interest loan benefit 4 During 2021, Lauren earned a salary of $105,000 as well as commissions of 58,000. The D 5 Company withheld the following amounts from her salary 6 7 8 Income Taxes 33,600 9 CPP 3,166 0 EI 890 11 Disability insurance premiums 2,000 2 Registered Pension Plan (RPP) Contributions 3,600 3 4 5 WEL contributed 54,100 on Lauren's behalf to the Company's RPP. 6 7 16 WEL provides group medical coverage to all of its employees. The private health plan premiums paid by WEL on Lauren's behalf cost $1,020 for the year. 7. During the year, Lauren received two non-cash gifts from WEL, a season skipass worth 5000 and a Christmas gift certificate to a local spa for $175. Record the gifts separately, toxoble, on the two lines provided 9 1 8 WEL provides life insurance coverage to all of its employees. The premiums paid by WEL on Lauren's behalf cost $500 for the year Tx 1 under the Micro Sangre A 9 Lauren was granted options to buy 60 of the company's shares at $10 per share when she joined the staff of WEL. At that time, the shares had an assessed fait market value of $14 per share. On May 10, 2021, the shares are trading at $13 per share. She acquires 60 shares on that date and is still holding these shares on December 31 4 5 10 Lauren is a part of the Canadian Mountaineers Association, and paid professional dues of 5 $380 for 2021. 2 311 Due to a dog sledding accident Lauren breaks her collar bone and was off work for three months during 2021. She received a total of 56,100 in payments from the disability insurance company D during this period. The premiums are S1000/year and were withheld from Laura's pay 47 18 11 Due to a dog sledding accident Lauren breaks her collar bone and was off work for three months 19 during 2021. She received a total of $6,100 in payments from the disability insurance company 50 during this period. The premiums are $1000/year and were withheld from Laura's Day 51 52 Show the disability benefit and premiums separately (if applicable) 53 ut the auto benefit enter each calculation separately into column Leave crow banknot required 12 WEL provides Lauren with a vehicle that she uses to drive her clients on tours. The vehicle was used by Lauren throughout 2021, aside for the three months she was off work. WEL required her to return the car and keys. WEL pays all operating and maintenance costs, a total of $2,300 during the year Details of the vehicle and bilometers drivers are below. 55 56 Total km drive Personal km driven Cost of car (including GST and PST) 32 100 12.840 44,600 57 58 59 60 61 Standby charge (reduced, if applicable) plus -5 6 7 Total km drive Personal km driven Cost of car (including GST and PST) 32 100 12,840 44.600 0 1 Standby charge (reduced, if applicable) plus Operating cost benefit, which is the lesser of: 1/2 of reduced standby charge Or $0.27/km x personal km Other - Indicate in column G + 13 Lauren has renovated in order to have a separate area in her townhouse to be used exclusively to signing the contracts and meeting with clients. WEL will provide her with a signed form 12200 stating that she is required to pay for certain employment expenses without reimbursement and use a portion of her home for work. She used this work space between February 1 and December 31, 2021 o deduction is not allowed. leove blank Show the deductions as negative. Multiply the total of the end Work space related expenditures are as follows: Mortgage Interest (total for 11 months) Utilities (total for 11 months) Home Insurance (total for 11 months) Property Tax (total for 11 months) Office Furniture 10,109 3,014 3,146 5,064 6.634 + Cover sheet- please read 01 02 03 04 05 Lilation Mode: Automatic Workbook Statistic 1290 Sunny Vodeduction is not allowed event Show the educative Mutter Workspace related expenditures are as follows: Mortgage Interest (total for 11 month) Utilities (total for 11 months) Home Insurance (total for 11 months) Property Tax (total for 11 months) Office Furniture 10.100 3,014 3,146 5064 6,634 Total square footage Total Deduction 25 Total square footage Total Deduction 25 77 78 79 80 81 Required: Determine Lauren's net employment income for 2021 Net employment income Please use the SUM function to show your net employment income 82 33 34 85 B6 tructions: If there is no tax impact, leave the answer cell blank. (These are the blue Answer" boxes below) If an amount reduces net employment income, enter as a negative, Please use formulas for your answers. Do not calculate these outside of excel, and hardcode them You can copy and paste your answer into the supporting calculations box and put on apostrophe in front, so that I can see the formula, Example (this is NOT a part of the question). Supporting Calculation Answer Mr. Craig Webber is provided with a car that is leased by his employer. The monthly Lease Standby charge payments for 2021 are $600. During 2021, he drives the automobile a total of 30,000km of 1,920 60012*2/3)*8000/166712 which 22,000km are employment related. The automobile is available for the entire year. His Operating cost benefit is the employer paid a total of $9,200 in operating costs. Calculate Mt. Webber's minimum 2021 lesser of 1,920 x 1/2 or taxable benefit for the use of the automobile, 960 8000 x $0.27 Maris Available duvanced mountaineer and outdoor adventure specialist In 2021, a headhunting firm connected her with Whitehorse petons Ltd. (WEL) a public Canadian company. Wel was looked for another person to join their expanding company 1 5 Other information relevant to 2021 is as follows: 16 Answet Supporting to 1 Lauren put her house on the market on January 5, 2021, and at the urgin of the listing agent, 798001/2 she accepted an offer resulting in a loss on this property. We agreed to compensate her for one-half of any loss on the sale of her home. The payment was made on May 30, 2021 17 209.000 18 Proceeds on sale of home 317,700 19 Original cost of home 397,500 20 Gain (loss) (29.8001 2 In order to help Lauren with the purchase of her new townhouse, WEL provided her with a $150,000, 0.5% housing loan. The funds are provided to lauren on March 1, 2021. Assume that the prescribed rate for all of 2021 is 1 percent. Use the number months to calculate the low interest loan benefit 4 During 2021, Lauren earned a salary of $105,000 as well as commissions of 58,000. The D 5 Company withheld the following amounts from her salary 6 7 8 Income Taxes 33,600 9 CPP 3,166 0 EI 890 11 Disability insurance premiums 2,000 2 Registered Pension Plan (RPP) Contributions 3,600 3 4 5 WEL contributed 54,100 on Lauren's behalf to the Company's RPP. 6 7 16 WEL provides group medical coverage to all of its employees. The private health plan premiums paid by WEL on Lauren's behalf cost $1,020 for the year. 7. During the year, Lauren received two non-cash gifts from WEL, a season skipass worth 5000 and a Christmas gift certificate to a local spa for $175. Record the gifts separately, toxoble, on the two lines provided 9 1 8 WEL provides life insurance coverage to all of its employees. The premiums paid by WEL on Lauren's behalf cost $500 for the year Tx 1 under the Micro Sangre A 9 Lauren was granted options to buy 60 of the company's shares at $10 per share when she joined the staff of WEL. At that time, the shares had an assessed fait market value of $14 per share. On May 10, 2021, the shares are trading at $13 per share. She acquires 60 shares on that date and is still holding these shares on December 31 4 5 10 Lauren is a part of the Canadian Mountaineers Association, and paid professional dues of 5 $380 for 2021. 2 311 Due to a dog sledding accident Lauren breaks her collar bone and was off work for three months during 2021. She received a total of 56,100 in payments from the disability insurance company D during this period. The premiums are S1000/year and were withheld from Laura's pay 47 18 11 Due to a dog sledding accident Lauren breaks her collar bone and was off work for three months 19 during 2021. She received a total of $6,100 in payments from the disability insurance company 50 during this period. The premiums are $1000/year and were withheld from Laura's Day 51 52 Show the disability benefit and premiums separately (if applicable) 53 ut the auto benefit enter each calculation separately into column Leave crow banknot required 12 WEL provides Lauren with a vehicle that she uses to drive her clients on tours. The vehicle was used by Lauren throughout 2021, aside for the three months she was off work. WEL required her to return the car and keys. WEL pays all operating and maintenance costs, a total of $2,300 during the year Details of the vehicle and bilometers drivers are below. 55 56 Total km drive Personal km driven Cost of car (including GST and PST) 32 100 12.840 44,600 57 58 59 60 61 Standby charge (reduced, if applicable) plus -5 6 7 Total km drive Personal km driven Cost of car (including GST and PST) 32 100 12,840 44.600 0 1 Standby charge (reduced, if applicable) plus Operating cost benefit, which is the lesser of: 1/2 of reduced standby charge Or $0.27/km x personal km Other - Indicate in column G + 13 Lauren has renovated in order to have a separate area in her townhouse to be used exclusively to signing the contracts and meeting with clients. WEL will provide her with a signed form 12200 stating that she is required to pay for certain employment expenses without reimbursement and use a portion of her home for work. She used this work space between February 1 and December 31, 2021 o deduction is not allowed. leove blank Show the deductions as negative. Multiply the total of the end Work space related expenditures are as follows: Mortgage Interest (total for 11 months) Utilities (total for 11 months) Home Insurance (total for 11 months) Property Tax (total for 11 months) Office Furniture 10,109 3,014 3,146 5,064 6.634 + Cover sheet- please read 01 02 03 04 05 Lilation Mode: Automatic Workbook Statistic 1290 Sunny Vodeduction is not allowed event Show the educative Mutter Workspace related expenditures are as follows: Mortgage Interest (total for 11 month) Utilities (total for 11 months) Home Insurance (total for 11 months) Property Tax (total for 11 months) Office Furniture 10.100 3,014 3,146 5064 6,634 Total square footage Total Deduction 25 Total square footage Total Deduction 25 77 78 79 80 81 Required: Determine Lauren's net employment income for 2021 Net employment income Please use the SUM function to show your net employment income 82 33 34 85 B6