A new 10-year loan on this Los Angeles apartment tower costs 6.75%. The property earns 5.05% on the purchase price in Year 1. The model returns a 6.22% unlevered IRR and a 4.86% levered IRR, so borrowing half the price lowers the return on equity, and the levered figure sits below the 5.15% 10-year Treasury yield the loan was priced from.
You are on the acquisitions team of an institutional apartment investor, and you want a committee-ready pro forma on a real building before a seller has sent a rent roll. We asked Compound to pick a property from the CMBS loan-level filings and build the model from public data. It ran on November 15, 2026 and returned one Excel workbook with nine sheets and a short summary.
Compound picked the property that the Form ABS-EE of Benchmark 2019-B12 Mortgage Trust names 10000 Santa Monica Blvd, in ZIP 90067 in Los Angeles. The filing reports 281 units built in 2017, and the trust’s prospectus lists the property type as multifamily, high rise. The request set the purchase price at the latest appraised value, and the latest appraisal in the filing is $535 million, dated March 25, 2019. That price is an assumption of the exercise. The appraisal was made when the loan was securitized, and nothing here is a current value for the property, a forecast of what it will earn, or advice to buy or sell it.
What the workbook shows:
- Leverage lowers the return at this price. The unlevered IRR is 6.22% and the levered IRR is 4.86%, with equity multiples of 1.63x and 1.47x. The 6.75% coupon is 170 basis points above the 5.05% Year-1 cap rate (our arithmetic).
- Two of the three flags in the request trip. Negative leverage flags, and DSCR falls to 1.13x after the year-5 refinance and stays below 1.25x for four years. The tax reassessment flag reads OK only because reassessed tax is $2,040,351 below the model’s estimate of the current bill. Before that cut the Year-1 cap rate is 4.67% (our arithmetic).
- The price is $1,903,915 a unit. That is 6.2x the $308,801 a home at which AvalonBay carries its Los Angeles region.
- The loan in place costs 4.15%. The filing and prospectus put it at $350 million, interest-only to May 6, 2029.
Each input in the workbook names its source or says “analyst assumption”. Property income, occupancy, the appraisal and the existing loan come from CMBS loan-level filings on SEC EDGAR. Bedroom rent ratios come from HUD Small Area Fair Market Rents, and market rent and growth from Zillow’s ZORI index and Apartment List. The expense mix comes from AvalonBay’s FY2025 10-K, and the per-unit check from Schedule III of the same 10-K. General expense growth is the Bureau of Labor Statistics CPI-U for Los Angeles, and debt is priced off the Daily Treasury Par Yield Curve.
“I am taking a stabilized apartment acquisition to investment committee and want a multifamily acquisition pro forma built on a real property, with no renovation plan. From the CMBS loan-level filings, pick one U.S. mid-rise or high-rise apartment property of roughly 200 to 500 units, at least 94% occupied, in a coastal metro such as Boston, New York, Washington, Los Angeles, San Diego, the San Francisco Bay Area or Seattle, whose latest report gives units, occupancy, revenue, operating expenses, net operating income, appraised value and the loan terms. Use it as the subject and its latest appraised value as the purchase price. Build a unit-mix rent roll by unit type: set the mix as an analyst assumption, scale in-place rents so they tie to reported revenue, and shape rents across types with the ratios between bedroom sizes in the HUD Fair Market Rents for the ZIP code or metro. Set market rent and growth per type from Zillow ZORI and Apartment List for the metro, and show loss-to-lease per type. Split reported operating expenses into property tax, insurance, payroll, utilities, repairs and management fee using the expense mix public apartment REITs report in their latest 10-K, and grow each line at its own rate, with general growth from the BLS CPI. Reassess property tax at the purchase price under the state's rules. Price a 10-year loan off today's 10-year Treasury yield, add a refinance at the end of year 5 sized to a target loan-to-value on NOI at that date, and show both next to the loan the property has now. Build: the rent roll and expense schedule; a 120-month cash flow rolled up to annual; the debt and refinance schedule with DSCR by year; sale in year 10 over an exit cap rate; unlevered and levered IRR side by side, equity multiple and year-1 cash-on-cash; the price per unit against what public apartment REITs carry buildings at in the same metro (Schedule III); and a sensitivity table of levered IRR to rent growth and exit cap rate. Flag negative leverage, a DSCR below 1.25x in any year, and a tax reassessment that cuts year-1 NOI by more than 5%. 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.
The subject property, the price and what the filing reports
The filing reports $26,906,608 of net operating income for the 12 months to June 30, 2026, which is a 5.03% cap rate on the $535 million price. The price is the 2019 appraised value because the request said to use it, and the Assumptions sheet labels it “Request”.
The Form ABS-EE for the reporting period ended October 13, 2026 also gives 97.86% occupancy, revenue of $51,139,742 and operating expenses of $24,233,134. Expenses are 47.4% of revenue, or $86,239 a unit a year (our arithmetic). The filing gives revenue and expenses only in total, so the model rebuilds the rent roll and the expense lines from other public sources.
| B | C | D | E | |
|---|---|---|---|---|
| 5 | Input | Value | Unit | Source / basis |
| 6 | SUBJECT PROPERTY (CMBS LOAN-LEVEL DATA) | |||
| 7 | Property | 10000 Santa Monica Blvd | name | Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026; property type per Benchmark 2019-B12 free writing prospectus, Annex A (July 2019): Multifamily, High Rise |
| 8 | Apartment units | 281 | units | Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 |
| 9 | Year built | 2017 | year | Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 |
| 10 | Physical occupancy (latest) | 97.86% | % | Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 |
| 11 | Revenue, trailing 12 months | 51,139,742 | $ | Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 (TTM 7/1/2025 to 6/30/2026) |
| 12 | Operating expenses, trailing 12 months | 24,233,134 | $ | Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 |
| 13 | Net operating income, trailing 12 months | 26,906,608 | $ | Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 (CREFC basis) |
| 16 | Most recent appraised value (MAI) | 535,000,000 | $ | Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 |
| 17 | Appraisal date | 03/25/2019 | date | Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026; the appraisal is from securitization, so it is 7.6 years old |
| 19 | EXISTING LOAN (IN PLACE TODAY) | |||
| 20 | Trust notes A-3, A-4, A-6 (in Benchmark 2019-B12) | 50,000,000 | $ | Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 |
| 21 | Pari passu companion notes (other trusts) | 170,000,000 | $ | Benchmark 2019-B12 free writing prospectus, Annex A (July 2019), cut-off pari passu companion balance |
| 22 | Subordinate companion note (B-note) | 130,000,000 | $ | Benchmark 2019-B12 free writing prospectus, Annex A (July 2019), cut-off subordinate companion balance |
| 23 | Senior note coupon | 4.15% | % | Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 (fixed) |
| 27 | Maturity date | 05/06/2029 | date | Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 |
| 28 | Interest-only term | 120 | months | Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 (interest only for full term, balloon) |
| 29 | Prepayment lockout end | 02/05/2029 | date | Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026; prospectus: Lockout/27, Defeasance/89, open last 4 payments |
| 30 | Reported senior debt service, trailing 12 months | 9,256,806 | $ | Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 (senior notes only) |
| 31 | Reported DSCR on NOI | 2.91x | x | Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 |
| 33 | ACQUISITION | |||
| 34 | Purchase price (= latest appraised value) | 535,000,000 | $ | Request: latest appraised value is the purchase price |
| 35 | Closing date | 12/31/2026 | date | Analyst assumption: year-end 2026 close so Year 1 is calendar 2027 |
| 36 | Buyer closing costs | 1.00% | % of price | Analyst assumption: title, legal, diligence; City of LA transfer and ULA taxes are customarily paid by the seller |
| 37 | Hold period | 10 | years | Request: sale in year 10 |
The sheet notes beside the appraisal date that the appraisal is 7.6 years old. The loan in place has three parts: $50 million of notes A-3, A-4 and A-6 held by the trust, $170 million of pari passu companion notes in other trusts and a $130 million subordinate note, all at 4.15%. The filing reports the trust’s notes, and Compound took the companion balances from Annex A of the trust’s July 2019 free writing prospectus.
The closing date of December 31, 2026 and buyer closing costs of 1.00% of the price are analyst assumptions. Equity at close is $274,856,250: the price and closing costs of $540,350,000, less the $267,500,000 loan, plus the loan’s 0.75% origination fee.
The unit-mix rent roll and loss-to-lease
The filing reports no unit mix and no rents, so Compound built a four-type rent roll that ties to reported revenue to the dollar. In-place rent averages $13,948 a month and market rent $14,032, a loss-to-lease of 0.6%.
The request asked for the mix as an analyst assumption, and Compound set it at 14 studios, 98 one-bedrooms, 113 two-bedrooms and 56 units of three bedrooms or more.
In-place rent is built in three steps. Compound took 10% of reported revenue as other income, an analyst assumption, which leaves $46,025,768 of rental revenue. It took the ratios between bedroom sizes from HUD’s FY2026 Small Area Fair Market Rents for ZIP 90067, which run from $3,020 for a studio to $5,350 for a three-bedroom. Then it solved for the one factor that makes those rents, across the assumed mix and the reported 97.86% occupancy, add up to the rental revenue. The factor is 3.4082, and its formula is in the excerpt below.
| B | C | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|
| 4 | Unit type | Units | HUD SAFMR ($/mo) | HUD ratio to 2BR | In-place rent ($/mo) | Apt. List shape ($/mo) | Market rent ($/mo) | Loss-to-lease ($) | Loss-to-lease |
| 5 | Studio | 14 | 3,020 | 0.72x | 10,293 | 1,665 | 10,207 | (85) | (0.8%) |
| 6 | 1 bedroom | 98 | 3,380 | 0.80x | 11,520 | 1,864 | 11,424 | (96) | (0.8%) |
| 7 | 2 bedroom | 113 | 4,220 | 1.00x | 14,383 | 2,377 | 14,568 | 186 | 1.3% |
| 8 | 3 bedroom and larger | 56 | 5,350 | 1.27x | 18,234 | 3,013 | 18,469 | 235 | 1.3% |
| 9 | Total / weighted average | 281 | 4,092 | 13,948 | 2,289 | 14,032 | 84 | 0.6% | |
| 11 | TIE-OUT TO REPORTED REVENUE | ||||||||
| 12 | Reported revenue, trailing 12 months ($) | 51,139,742 | |||||||
| 13 | Other income share | 10.0% | |||||||
| 14 | Other income ($) | 5,113,974 | |||||||
| 15 | Rental revenue ($) | 46,025,768 | |||||||
| 16 | Reported physical occupancy | 97.86% | |||||||
| 17 | In-place scale factor on HUD SAFMR | 3.4082 | |||||||
| 18 | Mark-to-market factor (ZORI growth over average lease age) | 1.0060 | |||||||
| 19 | Market scale factor on Apartment List shape | 6.1288 | |||||||
| 20 | Check: modeled in-place revenue less reported revenue ($) | - |
The weighted in-place rent is 5.2 times the Zillow ZORI multifamily index for the Los Angeles metro, which was $2,689.65 in September 2026 (our arithmetic). The agent’s summary says Apartment List’s medians are far below the tower’s roughly $14K in-place rent, so Compound used the metro sources only for growth and for the shape across unit types.
Market rent uses a second shape. Apartment List’s November 2026 report gives City of Los Angeles medians of $1,864 for a one-bedroom and $2,377 for a two-bedroom, and Compound extended those to the other two types with the HUD ratios. It scaled the shape so that the weighted market rent equals in-place rent marked up by half a year of ZORI growth: ZORI rose 1.21% in the year to September 2026, the average in-place lease is assumed to be 6 months old, and the mark-to-market factor is 1.0060.
Loss-to-lease differs by type because the two shapes disagree. Apartment List’s one-bedroom median is 0.78x of its two-bedroom median (our arithmetic), and HUD’s ratio is 0.80x. Studios and one-bedrooms show in-place rent 0.8% above market, and the larger types show it 1.3% below. A real rent roll would replace all of these figures, and rent roll analysis shows that tie-out on lease-level data.
Year-1 market rent growth is 0.55%, the average of ZORI’s 1.21% and Apartment List’s metro figure of (0.10%), and it is the same for every type because neither source publishes Los Angeles growth by bedroom size. Growth in years 2 to 10 is 3.00%, underwritten occupancy is 96.00% and bad debt and concessions take 1.00% of gross potential rent. All three are analyst assumptions.
Operating expenses by line and the Prop 13 reassessment
Compound split the reported $24,233,134 of expenses with AvalonBay’s same-store expense mix and then replaced the tax line with a reassessment at the purchase price. Reassessed tax is $6,417,887, which is $2,040,351 below the mix-based estimate of the current bill, so the reassessment flag reads OK.
The split has two steps. A management fee of 2.5% of effective gross income, an analyst assumption, comes out first, because AvalonBay’s same-store expense table excludes property management. The remaining $22,954,640 is divided in the proportions of AvalonBay’s FY2025 same-store lines: property taxes 35.8%, repairs and maintenance 18.7%, payroll 18.3%, utilities 13.1%, office operations and marketing 9.2% and insurance 4.9%.
Each line then grows at its own rate. General growth is the Los Angeles CPI-U, which rose 3.72% in the year to September 2026. Payroll and utilities grow at 4.22% and insurance at 6.72%; the spreads over CPI are analyst assumptions. Property tax grows at 2.00%, the cap on assessed value growth in the Los Angeles County Auditor-Controller’s 2025-26 Taxpayers’ Guide.
| B | C | D | E | F | H | I | |
|---|---|---|---|---|---|---|---|
| 4 | Expense line | AvalonBay ($000) | Share of mix | Allocated TTM ($) | Annual growth | Year 1, current basis | Year 1 underwritten |
| 5 | Property tax | 306,405 | 35.8% | 8,210,690 | 2.00% | 8,458,238 | 6,417,887 |
| 6 | Insurance | 42,098 | 4.9% | 1,128,094 | 6.72% | 1,243,664 | 1,243,664 |
| 7 | Payroll | 156,693 | 18.3% | 4,198,879 | 4.22% | 4,467,338 | 4,467,338 |
| 8 | Utilities | 112,313 | 13.1% | 3,009,635 | 4.22% | 3,202,059 | 3,202,059 |
| 9 | Repairs and maintenance | 159,930 | 18.7% | 4,285,621 | 3.72% | 4,526,852 | 4,526,852 |
| 10 | Other (office operations and marketing) | 79,178 | 9.2% | 2,121,721 | 3.72% | 2,241,150 | 2,241,150 |
| 11 | Management fee | 1,278,494 | 1,259,034 | 1,259,034 | |||
| 12 | Total operating expenses ($) | 856,617 | 100.0% | 24,233,134 | 25,398,335 | 23,357,983 | |
| 20 | PROPERTY TAX REASSESSMENT (PROP 13) | ||||||
| 21 | Purchase price ($) | 535,000,000 | |||||
| 22 | Share reassessed on change in ownership | 100% | |||||
| 23 | Total property tax rate | 1.200% | |||||
| 24 | Year-1 property tax, reassessed at purchase price ($) | 6,417,887 | |||||
| 25 | Year-1 property tax at current basis, from REIT mix ($) | 8,458,238 | |||||
| 26 | Increase in Year-1 tax from reassessment ($) | (2,040,351) | |||||
| 27 | Year-1 NOI as underwritten ($) | 27,003,368 | |||||
| 28 | Year-1 NOI before reassessment ($) | 24,963,017 | |||||
| 29 | Cut to Year-1 NOI from reassessment | (8.2%) | |||||
| 30 | Flag: reassessment cuts Year-1 NOI by more than threshold | OK |
For the reassessment, Compound cited the California Board of Equalization’s rule that a change in ownership is reassessed to current fair market value. The rate is the 1.00% base, plus 0.1196% for Los Angeles Unified School District debt from the Taxpayers’ Guide, plus 0.08% for other voter-approved debt, which is an analyst assumption. The total is 1.200%, under the 1.25% ceiling the guide gives for most of the county.
Read the flag with care. The request asked for a flag when reassessment cuts Year-1 NOI by more than 5%. The “cut” in the model is (8.2%), a negative number: reassessment raises Year-1 NOI from $24,963,017 to $27,003,368. The estimate of the current bill, $8,458,238, is a national REIT’s 35.8% tax share applied to this building’s expenses. At the 1.200% rate, a bill of that size implies an assessed value of about $705 million (our arithmetic), which is above the price. The agent’s summary says the result depends entirely on that mix, and that the flag could flip if the actual assessed value is below $535 million. As a cross-check, Compound computed the same share from Essex Property Trust’s FY2025 income statement and got 36.8%.
Year-1 NOI before reassessment is a 4.67% cap rate on the price (our arithmetic), against 5.05% as underwritten. The parcel’s tax bill settles which is right.
The 120-month cash flow and NOI by year
Year-1 NOI is $27,003,368, which is 0.4% above the trailing figure in the filing (our arithmetic), and it reaches $33,615,508 in Year 10. Expenses grow faster than rent, so the NOI margin falls from 53.6% to 51.2%.
The Monthly sheet runs 132 columns: 120 months of hold and 12 more that give the forward NOI the sale is priced on. Loss-to-lease burns off over the 12-month lease term: it costs $129,658 in Year 1 and is zero from Year 2. The Annual sheet rolls every line up by year with SUMIFS on the month’s year number, so no annual figure is typed.
| B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4 | Year | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Year 11 |
| 5 | Year ending | Dec-26 | Dec-27 | Dec-28 | Dec-29 | Dec-30 | Dec-31 | Dec-32 | Dec-33 | Dec-34 | Dec-35 | Dec-36 | Dec-37 |
| 9 | Gross potential rent at market | 47,456,833 | 48,346,574 | 49,796,972 | 51,290,881 | 52,829,607 | 54,414,495 | 56,046,930 | 57,728,338 | 59,460,188 | 61,243,994 | 63,081,314 | |
| 10 | Loss-to-lease | (129,658) | - | - | - | - | - | - | - | - | - | - | |
| 11 | Vacancy | (1,893,087) | (1,933,863) | (1,991,879) | (2,051,635) | (2,113,184) | (2,176,580) | (2,241,877) | (2,309,134) | (2,378,408) | (2,449,760) | (2,523,253) | |
| 12 | Bad debt and concessions | (474,568) | (483,466) | (497,970) | (512,909) | (528,296) | (544,145) | (560,469) | (577,283) | (594,602) | (612,440) | (630,813) | |
| 13 | Net rental income | 44,959,520 | 45,929,246 | 47,307,123 | 48,726,337 | 50,188,127 | 51,693,771 | 53,244,584 | 54,841,921 | 56,487,179 | 58,181,794 | 59,927,248 | |
| 14 | Other income | 5,401,832 | 5,602,684 | 5,811,003 | 6,027,069 | 6,251,168 | 6,483,600 | 6,724,674 | 6,974,712 | 7,234,047 | 7,503,024 | 7,782,002 | |
| 15 | Effective gross income ($) | 50,361,352 | 51,531,929 | 53,118,127 | 54,753,406 | 56,439,295 | 58,177,371 | 59,969,258 | 61,816,633 | 63,721,226 | 65,684,818 | 67,709,251 | |
| 24 | Total operating expenses ($) | (23,357,983) | (24,174,318) | (25,032,226) | (25,923,897) | (26,850,785) | (27,814,411) | (28,816,368) | (29,858,325) | (30,942,029) | (32,069,310) | (33,242,086) | |
| 25 | Net operating income ($) | 27,003,368 | 27,357,612 | 28,085,900 | 28,829,508 | 29,588,510 | 30,362,960 | 31,152,890 | 31,958,308 | 32,779,196 | 33,615,508 | 34,467,165 | |
| 26 | NOI margin | 53.6% | 53.1% | 52.9% | 52.7% | 52.4% | 52.2% | 51.9% | 51.7% | 51.4% | 51.2% | 50.9% | |
| 28 | Cash flow from operations ($) | 26,905,018 | 27,255,605 | 27,980,101 | 28,719,775 | 29,474,696 | 30,244,914 | 31,030,455 | 31,831,321 | 32,647,488 | 33,478,902 | 34,325,480 | |
| 33 | Debt service (interest + scheduled principal) | - | (18,307,031) | (18,357,188) | (18,307,031) | (18,307,031) | (18,307,031) | (26,828,750) | (26,760,981) | (26,757,319) | (26,753,391) | (26,810,602) | |
| 34 | Loan fundings, repayments and fees (net) | 265,493,750 | - | - | - | - | 57,744,965 | - | - | - | - | (311,794,219) | |
| 35 | Levered cash flow ($) | (274,856,250) | 8,597,987 | 8,898,417 | 9,673,069 | 10,412,743 | 68,912,630 | 3,416,164 | 4,269,474 | 5,074,002 | 5,894,096 | 277,995,843 | |
| 37 | DSCR (NOI / debt service) | 1.48x | 1.49x | 1.53x | 1.57x | 1.62x | 1.13x | 1.16x | 1.19x | 1.23x | 1.25x | ||
| 38 | Cash-on-cash (levered operating cash flow / equity) | 3.1% | 3.2% | 3.5% | 3.8% | 4.1% | 1.2% | 1.6% | 1.8% | 2.1% | 2.4% |
Year-1 effective gross income is $50,361,352, which is 1.5% below the reported trailing revenue (our arithmetic), because the model underwrites 96.00% occupancy against 97.86% reported. Year-1 expenses are $23,357,983, 3.6% below the trailing figure (our arithmetic), because of the reassessed tax line. The two changes roughly offset. From Year 2, rent grows 3.00% a year while insurance grows 6.72%, and NOI grows 24.5% over nine years (our arithmetic).
The sale is at the end of Year 10. Compound divided Year-11 NOI of $34,467,165 by a 5.50% exit cap rate to get a gross price of $626,675,724, or $2,230,163 a unit. The exit cap is an analyst assumption, about 45 bps over the Year-1 cap rate for a tower that will be 20 years old at sale. Selling costs are 6.95% of the price (our arithmetic): 5.95% for the City of Los Angeles transfer tax including Measure ULA, cited to the city’s Office of Finance, and 1.00% for brokers and legal. Net sale proceeds are $583,121,762.
The acquisition loan, the year-5 refinance and the loan in place
The acquisition loan is $267,500,000 at 6.75%, interest-only, and covers debt service 1.48x in Year 1. The year-5 refinance raises the loan to $331,232,288 at 7.00% with amortization, and DSCR drops to 1.13x in Year 6.
The coupon is the 10-year Treasury par yield of 5.15% at the close of November 13, 2026, plus a 1.60% spread, which is an analyst assumption for low-leverage fixed-rate apartment debt. Leverage is 50% of the price, and the sheet’s reason is that the loan is sized so Year-1 DSCR clears 1.25x.
| B | C | D | E | |
|---|---|---|---|---|
| 4 | Term | Existing loan (in place) | New acquisition loan | Year-5 refinance |
| 5 | Description | CMBS A-notes + B-note | 10-yr fixed off 10Y UST | Sized on year-6 NOI |
| 6 | Loan amount ($) | 350,000,000 | 267,500,000 | 331,232,288 |
| 7 | Coupon | 4.15% | 6.75% | 7.00% |
| 8 | Interest basis | Actual/360 | Actual/360 | Actual/360 |
| 9 | Term (months) | 120 | 120 | 60 |
| 10 | Interest-only period (months) | 120 | 120 | 0 |
| 11 | Amortization (months, 0 = none) | 0 | 360 | 360 |
| 12 | Contractual maturity (acquisition loan prepaid at refinance) | 05/06/2029 | 12/31/2036 | 12/31/2036 |
| 13 | Loan-to-value | 65.4% | 50.0% | 60.0% |
| 14 | First-year debt service ($) | 14,726,736 | 18,307,031 | 26,828,750 |
| 15 | NOI used for coverage ($) | 27,003,368 | 27,003,368 | 30,362,960 |
| 16 | DSCR | 1.83x | 1.48x | 1.13x |
| 17 | Debt yield | 7.72% | 10.09% | 9.17% |
| 18 | Debt constant | 4.21% | 6.84% | 8.10% |
| 20 | REFINANCE SIZING (END OF YEAR 5) | |||
| 21 | Forward 12-month NOI at refinance (Year 6) ($) | 30,362,960 | ||
| 22 | Refinance valuation cap rate | 5.50% | ||
| 24 | Value at refinance ($) | 552,053,813 | ||
| 25 | Refinance loan ($) | 331,232,288 | ||
| 26 | Acquisition loan balance repaid ($) | 267,500,000 | ||
| 27 | Prepayment cost ($) | 2,675,000 | ||
| 28 | Refinance costs ($) | 3,312,323 | ||
| 29 | Net cash-out to equity ($) | 57,744,965 |
The loan in place is the comparison. Compound put all $350,000,000 of it in the column, which is 65.4% of the price, and computed $14,726,736 of annual interest and a 1.83x DSCR on the model’s Year-1 NOI. The filing’s own figures are on a different base: $9,256,806 of debt service on the senior notes for the trailing 12 months and a DSCR of 2.91x. The new loan is smaller than the loan in place and costs $3,580,295 more a year (our arithmetic). The loan in place costs less than the 5.05% Year-1 cap rate, so a buyer able to assume it would have positive leverage until May 6, 2029.
For the refinance, Compound valued the property at Year-6 NOI of $30,362,960 over a 5.50% cap rate, which is $552,053,813, and lent 60% of it. The target, the 25 bps of extra coupon and the 360-month amortization are analyst assumptions. After repaying the acquisition loan, a 1% prepayment cost and refinance costs, the refinance returns $57,744,965 to equity.
Annual debt service rises by $8,521,719 to $26,828,750 (our arithmetic). The agent’s summary gives the reason: sizing on loan-to-value produces more debt than the NOI supports at 7%. A loan that covered Year-6 debt service 1.25x at the same debt constant of 8.10% would be about $299.9 million, or 54.3% of the refinance value (our arithmetic).
DSCR by year: the acquisition loan, then the year-5 refinance
NOI divided by debt service. Red bars are the years the workbook flags
Compound workbook, Debt sheet rows 16, 42 and 43, and Assumptions sheet
DSCR is 1.48x to 1.62x in Years 1 to 5, then 1.13x, 1.16x, 1.19x and 1.23x in Years 6 to 9, and 1.25x in Year 10. Cash-on-cash follows the same path: 3.1% in Year 1, 4.1% in Year 5 and 1.2% in Year 6. A purchase that depends on raising occupancy before a refinance has a different debt problem, and the multifamily value-add pro forma covers the version with a renovation schedule.
Returns, flags and negative leverage
The levered IRR of 4.86% is 136 basis points below the unlevered IRR of 6.22% (our arithmetic). Every dollar borrowed at 6.75% is invested in a property that returns less than that over the hold, so the equity return falls as debt is added.
Levered profit over ten years is $128,288,177 on $274,856,250 of equity. At the sale, net proceeds of $583,121,762 repay a refinance balance of $311,794,219 and leave $271,327,543 for equity (our arithmetic).
| Flag | Value | Test against | Result |
|---|---|---|---|
| Negative leverage: Year-1 cap rate below acquisition loan coupon | 5.05% | 6.75% | FLAG |
| Negative leverage: levered IRR below unlevered IRR | 4.86% | 6.22% | FLAG |
| Minimum DSCR, years 1-10, below threshold | 1.13x | 1.25x | FLAG |
| Property tax reassessment cuts Year-1 NOI by more than threshold | (8.2%) | 5.0% | OK |
Source: Compound workbook, Summary sheet, rows 27 to 30.
Compound wrote the negative leverage flag as two tests: the Year-1 cap rate against the coupon, and the levered IRR against the unlevered IRR.
Yields, loan coupons and model returns on one scale
Percent. Rates are as of November 13, 2026; returns are the model's base case at the 2019 appraised value
Compound workbook, Summary, Debt and Assumptions sheets: CMBS filing, Treasury par yield curve and model outputs
Holding Year-1 NOI fixed, the price at which the Year-1 cap rate equals the 6.75% coupon is about $400 million (our arithmetic). That figure measures the distance between the 2019 appraisal and November 2026 borrowing costs, and it says nothing about what the property is worth.
Sensitivity: levered IRR to rent growth and exit cap rate
Across long-run rent growth of 2.0% to 4.0% and exit cap rates of 5.00% to 6.00%, the levered IRR runs from (0.2%) to 9.6%. Six of the 25 cells are above the 6.75% loan coupon (our count).
| C | D | E | F | G | H | |
|---|---|---|---|---|---|---|
| 48 | Growth \ Exit cap | 5.00% | 5.25% | 5.50% | 5.75% | 6.00% |
| 49 | 2.0% | 2.8% | 2.0% | 1.2% | 0.5% | (0.2%) |
| 50 | 2.5% | 4.7% | 3.9% | 3.1% | 2.4% | 1.7% |
| 51 | 3.0% | 6.4% | 5.6% | 4.9% | 4.1% | 3.5% |
| 52 | 3.5% | 8.1% | 7.3% | 6.5% | 5.8% | 5.1% |
| 53 | 4.0% | 9.6% | 8.8% | 8.0% | 7.3% | 6.7% |
At a 5.50% exit cap, the levered IRR is 1.2% with 2.0% growth, 4.9% with 3.0% and 8.0% with 4.0%. At 3.0% growth, it is 6.4% at a 5.00% exit cap and 3.5% at 6.00%.
The base case of 3.00% growth is already above what the two rent sources show for the metro today, which is 1.21% on ZORI and (0.10%) on Apartment List. The evidence for a row is in the building’s own renewal and new-lease history, which the seller has.
Price per unit against what a public REIT carries buildings at
The price is $1,903,915 a unit, against a gross carrying amount of $308,801 a home for AvalonBay’s Los Angeles region. The closest single property in the comparison, Avalon Santa Monica on Main, is carried at $829,128 a home.
Compound took the region total and five properties from Schedule III of AvalonBay’s FY2025 10-K.
Price per unit: the subject against AvalonBay's Los Angeles carrying amounts
Dollars per unit or home. REIT figures are historical cost from Schedule III
Compound workbook, Comps sheet: CMBS filing and AvalonBay FY2025 10-K, Schedule III
The sheet’s header states that carrying amounts are historical cost and are not market value, and that the region total includes suburban and Ventura County communities. We read the comparison as a size check on the rent roll: a building priced at 6.2x a REIT’s regional cost per home has to collect rent in proportion, and the model’s $13,948 average in-place rent is what the filing’s revenue implies. For a newer asset in a market where the question is only what to pay, see core multifamily underwriting.
What the public data cannot tell you
The filing gives one year of totals for the property and the terms of the loan. The unit mix, the expense lines and the tax bill in this model are estimates built on those totals, and the seller holds the documents that replace them.
- A current rent roll. Unit mix, in-place rents, lease dates and concessions replace the assumed mix, the HUD and Apartment List shapes and the 6-month average lease age.
- A trailing 12 months by line. It replaces the 10% other-income share and the REIT expense mix.
- The parcel’s tax bill, assessed value and parcel number. These replace the mix-based estimate of the current bill and decide the reassessment flag.
- A current appraisal. The price in this model is a value from March 2019.
- Insurance renewal quotes. Insurance grows at the fastest rate in the model.
- A capital history and a property condition report, which test the $350 a unit reserve.
- The existing loan documents and a defeasance quote. The filing gives a prepayment lockout that ends February 5, 2029, after the model’s closing date, so a buyer needs the cost of defeasing the loan or the terms for assuming it.
Our view: what this pro forma is good for
We would take this workbook to a first committee discussion as the frame, with the price and the tax line marked open. Its most useful output is the list of three inputs that decide the answer: the price, the current tax bill and the refinance sizing.
At the 2019 appraised value, the model says debt at November 2026 rates does not help. That is a statement about the price input, which the request fixed and Compound labeled “Request”. An analyst would next run the workbook at a lower price and at a lower loan-to-value. Both are one-cell changes on the Assumptions sheet.
The tax reassessment is the item we would not rely on yet. The flag reads OK because a national REIT’s tax share was applied to this building’s expenses, and Compound said so in its summary.
The refinance is the clearest finding for a lender conversation. Sizing to 60% of value takes $57,744,965 out in year 5 and leaves four years under the 1.25x threshold.
This page is the stabilized, no-renovation case on an institutional high-rise. The real estate pro forma page covers the general structure across property types, and the small multifamily pro forma covers a small walk-up building with a choice of three loans.
Multifamily acquisition pro forma (Excel)Compound’s workbook from this run: a Summary with returns, flags, the three loans side by side and the sensitivity table, an Assumptions sheet with a source or reason beside every input, the unit-mix RentRoll, the Expenses schedule with the Prop 13 reassessment, the 132-month Monthly cash flow, the Annual roll-up, the Debt and refinance schedule, the Schedule III Comps and a Sources sheet.Download · FreeFAQ
What is a multifamily acquisition pro forma?
It is a model of buying, holding and selling an apartment building. It starts from a rent roll and an expense schedule, projects net operating income, layers on the loan, and prices a sale at the end of the hold. The outputs are the unlevered and levered IRR, the equity multiple, cash-on-cash and debt service coverage by year.
What should a multifamily acquisition pro forma include?
A rent roll by unit type with in-place rent, market rent and loss-to-lease. An expense schedule by line, with property tax restated for the purchase. A monthly cash flow, a debt schedule with DSCR by year, and a sale at an exit cap rate. Returns with and without debt, a sensitivity table, and a source beside each input.
How do you build a rent roll when you only have total revenue?
You assume a unit mix, take the ratios between bedroom sizes from a public source, and solve for the scale factor that makes the rents add up to reported rental revenue at reported occupancy. Compound did that here with HUD Small Area Fair Market Rents and a factor of 3.4082.
How is property tax handled when you buy an apartment building in California?
The model on this page reassesses the property at the purchase price, citing the California Board of Equalization’s rule that a change in ownership is reassessed to current fair market value. It applies a total rate of 1.200% and grows the tax 2.00% a year, the cap on assessed value growth in the Los Angeles County Taxpayers’ Guide.
What is negative leverage in a multifamily deal?
Negative leverage is when the loan’s interest rate is higher than the cap rate the property is bought at, so each borrowed dollar earns less than it costs. In this model the coupon is 6.75% and the Year-1 cap rate is 5.05%, and the levered IRR of 4.86% is below the unlevered IRR of 6.22%.
Why does DSCR fall after a refinance in a pro forma?
A refinance sized on loan-to-value lends against the property’s value, and a higher value at a low cap rate supports a loan whose payments the income covers only thinly. In this model the refinance loan is 60% of a value set at a 5.50% cap rate, the coupon is 7.00% and the loan amortizes, so debt service rises to $26,828,750 and DSCR falls from 1.62x in Year 5 to 1.13x in Year 6.





