Question
In: Economics
The city of Waterbourne has made it a strategic goal to enhance livability in the city....
The city of Waterbourne has made it a strategic goal to enhance livability in the city. The city has decided to undertake a project that will occur in two phases. During the first phase, the city will connect several of the parks with walking paths. During the second phase, the city will add water features or splash fountains to several of the parks.
The initial cost of the project will be $340042. Annual utilities for maintaining the walking paths and keeping them lit during the early evening are estimated to be $11380, with costs increasing by $282 each subsequent year. The paths will require repaving in year 9 at a cost of $43703 and again in year 17 at a cost of $66835.
The water features and splash fountains will be added to the parks at the end of year 9 at a cost of $316585. The water utilities are estimated to be $17520 per year, increasing by 14% each subsequent year. (The first payment for the water utilities will occur at the end of year 9.)
The city has secured a sponsorship from a local business to help pay for part of the project. The city will receive a grant from the business of $118993 per year, increasing by 7% each subsequent year. The city will receive the grant for 7 years. (The city will receive the first grant payment at the end of year 1.)
Using a nominal annual interest rate of 7% compounded annually and a lifespan of 30 years, what is the present worth of the entire project?
Solutions
Expert Solution
i=7% =0.07, t= 30yrs
Investment in year 0 = 340042
Investment in year 9 = repaving + water features = 43703+316585 = 360288
Investment in year 17 = repaving = 66835
utilities for path = 11380 increasing by 282 each year from year 1 to year 30
water utilities = 17520 increasing 14% every year from year 9
Sponsorship starting year 1 = 118993 increasing at 7% uptill 7 yrs
Finding net cash flow for each year
Using formula PV = FV / (1+i)^n for finding present value of any future value
using excel
| Years | Interest | Cash Flow (Future Value) | P/F factor | Present worth | ||||
| Investment | utilities for path | Water utilities | Sponsorship | Net cash flow | ||||
| 0 | -340042.00 | -3,40,042.00 | 1 | -3,40,042.00 | ||||
| 1 | 7.00% | -11,380.00 | 1,18,993.00 | 1,07,613.00 | 0.934579439 | 1,00,572.90 | ||
| 2 | 7.00% | -11,662.00 | 1,27,322.51 | 1,15,660.51 | 0.873438728 | 1,01,022.37 | ||
| 3 | 7.00% | -11,944.00 | 1,36,235.09 | 1,24,291.09 | 0.816297877 | 1,01,458.55 | ||
| 4 | 7.00% | -12,226.00 | 1,45,771.54 | 1,33,545.54 | 0.762895212 | 1,01,881.25 | ||
| 5 | 7.00% | -12,508.00 | 1,55,975.55 | 1,43,467.55 | 0.712986179 | 1,02,290.38 | ||
| 6 | 7.00% | -12,790.00 | 1,66,893.84 | 1,54,103.84 | 0.666342224 | 1,02,685.89 | ||
| 7 | 7.00% | -13,072.00 | 1,78,576.41 | 1,65,504.41 | 0.622749742 | 1,03,067.83 | ||
| 8 | 7.00% | -13,354.00 | -13,354.00 | 0.582009105 | -7,772.15 | |||
| 9 | 7.00% | -360288.00 | -13,636.00 | -17,520.00 | -3,91,444.00 | 0.543933743 | -2,12,919.60 | |
| 10 | 7.00% | -13,918.00 | -19,972.80 | -33,890.80 | 0.508349292 | -17,228.36 | ||
| 11 | 7.00% | -14,200.00 | -22,768.99 | -36,968.99 | 0.475092796 | -17,563.70 | ||
| 12 | 7.00% | -14,482.00 | -25,956.65 | -40,438.65 | 0.444011959 | -17,955.24 | ||
| 13 | 7.00% | -14,764.00 | -29,590.58 | -44,354.58 | 0.414964448 | -18,405.57 | ||
| 14 | 7.00% | -15,046.00 | -33,733.26 | -48,779.26 | 0.387817241 | -18,917.44 | ||
| 15 | 7.00% | -15,328.00 | -38,455.92 | -53,783.92 | 0.36244602 | -19,493.77 | ||
| 16 | 7.00% | -15,610.00 | -43,839.75 | -59,449.75 | 0.338734598 | -20,137.69 | ||
| 17 | 7.00% | -66835.00 | -15,892.00 | -49,977.31 | -1,32,704.31 | 0.31657439 | -42,010.79 | |
| 18 | 7.00% | -16,174.00 | -56,974.14 | -73,148.14 | 0.295863916 | -21,641.89 | ||
| 19 | 7.00% | -16,456.00 | -64,950.52 | -81,406.52 | 0.276508333 | -22,509.58 | ||
| 20 | 7.00% | -16,738.00 | -74,043.59 | -90,781.59 | 0.258419003 | -23,459.69 | ||
| 21 | 7.00% | -17,020.00 | -84,409.69 | -1,01,429.69 | 0.241513087 | -24,496.60 | ||
| 22 | 7.00% | -17,302.00 | -96,227.05 | -1,13,529.05 | 0.225713165 | -25,625.00 | ||
| 23 | 7.00% | -17,584.00 | -1,09,698.84 | -1,27,282.84 | 0.210946883 | -26,849.92 | ||
| 24 | 7.00% | -17,866.00 | -1,25,056.67 | -1,42,922.67 | 0.19714662 | -28,176.72 | ||
| 25 | 7.00% | -18,148.00 | -1,42,564.61 | -1,60,712.61 | 0.184249178 | -29,611.17 | ||
| 26 | 7.00% | -18,430.00 | -1,62,523.65 | -1,80,953.65 | 0.172195493 | -31,159.40 | ||
| 27 | 7.00% | -18,712.00 | -1,85,276.96 | -2,03,988.96 | 0.160930367 | -32,828.02 | ||
| 28 | 7.00% | -18,994.00 | -2,11,215.74 | -2,30,209.74 | 0.150402212 | -34,624.05 | ||
| 29 | 7.00% | -19,276.00 | -2,40,785.94 | -2,60,061.94 | 0.140562815 | -36,555.04 | ||
| 30 | 7.00% | -19,558.00 | -2,74,495.97 | -2,94,053.97 | 0.131367117 | -38,629.02 | ||
| -3,95,633.25 | ||||||||
total present worth of project is -395633.25
showing formula in excel
| Years | Interest | Cash Flow (Future Value) | P/F factor | Present worth | ||||
| Investment | utilities for path | Water utilities | Sponsorship | Net cash flow | ||||
| 0 | -340042 | =C3+D3+E3+F3 | =(1+B3)^-A3 | =H3*G3 | ||||
| 1 | 0.07 | -11380 | 118993 | =C4+D4+E4+F4 | =(1+B4)^-A4 | =H4*G4 | ||
| 2 | 0.07 | =D4-282 | =F4*1.07 | =C5+D5+E5+F5 | =(1+B5)^-A5 | =H5*G5 | ||
| 3 | 0.07 | =D5-282 | =F5*1.07 | =C6+D6+E6+F6 | =(1+B6)^-A6 | =H6*G6 | ||
| 4 | 0.07 | =D6-282 | =F6*1.07 | =C7+D7+E7+F7 | =(1+B7)^-A7 | =H7*G7 | ||
| 5 | 0.07 | =D7-282 | =F7*1.07 | =C8+D8+E8+F8 | =(1+B8)^-A8 | =H8*G8 | ||
| 6 | 0.07 | =D8-282 | =F8*1.07 | =C9+D9+E9+F9 | =(1+B9)^-A9 | =H9*G9 | ||
| 7 | 0.07 | =D9-282 | =F9*1.07 | =C10+D10+E10+F10 | =(1+B10)^-A10 | =H10*G10 | ||
| 8 | 0.07 | =D10-282 | =C11+D11+E11+F11 | =(1+B11)^-A11 | =H11*G11 | |||
| 9 | 0.07 | =-43703-316585 | =D11-282 | -17520 | =C12+D12+E12+F12 | =(1+B12)^-A12 | =H12*G12 | |
| 10 | 0.07 | =D12-282 | =E12*(1+0.14) | =C13+D13+E13+F13 | =(1+B13)^-A13 | =H13*G13 | ||
| 11 | 0.07 | =D13-282 | =E13*(1+0.14) | =C14+D14+E14+F14 | =(1+B14)^-A14 | =H14*G14 | ||
| 12 | 0.07 | =D14-282 | =E14*(1+0.14) | =C15+D15+E15+F15 | =(1+B15)^-A15 | =H15*G15 | ||
| 13 | 0.07 | =D15-282 | =E15*(1+0.14) | =C16+D16+E16+F16 | =(1+B16)^-A16 | =H16*G16 | ||
| 14 | 0.07 | =D16-282 | =E16*(1+0.14) | =C17+D17+E17+F17 | =(1+B17)^-A17 | =H17*G17 | ||
| 15 | 0.07 | =D17-282 | =E17*(1+0.14) | =C18+D18+E18+F18 | =(1+B18)^-A18 | =H18*G18 | ||
| 16 | 0.07 | =D18-282 | =E18*(1+0.14) | =C19+D19+E19+F19 | =(1+B19)^-A19 | =H19*G19 | ||
| 17 | 0.07 | -66835 | =D19-282 | =E19*(1+0.14) | =C20+D20+E20+F20 | =(1+B20)^-A20 | =H20*G20 | |
| 18 | 0.07 | =D20-282 | =E20*(1+0.14) | =C21+D21+E21+F21 | =(1+B21)^-A21 | =H21*G21 | ||
| 19 | 0.07 | =D21-282 | =E21*(1+0.14) | =C22+D22+E22+F22 | =(1+B22)^-A22 | =H22*G22 | ||
| 20 | 0.07 | =D22-282 | =E22*(1+0.14) | =C23+D23+E23+F23 | =(1+B23)^-A23 | =H23*G23 | ||
| 21 | 0.07 | =D23-282 | =E23*(1+0.14) | =C24+D24+E24+F24 | =(1+B24)^-A24 | =H24*G24 | ||
| 22 | 0.07 | =D24-282 | =E24*(1+0.14) | =C25+D25+E25+F25 | =(1+B25)^-A25 | =H25*G25 | ||
| 23 | 0.07 | =D25-282 | =E25*(1+0.14) | =C26+D26+E26+F26 | =(1+B26)^-A26 | =H26*G26 | ||
| 24 | 0.07 | =D26-282 | =E26*(1+0.14) | =C27+D27+E27+F27 | =(1+B27)^-A27 | =H27*G27 | ||
| 25 | 0.07 | =D27-282 | =E27*(1+0.14) | =C28+D28+E28+F28 | =(1+B28)^-A28 | =H28*G28 | ||
| 26 | 0.07 | =D28-282 | =E28*(1+0.14) | =C29+D29+E29+F29 | =(1+B29)^-A29 | =H29*G29 | ||
| 27 | 0.07 | =D29-282 | =E29*(1+0.14) | =C30+D30+E30+F30 | =(1+B30)^-A30 | =H30*G30 | ||
| 28 | 0.07 | =D30-282 | =E30*(1+0.14) | =C31+D31+E31+F31 | =(1+B31)^-A31 | =H31*G31 | ||
| 29 | 0.07 | =D31-282 | =E31*(1+0.14) | =C32+D32+E32+F32 | =(1+B32)^-A32 | =H32*G32 | ||
| 30 | 0.07 | =D32-282 | =E32*(1+0.14) | =C33+D33+E33+F33 | =(1+B33)^-A33 | =H33*G33 | ||
| =SUM(I3:I33) | ||||||||
Rahul Sunny answered 2 years agoRelated Solutions
The city of Waterbourne has made it a strategic goal to enhance livability in the city....
The city of Waterbourne has made it a strategic goal to enhance
livability in the city. The city has decided to undertake a project
that will occur in two phases. During the first phase, the city
will connect several of the parks with walking paths. During the
second phase, the city will add water features or splash fountains
to several of the parks.
The initial cost of the project will be $409250. Annual
utilities for maintaining the walking paths and...
what is the goal of strategic bundling?
identify and define the various types of strategic alternatives and how the process of bundling might help or harm the strategic motivation of the organization. what is the goal of strategic bundling?
(50 pts) Enhance the Future Goal Problem. a. Use lists to track and store the inputs...
(50 pts) Enhance the Future Goal Problem. a. Use lists to track
and store the inputs and outputs for each Future Value investment
the user calculates. b. Modify the existing code so that it
correctly calculates the numbers months/years it takes to achieve a
monetary goal. c. Write code that properly stores each input/output
value in its corresponding list. d. Comment on the provided code
for the History button. You do NOT need to modify the included
code! It will...
How can effective goal setting in an organization be used to enhance employee learning and performance?...
How can effective goal setting in an organization be used to
enhance employee learning and performance? Explain why performance
feedback is so critical to employee motivation and performance and
how it can be delivered effectively. Identify, at least, two ways
that managers can reward performance, so as to increase motivation
and creativity in the employee’s job. Discuss, at least, two
effective strategies for helping an employee improve poor
performance.
What strategic recommendations can you make to chipotle to address their issues and enhance their strategy
What strategic recommendations can you make to chipotle to
address their issues and enhance their strategy
A strategic goal of any healthcare organization is the quality performance of the employees. The Institute...
A strategic goal of any healthcare organization is the quality
performance of the employees. The Institute of Medicine (1998)
created the most accepted definition of quality in the healthcare
industry: patient services current with scientific knowledge that
result in a desired health outcome. Research information on
high-performance organizations and provide 5 strategic methods that
could be used to improve employee productivity in the healthcare
organization.
From the book "The Goal" name examples of the Ten Strategic Operations Management Decisions.
From the book "The Goal" name examples of the Ten Strategic
Operations Management Decisions.
Healthcare Human Resources Management 1. The ultimate goal of Strategic Management is to maintain a sustainable...
Healthcare Human Resources Management
1. The ultimate goal of Strategic Management is to maintain a
sustainable a competitive advantage. Explain.
The president of ABC made this statement in the company’s annual report: “ABC’s primary goal is...
The president of ABC made this statement in the company’s annual
report: “ABC’s primary goal is to increase the value of our common
stockholders’ equity. Later in the report, the following
announcements were made:
a) The company contributed $1 million to the symphony orchestra
in Chicago, IL, its headquarters city.
b) The company is spending $800 million to open a new plant and
expand operations in South Vietnam. No profits will be produced by
the Vietnamese operation for four years,...
A “strategic plan” is made up of six plans. List and explain each of these plans....
A
“strategic plan” is made up of six plans. List and explain each of
these plans. Also make sure that you explain the importance that
each plan makes to the entire strategic plan
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What are the two reasons that limit the ability of correlational studies to provide information on...
- Suppose that 20 monthly payments of $100 each are followed by 30 monthly payments of $200...
- D. Explain what it means for recommendations to be specific and actionable. E. Discuss how charts...
- Capital Toys’ management is considering eliminating product A, which has been showing a loss for several...
- Computer Networks IT 210 Please Use your own words . sorry No handwriting no copy paste...
- The Coronavirus will obviously impact the economy of big organizations like FIFA or the NBA but...
- Question: what is the difference between rights of assertion and observation assertion. Include which financial statements...
ADVERTISEMENT