The Nationals Company pays its dividends once per year. The Nationals Companys last dividend (paid yesterday) was $1.30. Its dividend growth rate is expected to grow each year at 20% for three (3) years, after which dividends are expected to grow at a rate of six percent (6%) forever. Its required return (WACC) is 11%. a. What is the best estimate of the current stock price? b. What is the capital gains yield in year 3? c. What is the dividend yield in year 3?

Show work in Excel