EXCEL SOLUTION NEEDED!!!

please help me with all 4 questions:)))

Unanswered Answered A stock just paid a dividend of $1.57. The dividend is expected to grow at 27.83% for two years and then grow at 3.98% thereafter. The required return on the stock is 14.58% What is the value of the stock? wered not submitted Submit Attempts Rernaining: Infinity Answer format: Currency: Round to: 2 decimal places. wered The risk-free rate is 2.49% and the market risk premium is 7.28%. A stock with a B of 1.01 will have an expected return of Submit Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, % sign required. WW accept decimal format rounded to decimal places (ex: 0.0924) not submitted Attempts Remaining: Infinity 13 The risk-free rate is 2.94% and the expected return on the market 11.53%. A stock with a B of 1.24 will have an expected return of_%. Submit Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, sign mouired. Wm accept decimal format rounded to 4 decimal places (ex: 0.0924) not submitted Attempts Remaining Infinity 4 Unawet A stock has an expected return of 14.00%. The risk-free rate is 2.05% and the market risk prerniurn is 6.64%. What is the B of the stock? Submit Answer format: Number: Round to: 2 decimal places not submitted Attempts Remaining: Infinity