Question: Please answer using excel and show formulas used CUUIU DE JUIL fact affect your answer? ate the first-year cash aff has collected the followin he

Please answer using excel and show formulas used
CUUIU DE JUIL fact affect your answer? ate the first-year cash aff has collected the followin he following infor 12-2 PROJECT CASH FLOW Colsen Communications is trying to est flow (at Year 1) for a proposed project. The financial staff has col mation on the project: Sales revenues Operating costs (excluding depreciation) Depreciation Interest expense $15 million 10.5 million 3 million 3 million The company has a 40% tax rate, and its WACC is 11%. a. What is the project's cash flow for the first year (t = 1)? b. If this project would cannibalize other projects by $1.5 million of cash flow bet per year, how would this change your answer to part a? C. Ignore part b. If the tax rate dropped to 30%, how would that change your answer part a
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
