Attachment_P-FinancialSubmissionWorkbook-Final.xlsx
XLSX spreadsheet 99 KB Posted
- Solicitation number
- 25-P-00399
- Issued by
- Hillsborough County, Florida
About this file
The document is a Financial Submission Workbook for the City of Tampa's Redevelopment of the Royal Street Parking Lot and Army/Navy Store Site, located in the Downtown Community Redevelopment Area. The workbook provides detailed financial templates for a potential development project, including a Development Program Summary, Development Cost Pro Forma, Stabilized Operating Pro Forma, and a 15-Year Operating Pro Forma. The templates are designed for potential developers to outline projected residential, commercial, and other space allocations, along with comprehensive financial projections across multiple years and funding categories.
The financial workbook shows zero values across all sections, indicating it is a template for prospective developers to complete with their specific project details. The document includes sections for various funding sources such as construction financing, permanent financing, construction loans, developer equity, LIHTC equity, and potential state tax credit equity. The pro forma templates cover revenue streams, expense categories, operating income, debt service, and cash flow projections, with provisions for different housing types including market-rate, affordable at 80% AMI, and 140% AMI levels. The financial model is set up to project financial performance through 2043, with the ability to input escalation rates and detailed revenue and expense categories.
View the file
Other files
Show all 18
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 .