PROTECTED_CVG_ProForma_Template_BLANK_3.2.26.xlsx
XLSX spreadsheet 30 KB Posted
- Attached to
- Food & Beverage Concessions
- Solicitation number
- 26-021-RFP Conc
- Issued by
- Kenton County, Kentucky
About this file
This is a Pro Forma financial template for the Cincinnati/Northern Kentucky International Airport (CVG) Food & Beverage Concessions contract opportunity managed by the Kenton County Airport Board (KCAB). The template is designed for proposers to project financial performance over a ten-year concession term spanning 2025 through 2034. A pre-proposal site visit is scheduled for Tuesday, April 21, 2026, at 9:00 am at CVG Main Terminal Ticketing Level, with RSVP required by March 25, 2026, through KCAB's online bidding system. Questions regarding the opportunity are due by 11:59 pm on Thursday, May 14, 2026, with answers posted no later than May 21, 2026. Proposals must be submitted by Thursday, June 25, 2026, at 11:59 pm through the online procurement portal at https://procurement.opengov.com/portal/cvgairport. The contract term runs for ten years from 2025 through 2034.
The Pro Forma template requires proposers to complete financial projections based on specified airport enplanement assumptions, which range from 4,484,926 in 2025 to 5,308,229 in 2034 with a 2 percent year-over-year growth rate. Proposers must input their capture rate, average check, cost of goods sold, wages, and operating expenses, including utilities, royalties, insurance, repairs and maintenance, rent, and general administrative costs. The template calculates gross profit, EBITDA, and net profit across the ten-year period. The template includes instructional notes indicating that capture rates should be entered as whole number percentages rather than decimals, and all financial assumptions should be entered only in designated yellow cells. The blank Pro Forma template serves as the standardized financial analysis tool for all bidders to demonstrate the economic viability of their proposed food and beverage concession operation at CVG.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Food_&_Beverage_Concessions.pdf | ||
| Proposed_Agreement_-_Food_&_Beverage_Concession.pdf | ||
| 2026.03.24_RFP_Release_Technical_Design_Criteria_Manual.docx | DOCX document | |
| Proforma_Instruction_Guide_3.2.26.docx | DOCX document | |
| 2025_Airline_Rankings.xlsx | XLSX spreadsheet | |
| 2025_Monthly_Enplanements.xlsx | XLSX spreadsheet | |
| Condition_Assessment_Summary.pdf | ||
| Condition_Assessment_-_A-004.pdf | ||
| Condition_Assessment_-_A-031.pdf | ||
| KCAB_-_RSVP_Instructional_Guide_for_OpenGov.pdf | ||
| Condition_Assessment_-_A-015.pdf | ||
| LOD_A-015.pdf | ||
| LOD_A-004.pdf | ||
| LOD_A-031.pdf | ||
| CVG_Flight_Schedule_Summary_2025_06.30_-_07.06.pdf | ||
| XX-XXRFP_Food_&_Beverage_Multi_Unit_Concessions_4.24.25_DRAFT.docx | DOCX document | |
| 2024_Monthly_Enplanements.xlsx | XLSX spreadsheet | |
| 2024_Airline_Rankings.xlsx | XLSX spreadsheet |
Show all 18
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
ProFroma
| Cincinnati/Northern Kentucky International Airport |
| Concession Pro Forma |
| Term: |
| Concept: |
| Location: |
PLEASE FILL IN YELLOW CELLS ONLY 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 Total
| ASSUMPTIONS USED | |||||||||||
| Airport Overall Enplanements | 4,484,926 | 4,506,301 | 4,621,132 | 4,713,555 | 4,807,826 | 4,903,983 | 5,002,062 | 5,102,104 | 5,204,146 | 5,308,229 | 48,654,263 |
| YOY Increase | 0% | 2% | 2% | 2% | 2% | 2% | 2% | 2% | 2% | 2% |
Capture Rate tc={F3F7F9A8-70B1-426F-A04C-6BD0D6038C43}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| Capture Rate should be entered as a whole number, not a decimal. For example, enter 33% instead of 0.33. | 0.0% | |||||||||||
| Capture Enplanments | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Average Check | 0.00 | ||||||||||
| Sales per Enplanement | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.00 |
| Gross Sales: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - | |
| Cost of Goods Sold | $ - | |||||||||||
| A | Gross Profit | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Expenses | ||||||||||||
| Wages | ||||||||||||
| Management/Administrative | $ - | |||||||||||
| Employee | $ - | |||||||||||
| Benefits | $ - | |||||||||||
| Taxes | $ - | |||||||||||
| B | Total Wages | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - |
| Utilities | $ - | |||||||||||
| Royalties/Advertising | $ - | |||||||||||
| Insurance | $ - | |||||||||||
| Repairs/Maintenance | $ - | |||||||||||
| Rent | $ - | |||||||||||
| General Administrative | $ - | |||||||||||
| Other Direct Expenses | $ - | |||||||||||
| C | Sub-Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - |
D Total Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ -
| E | EBITDA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - |
| F | Interest, Depreciation, and Amortization | $ - | ||||||||||
| Marketing Fund | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - | |
| G | Net Profit | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
Proposer's Notes:
Capture Rate should be entered as a whole number, not a decimal. For example, enter 33% instead of 0.33.
File details come from the government source that posted it. Updated .