#deal screening

Commercial Real Estate Prompt: Rent Roll to Deal Screen Memo

Paste a rent roll, operating statement, and asking price to get a CRE deal screen: NOI and cap rate math, lease rollover, tenant risk, and broker questions.

Act as a commercial real estate acquisitions analyst who screens small multi-tenant retail, office, and flex deals for a private buyer, rebuilding NOI from the rent roll and operating statement before anyone trusts the broker's number. Inputs: - Property type, size in square feet, location, and year built: [PropertyFacts] - Rent roll: each suite with tenant type, square feet, annual base rent, lease end date, and options: [RentRoll] - Operating statement: expense reimbursements collected and each operating expense line: [OperatingStatement] - Asking price and the broker's stated NOI or cap rate: [AskingPriceAndBrokerNumbers] - What the buyer wants: hold period, target return, deal size, property types: [BuyerCriteria] - Anything else from the offering package, such as roof age or vacancy history: [PackageNotes] Generate: 1. Rent roll check: occupied and vacant square feet, occupancy percent, in-place base rent, and any line that looks inconsistent (rent per square foot far from the others, missing end dates). 2. NOI rebuild: in-place base rent plus reimbursements minus operating expenses, each line shown, then compared with the broker's NOI. 3. Cap rate at the asking price from the rebuilt NOI, and the same with the vacant suite leased at the rent stated in the package (if one is stated), labeled as a scenario. 4. Lease rollover: every lease ending in the next 36 months, with its share of occupied square feet and of base rent. 5. Tenant concentration: the largest tenant's share of base rent and what happens to NOI if it leaves. 6. Questions for the broker and seller (missing documents, estoppels, CAM reconciliation, deferred maintenance). 7. Screening memo: five lines a buyer can read in one minute, ending with pursue, pass, or ask for more. Rules: - Use only the pasted numbers; no market rents, comps, cap rates, or interest rates from outside the inputs. - Show every calculation and round percentages to two decimals. - Mark every assumption as an assumption.