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 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 TermsLease Year 1Lease Year 2Lease Year 3Lease Year 4Lease Year 5
Year:20262027202820292030
Duration:12 months12 months12 months12 months12 months
Estimated Enplanements:130,000241,868450,000562,500703,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 sales0%0%0%0%0%
Projected Alcoholic Beverages as % of total sales0%0%0%0%0%
Projected Other as % of total sales0%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$ -$ -$ -$ -$ -
MAG90%$ -$ -$ -$ -$ -
Proposed Concept:
Proposed Concept (TKI):Rent for the Period$ -$ -$ -$ -$ -
Rent ($/sf)$ -$ -$ -$ -$ -
Effective % RentERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

Package 1 F&B - Ex. D

Exhibit D - TKIPopulate yellow cells
CONCESSIONS PROGRAM - UNIT PROFORMA OPERATING STATEMENT
$ - 0$ 1.00$ 2.00$ 3.00$ 4.00
% ASSUMPTION OF GROSS SALESTOTAL - FIRST FULL YEAR SALES ESTIMATELease Year 1Lease Year 2Lease Year 3Lease Year 4Lease Year 5
GROSS SALES PROJECTION (From Exhibit C)$ -$ -$ -$ -$ -
COST OF GOODS ESTIMATE
Inventory Procurement0.0%$ -$ -$ -$ -$ -
Supplies(Packaging, labels, etc.)0.0%-----
Markdowns0.0%-----
Inventory Shrink0.0%-----
TOTAL COST OF GOODS$ -$ -$ -$ -$ -
VARIABLE OPERATING EXPENSES0.0%
Salaries and Wages$ -$ -$ -$ -$ -$ -
Employee Benefits$ ------
Direct Operating Expenses-transportation, shipping, etc.0.0%-----
Marketing0.0%-----
Repairs & Maintenance0.0%-----
Other0.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 SALESERROR:#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 .