Trailing Twelve Month Operating Review — Actual vs. Budget — Forward Projections
440 Units | T12: Jan – Dec 2025 | As of December 31, 2025
| Month | Net Rental Income | Other Income | Total Income | Total OpEx | NOI | NOI Margin |
|---|
| Line Item | T12 Total | Per Unit / Yr | % of GPR |
|---|---|---|---|
| INCOME | |||
| Market / Gross Potential Rent | $8,634,499 | $19,624 | 100.0% |
| Loss / Gain to Lease | $143,031 | $325 | 1.7% |
| Vacancy | ($548,067) | ($1,246) | (6.3%) |
| Management Office / Model | ($6,070) | ($14) | (0.1%) |
| Staff Units | ($15,615) | ($35) | (0.2%) |
| Concessions | ($32,600) | ($74) | (0.4%) |
| Net Rental Income | $8,175,178 | $18,580 | 94.7% |
| Other Income (all categories) | $1,561,170 | $3,548 | 18.1% |
| Bad Debt — Net Recovery | $50,773 | $115 | 0.6% |
| Effective Gross Income (EGI) | $9,787,122 | $22,243 | 113.4% |
| OPERATING EXPENSES | |||
| Renting Expense | $89,395 | $203 | 1.0% |
| Administrative Costs | $122,117 | $278 | 1.4% |
| Management Fees (3.3% of NRI) | $269,310 | $612 | 3.1% |
| Salaries & Benefits | $671,031 | $1,525 | 7.8% |
| Contract Repairs & Maintenance | $287,254 | $653 | 3.3% |
| Maintenance & Repair Supplies | $62,913 | $143 | 0.7% |
| Total Variable Expense | $1,502,021 | $3,414 | 17.4% |
| Utilities (water, sewer, electric, trash) | $705,378 | $1,603 | 8.2% |
| Real Estate & Property Taxes | $804,682 | $1,829 | 9.3% |
| Insurance (liability, property, umbrella) | $160,742 | $365 | 1.9% |
| Total Fixed Expense | $1,670,802 | $3,797 | 19.4% |
| Total Operating Expenses | $3,172,823 | $7,211 | 36.7% |
| Net Operating Income (NOI) | $6,614,298 | $15,032 | 76.6% |
| Line Item | Actual | Budget | Variance $ | Var % |
|---|---|---|---|---|
| INCOME | ||||
| Net Rental Income | $683,671 | $695,999 | ($12,328) | -1.8% |
| Other Income | $122,487 | $120,528 | $1,959 | +1.6% |
| Bad Debt — Net | ($3,161) | ($3,195) | $34 | +1.1% |
| Total Income | $802,997 | $813,332 | ($10,335) | -1.3% |
| EXPENSES | ||||
| Renting | $7,109 | $5,135 | ($1,974) | -38.4% |
| Administrative | $8,666 | $11,903 | $3,237 | +27.2% |
| Management Fees | $22,704 | $20,333 | ($2,371) | -11.7% |
| Salaries & Benefits | $66,967 | $73,124 | $6,157 | +8.4% |
| Contract Repairs | $18,899 | $13,735 | ($5,164) | -37.6% |
| Maint. Supplies | $3,451 | $5,415 | $1,964 | +36.3% |
| Variable Total | $127,794 | $129,645 | $1,851 | +1.4% |
| Utilities | $70,213 | $74,872 | $4,659 | +6.2% |
| Taxes | $69,055 | $65,743 | ($3,312) | -5.0% |
| Total OpEx | $279,501 | $270,260 | ($9,241) | -3.4% |
| NOI | $523,497 | $543,072 | ($19,575) | -3.6% |
| Line Item | Actual | Budget | Variance $ | Var % |
|---|---|---|---|---|
| INCOME | ||||
| Net Rental Income | $8,175,178 | $8,229,490 | ($54,312) | -0.7% |
| Other Income | $1,561,170 | $1,376,873 | $184,297 | +13.4% |
| Bad Debt — Net | $50,773 | $27,885 | $22,888 | +82.1% |
| Total Income | $9,787,122 | $9,634,248 | $152,874 | +1.6% |
| EXPENSES | ||||
| Renting | $89,395 | $63,224 | ($26,171) | -41.4% |
| Administrative | $122,117 | $128,750 | $6,633 | +5.2% |
| Management Fees | $269,310 | $240,857 | ($28,453) | -11.8% |
| Salaries & Benefits | $671,031 | $700,818 | $29,787 | +4.3% |
| Contract Repairs | $287,254 | $236,409 | ($50,845) | -21.5% |
| Maint. Supplies | $62,913 | $73,880 | $10,967 | +14.8% |
| Variable Total | $1,502,021 | $1,443,938 | ($58,083) | -4.0% |
| Utilities | $705,378 | $753,104 | $47,726 | +6.3% |
| Taxes | $804,682 | $788,916 | ($15,766) | -2.0% |
| Total OpEx | $3,172,823 | $3,146,700 | ($26,123) | -0.8% |
| NOI | $6,614,298 | $6,487,548 | $126,750 | +2.0% |
Green = under budget (favorable) · Red = over budget (unfavorable) · Income: favorable = above budget
| Account | Balance |
|---|---|
| ASSETS | |
| Current Assets | |
| Cash — Operating | $279,730 |
| Security Deposit Escrow | $189,737 |
| Capital Reserve — Internal | $829,914 |
| Accounts Receivable — Tenants | $79,805 |
| Accounts Receivable — Other | $25,478 |
| Allowance for Doubtful Accounts | ($10,204) |
| Replacement Reserve (Lender) | $24,903 |
| Escrow — Real Estate Tax (Lender) | $172,929 |
| Escrow — Insurance (Lender) | $172,680 |
| Prepaid Insurance & Deposits | $7,764 |
| Total Current Assets | $1,773,640 |
| Non-Current Assets | |
| Real Property Investment | $90,000,000 |
| Capital Improvements | $3,803,894 |
| Property Improvements | $825,870 |
| Legal & Acquisition Costs (net) | $3,375,085 |
| Accumulated Depreciation & Amortization | ($21,185,850) |
| Financing Fees (net) | $210,576 |
| Total Non-Current Assets | $77,220,985 |
| TOTAL ASSETS | $78,994,625 |
| LIABILITIES | |
| Current Liabilities | |
| Prepaid Tenant Rents | $13,880 |
| Accrued Interest Payable | $170,980 |
| Accounts Payable | $157,329 |
| Accrued Expenses | $81,659 |
| Total Current Liabilities | $423,848 |
| Long-Term Liabilities | |
| Tenant Security Deposits | $188,905 |
| 1st Mortgage Payable | $47,615,511 |
| 2nd Mortgage Payable | $15,111,142 |
| Total Other Liabilities | $62,915,558 |
| TOTAL LIABILITIES | $63,339,407 |
| CAPITAL | |
| Capital — MLG Runaway Bay | $30,888,000 |
| Capital — K2 Runaway Bay | $3,432,000 |
| Partner Distributions | ($12,539,821) |
| Retained Earnings | ($6,124,960) |
| TOTAL CAPITAL | $15,655,219 |
| TOTAL LIABILITIES & CAPITAL | $78,994,625 |
| Line Item | T12 Actual | Year 1 (2026) | Y1 Δ | Year 2 (2027) | Y2 Δ | Year 3 (2028) | Y3 Δ vs T12 |
|---|---|---|---|---|---|---|---|
| INCOME | |||||||
| Gross Potential Rent | $8,634,499 | $8,893,534 | +3.0% | $9,160,340 | +3.0% | $9,435,150 | +9.3% |
| Net Rental Income | $8,175,178 | $8,406,613 | +2.8% | $8,686,155 | +3.3% | $8,965,516 | +9.7% |
| Other Income | $1,561,170 | $1,592,393 | +2.0% | $1,624,241 | +2.0% | $1,656,726 | +6.1% |
| Effective Gross Income | $9,787,122 | $10,049,779 | +2.7% | $10,361,158 | +3.1% | $10,673,013 | +9.1% |
| EXPENSES | |||||||
| Total Operating Expenses | $3,172,823 | $3,268,008 | +3.0% | $3,366,048 | +3.0% | $3,467,030 | +9.3% |
| NET OPERATING INCOME | |||||||
| Net Operating Income | $6,614,298 | $6,730,998 | +1.8% | $6,944,348 | +3.2% | $7,155,212 | +8.2% |
| NOI Margin | 67.6% | 67.0% | — | 67.0% | — | 67.1% | — |
| NOI / Unit / Yr | $15,032 | $15,298 | +$266 | $15,783 | +$485 | $16,262 | +$1,230 |
| Exit Cap | Exit Value | Exit Equity | Value Creation | % Gain |
|---|
Below-NOI capital spend on property upkeep, unit turns, and replacement items. All amounts positive = cash outflow.
| GL | Description | Dec 2025 | Q4 2025 | H2 2025 | YTD / T12 | Mo. Avg | $/Unit/Yr |
|---|
Structural improvements, major system replacements, and unit upgrade program. Largest line: Upgrade Units ($360K YTD).
| GL | Description | Dec 2025 | Q4 2025 | H2 2025 | YTD / T12 | Mo. Avg | $/Unit/Yr |
|---|
| Category | Dec 2025 | Q4 2025 | H2 2025 | YTD / T12 | Mo. Avg | $/Unit/Yr | |
|---|---|---|---|---|---|---|---|
1st Mortgage (Lument, $47.6M) + 2nd Mortgage ($15.1M). See Balance Sheet tab for loan terms.
| GL | Description | Dec 2025 | Q4 2025 | YTD / T12 | Mo. Avg | % of NOI |
|---|
Owner-level fees separate from property management (included in OpEx above NOI).
| GL | Description | Dec 2025 | Q4 2025 | YTD / T12 | Mo. Avg | % of NOI |
|---|
Cash distributions to equity partners. Amounts shown as outflows (negative).
| GL | Description | Dec 2025 | Q4 2025 | YTD / T12 | Mo. Avg | % of NOI |
|---|
Full cash flow from NOI through partner distributions per the GL statement.
| Line Item | T12 Amount |
|---|
| Unit Type | Current Rent | 4-Wk Avg | Chg | Avg Mkt | Avg In-Place |
|---|
| Week | Phys Occ | Leased | Vacant | Move In | Move Out | Notice | Leads | Shows | Apps | 30+ Delinq | 1BR-A | 1BR-B | 2BR-A |
|---|
Upload weekly rent rolls, MMR summaries, and variance reports. PDF, XLSX accepted.
Upload monthly P&Ls, financials, and investor packages.
Pull report attachments from your dedicated reports inbox.