Three alternative plans are to be analyzed for the construction of a four lane highway section. With Plan A, the four lanes would be built in a single stage in Years 1 and 2 at a cost of 58 million dollars. With Plan B, two lanes would be built at Years 1 and 2 at a cost of forty-five million dollars, and two lanes would be built at Year 6 at a cost of sixteen million dollars. With Plan C, the initial stage would be the same as with Plan B, but the second stage would not occur until Year 12. The annual maintenance costs would be three million dollars for four lanes and two and a half million dollars for two lanes. The annual road-user costs would be one million dollars per year per lane in Year 3 and would increase by $300,000 per year. Compare the alternatives in terms of present values of total costs for an analysis period of twenty years and a discount rate of 7 percent.

Please answer using excel with formulas shown. Thanks!

* Plan A and B are total costs.