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!

Place a similar order with us or any form of academic custom essays related subject and it will be delivered within its deadline. All assignments are written from scratch based on the instructions which you will provide to ensure it is original and not plagiarized. Kindly use the calculator below to get your order cost; Do not hesitate to contact our support staff if you need any clarifications.

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total:

Whatever level of paper you need – college, university, research paper, term paper or just a high school paper, you can safely place an order.