Attachment_P-FinancialSubmissionWorkbook-Final.xlsx

XLSX spreadsheet 99 KB Posted

Attached to
Redevelopment of the Royal Street Parking Lot and Army/Navy Store Site in the Downtown Community Redevelopment Area (RE-BID)
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 ComponentGSF or SpacesRSF or SpacesFloor Location/Description
Residential Space - Rental00
Residential Space - Homeownership00
Retail Space00
Commercial Space00
Open Space00
Other Space (specify type in description)00
Parking00
Total SF00
Rental Housing DetailStudio1 BR2 BR3 BR4 BRTotals
Up to 80% AMI
Rent000000
Units000000
Up to 140% AMI
Rent000000
Units000000
Market (Unrestricted)
Rent000000
Units000000

Total Units 0

Homeownership Detail (if applicable)Studio1 BR2 BR3 BR4 BRTotals
Up to 80% AMI
Sales Price000000
Units000000
Up to 140% AMI
Sales Price000000
Units000000
Market (Unrestricted)
Sales Price000000
Units000000

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 - MarketRental Housing - Up to 80% AMIRental Housing - Up to 140% AMIHomeownership - MarketHomeownership - Up to 80% AMIHomeownership - Up to 140% AMICommercialRetailOpen SpaceParkingOtherTotalResidential Per UnitComments
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 GSFERROR:#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 CostsERROR:#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 - MarketRental Housing - AffordableCommercialRetailOpen SpaceParkingOtherAnnual Total
Revenue
Gross Lease Income$0$0$0$0$0$0$0$0
Vacancy Rate0%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 YearAnnual123456789101112131415
Revenue CategoryEscalationDec-29Dec-30Dec-31Dec-32Dec-33Dec-34Dec-35Dec-36Dec-37Dec-38Dec-39Dec-40Dec-41Dec-42Dec-43
Rental Revenue
Gross Lease Income - Residential0.00%$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Gross Lease Income - Commercial0.00%$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Gross Lease Income - Retail0.00%$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Gross Lease Income - Parking0.00%$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Vacancy0.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 .