The following information is given:

Baseline $($last year$)$ sales: $$200$ million

Sales growth rates $($net$)$: Base year $=45\%$ with a fade rate of $4\%$ a year for years $1-10$: $($increasing sales due to sustained competitive advantage and a differentiated product$)[$source: Strategic Plan$].$ Fade rate is the rate of decline per year $($each year$)$ from a base year. It is cumulative

Sales growth rate after year $10$ and forward: $5\%($in year $11,$ the competition has caught up and the market has reached maturity$)[$source: Strategic Plan$].$ with no fade rate.

Profit margin: Base year $=20\%,$ with a fade rate of $1\%$ a year for years $1-10$: $($during the period of competitive advantage, the firm can charge higher prices, but its profit margin slowly declines as competition increases$)[$source: Strategic Plan$]$

Profit margin in year $10$ and going forward: $10\%[$source: Strategic Plan$]$ with no fade rate.

Fixed capital investment rate: $20\%($for every dollar of new sales, we need an additional investment in fixed plant and equipment of $$0\mathrm{.}20)[$source: historical relationship$]$

Working capital investment rate: $10\%($for every dollar of new sales we need an additional investment in inventories and receivables of $$0\mathrm{.}10)[$source: historical relationship$]$

Cash tax rate: $21\%[$source: historical relationship$]$

Cost of capital: $12\%[$source: current yield on firm's debt and the cost of equity estimated using the Capital Asset Pricing Model, weighted average based on the target capital structure$]$

Marketable securities: $$15$ million

Market value of firm's debt: $$50$ million

The firm has $10$ million shares of common stock outstanding selling at:

Scenario $1=$ $$40/$share and

Scenario $2=$ $$60/$share$.$

Need help witht the organge excel calculations