Question

In: Finance

Arlington, Texas wants to build a new recreation center. The estimated cost of construction cost us...

Arlington, Texas wants to build a new recreation center. The estimated cost of construction cost us $14 million with annual staffing and maintenance costs of $520,000 per year over the twenty-year life of the center. At the end of the life of the center, Arlington expects to sell the land for $5 million, though that figure might be as low as $1 million and as high $ 9 million. City staff estimate first year benefits to be $2.1 million (accruing at the end of the first year). Staff expect annual benefits to grow in real terms at 4 percent, though this could be as low as 1 percent and as high as 6 percent. They assume that the real discount rate for use in Arlington should be 7 percent, thought it might be a percentage point higher or lower

a) What is the present value of net benefits for the recreation project using staff predictions?

b) What is the sensivity of the present value of net benefits to alternative predictions about land price, growth rate of annual benefits and the real discount rate.

Solutions

Expert Solution

A.

Information Provided Units Value
Construction Cost $ mn 14
Staffing & Maintenance Cost $ mn/year 0.52
Life of project years 20
Land Value $mn 5
First Year Benefit $mn 2.1
Growth Rate % 4%
Discount Rate % 7%
Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Construction Cost -14                                -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -  
Staffing & Maintenance Cost                            -   -0.52 -0.52 -0.52 -0.52 -0.52 -0.52 -0.52 -0.52 -0.52 -0.52 -0.52 -0.52 -0.52 -0.52 -0.52 -0.52 -0.52 -0.52 -0.52 -0.52
Benefits                            -   2.1 2.2 2.3 2.4 2.5 2.6 2.7 2.8 2.9 3.0 3.1 3.2 3.4 3.5 3.6 3.8 3.9 4.1 4.3 4.4
Land Value                            -                                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -                  -   5
Cash Flow per Year -14.0 1.6 1.7 1.8 1.8 1.9 2.0 2.1 2.2 2.4 2.5 2.6 2.7 2.8 3.0 3.1 3.3 3.4 3.6 3.7 8.9
Present Value per year -14.0 1.5 1.5 1.4 1.4 1.4 1.4 1.3 1.3 1.3 1.3 1.2 1.2 1.2 1.2 1.1 1.1 1.1 1.1 1.0 2.3
Net Present Value 12.1

The above table can be duplicated in excel worksheet.

1. Construction Cost is outflow in 0th year

2. Staffing & Maintenance cost is outflow each year from operation of recreational center

3. Benefits is inflow from 1st year which is growing at 4%. From 2nd year onwards, use the formula:

Benefit of last year*(1+4%)

4. Land Value is inflow in last year (20th year)

5 Cash flow per year is summation of above four points

6 Present value per year is discount of cash flow per year using the formula:

Cash flow of nth year / (1+discount rate)^nth year

7 Net present value (NPV) is summation of all present value per year

B. By doing above and linking the formula in excel worksheet, you can easily change the inputs and see the sensitivity in different scenario.

1. Changing the land value from $5mn to $1mn and remaining inputs remain unchanged, the NPV will change from $12.1mn to $11.1mn

2. Changing the land value from $5mn to $9mn and remaining inputs remain unchanged, the NPV will change from $12.1mn to $13.2mn

3. Changing the growth rate from 4% to 1% and remaining inputs remain unchanged, the NPV will change from $12.1mn to $5.7mn

4. Changing the growth rate from 4% to 6% and remaining inputs remain unchanged, the NPV will change from $12.1mn to $17.7mn

5. Changing the discount rate from 7% to 6% and remaining inputs remain unchanged, the NPV will change from $12.1mn to $14.9mn

6. Changing the discount rate from 7% to 8% and remaining inputs remain unchanged, the NPV will change from $12.1mn to $9.8mn


Related Solutions

