DO IT USING EXCEL, AND POST THE EXCEL SCREENSHOT AND FORMULA IN EXCEL SCREENSHOT. THANK YOU

Question 20 5 pts Bandor Furniture pays a constant annual dividend. Last year, the dividend yield was 4.9 percent when the stock was selling for $43.50 per share. What is the current price of the stock if the current dividend yield is 4 percent? $53.29 $38.62 $42.07 $35.51 $41.54