Using the free cash flow valuation model to price an IPOPersonal Finance ProblemAssume that you have an opportunity to buy the stock of CoolTech, Inc., an IPO being offered for $9.01per share. Although you are very much interested in owning the company, you are concerned about whether it is fairly priced. To determine the value of the shares, you have decided to apply the free cash flow valuation model to the firm's financial data that you've accumulated from a variety of data sources. The key values you have compiled are summarized in the following table,

a. Use the free cash flow valuation model to estimate CoolTech's common stock value per share.

b.Judging by your finding in part a and the stock's offering price, should you buy the stock?

c. On further analysis, you find that the growth rate in FCF beyond 2023 will be 4% rather than 3%. What effect would this finding have on your responses in parts a and b?

If there is a way to figure out the math through EXCEL that would be great.

i X Data Table in order to copy the contents of the data table below into a (Click on the icon here spreadsheet.) Other data Free cash flow Year (t) FCF 2020 $650,000 2021 $730,000 2022 $850,000 2023 $950,000 Growth rate of FCF, beyond 2023 to infinity = 3% Weighted average cost of capital = 9% Market value of all debt = $2,820,000 Market value of preferred stock = $1,130,000 Number of shares of common stock to be issued = 1,100,000 Print Done