How concentrated is our lease-renewal risk?
- Files
- 3
- Rows
- 1,210
- Checks passed
- 18
Rent expiring in one quarter
39.9%
Arrears outstanding
$93,100
Occupancy, paying
72.6%
What went in
Jul 1, 2025 – Jun 30, 2026
- Project
- Rent roll and ledger: three properties
- Subject
- Cash flow & budgets
- Rows
- 1,210
Source files
- rent_roll_jun_2026.xlsx84 rows
- payment_ledger_12m.csv1,042 rows
- lease_schedule.xlsx84 rows
The finished example
Demonstration data we built, not a customer's file.
Rendered by the same components that render your own projects.
Two fifths of your monthly rent comes up for renewal in one quarter.
28 of 84 leases end in January, February and March 2027, carrying $85,700 of the $214,800 monthly roll: 39.9% of the income renegotiated in thirteen weeks, because the buildings were let up together and nobody has looked at the calendar in aggregate since. Separately, 19 tenants are shown as current who have not paid on time in a year, and the $93,100 of arrears is not spread across the portfolio: three tenants carry $61,200 of it and all three are past 90 days.
The renewals are not spread across the year
$85,700 a month lands in Q1 2027
- 0128 leases worth $85,700 a month all end in the first quarter of 2027.
- 0219 tenants have never paid on time and every one of them shows as current.
- 03Three tenants owe $61,200 of the $93,100 outstanding.
Filed under
Closest to this one
Ranked by how many subjects they share with this project.
Have something like this?
Drop it in and see what comes back. You only pay once you like it.
No account needed to start. You only pay when you like what you see.