Bridge-to-perm multifamily model: coverage caps the refinance loan

An analyst sizing an equity raise asks Compound for a bridge-to-perm model on a real apartment property. Compound picks a 288-unit Houston property from CMBS loan-level filings and builds the renovation, the lease-up, the bridge loan, the refinance and the waterfall in three cases.

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

Short answer

A bridge-to-perm multifamily model carries an apartment purchase from a floating-rate bridge loan, through renovation and lease-up, to a permanent loan. In Compound's model of a 288-unit Houston property from CMBS filings, the base-case permanent loan is $20,404,654 against a $20,738,336 bridge payoff, and the levered IRR is 4.3%.

Try it now
On this page (11)
  1. 1. What goes into a bridge-to-perm multifamily model
  2. 2. The rent roll and the renovation budget by scope
  3. 3. Sources and uses: sizing the equity raise
  4. 4. Lease-up on an S-curve and the monthly NOI
  5. 5. The bridge loan: forward SOFR, a rate cap and the interest reserve
  6. 6. The refinance: three sizing tests against the bridge payoff
  7. 7. Base, upside and downside on one summary
  8. 8. The waterfall: return of capital, an 8% preferred return and three hurdles
  9. 9. What public data cannot tell you about a bridge-to-perm deal
  10. 10. Our view: the price has to carry the refinance
  11. 11. FAQ

The 1.25x coverage test sets the permanent loan in this model’s base case at $20,404,654. The bridge loan it has to repay, with the exit fee, is $20,738,336. The refinance in month 30 is $333,682 short, and $537,729 short once the new loan’s costs are paid. After the released reserve and that month’s property cash, equity adds $441,665, and the levered IRR over a 60-month hold is 4.3%, below the 8% preferred return the investors are owed first.

You work in acquisitions or asset management, and you are sizing an equity raise for an apartment property that needs renovation and lease-up before a permanent lender will lend on it. A bridge-to-perm multifamily model answers three questions in order: how much equity goes in at closing, whether the interest reserve lasts through lease-up, and whether the permanent loan repays the bridge loan when the property stabilizes. We asked Compound to build that model on a real property from public data, and it returned one Excel workbook and a summary.

The property, its income and its loan come from a public filing. The purchase price is an assumption set by the request: the lower of the latest appraised value and the loan balance. The renovation plan, the lease-up curve and both new loans are analyst assumptions, and the sheet labels each one. The returns below are neither a forecast for this property nor advice to buy, sell or lend on it.

What the workbook shows:

  • The coverage test sets the permanent loan, and it lands just under the payoff. At a 6.75% rate and a 1.25x minimum, $1,985,163 of trailing net operating income supports $20,404,654. The loan-to-value test would allow $22,127,612.
  • Equity at closing is $10,184,534, which is 33.0% of total uses. The base case adds $441,665 at the refinance. The downside case contributes $19,093,007 in total.
  • Leverage lowers the base-case return. The unlevered IRR is 7.2% and the levered IRR is 4.3%. The bridge loan costs 7.75% once SOFR reaches the cap strike, against a yield on cost of 6.66%.

Each input on the Assumptions sheet carries a citation, the word “Request”, or the words “analyst assumption” with a reason. The property comes from CMBS loan-level filings, which trusts file on Form ABS-EE with SEC EDGAR. Metro rent comes from the Zillow Observed Rent Index (ZORI) and from Apartment List, and metro vacancy from Apartment List. The bridge loan floats over Compound’s SOFR forward curve, and the permanent rate starts from the Daily Treasury Par Yield Curve. Two figures came from the web: the metro median rent from Apartment List’s Houston rent report for November 2026, and the Houston multifamily cap rate from Matthews’ Houston multifamily market report for Q2 2026.

Prompt to try

“I am sizing the equity raise for a distressed apartment deal and want a bridge-to-perm multifamily model built on a real property. From the CMBS loan-level filings, pick one apartment property of roughly 150 to 400 units in Texas or Florida that is in trouble: occupancy below 80% or a DSCR below 1.0x in its latest report, which also gives units, revenue, operating expenses, net operating income, appraised value and the loan balance, rate and maturity. Use it as the subject and set the purchase price at the lower of its latest appraised value and the outstanding loan balance. Build a rent roll that tags units by renovation scope (none, light, medium, heavy) as an analyst assumption, with a budget per scope, a contingency and a monthly draw curve. Set in-place rent from reported revenue, renovated market rent from Zillow ZORI and Apartment List rent for the metro, and the lease-up target from Apartment List vacancy for the metro, on an S-curve with a start occupancy, target occupancy, inflection month and steepness. Price a floating-rate bridge loan off the SOFR forward curve plus a spread, with loan-to-cost, a renovation holdback, a rate cap, extension options with fees and a DSCR test, and a permanent loan off the 10-year Treasury yield, sized to the lowest of loan-to-value, a 1.25x DSCR and a loan cap. Build: sources and uses; the monthly draw schedule; the bridge loan with an interest reserve sized from the cumulative shortfall plus a buffer; the refinance; lease-up and operating cash flow monthly for 36 months and annual after that; a waterfall with return of capital, an 8% compounding preferred return, a GP catch-up and three IRR hurdles; and base, upside and downside cases as full assumption sets on one summary. Report levered IRR, equity multiple, cash-on-cash, peak equity, refinance proceeds, yield on cost against the market cap rate, LP and GP returns, the promote, and the number of months that fail the reserve test. Flag a refinance that does not repay the bridge loan, a lease-up target above the metro's occupancy, and a downside case where the reserve runs out. 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 →

