Real estate development pro forma: yield on cost 11 bps over cap rate

A development analyst asks Compound whether a new 300-unit apartment building pencils at today's costs and rates. Compound picks the metro from permit, rent and vacancy data, anchors hard cost on a REIT's 10-Q and builds the pro forma in Excel.

Compound Research · Updated Nov 15, 2026 · 14 min read

Short answer

A real estate development pro forma projects the cost, financing, lease-up and sale of a new building. Compound's model of a 300-unit mid-rise in the Washington DC metro costs $106.0 million and earns a 5.75% untrended yield on cost, 11 basis points above a 5.64% market cap rate, so every flag in the request trips.

Try it now
On this page (12)
  1. 1. What goes into a real estate development pro forma
  2. 2. Picking the market: permits, rents and vacancy across 50 metros
  3. 3. Hard cost per unit from a REIT development pipeline
  4. 4. The development budget: $353,354 per unit
  5. 5. Construction draw schedule: S-curve, equity first, capitalized interest
  6. 6. Lease-up and the operating pro forma to year 11
  7. 7. Yield on cost and development spread
  8. 8. Permanent loan sizing and the refinance shortfall
  9. 9. Returns and the two sensitivity tables
  10. 10. What public data cannot tell you about a development deal
  11. 11. Our view: start with the spread
  12. 12. FAQ

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.

Prompt to try

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

Try this prompt free →

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.

DC_Apartment_Development_Pro_Forma.xlsx
P11fx=M11/N11-1
BDNOMPSTXY
4RankMetroRecent peak (2021-25)Peak yearTTM Sep-26TTM vs peakYoYAL vacancy Oct-26Passes all threeREIT development under way in metro (Vivmark Q3 2026 10-Q)
73Chicago-Naperville-Elgin, IL-IN Metro Area8,12820224,536(44.2%)4.7%5.9%YesNone
117Washington-Arlington-Alexandria, DC-VA-MD-WV Metro Area23,799202212,057(49.3%)1.4%6.3%YesAvalon Dulles Innovation, Herndon VA (355 homes)
139Philadelphia-Camden-Wilmington, PA-NJ-DE-MD Metro Area25,42720216,498(74.4%)3.3%5.2%YesNone
1612Riverside-San Bernardino-Ontario, CA Metro Area7,34820232,965(59.6%)2.9%5.2%YesNone
1814Detroit-Warren-Dearborn, MI Metro Area3,22320252,078(35.5%)4.2%4.6%YesNone
1915Seattle-Tacoma-Bellevue, WA Metro Area20,321202112,436(38.8%)1.8%6.1%YesNone
2622Baltimore-Columbia-Towson, MD Metro Area3,74020222,108(43.6%)2.7%5.3%YesAVA Brewer's Hill, Baltimore (418); Avalon Townhome Collection Arundel Mills (90)
2824St. Louis, MO-IL Metro Area4,20220222,461(41.4%)4.1%6.4%YesNone
3026Portland-Vancouver-Hillsboro, OR-WA Metro Area6,75420223,157(53.3%)1.1%6.2%YesNone
3228Pittsburgh, PA Metro Area2,83120231,649(41.8%)3.5%6.2%YesNone
3632Columbus, OH Metro Area9,54920256,415(32.8%)2.9%6.4%YesNone
4137Virginia Beach-Chesapeake-Norfolk, VA-NC Metro Area2,67420231,580(40.9%)7.1%3.6%YesNone
4541Milwaukee-Waukesha, WI Metro Area2,01620241,351(33.0%)5.1%5.1%YesNone
4642Oklahoma City, OK Metro Area1,3342025398(70.2%)2.4%6.1%YesNone
56United States2.7%7.0%
SummaryAssumptionsBudgetMonthlyAnnualMarket ScreenSources
The Market Screen sheet as Compound wrote it, 10 of its 24 columns. We show the 14 metros that pass all three tests and the United States row, out of 50 metros. The formula bar shows cell P11, the Washington permit decline. The last column records whether the REIT's 10-Q lists a development under way in the metro.

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

202113,590202223,799202312,41920249,60620257,39212 months to September 202612,057

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

