Residents of Autopia Township are lobbying the City Council for a swimming pool. Based on an analysis of swimming pool usage in similar municipalities, you develop the following assumptions:

$$ Similar pool complexes charge admission of $$5$ per person on average

$$ At this price, you estimate that, the pool will have average usage of $50$ people per day during its operating period of around $5$ months.

$$ It will operate only when weather permits, assumed to be $150$ days out of the year

$$ Maintenance and operating costs are assumed to be $$5000$ per month, during the five months of each year that the pool will be open to the public.

$$ The City Council assumes a $6$ percent discount rate for all capital investment analyses

$($A$)$ Set up a model in Excel to calculate the NPV of operations of the pool, assuming an operating life of $25$ years. Calculate the NPV of pool operations $($ignoring land acquisition and construction costs$).$

$($B$)$ In a few sentences, Interpret the findings for the City Council, explaining in lay terms why one must discount revenue received and operating costs paid in the future. From a fiscal standpoint, what should the City consider in deciding how much to invest in the pool?