Colsen Communications is trying to estimate the first-year cash flow (at Year 1) for a proposed project. The financial staff has collected the following information on the project:

Sales revenues $20 million

Operating costs (excluding depreciation) 14 million

Depreciation 4 million Interest expense 4 million

The company has a 40% tax rate,

and its WACC is 10%.

Write out your answers completely. For example, 13 million should be entered as 13,000,000.

What is the project's cash flow for the first year (t = 1)? Round your answer to the nearest dollar.

If this project would cannibalize other projects by $2 million of cash flow before taxes per year, how would this change your answer to part a? Round your answer to the nearest dollar. The firm's project's cash flow would now be $

Ignore part b. If the tax rate dropped to 35%, how would that change your answer to part a? Round your answer to the nearest dollar. The firm's project's cash flow would increase by $

(please show steps, we are allowed excel, so doing it in excel would be helpful so I can see how to do it)