You are given the following information for a business:

$-$ Tax rate is $15$ percent.

$-$ Sales in the most recent year $=$ $$800$M$,$ and EBIT $=$ $$300$M$.$

$-$ Capital expenditures $=$ $$120$M and depreciation expense $=$ $$90$M$.$

$-$ The required level of working capital is $8\%$ of sales.

$-$ Growth of $10\%$ per year expected over the next $4$ years, after which the growth rate will drop to $3\%$ per year forever.

$-$ Debt: $2,000,0006\mathrm{.}1$ percent coupon bonds outstanding, $$1,000$ par value, $15$ years to maturity, selling for $90$ percent of par; the bonds make semiannual payments.

$-$ Common stock of $100$ MM shares outstanding trading at $$15.$

$-$ The risk free rate is $3\mathrm{.}5\%$ and the expected market return is $10\mathrm{.}5\%.$ The Beta of the stock is $1\mathrm{.}3.$

What is the intrinsic value of the stock. Please complete in Excel and show formulas.