National MotorsRock Creek plant is considering the following projects to improve its production process. Corporate headquarters requires a minimum 15% rate of return. Thus, all projects that come to the plants capital screening committee meet that rate. The Rock Creek plant can afford to do several projects, but not all. Rank the seven projects from best to worst.

Please show answer in excel if possible.

First Cost Annual Benefit Life (years) PW at 15% Project 1 2 3 4 5 6 7 $200,000 $50,000 300,000 70,000 100,000 40,000 50,000 12,500 250,000 75,000 150,000 32,000 400,000 125,000 15 10 5 10 5 20 5 $92,369 51,314 34,086 12,735 1412 50,299 19,019