Question 1. Using Excel, create a Cost-Benefit Analysis (CBA) spreadsheet. Provide the spreadsheet output (as appendix) showing your CBA process and result.

Question 2. What is the total nominal future cost of this project?

Question 3. What is the total nominal future benefit of this project?

Question 4. What is the net nominal future value of this project?

Question 5. What is the net real future value of this project?

Question 6. What is the net real present value (more simply net present value (NPV)) of this project?

Question 7. Based on the CBA result, net real present value, would you like to recommend that the City construct additional elementary schools? In other words, is it good project for residents in the City of South Bend in terms of economic efficiency? Why or why not?

Question 8. Based on your political value and belief, would you like to recommend that the City construct additional elementary schools? In other words, is it good project for residents in the City of South Bend in terms of non-economic social value (e.g. humanity, equality, and justice)? Why or why not?

Norminal Net Future Value inflation rate Net Future Value interest rate Net Present Cost 1 Cost 3 Cost 5 Benefit 1 Benefit 2Cost cost of three during cost of three more market value income in cost ! Year Periodelementary construction elementary Hiring more equipment of houses the City 2+3 Benefit 1Total benefit - Total cost congestion 4 Cost 5 Benefit 2 0.543933743 -4.168799216