Calendar 2030, month by month
Net operating income by month · actual Feb to Dec, pro forma all year, axis not from zero
- Jan 2030Not reported$287,630
- Feb 2030$308,208$315,598($7,390)
- Mar 2030$308,208$315,598($7,390)
- Apr 2030$308,208$315,598($7,390)
- May 2030$318,140$315,598+$2,542
- Jun 2030$318,140$315,598+$2,542
- Jul 2030$318,140$315,598+$2,542
- Aug 2030$302,829$315,598($12,769)
- Sep 2030$302,829$315,598($12,769)
- Oct 2030$302,829$315,598($12,769)
- Nov 2030$318,257$315,598+$2,659
- Dec 2030$318,257$315,598+$2,659
- Calendar 2030 to dateFeb to Dec$3,424,047$3,471,579($47,532) (-1.4%)
- Full year 2030, forecastactual to date plus pro forma, deal months 36 to 47$3,711,677$3,759,209($47,532) (-1.3%)
| Month | Effective gross income | Operating expenses | Property tax | NOI, actual | NOI, pro forma | NOI variance | Details |
|---|---|---|---|---|---|---|---|
| Jan 2030 | Not reported | Not reported | Not reported | Not reported | $287,630 | ||
| Feb 2030 | $473,604 | $131,396 | $34,000 | $308,208 | $315,598 | ($7,390) | |
| Mar 2030 | $473,604 | $131,396 | $34,000 | $308,208 | $315,598 | ($7,390) | |
| Apr 2030 | $473,604 | $131,396 | $34,000 | $308,208 | $315,598 | ($7,390) | |
| May 2030 | $481,734 | $129,593 | $34,000 | $318,140 | $315,598 | +$2,542 | |
| Jun 2030 | $481,734 | $129,593 | $34,000 | $318,140 | $315,598 | +$2,542 | |
| Jul 2030 | $481,734 | $129,593 | $34,000 | $318,140 | $315,598 | +$2,542 | |
| Aug 2030 | $480,695 | $143,866 | $34,000 | $302,829 | $315,598 | ($12,769) | |
| Sep 2030 | $480,695 | $143,866 | $34,000 | $302,829 | $315,598 | ($12,769) | |
| Oct 2030 | $480,695 | $143,866 | $34,000 | $302,829 | $315,598 | ($12,769) | |
| Nov 2030 | $482,624 | $130,367 | $34,000 | $318,257 | $315,598 | +$2,659 | |
| Dec 2030 | $482,624 | $130,367 | $34,000 | $318,257 | $315,598 | +$2,659 | |
| Calendar 2030 to dateFeb to Dec | $5,273,345 | $1,475,298 | $374,000 | $3,424,047 | $3,471,579 | ($47,532) (-1.4%) | |
| Full year 2030, forecastactual to date plus pro forma, deal months 36 to 47 | $5,701,599 | $1,584,172 | $405,750 | $3,711,677 | $3,759,209 | ($47,532) (-1.3%) |
Jan 2030
Deal month 36, operating year 3, not reported
- Effective gross income
- Actualno actualPro forma$428,254
- Operating expenses
- Actualno actualPro forma$108,875
- Property tax
- Actualno actualPro forma$31,750
- Net operating income
- Actualno actualPro forma$287,630
Feb 2030
Deal month 37, operating year 4, reported
- Effective gross income
- Actual$473,604Pro forma$479,705Variance($6,101) (-1.3%)
- Operating expenses
- Actual$131,396Pro forma$130,107Variance+$1,289 (+1.0%)
- Property tax
- Actual$34,000Pro forma$34,000Variance$0 (0.0%)
- Net operating income
- Actual$308,208Pro forma$315,598Variance($7,390) (-2.3%)
Mar 2030
Deal month 38, operating year 4, reported
- Effective gross income
- Actual$473,604Pro forma$479,705Variance($6,101) (-1.3%)
- Operating expenses
- Actual$131,396Pro forma$130,107Variance+$1,289 (+1.0%)
- Property tax
- Actual$34,000Pro forma$34,000Variance$0 (0.0%)
- Net operating income
- Actual$308,208Pro forma$315,598Variance($7,390) (-2.3%)
Apr 2030
Deal month 39, operating year 4, reported
- Effective gross income
- Actual$473,604Pro forma$479,705Variance($6,101) (-1.3%)
- Operating expenses
- Actual$131,396Pro forma$130,107Variance+$1,289 (+1.0%)
- Property tax
- Actual$34,000Pro forma$34,000Variance$0 (0.0%)
- Net operating income
- Actual$308,208Pro forma$315,598Variance($7,390) (-2.3%)
May 2030
Deal month 40, operating year 4, reported
- Effective gross income
- Actual$481,734Pro forma$479,705Variance+$2,028 (+0.4%)
- Operating expenses
- Actual$129,593Pro forma$130,107Variance($514) (-0.4%)
- Property tax
- Actual$34,000Pro forma$34,000Variance$0 (0.0%)
- Net operating income
- Actual$318,140Pro forma$315,598Variance+$2,542 (+0.8%)
Jun 2030
Deal month 41, operating year 4, reported
- Effective gross income
- Actual$481,734Pro forma$479,705Variance+$2,028 (+0.4%)
- Operating expenses
- Actual$129,593Pro forma$130,107Variance($514) (-0.4%)
- Property tax
- Actual$34,000Pro forma$34,000Variance$0 (0.0%)
- Net operating income
- Actual$318,140Pro forma$315,598Variance+$2,542 (+0.8%)
Jul 2030
Deal month 42, operating year 4, reported
- Effective gross income
- Actual$481,734Pro forma$479,705Variance+$2,028 (+0.4%)
- Operating expenses
- Actual$129,593Pro forma$130,107Variance($514) (-0.4%)
- Property tax
- Actual$34,000Pro forma$34,000Variance$0 (0.0%)
- Net operating income
- Actual$318,140Pro forma$315,598Variance+$2,542 (+0.8%)
Aug 2030
Deal month 43, operating year 4, reported
- Effective gross income
- Actual$480,695Pro forma$479,705Variance+$989 (+0.2%)
- Operating expenses
- Actual$143,866Pro forma$130,107Variance+$13,758 (+10.6%)
- Property tax
- Actual$34,000Pro forma$34,000Variance$0 (0.0%)
- Net operating income
- Actual$302,829Pro forma$315,598Variance($12,769) (-4.0%)
Sep 2030
Deal month 44, operating year 4, reported
- Effective gross income
- Actual$480,695Pro forma$479,705Variance+$989 (+0.2%)
- Operating expenses
- Actual$143,866Pro forma$130,107Variance+$13,758 (+10.6%)
- Property tax
- Actual$34,000Pro forma$34,000Variance$0 (0.0%)
- Net operating income
- Actual$302,829Pro forma$315,598Variance($12,769) (-4.0%)
Oct 2030
Deal month 45, operating year 4, reported
- Effective gross income
- Actual$480,695Pro forma$479,705Variance+$989 (+0.2%)
- Operating expenses
- Actual$143,866Pro forma$130,107Variance+$13,758 (+10.6%)
- Property tax
- Actual$34,000Pro forma$34,000Variance$0 (0.0%)
- Net operating income
- Actual$302,829Pro forma$315,598Variance($12,769) (-4.0%)
Nov 2030
Deal month 46, operating year 4, reported
- Effective gross income
- Actual$482,624Pro forma$479,705Variance+$2,919 (+0.6%)
- Operating expenses
- Actual$130,367Pro forma$130,107Variance+$260 (+0.2%)
- Property tax
- Actual$34,000Pro forma$34,000Variance$0 (0.0%)
- Net operating income
- Actual$318,257Pro forma$315,598Variance+$2,659 (+0.8%)
Dec 2030
Deal month 47, operating year 4, reported
- Effective gross income
- Actual$482,624Pro forma$479,705Variance+$2,919 (+0.6%)
- Operating expenses
- Actual$130,367Pro forma$130,107Variance+$260 (+0.2%)
- Property tax
- Actual$34,000Pro forma$34,000Variance$0 (0.0%)
- Net operating income
- Actual$318,257Pro forma$315,598Variance+$2,659 (+0.8%)
Calendar 2030 to date
Feb to Dec, deal months 37 to 47
- Effective gross income
- Actual$5,273,345Pro forma$5,276,758Variance($3,413) (-0.1%)
- Operating expenses
- Actual$1,475,298Pro forma$1,431,179Variance+$44,119 (+3.1%)
- Property tax
- Actual$374,000Pro forma$374,000Variance$0 (0.0%)
- Net operating income
- Actual$3,424,047Pro forma$3,471,579Variance($47,532) (-1.4%)
Full year 2030, forecast
Pro forma for deal months 36 to 47. Operating year 4 (months 37 to 48), the year Cash flows and Summary show, is one month later: pro forma NOI $3,787,177
- Effective gross income
- Forecast$5,701,599Full year pro forma$5,705,012Variance($3,413) (-0.1%)
- Operating expenses
- Forecast$1,584,172Full year pro forma$1,540,053Variance+$44,119 (+2.9%)
- Property tax
- Forecast$405,750Full year pro forma$405,750Variance$0 (0.0%)
- Net operating income
- Forecast$3,711,677Full year pro forma$3,759,209Variance($47,532) (-1.3%)
How the months are derived and read
Reading the variance. Variance is actual less pro forma. Green is favorable and red unfavorable, set per line: for income and NOI, above plan is favorable; for operating expenses and property tax, under plan is favorable. A grey pill is on plan.
Where the months come from. The pro forma is the model's monthly series. The actuals are reported by quarter, so each month is derived from its quarter: income and operating expenses are spread across the quarter's months in proportion to the pro forma, and property tax posts level with any quarter's true-up in its last month. The quarters are reproduced to the cent.
Ties to the hub. The twelve derived months of operating year 4 (Feb 2030 to Jan 2031, months 37 to 48) sum to the four reported quarters: NOI $3,727,705 against a plan of $3,787,177, $59,473 behind plan.
As of month 48 (Jan 2031). 11 months are reported in calendar 2030, the year with the most reported months; the rest show the pro forma only. Sample data. The sponsor owns every figure; Apolis formats the record.
Construction loan, month 48 maturity, extensions, coverage
- Drawn balancethe permanent loan does not exist yet
- $33,922,221
- Initial maturity
- month 42
- Current maturity
- month 54
- Extension exercisedmonth 42, fee $84,806
- yes
- Coverage, trailing 3 monthsextension test 1.15x met; covenant 1.20x met; plan 1.60x
- 1.58x
- Next extensionfee $84,806; projected coverage 1.64x
- month 54
Operating year 4 to date every figure and the next report
- Occupancyplan 94.6%, four quarters averaged
- 94.5%
- Net operating incomeplan $3,787,177 for the year
- $3,727,705
- Cash to equityplan $1,313,177; costs on plan
- $1,253,705
- Replacement reserve funded
- $100,000
Operating year 4 to date money lines are the 4 reported quarters summed to the cent; occupancy is their average. The refinance is scheduled for month 61 and has not happened yet. Next report: quarterly statement; K-1 through the deal room by March 15, estimate by end of January.
Coming next, not built yet 1
T12 and rent roll ingestionArrives with actuals ingestion
Upload a T12 or a rent roll, AI extraction drafts the lines, and a reviewer confirms every figure on a review screen before anything lands in operating_periods for this deal and period. No ledger line posts without a human confirming it.
Apolis formats the record; the sponsor owns every figure in it.