Conduct an ROI analysis of the Mario Cuomo Bridge
In your Excel file, be clear to share with us the following:
At what month/year does the bridge break-even with the revenue it generates every month/year.
If the bridge is suppose to have a lifespan of 100 years, at the end of 100 years, how much revenue would it
have generated?
Please take the following variables into consideration
Monthly traffic flow due to seasonality
How monthly traffic will increase over time due to population increase (or you can argue it may decrease due
to technology innovations and people working from home)
What the monthly toll rates are and how they fluctuate over time (you have control over this clearly in your
model).
Due to COVID19, traffic has significantly declined and you can assume this will be the case for the next 3
months. How will that impact revenue and extend the time to break even?
You do not have to assume inflation, but if you do, bonus points!
Please make it a point to use a visual to show your model. Here is a great example from the NYTimes on a
topic we just spoke about: https://www.nytimes.com/interactive/2020/03/25/opinion/coronavirus-trumpreopen-america.html?utm_source=digg
Resources:
http://www.thruway.ny.gov/about/financial/monthly/index.html (Click on the “Blue Book” links and see the
monthly revenue for the Cuomo Bridge). In order to forecast as accurately as possible, you will need at least
24 months of data. The more data you have, the more accurately you can forecast into the future.
https://en.wikipedia.org/wiki/Tappan_Zee_Bridge_(2017%E2%80%93present)
https://en.wikipedia.org/wiki/Tappan_Zee_Bridge_(1955%E2%80%932017).
All work should be showed in excel sheets. small write up in the excel file to explain assumptions and how
the results came about