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 ItemTab / Worksheet NameCell Reference / Range
(or Page/Section #)Notes (optional)
1. Complete Development Budget
1Hard costs
2Soft costs
3Land acquisition costs
2. Sources and Uses of Funds
4Debt financing source(s)
5Equity financing source(s)
6Grants / incentives / other sources
7Uses of funds (total development cost allocation)
3. Stabilized Operating Pro Forma
8Revenue (gross / effective)
9Operating expenses
10Net operating income (NOI)
4. Investment Returns Analysis
11IRR
12Cash-on-cash return
13Yield on cost
5. Development and Stabilization Timeline
14Predevelopment / entitlement milestones
15Construction completion
16Lease-up / stabilization
6. Sensitivity Analysis
17Interest rate sensitivity
18Construction cost sensitivity
19Absorption / lease-up sensitivity
20Rent / revenue sensitivity
Ex.Hard costs (example — delete before submitting)Development BudgetB10:B24Includes 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 .