hello please answer the following questions using excel for fill in the blanks if possible.

Question 1 (2 points) Company X is just about to do a 7 for 2 stock split. The firm's shares are currently trading at $142.51. What will be the stock price immediately after the split? (Report your answer to the nearest cent without any $ signs, e. 12.34.) Your Answer: Answer Question 2 ( 2 points) Which of the following statements is not true? Dividends from preferred shares in Canada are taxed in the same way as dividends from common shares. Preferred shares offer less opportunity for capital gains compared to common shares. Dividends on preferred shares must be paid before any dividends are paid on common shares. Preferred shareholders have greater voting rights compared to common shareholders. Question 3 ( 2 points) Suppose that a preferred share is pays a dividend of $0.95 (per share) on a quarterly basis. The next dividend is to be paid 3 months from today. If the required rate of return on this share is 3.90% (effective annual rate). what is the price today of this preferred share? (Enter your answer to the nearest cent without any $ signs, eg. 12.34.) Your Answer: Answer Question 4 (2 points) A company with a higher share price has greater weight in the SSP/TSX Composite Index than a company with a lower share price. True False The following table shows the order book for a particular stock: Suppose that a fimit order to sel 200 shares at $15.58 is followed by a market order to sell 75 shares. After these orders. What is the missing number (????) in the revised table below? (Enter your answer as a whole number without commas or decimals, ef 123.) Your Answer. Answer Question 6(2 points) The following table shows the order book for a particular stock Suppose that a market order to bury 225 shares is followed by a limit order to sell 150 shares at $25.34. After these orders, what is the missing number fmn in the revised table below? (Enter your aniwer as a whole number without commar or decinalk, es 123) Vour