DC_Apartment_Development_Pro_Forma.xlsx
C14fx=C9*(1+C12)*C13
BCDEF
4Total ($)$ / unit$ / SF% of total
6HARD COST BUILD
7REIT total capital cost per unit (Avalon Dulles Innovation)$338,639
8Hard cost share of REIT total capital cost65%
9REIT hard cost per unit at construction start$220,116
10PPI inputs to multifamily construction, change since base month4.22%
11Construction average hourly earnings, change since base month1.99%
12Blended cost escalation to today3.33%
13Hard cost sensitivity factor100%
14Hard cost per unit, today ($)$227,443
30DEVELOPMENT BUDGET
31Land12,000,00040,00047.0611.3%
32Site work5,458,62518,19521.415.1%
33Structure20,469,84468,23380.2719.3%
34Envelope11,599,57938,66545.4910.9%
35Mechanical, electrical, plumbing17,058,20456,86166.8916.1%
36Finishes13,646,56345,48953.5212.9%
37Total hard costs ($)68,232,815227,443267.5864.4%
38Hard cost contingency3,411,64111,37213.383.2%
39Soft costs9,552,59431,84237.469.0%
40Soft cost contingency477,6301,5921.870.5%
41Furniture, fixtures and equipment1,050,0003,5004.121.0%
42Developer fee3,266,98710,89012.813.1%
43Total cost before financing ($)97,991,667326,639384.2892.4%
44Construction loan origination fee587,9501,9602.310.6%
45Capitalized interest7,426,54824,75529.127.0%
46Total development cost ($)106,006,164353,354415.71100.0%
SummaryAssumptionsBudgetMonthlyAnnualMarket ScreenSources
The Budget sheet, columns B to F, as Compound wrote them: the hard cost build in rows 7 to 14 and the development budget in rows 31 to 46. We leave out the rent build and the sources and uses. The formula bar shows cell C14, where the REIT's hard cost per unit is escalated to today.

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

Land$40,000Total hard costs$227,443Hard cost contingency$11,372Soft costs$31,842Soft cost contingency$1,592Furniture, fixtures and equipment$3,500Developer fee$10,890Construction loan origination fee$1,960Capitalized interest$24,755

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.

DC_Apartment_Development_Pro_Forma.xlsx
D35fx=(D33+D34/2)*D32*D8/Assumptions!$C$62*D11
BCDEOAAABACAPAS
4Month #Total12122425263942
5Period end dateJan-27Feb-27Dec-27Dec-28Jan-29Feb-29Mar-30Jun-30
15S-curve, cumulative % complete0.4%1.7%50.0%100.0%100.0%100.0%100.0%100.0%
25Total uses before interest ($)98,579,61715,329,2271,053,3435,387,6981,403,128----
27Equity funded (equity first)39,784,61715,329,2271,053,343------
28Construction loan draws58,795,000--5,387,6981,403,128----
311M SOFR forward (%)4.194.314.474.724.684.644.554.54
32All-in rate (SOFR + spread)7.19%7.31%7.47%7.72%7.68%7.64%7.55%7.54%
33Opening balance--11,156,89260,668,83662,479,93862,892,93866,221,54866,221,548
35Interest on average balance (actual/360)11,151,682--89,089407,974413,000373,636430,265416,058
36Interest paid from property cash flow3,725,135------430,265416,058
37Capitalized interest7,426,548--89,089407,974413,000373,636--
38Repayment at refinance66,221,548-------66,221,548
39Closing balance ($)--16,633,67962,479,93862,892,93863,266,57466,221,548-
42Occupied units0.00.00.00.020.040.0281.0281.0
60Net operating income ($)54,398,885----(237,843)(184,886)503,214511,028
SummaryAssumptionsBudgetMonthlyAnnualMarket ScreenSources
The Monthly sheet as Compound wrote it: the totals column and 8 of its 132 months (months 1, 2, 12, 24, 25, 26, 39 and 42), and 16 of its rows. The formula bar shows cell D35, interest on the opening balance plus half of the month's draw.

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

Month 9, construction$0.7MMonth 12, construction$16.6MMonth 15, construction$32.9MMonth 18, construction$47.1MMonth 21, construction$57.1MMonth 24, construction$62.5MMonth 30, lease-up$64.9MMonth 36, lease-up$66.2MMonth 41, lease-up$66.2M

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.

DC_Apartment_Development_Pro_Forma.xlsx
D26fx=SUMIFS(Monthly!$D$60:$EE$60,Monthly!$D$7:$EE$7,D$4)
BDEFGHIJKLMNO
4Model yearYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11Total
5Year endingDec-27Dec-28Dec-29Dec-30Dec-31Dec-32Dec-33Dec-34Dec-35Dec-36Dec-37
6Year-end occupied units00240281281281281281281281281
7Year-end occupancy0.0%0.0%80.0%93.7%93.7%93.7%93.7%93.7%93.7%93.7%93.7%
11Gross potential rent--9,443,2289,610,8119,875,10810,146,67310,425,70710,712,41411,007,00511,309,69811,620,71594,151,358
16Effective gross income ($)--3,642,8429,222,2839,649,6689,915,03410,187,69710,467,85910,755,72511,051,50811,355,42486,248,041
25Total 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)
26Net operating income ($)--653,2135,978,8616,304,4226,470,1546,640,2156,814,7166,993,7737,177,5037,366,02954,398,885
28Cash flow before debt service ($)--557,7325,880,5166,203,1266,365,8196,532,7506,704,0276,879,7637,060,0747,245,07653,428,883
33Construction interest capitalized165,4383,519,5003,698,00643,603-------7,426,548
34Permanent loan debt service---2,489,1264,978,2534,978,2534,978,2534,978,2534,978,2534,978,253-32,358,641
42Property cash flow after debt service--(698,877)922,8641,224,8731,387,5671,554,4971,725,7751,901,5112,081,821-10,100,031
43Refinance (negative = extra equity)---(2,899,463)-------(2,899,463)
44Sale proceeds net of perm payoff---------64,386,985-64,386,985
45Levered net cash flow ($)(39,784,617)-(698,877)(1,976,599)1,224,8731,387,5671,554,4971,725,7751,901,51166,468,806-31,802,936
SummaryAssumptionsBudgetMonthlyAnnualMarket ScreenSources
The Annual sheet as Compound wrote it, years 1 to 11 and the total, 15 of its rows. The formula bar shows cell D26: each year's net operating income is a sum over the Monthly sheet for that model year.

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

