Question
In: Economics
The municipality of a major city in Quebec is planning to build a new bridge to...
The municipality of a major city in Quebec is planning to build a new bridge to decrease the traffic load on the existing bridges connecting both sides of the city across the river. Construction is to start in 2020 and is expected to take four years at a cost of $25 million per year. After construction is completed, the cost of operation and maintenance is expected to be $2.5 million for the first year and to increase by 2.8% per year thereafter. The scrap/salvage value of the bridge at the end of year 2053 is estimated to be $5 million. Consider the present to be the end of 2018/beginning of 2019 and the interest rate to be 8%.
a) Draw a cash flow diagram for this project (from
present till end of year 2053).
b) Find the Present Worth of this project.
c) Find the Future Worth of this project.
Solutions
Expert Solution
a) Cash Flow Diagram 
B) & C) part using excel,
i = 8% = 0.08
For PV factor, we use formula 1/ (1+0.08)^(year - 2018)
Construction cost per year for four years = 25m
O&M cost for first year = 2.5m
Cash flow of O&M cost = 1.028 * cost of O&M in previous year
| Year | Construction cost | O&M Cost | Scrap value | Net cash flow | PV Factor | Present value |
| 2018 | 0.00 | 1 | 0.00 | |||
| 2019 | 0.00 | 0.925925926 | 0.00 | |||
| 2020 | -25000000 | -25000000.00 | 0.85733882 | -21433470.51 | ||
| 2021 | -25000000 | -25000000.00 | 0.793832241 | -19845806.03 | ||
| 2022 | -25000000 | -25000000.00 | 0.735029853 | -18375746.32 | ||
| 2023 | -25000000 | -25000000.00 | 0.680583197 | -17014579.93 | ||
| 2024 | -2500000 | -2500000.00 | 0.630169627 | -1575424.07 | ||
| 2025 | -2570000 | -2570000.00 | 0.583490395 | -1499570.32 | ||
| 2026 | -2641960 | -2641960.00 | 0.540268885 | -1427368.78 | ||
| 2027 | -2715935 | -2715934.88 | 0.500248967 | -1358643.62 | ||
| 2028 | -2791981 | -2791981.06 | 0.463193488 | -1293227.44 | ||
| 2029 | -2870157 | -2870156.53 | 0.428882859 | -1230960.94 | ||
| 2030 | -2950521 | -2950520.91 | 0.397113759 | -1171692.45 | ||
| 2031 | -3033135 | -3033135.49 | 0.367697925 | -1115277.63 | ||
| 2032 | -3118063 | -3118063.29 | 0.340461041 | -1061579.07 | ||
| 2033 | -3205369 | -3205369.06 | 0.315241705 | -1010466.01 | ||
| 2034 | -3295119 | -3295119.39 | 0.291890468 | -961813.94 | ||
| 2035 | -3387383 | -3387382.74 | 0.270268951 | -915504.38 | ||
| 2036 | -3482229 | -3482229.45 | 0.250249029 | -871424.54 | ||
| 2037 | -3579732 | -3579731.88 | 0.231712064 | -829467.06 | ||
| 2038 | -3679964 | -3679964.37 | 0.214548207 | -789529.76 | ||
| 2039 | -3783003 | -3783003.37 | 0.198655748 | -751515.36 | ||
| 2040 | -3888927 | -3888927.47 | 0.183940507 | -715331.29 | ||
| 2041 | -3997817 | -3997817.44 | 0.170315284 | -680889.41 | ||
| 2042 | -4109756 | -4109756.33 | 0.157699337 | -648105.85 | ||
| 2043 | -4224830 | -4224829.50 | 0.146017905 | -616900.75 | ||
| 2044 | -4343125 | -4343124.73 | 0.135201764 | -587198.12 | ||
| 2045 | -4464732 | -4464732.22 | 0.125186818 | -558925.62 | ||
| 2046 | -4589745 | -4589744.72 | 0.115913721 | -532014.39 | ||
| 2047 | -4718258 | -4718257.58 | 0.107327519 | -506398.88 | ||
| 2048 | -4850369 | -4850368.79 | 0.099377333 | -482016.71 | ||
| 2049 | -4986179 | -4986179.11 | 0.092016049 | -458808.50 | ||
| 2050 | -5125792 | -5125792.13 | 0.085200045 | -436717.72 | ||
| 2051 | -5269314 | -5269314.31 | 0.078888931 | -415690.57 | ||
| 2052 | -5416855 | -5416855.11 | 0.073045306 | -395675.84 | ||
| 2053 | -5568527 | 5000000 | -568527.05 | 0.067634543 | -38452.07 | |
| Net Present Value | -101606193.87 | |||||
| Future value = Present value *(1+i)^t | Future Value | -1502282558.87 | ||||
Pls comment if you require any further explanation or you think the solution is wrong
Rahul Sunny answered 1 year agoRelated Solutions
The City of Pawnee, IN (not a real city) is planning to build a new hospital...
The City of Pawnee, IN (not a real
city) is planning to build a new hospital next year that has a
property value of $100 million. The Pawnee government plans to keep
the property tax rate the same every year and to provide the same
government services as they did last year. That is, the total
budgeted expenditures and income from other sources will remain
unchanged. Note: This question does not require any numerical
calculations.
Will the average amount of...
A new bridge is to be constructed over the East River in New York City. Two...
A new bridge is to be constructed over the East River in New
York City. Two structural possibilities exist: the support could be
in the shape of a parabola or the support could be in the shape of
a semi-ellipse.
The space between the supports needs to be 1050 feet.
The height at the center of the arch needs to be 350 feet.
Determine the equation of a parabola with these characteristics.
(Hint: Place the vertex of the parabola at...
A certain municipality is planning to construct a new water treatment plant. The average water requirement...
A certain municipality is planning to construct a new water
treatment plant. The average water requirement is equivalent to
123456 m3 /d). The peak flow rate is twice the average flow rate. A
jar test experiment revealed the following results: Alum dose: 15
mg/L Temperature: 20 o C Coagulation: G = 850 s-1 , t = 40 s
Flocculation: GT =123456 . Settling: t = 1.5 h.
a) Determine the size of the coagulation tank (L=2W, W=D) and
flocculation tank...
9. A $2,000,000 bond was issued on April 20, 2020 to build a new bridge. The...
9. A $2,000,000 bond was issued on
April 20, 2020 to build a new bridge. The bonds carried a 4%
interest rate and are due in 10 years. The first bond payment was
made on March 31, 2021 for $280,000, which included $80,000 of
interest.
Required:
(A.) Prepare the required journal
entry in the Capital Projects Fund on April 20 for the Fund
Financial Statements and the entry on March 31 to record the
repayment of the bonds.
(B.) Prepare...
1. The city of Ottawa is planning to build a man-make lake at LeBreton flats. The...
1. The city of Ottawa is planning to build a man-make lake at
LeBreton flats. The government would like to know how to value and
monetize the benefits of such a project. You have been asked to
advise the city of the appropriate approach to use for the
valuation and monetization of the benefits. What approach will you
advice the city to use? What are the key steps of your proposed
approach? What are the limitations of the approach?
Stanford Company has contracted to build for the City of New London a new courthouse. The...
Stanford Company has contracted to build for the City of New
London a new courthouse. The estimated cost of the project is
$6,000,000, and the contract price is $9,000,000. The courthouse
took three years to complete as follows:
2018
2019
2020
Costs to
date
$1,500,000
$4,000,000
$6,200,000
Cost to
complete
$4,500,000
$2,200,000
$0
Amounts billed to date
$1,400,000
$5,800,000
$9,000,000
Amounts collected to date
$1,300,000
$4,300,000
$9,000,000
Determine the gross profit to be recognized for
2018 ...
Stanford Company has contracted to build for the City of New London a new courthouse. The...
Stanford Company has contracted to build for the City of New
London a new courthouse. The estimated cost of the project is
$6,000,000, and the contract price is $9,000,000. The courthouse
took three years to complete as follows:
2018
2019
2020
Costs to
date
$1,500,000
$4,000,000
$6,200,000
Cost to
complete
$4,500,000
$2,200,000
$0
Amounts billed to date
$1,400,000
$5,800,000
$9,000,000
Amounts collected to date
$1,300,000
$4,300,000
$9,000,000
Determine the gross profit to be recognized for
2018 ...
Assume a company is planning to make a major financial investment to build a manufacturing facility...
Assume a company is planning to make a major financial
investment to build a manufacturing facility in a foreign country.
Which of the following risks is particularly important to research
in the foreign country?
Diversification risk
Commercial risk
Political risk
Translational risk
Transactional risk
TechMedia, Inc. is a U.S. firm that is planning to build a new production facility in...
TechMedia, Inc. is a U.S. firm that is planning to build a new
production facility in either the USA or China. The initial cost to
build the facility will be $8.2 million if built in the USA or ¥45
million if built in China. In either location, the project will
require an initial investment of $225,000 in net working capital.
Net working capital at the end of each of years 1 through 4 will be
$65,000. Net working capital will...
he main reason for the financial statements and reporting for any city or municipality is for...
he main reason for the financial statements and reporting for
any city or municipality is for the following …
Select one:
a. Implement the interperiod equity concept.
b. Create accountability of the reports.
c. Budgetary compliance.
d. To show the service efforts.
e. To show the accomplishments.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Describe in detail two modern applications of electromagnets. Do these electromagnets draw a large amount of...
- Refunding Analysis Mullet Technologies is considering whether or not to refund a $250 million, 13% coupon,...
- in java What object is passed to the start method in a JavaFX program? What should...
- QUESTION ONE Briefly explain the following types of errors: (i) Error of commission &n
- List the basic principles of the distillation tower at least 4 principal and why there are...
- Imagine you're a business owner: If waiting in lines is a truly inescapble event for your...
- A piston-cylinder device initially contains 0.20(kg) of steam at 3.5(MPa), 300(C). The steam loses heat to...
ADVERTISEMENT