What goes into a bridge-to-perm multifamily model

The facts about the property and its loan come from one CMBS filing, and the request sets the price rule. Everything about the renovation, the lease-up and the two new loans is an analyst assumption with a stated reason.

Compound picked Providence at Champions, at 5100 FM 1960 Rd W in Houston, loan 20 in the Benchmark 2025-V18 Mortgage Trust. The figures are from the trust’s Form ABS-EE for the reporting period ended October 13, 2026, filed October 27, 2026. The filing reports 288 units built in 1979. For the 12 months to March 31, 2026 it reports revenue of $3,562,800, operating expenses of $1,865,511 and net operating income of $1,697,289, with physical occupancy of 92.0%.

The request asked for a property with occupancy below 80% or a debt service coverage ratio below one. This one meets the second test. The filing reports annual debt service of $1,784,750, which is $87,461 more than net operating income (our arithmetic), and a coverage ratio of 0.95x. It also reports a loan balance of $27,500,000 at a fixed 6.49% and a maturity date of June 6, 2030. The appraised value in the filing is $25,400,000 as of August 21, 2026, against $42,700,000 at securitization. That is 40.5% lower (our arithmetic).

Providence_at_Champions_Bridge_to_Perm.xlsx
D27fx=MIN($D$18,$D$21)
BCDG
5InputUnitBaseSource / basis
7SUBJECT PROPERTY (CMBS LOAN-LEVEL DATA)
8Property (5100 FM 1960 Rd W, Houston, TX 77069, Harris County)Providence at ChampionsBenchmark 2025-V18 Mortgage Trust, Form ABS-EE for the period ended Oct 13, 2026 (loan 20)
9Unitsunits288Benchmark 2025-V18 ABS-EE, Oct 2026 report
10Year builtyear1979Benchmark 2025-V18 ABS-EE, Oct 2026 report
11Latest physical occupancy%92.0%Benchmark 2025-V18 ABS-EE, Oct 2026 report (financials to Mar 31, 2026)
12Financials period enddateMar 31, 2026Benchmark 2025-V18 ABS-EE, Oct 2026 report (T12 Apr 2025 to Mar 2026)
13T12 revenue$$3,562,800Benchmark 2025-V18 ABS-EE, Oct 2026 report
14T12 operating expenses$$1,865,511Benchmark 2025-V18 ABS-EE, Oct 2026 report
15T12 net operating income$$1,697,289Benchmark 2025-V18 ABS-EE, Oct 2026 report
16Latest annual debt service$$1,784,750Benchmark 2025-V18 ABS-EE, Oct 2026 report
17Latest DSCR (NOI)x0.95xBenchmark 2025-V18 ABS-EE, Oct 2026 report
18Latest appraised value (MAI)$$25,400,000Benchmark 2025-V18 ABS-EE, Oct 2026 report
19Appraisal datedateAug 21, 2026Benchmark 2025-V18 ABS-EE, Oct 2026 report
20Appraised value at securitization$$42,700,000Benchmark 2025-V18 ABS-EE, Oct 2026 report (Apr 2025 appraisal)
21Outstanding loan balance$$27,500,000Benchmark 2025-V18 ABS-EE, Oct 2026 report
22Loan interest rate (fixed)%6.49%Benchmark 2025-V18 ABS-EE, Oct 2026 report
23Loan maturitydateJun 6, 2030Benchmark 2025-V18 ABS-EE, Oct 2026 report
24Transferred to special servicingdateJun 30, 2026Benchmark 2025-V18 ABS-EE, Oct 2026 report
26ACQUISITION
27Purchase price (lower of appraisal and loan balance)$$25,400,000Request: lower of latest appraised value and outstanding loan balance
28Closing datedateDec 31, 2026analyst assumption: a year-end close leaves about six weeks to sign and close after the Nov 2026 data
29Closing costs% of price1.5%analyst assumption: title, legal, third-party reports and transfer costs typical for a Texas apartment trade
SummaryAssumptionsSourcesRent RollS&UModel_BaseModel_UpsideModel_DownsideAnnual CF
The subject and acquisition blocks of the Assumptions sheet, columns B, C, D and G, as Compound wrote them. We leave out the Upside and Downside columns, which repeat the Base values on these rows. Blue figures are inputs and shaded cells are analyst assumptions. The formula bar shows the price rule from the request.

