Please calculate the following information based off the information given. Please use excel.

Inputs $ Base Sales 15,000,000 Sales Growth Rate Years 2-5 12% OCF Growth Rate Year-6 forward 4% COGS% of Sales 60% $2,000,000 Fixed Operating Costs Year 1 Fixed Operating Costs increase years 2-5 Initial Capital Investment Increase in Capital Investment 4% $50,000,000 3% 5% Depeciation % Gross Assets 8% NWC as % of Sales 21% Tax Rate WACC EA Year Sales COGS Fixed costs EBITDA Depreciation expense BT |xes Net Income Depreciation expense Operating Cash flows Investment in NWC Annual capital investment Free Cash Flow years 1-5 PV Free Cash Flow years 6 and beyond Gross Fixed Assets Annual investment in Gross Fixed Assets Depreciation expense Net Working Capital Increase in NWC Inputs $ Base Sales 15,000,000 Sales Growth Rate Years 2-5 12% OCF Growth Rate Year-6 forward 4% COGS% of Sales 60% $2,000,000 Fixed Operating Costs Year 1 Fixed Operating Costs increase years 2-5 Initial Capital Investment Increase in Capital Investment 4% $50,000,000 3% 5% Depeciation % Gross Assets 8% NWC as % of Sales 21% Tax Rate WACC EA Year Sales COGS Fixed costs EBITDA Depreciation expense BT |xes Net Income Depreciation expense Operating Cash flows Investment in NWC Annual capital investment Free Cash Flow years 1-5 PV Free Cash Flow years 6 and beyond Gross Fixed Assets Annual investment in Gross Fixed Assets Depreciation expense Net Working Capital Increase in NWC