The Brisbane City Council is planning to develop a piece of land that it currently owns but is not utilising, which is valued at $$650,000.$ The Council has asked you to assist in comparing the projects. The options they are considering include a green recycling infrastructure project with an $8-$year life and a children's playground with a $5-$year life. You collected the information below:

Green recycling project:

Initial cost $=$ $$950,000$

Ongoing benefit $=$ $$170,000$ per year

Ongoing cost $=$ $$12,000$ per year

Children's playground project:

Initial cost $=$ $$450,000$

Ongoing benefit $=$ $$130,000$ per year

Ongoing cost $=$ $$13,000$ per year

You also determined that there is a perpetuity benefit for the green recycling project of $$2,700$ expected at the end of the project life.

You also determined that the appropriate discount rate is $6\%$ for these projects.

To compare the projects, you want to use the both the EANB and the rollover method. To make your decision you find the following:

for Green Infrastructure project$$

NPV$=$

EVNB$=$

ROLL$-$OVER NPV$=$

for Children's Playground project:

NPV$=$

EVNB$=$

ROLL$-$OVER NPV$=$

Based on the information you collated above, which project you suggest that the Council selects $.$Provide an explanation of your results in your spreadsheet including a comparison of the methods. $($best work with excel$)$