Editing Openai/69719895-3714-8012-94ef-2b4dc24788de (section)

=== Assistant: Love the structure you’ve laid out—this is a serious, lender- and investor-grade annual report. ===
Love the structure you’ve laid out—this is a serious, lender- and investor-grade annual report. 👍
Right now, the limiting factor is data availability. To do this correctly (and per your own rules), I need to collect inputs first rather than estimate or infer.

Below is a clean intake checklist so we can move fast and produce a polished Calendar Year 2025 report in one pass.

==== Step 1: Upload Required Reports (2025) ====

Please upload all five reports for Calendar Year 2025 (CSV, Excel, or PDF is fine—Stessa exports preferred):
# Net Cash Flow Report (2025)
# Income Statement (2025, portfolio-level)
# Rent Roll (as of 12/31/2025)
# Schedule of Real Estate Owned (as of 12/31/2025)
# Maintenance Logs (2025)

These will fully support:
* NOI, cash flow, DSCR
* Income & expense categorization
* Capital vs operating expense separation
* Maintenance trend analysis

==== Step 2: Per-Property Inputs (Required by Your Rules) ====

These cannot be derived from the uploaded reports and must be provided explicitly.

===== A. Gross Rent Multiplier (GRM) =====

For each property, please provide:
* Annual Gross Scheduled Income (Market Rent, not actuals)

Format suggestion:

<syntaxhighlight>Property Address | Units | Monthly Market Rent per Unit | Annual Scheduled Income

</syntaxhighlight>

===== B. Capitalization Rate (Cap Rate) =====

For each property, please provide:
* Net Operating Income (NOI) by property (2025) > This should exclude debt service and capital expenses.

Format suggestion:

<syntaxhighlight>Property Address | 2025 Property-Level NOI

</syntaxhighlight>

===== C. Property Valuations & Debt (for Net Worth & Equity) =====

For each property, please provide:
* Estimated Market Value (12/31/2025)
* Outstanding Mortgage Balance (12/31/2025)

Format suggestion:

<syntaxhighlight>Property Address | Market Value | Mortgage Balance

</syntaxhighlight>

===== D. Vacancy Assumption (Portfolio-Level) =====

Provide one vacancy percentage for 2025:

<syntaxhighlight>Portfolio Vacancy Rate (% of unit-months unoccupied)

</syntaxhighlight>

This will be used for:
* Vacancy Rate
* Vacancy & Credit Loss ($)
* Gross Operating Income

==== Step 3: Prior-Year Comparison Data (2024) ====

To complete Section 10: Year-Over-Year Analysis, please also upload:
* Income Statement (2024)
* Net Cash Flow Report (2024)

(Portfolio-level only is sufficient.)

==== Step 4: Market & Economic Context (Optional Confirmation) ====

If you’d like me to proceed automatically, I will use public, widely cited sources for:
* U.S. national trends
* Ohio state trends
* Columbus MSA trends

If you prefer specific sources (e.g., Yardi Matrix, CoStar, Census, Fed), tell me now.

==== What Happens Next ====

Once the above is provided, I will:

✔ Build the full 12-section Annual Financial Report exactly as specified
✔ Show every calculation with formulas and inputs, Word-ready
✔ Use Stessa category alignment throughout
✔ Clearly flag any excluded metrics due to missing data
✔ Deliver something suitable for:
* Lenders
* Partners
* Your own multi-year benchmarking

When you’re ready, start by uploading the five 2025 reports, and we’ll roll straight into Section 1 → Section 12 without backtracking.