Nashville 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

Nashville–Davidson–Murfreesboro–Franklin metro, CBSA 34980. Publisher inventories and submarket boundaries are not verified as identical to the CBSA or to each other. Davidson rules do not automatically apply to Williamson, Rutherford or Sumner counties. Conventional apartments; no neighborhood cap premiums inferred.

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

Local evidence to obtain

Reconcile collected and asking rent, incremental concessions, corridor opening dates and the parcel’s actual tax district. Fund negative cash after reserves and test exit value with the same lower NOI.

Reconciled reference, not a property quote

Twelve additional free lease-months at $1,450 reduce collections by $17,400 with fixed recurring expenses. This hypothetical concession miss is incremental to baseline loss, not a reported Nashville average. All amounts below are hypothetical annual dollars unless labeled otherwise. Loan $1,100,000, 6.6% assumed interest, 30-year monthly amortization.

One acquisition across report and worksheet
ItemAmount
Purchase price$2,000,000
Scheduled annual rent$313,200
Vacancy / collection allowance-$31,320
Effective income$281,880
Buyer property taxes$40,000
Commercial insurance$16,000
Management$16,913
Recurring repairs$20,000
Owner utilities$20,000
Payroll / contracts / administration$58,967
Recurring expenses$171,880
NOI before debt$110,000
Annual debt service$84,303
Replacement reserves below NOI$10,800
Cash after debt / reserves$14,897
Initial work$120,000
Closing costs$60,000
Total acquisition cost$2,180,000
Invested cash, no initial reserve deposit$1,080,000

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

Combined downside: one incremental $17,400 collected-income loss reduces NOI to $92,600 and cash to -$2,503. At 6.5% exit, gross value becomes $1,424,615. 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

Davidson’s revenue-neutral certification does not freeze a parcel bill or establish the adopted rate. Verify assessed value, classification, General or Urban Services District, municipal obligations and the current bill. Williamson and Rutherford require separate records. No future tax rate or appeal reduction is assumed.

Obtain the actual insurance terms and a building-systems inspection. Separate initial work and funded reserves from recurring repairs. The extra concession shock is additional to the baseline loss allowance; do not deduct a concession already included in collections twice.

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