Atlanta metro apartment underwriting worksheet

RentalCalcs Editorial · reviewed October 22, 2026. Conventional apartments. Free; no account required. This worksheet does not save entries. Print or save to PDF before closing.

Read the full research, source ledger and coverage limits

Property and source identity

One Atlanta–Sandy Springs–Roswell metro report, CBSA 12060. Northmarq and MMG define their own Atlanta inventories; exact correspondence to the CBSA is unverified. Atlanta city rules and costs do not automatically apply to Sandy Springs, Alpharetta or unincorporated counties. Conventional apartments only; no neighborhood cap premiums inferred.

Evidence binding: georgia-2026-10-18-v2. Do not substitute an asking cap, gross yield or modeled inventory yield for a matched sale cap.

Local evidence to obtain

Record trailing collected NOI, buyer year-one NOI and stabilized NOI separately. Fund renovation downtime and incremental concession months, then reconcile the exit income convention with comparable sales and actual debt proceeds.

Reconciled reference, not a property quote

Test twelve incremental free lease-months at $1,450 each while holding recurring expenses constant; this is a concession miss, not a reported Atlanta average. All amounts below are hypothetical annual dollars unless labeled otherwise. Loan $1,375,000, 6.6% assumed interest, 30-year monthly amortization.

One acquisition across report and worksheet
ItemAmount
Purchase price$2,500,000
Scheduled annual rent$417,600
Vacancy / collection allowance-$41,760
Effective income$375,840
Buyer property taxes$42,000
Commercial insurance$21,000
Management$22,550
Recurring repairs$25,000
Owner utilities$30,000
Payroll / contracts / administration$97,790
Recurring expenses$238,340
NOI before debt$137,500
Annual debt service$105,379
Replacement reserves below NOI$14,400
Cash after debt / reserves$17,721
Initial work$180,000
Closing costs$75,000
Total acquisition cost$2,755,000
Invested cash, no initial reserve deposit$1,380,000

Entry cap 5.50%; yield on total acquisition cost 4.99%; DSCR before / after reserves 1.30× / 1.17×; debt yield 10.00%; cash-on-cash 1.28%. Add any initial reserve deposit to invested cash and cost.

Combined downside: one incremental $17,400 collected-income loss reduces NOI to $120,100 and cash to $321. At 6.5% exit, gross value becomes $1,847,692. Capitalize the miss only if it recurs in normalized exit NOI; a one-off concession or repair reduces cash without automatically reducing future annual NOI. This excludes payoff, selling costs, income tax and interim cash flow; the income miss is counted once.

Replace the assumptions before bidding

Georgia DOR generally assesses taxable property at 40% of fair market value, subject to statutory exceptions. The actual bill depends on county valuation and each applicable district’s millage. Verify the parcel and buyer-use treatment; owner-occupied homestead benefits cannot simply be retained in an investor apartment budget.

A renovation budget is separate from recurring repairs and turnover. Obtain a commercial coverage quote, payroll and utility contracts, and a unit-by-unit work calendar. Concessions already inside the baseline loss allowance must not be subtracted again; the stress below is an explicitly additional miss.

Value = annual NOI ÷ (cap percent ÷ 100). Enter cumulative NOI growth separately from annual growth. A tighter exit is a scenario, not a forecast.