Attachment_P-FinancialSubmissionWorkbook-Final.xlsx
XLSX spreadsheet 99 KB Posted
- Solicitation number
- 25-P-00399
- Issued by
- Hillsborough County, Florida
About this file
This is a financial submission workbook for the City of Tampa's Request for Proposals (RFP) for the redevelopment of the Royal Street Parking Lot and Army/Navy Store site located in the Downtown Community Redevelopment Area. The workbook serves as a template for applicants to submit detailed financial information regarding their proposed development project. The submission deadline is December 12, 2025, with a mandatory pre-proposal conference scheduled for November 17, 2025. The RFP requires developers to create a high-density, mixed-use transit-oriented development featuring a minimum of 800 total dwelling units, including at least 30% affordable housing for households earning up to 80% of Area Median Income (AMI), an additional 20% workforce housing for households earning between 80% and 140% AMI, and 28 conservatory housing units for cultural arts professionals. The project must also include a minimum of 15,000 square feet of non-residential space comprising retail, commercial, and open space components, along with parking facilities.
The financial submission workbook contains four primary pro forma templates: a Development Program Summary, a Development Cost Pro Forma, a Stabilized Operating Pro Forma, and a 15-Year Operating Pro Forma. All financial inputs are presented in 2025 dollars. The Development Cost Pro Forma requires applicants to itemize all project costs including land acquisition, hard costs (construction, site work, public realm improvements), soft costs (architecture, engineering, legal, financing fees, developer fees), and finance costs. The workbook requests detailed sources of funds including construction financing, developer equity, Low-Income Housing Tax Credits (LIHTC), state tax credits, permanent financing, and condo sales revenue. The Stabilized Operating Pro Forma and 15-Year Operating Pro Forma require applicants to project revenue streams from residential leasing, commercial leasing, retail leasing, and parking operations, along with detailed operating expense projections for maintenance, real estate taxes, insurance, utilities, management fees, and administrative expenses. The workbook calculates debt service coverage ratios and equity cash flows for both developer and investor returns over the 15-year projection period.
View the file
Other files
Show all 19
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
1-Development Program Summary
| Royal Street Parking Lot and Army/Navy Store Redevelopment RFP |
| Development Program Summary |
| Applicant Name: |
| Program Component | GSF or Spaces | RSF or Spaces | Floor Location/Description |
| Residential Space - Rental | 0 | 0 | |
| Residential Space - Homeownership | 0 | 0 | |
| Retail Space | 0 | 0 | |
| Commercial Space | 0 | 0 | |
| Open Space | 0 | 0 | |
| Other Space (specify type in description) | 0 | 0 | |
| Parking | 0 | 0 | |
| Total SF | 0 | 0 |
| Rental Housing Detail | Studio | 1 BR | 2 BR | 3 BR | 4 BR | Totals |
| Up to 80% AMI | ||||||
| Rent | 0 | 0 | 0 | 0 | 0 | 0 |
| Units | 0 | 0 | 0 | 0 | 0 | 0 |
| Up to 140% AMI | ||||||
| Rent | 0 | 0 | 0 | 0 | 0 | 0 |
| Units | 0 | 0 | 0 | 0 | 0 | 0 |
| Market (Unrestricted) | ||||||
| Rent | 0 | 0 | 0 | 0 | 0 | 0 |
| Units | 0 | 0 | 0 | 0 | 0 | 0 |
Total Units 0
| Homeownership Detail (if applicable) | Studio | 1 BR | 2 BR | 3 BR | 4 BR | Totals |
| Up to 80% AMI | ||||||
| Sales Price | 0 | 0 | 0 | 0 | 0 | 0 |
| Units | 0 | 0 | 0 | 0 | 0 | 0 |
| Up to 140% AMI | ||||||
| Sales Price | 0 | 0 | 0 | 0 | 0 | 0 |
| Units | 0 | 0 | 0 | 0 | 0 | 0 |
| Market (Unrestricted) | ||||||
| Sales Price | 0 | 0 | 0 | 0 | 0 | 0 |
| Units | 0 | 0 | 0 | 0 | 0 | 0 |
Total Units 0
24 Dry Dock Financial Submissions Appendix - &A Page &P of
2-Development Cost Pro Forma
| Royal Street Parking Lot and Army/Navy Store Redevelopment RFP |
| Development Cost Pro Forma |
| Applicant Name: |
| Rental Housing - Market | Rental Housing - Up to 80% AMI | Rental Housing - Up to 140% AMI | Homeownership - Market | Homeownership - Up to 80% AMI | Homeownership - Up to 140% AMI | Commercial | Retail | Open Space | Parking | Other | Total | Residential Per Unit | Comments | |
| Uses of Funds |
| Land Cost | |||||||||||||
| Acquisition Cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Land Closing Costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Hard Cost | |||||||||||||
| Construction | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Site Work | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Public Realm - Onsite | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Public Realm - Offsite | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Hard Cost Escalation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Hard Cost Contingency | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Tenant Improvements | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Hard Cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Per GSF | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Soft Cost | |||||||||||||
| Architecture & Engineering | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Administrative | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Survey and Permits | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Environmental Engineer | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Legal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Title and Recording | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Accounting and Cost Certification | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Marketing and Rent Up | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Real Estate Taxes | $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 |
| Relocation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Appraisal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Security | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Acquisition Loan Interest | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Inspecting Engineer | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Bridge Loan Interest | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Pre Development loan interest | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Mortgage Insurance Premium (MIP) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Credit Enhancement Fees | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Letter of Credit Fees | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other Financing Fees: | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Development Consultant | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Developer Fee | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Developer Overhead | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Soft Cost Contingency $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
| Total Soft Cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| % of Hard Costs | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Finance Cost | |||||||||||||
| Construction Interest | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Debt Placement/Closing Costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Equity Placement/Closing Costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Development Cost (TDC) $0 $0
Sources of Funds
| Construction Financing | |||||||||||||
| Construction Loan | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Developer Equity | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Deferred Developer Fee | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| LIHTC Equity (4% or 9%) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| State Tax Credit Equity | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Permanent Financing | |||||||||||||
| Condo Sales Revenue | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Permanent Loan | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Deferred Developer Fee | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| LIHTC Equity (4% or 9%) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Notes:
24 Dry Dock Financial Submissions Appendix - &A Page &P of
3-Stab. Operating Pro Forma
| Royal Street Parking Lot and Army/Navy Store Redevelopment RFP | |
| Stabilized Operating Pro Forma | (All Inputs in 2025 Dollars) |
| Applicant Name: |
| Rental Housing - Market | Rental Housing - Affordable | Commercial | Retail | Open Space | Parking | Other | Annual Total | |
| Revenue | ||||||||
| Gross Lease Income | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Vacancy Rate | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |
| Vacancy | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Effective Gross Income | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other Revenue | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Revenue | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Effective Gross Income (EGI) $0
| Expenses | ||||||||
| Maintenance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| RE Taxes | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Insurance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Utilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other Op Ex | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Management Fee | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Administrative Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Annual Reserves $0
Total Operating Expenses $0
Stabilized Net Operating Income $0
Notes:
24 Dry Dock Financial Submissions Appendix - &A Page &P of
4-15yr Operating Pro Forma
| Royal Street Parking Lot and Army/Navy Store Redevelopment RFP |
| 15-Year Operating Pro Forma |
| Applicant Name |
| Lease Year/Fiscal Year | Annual | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| Revenue Category | Escalation | Dec-29 | Dec-30 | Dec-31 | Dec-32 | Dec-33 | Dec-34 | Dec-35 | Dec-36 | Dec-37 | Dec-38 | Dec-39 | Dec-40 | Dec-41 | Dec-42 | Dec-43 |
| Rental Revenue | ||||||||||||||||
| Gross Lease Income - Residential | 0.00% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Gross Lease Income - Commercial | 0.00% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Gross Lease Income - Retail | 0.00% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Gross Lease Income - Parking | 0.00% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Vacancy | 0.00% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other Revenue | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Revenue | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Effective Gross Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
| Expenses | |||||||||||||||
| Maintenance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| RE Taxes | $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 |
| Utilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other Op Ex | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Management Fee | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Administrative Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Annual Reserves $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Operating Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
| Debt Service | |||||||||||||||
| 1st Mortgage | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Debt Service | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Debt Service Coverage Ratio NOI/DS ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
| Equity CF | |||||||||||||||
| Developer | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Investor | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Equity CF | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Notes:
24 Dry Dock Financial Submissions Appendix - &A Page &P of
File details come from the government source that posted it. Updated .