RentalCalcs · Philadelphia metro · reviewed 2026-10-22

Apartment evidence and buyer worksheet

Free manual worksheet. Typed fields do not calculate or change the reference example. No account or automatic saving; entries remain in this open page. Print or save a completed PDF before closing.

Read the report

1. Match the comparable and its income

One Philadelphia–Camden–Wilmington metro report, CBSA 37980, covering a PA–NJ–DE–MD statistical identity. Northmarq and CBRE use their own apartment markets; exact CBSA inventory crosswalks are unavailable. Philadelphia City, Camden, Wilmington and Cecil County have separate legal and cost frameworks. The city rules below apply only to a verified Philadelphia address, and Wilmington rules only within that city.

2. What if three Philadelphia renewals need two free months?

Three renewals with two $1,700 rent-free months each cost $10,200 beyond baseline only if those months were not already allowed. No income from initial work is assumed.

Northern Liberties, Fishtown and Kensington: occupancy can recover before the renewal budget

Collect dated competing offers, free-rent terms, fees, utility charges and subject receipts. Record initial lease term and renewal month separately; do not count free rent both as vacancy and an extra concession loss.

Older Philadelphia conversions: price the supported units and the lease-ready file

Obtain the CO or city-accepted alternative, current rental license, unit-level lead file, violations, suitability certificates and contractor bids. Confirm the subject's exact accepted documentation and timing with L&I/Public Health or counsel.

New Castle County trades are not Philadelphia City comparables by default

Verify municipality and county, local rental registration/license, inspection history, management requirements and an actual management quote. Rebuild taxes, utilities and recurring services for the buyer; identify the correct authority for a Newark-area address.

3. Reconcile buyer operations

Rebuild the actual local parcel bill and abatement/exemption schedule; the city OPA guidance is not a PA/NJ/DE/MD tax rate. The first fully taxable year can differ from the seller's last bill, but no universal expiry date or buyer tax quote is assumed. Verify legal occupancy and lead/lease documents for a Philadelphia City subject. Wilmington has a distinct program. Itemize recurring compliance, management and utilities, and keep one-time correction bids in initial work. Obtain binding insurance terms.

4. Financing, work and cash

5. Income miss and exit test

Three hypothetical renewals at $1,700 with two rent-free months each reduce collected annual income by $10,200 beyond baseline loss only if not already included. This is not a measured Philadelphia incentive average. Capitalize the loss into exit value only when it represents recurring normalized income, rather than a single first-year turn.

Same hypothetical acquisition as the report

Annual dollars unless marked; manual reference, no market quote
Scheduled income$326,400
Loss allowance$26,112
Effective income$300,288
Buyer property taxes$30,000
Commercial insurance$16,000
Management$15,014
Recurring repairs$26,000
Owner utilities$26,000
Administration and contracts$55,274
Recurring expense total$168,288
NOI$132,000
Purchase price$2,200,000
Loan principal$1,210,000
Annual amortizing debt service$91,776
Annual reserve below NOI$9,600
Cash after debt and reserve$30,624
Closing costs, once$66,000
Initial work, once$140,000
Invested cash; no initial reserve deposit assumed$1,196,000

Entry 6.00%; assumed debt 6.5% / 30 years. DSCR 1.44× before / 1.33× after reserves. Debt yield 10.91%; cash-on-cash 2.56%. Yield on price + closing + work 5.49%. No income from initial work assumed.

Same incremental stress $10,200: NOI $121,800, cash $20,424. At 7% exit, gross value $1,740,000. Excludes sale costs, tax, loan payoff and interim cash; applies only if the loss recurs in normalized exit NOI.

Source ledger and refresh policy. Edition philadelphia-2026-10-22-v1; benchmark binding philadelphia-evidence-2026-h1-v1. Review the report and regenerate this worksheet together after input changes.