⤓ Download Excel model
06 · P&L
P&L
Revenue and gross margin from the Revenue Estimates tab, expenses including property financing and labor, net profit and a simple ROI.
Property acquisition and financing
A separate calculation. Its answer, the property service cost, is the only property financing line in the P&L below.
| Line | Your amount ✎ | Default estimate |
|---|
Revenue
| Line | Annual | Source |
|---|---|---|
| Total revenues | From Revenue Estimates tab | |
| Total gross margin | From Revenue Estimates tab (revenue × gross margin by line) |
Expenses
| Line | Your amount ✎ | Default estimate |
|---|
Property service cost is interest only (no principal). Labor comes from the Labor tab.
Net profit
| Summary | Annual |
|---|
Simple ROI
| Line | Amount |
|---|
Simple ROI = net profit ÷ (equity contribution + initial capex). Equity contribution = total property acquisition (purchase price + closing + due diligence) − amount financed. Initial capex is the total on the Initial Capex tab, which no longer includes the property.
Sources
- Durham County FY2026-27 tax rate · June 2026
- City of Durham FY2025-26 proposed rate · 2025; verify