The current price of DUMBA's common stock is $30 per share.You plan onbuying it today, holding it for 4 years, and then selling it.You anticipatereceiving a dividend per share of $1.00 one year from today, $2.00 two yearsfrom today, $2.50 three years from today, and $2.50 four years from today.If you want to earn 20% on your investment, what price must you receive when you sell the stock four years from today?

Please show/explain using excel