A company wants to build a new factory. They know the cost to build the factory...
A company wants to build a new factory. They know the cost to build the factory and have forecasted the future cash flows from the plant. They want to do an NPV analysis but are not sure what rate to use. They come to you as a consultant to figure out their cost of capital. The information they have given you is: They just paid a dividend of $2.75. Their dividend growth rate is 4.8%. Their current stock price is...
Mutton Motors wants to build a new factory. They know the cost to build the factory...
Mutton Motors wants to build a new factory. They know the cost to build the factory and have forecasted the future cash flows from the plant. They want to do an NPV analysis but are not sure what rate to use. They come to you as a consultant to figure out their cost of capital. The information they have given you is: They just paid a dividend of $2.75. Their dividend growth rate is 4.8%. Their current stock price is...
A recreation center would have the estimated value • $1,000,000 if it has no public swimming...
A recreation center would have the estimated value • $1,000,000 if it has no public swimming pool • $1,800,000 if it has a public swimming pool with 2 lanes • $2,200,000 if it has a public swimming pool with 3 lanes • $2,400,000 if it has a public swimming pool with 4 lanes The pool costs $400,000 with 2 lanes. Each additional lane would cost $300,000. The city Park & Recreation Board is a bureaucracy that overview the center construction....
Pine Village City council proposes to construct new recreation fields. Construction will cost $350,000 and Annual...
Pine Village City council proposes to construct new recreation fields. Construction will cost $350,000 and Annual expenses are $80,000. The city council estimates that the valve of added youth leagues is about $125,000 annually. In year 6 another $90,000 will be needed to refurbish the fields. The city council agrees to transform the ownership of the field to a private company for $150,000 at the end of year 10. a. Draw the cash flow diagram. b. If the MARR for...
Finch Construction Company expects to build three new homes during a specific accounting period. The estimated...
Finch Construction Company expects to build three new homes during a specific accounting period. The estimated direct materials and labor costs are as follows. Expected Costs Home 1 Home 2 Home 3 Direct labor $ 72,000 $ 93,000 $ 190,000 Direct materials 106,000 150,000 186,000 Assume Finch needs to allocate two major overhead costs ($53,250 of employee fringe benefits and $22,100 of indirect materials costs) among the three jobs. Required Choose an appropriate cost driver for each of the overhead...
Gibson Construction Company expects to build three new homes during a specific accounting period. The estimated...
Gibson Construction Company expects to build three new homes during a specific accounting period. The estimated direct materials and labor costs are as follows: Expected Costs Home 1 Home 2 Home 3 Direct labor $ 80,000 $ 94,000 $ 187,000 Direct materials 92,000 139,000 195,000 Assume Gibson needs to allocate two major overhead costs ($54,150 of employee fringe benefits and $12,780 of indirect materials costs) among the three jobs. Required Choose an appropriate cost driver for each of the overhead...
Solomon Construction Company expects to build three new homes during a specific accounting period. The estimated...
Solomon Construction Company expects to build three new homes during a specific accounting period. The estimated direct materials and labor costs are as follows: Expected Costs Home 1 Home 2 Home 3 Direct labor $ 65,000 $ 99,000 $ 189,000 Direct materials 98,000 136,000 188,000 Assume Solomon needs to allocate two major overhead costs ($70,600 of employee fringe benefits and $29,540 of indirect materials costs) among the three jobs. Required Choose an appropriate cost driver for each of the overhead...
Benson Construction Company expects to build three new homes during a specific accounting period. The estimated...
Benson Construction Company expects to build three new homes during a specific accounting period. The estimated direct materials and labor costs are as follows: Expected Costs Home 1 Home 2 Home 3 Direct labor $ 72,000 $ 109,000 $ 179,000 Direct materials 104,000 134,000 197,000 Assume Benson needs to allocate two major overhead costs ($36,000 of employee fringe benefits and $13,050 of indirect materials costs) among the three jobs. Required Choose an appropriate cost driver for each of the overhead...
Pine Village council proposes to construct new recreation fields. Construction will cost $350,000 and annual O&M...
Pine Village council proposes to construct new recreation fields. Construction will cost $350,000 and annual O&M expenses are $80,000. The city council estimates that the value of added youth leagues is about $125,000 annually. In year 6 another $90,000 will be needed to refurnish the fields. the city council agrees to transform the ownership of the fields to a private company for $150,00 at the end of year 10. a. Draw the cash flow diagram. b. If the MARR for...
Beats wants to build a new factory to produce its headphones. It will cost $230 million...
Beats wants to build a new factory to produce its headphones. It will cost $230 million initially to build the factory over the course of 12 months, which will be worthless after 10 years. The factory will be depreciated linearly to $0 over 10 years. Beats already owns the land on which the factory will be built. The land is currently worth $10 million and was purchased for $2 million eight years ago. After completion of the factory at the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT