** Hi there, do help to explain in MICROSOFTWORD/ EXCEL SHEETS for better understanding and easy to read, highly appreciate the explanation and the working"

Question 4 You are required to answer the following questions by showing relevant workings. a. What is the value of a bond that matures in 3 years, has an annual coupon payment of RM110, and a par value of RM1,000 given that the required rate of return is 12%? (2 Marks) b. Sedih Hati Berhad's preferred stock pays a RM0.10 annual dividend. Calculate the value of the stock if the required rate of return is 20%. (3 Marks) c. Pedih Hati Berhad's common stock is currently selling for RM34.00. It is expected to pay a dividend of RM2.00 at the end of the year. Dividends are expected to grow at a constant rate of 5% indefinitely. Compute the required rate of return on Pedih Hati Berhad's common stock. (3 Marks) d. Patah Hati Berhad's common stock is selling for RM22.00 per share. The last dividend was RM1.20, and dividends are expected to grow at a 6% annual rate. Flotation costs on new stock sales are 5% of the selling price. Compute the cost of Patah Hati Berhad's new common stock (3 Marks) e. Kecewa Berhad is planning a RM50,000 expansion. The expansion is to be financed by RM20,000 debt and RM30,000 common stock. The before-tax cost of debt is 9% and the cost of common stock is 14%. If the corporate tax is 40%. Determine the Weighted Average Cost of Capital (WACC) for Kecewa Berhad. (4 Marks)