can someone show how to do this in excel and please post formuals!

thanks!

0 / 10 pts Question 15 Panda Industries Inc. has $2,942,811 in preferred equity and its outstanding debt has a value of $3,488,054. The firm's WACC is 10.04%. Use the DCF valuation model with the expected FCFs shown below; year 1 represents one year from today and so on. The company expects to grow at a 3.6% rate after Year 5. Rounding to the nearest penny, what is the value of common equity? Period Free Cash Flow Year 1 $1,167,687 Year 2 $1,360,353 Year 3 $1,839,925 Year 4 $2,706,969 Year 5 $3,527,853 red wer 36,342,115.99 margin of error +/-0.1%