2-Attachment E - Financial Pro Forma Instructions.xlsx
XLSX spreadsheet 11 KB Posted
- Attached to
- Murray City RDA Old City Hall Redevelopment
- Solicitation number
- 26-32
- Issued by
- Salt Lake County, Utah
About this file
This is a Financial Pro Forma Instructions document prepared for the Redevelopment Agency of Murray City, Utah, in connection with the Old City Hall Redevelopment project located at 5025 South State Street in Murray. The RDA is soliciting proposals from qualified developers for redevelopment of approximately 5.98 acres as a privately owned mixed-use development with meaningful commercial activity along State Street to support economic redevelopment objectives within Murray's City Center. The solicitation is qualifications and concept-based, with the selected proposer to be invited into negotiations toward redevelopment and disposition agreements subject to RDA Board approval.
Respondents must submit a Development Pro Forma with a cover sheet that serves as a data point locator, identifying the exact location of required financial information within their submitted model. Required submissions include a complete development budget (hard costs, soft costs, and land acquisition costs), sources and uses of funds (debt financing, equity financing, grants and incentives), a stabilized operating pro forma (revenue, operating expenses, and net operating income), investment returns analysis (IRR, cash-on-cash return, and yield on cost), a development and stabilization timeline (predevelopment milestones, construction completion, and lease-up/stabilization), and sensitivity analyses for interest rates, construction costs, absorption/lease-up, and rent/revenue scenarios. Respondents must certify that referenced locations in their pro forma accurately correspond to the required data points and submit the cover sheet as the first page of their Development Pro Forma Instructions.
View the file
Other files
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
Cover Sheet
| DEVELOPMENT PRO FORMA — DATA POINT LOCATOR (COVER SHEET) |
| To be completed by Respondent and submitted as the first page of the Development Pro Forma |
| Instructions |
| For each line item below, identify exactly where it appears in your submitted pro forma model. Provide the tab/worksheet name and the specific cell reference or range (e.g., 'Sources & Uses' tab, cell B22), or the page/section number if submitting a non-Excel format. This cover sheet does not replace the underlying analysis — it is a navigation aid to help reviewers efficiently locate and verify each required item. |
| Respondent Information |
| Respondent / Firm Name: |
| Pro Forma File Name(s): |
| Date Submitted: |
| Required Data Points | |||||
| No. | Line Item | Tab / Worksheet Name | Cell Reference / Range | ||
| (or Page/Section #) | Notes (optional) | ||||
| 1. Complete Development Budget | |||||
| 1 | Hard costs | ||||
| 2 | Soft costs | ||||
| 3 | Land acquisition costs | ||||
| 2. Sources and Uses of Funds | |||||
| 4 | Debt financing source(s) | ||||
| 5 | Equity financing source(s) | ||||
| 6 | Grants / incentives / other sources | ||||
| 7 | Uses of funds (total development cost allocation) | ||||
| 3. Stabilized Operating Pro Forma | |||||
| 8 | Revenue (gross / effective) | ||||
| 9 | Operating expenses | ||||
| 10 | Net operating income (NOI) | ||||
| 4. Investment Returns Analysis | |||||
| 11 | IRR | ||||
| 12 | Cash-on-cash return | ||||
| 13 | Yield on cost | ||||
| 5. Development and Stabilization Timeline | |||||
| 14 | Predevelopment / entitlement milestones | ||||
| 15 | Construction completion | ||||
| 16 | Lease-up / stabilization | ||||
| 6. Sensitivity Analysis | |||||
| 17 | Interest rate sensitivity | ||||
| 18 | Construction cost sensitivity | ||||
| 19 | Absorption / lease-up sensitivity | ||||
| 20 | Rent / revenue sensitivity | ||||
| Ex. | Hard costs (example — delete before submitting) | Development Budget | B10:B24 | Includes contractor GC & contingency |
By submitting this cover sheet, the respondent certifies that the referenced locations accurately correspond to the required data points within the attached pro forma model.
Signature: Date:
File details come from the government source that posted it. Updated .