Order now
     

Airport Finance Project

1. Prepare a cash flow for Memphis international airport for 20 years showing amounts coming in from the FAA, State and other amounts needed to pay costs to construct.
Assume all events happen in yearly time units.
2- Your answer must be in Excel spreadsheet.
3- Make your answer clear and easy to track. Write a formula that you will be used.

Airport Financial Project

Basic Information
Total Cost $200,000,000
Timeline
Design – 2016 1 Year
Demolition -2017 1 Year
Construction – 2018-2020 3 Years
Total Time 5 Years

Design – 10% of Total Cost $20,000,000
Demo – 5% of Total Cost $10,000,000
Total Cost of Construction $170,000,000
Square Footage Terminal B Old
Concourse Level (Ticket Counter/Gates) 175,000
Apron Level (Operations) 100,000

Square Footage Terminal B New
Concourse Level (Ticket Counter/Gates) 300,000
Apron Level (Operations) 100,000
Total Square Footage of New Concourse 400,000.00

Public Area – 1/3 of new Concourse area.

Funding
FAA (Federal) – 75% FAA/25% Airport
of public area.
State – remaining amounts at a 90% state/
10% Airport.
Both Federal and State grants are limited
to $5 million each/year.

Inflation 2%
Interest paid on borrowing 3%

Question:
1. Prepare a cash flow for 20 years showing
amounts coming in from the FAA, State and
other amounts needed to pay costs to construct.
Assume all events happen in yearly time units.
TAKE ADVANTAGE OF OUR PROMOTIONAL DISCOUNT DISPLAYED ON THE WEBSITE AND GET A DISCOUNT FOR YOUR PAPER NOW!