Use the Free Cash Flow method of valuation and the following data, to calculate the value for a venture with the following information.

Expected sales at year zero (or beginning of year 1): $12.00 M; growth rate in sales for the first 8 years: 45%; and for years 9-on: 15%; Annual profit margin (or EBIAT/Sales) for all years=25%; Annual asset intensity ratio (or (FA+WC)/Sales) for all years = 32%; discount rate in years 1-8: 35%, and in years 9-on: 20%. Use Excel.