The price rule gives $25,400,000, or $88,194 per unit, because the appraisal is the lower of the two figures by $2,100,000 (our arithmetic). On filed net operating income that is a 6.68% going-in cap rate. The price is below the $27,500,000 loan balance, and the model does not test whether a sale at that price can repay the loan in place.

The market inputs follow the request. Renovated market rent for the metro is $1,370 a month, the average of ZORI’s multifamily reading of $1,410 for September 2026 and Apartment List’s median of $1,330. Both sources show rents falling over the past year, by 0.6% and 1.9%. Apartment List’s metro vacancy of 8.4% for October 2026 gives a lease-up target of 91.6% occupancy. The market cap rate is 6.28%.

The rent roll and the renovation budget by scope

The rent roll tags 230 of 288 units for renovation and prices the work at $4,078,800 with contingency. The tags and the cost per unit are analyst assumptions, since a CMBS filing has no unit-level data.

The filing gives total revenue and one occupancy figure. Compound backs into an in-place rent of $1,031 per occupied unit: revenue, less an assumed 8.0% share of other income, over 288 units at 92.0% occupancy for 12 months. Every one of the 288 unit rows carries that same in-place rent. The scope tags split the units 58 with no work, 86 light, 86 medium and 58 heavy.

Providence_at_Champions_Bridge_to_Perm.xlsx
C6fx=COUNTIF($C$14:$C$301,B6)
BCDEFGHIJ
5ScopeUnits% of unitsIn-place rentRenovated rent, BaseRenovated rent, UpsideRenovated rent, DownsideCost per unit, BaseBudget, Base (before contingency)
6None5820.1%$1,031$1,031$1,031$1,031--
7Light8629.9%$1,031$1,164$1,192$1,123$6,000$516,000
8Medium8629.9%$1,031$1,260$1,301$1,219$12,000$1,032,000
9Heavy5820.1%$1,031$1,370$1,411$1,315$20,000$1,160,000
10Total288100.0%$1,031$1,208$1,236$1,172$9,403$2,708,000
13UnitScopeIn-place rentRenovated rent, BaseRent premiumRenovation cost, BaseDowntime (months)
141None$1,031$1,031--0
7259Light$1,031$1,164$134$6,0001
158145Medium$1,031$1,260$229$12,0001
244231Heavy$1,031$1,370$339$20,0002
301288Heavy$1,031$1,370$339$20,0002
SummaryAssumptionsSourcesRent RollS&UModel_BaseModel_UpsideModel_DownsideAnnual CF
The Rent Roll sheet as Compound wrote it: the scope summary in rows 5 to 10 and five of the 288 unit rows below it, one from each scope and the last row. Green figures link to another sheet. The formula bar shows the unit count for a scope, which counts the tags in the unit rows.

Renovated rent is a share of the $1,370 metro rent by scope: 85.0% for light, 92.0% for medium and 100.0% for heavy in the base case. That gives $1,164, $1,260 and $1,370. Across all 288 units, including the 58 left alone, the blended rent after renovation is $1,208. That is $177 above in-place rent, or 17.1% (our arithmetic).

The budget is $6,000, $12,000 and $20,000 per unit by scope, which totals $2,708,000 for the units. A $1,000,000 allowance for common areas and exteriors and a 10.0% contingency bring it to $4,078,800, or $14,163 per unit across the property. The draw curve is a bell shape over 18 months in the base case, 15 in the upside case and 24 in the downside case (our counts).

Sources and uses: sizing the equity raise

Total uses are $30,819,694 and the bridge loan funds $20,635,160 of it, so equity at closing is $10,184,534. The split is $9,166,081 from limited partners and $1,018,453 from the general partner.

Providence_at_Champions_Bridge_to_Perm.xlsx
C12fx=Model_Base!$D$104*(1+Assumptions!$D$101)
BCDE
5$$ per unit% of total
6USES
7Purchase price$25,400,000$88,19482.4%
8Closing costs$381,000$1,3231.2%
9Renovation budget (incl. contingency)$4,078,800$14,16313.2%
10Bridge origination fee$206,352$7160.7%
11Rate cap$206,352$7160.7%
12Interest reserve (Base cumulative shortfall + buffer)$547,191$1,9001.8%
13Total uses ($)$30,819,694$107,013100.0%
15SOURCES
16Bridge loan, initial funding$16,556,360$57,48753.7%
17Bridge loan, renovation holdback (future funding)$4,078,800$14,16313.2%
18Equity at close$10,184,534$35,36333.0%
19Total sources ($)$30,819,694$107,013100.0%
20Check: sources less uses-
22MEMO
23Bridge loan commitment$20,635,160
24LP equity at close$9,166,081
25GP equity at close$1,018,453
26Bridge commitment / appraised value81.2%
27Bridge commitment / (price + renovation)70.0%
28Going-in cap rate on T12 NOI6.7%
SummaryAssumptionsSourcesRent RollS&UModel_BaseModel_UpsideModel_DownsideAnnual CF
The S&U sheet, columns B to E, as Compound wrote it. The formula bar shows the interest reserve: the base case's cumulative shortfall on the model sheet, plus the buffer on the Assumptions sheet.

