Conduct a cost benefit analysis in excel for the public project to build a public library in Bondo town:

Conduct a cost benefit analysis of this project $.$Assume a discount rate of $5\%.$

Costs:

Construction Costs:

Year $0$: $$1000000$

for the initial construction of the library building.

Operational Costs:

Years $1-10$:$ $50000$

per year for staffing, utilities, and maintenance.

Renovation Costs:

Year $10$: $200,000$

for a major renovation to update the library facilities.

Expansion Costs:

Year $15$: $500,000$

for a

expansion of the library to accommodate growing community needs.

Maintenance Costs:

Years $1-20$: $20,000$

per year for ongoing maintenance and minor repairs.

Explanation

The costs associated with building a library in a small town include construction, operational, renovation, expansion, and maintenance costs, totaling $1,000,000$

initially and additional expenses over $20$ years. These expenses cover building construction, staffing, utilities, major renovations, expansion to meet community needs, and ongoing maintenance.