Charlotte 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 Charlotte–Concord–Gastonia metro report, CBSA 16740, linked from North and South Carolina. Northmarq’s publisher market includes York County, SC; exact alignment with the complete CBSA is unverified. Charlotte city, Mecklenburg County and the cross-state metro are different entities. No neighborhood cap rates are inferred.

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

Local evidence to obtain

Record parcel state, municipality, tax districts, ownership-transfer treatment and revaluation dates. Reconcile effective renewals and buyer expenses, then test the same annual cost miss with a wider exit and a funded cash contingency.

Reconciled reference, not a property quote

Test an additional annual tax and coverage obligation against the acquisition’s collected income before assigning value to the metro recovery. All amounts below are hypothetical annual dollars unless labeled otherwise. Loan $1,430,000, 6.6% assumed interest, 30-year monthly amortization.

One acquisition across report and worksheet
ItemAmount
Purchase price$2,600,000
Scheduled annual rent$372,000
Vacancy / collection allowance-$37,200
Effective income$334,800
Buyer property taxes$30,000
Commercial insurance$18,000
Management$20,088
Recurring repairs$22,000
Owner utilities$26,000
Payroll / contracts / administration$75,712
Recurring expenses$191,800
NOI before debt$143,000
Annual debt service$109,594
Replacement reserves below NOI$12,000
Cash after debt / reserves$21,406
Initial work$130,000
Closing costs$78,000
Total acquisition cost$2,808,000
Invested cash, no initial reserve deposit$1,378,000

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

Combined downside: one incremental $12,000 annual operating cost reduces NOI to $131,000 and cash to $9,406. At 6.25% exit, gross value becomes $2,096,000. 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

The reference is a hypothetical Mecklenburg acquisition. The county’s 2027 revaluation schedule does not establish this parcel’s next assessment or final bill; obtain the notice and adopted district rates. A York County alternative requires its own transfer and exemption determination. Do not carry owner-occupied treatment into an investor budget.

Obtain a commercial coverage quote and flood determination, reserve inspection and owner-paid utility records. State consumer insurance guidance is not proof of apartment coverage. Keep initial replacements separate from recurring repairs and reserves; test additional lender reserve deposits in invested cash.

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