Question: can you do it with an Excel please ? Mr. Bond's net employment income for the year would be calculated as follows: Gross Salary Additions:

Mr. Bond's net employment income for the year would be calculated as follows: Gross Salary Additions: Bonus (Note One) Automobile Benefit (Note Two) Counseling Benefit (Note Three) Imputed Interest Benefit (Note Four) Stock Option Benefit (Note Five) Deductions: Registered Pension Plan Contributions Professional Dues Employment Income for 2022 Note One Note Two Standby Charge Operating Cost Benefit Payments Withheld Taxable Benefit Note Three Note Four The imputed interest benefit is calculated as follows: Taxable Benefit Reduction For Interest Paid Addition To Employment Income Note Five Note Six Other items and the reasons for their exclusion would be as follows: Mr. Jason Bond has been empioyed tor many years as a graphic ilustrator in Kamioops, British Columbia. His employer is a large publicly traded Canadian company. In 2022, his gross salary was $82,500. In addition, he was awarded a $20,000 bonus to reflect his outstanding performance during the year. As he was in no immediate need of additional income, he arranged with his employer that none of this bonus would be paid until 2027, the year of his expected retirement. Other Information: For the 2022 taxation year, the following items were relevant. 1. Mr. Bond's employer withheld the following amounts from his income: 2. During the year, Mr. Bond was provided with an automobile owned by his employer. Ihe cost of the automobile was $47,500. Mr. Bond drove the car a total of 10,000 kilometres during the year, of which only 4,000 kilometres were driven for employment purposes and 6,000 for personal use. The automobile was used by Mr. Bond for 10 months of the year. During the other two months, he was out of the country, and company policy required the return of the automobile to the company. 3. During the year, the corporation paid Mega Financial Planners a total of $1,500 for providing counseling services to Mr. Bond with respect to his personal financial situation. 4. In order to assist Mr. Bond in purchasing a ski chalet, the employer provided him with a five-year loan of $150,000. The loan was granted on October 1 at an interest rate of 1%. Mr. Bond paid a total of $275 in interest for 2022 on January 20, 2023. Assume that, at the time the loan was granted and throughout the remainder of the year, the relevant prescribed rate was 2%. 5. Mr. Bond was required to pay professional dues of $1,800 during the year. 6. On June 6, 2022, when Mr. Bond exercised his stock options to buy 1,000 shares of his employer's common stock at a price of $15 per share, the shares were trading at $18 per share. When the options were granted in April 2021, the shares were trading at $12 per share. In December of 2022 the shares were sold for $20 per share. Required: Calculate Mr. Bond's minimum 2022 employment income. Provide reasons for omitting items that you have not included in employment income. Ignore GST and PST considerations
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
