A permanent loan of $30,318,852 does not repay a construction loan that has grown to $35,799,601. That is the base case of this model for a 180,300 square foot warehouse project in Maryland. At the refinance on January 18, 2028 the sponsor adds $5,783,937 of new equity, and every one of the 50 cells in the model’s two sensitivity tables shows a shortfall (our count).
You work in acquisitions or asset management at an institutional real estate investor, and a development is on your desk. The construction lender sizes its loan on cost. The permanent lender sizes the takeout on value and on income. A construction-to-permanent loan model puts both loans on one timeline and answers one question: on the day of the refinance, does the second loan pay off the first? We asked Compound to build that model on a real project from public data. It ran on November 15, 2026 and returned one Excel workbook and a summary.
The project’s cost, size, yield and stabilization date come from a public filing. Both loans are assumptions: the request set the structure, and the workbook takes no loan from the filing.
Two facts frame every figure below. Compound’s summary reports that $53.7M of the $57.6M had already been spent, so a new construction loan from November 17, 2026 is a hypothetical structure on a project that is mostly paid for. The filing’s total also includes capitalized interest, so the model’s $1,750,000 interest reserve and $358,249 loan fee count some financing cost a second time, as Compound’s summary notes.
The shortfall is the output of those assumptions. It is neither a forecast for this property nor advice to buy, sell or lend on it.
What the workbook shows:
- The debt service coverage test sets the permanent loan. At a 6.90% rate and a 1.25x minimum, stabilized net operating income of $2,995,200 supports $30,318,852. The 65% loan-to-value test would allow $32,260,893.
- The construction loan is larger than either test allows. A 60% loan-to-cost commitment of $35,824,950 is drawn to $35,799,601 by month 14, with $1,724,651 of interest capitalized.
- The as-stabilized value is 83.1% of total cost. Net operating income over a 6.03% cap rate, the median of nine Maryland industrial properties in CMBS filings, gives $49,632,142 against a cost of $59,708,249 with financing.
- The permanent rate is 170 basis points above the project’s yield on cost. The 10-Q discloses a 5.2% expected stabilized yield. The 10-year Treasury alone closed at 5.15% on November 13, 2026.
- The interest reserve lasts with $25,349 to spare. A $1,750,000 reserve covers interest through month 14 and runs out in month 15.
Each input on the Assumptions sheet carries a citation, the word “Request”, or the words “Analyst assumption” with a reason. The project comes from a 10-Q on SEC EDGAR. The cap rate comes from CMBS loan-level filings. The construction loan floats over Compound’s SOFR forward curve, and the permanent rate starts from the Daily Treasury Par Yield Curve.
“I need to know whether the permanent loan will pay off the construction loan on a warehouse development, and how much cash the sponsor must add if it does not, so I want a construction-to-permanent loan model anchored on public facts. From the latest 10-K or 10-Q of a public industrial REIT, pick one development project, or one market's group of projects, that the REIT discloses with its square feet, total expected investment, percent leased, expected stabilized yield and stabilization date. Use those figures as the project: total cost, building size, and stabilized NOI as cost times the disclosed yield. Set the as-stabilized value from that NOI over a cap rate taken from the appraised values and NOI of stabilized industrial properties in the same state in the CMBS loan-level filings. Set the construction loan at a stated loan-to-cost, floating over the SOFR forward curve plus a spread, with an S-curve monthly draw, equity funded first, and an interest reserve. Set the permanent loan rate from the 10-year point of today's Treasury par yield curve plus a spread, with a 30-year amortization, a maximum loan-to-value of 65% and a minimum DSCR of 1.25x. Spreads, loan-to-cost and the draw curve are analyst assumptions with a note on each. Build three sections: construction, with the running balance, interest capitalized each month and the payoff at a stabilization month I can change; permanent sizing, with the loan-to-value test and the DSCR test side by side and the binding one picked by formula; and the transition, as sources and uses at the refinance. Report the construction payoff, permanent proceeds and which test set them, the equity paydown or cash back, the blended cost of capital across both loans, stabilized debt service, and cash-on-cash before and after the transition, with any paydown counted as new equity. Add a sensitivity table of the shortfall to the permanent loan rate and stabilized NOI, and a second one to the stabilization month and the cap rate. Flag a payoff shortfall, an interest reserve that runs out before stabilization, and a permanent loan rate above the project's yield on cost. 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 construction-to-permanent loan model
Five project figures come from one table in a 10-Q, and four inputs come from the request. The loan terms that decide the answer are analyst assumptions, and the sheet labels each one.
Compound picked Craftsman Circle in Hyattsville, Maryland, a row in the Development and Redevelopment Activity table of an industrial REIT’s 10-Q for the quarter ended September 30, 2026, filed November 4, 2026. The row gives a total expected investment of $57,600,000, an estimated post-development size of 180,300 square feet, an estimated stabilized cap rate of 5.2%, a stabilization quarter of Q4 2027 and 0.0% leased.
| B | C | D | E | |
|---|---|---|---|---|
| 5 | Input | Value | Unit | Source / basis |
| 7 | Total expected investment (total project cost) | 57,600,000 | $ | Terreno Realty Corp 10-Q, quarter ended 9/30/2026 (filed 11/4/2026), Development and Redevelopment Activity table, Craftsman Circle row. Includes purchase price, closing costs, redevelopment spend, capitalized interest and leasing costs. |
| 8 | Building size (estimated post-development) | 180,300 | SF | Terreno Realty Corp 10-Q, quarter ended 9/30/2026 (filed 11/4/2026), Development and Redevelopment Activity table, Craftsman Circle row |
| 9 | Expected stabilized yield (estimated stabilized cap rate) | 5.2% | % | Terreno Realty Corp 10-Q, quarter ended 9/30/2026 (filed 11/4/2026), Development and Redevelopment Activity table, Craftsman Circle row. Terreno defines it as annualized cash NOI at market occupancy (about 95%) divided by total cost. |
| 10 | Percent pre-leased at 9/30/2026 | - | % | Terreno Realty Corp 10-Q, quarter ended 9/30/2026 (filed 11/4/2026), Development and Redevelopment Activity table, Craftsman Circle row (shown as —%). |
| 11 | Disclosed stabilization quarter (Q4 2027), quarter-end date | 12-31-27 | date | Terreno Realty Corp 10-Q, quarter ended 9/30/2026 (filed 11/4/2026), Development and Redevelopment Activity table, Craftsman Circle row: estimated stabilization quarter Q4 2027; quarter-end date used. |
| 14 | As-stabilized cap rate (median of comps below) | 6.03% | % | Formula: median of the 9 Maryland industrial/warehouse comps in the CMBS block below (appraised value and underwritten NOI at securitization, SEC Form ABS-EE). |
| 19 | Land and site cost funded at closing (% of total cost) | 25% | % | Analyst assumption: 25% for infill Washington DC-area industrial land and closing costs; the seller's budget should replace it. |
| 20 | Construction period (months) | 10 | months | Analyst assumption: 10 months, typical for a 180,000 SF tilt-up warehouse shell; leaves 4 months of lease-up before the disclosed stabilization quarter. |
| 21 | Construction loan-to-cost | 60% | % | Analyst assumption: 60%, the middle of the 55% to 65% range lenders offer on speculative industrial with no pre-leasing. |
| 22 | Construction spread over 1M SOFR | 3.00% | % | Analyst assumption: 300 bps, in line with bank pricing on unleased industrial construction loans. |
| 23 | Construction origination fee (% of commitment) | 1.00% | % | Analyst assumption: 1.00%, the market norm for construction loans; paid at closing out of equity. |
| 24 | Interest reserve (funded inside the loan) | 1,750,000 | $ | Analyst assumption: sized to cover projected interest on the forward curve through the base stabilization month (about $1.73M), rounded up to the nearest $250K. |
| 26 | Stabilization and payoff month (model month) | 14 | month | Request: changeable. Base value 14 = first model month ending on or after the disclosed Q4 2027 stabilization (row 27). |
| 30 | 10-year Treasury par yield (close 11/13/2026) | 5.15% | % | U.S. Department of the Treasury daily par yield curve, 10-year, as of 11/13/2026 (latest close before 11/15/2026), Compound stored rates data. |
| 31 | Permanent spread over 10-year Treasury | 1.75% | % | Analyst assumption: 175 bps, typical life-company or CMBS spread for a newly leased suburban Maryland warehouse at 65% LTV or less. |
| 32 | Amortization (years) | 30 | years | Request |
| 33 | Maximum loan-to-value | 65% | % | Request |
| 34 | Minimum debt service coverage ratio | 1.25x | x | Request |
| 35 | Permanent loan closing costs (% of loan) | 1.00% | % | Analyst assumption: 1.00% for fees, legal and third-party reports at the refinance. |
The yield needs a careful read. The filing defines its estimated stabilized cap rate as annualized cash net operating income at market occupancy, generally 95%, divided by total cost. That is a yield on cost. The request told Compound to use it that way: stabilized net operating income is $57,600,000 times 5.2%, or $2,995,200, which is $16.61 per square foot.
Four inputs carry the label “Request”: the 30-year amortization, the 65% maximum loan-to-value, the 1.25x minimum coverage, and the stabilization month, which you can change. The base value of 14 is a formula result. Cell C27 counts the forward curve periods that end before the disclosed quarter end of December 31, 2027 and adds one.
The analyst assumptions are the ones a lender’s term sheet would replace. The construction loan is 60% of cost at 300 basis points over 1-month SOFR with a 1.00% origination fee. Land and site cost is 25% of total cost, funded at closing, and construction takes 10 months. The permanent loan prices at 175 basis points over the 10-year Treasury with 1.00% of closing costs. Each has a one-line reason in column E. The loan-to-cost note, for example, says 60% is the middle of the range lenders offer on speculative industrial with no pre-leasing.
The as-stabilized cap rate from Maryland CMBS industrial loans
The value at stabilization is net operating income over a cap rate, and the request asked for that cap rate from CMBS filings in the same state. Compound found nine comps, took the median of 6.03%, and the value came out below cost.
Every CMBS deal files loan-level data with the SEC on Form ABS-EE, with each property’s appraised value and underwritten net operating income. Compound kept Maryland industrial and warehouse properties with an MAI appraisal dated 2023 or later and occupancy of 90% or more at securitization.
| B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|
| 84 | Property | Cap rate | City | Appraisal date | Appraised value | Underwritten NOI | Occupancy | CMBS deal |
| 85 | 11900 Trolley Lane | 5.54% | Beltsville | 04-07-25 | 25,300,000 | 1,400,518 | 100.0% | Benchmark 2025-V16 Mortgage Trust |
| 86 | 3300 75th Avenue | 6.35% | Landover | 05-02-23 | 67,800,000 | 4,305,412 | 100.0% | Benchmark 2023-B39 Mortgage Trust |
| 87 | 40-52 Derwood Circle | 6.66% | Rockville | 08-29-25 | 15,800,000 | 1,052,500 | 100.0% | BANK 2025-BNK51 |
| 88 | Brandywine Regency Warehouse & Distribution Center | 5.78% | Brandywine | 11-15-25 | 138,300,000 | 7,996,872 | 100.0% | BBCMS Mortgage Trust 2025-C39 |
| 89 | Clinton | 6.42% | Clinton | 08-13-24 | 7,900,000 | 507,120 | 100.0% | BANK 2024-BNK48 |
| 90 | Dunlop Protective Footwear - Havre De Grace, MD | 6.03% | Havre De Grace | 03-01-24 | 11,300,000 | 681,932 | 100.0% | BMO 2024-5C4 Mortgage Trust |
| 91 | Fedex Ground - Cumberland | 5.07% | Cumberland | 02-28-23 | 46,300,000 | 2,346,515 | 100.0% | BANK5 2023-5YR1 |
| 92 | McGaw Commerce Center | 5.51% | Columbia | 02-14-24 | 50,100,000 | 2,760,449 | 94.6% | BMO 2024-5C4 Mortgage Trust |
| 93 | Middle River Distribution Center | 6.16% | Middle River | 01-12-26 | 22,400,000 | 1,378,733 | 100.0% | Benchmark 2026-B43 Mortgage Trust |
The nine cap rates run from 5.07% for Fedex Ground - Cumberland to 6.66% for 40-52 Derwood Circle in Rockville. The median is the Dunlop Protective Footwear property in Havre De Grace at 6.03%. Eight of the nine were 100.0% occupied at securitization, and McGaw Commerce Center in Columbia was 94.6% occupied.
Cap rates of nine Maryland industrial properties in CMBS filings
Percent. Underwritten net operating income over appraised value at securitization, lowest to highest. The median comp is highlighted
Compound workbook, Assumptions sheet, CMBS comps block, from SEC Form ABS-EE asset-level data. Appraisals are dated from February 2023 to January 2026.
Compound also computed a value-weighted rate of 5.82% and marked it “reference only”. It is lower than the median because the largest comp, Brandywine Regency Warehouse & Distribution Center, carries a $138,300,000 appraisal at 5.78%. We agree with using the median. One large property should not set the cap rate for a 180,300 square foot building.
At 6.03%, $2,995,200 of net operating income is worth $49,632,142, or $275.28 per square foot. Total project cost with the interest reserve and the loan fee is $59,708,249. The value is 83.1% of that cost, about $10.1 million less (our arithmetic). The reason is a comparison of two inputs: the 5.2% yield on cost from the filing is 83 basis points below the 6.03% median cap rate from the comps (our arithmetic). The comps are appraisals of other, leased properties across Maryland. The result describes how the model’s value input sits against its cost input, and it is no estimate of what this building will sell for.
Construction loan draw schedule: equity first, an S-curve and an interest reserve
The construction loan is sized on cost, funded after the equity, and charged interest that it lends to itself. By the payoff month it has grown to $35,799,601, of which $1,724,651 is capitalized interest.
The commitment is a single formula, =C8*(C6+C7)/(1-C8*C9). The origination fee is 1.00% of the commitment and is itself a project cost, so the commitment depends on a total that depends on the commitment. The formula solves that loop in one cell: 60% of the $57,600,000 investment plus the $1,750,000 interest reserve, grossed up for the fee, is $35,824,950. The fee is $358,249, total cost is $59,708,249, and required sponsor equity is $23,883,300, or 40.0%.
| B | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29 | Model month | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 31 | Period end | 11/17/26 | 12/17/26 | 1/19/27 | 2/17/27 | 3/17/27 | 4/19/27 | 5/17/27 | 6/17/27 | 7/19/27 | 8/17/27 | 9/17/27 | 10/18/27 | 11/17/27 | 12/17/27 | 1/18/28 | 2/17/28 |
| 33 | Phase | Closing | Construction | Construction | Construction | Construction | Construction | Construction | Construction | Construction | Construction | Construction | Lease-up | Lease-up | Lease-up | Lease-up | After payoff |
| 36 | S-curve cumulative % of construction complete | - | 2.8% | 10.4% | 21.6% | 35.2% | 50.0% | 64.8% | 78.4% | 89.6% | 97.2% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% |
| 41 | Total uses before interest ($) | 14,758,249 | 1,209,600 | 3,283,200 | 4,838,400 | 5,875,200 | 6,393,600 | 6,393,600 | 5,875,200 | 4,838,400 | 3,283,200 | 1,209,600 | - | - | - | - | - |
| 43 | Sponsor equity | 14,758,249 | 1,209,600 | 3,283,200 | 4,632,250 | - | - | - | - | - | - | - | - | - | - | - | - |
| 44 | Construction loan draw for costs | - | - | - | 206,150 | 5,875,200 | 6,393,600 | 6,393,600 | 5,875,200 | 4,838,400 | 3,283,200 | 1,209,600 | - | - | - | - | - |
| 50 | All-in rate | - | 6.97% | 7.19% | 7.31% | 7.37% | 7.51% | 7.57% | 7.63% | 7.69% | 7.70% | 7.70% | 7.58% | 7.53% | 7.47% | 7.47% | 7.66% |
| 51 | Interest accrued (actual/360) | - | - | - | - | 1,181 | 41,880 | 73,746 | 124,677 | 170,713 | 186,011 | 221,934 | 227,886 | 220,524 | 219,999 | 236,100 | 228,374 |
| 52 | Interest funded from reserve (capitalized) | - | - | - | - | 1,181 | 41,880 | 73,746 | 124,677 | 170,713 | 186,011 | 221,934 | 227,886 | 220,524 | 219,999 | 236,100 | 25,349 |
| 54 | Closing balance ($) | - | - | - | 206,150 | 6,082,531 | 12,518,011 | 18,985,357 | 24,985,234 | 29,994,347 | 33,463,558 | 34,895,092 | 35,122,978 | 35,343,502 | 35,563,501 | 35,799,601 | 35,824,950 |
| 59 | Reserve closing | 1,750,000 | 1,750,000 | 1,750,000 | 1,750,000 | 1,748,819 | 1,706,938 | 1,633,192 | 1,508,516 | 1,337,803 | 1,151,792 | 929,858 | 701,972 | 481,448 | 261,449 | 25,349 | - |
Equity goes in first. At closing on November 17, 2026 the sponsor funds $14,758,249: the land and site cost of $14,400,000 and the loan fee. It funds all of months 1 and 2 and most of month 3. The loan’s first draw is $206,150 in month 3.
The rest of the cost follows an S-curve over 10 months. It runs at 2.8% of construction spend in month 1, 14.8% in each of months 5 and 6, and 2.8% in month 10. The two peak months draw $6,393,600 each. The draw curve is an analyst assumption that a contractor’s schedule of values would replace.
Interest accrues on the opening balance each month at the 1-month forward rate plus 300 basis points, on an actual/360 basis. The forward curve starts at 3.97% for the first period and reaches 4.70% in month 10, so the all-in rate rises from 6.97% to 7.70% during construction. The reserve pays the interest, which means the loan funds it and the balance grows by it.
Construction loan balance at each month end
Closing balance, months 0 to 14. Costs are drawn through month 10. In the four lease-up months the balance grows only by capitalized interest
Compound workbook, Construction sheet, closing balance row. Interest at 1-month forward SOFR as of November 13, 2026 plus an assumed 300 basis points.
The balance is $34,895,092 when construction ends in month 10. Four months of lease-up add only interest, and the payoff on January 18, 2028 is $35,799,601. The balance-weighted all-in rate through payoff is 7.58%. The schedule counts no lease-up income before stabilization, a choice stated at the top of the sheet.
The reserve deserves a second look. Compound sized it at $1,750,000 against projected interest of $1,724,651, so $25,349 is left at payoff and month 15 is the first month it cannot cover. The flag for a reserve that runs out before stabilization reads “OK”, with one month of room. The reserve was sized to the projected interest, so the pass follows from the sizing.
How to size the permanent loan: LTV and DSCR tests side by side
The permanent loan is the smaller of two numbers: a share of value and the loan whose payments the income covers 1.25 times. Here the coverage test gives $30,318,852 and the value test gives $32,260,893, so coverage sets the loan.
| B | C | D | |
|---|---|---|---|
| 24 | Test | Loan-to-value | Debt service coverage |
| 25 | Constraint (max LTV / min DSCR) | 65% | 1.25x |
| 26 | Sized off (value / NOI) | 49,632,142 | 2,995,200 |
| 27 | Maximum loan ($) | 32,260,893 | 30,318,852 |
| 28 | Annual debt service at maximum loan | 2,549,643 | 2,396,160 |
| 29 | Implied loan-to-value | 65.0% | 61.1% |
| 30 | Implied DSCR | 1.17x | 1.25x |
| 31 | Result | Not binding | Binding |
| 33 | PERMANENT LOAN RESULT | ||
| 34 | Permanent loan proceeds ($) | 30,318,852 | |
| 35 | Test that sets proceeds | DSCR | |
| 36 | Stabilized annual debt service ($) | 2,396,160 | |
| 37 | Monthly debt service | 199,680 | |
| 38 | DSCR at proceeds | 1.25x | |
| 39 | Loan-to-value at proceeds | 61.1% | |
| 40 | Debt yield | 9.88% | |
| 41 | Yield on cost (disclosed) | 5.20% | |
| 42 | Permanent rate less yield on cost (bps) | 170 |
The rate is two cells. The 10-year Treasury par yield closed at 5.15% on November 13, 2026, a sourced figure. The 175 basis point spread is an analyst assumption, described on the sheet as typical of a life company or CMBS loan on a newly leased suburban Maryland warehouse. Together they make 6.90%. With 30-year amortization, a year of principal and interest is 7.90% of the loan amount. That figure is the annual debt constant.
The loan-to-value test is 65% of $49,632,142, or $32,260,893. Payments on that loan would be $2,549,643 a year, and net operating income would cover them 1.17x, below the 1.25x minimum. The coverage test works backward from income: $2,995,200 divided by 1.25 and by the debt constant is $30,318,852. That loan is 61.1% of value, inside the 65% limit. The model picks the smaller with =MIN(C27,D27) and names the binding test in the next cell, so the label changes when the inputs do.
Debt service on the permanent loan is $2,396,160 a year, or $199,680 a month. The debt yield is 9.88%.
The project's yield against the cost of each loan
Percent. The yield on cost is from the 10-Q and the Treasury yield is the November 13, 2026 close. Loan spreads are analyst assumptions
Compound workbook, Permanent sheet, cells C7, C11, C17, C19 and C21, and Construction sheet, cell C24.
The chart explains why coverage binds. The project earns 5.2% on cost. The permanent loan costs 6.90% in interest and 7.90% with amortization. When each dollar of debt costs more per year than each dollar of cost earns, a 1.25x coverage rule holds the loan to a small share of cost. The permanent proceeds are 50.8% of total project cost (our arithmetic), and the construction loan was 60%. Compound’s third flag reports the same thing in one line: the permanent rate is 170 basis points above the yield on cost.
Refinance sources and uses: the equity paydown
The transition is one small table. Uses are the construction payoff and the new loan’s closing costs, sources are the permanent proceeds, and the difference is cash from the sponsor.
| B | C | D | |
|---|---|---|---|
| 5 | SOURCES AND USES AT REFINANCE | ||
| 6 | Refinance date | 01-18-28 | |
| 8 | Construction loan payoff | 35,799,601 | |
| 9 | Permanent loan closing costs | 303,189 | |
| 10 | Cash returned to sponsor | - | |
| 11 | Total uses ($) | 36,102,789 | |
| 14 | Permanent loan proceeds | 30,318,852 | |
| 15 | Sponsor equity paydown (new equity) | 5,783,937 | |
| 16 | Total sources ($) | 36,102,789 | |
| 20 | EQUITY AND CASH-ON-CASH | ||
| 21 | Initial sponsor equity | 23,883,300 | |
| 22 | Construction interest paid by sponsor | - | |
| 23 | Equity invested before transition ($) | 23,883,300 | |
| 24 | Plus: equity paydown at refinance | 5,783,937 | |
| 25 | Less: cash returned at refinance | - | |
| 26 | Equity invested after transition ($) | 29,667,237 | |
| 27 | Stabilized NOI | 2,995,200 | |
| 29 | Annualized construction interest at stabilization | 2,718,320 | |
| 30 | Cash flow before transition ($) | 276,880 | |
| 31 | Cash-on-cash before transition | 1.2% | |
| 32 | Stabilized permanent debt service | 2,396,160 | |
| 33 | Cash flow after transition ($) | 599,040 | |
| 34 | Cash-on-cash after transition | 2.0% | |
| 36 | BLENDED COST OF CAPITAL ACROSS BOTH LOANS | ||
| 37 | Construction loan balance-weighted all-in rate | 7.58% | |
| 38 | Construction loan amount (payoff) | 35,799,601 | |
| 39 | Permanent loan rate | 6.90% | |
| 40 | Permanent loan amount | 30,318,852 | |
| 41 | Blended cost of debt (amount-weighted) | 7.27% | |
| 43 | FLAGS | Value | Status |
| 44 | Payoff shortfall (sponsor paydown, $) | 5,783,937 | FLAG |
| 45 | Interest reserve runs out before stabilization (first uncovered month) | 15 | OK |
| 46 | Permanent rate above yield on cost (bps) | 170 | FLAG |
| 47 | Construction not finished by stabilization month (months of slack) | 4 | OK |
Uses total $36,102,789: the $35,799,601 payoff and $303,189 of closing costs at 1.00% of the new loan. The permanent loan supplies $30,318,852. The sponsor supplies the other $5,783,937, and no cash comes back. The paydown is 24.2% of the equity the sponsor had already invested (our arithmetic), and it raises that equity from $23,883,300 to $29,667,237.
What the refinance needs and what each sizing test provides
Dollars at the January 18, 2028 refinance. The paydown is the payoff plus closing costs, less the permanent proceeds
Compound workbook, Transition sheet, cells C8, C9 and C15, and Permanent sheet, cells C27 and D27.
The request asked for cash-on-cash before and after, with the paydown counted as new equity. Before the transition, the model annualizes construction interest at the payoff-month rate of 7.47% on the payoff balance, which is $2,718,320. Net operating income less that interest leaves $276,880, or 1.2% on $23,883,300. After the transition, net operating income less $2,396,160 of debt service leaves $599,040, or 2.0% on $29,667,237.
The blended cost of debt across both loans is 7.27%. Compound weights the construction loan’s 7.58% by its payoff balance and the permanent loan’s 6.90% by its proceeds. The loans run one after the other, so 7.27% is an amount-weighted average of two rates and the project never pays it in any one month.
What moves the shortfall: rate, NOI, cap rate and timing
Net operating income and the permanent rate move the shortfall by millions. The cap rate changes it only at 6.53%, the highest column in the grid, and a delay costs the sponsor interest out of pocket instead of a larger payoff.
| B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|
| 5 | SHORTFALL ($) VS PERMANENT LOAN RATE AND STABILIZED NOI | |||||||
| 6 | Stabilized NOI ($) | |||||||
| 7 | Permanent loan rate | 2,695,680 | 2,845,440 | 2,995,200 | 3,144,960 | 3,294,720 | ||
| 8 | 5.90% | 7,055,145 | 5,458,231 | 3,861,317 | 2,264,403 | 667,489 | ||
| 9 | 6.40% | 7,356,243 | 5,776,057 | 4,195,870 | 2,615,684 | 1,035,497 | ||
| 10 | 6.90% | 8,785,503 | 7,284,720 | 5,783,937 | 4,283,154 | 2,782,371 | ||
| 11 | 7.40% | 10,103,461 | 8,675,898 | 7,248,334 | 5,820,771 | 4,393,208 | ||
| 12 | 7.90% | 11,320,575 | 9,960,629 | 8,600,683 | 7,240,738 | 5,880,792 | ||
| 15 | SHORTFALL ($) VS STABILIZATION MONTH AND CAP RATE | |||||||
| 16 | As-stabilized cap rate | Memo | ||||||
| 17 | Stabilization month | 5.53% | 5.78% | 6.03% | 6.28% | 6.53% | Sponsor-paid interest | |
| 18 | 10 | 4,879,429 | 4,879,429 | 4,879,429 | 4,879,429 | 5,400,517 | - | |
| 19 | 12 | 5,327,838 | 5,327,838 | 5,327,838 | 5,327,838 | 5,848,926 | - | |
| 20 | 14 | 5,783,937 | 5,783,937 | 5,783,937 | 5,783,937 | 6,305,025 | - | |
| 21 | 16 | 5,809,286 | 5,809,286 | 5,809,286 | 5,809,286 | 6,330,374 | 426,247 | |
| 22 | 18 | 5,809,286 | 5,809,286 | 5,809,286 | 5,809,286 | 6,330,374 | 895,810 |
In the first table the smallest shortfall is $667,489, at a 5.90% permanent rate with net operating income 10% above the base. The largest is $11,320,575, at 7.90% with net operating income 10% below. At the base rate, the shortfall is $7,284,720 with income 5% lower and $4,283,154 with income 5% higher.
A lower rate helps less than it seems. At 5.90% and base income the shortfall is still $3,861,317, because the loan-to-value test takes over as the limit once coverage loosens.
The second table has a pattern worth noticing. Across cap rates from 5.53% to 6.28% the base-month shortfall is the same $5,783,937. The coverage test binds in all four columns, and coverage does not depend on value. At 6.53%, the highest column in the grid, the value test binds and the shortfall rises to $6,305,025. For this project a better appraisal would not produce a larger loan.
Timing works in two stages. Stabilizing at month 10 lowers the shortfall to $4,879,429, since less interest has been capitalized. Stabilizing at month 16 or month 18 gives $5,809,286 in both rows: once the reserve is spent, the balance stops at the $35,824,950 commitment. The cost of delay moves to the memo column. The sponsor pays $426,247 of interest directly through month 16 and $895,810 through month 18.
We ran one more number from the workbook’s cells. For the coverage test alone to produce enough proceeds to cover the payoff and closing costs at 6.90%, stabilized net operating income would need to be about $3.57 million, roughly 19% above the base and a 6.2% yield on the filed cost (our arithmetic).
What public data cannot tell you about a construction loan takeout
Public filings give the project’s total cost, size and expected yield. The developer’s budget, its contracts and the lender’s term sheet hold the inputs that decide the takeout, and each one replaces a labeled assumption in this workbook.
- The line-item budget and spend to date. The 10-Q gives one total, defined to include the purchase price, closing costs, redevelopment spending, capitalized interest and leasing costs. A budget that separates those lines would remove the overlap with the model’s reserve and fee. The developer’s draw history would replace the 25% land share and the 10-month build.
- The construction contract and schedule. A guaranteed maximum price contract, the permits and the expected certificate of occupancy date set the draw curve and the construction period.
- The leasing pipeline. Stabilized net operating income here is cost times a disclosed yield. The filing shows the building 0.0% leased at September 30, 2026. Letters of intent, rent per square foot, free rent, tenant improvements and commissions would turn that yield into a rent roll, and the sensitivity table shows what 5% of income is worth.
- The construction lender’s term sheet. Loan-to-cost, spread, fee, the index the loan agreement names, any rate floor, the reserve’s size, extension options and recourse are all assumptions here. The forward curve in the workbook is market-implied compounded SOFR, and the Sources sheet says it is not Term SOFR.
- The permanent lender’s quote. The model applies the Treasury yield of November 13, 2026 to a loan that closes in January 2028. A quote would give the spread, any interest-only period, the lender’s own coverage and loan-to-value limits, and whether the rate can be locked forward.
- An appraisal. The as-stabilized value rests on the median of nine appraisal-based cap rates from across Maryland, dated 2023 to 2026. They are not sale prices, and none is the subject property.
Our view: size the construction loan from the takeout backward
On these inputs the gap is structural. A 60% loan-to-cost construction loan cannot be taken out by a permanent loan that coverage holds to about half of cost.
The usual order is to size the construction loan on cost and check the takeout later. This workbook is an argument for the reverse. Permanent proceeds net of closing costs are about $30.0 million, or 50.3% of total cost (our arithmetic). A construction loan near that size would be repaid in full, and it would also capitalize less interest than the one modeled. The sponsor then knows on day one that the equity requirement is closer to half the cost than to 40.0%, and the $5,783,937 is in the capital plan before the first draw.
The other side has weight. The permanent rate is today’s 10-year yield applied 14 months ahead, and a fall of 100 basis points would cut the shortfall to $3,861,317 on the first table. The spread assumptions may be wide for a fully leased building. And a yield on cost of 5.2% may be acceptable to an owner that does not plan to borrow against the building.
Three things would change our view. A signed lease at rents that lift net operating income toward $3.57 million would close the gap on the coverage test. A permanent quote with an interest-only period would loosen coverage, and the value test at $32,260,893 would then set the loan. A line-item budget would show how much of the $57,600,000 is already interest. Until then we would carry the paydown as a real use of cash.
This page isolates the takeout. A real estate development pro forma covers the whole project, from the choice of metro to yield on cost and returns. A bridge-to-perm multifamily model asks the same refinance question about an existing building in lease-up. An industrial warehouse acquisition model starts where this one ends, with a leased building and a rent roll, and a real estate pro forma sizes a single acquisition loan.
Construction-to-permanent loan model (Excel)Compound’s workbook from this run: a Summary with the key results and four flags; the Assumptions sheet with a source or a reason for every input, the 36-month SOFR forward curve and nine CMBS comps; the monthly Construction schedule; the Permanent sizing tests; the Transition sources and uses; two Sensitivity tables; and the Sources list.Download · FreeFrequently asked questions
What is a construction-to-permanent loan model?
It is a model that carries a development from the first construction draw to the refinance. It has three parts: the construction loan balance by month with capitalized interest, the permanent loan sized on loan-to-value and debt service coverage, and the sources and uses on the day one loan repays the other. Its main output is the cash the sponsor adds or receives at that refinance.
How is a permanent loan sized at takeout?
A lender computes the largest loan under each of its limits and lends the smallest. In this model the limits are 65% of as-stabilized value and 1.25x coverage of debt service by net operating income. Coverage gives $30,318,852 and value gives $32,260,893, so coverage sets the loan. The model picks the binding test by formula.
What happens if the permanent loan does not pay off the construction loan?
The sponsor pays the difference in cash at the refinance, often called a cash-in refinance or an equity paydown. In this model the difference is $5,783,937, which includes $303,189 of closing costs on the new loan. The alternatives are a loan extension, more leasing before the refinance, or a different lender, and the model’s stabilization month input shows what a delay does to the payoff and to interest paid out of pocket.
How do you size an interest reserve on a construction loan?
Project the loan balance month by month from the draw schedule, apply the forward rate plus the spread to each month’s opening balance, and add up the interest through the stabilization month. This model projects $1,724,651 and sets the reserve at $1,750,000. The schedule then reports the first month the reserve cannot cover, which is month 15 against a payoff in month 14.
Why does the cap rate not change the shortfall in this model?
The debt service coverage test sets the loan, and coverage depends on income, the rate and the amortization. Value enters only the loan-to-value test. In the second sensitivity table the shortfall is $5,783,937 at every cap rate from 5.53% to 6.28%, and it is higher at 6.53%, the highest column in the table, where the value test becomes the smaller of the two.





