A new 300-unit apartment building in the Washington DC metro costs $106,006,164 to build in this model and earns a 5.75% yield on that cost. Finished apartment buildings in the same market trade at a 5.64% cap rate. The developer takes two years of construction risk and more than a year of lease-up risk for 11 basis points of extra yield. The request asked for a flag below 150.
You work in development or acquisitions and you want to know whether a new apartment building pencils at today’s costs and rates before you spend money on a site. We asked Compound to pick the market from public data, anchor the cost and the target yield on what a public apartment REIT discloses, and build the full development pro forma. It ran on November 15, 2026 and returned one Excel workbook and a short summary.
The subject is a hypothetical building with no site or seller behind it. The model’s returns follow from stated inputs. They are not a forecast of what a project in this metro would earn, and nothing here is advice to build, buy or lend.
What the workbook shows:
- The spread is 11 basis points. Untrended yield on cost is 5.75% and trended yield is 5.87%, against a 5.64% market cap rate. Development margin is 4.1%, or $4,327,447.
- Every flag trips. The spread is under 150 basis points, the permanent loan is $2,899,463 short of the construction payoff, and both yields are below the 6.2% the REIT projects for its own pipeline.
- Debt lowers the return. The unlevered IRR is 7.0% and the levered IRR is 6.3%. The permanent loan costs 6.75%, more than the building yields.
- Capitalized interest is $7,426,548. That is 7.0% of total cost, on a construction loan priced at the one-month SOFR forward rate plus 3.00%.
Each input names its source or says “analyst assumption”. Permits and population come from the Census Bureau, rents from Zillow’s ZORI index and Apartment List, and vacancy from Apartment List. The cost anchor and the target yield come from a REIT’s filings on SEC EDGAR, and the escalation from two Bureau of Labor Statistics series. The construction loan is priced on the SOFR forward curve and the permanent loan on the Daily Treasury Par Yield Curve. The market cap rate comes from web search.
“I am testing whether a new apartment building pencils at today's costs and rates and want a real estate development pro forma anchored on public facts. Pick the market from the data: among the 50 largest metros, choose one where Census building permits for buildings of five or more units have fallen at least 30% from their recent peak while Zillow ZORI rent is still rising and Apartment List vacancy is at or below the national figure, and show the table you chose from. The subject is a single-phase, 300-unit mid-rise rental building in that metro. Set rents from ZORI and Apartment List for the metro. Set the hard cost per unit and the target yield from what a public apartment REIT that builds in that region discloses for its development pipeline in its latest 10-K or 10-Q (total cost, units, expected stabilized yield), and bring the cost to today with the BLS construction cost PPI and construction wage series. Split hard cost across site, structure, envelope, mechanical-electrical-plumbing and finishes, and set land, soft costs, contingency, furniture and developer fee as analyst assumptions with a note on each. Price the construction loan off the SOFR forward curve plus a spread, and the permanent loan off the 10-year Treasury yield. Build: the development budget; S-curve monthly draws with equity funded first; capitalized interest worked out from the average balance with no circular reference; lease-up; an operating pro forma to year 11; the permanent loan sized to the lowest of loan-to-cost, a 1.25x DSCR and a maximum loan-to-value; the refinance, with any shortfall shown as extra equity; and a sale. Report untrended and trended yield on cost, development spread over the market cap rate, development margin, levered and unlevered IRR, equity multiple, profit, stabilized DSCR and debt yield, peak equity, capitalized interest and the permanent loan size. Add two sensitivity tables: yield on cost to hard cost and rent, and equity multiple to exit cap rate and rent. Flag a development spread under 150 basis points, a refinance shortfall, and a yield on cost below the yield the REIT discloses. Use the stored public data wherever it has the figure, and web search only for what it lacks. Put every input on an Assumptions sheet with one column that says where it came from: a cited source, or "analyst assumption" for a figure I would set myself, with the reason for the value you chose. Every output must be a live formula that traces back to the Assumptions sheet. Add a Sources sheet listing each data source, what it gave and its date. Deliver one Excel workbook and a short summary of the result, the flags, and what I would need from the seller to firm it up. Cite every sourced figure.”
That is the request as we sent it, without its closing line, which asks that no name or email be put in the workbook.
What goes into a real estate development pro forma
A development pro forma asks whether the finished building earns enough on its cost to pay for the risk of building it. It gets there through a budget, a monthly draw schedule, two loans, a lease-up and a sale.
An acquisition model starts with a building that already collects rent, as the real estate pro forma page shows. A ground-up model has no income for two years, so the budget, the timing of each draw and the loan that repays the construction lender carry more weight.
Compound’s workbook has seven sheets. Assumptions holds every input with its source in column E. Budget builds the cost. Monthly is a 132-month schedule of draws, interest, lease-up, both loans and the sale. Annual sums it by year, and Summary reports the yields, the returns and the flags. Market Screen is the table the metro was chosen from, and Sources lists each data source with its date.
Four inputs carry the label “Request”: the 300 units, the 1.25x coverage test, the 150 basis point threshold and the 30% permit decline.
Picking the market: permits, rents and vacancy across 50 metros
Fourteen of the 50 largest metros pass all three tests, and Washington DC is the largest of them where the REIT has a project under construction. Its permits for buildings of five or more units are 49.3% below their 2022 peak.
The request set three tests: permits at least 30% below their recent peak, ZORI rent rising, and Apartment List vacancy at or below the national figure, which was 7.0% in October 2026. Compound loaded the Census Building Permits Survey for 2021 through 2025 and the year to date through September 2026, ranked the metros by 2025 population and tested each one with a formula.
| B | D | N | O | M | P | S | T | X | Y | |
|---|---|---|---|---|---|---|---|---|---|---|
| 4 | Rank | Metro | Recent peak (2021-25) | Peak year | TTM Sep-26 | TTM vs peak | YoY | AL vacancy Oct-26 | Passes all three | REIT development under way in metro (Vivmark Q3 2026 10-Q) |
| 7 | 3 | Chicago-Naperville-Elgin, IL-IN Metro Area | 8,128 | 2022 | 4,536 | (44.2%) | 4.7% | 5.9% | Yes | None |
| 11 | 7 | Washington-Arlington-Alexandria, DC-VA-MD-WV Metro Area | 23,799 | 2022 | 12,057 | (49.3%) | 1.4% | 6.3% | Yes | Avalon Dulles Innovation, Herndon VA (355 homes) |
| 13 | 9 | Philadelphia-Camden-Wilmington, PA-NJ-DE-MD Metro Area | 25,427 | 2021 | 6,498 | (74.4%) | 3.3% | 5.2% | Yes | None |
| 16 | 12 | Riverside-San Bernardino-Ontario, CA Metro Area | 7,348 | 2023 | 2,965 | (59.6%) | 2.9% | 5.2% | Yes | None |
| 18 | 14 | Detroit-Warren-Dearborn, MI Metro Area | 3,223 | 2025 | 2,078 | (35.5%) | 4.2% | 4.6% | Yes | None |
| 19 | 15 | Seattle-Tacoma-Bellevue, WA Metro Area | 20,321 | 2021 | 12,436 | (38.8%) | 1.8% | 6.1% | Yes | None |
| 26 | 22 | Baltimore-Columbia-Towson, MD Metro Area | 3,740 | 2022 | 2,108 | (43.6%) | 2.7% | 5.3% | Yes | AVA Brewer's Hill, Baltimore (418); Avalon Townhome Collection Arundel Mills (90) |
| 28 | 24 | St. Louis, MO-IL Metro Area | 4,202 | 2022 | 2,461 | (41.4%) | 4.1% | 6.4% | Yes | None |
| 30 | 26 | Portland-Vancouver-Hillsboro, OR-WA Metro Area | 6,754 | 2022 | 3,157 | (53.3%) | 1.1% | 6.2% | Yes | None |
| 32 | 28 | Pittsburgh, PA Metro Area | 2,831 | 2023 | 1,649 | (41.8%) | 3.5% | 6.2% | Yes | None |
| 36 | 32 | Columbus, OH Metro Area | 9,549 | 2025 | 6,415 | (32.8%) | 2.9% | 6.4% | Yes | None |
| 41 | 37 | Virginia Beach-Chesapeake-Norfolk, VA-NC Metro Area | 2,674 | 2023 | 1,580 | (40.9%) | 7.1% | 3.6% | Yes | None |
| 45 | 41 | Milwaukee-Waukesha, WI Metro Area | 2,016 | 2024 | 1,351 | (33.0%) | 5.1% | 5.1% | Yes | None |
| 46 | 42 | Oklahoma City, OK Metro Area | 1,334 | 2025 | 398 | (70.2%) | 2.4% | 6.1% | Yes | None |
| 56 | United States | 2.7% | 7.0% |
Chicago passes and is larger, but the REIT’s filing lists no development there. Compound wrote its selection rule on the sheet: the largest passing metro where a public apartment REIT has a development under construction in its latest 10-Q, so that hard cost and target yield come from the same metro as the rents. The rule reads one company’s filing, and the agent’s answer says so.
Washington passes the rent and vacancy tests by small margins. ZORI rose 1.4% in the year to September 2026 against 2.7% for the United States, and vacancy is 6.3% against 7.0%.
Units permitted in buildings of five or more units, Washington DC metro
Units authorized per year, 2021 to 2025, and the twelve months to September 2026. The 2022 peak is highlighted
Compound workbook, Market Screen sheet, row 11, from the Census Building Permits Survey. The trailing twelve months is the sheet's formula: year to date September 2026 plus 2025 less year to date September 2025.
The chart shows something the pass-or-fail column hides. Permits fell from 23,799 units in 2022 to 7,392 in 2025, and then turned. The first nine months of 2026 authorized 10,667 units against 6,002 in the same months of 2025. The metro passes the test as written, and a developer would still want to know how many of the new permits are in its submarket. For the same question at the scale of one site, see the real estate market analysis page.
Hard cost per unit from a REIT development pipeline
Compound took the total cost and home count of one REIT project in the metro, assumed 65% of it is hard cost, and escalated it 3.33% with two BLS series. The result is $227,443 per unit.
The anchor is Avalon Dulles Innovation in Herndon, Virginia. Vivmark Residential’s Form 10-Q for the third quarter of 2026 lists it in the Development communities table with 355 homes, a total capital cost of $120.2 million and a construction start in the second quarter of 2026. That is $338,639 per home.
A REIT’s total capital cost includes land, soft costs, capitalized interest and overhead, and the filing does not split it. Compound assumed hard cost is 65% of the total and noted in column E that the share typically runs from 60% to 70% for suburban mid-rise buildings. That gives $220,116 per unit at the construction start.
To bring that to today, Compound used the BLS producer price index for inputs to multifamily construction, which rose from 164.615 in May 2026 to a preliminary 171.564 in October 2026, or 4.22%. Average hourly earnings in construction rose from $41.21 to $42.03, or 1.99%. Weighting materials at 60% and labor at 40%, a stated assumption, gives 3.33%. A REIT’s projected cost may already allow for price increases through completion, so this step can count some escalation twice. A contractor’s estimate replaces it.
The same REIT supplied the rent check. Compound blended ZORI ($2,407 a month) and the Apartment List median ($2,165) at equal weights to get $2,286, then added a 13% premium for a new building to reach $2,583. Column E says how the premium was set: so that the subject lands near the $2,585 a month the REIT’s supplemental projects for the Herndon community. The rent is calibrated to one REIT project, and the sensitivity tables test it. The REIT’s figure is projected revenue per home, and the filing does not say whether it includes parking and fee income. The model adds $150 per occupied unit per month of other income on top of the rent, so if the REIT’s figure already includes that income, the model counts it twice.
The development budget: $353,354 per unit
Total development cost is $106,006,164, or $353,354 per unit and $415.71 per rentable square foot. Hard costs are 64.4% of it and capitalized interest is 7.0%.
| B | C | D | E | F | |
|---|---|---|---|---|---|
| 4 | Total ($) | $ / unit | $ / SF | % of total | |
| 6 | HARD COST BUILD | ||||
| 7 | REIT total capital cost per unit (Avalon Dulles Innovation) | $338,639 | |||
| 8 | Hard cost share of REIT total capital cost | 65% | |||
| 9 | REIT hard cost per unit at construction start | $220,116 | |||
| 10 | PPI inputs to multifamily construction, change since base month | 4.22% | |||
| 11 | Construction average hourly earnings, change since base month | 1.99% | |||
| 12 | Blended cost escalation to today | 3.33% | |||
| 13 | Hard cost sensitivity factor | 100% | |||
| 14 | Hard cost per unit, today ($) | $227,443 | |||
| 30 | DEVELOPMENT BUDGET | ||||
| 31 | Land | 12,000,000 | 40,000 | 47.06 | 11.3% |
| 32 | Site work | 5,458,625 | 18,195 | 21.41 | 5.1% |
| 33 | Structure | 20,469,844 | 68,233 | 80.27 | 19.3% |
| 34 | Envelope | 11,599,579 | 38,665 | 45.49 | 10.9% |
| 35 | Mechanical, electrical, plumbing | 17,058,204 | 56,861 | 66.89 | 16.1% |
| 36 | Finishes | 13,646,563 | 45,489 | 53.52 | 12.9% |
| 37 | Total hard costs ($) | 68,232,815 | 227,443 | 267.58 | 64.4% |
| 38 | Hard cost contingency | 3,411,641 | 11,372 | 13.38 | 3.2% |
| 39 | Soft costs | 9,552,594 | 31,842 | 37.46 | 9.0% |
| 40 | Soft cost contingency | 477,630 | 1,592 | 1.87 | 0.5% |
| 41 | Furniture, fixtures and equipment | 1,050,000 | 3,500 | 4.12 | 1.0% |
| 42 | Developer fee | 3,266,987 | 10,890 | 12.81 | 3.1% |
| 43 | Total cost before financing ($) | 97,991,667 | 326,639 | 384.28 | 92.4% |
| 44 | Construction loan origination fee | 587,950 | 1,960 | 2.31 | 0.6% |
| 45 | Capitalized interest | 7,426,548 | 24,755 | 29.12 | 7.0% |
| 46 | Total development cost ($) | 106,006,164 | 353,354 | 415.71 | 100.0% |
Every line outside hard cost is an analyst assumption with a reason beside it. Land is $40,000 per unit, inside a range of $30,000 to $50,000 a door that the note gives for entitled suburban sites. Soft costs are 14% of hard cost. Contingency is 5% on hard cost and 5% on soft cost, furniture and equipment is $3,500 per unit, and the developer fee is 4%. The split of hard cost across five trades is also the analyst’s.
Development cost per unit by budget line
Dollars per unit for a 300-unit building. Hard cost is anchored on a REIT filing and escalated with BLS data. Capitalized interest is computed by the monthly schedule. The other lines are analyst assumptions
Compound workbook, Budget sheet, column D, rows 31 to 45.
One line cannot be typed in. Capitalized interest depends on the draw schedule, so cell C45 reads its total from the Monthly sheet.
Construction draw schedule: S-curve, equity first, capitalized interest
Equity of $39,784,617 funds the land and the first months of construction, and the loan’s first draw comes in month 9. The loan balance reaches $66,221,548 before the refinance, of which $7,426,548 is interest added to the balance.
| B | C | D | E | O | AA | AB | AC | AP | AS | |
|---|---|---|---|---|---|---|---|---|---|---|
| 4 | Month # | Total | 1 | 2 | 12 | 24 | 25 | 26 | 39 | 42 |
| 5 | Period end date | Jan-27 | Feb-27 | Dec-27 | Dec-28 | Jan-29 | Feb-29 | Mar-30 | Jun-30 | |
| 15 | S-curve, cumulative % complete | 0.4% | 1.7% | 50.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | |
| 25 | Total uses before interest ($) | 98,579,617 | 15,329,227 | 1,053,343 | 5,387,698 | 1,403,128 | - | - | - | - |
| 27 | Equity funded (equity first) | 39,784,617 | 15,329,227 | 1,053,343 | - | - | - | - | - | - |
| 28 | Construction loan draws | 58,795,000 | - | - | 5,387,698 | 1,403,128 | - | - | - | - |
| 31 | 1M SOFR forward (%) | 4.19 | 4.31 | 4.47 | 4.72 | 4.68 | 4.64 | 4.55 | 4.54 | |
| 32 | All-in rate (SOFR + spread) | 7.19% | 7.31% | 7.47% | 7.72% | 7.68% | 7.64% | 7.55% | 7.54% | |
| 33 | Opening balance | - | - | 11,156,892 | 60,668,836 | 62,479,938 | 62,892,938 | 66,221,548 | 66,221,548 | |
| 35 | Interest on average balance (actual/360) | 11,151,682 | - | - | 89,089 | 407,974 | 413,000 | 373,636 | 430,265 | 416,058 |
| 36 | Interest paid from property cash flow | 3,725,135 | - | - | - | - | - | - | 430,265 | 416,058 |
| 37 | Capitalized interest | 7,426,548 | - | - | 89,089 | 407,974 | 413,000 | 373,636 | - | - |
| 38 | Repayment at refinance | 66,221,548 | - | - | - | - | - | - | - | 66,221,548 |
| 39 | Closing balance ($) | - | - | 16,633,679 | 62,479,938 | 62,892,938 | 63,266,574 | 66,221,548 | - | |
| 42 | Occupied units | 0.0 | 0.0 | 0.0 | 0.0 | 20.0 | 40.0 | 281.0 | 281.0 | |
| 60 | Net operating income ($) | 54,398,885 | - | - | - | - | (237,843) | (184,886) | 503,214 | 511,028 |
The land closes on January 31, 2027. In month 1 the developer funds $15,329,227: the land, a quarter of the soft costs, the loan fee and the first sliver of construction. Hard costs then follow an S-curve over 24 months. Row 15 computes cumulative completion from a cosine, so spending is slowest at the start and the end.
Equity goes in first. The construction loan is 60% of the cost before financing, a commitment of $58,795,000. Interest is added to the balance on top of that commitment, which is how the balance reaches $66,221,548. Row 27 funds each month’s cost from equity until the budgeted equity is spent, and the loan’s first draw is $672,309 in month 9.
The loan rate floats. Row 31 looks up the one-month SOFR forward rate for each month on the curve of November 13, 2026, and row 32 adds the 3.00% spread. The all-in rate is 7.19% in month 1 and 7.72% in month 24. The spread, the 1.00% fee and the 60% loan-to-cost are analyst assumptions.
The request asked for interest with no circular reference. A model that charges interest on the closing balance refers to itself, because the balance includes the interest. Compound charged it on the opening balance plus half of the month’s draw, on an actual/360 basis, so each month depends only on the month before.
Construction loan balance at selected month ends
Closing balance. Costs are drawn through month 24. During lease-up the balance grows by the interest that property cash flow does not cover
Compound workbook, Monthly sheet, row 39. Interest at the one-month SOFR forward rate as of November 13, 2026 plus an assumed 3.00%.
The balance is $62,479,938 when construction ends. During lease-up, row 36 pays the interest that property cash flow can cover and row 37 adds the rest to the loan. Interest totals $11,151,682 over the life of the loan: cash flow pays $3,725,135 and $7,426,548 is capitalized. The construction-to-permanent loan page follows the same two-loan mechanics on an industrial project.
Lease-up and the operating pro forma to year 11
The building leases 20 units a month from month 25 and reaches 281 occupied units in month 39. Net operating income is $653,213 in year 3, $5,978,861 in year 4 and $6,304,422 in year 5, the first full stabilized year.
Stabilized occupancy is the metro’s vacancy turned around: 300 units less 6.3% is 93.7%. The pace of 20 net leases a month is an analyst assumption. The note ties it to Apartment List figures for the metro: 37.7 days from listing to lease, and 34.4% of properties offering at least one month free. Every lease-up lease in the model gets one month free.
Rent grows 0.63% a year for years 1 to 3, an equal blend of the ZORI change of 1.36% and Apartment List’s change of (0.1%). From year 4 it grows 2.75%, an analyst assumption. The two rent sources disagree on direction for this metro, and the agent’s answer says so.
Operating expenses are analyst assumptions by line. Real estate taxes are the largest at $3,400 per unit per year. Management is 3.0% of effective gross income, and expenses grow 3.0% a year.
| B | D | E | F | G | H | I | J | K | L | M | N | O | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4 | Model year | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Year 11 | Total |
| 5 | Year ending | Dec-27 | Dec-28 | Dec-29 | Dec-30 | Dec-31 | Dec-32 | Dec-33 | Dec-34 | Dec-35 | Dec-36 | Dec-37 | |
| 6 | Year-end occupied units | 0 | 0 | 240 | 281 | 281 | 281 | 281 | 281 | 281 | 281 | 281 | |
| 7 | Year-end occupancy | 0.0% | 0.0% | 80.0% | 93.7% | 93.7% | 93.7% | 93.7% | 93.7% | 93.7% | 93.7% | 93.7% | |
| 11 | Gross potential rent | - | - | 9,443,228 | 9,610,811 | 9,875,108 | 10,146,673 | 10,425,707 | 10,712,414 | 11,007,005 | 11,309,698 | 11,620,715 | 94,151,358 |
| 16 | Effective gross income ($) | - | - | 3,642,842 | 9,222,283 | 9,649,668 | 9,915,034 | 10,187,697 | 10,467,859 | 10,755,725 | 11,051,508 | 11,355,424 | 86,248,041 |
| 25 | Total operating expenses ($) | - | - | (2,989,629) | (3,243,422) | (3,345,246) | (3,444,880) | (3,547,483) | (3,653,143) | (3,761,953) | (3,874,004) | (3,989,396) | (31,849,157) |
| 26 | Net operating income ($) | - | - | 653,213 | 5,978,861 | 6,304,422 | 6,470,154 | 6,640,215 | 6,814,716 | 6,993,773 | 7,177,503 | 7,366,029 | 54,398,885 |
| 28 | Cash flow before debt service ($) | - | - | 557,732 | 5,880,516 | 6,203,126 | 6,365,819 | 6,532,750 | 6,704,027 | 6,879,763 | 7,060,074 | 7,245,076 | 53,428,883 |
| 33 | Construction interest capitalized | 165,438 | 3,519,500 | 3,698,006 | 43,603 | - | - | - | - | - | - | - | 7,426,548 |
| 34 | Permanent loan debt service | - | - | - | 2,489,126 | 4,978,253 | 4,978,253 | 4,978,253 | 4,978,253 | 4,978,253 | 4,978,253 | - | 32,358,641 |
| 42 | Property cash flow after debt service | - | - | (698,877) | 922,864 | 1,224,873 | 1,387,567 | 1,554,497 | 1,725,775 | 1,901,511 | 2,081,821 | - | 10,100,031 |
| 43 | Refinance (negative = extra equity) | - | - | - | (2,899,463) | - | - | - | - | - | - | - | (2,899,463) |
| 44 | Sale proceeds net of perm payoff | - | - | - | - | - | - | - | - | - | 64,386,985 | - | 64,386,985 |
| 45 | Levered net cash flow ($) | (39,784,617) | - | (698,877) | (1,976,599) | 1,224,873 | 1,387,567 | 1,554,497 | 1,725,775 | 1,901,511 | 66,468,806 | - | 31,802,936 |
The first lease-up months lose money. Net operating income is ($237,843) in month 25, when 20 units are occupied and the full staff and tax bill are running, and equity covers the deficit. The pro forma runs to year 11 because the building is sold at the end of year 10 and a buyer prices on the next twelve months of income.
Yield on cost and development spread
Untrended net operating income of $6,099,205 on a cost of $106,006,164 is a 5.75% yield on cost. The market cap rate is 5.64%, so the development spread is 11 basis points and the margin is 4.1%.
| B | C | D | |
|---|---|---|---|
| 4 | Value | Basis | |
| 13 | NOI AND YIELD | ||
| 14 | Untrended gross potential rent (today's rents) | $9,299,099 | |
| 15 | Untrended vacancy | ($587,500) | |
| 16 | Untrended concessions and bad debt | ($130,674) | |
| 17 | Untrended other income | $505,884 | |
| 18 | Untrended effective gross income | $9,086,809 | |
| 19 | Untrended operating expenses before management | ($2,715,000) | |
| 20 | Untrended management fee | ($272,604) | |
| 21 | Untrended stabilized NOI ($) | $6,099,205 | |
| 22 | Trended stabilized NOI, 12 months after refinance ($) | $6,222,816 | Forward 12 months of NOI after the refinance month |
| 23 | Untrended yield on cost | 5.75% | |
| 24 | Trended yield on cost | 5.87% | |
| 25 | Market cap rate (Washington DC multifamily) | 5.64% | |
| 26 | Development spread, untrended yield on cost less market cap rate (bps) | 11 | |
| 27 | Stabilized value at market cap rate (trended NOI) | $110,333,611 | |
| 28 | Development profit at stabilization | $4,327,447 | |
| 29 | Development margin (profit / total development cost) | 4.1% | |
| 65 | FLAGS | ||
| 66 | Development spread under 150 bps | FLAG | Spread of 11 bps against a 150 bps threshold |
| 67 | Refinance shortfall | FLAG | Perm loan falls $2,899,463 short of the construction payoff; funded as extra equity |
| 68 | Trended yield on cost below Vivmark's disclosed 6.2% | FLAG | Trended 5.87% vs Vivmark 6.2% |
| 69 | Untrended yield on cost below Vivmark's disclosed 6.2% | FLAG | Untrended 5.75% vs Vivmark 6.2% |
Untrended yield uses today’s rents and expenses at stabilized occupancy, and tells you whether the deal works if nothing improves. Trended yield uses the first twelve months after the refinance, when rents and expenses have grown: $6,222,816, or 5.87%.
The market cap rate is from a brokerage’s published report on Washington DC multifamily for the third quarter of 2026, which the agent found by web search and cited on the Sources sheet. Stabilized value is the trended income divided by that rate, $110,333,611, and development profit is that value less the cost.
Compound wrote two flags for the REIT comparison, one for each yield. Vivmark’s supplemental for the quarter, an exhibit to a Form 8-K, gives a weighted average projected net operating income of 6.2% of total capital cost across its development communities. The agent read the exhibit because the 10-Q does not state a yield, and the Sources sheet records that.
The subject's yield on cost against market rates
Percent. The yields are the model's results on stated assumptions. The cap rate and the REIT yield are cited. The permanent loan rate is the Treasury yield plus an assumed spread
Compound workbook, Summary and Assumptions sheets. Treasury par yield at the close of November 13, 2026.
The 10-year Treasury yields 5.15%, a finished building yields 5.64%, and this building yields 5.75% to its developer. Long-term debt costs 6.75%. To clear the request’s 150 basis points, the yield on cost would need to be 7.14% (our arithmetic: the cap rate plus 1.50%).
Permanent loan sizing and the refinance shortfall
The 1.25x coverage test sets the permanent loan at $63,961,701, below what the cost and value tests allow. After fees it repays all but $2,899,463 of the construction loan, and the model shows that amount as extra equity.
| B | C | D | |
|---|---|---|---|
| 31 | PERMANENT LOAN SIZING | ||
| 32 | Permanent loan rate (10-year Treasury + spread) | 6.75% | |
| 33 | Maximum loan by loan-to-cost | $68,904,007 | |
| 34 | Maximum loan by DSCR | $63,961,701 | |
| 35 | Maximum loan by loan-to-value | $71,716,847 | |
| 36 | Permanent loan, lowest of the three tests ($) | $63,961,701 | |
| 37 | Binding constraint | DSCR | Lowest of the loan-to-cost, DSCR and loan-to-value tests |
| 38 | Monthly payment | $414,854 | |
| 39 | Annual debt service | $4,978,253 | |
| 40 | Stabilized DSCR | 1.25x | |
| 41 | Stabilized debt yield | 9.7% | |
| 43 | REFINANCE | ||
| 44 | Construction loan payoff at refinance | $66,221,548 | |
| 45 | Permanent loan fees and closing costs | $639,617 | |
| 46 | Net permanent loan proceeds | $63,322,084 | |
| 47 | Refinance shortfall funded with extra equity | $2,899,463 | |
| 48 | Cash-out to equity at refinance | $0 | |
| 58 | RETURNS | ||
| 59 | Unlevered IRR (property, before debt) | 7.0% | |
| 60 | Levered IRR (equity, after debt) | 6.3% | |
| 61 | Equity multiple (levered) | 1.73x | |
| 62 | Levered profit ($) | $31,802,936 | |
| 63 | Unlevered profit ($) | $71,167,362 |
The permanent loan rate is the 10-year Treasury par yield of 5.15% at the close of November 13, 2026 plus an assumed 1.60% spread, which is 6.75%. It amortizes over 30 years.
Compound sized the loan three ways and took the smallest. Loan-to-cost at 65% allows $68,904,007 and loan-to-value at 65% allows $71,716,847. The coverage test asks how large a loan the trended income can pay 1.25 times over, and cell C34 solves it with a present value formula. Cell C37 names the binding test, and it reads “DSCR”.
Annual debt service on the sized loan is $4,978,253, which is 7.78% of the loan amount (our arithmetic). A building that yields 5.87% on cost cannot borrow much of that cost at that payment rate. The loan is 60.3% of total development cost (our arithmetic), and the debt yield is 9.7%.
The refinance is in month 42, three months after stabilization. The construction payoff is $66,221,548. The permanent loan, less $639,617 of closing costs, delivers $63,322,084, and the developer pays the difference.
That is why peak equity of $43,024,140 is above the $39,784,617 funded at the start. The gap is the shortfall plus $340,060 of net deficits during lease-up (our arithmetic: peak equity less initial equity less the shortfall). Those deficits are outside the $106,006,164 total cost that the yield on cost divides by.
Returns and the two sensitivity tables
The base case returns a 7.0% unlevered IRR, a 6.3% levered IRR and a 1.73x equity multiple over ten years. In the yield table, one of 25 cases reaches the yield that a 150 basis point spread requires.
Year-11 net operating income of $7,366,029 at a 5.90% exit cap rate gives a sale price of $124,847,941. The exit rate is an analyst assumption: the market rate plus about 25 basis points for a ten-year-old building. After sales costs and a loan payoff of $58,588,237, equity receives $64,386,985, and levered profit is $31,802,936.
The levered IRR is below the unlevered IRR because both loans cost more than the building earns. The agent’s answer puts it in one sentence: “Debt costs more than the property yields, so leverage lowers the return.”
The first table varies rent and hard cost and reports untrended yield on cost. Both tables are Excel data tables on the Assumptions sheet, linked to Summary.
| Rent factor (down) / hard cost factor (across) | 90% | 95% | 100% | 105% | 110% |
|---|---|---|---|---|---|
| 90% | 5.43% | 5.18% | 4.95% | 4.74% | 4.55% |
| 95% | 5.87% | 5.60% | 5.35% | 5.13% | 4.92% |
| 100% | 6.31% | 6.02% | 5.75% | 5.51% | 5.29% |
| 105% | 6.75% | 6.44% | 6.16% | 5.90% | 5.66% |
| 110% | 7.19% | 6.86% | 6.56% | 6.28% | 6.03% |
Across the middle row, hard cost moves the yield from 6.31% to 5.29%. Down the middle column, rent moves it from 4.95% to 6.56%. Rents 5% higher at today’s hard cost give 6.16%, just under the REIT’s 6.2%. The 7.14% that the spread threshold implies is reached in one corner only, at 7.19%, with rents 10% higher and hard cost 10% lower.
The second table varies rent and the exit cap rate and reports the levered equity multiple.
| Rent factor (down) / exit cap rate (across) | 5.40% | 5.65% | 5.90% | 6.15% | 6.40% |
|---|---|---|---|---|---|
| 90% | 1.40x | 1.31x | 1.22x | 1.14x | 1.06x |
| 95% | 1.67x | 1.56x | 1.45x | 1.35x | 1.26x |
| 100% | 2.00x | 1.86x | 1.73x | 1.62x | 1.51x |
| 105% | 2.34x | 2.18x | 2.04x | 1.91x | 1.78x |
| 110% | 2.66x | 2.49x | 2.34x | 2.19x | 2.06x |
The multiple runs from 1.06x to 2.66x. At the base exit rate it is 1.45x with rents 5% lower and 2.04x with rents 5% higher.
What public data cannot tell you about a development deal
Public data gives the market, a cost anchor and the price of debt. The site, the bid and the entitlement come from the land seller and the developer’s own team, and they decide how closely a real project resembles this one.
The agent’s summary lists what you would ask for to firm the numbers up:
- The land. The price, the entitlement status, the approved unit mix and unit sizes, and the parking ratio. The model’s $40,000 per unit and 850 square feet per unit stand in for these.
- The cost. A guaranteed maximum price bid or a contractor’s estimate by trade, which replaces the 65% hard cost share, the escalation and the trade split in one step.
- The site. Geotechnical and environmental reports, utilities, offsite work, impact fees, proffers and any affordable housing requirement.
- The operations. The jurisdiction’s approach to assessing a new building and its tax rate, an insurance quote and an operating budget.
- The rents. Lease-up comparables in the submarket with their concessions, in place of a metro index plus a 13% premium.
- The debt and the schedule. Term sheets for both loans and the contractor’s schedule, which replace the assumed spreads and the 24-month S-curve. The workbook has no line for a prepayment cost on the permanent loan at the sale.
Two public figures are preliminary: the October 2026 values of both BLS series are first prints. The adaptive reuse pro forma page takes the other route to new apartments, where the purchase price of an existing office building replaces the land and much of the structure line.
Our view: start with the spread
The verdict of this workbook is in one cell, the 11 basis points in Summary C26, and the other sheets explain it. We would read a development model in that order: yield on cost first, financing second.
The agent’s answer says the Washington DC deal “does not pencil at today’s costs and rates”, and the workbook supports that on its inputs. We would be careful about how far the conclusion travels. The land price, the hard cost share, the rent premium, both loan spreads and the exit cap rate are assumptions, and the rent rests on a premium calibrated to one REIT project.
What the model does establish is the size of the gap. A developer who likes this metro needs cheaper land, a lower bid or higher rents worth roughly 140 basis points of yield to meet the request’s threshold (our arithmetic: 150 less the 11 in the model).
The practical use is the second run. Every input sits on one sheet with its reason, so the first contractor estimate, the first term sheet and the first rent comps each replace a line, and the flags recompute.
Real estate development pro forma (Excel)Compound’s workbook from this run: a Summary with yields, loan sizing, returns, flags and two sensitivity tables, an Assumptions sheet with a source or reason beside every input, the development Budget, the 132-month Monthly cash flow, the Annual pro forma, the 50-metro Market Screen and a Sources sheet.Download · FreeFAQ
What is a real estate development pro forma?
It is a financial model of a building that does not exist yet. It sets out the cost to build, the timing of that spending, the construction and permanent loans, the lease-up, the operating income once the building is full, and the sale. Its main outputs are the yield on cost, the development spread and margin, the equity required and the returns.
How do you calculate yield on cost?
Divide stabilized net operating income by total development cost, including land, soft costs, fees and capitalized interest. In this model that is $6,099,205 over $106,006,164, or 5.75%, at today’s rents and expenses. The trended figure uses the income of the first stabilized year after rents and expenses have grown, and is 5.87%.
What is a development spread?
It is the yield on cost less the cap rate at which finished buildings trade, and it pays the developer for construction and lease-up risk. The request in this example asked for a flag below 150 basis points, and the model’s spread is 11. The right threshold for a project depends on its risk and is a judgment for the developer and its investors.
How do you calculate capitalized interest without a circular reference?
Charge each month’s interest on the opening balance plus half of that month’s draw. The opening balance is the prior month’s closing balance, so no cell depends on itself. Compound’s Monthly sheet does this in row 35 at the one-month SOFR forward rate plus a spread, and row 37 adds the unpaid interest to the next month’s balance.
How is the permanent loan sized on a new development?
The lender computes the largest loan under each of its tests and lends the smallest. This model uses 65% of cost, 65% of stabilized value and a 1.25x debt service coverage ratio. They give $68,904,007, $71,716,847 and $63,961,701, so coverage sets the loan.





