Question: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%