The bridge loan is 70.0% of the purchase price plus the renovation budget. The lender funds $16,556,360 at closing and holds back $4,078,800, the full renovation budget, to fund as work is done. Because the loan is sized on cost, the commitment is 81.2% of the latest appraised value.

The loan’s origination fee and the rate cap each cost $206,352, which is 1.0% of the commitment. The interest reserve is $547,191. Compound sized it the way the request asked: the base case’s cumulative monthly shortfall of $475,818 plus a 15.0% buffer. The reserve and the loan are set once on the base case and held for all three cases. A case that needs more calls it from equity, month by month.

Equity contributed, at closing and over the hold

US dollars. Equity at closing is the same in every case. Later contributions are capital calls at the refinance, for reserve shortfalls and for cost overruns

Equity at close, every case$10,184,534Upside: total equity contributed$10,184,534Base: total equity contributed$10,626,199Downside: total equity contributed$19,093,007

Compound workbook, S&U sheet and Summary sheet (total equity contributed).

The base case needs $10,626,199, of which $441,665 arrives at the refinance. The downside case needs $8,908,473 after closing (our arithmetic).

Lease-up on an S-curve and the monthly NOI

Net operating income falls before it rises: $97,989 in month 1, $89,343 in month 6, $165,711 in month 30. Model year 1 is 31.3% below the filed trailing figure (our arithmetic), because the model starts at 85.0% occupancy and takes units offline.

Occupancy follows a logistic curve with four inputs, as the request specified. The base case starts at 85.0%, targets 91.6%, has its inflection in month 9 and uses a steepness of 0.35 per month. The start figure is an analyst assumption below the 92.0% in the filing.

Providence_at_Champions_Bridge_to_Perm.xlsx
F52fx=Assumptions!$D$56+(Assumptions!$D$58-Assumptions!$D$56)*(F51-$D$51)/(1-$D$51)
BFHKNQTWACADAI
6Month1369121518242530
7Period endJan-27Mar-27Jun-27Sep-27Dec-27Mar-28Jun-28Dec-28Jan-29Jun-29
40Total renovation spend ($)19,986134,193296,529375,250334,869193,33519,986---
47Renovated units completed0.04.334.388.7151.4202.7227.8230.0230.0230.0
48Units offline for renovation1.18.620.326.324.014.42.20.00.00.0
52Physical occupancy85.1%85.5%86.5%88.2%89.8%90.9%91.4%91.6%91.6%91.6%
54Occupied units244.2238.8231.6230.8237.2248.6261.1263.8263.8263.9
59In-place rent1,0311,0311,0311,0311,0311,0371,0441,0571,0591,070
66Gross potential rent ($)295,738288,826283,186288,799305,022328,453349,203356,478357,212360,906
67(-) Vacancy(44,028)(41,964)(38,201)(34,143)(30,976)(29,942)(30,189)(29,932)(29,956)(30,190)
72Effective gross income ($)259,918254,912252,974262,959282,982308,245329,417337,194337,928341,501
75(-) Operating expenses excl. management(154,131)(154,893)(156,042)(157,199)(158,365)(159,539)(160,723)(163,116)(163,518)(165,544)
76Net operating income ($)97,98992,37289,34397,872116,128139,458158,812163,962164,272165,711
80Trailing 3-month NOI, annualized1,175,8651,142,3581,075,0781,129,7501,314,3351,580,3111,835,3521,963,5661,967,4861,985,163
SummaryAssumptionsSourcesRent RollS&UModel_BaseModel_UpsideModel_DownsideAnnual CF
Fourteen rows of the Model_Base sheet for 10 of its monthly columns, as Compound wrote them. We chose the months and left out the other rows in the operating block. The formula bar shows physical occupancy in month 1: the start occupancy plus the rescaled logistic curve times the gap to the target.

Occupancy rises from 85.1% to 89.8%, and up to 26.3 units are offline in month 9. Occupied units drop from 244.2 in month 1 to 230.8 in month 9. Rent growth is 0.0% in year 1, so rent rises only as renovated units return at the higher rent. The model adds $300 per unit per year to filed expenses for insurance and taxes and grows them at 3.0% a year.

Net operating income: the filed figure and the base case by year

US dollars. The filed figure is the trailing 12 months in the CMBS report. Model years run from the December 31, 2026 closing

