The firms weighted average cost of capital is 19%, and it has $1,500,000 of debt at market value and $750,000 of preferred stock at its assumed market value. The estimated free cash flows over the next 5 year, 2013 through 2017, are given below. Beyond 2017 to infinity, the firm expects its free cash flow to grow by 2% annually.

Year(t)	Free cash flow(FCF)
2013	$150,000
2014	225,000
2015	610,000
2016	650,000
2017	690,000

a.Estimate the value of Brees Industries entire company by using the free cash flow valuation model.

b.Use your finding in part a, along with the data provided above, to find Brees Industries common stock value.

c. If the firm plans to issue 200,000 shares of common stock, what is its estimated value per share?

please show all work in excel****