Homework answers / question archive / You received your Master's in Public Administration degree from Nova Southeastern University and became a policy analyst with the City of Boondocks

You received your Master's in Public Administration degree from Nova Southeastern University and became a policy analyst with the City of Boondocks

Business

Share With

---

You received your Master's in Public Administration degree from Nova Southeastern University and became a policy analyst with the City of Boondocks. To enhance the recreational experience of citizens in your city, the city council wants to choose from the following four policy alternatives:

(1) Do Nothing

(2) Repair the Swimming Pool

(3) Build New Pool in a New Site

(4) Build New Pool on an Existing Site

Using the following data (Table1-4) for the four policy alternatives, calculate the NPV and BCR at a 5% discount rate and select the best policy alternative.  Upload the full excel sheet or ms word doc file with all steps and a brief explanation of what alternative is best and why.

Note: Y0-Y5 stands for Year0 to Year5

Alternative - Do Nothing

Table1:

	Y0	Y1	Y2	Y3	Y4	Y5
Costs	0	$ 250,000	$ 250,000	$ 250,000	$ 250,000	$ 250,000
Benefits	0	$ 1,000,000	0	0	0	0
Discount Rate		5%	5%	5%	5%	5%
Discount Factor		.9524	.9070	.8638	.8227	.7835

 

Alternative - Repair the Swimming Pool

Table2:

	Y0	Y1	Y2	Y3	Y4	Y5
Costs	0	$ 1057,000	$ 32,000	$ 32,000	$ 32,000	$ 32,000
Benefits	0	$ 165,000	$ 165,000	$ 165,000	$ 165,000	$ 165,000
Discount Rate		5%	5%	5%	5%	5%
Discount Factor		.9524	.9070	.8638	.8227	.7835

 

Alternative - Build New Pool at a New Site

Table3:

	Y0	Y1	Y2	Y3	Y4	Y5
Costs	0	$ 1,080,000	$ 80,000	$ 80,000	$ 80,000	$ 80,000
Benefits	0	$ 365,000	$ 365,000	$ 365,000	$ 365,000	$ 365,000
Discount Rate		5%	5%	5%	5%	5%
Discount Factor		.9524	.9070	.8638	.8227	.7835

 

Alternative - Build New Pool at an Existing Site

Table4:

	Y0	Y1	Y2	Y3	Y4	Y5
Costs	0	$ 1000,000	$ 55,000	$ 55,000	$ 55,000	$ 55,000
Benefits	0	$ 165,000	$ 165,000	$ 165,000	$ 165,000	$ 165,000
Discount Rate		5%	5%	5%	5%	5%
Discount Factor		.9524	.9070	.8638	.8227	.7835

 

 

You received your Master's in Public Administration degree from Nova Southeastern University and became a policy analyst with the City of Boondocks. To enhance the recreational experience of citizens in your city, the city council wants to choose from the following four policy alternatives:

(1) Do Nothing

(2) Repair the Swimming Pool

(3) Build New Pool in a New Site

(4) Build New Pool on an Existing Site

Using the following data (Table1-4) for the four policy alternatives, calculate the NPV and BCR at a 5% discount rate and select the best policy alternative.  Upload the full excel sheet or ms word doc file with all steps and a brief explanation of what alternative is best and why.

Note: Y0-Y5 stands for Year0 to Year5

Alternative - Do Nothing

Table1:

	Y0	Y1	Y2	Y3	Y4	Y5
Costs	0	$ 250,000	$ 250,000	$ 250,000	$ 250,000	$ 250,000
Benefits	0	$ 1,000,000	0	0	0	0
Discount Rate		5%	5%	5%	5%	5%
Discount Factor		.9524	.9070	.8638	.8227	.7835

 

Alternative - Repair the Swimming Pool

Table2:

	Y0	Y1	Y2	Y3	Y4	Y5
Costs	0	$ 1057,000	$ 32,000	$ 32,000	$ 32,000	$ 32,000
Benefits	0	$ 165,000	$ 165,000	$ 165,000	$ 165,000	$ 165,000
Discount Rate		5%	5%	5%	5%	5%
Discount Factor		.9524	.9070	.8638	.8227	.7835

 

Alternative - Build New Pool at a New Site

Table3:

	Y0	Y1	Y2	Y3	Y4	Y5
Costs	0	$ 1,080,000	$ 80,000	$ 80,000	$ 80,000	$ 80,000
Benefits	0	$ 365,000	$ 365,000	$ 365,000	$ 365,000	$ 365,000
Discount Rate		5%	5%	5%	5%	5%
Discount Factor		.9524	.9070	.8638	.8227	.7835

 

Alternative - Build New Pool at an Existing Site

Table4:

	Y0	Y1	Y2	Y3	Y4	Y5
Costs	0	$ 1000,000	$ 55,000	$ 55,000	$ 55,000	$ 55,000
Benefits	0	$ 165,000	$ 165,000	$ 165,000	$ 165,000	$ 165,000
Discount Rate		5%	5%	5%	5%	5%
Discount Factor		.9524	.9070	.8638	.8227	.7835