Using Excel (if applicable),

A company is evaluating a project that would require a $5 million investment today (t = 0). The after-tax cash flows would depend on whether a new property tax is imposed. There is a 75% chance that the tax will pass and 25% chance that it won't. If the tax passes, the project will produce after-tax cash flows of $1,200,000 at the end of each of the next 5 years. If the tax doesn't pass, the after-tax cash flows will be $2,000,000 for 5 years. The project has a WACC of 12%. The firm would have the option to abandon the project 1 year from now, and if it is abandoned, the firm would receive the expected $1,200,000 cash flow at t = 1 and would also sell the property for $4 million at t = 1. If the project is abandoned, the company would receive no further cash inflows from it. What is the value of this abandonment option? Should the company take the project? Do not round intermediate calculations.