Filed trailing 12 months to Mar 31, 2026$1,697,289Model year 1 (months 1 to 12)$1,165,380Model year 2$1,831,880Model year 3$1,990,096Model year 4$2,030,212Model year 5$2,070,729Year 6 (the sale is priced on this)$2,111,946

Compound workbook, Assumptions (filed net operating income), Model_Base (next-12-month NOI at months 0, 12 and 60), Summary and Annual CF sheets.

Year 3 net operating income is $1,990,096, which is 17.3% above the filed figure (our arithmetic). The multifamily value-add pro forma on this site tracks a unit-per-month renovation schedule under permanent debt from day one.

The bridge loan: forward SOFR, a rate cap and the interest reserve

The bridge rate is 7.44% in month 1 and 7.75% in each of the 25 months when forward SOFR is above the 4.50% cap strike (our count). The bridge DSCR is below 1.00x in 15 months, and the reserve pays the shortfalls.

The loan floats at one-month SOFR plus 3.25%. Compound’s forward curve as of the November 13, 2026 close runs from 4.19% for January 2027 to a peak of 4.96% in August 2028. A cap struck at 4.50% limits the rate, and the model charges interest on an actual/360 basis on the balance as the holdback is drawn.

Providence_at_Champions_Bridge_to_Perm.xlsx
F99fx=IF(F12=1,F80/((F88+F90)*F87),0)
BFHKNQTWACADAI
6Month1369121518242530
83BRIDGE LOAN
84SOFR 1M forward (floored, case shift)4.19%4.37%4.63%4.70%4.47%4.73%4.87%4.72%4.68%4.55%
86SOFR after cap4.19%4.37%4.50%4.50%4.47%4.50%4.50%4.50%4.50%4.50%
87All-in bridge rate7.44%7.62%7.75%7.75%7.72%7.75%7.75%7.75%7.75%7.75%
88Opening balance16,556,36016,650,98817,227,32318,220,51019,332,79920,213,00420,615,17420,635,16020,635,16020,635,160
90(+) Holdback draws19,986134,193296,529375,250334,869193,33519,986---
92Closing balance ($)16,576,34616,785,18117,523,85118,595,76019,667,66920,406,33920,635,16020,635,16020,635,160-
93(-) Interest (actual/360)(106,242)(110,117)(113,175)(120,098)(130,738)(136,184)(133,269)(137,711)(137,711)(133,269)
96(-) Extension fee--------(51,588)-
97(-) Replacement rate cap--------(103,176)-
99DSCR, T3 NOI / annualized interest0.95x0.89x0.79x0.78x0.87x1.00x1.15x1.23x1.23x1.24x
102INTEREST RESERVE
103Cash flow after bridge debt service(15,471)(24,999)(31,139)(29,587)(22,026)(4,197)18,01618,613(135,860)24,690
104Shortfall; D = cumulative shortfall15,47124,99931,13929,58722,0264,197--135,860-
105Reserve, opening547,191521,755437,001334,980251,609211,430207,233207,233207,23371,373
107(-) Draws to cover shortfall(15,471)(24,999)(31,139)(29,587)(22,026)(4,197)--(135,860)-
109Reserve, closing ($)531,720496,756405,862305,393229,583207,233207,233207,23371,373-
110Uncovered shortfall (equity call)----------
SummaryAssumptionsSourcesRent RollS&UModel_BaseModel_UpsideModel_DownsideAnnual CF
The bridge loan and interest reserve blocks of the Model_Base sheet for the same 10 months, as Compound wrote them. We left out the rows that hold only a total or a switch. The formula bar shows the bridge DSCR in month 1: trailing three-month net operating income, annualized, over a year of interest at the month's balance and rate.

The bridge DSCR starts at 0.95x, reaches a low of 0.78x in month 8 and first clears the 1.00x test in month 16 (our reading of the row). The Summary counts 15 months below the test in the base case. The reserve covers the shortfalls and falls from $547,191 to $207,233 by month 24.

Then the initial 24-month term ends. The model takes the first of two 12-month extensions in month 25 and charges an extension fee of $51,588 and a replacement rate cap of $103,176. Those two costs produce a $135,860 shortfall in that month, and the reserve drops to $71,373.

Check the extension condition against your own loan agreement. The Assumptions sheet describes the 1.00x test as the condition for an extension, and the model reports it as a count of months. In the downside case the ratio is 0.82x in month 24 and the model extends the loan. The Summary flag “Bridge needs more extensions than available” compares only the number of extensions used with the two available, so its OK in all three cases does not mean the 1.00x condition was met.

The refinance: three sizing tests against the bridge payoff

The permanent loan is the lowest of three limits, and in the base case the 1.25x coverage test is lowest at $20,404,654. The payoff is $20,738,336, so the refinance does not repay the bridge loan and the Summary flags it.

