Converting this office complex into 659 apartments costs $383.1 million, and the finished apartments are worth $128.0 million. That is the base case of this model for Constitution Plaza, a 659,315 square foot office property in Hartford, Connecticut, as its loan’s CMBS filings describe it. The purchase basis is $13.0 million, or $19.72 per square foot, and it is 3.4% of the budget. Nearly all of the cost is the work.
Read the cost with its source in mind. The model prices the work from the construction budget in a City of Denver conversion case study and applies it to every square foot, which gives $581,398 per apartment. Two completed Hartford conversions recorded in the workbook cost about $137,000 and $296,000 per unit (our arithmetic), so treat the $383.1 million as the result of these inputs.
An adaptive reuse pro forma answers one question first: is the finished building worth more than the purchase price plus the cost of converting it? We asked Compound to build that model on a real building from public data. It ran on November 15, 2026 and returned one Excel workbook and a summary.
The building’s size, age, occupancy, income, appraisal and loan come from public filings. The purchase price is an assumption set by the request: the lower of the latest appraised value and the outstanding loan balance. Nothing in the filings says the property can be bought at that figure. The shortfall is the output of the model’s inputs. It is neither a forecast for this property nor advice to buy or sell it.
What the workbook shows:
- Hard cost alone is more than the finished value. Three hard-cost groups total $350.03 per square foot at today’s prices, or $230.8 million.
- Cost per unit is $581,398 and value per unit is $194,167. The cost comes from a Denver building’s budget, and the value comes from Zillow home values by bedroom for the Hartford metro.
- Both exits lose money. Selling at completion loses $257.7 million of equity. Holding to stabilization loses $291.1 million, a levered IRR of negative 26.0%. The two sale prices rest on different evidence: home values at completion and a cap rate at the end of the hold. The building comes from CMBS loan-level filings on SEC EDGAR. The basis comparison comes from REIT Schedule III data. Both loans float over Compound’s SOFR forward curve, and the permanent rate starts from the Daily Treasury Par Yield Curve.
“I am weighing an office-to-apartment conversion and want an adaptive reuse pro forma that shows whether the finished value carries the cost, anchored on a real building. From the CMBS loan-level filings, pick one downtown office property in a Midwest or Northeast city, built before 1990, that is less than 60% occupied or whose loan is past its maturity date, and whose latest report gives net rentable area, year built, occupancy, net operating income, appraised value and the loan balance. Use it as the conversion candidate and set the purchase basis at the lower of its latest appraised value and the outstanding loan balance; compare that basis per square foot with what public office REITs carry buildings at in the same state (Schedule III). Set the unit count from the rentable area at an assumed efficiency and average unit size. Set hard costs in three groups (keep and repair the structure, envelope and systems; selective demolition; residential build-out) as analyst assumptions per square foot from published conversion cost ranges, brought to today with the BLS construction cost PPI and construction wage series. Set apartment rents from Zillow ZORI and Apartment List for the metro and HUD Fair Market Rents for the ZIP code, and the sale value per unit from comparable sales, using Zillow ZHVI for the metro and county property sale records where the state is covered, with the exit cap rate as a cross-check. Carry property tax, insurance and acquisition loan interest through an entitlement period, then a 24-month construction period with a monthly draw curve. Price the loans off the SOFR forward curve plus a spread, with interest accrued on the running balance and capitalized, and an interest reserve sized at closing and shown as a use. Build five sections: existing shell, entitlement, construction, exit, and sources and uses. Report total project cost with capitalized interest and reserve, cost per unit, and two sets of returns side by side: sell at completion, and hold to stabilization with a permanent loan off the 10-year Treasury yield. Add a sensitivity of profit and levered IRR to entitlement delays of 6, 12 and 18 months. Flag a finished value below total cost and an interest reserve that runs out before completion. 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 an adaptive reuse pro forma
The model has five sections: the existing shell, entitlement, construction, exit, and sources and uses. Filings and public series supply the building, the cost indexes, the rents, the home values and the rates, a City of Denver case study supplies the hard costs, and the unit mix and the loan terms are analyst assumptions.
The model assumes vacant possession when construction starts. It keeps 0% of the office net operating income during entitlement and does not model the cost of buying out leases. The timeline is 12 months of entitlement, 24 months of construction, then lease-up.
Each input on the Assumptions sheet carries a citation, the word “Request”, or the words “analyst assumption” with a reason. The 75% residential efficiency, for example, is the average of the Denver case study and a New York City Comptroller note.
Two sets of figures came from the web: Connecticut’s recorded sales from the state’s open-data portal, and Apartment List’s rents by bedroom from its listing pages. The Sources sheet lists 26 sources.
The existing shell: the building and the purchase basis
Compound picked Constitution Plaza in Hartford from the CMBS loan-level filings and set the basis at its $13,000,000 appraisal. That is $19.72 per square foot, 6.8% of the gross value at which a public REIT carried two Connecticut office buildings.
The filing for Wells Fargo Commercial Mortgage Trust 2018-C46, for the report period ending October 13, 2026, lists the property as 1, 10, 100, 248, 250 & 260 Constitution Plaza, Hartford, CT 06103. It was built in 1962 and last renovated in 2004. Physical occupancy is 73%, above the request’s 60% line, so the building qualifies on the other test. The loan’s maturity date was May 6, 2023, which is 43 months before the model’s closing date. The filing reports the loan as not repaid at that date.
| B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|
| 5 | CANDIDATE PROPERTY | Value | |||||
| 6 | Property | Constitution Plaza (1, 10, 100, 248, 250 & 260 Constitution Plaza), Hartford, CT 06103 | |||||
| 7 | Net rentable area (sf) | 659,315 | |||||
| 8 | Year built | 1962 | |||||
| 9 | Physical occupancy | 73% | |||||
| 10 | Revenue, trailing 12 months ($) | 14,078,747 | |||||
| 11 | Operating expenses, trailing 12 months ($) | 11,798,176 | |||||
| 12 | Net operating income, trailing 12 months ($) | 2,280,571 | |||||
| 13 | NOI per sf ($) | 3.46 | |||||
| 15 | PURCHASE BASIS | ||||||
| 16 | Latest appraised value ($) | 13,000,000 | |||||
| 17 | Loan balance, WFCM 2018-C46 note ($) | 16,369,863 | |||||
| 18 | Loan balance, JPMDB 2018-C8 note ($) | 24,554,793 | |||||
| 19 | Total outstanding loan balance ($) | 40,924,656 | |||||
| 20 | Purchase basis: lower of appraisal and loan balance ($) | 13,000,000 | |||||
| 21 | Purchase basis per sf ($) | 19.72 | |||||
| 22 | In-place NOI yield on basis | 17.5% | |||||
| 23 | Loan maturity date | 6-May-2023 | |||||
| 24 | Months past maturity at closing | 43 | |||||
| 25 | Qualifies: built before 1990 and (occupancy below 60% or loan past maturity) | Yes | |||||
| 27 | SCHEDULE III COMPARISON: PUBLIC OFFICE REIT CARRYING VALUES IN CONNECTICUT | ||||||
| 28 | Gross carrying ($) | Accum. depreciation ($) | Net carrying ($) | Rentable sf | Gross $/sf | Net $/sf | |
| 29 | Metro Center, Stamford (ESRT, FY2024) | 76,551,000 | 45,505,000 | 31,046,000 | 282,276 | 271.19 | 109.98 |
| 30 | First Stamford Place, Stamford (ESRT, FY2023) | 232,184,000 | 113,916,000 | 118,268,000 | 781,731 | 297.01 | 151.29 |
| 31 | Average of the two REIT buildings | 308,735,000 | 159,421,000 | 149,314,000 | 1,064,007 | 290.16 | 140.33 |
| 32 | Constitution Plaza purchase basis | 13,000,000 | 13,000,000 | 659,315 | 19.72 | 19.72 | |
| 33 | Basis as a share of REIT carrying value per sf | 6.8% | 14.1% |
For the 12 months to September 30, 2025 the filing shows net operating income of $2,280,571, or $3.46 per square foot. The latest MAI appraisal is $13,000,000, dated May 29, 2025.
The loan is two pari passu notes, one in the 2018-C46 trust and one in JPMDB Commercial Mortgage Securities Trust 2018-C8. Together their balance is $40,924,656, about 3.1 times the appraisal (our arithmetic). The basis cell is =MIN(C16,C19), and the appraisal is the smaller figure.
At that basis the in-place income is a 17.5% yield, and the model does not count on it. The building is 73% occupied in the filing, and the model assumes it is empty when the work starts. What it would cost to reach that point is not in the model.
The request also asked how the basis compares with what public office REITs carry buildings at in the same state. The Schedule III data has two Connecticut office lines, both from Empire State Realty Trust and both in Stamford. The two together average $290.16 gross and $140.33 net of depreciation.
The $19.72 basis is 6.8% of the gross figure and 14.1% of the net figure. Read that comparison narrowly: it covers two buildings in another city, and the workbook notes that both have since left the REIT’s portfolio.
Conversion cost per square foot: three hard-cost groups
Hard cost is $322.45 per square foot at April 2025 prices, taken from a City of Denver conversion case study, and $350.03 today after escalation with two BLS series. With contingency, soft costs, the developer fee and inflation to the draw dates, the development budget is $351,946,923 before land, carry and financing.
The unit count comes from area. At 75% efficiency the 659,315 square feet leave 494,486 square feet of net residential area, and at an average of 750 square feet the result is 659 units: 198 studios, 330 one-bedrooms and 131 two-bedrooms. The unit size and mix are analyst assumptions.
| B | C | D | E | F | |
|---|---|---|---|---|---|
| 13 | HARD COST ESCALATION, APR-2025 TO SEP-2026 | ||||
| 14 | BLS PPI, inputs to multifamily construction: change | 11.2% | |||
| 15 | BLS avg hourly earnings, construction of buildings: change | 5.9% | |||
| 16 | Blended escalation factor | 1.086 | |||
| 18 | DEVELOPMENT BUDGET | $/sf, Apr-2025 | $/sf, today | Total ($) | $/unit |
| 19 | Keep and repair structure, envelope and systems | 157.74 | 171.23 | 112,893,954 | 171,311 |
| 20 | Selective demolition and abatement | 12.33 | 13.39 | 8,825,611 | 13,392 |
| 21 | Residential build-out | 152.38 | 165.42 | 109,063,209 | 165,498 |
| 22 | Total hard cost ($) | 322.45 | 350.03 | 230,782,774 | 350,201 |
| 23 | Hard cost contingency | 52.51 | 34,617,416 | 52,530 | |
| 24 | Soft costs | 70.01 | 46,156,555 | 70,040 | |
| 25 | Developer fee | 18.90 | 12,462,270 | 18,911 | |
| 26 | Hard cost escalation to the planned draw dates | 42.36 | 27,927,908 | 42,379 | |
| 27 | Development budget before land, carry and financing ($) | 533.81 | 351,946,923 | 534,062 | |
| 28 | Check: total hard cost $/sf, today, against the CBRE $250-$650 range | Inside range |
The request set three hard-cost groups. The workbook fills them from the construction budget in the City and County of Denver’s April 2025 case study of an office conversion with 158,000 square feet of building area. Each line of that budget is divided by the area and marked up 10.4% for the general contractor’s costs and builder’s risk.
Keeping and repairing the structure, envelope and systems is $157.74 per square foot. Selective demolition and abatement is $12.33. Residential build-out of units and common areas is $152.38. The cell note says these are Denver prices with no adjustment for Hartford.
Two BLS series bring those April 2025 prices to today. The producer price index for inputs to multifamily construction rose 11.2% between April 2025 and September 2026, and average hourly earnings in construction of buildings rose 5.9%. The model weights the two at 50% each, and the factor is 1.086.
At today’s prices the three groups are $171.23, $13.39 and $165.42 per square foot. Total hard cost is $230,782,774, or $350,201 per unit. A check cell compares the $350.03 with a published range of $250 to $650 per square foot from CBRE and reads “Inside range”. The cell note on demolition and abatement says a 1962 building may need more than the Denver allowance.
Four lines sit under hard cost: a 15% contingency (the case study’s 10% design and 5% construction contingencies), 20% soft costs from a Citizens Budget Commission report, a 4% developer fee, and $27,927,908 of inflation at 5% a year to each draw date. The inflation formula covers hard cost, contingency and the developer fee. The budget is $533.81 per square foot and $534,062 per unit.
Entitlement carry, the draw curve and capitalized interest
The model holds the shell for 12 months of entitlement and 24 months of construction, and prices both loans off the SOFR forward curve. Tax and insurance carry is $3,143,615, origination fees are $2,190,586 and the interest reserve sized at closing is $16,465,782.
During the entitlement year the model pays tax and insurance on a building that earns nothing. Connecticut’s 70% assessment ratio and a combined Hartford rate of 71.6794 mills make the tax $652,283 a year, and insurance at $0.60 per square foot is $395,589. Together they are $87,323 a month.
An acquisition loan funds 50% of the basis, or $6,500,000. Its rate is the average 1-month forward SOFR over the entitlement period, 4.52%, plus a 4.00% spread, or 8.52%. With 35% of soft costs spent on design and permitting, entitlement-period cost is $17,737,472.
Construction draws follow a 24-month S-curve. Equity goes in first. The sponsor’s $167,948,328 funds costs before the construction loan does, and the loan balance reaches $215,192,926 at completion in month 36. The construction loan prices at forward SOFR plus 3.75%, and the average over the construction period is 4.68%, or 8.43% all in.
| B | C | D | E | F | |
|---|---|---|---|---|---|
| 5 | USES | $ | $/sf | $/unit | % of total |
| 6 | Purchase basis | 13,000,000 | 20 | 19,727 | 3.4% |
| 7 | Acquisition closing costs | 260,000 | 0 | 395 | 0.1% |
| 8 | Hard cost: structure, envelope and systems | 112,893,954 | 171 | 171,311 | 29.2% |
| 9 | Hard cost: selective demolition and abatement | 8,825,611 | 13 | 13,392 | 2.3% |
| 10 | Hard cost: residential build-out | 109,063,209 | 165 | 165,498 | 28.2% |
| 11 | Hard cost escalation to draw dates (planned) | 27,927,908 | 42 | 42,379 | 7.2% |
| 12 | Hard cost contingency | 34,617,416 | 53 | 52,530 | 8.9% |
| 13 | Soft costs | 46,156,555 | 70 | 70,040 | 11.9% |
| 14 | Developer fee | 12,462,270 | 19 | 18,911 | 3.2% |
| 15 | Tax and insurance carry, planned entitlement + construction | 3,143,615 | 5 | 4,770 | 0.8% |
| 16 | Costs before financing ($) | 368,350,537 | 559 | 558,954 | 95.2% |
| 17 | Loan origination fees | 2,190,586 | 3 | 3,324 | 0.6% |
| 18 | Interest reserve | 16,465,782 | 25 | 24,986 | 4.3% |
| 19 | Total uses ($) | 387,006,905 | 587 | 587,264 | 100.0% |
| 21 | SOURCES | ||||
| 22 | Acquisition loan | 6,500,000 | 10 | 9,863 | 1.7% |
| 23 | Construction loan commitment (incl. interest reserve) | 212,558,577 | 322 | 322,547 | 54.9% |
| 24 | Sponsor equity | 167,948,328 | 255 | 254,853 | 43.4% |
| 25 | Total sources ($) | 387,006,905 | 587 | 587,264 | 100.0% |
| 26 | Check: sources less uses | 0 | |||
| 28 | LOAN SIZING | ||||
| 29 | Debt for costs: loan-to-cost x costs before financing ($) | 202,592,796 | |||
| 30 | Construction-period average SOFR (planned) | 4.68% | |||
| 31 | Construction loan all-in rate | 8.43% | |||
| 32 | Reserve estimate: acquisition loan interest, entitlement ($) | 553,919 | |||
| 33 | Reserve estimate: interest on the rolled acquisition loan, construction ($) | 1,189,388 | |||
| 34 | Reserve estimate: interest on construction draws ($) | 13,225,585 | |||
| 35 | Interest reserve with cushion ($) | 16,465,782 | |||
| 36 | Total loan commitment ($) | 219,058,577 | |||
| 37 | Loan-to-cost on total uses | 56.6% |
The sheet builds the interest reserve from three interest estimates, the largest being $13,225,585 on construction draws, and adds a 10% cushion to reach $16,465,782.
Total uses are $387,006,905, or $587,264 per unit. The loan is 55% of costs before financing plus the reserve, a total commitment of $219,058,577 and 56.6% of total uses. Sponsor equity is $167,948,328, or 43.4%.
Uses of funds at closing
Dollars. The three hard-cost groups are highlighted. The purchase basis is the first bar
Compound workbook, Sources & Uses sheet, cells C6 to C18. Hard costs are analyst assumptions per square foot, escalated with BLS series.
The three hard-cost groups are 59.6% of uses (our arithmetic). The purchase basis is 3.4%. Total project cost less the basis and its closing costs is about $369.9 million (our arithmetic). A free building would still cost more than twice the finished value to convert.
The monthly schedule then tests the reserve. It capitalizes $12,600,130 of interest through completion, so $3,865,651 of the reserve is unused. Total project cost with capitalized interest is $383,141,253.
Apartment rents and finished value per unit
Underwritten rent is $1,778 a month across the unit mix, taken from Apartment List’s Downtown Hartford averages with no premium. Finished value is $194,167 per unit at completion, from Zillow home values by bedroom, and all but one of the workbook’s reference values are lower.
| B | C | D | E | F | |
|---|---|---|---|---|---|
| 5 | UNDERWRITTEN RENTS (TODAY'S $ PER UNIT PER MONTH) | Studio | One-bed | Two-bed | Weighted |
| 6 | HUD Small Area FMR, ZIP 06103 (FY2027) | 1,650 | 1,890 | 2,370 | 1,914 |
| 7 | HUD FMR, Hartford metro (FY2027) | 1,346 | 1,543 | 1,933 | 1,562 |
| 8 | Apartment List, Downtown Hartford (studio: on-plaza comp) | 1,554 | 1,740 | 2,210 | 1,778 |
| 9 | Apartment List, Hartford city | 1,432 | 1,501 | 1,717 | 1,524 |
| 10 | Unit mix | 30% | 50% | 20% | 100% |
| 11 | Underwritten rent | 1,554 | 1,740 | 2,210 | 1,778 |
| 12 | Zillow ZORI, ZIP 06103, all units | 1,579 | |||
| 13 | Zillow ZORI, Hartford metro, multifamily | 1,911 | |||
| 14 | Underwritten rent vs ZORI ZIP 06103 | 12.6% | |||
| 15 | Underwritten rent vs HUD SAFMR | (7.1%) | |||
| 17 | SALE VALUE PER UNIT (COMPARABLE SALES, TODAY'S $) | Studio | One-bed | Two-bed | Weighted |
| 18 | Zillow ZHVI by bedroom, Hartford metro | 138,424 | 162,852 | 300,072 | 182,968 |
| 19 | Adjustment to comp value | 0.0% | |||
| 20 | Comp value per unit, today ($) | 182,968 | |||
| 21 | CT recorded sales: Hartford condos, mean | 151,215 | |||
| 22 | CT recorded sales: Hartford condos, median | 108,000 | |||
| 23 | Hartford County multifamily, 2025 price per unit | 117,031 | |||
| 24 | Zillow ZHVI, metro condos (all sizes) | 269,064 | |||
| 25 | Comp value vs CT recorded-sales mean | 21.0% |
Apartment List’s Downtown Hartford averages are $1,740 and $2,210 for one and two bedrooms, and the studio rent of $1,554 is a listing at 5 Constitution Plaza.
Monthly rent per unit by source, weighted by the unit mix
Dollars per unit per month. The underwritten rent is highlighted. ZORI figures are single series with no bedroom detail
Compound workbook, Exit sheet, cells F6 to F13. HUD figures are FY2027, Zillow ZORI is September 2026, and Apartment List pages were read on November 15, 2026.
Compound underwrote the downtown averages, $1,778 weighted, with a 0% premium for new units. That is 12.6% above the ZORI figure for the ZIP and 7.1% below the HUD figure.
For value, the request asked for Zillow’s ZHVI for the metro. The September 2026 values for the Hartford metro are $162,852 for a one-bedroom home and $300,072 for a two-bedroom. ZHVI has no studio series, so the model sets a studio at 85% of the one-bedroom value, $138,424. Weighted by the mix, the value is $182,968 per unit today. Growth of 2% a year to completion makes it $194,167, and 659 units make a finished value of $127,955,895.
The sheet then lists what else the market says. Connecticut’s recorded sales show 178 Hartford condo sales from October 2024 to September 2025 with a mean of $151,215 and a median of $108,000. A broker’s county market report puts 2025 multifamily sales in Hartford County at $117,031 per unit and an 8.3% average cap rate. The one higher reference is ZHVI for metro condos of all sizes, $269,064.
Cost per unit against every value per unit in the workbook
Dollars per apartment. Total project cost is the first bar. The value the model uses is highlighted
Compound workbook, Exit sheet, cells C44, C39, F20, C32, F21, F23 and F22. Zillow ZHVI is September 2026. Connecticut recorded sales are from the state's open-data portal.
The exit cap rate is the cross-check the request asked for. In the first stabilized year the model’s net operating income is $7,819,721, or $11,866 per unit. At a 7.25% exit cap, an analyst assumption, the income is worth $107,858,223, or $163,670 per unit. That is 19.1% below the comp value at the same date.
ZHVI measures for-sale homes across a metro, and the subject is rental apartments in one downtown. None of the references is a sale of a newly converted downtown apartment building. We would treat $194,167 as the generous end of the evidence in this workbook.
Does the finished value carry the cost? Two exits side by side
It does not. Total project cost with capitalized interest is $383,141,253 and finished value at completion is $127,955,895, so the model raises its flag and both exits lose money.
| B | C | D | |
|---|---|---|---|
| 36 | FINISHED VALUE AGAINST TOTAL COST (AT COMPLETION) | ||
| 37 | Completion date | Nov-2029 | |
| 38 | Apartment units | 659 | |
| 39 | Comp value per unit at completion ($) | 194,167 | |
| 40 | Project costs before interest, through completion ($) | 370,541,123 | |
| 41 | Interest capitalized through completion ($) | 12,600,130 | |
| 42 | Total project cost incl. capitalized interest ($) | 383,141,253 | |
| 43 | Budgeted total uses incl. interest reserve ($) | 387,006,905 | |
| 44 | Total project cost per unit ($) | 581,398 | |
| 45 | Total project cost per sf ($) | 581 | |
| 46 | Finished value at completion ($) | 127,955,895 | |
| 47 | Finished value less total project cost ($) | (255,185,359) | |
| 48 | Flag: finished value below total cost | FLAG: finished value $128.0M is below total cost $383.1M | |
| 49 | Flag: interest reserve runs out before completion | OK: reserve covers interest to completion, $3.9M left | |
| 51 | RETURNS | Sell at completion | Hold to stabilization |
| 52 | Exit date | Nov-2029 | Dec-2036 |
| 53 | Gross sale price ($) | 127,955,895 | 119,704,561 |
| 54 | Net sale proceeds ($) | 125,396,777 | 117,310,470 |
| 55 | Loan repaid at exit ($) | 215,192,926 | 70,993,580 |
| 56 | Equity invested ($) | 257,744,477 | 348,336,452 |
| 57 | Equity distributions ($) | 0 | 57,266,747 |
| 58 | Levered profit ($) | (257,744,477) | (291,069,705) |
| 59 | Equity multiple | 0.00x | 0.16x |
| 60 | Levered IRR (annualized) | n.m. | (26.0%) |
| 61 | Unlevered profit ($) | (245,144,346) | (212,124,860) |
| 62 | Unlevered IRR (annualized) | (70.0%) | (10.5%) |
| 63 | Permanent loan at stabilization ($) | 75,500,756 | |
| 64 | Permanent loan rate | 6.90% | |
| 65 | DSCR on forward NOI at stabilization | 1.31x | |
| 66 | Yield on total project cost (forward NOI at stabilization) | 2.0% |
The flag reads “FLAG: finished value $128.0M is below total cost $383.1M”. Finished value is 33.4% of cost, and cost per unit is 2.99x value per unit (our arithmetic). The Summary sheet states the same gap as a break-even: each apartment would need to be worth $581,398.
Sell at completion. The sale in November 2029 brings $127,955,895, or $125,396,777 after 2% selling costs. That price is the comp value from Zillow home values, applied to a building that has not yet leased. The loan balance is $215,192,926. Sale proceeds fall $89.8 million short of the loan (our arithmetic), and the sponsor pays that on top of the equity commitment. Equity invested is $257,744,477, distributions are zero and the equity multiple is 0.00x. The levered IRR cell reads “n.m.” and the unlevered IRR is negative 70.0%.
Hold to stabilization. The hold ends in December 2036. The permanent loan prices at the 10-year Treasury par yield of 5.15% plus an assumed 1.75%, or 6.90%. It is the smaller of 70% of value at the exit cap and the loan that income covers 1.25x. The result is $75,500,756 with coverage of 1.31x.
The monthly schedule shows the construction loan at $252,290,359 when the permanent loan funds. The permanent loan repays part of it, and the sponsor funds the other $176.8 million or so (our arithmetic). Equity invested rises to $348,336,452, distributions total $57,266,747, and the equity multiple is 0.16x. The levered IRR is negative 26.0% and the unlevered IRR is negative 10.5%.
Holding loses more dollars than selling, $291,069,705 against $257,744,477, for two reasons. First, the two exits use different value bases. The sale at completion uses the comp value, $127,955,895. The sale at the end of the hold capitalizes forward net operating income at the 7.25% exit cap, which gives $119,704,561 seven years later. In the first stabilized year the cap-rate method gives a value 19.1% below the comp value.
Second, carry. The building earns a 2.0% yield on its total cost while debt costs 6.90% or more. For value at the 7.25% cap to equal total cost, net operating income would need to be about $27.8 million, roughly 3.6 times the model’s figure (our arithmetic).
Entitlement delay sensitivity: 6, 12 and 18 months
Each six months of delay adds between $9.0 million and $9.5 million to total cost (our arithmetic on the table). The interest reserve lasts to completion in all three cases, with $928,752 left after an 18-month delay.
| B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|
| 7 | Entitlement delay (months) | Sell: levered profit ($) | Sell: levered IRR | Hold: levered profit ($) | Hold: levered IRR | Total project cost ($) | Finished value less total cost ($) | Reserve left at completion ($) |
| 8 | Live case | (257,744,477) | n.m. | (291,069,705) | (26.0%) | 383,141,253 | (255,185,359) | 3,865,651 |
| 9 | 0 | (257,744,477) | n.m. | (291,069,705) | (26.0%) | 383,141,253 | (255,185,359) | 3,865,651 |
| 10 | 6 | (265,494,933) | n.m. | (300,495,520) | (26.3%) | 392,139,469 | (262,910,350) | 2,942,888 |
| 11 | 12 | (273,510,879) | n.m. | (310,395,476) | (26.7%) | 401,415,592 | (270,900,579) | 1,928,703 |
| 12 | 18 | (281,691,143) | n.m. | (320,488,481) | (27.1%) | 410,868,571 | (279,054,869) | 928,752 |
The delay is one input on the Assumptions sheet, and the whole model reruns for each row: the draw dates, the forward rates on those dates and the reserve balance. Total cost rises from $383,141,253 on plan to $410,868,571 at 18 months. The loss in the sale case grows from $257,744,477 to $281,691,143, and the levered IRR of the hold case moves from negative 26.0% to negative 27.1%.
Interest reserve left at completion, by entitlement delay
Dollars of the $16,465,782 reserve unused when construction ends
Compound workbook, Sensitivity sheet, cells I9 to I12.
The reserve shrinks from $3,865,651 to $928,752 across the cases. In a conversion with a thin positive margin, a cost of this size for each six months could decide the outcome.
What public data cannot tell you about a conversion candidate
Public filings describe the building as a lender reports it: size, age, occupancy, income, appraisal and loan. A conversion depends on the building’s layout, its condition and its leases, and those come from the seller.
Compound’s summary ends with the list it would ask the seller for. Each item replaces a labeled assumption.
- The rent roll, the leases and any termination rights. The model assumes vacant possession when construction starts and carries no buyout cost. The leases say when that can happen and what it costs.
- Floor plans for each building. Floor-plate depth and the position of cores and windows set the efficiency and the unit count.
- Condition and hazardous-materials surveys. These drive all three hard-cost groups, which are priced here from one Denver building’s budget.
- The May 2025 appraisal and the terms of a sale. The basis here is a rule applied to a filed appraisal. The price a seller would accept is not in the filing.
- The assessment, the tax bill, title and the plaza’s shared areas. The carry in the model applies the state’s 70% ratio and current mill rates to the basis, and what the six addresses share affects both cost and value. The $2,000 per unit of tax after completion assumes a tax agreement.
Our view: start with value per unit against cost per unit
A low basis does not make a conversion work. In this model the building could be free and conversion would still cost more than twice what the finished apartments are worth.
The basis is 3.4% of uses, and hard cost alone is more than the finished value. So the first test of a conversion is two numbers: all-in cost per unit and value per unit in that submarket. Here they are $581,398 and $194,167. The other side has weight, and it is local. The Sources sheet records two completed Hartford conversions from a Hartford Courant article of August 3, 2025: the plaza’s former hotel, converted to 190 units for $26M, and 777 Main, converted to 285 units for $84.5M. Those work out to about $137,000 and $296,000 per unit (our arithmetic), both far under this model’s $581,398. The workbook does not adjust those costs for date or say what they include.
The model’s cost comes from a different method: one Denver building’s budget per square foot, applied to all 659,315 square feet, or about 1,000 gross square feet for each apartment (our arithmetic). At the higher local figure, 659 units would cost about $195.4 million, still above the finished value. At the lower one they would cost about $90.2 million, below it (our arithmetic). We would not accept or reject a conversion on a cost per square foot borrowed from another city.
Three things would change our view: a survey and floor plans that cut hard cost per unit, public money such as tax credits or a tax agreement, and rent evidence from new downtown units that supports a premium over the average.
Other models answer the neighboring questions. A real estate development pro forma builds new apartments on land, where cost per square foot buys a floor plate designed for housing. An office lease rollover analysis keeps a building as office and asks what its leases are worth. A construction-to-permanent loan model isolates the takeout that the hold case here shows falling short.
Adaptive reuse pro forma (Excel)Compound’s workbook from this run: a Summary with the result, both flags and the delay cases; the Assumptions sheet with a source or a reason for every input and the SOFR forward curve; the Existing Shell, Entitlement, Construction, Exit and Sources & Uses sections; the Sensitivity data table; the Monthly CF engine; and the Sources list.Download · FreeFrequently asked questions
What is an adaptive reuse pro forma?
It is a model of converting an existing building to a new use: a purchase basis for the shell, a holding period for approvals, a construction budget and draw schedule, a finished value, and sources and uses. Its main output is whether the finished value is more than total cost.
How much does an office-to-apartment conversion cost per square foot?
Published ranges are wide. The workbook records a CBRE range of $250 to $650 per square foot. This model takes $322.45 of hard cost at April 2025 prices from a City of Denver case study, which becomes $350.03 today after BLS escalation. With contingency, soft costs, fee, inflation, carry and financing, total project cost is $581 per square foot.
What purchase price makes an office-to-residential conversion work?
Work backward: finished value, less conversion cost and financing, less a profit margin, is the most you can pay for the shell. In this model the answer is below zero. Total cost without the purchase is about $369.9 million (our arithmetic) against a finished value of $128.0 million. A price is an assumption here, set at the $13,000,000 appraisal.
How do entitlement delays affect a conversion pro forma?
A delay extends tax, insurance and loan interest on an empty building and moves every construction draw later at inflated prices. In this model each six months adds between $9.0 million and $9.5 million to total cost (our arithmetic).
How is an adaptive reuse pro forma different from a development pro forma?
A ground-up model starts with land. A conversion starts with a structure, so it adds demolition and abatement, repair of existing systems, a larger contingency and the loss of the old income. The existing floor plate sets how much of the area becomes rentable.





