← 9919 S Oglesby Ave, Chicago, IL 60617 · All properties

FINANCIALS.backup-20260712-050405.md

This page is a searchable text preview. Use the Dropbox link for the full original file.

Open full file in Dropbox

What This File Appears To Be

Financial Data **Last Updated:** 2026-04-13 **Source:** Lofty PM Data Entry + Cash Flow Statement ## Investment Summary · Field · Value · · ------- · ------- · · Total Investment · $184,343.22 · · Sale Price · $158,000 · · Monthly Rent · $1,800 (projected) · ## Income · Field · Value · · ------- · ------- · · Monthly Gross Rent · $1,800 (projected) · ## Insurance - **Annual Premium:** $1,337.70 ## Property Management - **PM Fee Rate:** 10.0% of gross rents - **DAO LLC Fee:** $750.00/year ## Annual Exp

Text Preview

# Financial Data

**Last Updated:** 2026-04-13
**Source:** Lofty PM Data Entry + Cash Flow Statement

## Investment Summary
| Field | Value |
|-------|-------|
| Total Investment | $184,343.22 |
| Sale Price | $158,000 |
| Monthly Rent | $1,800 (projected) |

## Income
| Field | Value |
|-------|-------|
| Monthly Gross Rent | $1,800 (projected) |

## Insurance

- **Annual Premium:** $1,337.70



## Property Management

- **PM Fee Rate:** 10.0% of gross rents
- **DAO LLC Fee:** $750.00/year

## Annual Expenses
| Field | Value | Source |
|-------|-------|--------|
| Property Taxes | $1,253.80 | Lofty PM Data Entry |
| Homeowners Insurance | $1,337.70 (2025 term, cancelled) | Obie — Cancelled |
| Property Management | ~15% gross | ECO Systems |
| Utilities | $0| |
| Utilities Water/Sewer | $763.42|
| **Total Annual OpEx** | **~$2,900** | |

## DAO Cash Balances (Yhome Transition Reconciliation)
| Field | Value |
|-------|-------|
| **ECO Operating Cash** | $464.27 |
| **DAO Net Cash (Capital Call)** | *(pending)* |
| **Status** | 🏁 **SOLD Feb 2026** — Property divested |

## Operating Reserve
| Field | Value | Source |
|-------|-------|--------|
| Current OR Balance | $3,259.93 | Lofty PM Data Entry |
| Current Maintenance Reserve | $-200.00 | LoftyAssist |
| OR Replenishment | Per policy | |

## T-12 Financials (from Cash Flow Statement)
Cash flow statement shows:
- Revenue: $1,800/mo base rent modeled
- Notable: $3,600 in owner distributions shown, $850 in one month
- Capital expenditure: $2,430 (large repair in one period)

## Current Month Distribution
| Field | Value |
|-------|-------|
| Distribution | **$0.00** |

> ⚠️ Property vacant. No rent being collected. No active lease.

## Calculated Metrics
| Field | Value |
|-------|-------|
| Cap Rate | 4.18% |
| IRR | 1.8% |
| Cash-on-Cash Return | 0% (vacant) |

---
*Updated 2026-04-04. Cash flow statement shows base rent model but property is vacant. Insurance cancelled in 2025. Taxes from Lofty PM Data Entry.*

<!-- AUTO:CF_PRIOR_MONTH_START -->

## Cash Flow Snapshot (2026-04)

**Source:** Cash Flow Statement, month `2026-04`
**Updated:** 2026-05-18

| Metric | Amount |
|---|---:|
| Revenue | $0.00 |
| Operating Expenses | $0.00 |
| NOI | $0.00 |
| Loan/CapEx/Retained Earnings | $0.00 |
| Net Operating Cashflow | $0.00 |
| Rents | $0.00 |
| Property Management Fee | $0.00 |
| Insurance | $0.00 |
| Taxes | $0.00 |
| Utilities | $0.00 |
| Repairs / Maintenance | $0.00 |
| Operating Reserve Balance | $0.00 |
| ECO Cash Balance | $0.00 |
| Mortgage Principal Balance | $0.00 |
| Estimated NAV | $0.00 |

`source_workbook: Public/07 - P&L & Owner Statements/Cash Flow Statement - 9919 S Oglesby Ave Chicago IL, 60617.xlsx`
<!-- AUTO:CF_PRIOR_MONTH_END -->

## Monthly Cash Position (2026-06)

| Metric | Amount | Source |
|---|---:|---|
| Lofty Operating Cash | -$200.00 | Lofty `curr_maintenance_reserve` |
| ECO Operating Cash | $1,676.64 | ECO Systems General Ledger Column E (103 rows) |