RentalCalcs · Free research worksheet · Reviewed October 18, 2026

Illinois apartment offer worksheet

A rent increase does not establish a better buyer return until taxes, collections and recurring work are rebuilt. Compare lakefront, downtown and suburban income separately; obtain local sales before pricing downstate apartments.

· Read the evidence and use the interactive tools

Property / legal jurisdiction: Date:

Unit count / lease type / source documents:

1. Reconcile recurring buyer NOI

Annual lineReport illustrationYour property / evidence
Price$2,000,000___________________
Scheduled rent$336,000___________________
Vacancy, concessions and collection loss (subtract once)$26,880___________________
Effective collected income$309,120___________________
Buyer taxes$60,000___________________
Binding insurance premium$18,000___________________
Management$15,000___________________
Recurring repairs$26,000___________________
Owner utilities$22,000___________________
Administration / recurring compliance$28,120___________________
Recurring expenses total$169,120___________________
NOI before debt and reserve$140,000___________________

All example amounts are hypothetical, not local quotes. Buyer NOI = collected income − recurring operating costs. Capital work and replacement reserves are separate. Cap = NOI ÷ price × 100.

2. Complete the Illinois evidence checks

3. Match the comp before choosing a cap

Sale address / date / source:

Actual geography, units, class and lease/regulation basis:

Price / reported NOI / trailing or forward basis:

Debt assumption, concessions, immediate work, missing inputs:

The displayed 2025 comparator is an arithmetic implication of approximately 6.0% and the publisher’s reported 25-bp increase, not a separately verified exact 2025 mean. Only one verified regional cap series is included. A single Chicago point is more honest than a fabricated statewide range. Its 2025 comparator is not a matched H1 2025 cohort. REIS operating observations and CoStar/RCA sales cover different concepts. Do not mix this average with an asking yield, small-house gross rent/value index or a professional survey.

4. Reconcile debt and invested cash

Loan, rate, amortization$1,100,000 / 6.5% / 30 years____________
Annual debt service$83,433____________
Annual replacement reserve below NOI$12,000____________
Down payment + closing + immediate work$900,000 + $60,000 + $100,000 = $1,060,000____________
Cash after debt and reserve$44,567____________
DSCR before / after reserve1.68× / 1.53×____________
Cash-on-cash before income tax4.20%____________

Confirm lender NOI/reserve convention. Cash-on-cash uses all invested cash above; capital reserves and repairs are not interchangeable. Property value does not guarantee refinance proceeds.

5. Test what would change the offer

Entry cap: _____% · Exit cap: _____% · Total cumulative NOI change: _____%

Value = annual NOI ÷ (cap ÷ 100). Buyer-cost correction: _____ per year. Revised NOI: _____ . Value at original cap: _____ . Wider-cap value: _____ .

NOI needed to preserve value = starting NOI × exit cap ÷ entry cap. Simple value excludes debt payoff, sale costs, taxes and interim cash flow.

Missing document / evidence that invalidates the thesis:

Maximum offer supported by buyer NOI, debt and liquidity:

Primary checks: Cook County Assessor — How commercial properties are valued · Illinois Department of Insurance — Small business insurance · City of Chicago — Residential Landlord and Tenant Ordinance. No photographed building or regional benchmark is a subject-property appraisal.