Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

May you please solve by excel and show me the calculation or formula you use for each cell ? A bridge is to be constructed

image text in transcribedMay you please solve by excel and show me the calculation or formula you use for each cell ?

A bridge is to be constructed now as part of a new road. An analysis has shown that traffic density on the new road will justify a two-lane bridge at the present time. Because of uncertainty regarding future use of the road, the time at which an extra two lanes will be required is currently being studied. The estimated probabilities of having to widen the bridge to four lanes at various times in the future are as follows: Widen Bridge In Probability 3 years 4 years 5 years 6 years 0.2 0.3 0.4 The present estimated cost of the two-lane bridge is $2,000,000. If constructed now, the four-lane bridge will cost $3,500,000. The future cost of widening a two-lane bridge will be an extra $2,000,000 plus $250,000 for every year that widening is delayed. If money can earn 12% per year, what would you recommend? A bridge is to be constructed now as part of a new road. An analysis has shown that traffic density on the new road will justify a two-lane bridge at the present time. Because of uncertainty regarding future use of the road, the time at which an extra two lanes will be required is currently being studied. The estimated probabilities of having to widen the bridge to four lanes at various times in the future are as follows: Widen Bridge In Probability 3 years 4 years 5 years 6 years 0.2 0.3 0.4 The present estimated cost of the two-lane bridge is $2,000,000. If constructed now, the four-lane bridge will cost $3,500,000. The future cost of widening a two-lane bridge will be an extra $2,000,000 plus $250,000 for every year that widening is delayed. If money can earn 12% per year, what would you recommend

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Emotion Behind Money Building Wealth From The Inside Out

Authors: Julie M. Murphy

1st Edition

979-8598954188

More Books

Students also viewed these Finance questions

Question

Identify and describe limitations of ratio analysis.

Answered: 1 week ago