In the most recent year, a Company had net earnings of $150,000. Additionally, the Company had $50,000 of depreciation and $20,000 change in working capital.

The Company's tax rate is 35%. Analysts estimate that this FCF is anticipated to grow by 8% per year for the next 5 years then level off at a terminal growth rate of 3%.

Assuming the companys beta is 0.9, risk free rate is 1.5%, market risk premium (Rm Rf) is 8%, and the Company has 10,000 shares outstanding, what value would you assign the shares?

Assume the Company is entirely funded by equity and has no cash on hand at the time of the analysis. Create a data table showing how the per share value would change if the terminal growth rate change in increments of 0.5% ranging from 1% - 4%

PLEASE SOLVE IN EXCEL AND USE FORMULATEXT!