1-02 Exhibit C and D - TKI Percentage Rent and Rent Proforma.xlsx
XLSX spreadsheet 19 KB Posted
- Attached to
- Airport Terminal Food and Beverage Concessions
- Solicitation number
- 26-37RFP
- Issued by
- Collin County, Texas
About this file
This file contains financial proforma exhibits (Exhibits C and D) for a food and beverage concession opportunity at McKinney, Texas's airport terminal (TKI). The concession agreement is for a single post-security food and beverage unit totaling 1,150 square feet. The proforma covers a five-year lease period from 2026 through 2030, with enplanement projections ranging from 130,000 passengers in year one to 703,125 passengers by year five. The financial exhibits are designed for the successful operator (respondent) to populate with proposed sales projections, rent structures, and operating assumptions to demonstrate the financial viability of their proposed food and beverage concept.
Exhibit C requests the operator's projected sales per enplanement, sales distribution by category (food and non-alcoholic beverages, alcoholic beverages, and other), and proposed percentage rent calculations for each category with a minimum annual guarantee representing 90 percent of projected gross sales. Exhibit D requires the operator to submit a unit proforma operating statement detailing cost of goods, variable operating expenses including labor and marketing, and fixed occupancy costs to project profit or loss and the rent revenue ratio as a percentage of total sales. All financial fields are designated for the operator to complete, allowing the City to evaluate the economic feasibility and competitiveness of each respondent's proposed concession operation.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 2-01 26-37RFP TKI Concessions.pdf |
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
Package 1 F&B - Ex. C
| Exhibit C - TKI | ||||||
| CONCESSIONS PROGRAM - PERCENTAGE RENT PROFORMA | ||||||
| TKI | ||||||
| Instructions: only populate cells in yellow. | ||||||
| Financial Terms | Lease Year 1 | Lease Year 2 | Lease Year 3 | Lease Year 4 | Lease Year 5 | |
| Year: | 2026 | 2027 | 2028 | 2029 | 2030 | |
| Duration: | 12 months | 12 months | 12 months | 12 months | 12 months | |
| Estimated Enplanements: | 130,000 | 241,868 | 450,000 | 562,500 | 703,125 | |
| TKI - Location 1 | ||||||
| Location (1150 sf) | Projected Sales Per Enplanement (SPE) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 1,150 sf | ||||||
| Projected Food and Non-alcoholic Beverages as % of total sales | 0% | 0% | 0% | 0% | 0% | |
| Projected Alcoholic Beverages as % of total sales | 0% | 0% | 0% | 0% | 0% | |
| Projected Other as % of total sales | 0% | 0% | 0% | 0% | 0% | |
| Projected Sales Distribution (%) | 0% | 0% | 0% | 0% | 0% |
Desired/Preferred Concept
| Projected Gross Sales Projection | $ - | $ - | $ - | $ - | $ - | ||
| Projected Gross Sales ($/sf) | $ - | $ - | $ - | $ - | $ - |
| Rent - Food & Non-Alcoholic Bev (%) | 0% | $ - | $ - | $ - | $ - | $ - |
| Rent - Alcoholic Bev (%) | 0% | $ - | $ - | $ - | $ - | $ - |
| Rent - Other (%) | 0% | $ - | $ - | $ - | $ - | $ - |
| Total % Rent | $ - | $ - | $ - | $ - | $ - | |
| MAG | 90% | $ - | $ - | $ - | $ - | $ - |
| Proposed Concept: | ||||||
| Proposed Concept (TKI): | Rent for the Period | $ - | $ - | $ - | $ - | $ - |
| Rent ($/sf) | $ - | $ - | $ - | $ - | $ - | |
| Effective % Rent | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
Package 1 F&B - Ex. D
| Exhibit D - TKI | Populate yellow cells |
| CONCESSIONS PROGRAM - UNIT PROFORMA OPERATING STATEMENT |
| $ - 0 | $ 1.00 | $ 2.00 | $ 3.00 | $ 4.00 | |||
| % ASSUMPTION OF GROSS SALES | TOTAL - FIRST FULL YEAR SALES ESTIMATE | Lease Year 1 | Lease Year 2 | Lease Year 3 | Lease Year 4 | Lease Year 5 | |
| GROSS SALES PROJECTION (From Exhibit C) | $ - | $ - | $ - | $ - | $ - |
| COST OF GOODS ESTIMATE | ||||||
| Inventory Procurement | 0.0% | $ - | $ - | $ - | $ - | $ - |
| Supplies(Packaging, labels, etc.) | 0.0% | - | - | - | - | - |
| Markdowns | 0.0% | - | - | - | - | - |
| Inventory Shrink | 0.0% | - | - | - | - | - |
| TOTAL COST OF GOODS | $ - | $ - | $ - | $ - | $ - |
| VARIABLE OPERATING EXPENSES | 0.0% | ||||||
| Salaries and Wages | $ - | $ - | $ - | $ - | $ - | $ - | |
| Employee Benefits | $ - | - | - | - | - | - | |
| Direct Operating Expenses-transportation, shipping, etc. | 0.0% | - | - | - | - | - | |
| Marketing | 0.0% | - | - | - | - | - | |
| Repairs & Maintenance | 0.0% | - | - | - | - | - | |
| Other | 0.0% | - | - | - | - | - | |
| TOTAL VARIABLE OPERATING EXPENSES | $ - | $ - | $ - | $ - | $ - |
| FIXED OCCUPANCY COSTS | |||||
| Minimum Annual Guarantee/Percentage Rent (From Exhibit C) | $ - | $ - | $ - | $ - | $ - |
| Other | - | - | - | - | - |
| TOTAL FIXED OCCUPANCY COSTS | $ - | $ - | $ - | $ - | $ - |
| PROJECTED PROFIT/LOSS TOTAL | $ - | $ - | $ - | $ - | $ - |
| PROJECTED RENT REVENUE RATIO % OF TOTAL SALES | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
File details come from the government source that posted it. Updated .