Property Review
Owner dashboard · through June 2031 (fictional period)
Portfolio
Cash-basis totals from each monthly report.
Harbor View
100 Example Avenue, Ellery Bay (fictional)
occupied
NOI
net income
cash
Maple Court
200 Sample Street, Wrenfield (fictional)
occupied
NOI
net income
cash
Needs attention
Monthly net income
| Month | Harbor View | Maple Court |
|---|
Buildings now
Weekly report, end of June 2031. Lost rent is vacancy on that report. Cash still out is delinquency.
Harbor View
lost rent
8 of 8 occupied
on notice
collected
Maple Court
lost rent
12 of 15 occupied
on notice
collected
Vacant and on-notice units
Maple Court: 3 vacant (E, L, N) and 1 still rented with the resident on notice (M).
Maple Unit E · 2 bed / 1 bath · Vacant
Vacant about three weeks. Asking $1,975.00; prior rent $1,690.00; building market $1,975.00.
Maple Unit L · 2 bed / 1 bath · Vacant
Vacant about three weeks. Asking $1,975.00; prior rent $1,815.00.
Ledger showed a $145.20 resident credit from a prior period.
Maple Unit N · 2 bed / 1 bath · Vacant
Vacant about two weeks; make-ready in progress. Asking $1,975.00; prior rent $1,745.00.
Maple Unit M · 3 bed / 2 bath · On notice
On notice · move-out expected next month. Asking $2,575.00; current rent $1,980.00.
Resident gave notice. Move-out inspection, key return and the security-deposit review will follow the standard process.
Separately, one occupied unit is in a collections process (details omitted).
Pricing
Market rent on the June 2031 rent roll minus rent charged. A gap is not an instruction to raise every renewal.
| Property | Market rent | Charged rent | Loss to lease |
|---|---|---|---|
| Harbor View | $10,600 | $9,050 | $1,550 |
| Maple Court | $32,550 | $23,785 | $8,765 |
Loss to lease by unit type
| Property | Type | Units | Market | Charged | Gap |
|---|---|---|---|---|---|
| Harbor View | Studio | 8 | $10,600 | $9,050 | $1,550 |
| Maple Court | 3 bed / 1 bath | 3 | $7,050 | $6,515 | $535 |
| Maple Court | 2 bed / 1 bath | 9 | $17,775 | $10,520 | $7,255 |
| Maple Court | 3 bed / 2 bath | 3 | $7,725 | $6,750 | $975 |
Nearby market
Listing survey A, spring 2031: overall $1,610; studio $1,290; 1 bedroom $1,540; 2 bedroom $2,060. Listing survey B, early summer 2031: overall $1,705, up 2.4%.
Listing survey C, spring 2031: 2 bedroom $2,035; 3 bedroom $2,480. Listing survey D, early summer 2031: overall $2,140 and 2 bedroom $1,990.
Harbor View
June 2031 · 8 of 8 occupied
Cash after debt service
Mortgage
Northstar Bank (fictional) · statement June 2031 · principal paid to date $96,281.60 · loan principal $412,618.40 · 6.85% fixed · FYTD interest $14,190.37 · total interest paid $58,914.06.
| Month | Loan payment | Interest due | Principal due | Loan balance |
|---|---|---|---|---|
| Jul 2031 | $3,050.00 | $2,355.36 | $694.64 | $411,923.76 |
| Aug 2031 | $3,050.00 | $2,351.40 | $698.60 | $411,225.16 |
| Sep 2031 | $3,050.00 | $2,347.41 | $702.59 | $410,522.57 |
| Oct 2031 | $3,050.00 | $2,343.40 | $706.60 | $409,815.97 |
| Nov 2031 | $3,050.00 | $2,339.37 | $710.63 | $409,105.34 |
| Dec 2031 | $3,050.00 | $2,335.31 | $714.69 | $408,390.65 |
Where the money went
$145
$625
$780
$1,020
$1,040
Rent roll
Security deposits held $7,450. Negative balances are credits; positive balances are amounts owed.
| Unit | Type | Resident | Market | Rent | Charges | Lease ends | Balance |
|---|---|---|---|---|---|---|---|
| A | Studio | Occupied | $1,325.00 | $1,040.00 | $1,055.00 | MTM | $0.00 |
| B | Studio | Occupied | $1,325.00 | $1,110.00 | $1,125.00 | Feb 2032 | −$215.00 |
| C | Studio | Occupied | $1,325.00 | $1,280.00 | $1,295.00 | Sep 2031 | $0.00 |
| D | Studio | Occupied | $1,325.00 | $980.00 | $995.00 | MTM | $0.00 |
| E | Studio | Occupied | $1,325.00 | $1,195.00 | $1,210.00 | Jan 2032 | $42.50 |
| F | Studio | Occupied | $1,325.00 | $1,060.00 | $1,075.00 | MTM | $0.00 |
| G | Studio | Occupied | $1,325.00 | $1,235.00 | $1,250.00 | Nov 2031 | −$610.00 |
| H | Studio | Occupied | $1,325.00 | $1,150.00 | $1,165.00 | Apr 2032 | $0.00 |
Maple Court
June 2031 · 12 of 15 occupied
Cash after debt service
Operating cash is below this month's debt service of $6,120.
Mortgage
Northstar Bank (fictional) · statement June 2031 · principal paid to date $211,547.25 · loan principal $968,452.75 · 5.95% fixed · FYTD interest $28,905.12 · total interest paid $102,388.40.
| Month | Loan payment | Interest due | Principal due | Loan balance |
|---|---|---|---|---|
| Jul 2031 | $6,120.00 | $4,801.91 | $1,318.09 | $967,134.66 |
| Aug 2031 | $6,120.00 | $4,795.38 | $1,324.62 | $965,810.04 |
| Sep 2031 | $6,120.00 | $4,788.81 | $1,331.19 | $964,478.85 |
| Oct 2031 | $6,120.00 | $4,782.21 | $1,337.79 | $963,141.06 |
| Nov 2031 | $6,120.00 | $4,775.57 | $1,344.43 | $961,796.63 |
| Dec 2031 | $6,120.00 | $4,768.91 | $1,351.09 | $960,445.54 |
Where the money went
$410
$1,310
$3,240
$2,185
$1,560
$2,415
Rent roll
Security deposits held $17,925. Negative balances are credits; positive balances are amounts owed.
| Unit | Type | Resident | Market | Rent | Charges | Lease ends | Balance |
|---|---|---|---|---|---|---|---|
| A | 3 bed / 1 bath | Occupied | $2,350.00 | $1,890.00 | $1,905.00 | MTM | $0.00 |
| B | 3 bed / 1 bath | Occupied | $2,350.00 | $2,350.00 | $2,350.00 | Oct 2031 | $0.00 |
| C | 2 bed / 1 bath | Occupied | $1,975.00 | $1,720.00 | $1,735.00 | Dec 2031 | −$350.00 |
| D | 2 bed / 1 bath | Occupied | $1,975.00 | $1,940.00 | $1,990.00 | Mar 2032 | $0.00 |
| E | 2 bed / 1 bath | Vacant | $1,975.00 | — | — | - | — |
| F | 2 bed / 1 bath | Occupied | $1,975.00 | $1,805.00 | $1,805.00 | Feb 2032 | $88.25 |
| G | 2 bed / 1 bath | Occupied | $1,975.00 | $1,560.00 | $1,575.00 | MTM | −$12.40 |
| H | 2 bed / 1 bath | Occupied | $1,975.00 | $1,610.00 | $1,640.00 | MTM | $0.00 |
| I | 3 bed / 1 bath | Occupied | $2,350.00 | $2,275.00 | $2,395.00 | Aug 2031 | $0.00 |
| J | 2 bed / 1 bath | Occupied | $1,975.00 | $1,885.00 | $1,885.00 | Jan 2032 | −$1,885.00 |
| K | 3 bed / 2 bath | Occupied | $2,575.00 | $2,310.00 | $2,325.00 | May 2032 | $0.00 |
| L | 2 bed / 1 bath | Vacant | $1,975.00 | — | — | - | — |
| M | 3 bed / 2 bath | Occupied | $2,575.00 | $1,980.00 | $2,015.00 | MTM | $0.00 |
| N | 2 bed / 1 bath | Vacant | $1,975.00 | — | — | - | — |
| O | 3 bed / 2 bath | Occupied | $2,575.00 | $2,460.00 | $2,460.00 | Mar 2032 | $0.00 |