| Property / Suite | Tenant | Category | Lease End | Current Base | CAM | M2M Should-Be | M2M Back-Charge | Renewal % | New Base | Annual Upside | Decision | Notes | Actions |
|---|
M2M Should-Be = Current Base × (M2M Premium % / 100). The flat amount they should be paying each month while expired, per Letter D / your lease's holdover clause.
M2M Back-Charge = (M2M Should-Be − Current Base) × Months Since Expiration. The money on the table if Letty wants to back-collect the unpaid M2M premium.
New Base = Current Base × (1 + Renewal % / 100). The proposed renewal rent in Letter B.
Annual Upside = (New Base − Current Base) × 12. Year-1 incremental revenue if they sign.
Decision dropdown: choose Renew (Letter B), M2M (Letter D), Skip, or Walk. Only "Decided" rows get bundled into the bulk .zip.
Default %s by category (you can override anywhere):