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
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.
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.
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.
| Item | Amount |
|---|---|
| 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.
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.