Baseline (last year or year 0) sales: $45.00 million

Sales growth rate for years 1-5: 40%

Sales growth rate for years 6-10: 30%

Sales growth rate for years 11-on: 10%

Profit margin for years 1-10: 20%

Profit margin for years 11-on: 8%

Discount rate or cost of capital: 25% during years 1-10; and 14% for years 11-on.

What is the value of this company using the Fundamental Method of valuation?

For $15 million investment what % of the company should be given up by the entrepreneur?

please show how to solve in excel, thanks.