Providence_at_Champions_Bridge_to_Perm.xlsx
D121fx=$D$115/Assumptions!$D$109/$D$119
BCD
114REFINANCE INTO PERMANENT LOAN
115T3 NOI annualized at refinance$1,985,163
116Refinance valuation cap rate%6.28%
117Refinance value$31,610,875
118Perm interest rate%6.75%
119Annual debt constant%7.78%
120Loan by LTV$22,127,612
121Loan by DSCR$20,404,654
122Loan cap$25,000,000
123Permanent loan ($)$20,404,654
124Binding constraintDSCR
125(-) Perm financing costs$(204,047)
126(-) Bridge payoff incl. exit fee$(20,738,336)
127Net refinance proceeds to equity ($)$(537,729)
SummaryAssumptionsSourcesRent RollS&UModel_BaseModel_UpsideModel_DownsideAnnual CF
The refinance block of the Model_Base sheet, columns B to D, as Compound wrote it. Green figures link to the Assumptions sheet. The formula bar shows the DSCR test: net operating income over the minimum coverage and the loan's annual debt constant.

The refinance happens in month 30, after the renovation ends and occupancy flattens. Trailing three-month net operating income, annualized, is $1,985,163. At the 6.28% market cap rate the property is worth $31,610,875, and 70.0% of that is $22,127,612. That cap rate is 40 basis points below the 6.68% that the filed appraisal implies on filed income (our arithmetic). The permanent rate is the 10-year Treasury yield of 5.15% on November 13, 2026 plus a 1.60% spread, or 6.75%. With 30-year amortization the annual debt constant is 7.78%, and the 1.25x test allows $20,404,654.

The loan is 64.5% of the refinance value (our arithmetic), so the value limit has room and income sets the loan. The payoff is the full $20,635,160 commitment plus a 0.5% exit fee. After $204,047 of costs on the new loan, the refinance is $537,729 short. The $71,373 left in the interest reserve is released and the property’s cash after bridge interest that month is $24,690, so equity contributes $441,665.

Permanent loan proceeds against the bridge payoff

US dollars. The three base-case sizing limits, the payoff, and the permanent loan in the other two cases

Base: loan cap$25,000,000Base: loan by LTV, 70% of refinance value$22,127,612Bridge payoff with exit fee, every case$20,738,336Base: loan by DSCR at1.25x (the permanent loan)$20,404,654Upside: permanent loan, set by DSCR$24,671,849Downside: permanent loan, set by LTV$14,310,747

Compound workbook, refinance blocks of the Model_Base, Model_Upside and Model_Downside sheets.

For the coverage test alone to cover the payoff and the new loan’s costs, the loan would need to be about $20.95 million and trailing net operating income about $2.04 million, which is 2.7% above the base case (our arithmetic). In the upside case, income of $2,375,769 at month 27 supports $24,671,849 and returns $3,686,795 to equity. In the downside case the loan-to-value test binds. A 65.0% limit on a $22,016,533 value gives $14,310,747, and the equity pays $6,570,697 in month 40.

The construction-to-permanent loan model on this site isolates the same takeout question for a warehouse development.

Base, upside and downside on one summary

The three cases are full assumption sets, and the levered IRR runs from 22.6% to a loss of 23.2% with the base at 4.3%. The base case’s yield on cost of 6.66% is 38 basis points above the market cap rate and below the cost of both loans.

Each case has its own column on the Assumptions sheet. These are the main inputs that differ.

InputBaseUpsideDownside
Renovated rent, light scope (% of metro market rent)85.0%87.0%82.0%
Renovated rent, medium scope (% of metro market rent)92.0%95.0%89.0%
Renovated rent, heavy scope (% of metro market rent)100.0%103.0%96.0%
Rent growth, year 10.0%1.5%(1.5%)
Rent growth, year 2 onward2.5%3.0%1.5%
Concessions3.0%2.0%4.0%
Start occupancy85.0%88.0%80.0%
Target occupancy91.64%92.64%88.64%
Inflection month9714
Steepness0.350.450.25
Cost overrun0.0%0.0%15.0%
Operating expense adjustment$300-$450
Spread over SOFR3.25%3.00%3.75%
SOFR curve shift0.00%(0.25%)1.00%
Perm spread over 10-year Treasury1.60%1.50%1.90%
Perm interest rate6.75%6.65%7.05%
Maximum loan-to-value70.0%70.0%65.0%
Refinance valuation cap rate vs market0.00%(0.10%)0.50%
Refinance month302740
Hold period606072
Exit cap rate vs market0.25%0.00%0.75%

The Summary reads all three model sheets.

