please solve and show using excel! thank you!

Question 25 Panda Industries Inc. has a WACC of 7.46% and 78,032 common shares outstanding. The firm has $2,786,794 in preferred equity and outstanding debt of $1,701,855. Use the DCF valuation model based on the expected FCFs shown below; year 1 represents one year from today and so on. The company expects to grow at a 3.1% rate after Year 5. Rounding to the nearest penny, what is the value of each share of common stock? Free Cash Flow Year 1 $1.295,067 Year 2 $1,706.626 Year 3 $1,408,555 Year 4 $2.138.435 Year 5 $3.316.232 5 pts Period