The file's text, extracted by GovTribe without its formatting.
EXHIBIT XX - PROFORMA OPERATING STATEMENT
MINNEAPOLIS AIRPORTS COMMISSION
MINNEAPOLIS/ST. PAUL INTERNATIONAL AIRPORT
Provide a projection of sales, expenses and net income for the Wi-Fi concession. Describe major assumptions. Attach additional sheets as necessary. In order for the Review Team to more easily compare Proposals, we ask that you conform your numbers to the format of income and expense categories described in the following sections and illustrated in the form at the end of this exhibit.
General Information We are requesting a proforma for the concept you are proposing.
Income/Expense Description Line
| 1. | Revenue is defined as gross receipts. See definition of “Gross Sales” in Contract. |
| 2. | This line indicates the projected gross revenue from tenant space rent. If additional revenue sources are identified, list all revenue by category. |
| 3. | Total Revenue is the sum of all items listed in line 2. |
| 4. | Cost of sales in line 4 should be all costs of the product/service sold. |
| 5. | Total cost of sales represents the sum of all costs itemized in line 4. |
| 6. | Gross Income represents Total Revenue (line 3) less Total Cost of Sales (Line 6). |
| 7. | Controllable Expenses are the expenses directly related to the operating revenue and controlled by on-site management. All controllable expense account line items should represent the total for all locations being proposed. |
| 8. | Salaries and wages include all regular salaries and wages, overtime and bonus payments to employees. |
| 9. | Employee Benefits includes all payroll taxes (FICA, etc.), social insurance costs (worker’s compensation, health, etc.), and any other benefits paid to employees including paid time off. |
| 10. | Direct Operating expenses include expenses directly involved in service to the customer that are not included in the cost of sales (Line 4). |
| 11. | Marketing expenses include all indirect operating costs associated with selling, promotion, advertising, public relations, and marketing research. |
| 12. | Energy and utilities include all expenses related to electricity, HVAC, water, waste removal, etc. |
| 13. | Administrative and General expenses are commonly considered as indirect costs of operation and include, but are not limited to, postage, telephone, accounting/audit, general and property insurance, and security. |
| 14. | The Repairs and Maintenance line includes, repairs to furniture, fixture, equipment and maintenance contracts. These are expense items and not capital items as is the case with depreciation and reserve for replacement. |
| 15. | This line represents the total of all controllable expenses (Lines 7-14). |
| 16. | Income before fixed charges is calculated by subtracting the Controllable Expense total from Gross Income. This represents income before deduction of fixed charges such as occupation costs, reserve for replacement, interest, depreciation, amortization and income taxes. |
| 17. | Occupancy Costs include costs directly related to occupying and use of premises. The format provides for additional rent. |
| 18. | Ground Rent. Ground rent as governed by MAC Ordinance 121. There is a 10% increase in ground rent every 5 years. |
| 19. | Indirect cost recovery - This charge covers MAC provided services that a city would traditionally cover such as fire, police, public works, streets and other infrastructure/administration. This charge increases 2.5% January 1 or every year. |
| 20. | Participation Rent – Percentage of gross revenue offered as rent to MAC. |
| 21. | Taxes include property taxes and any other tax related to personal property. |
| 22. | Property insurance is the cost of insuring the property from fire, and other types of loss including liability as required by the Contract. |
| 23. | Reserve for replacement represents the capital set aside for maintaining the condition of the operation/asset. |
| 24. | Corporate overhead represents costs associated with corporate office. This is not a controllable expense of unit management and is typically an allocation from the company’s corporate office. |
| 25. | Miscellaneous costs. This allows for costs not previously stated and should be kept to 3% or less of Total revenue (line 3). |
| 26. | This line represents the total of all occupancy costs (lines 17-24). |
| 27. | Earnings before Interest, Taxes, Depreciation and Amortization. (“EBITDA”). It is calculated by subtracting line 25 (Total Occupancy Costs) from line 16 (Income Before Fixed Charges). |
EXHIBIT F-1 - PER-UNIT PROFORMA OPERATING STATEMENT (YEAR 1)
CONCEPT TYPE: PROPOSER:
HOURS OF OPERATION:
LINE #
| (2) |
| Space rent revenue – Cargo Facility |
| $ |
| % |
| Other revenue - list type/category or revenue(s) |
| $ |
| % |
| (3) |
| TOTAL REVENUE |
| $ |
| 100.0% |
| (5) |
| TOTAL COST OF SALES |
| $ |
| % |
| (7) |
| CONTROLLABLE EXPENSES |
| (8) |
| Salaries and Wages |
| $ |
| % |
| (9) |
| Employee Benefits |
| $ |
| % |
| (10) |
| Direct Operating Expenses |
| $ |
| % |
| (12) |
| Energy & Utilities |
| $ |
| % |
| (13) |
| Administrative & General |
| $ |
| % |
| (14) |
| Repairs & Maintenance |
| $ |
| % |
| (15) |
| TOTAL CONTROLLABLE EXPENSES |
| $ |
| % |
| (16) |
| INCOME BEFORE FIXED CHARGES |
| $ |
| % |
| (18) |
| Ground Rent (Rent starts at $0.83/SF) |
| $ |
| % |
| (19) |
| Indirect Cost recovery ($0.82/SF – 2026) |
| $ |
| % |
| (20) |
| Participation Rent (on Gross Receipts) |
| (21) |
| Taxes-Property & Other |
| $ |
| % |
| (22) |
| Property Insurance |
| $ |
| % |
| (23) |
| Reserve for Replacement |
| $ |
| % |
| (24) |
| Corporate Overhead |
| $ |
| % |
| (25) |
| Miscellaneous Costs |
| $ |
| % |
| (26) |
| TOTAL OCCUPANCY COSTS |
| $ |
| % |
Assumptions: Please share in detail your development assumptions including:
1. Size of the facility you propose to build: ___________________________________
2. Price per square foot you plan to charge tenants in year 1: _____________________
3. Will the price escalate or remain flat for term of the lease? _____________________
a. If it escalates, how often and what escalator is used? ________________
4. Estimated your cost to construct the facility: _________________________
5. Other assumptions used that materially affect your proposal