MeasureBaseUpsideDownside
Levered IRR (all equity)4.3%22.6%(23.2%)
Equity multiple1.22x2.35x0.33x
Cash-on-cash, year 31.4%3.5%(2.8%)
Cash-on-cash, average over hold1.3%4.1%(1.5%)
Peak equity$10,382,238$10,184,534$19,093,007
Total equity contributed$10,626,199$10,184,534$19,093,007
Profit to equity$2,333,275$13,704,626($12,791,340)
Unlevered IRR (property level)7.2%13.8%(2.2%)
Hold period606072
Refinance month302740
T3 NOI annualized at refinance$1,985,163$2,375,769$1,492,721
Refinance value$31,610,875$38,442,865$22,016,533
Perm loan rate6.75%6.65%7.05%
Refinance proceeds (permanent loan)$20,404,654$24,671,849$14,310,747
Binding sizing constraintDSCRDSCRLTV
Bridge payoff incl. exit fee$20,738,336$20,738,336$20,738,336
Net refinance proceeds to equity($537,729)$3,686,795($6,570,697)
Year 3 NOI$1,990,096$2,405,802$1,497,273
Total project cost (price + closing + renovation)$29,859,800$29,859,800$30,471,620
Yield on cost (year 3 NOI / project cost)6.66%8.06%4.91%
Yield on cost less market cap rate38178(137)
LP IRR4.3%18.2%(23.2%)
GP IRR (co-invest + promote)4.3%46.5%(23.2%)
GP promote-$3,791,119-
Months not passing the reserve test0031
Months not passing the bridge DSCR test15340
Bridge extensions used112
Lease-up target occupancy91.6%92.6%88.6%

Yield on cost against the cap rate and the cost of debt

Percent. Yield on cost is year 3 net operating income over purchase price, closing costs and renovation spend

Downside: yield on cost4.91Market cap rate, Houston multifamily6.28Base: yield on cost6.66Going-in cap rate on filed NOI6.68Base: permanent loan rate6.75Base: bridge rate with SOFR at the cap strike7.75Base: permanent loan debt constant7.78Upside: yield on cost8.06

Compound workbook, Summary sheet and Model_Base sheet. The market cap rate is from Matthews' Houston multifamily market report for Q2 2026.

A value-add deal works when the yield on cost ends well above both the market cap rate and the cost of debt. Here the yield on cost is 6.66%. The permanent rate is 6.75%, which is 9 basis points higher, and the debt constant that the coverage test uses is 7.78%, which is 112 basis points higher (our arithmetic).

In month 60 the model values the property on the next 12 months of net operating income, $2,111,946, at a 6.53% exit cap rate, for $32,342,207. If the exit rate also carried the 40 basis points between the market report and the appraisal, the price would be about $30.47 million, or $1.88 million lower (our arithmetic). After selling costs, the loan repayment and a prepayment cost, equity receives $11,826,470. Profit over five years is $2,333,275 on $10,626,199 contributed, a 1.22x multiple.

The Summary carries these flags, each a formula.

FlagBaseUpsideDownside
Refinance does not repay the bridge loanFLAGOKFLAG
Refinance shortfall funded by equity$333,682-$6,427,589
Lease-up target above metro occupancyOKFLAGOK
Interest reserve runs outOKOKFLAG
Bridge needs more extensions than availableOKOKOK

The upside case’s lease-up target of 92.6% is above the metro’s 91.6% occupancy, which the request asked Compound to flag. The downside case holds the sale to month 72 and sells for $20,217,016 at a 7.03% cap rate, $5,182,984 below the purchase price (our arithmetic).

The waterfall: return of capital, an 8% preferred return and three hurdles

In the base case every dollar goes to return of capital and preferred return, and the preferred return is only 49% paid (our arithmetic). The general partner earns a promote only in the upside case, where it is $3,791,119.

The waterfall runs monthly on the levered cash flow, in the order the request set: return of capital, an 8% preferred return compounded monthly, a catch-up to the general partner, then three tiers at investor IRR hurdles of 12%, 15% and 20%. Equity is 90% limited partner and 10% general partner co-investment.

Waterfall line, column D totalBaseUpsideDownside
Contributions$10,626,199$10,184,534$19,093,007
Distributable cash$12,959,475$23,889,160$6,301,667
Return of capital$10,626,199$10,184,534$6,301,667
Preferred return paid$2,333,275$3,421,064$0
GP catch-up$0$855,266$0
Tier 1 split, to the 12% hurdle$0$2,791,514$0
Tier 2 split, to the 15% hurdle$0$2,771,629$0
Tier 3 split, to the 20% hurdle$0$3,865,153$0
Residual split above the 20% hurdle$0$0$0
GP promote$0$3,791,119$0

In the base case the sale pays back the last $9,526,629 of capital and leaves $2,333,275 for the preferred return. Another $2,391,432 of accrued preferred return stays unpaid. There is no catch-up and no promote, so the limited partners and the general partner both earn 4.3%.

In the upside case $23,889,160 is distributed. After capital and $3,421,064 of preferred return, the general partner’s catch-up takes $855,266, and the three tiers split the rest. The limited partners earn 18.2% and the general partner earns 46.5%, with 35% of the profit on 10% of the equity (our arithmetic).

