Transcribed Image Text
P7–17 Using the free cash flow valuation model to price an IPOAssume that you have anopportunity to buy the stock of CoolTech, Inc., an IPO beingoffered for $12.50 pershare. Although you are very much interested in owning thecompany, you are concernedabout whether it is fairly priced. To determine the value of theshares, youhave decided to apply the free cash flow valuation model to thefirm’s financial datathat you’ve developed from a variety of data sources. The keyvalues you have compiledare summarized in the following table.Free cash flowYear (t) FCFt Other data2016 $ 700,000 Growth rate of FCF, beyond 2019 to infinity 52%2017 800,000 Weighted average cost of capital 5 8%2018 950,000 Market value of all debt 5 $2,700,0002019 1,100,000 Market value of preferred stock 5 $1,000,000Number of shares of common stock outstanding 5 1,100,000a. Use the free cash flow valuation model to estimate CoolTech’scommon stockvalue per share.b. Judging on the basis of your finding in part a and thestock’s offering price,should you buy the stock?c. On further analysis, you find that the growth rate in FCFbeyond 2019 will be3% rather than 2%. What effect would this finding have on yourresponses inparts a and b?Solve using Excel