DC_Apartment_Development_Pro_Forma.xlsx
C26fx=(C23-C25)*10000
BCD
4ValueBasis
13NOI AND YIELD
14Untrended gross potential rent (today's rents)$9,299,099
15Untrended vacancy($587,500)
16Untrended concessions and bad debt($130,674)
17Untrended other income$505,884
18Untrended effective gross income$9,086,809
19Untrended operating expenses before management($2,715,000)
20Untrended management fee($272,604)
21Untrended stabilized NOI ($)$6,099,205
22Trended stabilized NOI, 12 months after refinance ($)$6,222,816Forward 12 months of NOI after the refinance month
23Untrended yield on cost5.75%
24Trended yield on cost5.87%
25Market cap rate (Washington DC multifamily)5.64%
26Development spread, untrended yield on cost less market cap rate (bps)11
27Stabilized value at market cap rate (trended NOI)$110,333,611
28Development profit at stabilization$4,327,447
29Development margin (profit / total development cost)4.1%
65FLAGS
66Development spread under 150 bpsFLAGSpread of 11 bps against a 150 bps threshold
67Refinance shortfallFLAGPerm loan falls $2,899,463 short of the construction payoff; funded as extra equity
68Trended yield on cost below Vivmark's disclosed 6.2%FLAGTrended 5.87% vs Vivmark 6.2%
69Untrended yield on cost below Vivmark's disclosed 6.2%FLAGUntrended 5.75% vs Vivmark 6.2%
SummaryAssumptionsBudgetMonthlyAnnualMarket ScreenSources
The Summary sheet, columns B to D, as Compound wrote them: the NOI and yield block in rows 14 to 29 and the four flag rows. The formula bar shows cell C26, the development spread in basis points.

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

10-year Treasury yield, November 13, 20265.15Market cap rate, Washington DC multifamily5.64Untrended yield on cost5.75Trended yield on cost5.87Yield the REIT projects for its development6.2Permanent loan rate6.75

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.

DC_Apartment_Development_Pro_Forma.xlsx
C34fx=PV(C32/12,Assumptions!$C$67*12,-C22/Assumptions!$C$69/12)
BCD
31PERMANENT LOAN SIZING
32Permanent loan rate (10-year Treasury + spread)6.75%
33Maximum loan by loan-to-cost$68,904,007
34Maximum loan by DSCR$63,961,701
35Maximum loan by loan-to-value$71,716,847
36Permanent loan, lowest of the three tests ($)$63,961,701
37Binding constraintDSCRLowest of the loan-to-cost, DSCR and loan-to-value tests
38Monthly payment$414,854
39Annual debt service$4,978,253
40Stabilized DSCR1.25x
41Stabilized debt yield9.7%
43REFINANCE
44Construction loan payoff at refinance$66,221,548
45Permanent loan fees and closing costs$639,617
46Net permanent loan proceeds$63,322,084
47Refinance shortfall funded with extra equity$2,899,463
48Cash-out to equity at refinance$0
58RETURNS
59Unlevered IRR (property, before debt)7.0%
60Levered IRR (equity, after debt)6.3%
61Equity multiple (levered)1.73x
62Levered profit ($)$31,802,936
63Unlevered profit ($)$71,167,362
SummaryAssumptionsBudgetMonthlyAnnualMarket ScreenSources
The Summary sheet, columns B to D, as Compound wrote them: permanent loan sizing in rows 32 to 41, the refinance in rows 44 to 48 and returns in rows 59 to 63. The formula bar shows cell C34, the largest loan whose payment the trended income covers 1.25 times.

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.40x1.31x1.22x1.14x1.06x
95%1.67x1.56x1.45x1.35x1.26x
100%2.00x1.86x1.73x1.62x1.51x
105%2.34x2.18x2.04x1.91x1.78x
110%2.66x2.49x2.34x2.19x2.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 · Free

FAQ

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.

CoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix ResearchCoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix ResearchCoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix Research

See this workflow on your own deal

Try it now