answer this in excel format:

$FCF=$ EBIT $(1-T)+$ Depreciation $-$ Capital Expenditures $-$ Increase $inNWC$

Macrosoft's EBIT last year was $$100$M$.$ EBIT is expected to grow $10\%$ per year for the next $4$ years $($years $1$ through $4).$

Depreciation expense last year was $$10M.$ That is expected to increase $2\%$ each of the next $4$ years.

Capital expenditures are expected to be $$5M$ each of the next $4$ years.

Current assets last year were $$50M.$ Current liabilities were $$40M.$ Both current assets and current liabilities are expected to increase $10\%$ per year for the next $4$ years.

After year $4,$ free cash flow is expected to increase at $3\%$ per year in perpetuity.

The balance sheet shows $$500M$ in LTD$.$ The current market value of this debt is $$520M.$

The company has $50M$ common shares outstanding.

The company is in the $21\%$ tax bracket. The appropriate discount rate is $10\%.$

Selected Balance Sheet accounts $($in $$1,000\text{'}$s$)$

Assumptions

Selected Income Statement accounts $($in $$1,000\text{'}$s$)$