please show excel solutions

Miller and Company is a construction company with a recoid of completing nine projects witheut ary irregularities or complaints. These nine projects total \$1.2 bitlion. You just joined the organization as a business and market analyst. Miller's straqegy for evaluating a project consibts of the following: 1. Identifing the return for each project. 2. Adjust the cost of the project bosed on the project's risls if necestary. in Miner's blueprint, it maintains a WACC of 11.5% for averoge tibk projecti. Howevec, for riskier projects, that is, projects with a risk above averege, Miller tags an additional 2.0 on to its blueprint WACC Simdarly, for a less rikky project, that is, poojects with rikk lews than average, Miller subtracts 1.0 s from its blueprint WacC. Miller is considerine the followine projects and has aved that you make the recommendations. Assuming Miller is willing to accept all favorable projects, which projects should Miller choose (defend your recommendation), and what would be the anticipated cost of the projects? Assuming Miller is only willing to spend $120 million on projects, which projects should Miller pursue (defend your position)? In order, rank the projects from the highest to the least returns (delend vour ranking rationale)