A real estate equity waterfall with investor classes and a clawback test is a model of its own, and private equity returns covers carried interest at the fund level.

What public data cannot tell you about a bridge-to-perm deal

A CMBS filing gives one property’s totals as of a reporting date. The seller holds the unit-level and loan-level documents that would replace the assumptions this model labels, and Compound’s summary lists them.

  • A unit-level rent roll. Lease dates, actual rents, concessions and delinquency by unit would replace the single $1,031 in-place rent and show which units are vacant today.
  • Operating statements by line item. Trailing 12-month and trailing 3-month statements would replace the 8.0% other income share and the $300 per unit expense adjustment, and would show current occupancy against the 85.0% the base case starts from.
  • The 2024 renovation scope and a property condition report. Which units were renovated, and what the roofs and systems need, would replace the scope tags and the $1,000,000 common area allowance.
  • The August 2026 appraisal. The report would give the appraiser’s rent and cap rate, which you could set beside the 6.28% from a market report.
  • The existing loan documents. The prepayment terms decide what it costs to repay the $27,500,000 loan before its June 6, 2030 maturity.
  • Lender quotes. A bridge term sheet would give the loan-to-cost, the spread, the cap requirement and the extension conditions. A permanent quote would give the spread, any interest-only period and the lender’s coverage and loan-to-value limits.

One limit applies to the market inputs. The rent indexes describe the Houston metro, and ZORI for ZIP code 77069, where the filing places the property, reads $1,154 against $1,410 for the metro. The base case assumes a heavy renovation reaches the metro rent, and nearby rent comps would test that better than either index.

Our view: the price has to carry the refinance

On these inputs the base case returns less than its own preferred return and needs new equity at the refinance. We would size the raise to the base case plus the refinance call, and treat the price as the open variable.

The request fixed the price at the appraised value, and the model shows what that price implies. A going-in cap rate of 6.68% and a yield on cost of 6.66% after $4,078,800 of work means the renovation adds income at about the rate the purchase already earned. With permanent debt at a 7.78% constant, the coverage test will hold proceeds near the bridge balance however the lease-up goes. A lower price lowers the bridge loan, since the loan is sized on cost.

The gap is $333,682, and 2.7% more income closes it (our arithmetic). The upside case returns 22.6%.

Three things would change our view. A current rent roll showing occupancy near the filed 92.0% would raise first-year income. A permanent quote with an interest-only period would loosen the coverage test, and the loan-to-value limit of $22,127,612 would then set the loan above the payoff. A price below the appraised value would lower the bridge loan and raise the yield on cost. Until one of those is in hand, we would tell investors that the plan includes a capital call at the refinance, and show them the downside figure of $19,093,007 next to the base.

For the rate inputs alone, see how Compound builds a SOFR forward curve. For an acquisition with one permanent loan and no lease-up, see the real estate pro forma.

Bridge-to-perm multifamily model (Excel)Compound’s workbook from this run: a Summary with three cases, five tests and four flags; the Assumptions sheet with a source or a reason for every input, a 60-month SOFR forward curve and three draw curves; a 288-unit Rent Roll tagged by renovation scope; Sources and Uses; one monthly model sheet per case with the bridge loan, the interest reserve, the refinance, the permanent loan and the waterfall; an Annual CF sheet; and the Sources list.Download · Free

FAQ

What is a bridge-to-perm multifamily model?

It is a model of an apartment purchase financed first with a short floating-rate bridge loan and later with a long fixed-rate permanent loan. It has a renovation budget, a monthly lease-up, the bridge loan with an interest reserve, a refinance test and the returns to equity.

How is the permanent loan sized at the refinance?

A lender computes the largest loan under each limit and lends the smallest. This model uses three: a share of value, a minimum debt service coverage ratio and a loan cap. In the base case 70.0% of value gives $22,127,612, coverage of 1.25x gives $20,404,654 and the cap is $25,000,000, so coverage sets the loan.

How do you size an interest reserve on a bridge loan?

Project property cash flow after bridge interest and fees for each month, add up the months that are negative, and add a buffer. In this model the base case’s cumulative shortfall is $475,818, the buffer is 15.0% and the reserve is $547,191. The downside case has 31 months when the reserve cannot cover the shortfall.

How do you model lease-up on an S-curve?

Use a logistic function of the month with four inputs: start occupancy, target occupancy, the inflection month and a steepness. This model starts at 85.0%, targets 91.6% from Apartment List’s metro vacancy, and puts the inflection in month 9.

What happens when the refinance does not repay the bridge loan?

The owner pays the difference in cash, extends the bridge loan if the agreement allows it, or waits for income to grow. In this model’s base case the difference is $333,682, and equity contributes $441,665 after the new loan’s costs, the released reserve and that month’s property cash. In the downside case the difference is $6,427,589 after both extensions are used.

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