SUBMITTAL D_Pro Forma Template.xlsx
XLSX spreadsheet 19 KB Posted
- Solicitation number
- 147166
- Issued by
- Multnomah County, Oregon
About this file
This file is a pro forma financial template for the 2026 Advertising Program Concession Solicitation at Portland International Airport (Solicitation No. 2026-14650) in Oregon. The template is designed for proposers to submit detailed financial projections across a ten-year contract term. Proposers are required to complete the electronic submission through the PlanetBids system prior to the deadline specified in the project schedule. A non-mandatory pre-proposal meeting will be held to allow proposers to ask questions and receive clarification from subject matter experts. All questions must be submitted through PlanetBids with responses provided within 72 hours, and a question submission deadline is established on the schedule. The successful proposer will be notified by the estimated award date listed on the schedule, with results posted to PlanetBids as the final step in the selection process.
The pro forma template requires proposers to project gross receipts from up to five revenue line items across all ten years, broken down by dollar amount and percentage of sales. Proposers must also detail proposed rents, including minimum annual guarantees, and comprehensive operating expenses including payroll, benefits, franchise fees, repairs and maintenance, support space rent, utilities, insurance, licenses and permits, and selling, general and administrative costs. The template calculates EBITDA, interest and depreciation/amortization, and net profit or loss before taxes for each year. Additionally, proposers must identify total initial investments and mid-term refurbishment costs projected across the contract term. This financial documentation allows the Port of Portland to evaluate the financial viability and revenue generation potential of each proposal for the advertising concession operation.
View the file
Other files
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
Sheet1
| SUBMITTAL C - Pro Forma Template |
| 2026 Concession Solicitation at Portland International Airport |
| Advertising Program Request for Proposals |
| Solicitation No. 2026-14650 |
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | ||||||||||||
| Gross Receipts (Sales) | Total Dollars ($) | % of Sales | Total Dollars ($) | % of Sales | Total Dollars ($) | % of Sales | Total Dollars ($) | % of Sales | Total Dollars ($) | % of Sales | Total Dollars ($) | % of Sales | Total Dollars ($) | % of Sales | Total Dollars ($) | % of Sales | Total Dollars ($) | % of Sales | Total Dollars ($) | % of Sales | |
| Item #1 | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Item #2 | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Item #3 | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Item #4 | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Item #5 | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Total Gross Receipts | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% |
| Proposed Rents | |||||||||||||||||||||
| Proposed Rent | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Proposed Minimum Annual Guarantee | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Rent Payable to Port | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% |
| Operating Expenses | |||||||||||||||||||||
| Payroll | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Benefits | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Franchise/License/Brand Fees | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Repairs and maintenance | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Support space rent | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Offices, storage, distribution | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Utilities | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Insurance | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Licenses and permits | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| SG&A | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Item #1 | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Item #2 | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Item #3 | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Item #4 | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Item #5 | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Total Operating Expenses (excluding rent) | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Total Operating Expenses (including rent) | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% |
| EBITDA* | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Interest, depreciation and amortization | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| Net Profit (Loss) before tax | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | $ - 0 | 0.0% | |
| *Earnings before interest, taxes, depreciation and amortization |
| Total Initial Investments | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Mid-term Refurbishment | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
File details come from the government source that posted it. Updated .