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