Attachment_P-FinancialSubmissionWorkbook-Final.xlsx

This is a Financial Submission Workbook for the City of Tampa's Request for Proposals regarding the redevelopment of the Royal Street Parking Lot and Army/Navy Store site in the Downtown Community Redevelopment Area. The workbook serves as a template for applicants to submit detailed financial information related to their proposed development projects. The document contains four primary financial analysis sections: a Development Program Summary that captures proposed building square footage and unit counts across residential, commercial, retail, open space, and parking categories; a Development Cost Pro Forma that itemizes all hard costs (land acquisition, construction, site work, and public realm improvements), soft costs (architectural, engineering, legal, financing fees, and developer costs), and financing costs; a Stabilized Operating Pro Forma that projects annual revenues and operating expenses for the developed property; and a 15-Year Operating Pro Forma that forecasts financial performance across all revenue categories, expenses, net operating income, debt service, and equity cash flow. The template includes detailed line items for various housing affordability levels including units restricted to 80% AMI and 140% AMI, as well as market-rate and homeownership components.

The workbook provides a comprehensive framework for applicants to demonstrate project feasibility and financing viability through detailed cost accounting and revenue projections. All financial entries in the submitted template show zero values, indicating this is a blank template awaiting completion by proposers. The document is designed to accommodate mixed-use development with multiple revenue streams including residential rental income, commercial leasing, retail operations, and parking revenues. Applicants are required to detail construction financing sources including construction loans, developer equity, Low-Income Housing Tax Credits (LIHTC) at both 4% and 9% rates, state tax credits, and other financing mechanisms. The pro formas require annual escalation rates for revenues and expenses, calculation of debt service coverage ratios, and tracking of cash flow to both developers and investors over the 15-year analysis period. All financial projections are to be presented in 2025 dollars, establishing a consistent baseline for comparing proposals across applicants.