Enter the building, the tenant's suite and the year's costs. The page shows each step of the working and the share the tenant owes for the year and by the month. It runs in your browser: nothing you type is sent anywhere or saved. Words you don't know are in the glossary.
Each amount is rounded to the cent at each step. TenantLogix prorates by the day; this page prorates by the month, so a part-year tenant can differ by a few dollars.
The order changes the answer. A cap applied before the stop gives a different figure from a cap applied after it. This page follows the order TenantLogix's own reconciliation runs in, and so does the worksheet below.
These are the figures the calculator opens with. A 5,000 SF tenant in a 50,000 SF building moved in on April 1 and paid $2,800 a month in CAM estimates. The building averaged 80% leased; the lease grosses operations up to 95%.
| Step | Working | Amount |
|---|---|---|
| Gross-up | Operations $300,000 × 95 ÷ 80 | $356,250.00 |
| Pool | $356,250 + taxes $150,000 + insurance $50,000 | $556,250.00 |
| Pro rata share | 5,000 ÷ 50,000 | 10.00% |
| Share of the pool | $556,250 × 10% × 9/12 | $41,718.75 |
| Expense stop | $4.00 × 5,000 SF × 9/12 = $15,000 | $26,718.75 |
| Admin fee | 5% of $26,718.75 = $1,335.94 | $28,054.69 |
| Annual cap | $36,000 × 9/12 = $27,000, so the cap applies | $27,000.00 |
| Tenant's share | For the nine months; $3,000.00 a month | $27,000.00 |
| True-up | $27,000.00 less $25,200.00 in estimates | $1,800.00 due |
Plain CSV files. They open in Excel, Google Sheets or Numbers. No email address asked for.
One row per tenant, one column per step, in the order above: share, gross-up, pool, stop, admin fee, cap, the share for the year, estimates billed and the true-up. Two tenants from the worked example are filled in so you can check your formulas against them.
Download the worksheetOne row per suite, with the property, the suite, the tenant, the lease and the balance at cutover. These are the columns TenantLogix's import maps from one file into owners, properties, suites, tenants, leases, rent steps and opening balances. A vacant suite is a row with the tenant columns blank.
Download the rent rollThe calculator handles one tenant. TenantLogix runs the same steps for every lease in the pool, by the day, reads each lease's own stop, cap and fee, and puts the true-up on each tenant's ledger once you have reviewed it.