assuming a marginal tax rate of 26%, find the current intrinsic value of this stock using the FCFF approach. (please solve on excel and show formulas)

next year Item sales EPS growth rate next 5 years 3.50% n/a 8.10% 10.60% 4.50% Price/ earnings (ttm) Price/sales (ttm) Price/book value (mra) Enterprise value/revenue Enterprise value/ebitda 15.09 0.55 2.79 0.68 11.03 Earnings per share Sales per share Book value per share Revenue ebitda 5.05 132.73 27.31 131,540.00 7,888,000.00 Beta 30 year treasury bond yield Market risk premium Cost of Debt Enterprise Value Market Cap Current stock price number of shares expected dividend total cash and cash equivalents ebit roa roe roic Industrys capital structured Industrys capital structure e 0.41 3% 5.29% 3.54% 83,090,000,000.00 72,780,000,000.00 76.95 945,790,000.00 1.76 785,000,000.00 6,233,000,000.00 7.35% 15.03% 11.41% 24.50% 75.50% next year Item sales EPS growth rate next 5 years 3.50% n/a 8.10% 10.60% 4.50% Price/ earnings (ttm) Price/sales (ttm) Price/book value (mra) Enterprise value/revenue Enterprise value/ebitda 15.09 0.55 2.79 0.68 11.03 Earnings per share Sales per share Book value per share Revenue ebitda 5.05 132.73 27.31 131,540.00 7,888,000.00 Beta 30 year treasury bond yield Market risk premium Cost of Debt Enterprise Value Market Cap Current stock price number of shares expected dividend total cash and cash equivalents ebit roa roe roic Industrys capital structured Industrys capital structure e 0.41 3% 5.29% 3.54% 83,090,000,000.00 72,780,000,000.00 76.95 945,790,000.00 1.76 785,000,000.00 6,233,000,000.00 7.35% 15.03% 11.41% 24.50% 75.50%