Please show how to solve in Excel

EU to submit this Microsoft Word file. Task 1: Stock Valuation (Use the template on sheet Task 1-Stock Valuation to answer the Questions 1 to 6.) Question 1: 1. Ameri-Trade Corporation just paid a dividend of $4.50 per share. The company plans to increase its dividend by 3.15 percent per year indefinitely. If you require a return of 11 percent on your investment, how much will you pay for the company's stock today? (3 point) DE F A B 1 Task 1: Stock Valuation 2 Question 1 4 Input area: $ Dividend paid Dividend growth rate Required return 4.50 3.15% 11% Output area: Question 1 Stock price 13 15