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...
AZRB is a road bridge construction company. The company plan to build a major road bridge...
AZRB is a road bridge construction
company. The company plan to build a major road bridge for its new
project. Table shows the process sequence and other related data
for the major road bridge development.
Table :Activities to construct the bridge, estimated time and
crashing cost.
Activity
Predecessor
Time Estimates (Days)
Cost (RM per day)
Crash cost (RM per day)
Optimistic
Most Likely
Pessimistic
Maximum crash time (days)
a
m
b
A
-
65
73
90
100
150
6
B...
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...
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...
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...
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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- A firm with a 13% WACC is evaluating two projects for this year's capital budget. After-tax...
- The amount of water in a bottle is approximately normally distributed with a mean of 2.40...
- How to gather requirements and plan to identify unauthorized access attempts and block compromised systems from...
- 1) Suppose that a certain population of 100 individuals possesses two alleles (A and B) at...
- Information from the American Institute of Insurance indicates the mean amount of life insurance per household...
- The 7-year $1000 par bonds of Vail Inc. pay 9 percent interest. The market's required yield...
- Question: 3 There are four witnesses to a theft crime and investigator found out that if...
ADVERTISEMENT