attachment-download.xlsx
XLSX spreadsheet 39 KB Posted
- Solicitation number
- UU204763112
- Issued by
- Salt Lake County, Utah
About this file
This Excel spreadsheet is a revenue projection template for a Request for Proposal (RFP) issued by the University of Utah for an Outdoor Digital Signage Network Partnership. The RFP seeks a long-term contract with a vendor to operate, maintain, and sell advertising for existing and proposed outdoor media signage assets, which include 4 large format signs and 16 small format signs (12 interactive kiosks and 4 parking garage signs). The project aims to expand the network by adding 5-7 large format signs on main campus and 15-30 new small format signs, with potential off-campus locations at various health centers and facilities. The contract term spans 25 years, divided into an initial contract term, two five-year extensions, and includes provisions for phased implementation of new signage.
The revenue projection template requires vendors to provide detailed financial projections across multiple categories, including existing network revenue, proposed large format and small format sign revenues, and potential off-campus location revenues. Vendors must specify gross revenue, percentage share to the University, and share amounts for each year and sign type. The template also includes sections for an assumption payment for existing assets and an annual revenue share guaranty. Notably, the RFP emphasizes creating a "University of Light" that promotes community, the University, local and student art, and potentially generates additional revenue through strategic media placement and advertising sales.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment B Schedule_s A-C.docx | DOCX document | |
| UU204763112 Outdoor Signage Network Partnership.docx | DOCX document |
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
Instructions Please use this spreadsheet to provide revenue projections as part of your proposal response. Only enter information in tabs and cells that are green. Yellow tabs and cells have formulas that will pull automatically. Similarly, green colored tabs have cells for you to enter information. The yellow tab and any yellow cell do not require any entry and are locked. Please provide any notes regarding your revenue projections in the spaces provided.
The last tab in blue is an unscored revenue projection for potential off-campus large format locations and will be used for informational purposes only.
When you are finished, please save and submit this excel file with all other parts of your RFP response.
| VENDOR |
| Enter Company Name |
| CONTACT NAME |
PHONE
Projected Revenue Master
| VENDOR | Enter Company Name | ||||||||
| Revenue Projections | |||||||||
| Existing Network | New Large Format | New Small Format | Total | Overall % Share | |||||
| Gross Revenue | Share to University | Gross Revenue | Share to University | Gross Revenue | Share to University | Gross Revenue | Share to University | ||
| Year 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 3 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 7 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 8 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 9 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 10 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 11 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 12 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 13 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 14 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 15 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 16 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 17 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 18 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 19 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 20 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 21 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 22 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 23 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 24 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 25 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Total Assumption Payment | $ - 0 | 0 | |||||||
| Annual Revenue Share Guaranty | $ - 0 | 0 | |||||||
| Final Annual Revenue Share % | ERROR:#DIV/0! |
Revenue - Existing Network
| VENDOR | Enter Company Name | ||||||||||||
| Instructions: | Enter revenue projections and revenue percentage share to UU only in the GREEN cells as appropriate for each type of sign in the existing network. DO NOT ENTER DATA INTO YELLOW CELLS, THE FORMULAS IN THEM WILL CALCULATE AUTOMATICALLY. Place any questions or notes in the available space below the table. As a reminder, there are four (4) large format signs and sixteen (16) small format signs consisting of twelve (12) interactive kiosks and four (4) parking garage signs including in the existing media signage assets. | ||||||||||||
| Revenue Projections - Existing Network | |||||||||||||
| Large Format (4) | Interactive Kiosks (12) | Garage Signs (4) | Total | ||||||||||
| Gross Revenue | % to UU | Share to UU | Gross Revenue | % to UU | Share to UU | Gross Revenue | % to UU | Share to UU | Gross Revenue | Share to University | Overall % | ||
| EXAMPLE ENTRY | $ 5,000,000.00 | 50% | $ 2,500,000.00 | $ 2,000,000.00 | 60% | $ 1,200,000.00 | $ 1,000,000.00 | 35% | $ 350,000.00 | $ 8,000,000.00 | $ 4,050,000.00 | 51% | |
| INITIAL CONTRACT TERM | Year 1 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 2 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 3 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 4 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 5 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 6 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 7 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 8 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 9 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 10 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 11 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 12 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 13 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 14 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 15 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| 1ST FIVE YEAR EXTENSION | Year 16 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 17 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 18 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 19 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 20 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| 2ND FIVE YEAR EXTENSION | Year 21 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 22 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 23 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 24 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 25 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Total | $ - 0 | NA | $ - 0 | $ - 0 | NA | $ - 0 | $ - 0 | NA | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Notes: |
Revenue - Proposed Large Format
| VENDOR | Enter Company Name |
| Instructions: | Enter revenue projections for growth of the network only in the GREEN cells per the following desired schedule of new large format signs: |
• Phase 1 - Within one year - 2-3 large format signs
• Phase 2 - Within two years - an additional 1-2 large format signs
• Phase 3 - Within three years - an additional 2 large format signs As a reminder, these are potential/proposed locations only. You have been asked to rank order these locations in Schedule A. DO NOT ENTER DATA INTO YELLOW CELLS, THE FORMULAS IN THEM WILL CALCULATE AUTOMATICALLY. Place any questions or notes in the available space below the table.
| Revenue Projections | |||||||||||||
| Phase One - 2-3 Additional Large Format | Phase Two - 1-2 Additional Large Format | Phase Three - 2 Additional Large Format Signs | Total | ||||||||||
| Gross Revenue | % to UU | Share to UU | Gross Revenue | % to UU | Share to UU | Gross Revenue | % to UU | Share to UU | Gross Revenue | Share to University | Overall % | ||
| EXAMPLE ENTRY | $ 5,000,000.00 | 50% | $ 2,500,000.00 | $ 2,000,000.00 | 60% | $ 1,200,000.00 | $ 1,000,000.00 | 35% | $ 350,000.00 | $ 8,000,000.00 | $ 4,050,000.00 | 51% | |
| INITIAL CONTRACT TERM | Year 1 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||||
| Year 2 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| Year 3 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 4 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 5 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 6 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 7 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 8 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 9 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 10 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 11 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 12 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 13 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 14 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 15 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| 1ST FIVE YEAR EXTENSION | Year 16 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 17 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 18 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 19 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 20 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| 2ND FIVE YEAR EXTENSION | Year 21 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 22 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 23 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 24 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 25 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Total | $ - 0 | NA | $ - 0 | $ - 0 | NA | $ - 0 | $ - 0 | NA | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Notes: |
Revenue - Proposed Small Format
| VENDOR | Enter Company Name |
| Instructions: | Enter revenue projections for growth of the network only in the GREEN cells per the following desired schedule of new small format signs: |
• Phase 1 - Within one year - 5-10 small format signs
• Phase 2 - Within two years -5-10 small format signs
• Phase 3 - Within thre years - 5-10 small format signs As a reminder, locations on main campus will be chosen for these after contracting. DO NOT ENTER DATA INTO YELLOW CELLS, THE FORMULAS IN THEM WILL CALCULATE AUTOMATICALLY. Place any questions or notes in the available space below the table.
| Revenue Projections | |||||||||||||
| Phase One - 5-10 Additional Small Format | Phase Two - 5-10 Additional Small Format | Phase Three - 5-10 Additional Small Format | Total | ||||||||||
| Gross Revenue | % to UU | Share to UU | Gross Revenue | % to UU | Share to UU | Gross Revenue | % to UU | Share to UU | Gross Revenue | Share to University | Overall % | ||
| EXAMPLE ENTRY | $ 5,000,000.00 | 50% | $ 2,500,000.00 | $ 2,000,000.00 | 60% | $ 1,200,000.00 | $ 1,000,000.00 | 35% | $ 350,000.00 | $ 8,000,000.00 | $ 4,050,000.00 | 51% | |
| INITIAL CONTRACT TERM | Year 1 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||||
| Year 2 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | ||||
| Year 3 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 4 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 5 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 6 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 7 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 8 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 9 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 10 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 11 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 12 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 13 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 14 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 15 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| 1ST FIVE YEAR EXTENSION | Year 16 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 17 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 18 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 19 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 20 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| 2ND FIVE YEAR EXTENSION | Year 21 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Year 22 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 23 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 24 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Year 25 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | 0% | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Total | $ - 0 | NA | $ - 0 | $ - 0 | NA | $ - 0 | $ - 0 | NA | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | |
| Notes: |
Assumption + Guaranty
| VENDOR | Enter Company Name |
| Per 4.01.3 and 5.03 of the RFP, Vendor acknowledges the provided list o f existing outdoor media assets and intent to assume operation, maintenance, and media sales of the assets. As these assets represent a prior investment by the University, Vendor shall indicate a proposed payment to University for assumption of these assets as described. | |
| TOTAL AMOUNT OF ASSUMPTION PAYMENT | |
| $ - 0 | |
| Please describe below if this assumption payment is to be made in a lump sum or over a period of time. If over a period of time, please describe proposed payment schedule. |
| Per 5.03, Vendor response shall include a proposed annual revenue sharing guaranty to University with consequences for failure to meet guaranty. | |
| ANNUAL REVENUE SHARE GUARANTY TO UNIVERSITY | |
| $ - 0 | |
| Please provide below any details about an annual revenue share guaranty for University consideration, including Vendor proposed consequences for failure to meet guaranty. |
Revenue - Potential Off-Campus
| VENDOR | Enter Company Name |
| Instructions: | For the purposes of this RFP Vendor shall provide an annual revenue projection and share to the University for each location. This revenue projection is not scored and is not accounted in the final evaluation. It is for informational purposes only. |
The list provided below is not intended to be final or conclusive for potential locations for off-campus large format installations. The University desires to understand the revenue potential for large format installations on University owned or operated buildings, however, these locations have not been fully vetted or confirmed.
Should the University decide to move forward with off-campus locations, the final location and design of these installations shall be confirmed by the University and Vendor post RFP award. Vendor may request input from the University on design and placement of such large format media installations during the Pre-Proposal conference.
Locations and notes for off-campus locations below are provided based off previous research by University.
Enter an annual revenue projections for potential off-campus location only in the GREEN cells. Specific addresses and notes for each of these potential locations is listed below. DO NOT ENTER DATA INTO YELLOW CELLS, THE FORMULAS IN THEM WILL CALCULATE AUTOMATICALLY. Place any questions or notes in the available space below the table. This tab does not feed into the Projected Revenue Master sheet as it is unscored.
| Potential Off-Campus Revenue Projections | |||||||||
| Gross Revenue | % to UU | Share to UU | |||||||
| LOCATION | ADDRESS | LOCATION NOTES | EXAMPLE ENTRY | $ 5,000,000.00 | 50% | $ 2,500,000.00 | |||
| POTENTIAL OFF-CAMPUS LOCATIONS | Sugarhouse Health Center | 1280 E. Stringham Ave. | |||||||
| SLC, UT 84106 | Sign would likely need to be incorporated with building, ideally facing towards 1300 E. and I-80. | $ - 0 | 0% | $ - 0 | |||||
| U of U Herriman Campus | 14551 Sentinel Ridge Blvd. | ||||||||
| Herriman, UT 84065 | Signe would ideally be located close to Moun tain View Corridor. | $ - 0 | 0% | $ - 0 | |||||
| South Jordan Health Center | 5216 W. Daybreak Parkway | ||||||||
| South Jordan, UT 84009 | Sign would ideally be located close to Mountain View Corridor. | $ - 0 | 0% | $ - 0 | |||||
| Redwood Health Center | 1525 W. 2100 S. | ||||||||
| SLC, UT 84119 | Sign would likely need to be incorporated with building, ideally facing towards SR 201. | $ - 0 | 0% | $ - 0 | |||||
| Parkway Health Center | 145 W. 1300 S. | ||||||||
| Orem, UT 84058 | Sign would ideally be located to face University Parkway. | $ - 0 | 0% | $ - 0 | |||||
| Midvalley Health Center | 243 E. 6100 S. | ||||||||
| Murray, UT 84107 | Sign would ideally be located close to State Street. | $ - 0 | 0% | $ - 0 | |||||
| Farmington Health Center | 165 N University Ave. | ||||||||
| Farmington, UT 84025 | Sign would ideally be located to be seen from I-15. | $ - 0 | 0% | $ - 0 | |||||
| City Centre Campus | Corner of 200 E. and 400 S. Salt Lake City. | Sign would be on corner above parking garage entrance. | $ - 0 | 0% | $ - 0 | ||||
| West Valley Hospital | 3784 S. 5600 W. | ||||||||
| West Valley City | Sign would ideally be located to face major roadways like Mtn View Corridor and 5600 W. | $ - 0 | 0% | $ - 0 | |||||
| Total | $ - 0 | NA | $ - 0 | ||||||
| Notes: |
File details come from the government source that posted it. Updated .