Question:
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%
TAKE ADVANTAGE OF OUR PROMOTIONAL DISCOUNT DISPLAYED ON THE WEBSITE AND GET A DISCOUNT FOR YOUR PAPER NOW!