Free tool · no sign-up

CAM for one tenant,
worked out step by step.

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.

The figures already filled in are the worked example further down the page. Change any of them and the working follows.

Areas
The year's recoverable costs ($)
Lease terms (leave blank if the lease has none)

The working

  1. Gross-up of variable costs
  2. The pool
  3. Pro rata share
  4. Share of the pool
  5. Less the expense stop
  6. Plus the admin fee
  7. Annual cap
Tenant's CAM share
$0.00
for the year
By the month
$0.00
a month
True-up
n/a
enter the estimates billed to see the true-up

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.

Order of operations

The same order TenantLogix uses.

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.

  1. Gross up the costs that vary with occupancyIf the building averaged less than the lease's gross-up target, each variable cost is raised to what it would have been at the target: cost × target ÷ occupancy. Taxes and insurance usually stay as billed.
  2. Add up the poolThe pool is every category the tenant's lease shares, after gross-up.
  3. Take the tenant's pro rata shareTenant's rentable SF ÷ the building's rentable SF. The bottom of that fraction is the whole building, leased or not. For part of a year, the share is cut to the time occupied.
  4. Subtract the expense stopA base-year stop of $4.00/SF on a 5,000 SF suite means the first $20,000 a year is in the rent. The tenant pays only what the share comes to above that, and never less than zero.
  5. Add the admin feeA percentage of what is left after the stop, if the lease allows one.
  6. Apply the annual capThe share plus the fee cannot go over the lease's cap for the year, cut to the months occupied. What the cap cuts away is the owner's cost.
Worked example

Suite 300, nine months of the year.

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%.

StepWorkingAmount
Gross-upOperations $300,000 × 95 ÷ 80$356,250.00
Pool$356,250 + taxes $150,000 + insurance $50,000$556,250.00
Pro rata share5,000 ÷ 50,00010.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 fee5% 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 shareFor 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
Free templates

Two spreadsheets to download.

Plain CSV files. They open in Excel, Google Sheets or Numbers. No email address asked for.

CAM reconciliation worksheet

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.

cam-reconciliation-worksheet.csv · 27 columns
Download the worksheet

Rent roll template

One 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.

rent-roll-template.csv · 34 columns
Download the rent roll
Every tenant, every year

The app does this for the whole building.

The 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.

  • A reconciliation run you review firstOne row per lease, with the arithmetic behind each figure. Nothing posts until you post it.
  • Check last year's CAMType in what the owner billed each tenant last year. TenantLogix works out the same year from the leases and puts both side by side, with the reason for each difference. Nothing posts. It is on the Manager plan and in the free trial.
  • Fourteen days free, no cardThe trial is the Manager plan, CAM included. After it, Manager is $149 a month for up to 15 buildings.