Question
The City of Aviation is considering undergoing a major expansion and will be building a new terminal at its major international airport. The cost of
The City of Aviation is considering undergoing a major expansion and will be building a new terminal at its major international airport. The cost of the terminal is estimated to be $3.6 billion dollars which is similar to the cost of Salt Lake Citys (Links to an external site.)Links to an external site. new terminal. Assume all initial construction costs are paid in year 0.
The new terminal will be financed entirely with bonds paying 5.75 percent. The project will have a 40 year life. In year 21 a major renovation is projected and projected to have a price of 1.2 billion dollars in year 21. The 1.2 is in year 21 dollars.
Revenue assumptions are:
Total aeronautical revenue per year $140,000,000
Total non-aeronautical revenue per year $175,000,000
Total aeronautical revenue is projected to grow at 2.5 percent per year and total non-aeronautical revenue is projected to grow at 6 percent per year.
Total expenses are projected to be 60 percent of each years total revenue.
Solve the Problem
Create a timeline to model the project and calculate the Net Present Value (NPV) of the project. Disregard taxes and depreciation in your analysis
What is the NPV?
Based on the analysis should the project be pursued?
For help in calculating NPV, review the NPV video examples below.
Submit your spreadsheet with a working model that solves this problem.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started