Multifamily acquisition pro forma: leverage cuts the IRR to 4.86%

An acquisitions analyst asks Compound for an investment committee pro forma on a real 281-unit Los Angeles high-rise from the CMBS loan filings, priced at its 2019 appraised value, with a 10-year loan priced on the Treasury yield of November 13, 2026 and a refinance at the end of year 5.

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

Short answer

A multifamily acquisition pro forma projects a stabilized apartment purchase from the rent roll to the sale. Compound's model of a 281-unit Los Angeles high-rise, priced at its 2019 appraised value of $535 million, returns a 6.22% unlevered IRR and 4.86% levered, because the 6.75% loan costs more than the 5.05% Year-1 cap rate.

Try it now
On this page (11)
  1. 1. The subject property, the price and what the filing reports
  2. 2. The unit-mix rent roll and loss-to-lease
  3. 3. Operating expenses by line and the Prop 13 reassessment
  4. 4. The 120-month cash flow and NOI by year
  5. 5. The acquisition loan, the year-5 refinance and the loan in place
  6. 6. Returns, flags and negative leverage
  7. 7. Sensitivity: levered IRR to rent growth and exit cap rate
  8. 8. Price per unit against what a public REIT carries buildings at
  9. 9. What the public data cannot tell you
  10. 10. Our view: what this pro forma is good for
  11. 11. FAQ

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.

Prompt to try

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

Try this prompt free →

That is the request as we sent it, without its closing line, which asks that no name or email be put in the workbook.

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.

10000_Santa_Monica_Acquisition_Pro_Forma.xlsx
C34fx=C16
BCDE
5InputValueUnitSource / basis
6SUBJECT PROPERTY (CMBS LOAN-LEVEL DATA)
7Property10000 Santa Monica BlvdnameBenchmark 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
8Apartment units281unitsBenchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026
9Year built2017yearBenchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026
10Physical occupancy (latest)97.86%%Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026
11Revenue, trailing 12 months51,139,742$Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 (TTM 7/1/2025 to 6/30/2026)
12Operating expenses, trailing 12 months24,233,134$Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026
13Net operating income, trailing 12 months26,906,608$Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 (CREFC basis)
16Most recent appraised value (MAI)535,000,000$Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026
17Appraisal date03/25/2019dateBenchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026; the appraisal is from securitization, so it is 7.6 years old
19EXISTING LOAN (IN PLACE TODAY)
20Trust 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
21Pari passu companion notes (other trusts)170,000,000$Benchmark 2019-B12 free writing prospectus, Annex A (July 2019), cut-off pari passu companion balance
22Subordinate companion note (B-note)130,000,000$Benchmark 2019-B12 free writing prospectus, Annex A (July 2019), cut-off subordinate companion balance
23Senior note coupon4.15%%Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 (fixed)
27Maturity date05/06/2029dateBenchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026
28Interest-only term120monthsBenchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 (interest only for full term, balloon)
29Prepayment lockout end02/05/2029dateBenchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026; prospectus: Lockout/27, Defeasance/89, open last 4 payments
30Reported senior debt service, trailing 12 months9,256,806$Benchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026 (senior notes only)
31Reported DSCR on NOI2.91xxBenchmark 2019-B12 ABS-EE (EX-102), reporting period ended 10/13/2026
33ACQUISITION
34Purchase price (= latest appraised value)535,000,000$Request: latest appraised value is the purchase price
35Closing date12/31/2026dateAnalyst assumption: year-end 2026 close so Year 1 is calendar 2027
36Buyer closing costs1.00%% of priceAnalyst assumption: title, legal, diligence; City of LA transfer and ULA taxes are customarily paid by the seller
37Hold period10yearsRequest: sale in year 10
SummaryAssumptionsSourcesRentRollExpensesMonthlyAnnualDebtComps
The property, existing loan and acquisition blocks of the Assumptions sheet, as Compound wrote them. We chose the rows. Blue is a hardcoded input, yellow fill is an analyst assumption or a value set by the request, black is a formula. Column E says where each input came from.

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.

10000_Santa_Monica_Acquisition_Pro_Forma.xlsx
C17fx=C15/(12*C16*SUMPRODUCT(C5:C8,E5:E8))
BCEFGHIJK
4Unit typeUnitsHUD SAFMR ($/mo)HUD ratio to 2BRIn-place rent ($/mo)Apt. List shape ($/mo)Market rent ($/mo)Loss-to-lease ($)Loss-to-lease
5Studio143,0200.72x10,2931,66510,207(85)(0.8%)
61 bedroom983,3800.80x11,5201,86411,424(96)(0.8%)
72 bedroom1134,2201.00x14,3832,37714,5681861.3%
83 bedroom and larger565,3501.27x18,2343,01318,4692351.3%
9Total / weighted average2814,09213,9482,28914,032840.6%
11TIE-OUT TO REPORTED REVENUE
12Reported revenue, trailing 12 months ($)51,139,742
13Other income share10.0%
14Other income ($)5,113,974
15Rental revenue ($)46,025,768
16Reported physical occupancy97.86%
17In-place scale factor on HUD SAFMR3.4082
18Mark-to-market factor (ZORI growth over average lease age)1.0060
19Market scale factor on Apartment List shape6.1288
20Check: modeled in-place revenue less reported revenue ($)-
SummaryAssumptionsSourcesRentRollExpensesMonthlyAnnualDebtComps
The RentRoll sheet, as Compound wrote it. We chose the columns and shortened three headings; the sheet also has the mix share, gross potential rent and growth columns. The check in row 20 is modeled 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.

10000_Santa_Monica_Acquisition_Pro_Forma.xlsx
C29fx=C26/C28
BCDEFHI
4Expense lineAvalonBay ($000)Share of mixAllocated TTM ($)Annual growthYear 1, current basisYear 1 underwritten
5Property tax306,40535.8%8,210,6902.00%8,458,2386,417,887
6Insurance42,0984.9%1,128,0946.72%1,243,6641,243,664
7Payroll156,69318.3%4,198,8794.22%4,467,3384,467,338
8Utilities112,31313.1%3,009,6354.22%3,202,0593,202,059
9Repairs and maintenance159,93018.7%4,285,6213.72%4,526,8524,526,852
10Other (office operations and marketing)79,1789.2%2,121,7213.72%2,241,1502,241,150
11Management fee1,278,4941,259,0341,259,034
12Total operating expenses ($)856,617100.0%24,233,13425,398,33523,357,983
20PROPERTY TAX REASSESSMENT (PROP 13)
21Purchase price ($)535,000,000
22Share reassessed on change in ownership100%
23Total property tax rate1.200%
24Year-1 property tax, reassessed at purchase price ($)6,417,887
25Year-1 property tax at current basis, from REIT mix ($)8,458,238
26Increase in Year-1 tax from reassessment ($)(2,040,351)
27Year-1 NOI as underwritten ($)27,003,368
28Year-1 NOI before reassessment ($)24,963,017
29Cut to Year-1 NOI from reassessment(8.2%)
30Flag: reassessment cuts Year-1 NOI by more than thresholdOK
SummaryAssumptionsSourcesRentRollExpensesMonthlyAnnualDebtComps
The Expenses sheet, as Compound wrote it. We chose the rows and columns and shortened four headings; the sheet also has the trend factor column and three memo lines.

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.

10000_Santa_Monica_Acquisition_Pro_Forma.xlsx
D25fx=SUMIFS(Monthly!$D$33:$EE$33,Monthly!$D$6:$EE$6,D$4)
BCDEFGHIJKLMN
4YearYear 0Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
5Year endingDec-26Dec-27Dec-28Dec-29Dec-30Dec-31Dec-32Dec-33Dec-34Dec-35Dec-36Dec-37
9Gross potential rent at market47,456,83348,346,57449,796,97251,290,88152,829,60754,414,49556,046,93057,728,33859,460,18861,243,99463,081,314
10Loss-to-lease(129,658)----------
11Vacancy(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)
12Bad 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)
13Net rental income44,959,52045,929,24647,307,12348,726,33750,188,12751,693,77153,244,58454,841,92156,487,17958,181,79459,927,248
14Other income5,401,8325,602,6845,811,0036,027,0696,251,1686,483,6006,724,6746,974,7127,234,0477,503,0247,782,002
15Effective gross income ($)50,361,35251,531,92953,118,12754,753,40656,439,29558,177,37159,969,25861,816,63363,721,22665,684,81867,709,251
24Total 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)
25Net operating income ($)27,003,36827,357,61228,085,90028,829,50829,588,51030,362,96031,152,89031,958,30832,779,19633,615,50834,467,165
26NOI margin53.6%53.1%52.9%52.7%52.4%52.2%51.9%51.7%51.4%51.2%50.9%
28Cash flow from operations ($)26,905,01827,255,60527,980,10128,719,77529,474,69630,244,91431,030,45531,831,32132,647,48833,478,90234,325,480
33Debt 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)
34Loan fundings, repayments and fees (net)265,493,750----57,744,965----(311,794,219)
35Levered cash flow ($)(274,856,250)8,597,9878,898,4179,673,06910,412,74368,912,6303,416,1644,269,4745,074,0025,894,096277,995,843
37DSCR (NOI / debt service)1.48x1.49x1.53x1.57x1.62x1.13x1.16x1.19x1.23x1.25x
38Cash-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%
SummaryAssumptionsSourcesRentRollExpensesMonthlyAnnualDebtComps
The Annual sheet, as Compound wrote it. We chose the rows; the sheet also lists each expense line, replacement reserves and the unlevered cash flow. Year 11 is outside the hold and is shown as the forward NOI for the sale.

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.

10000_Santa_Monica_Acquisition_Pro_Forma.xlsx
C25fx=C24*Assumptions!C114*Assumptions!C112
BCDE
4TermExisting loan (in place)New acquisition loanYear-5 refinance
5DescriptionCMBS A-notes + B-note10-yr fixed off 10Y USTSized on year-6 NOI
6Loan amount ($)350,000,000267,500,000331,232,288
7Coupon4.15%6.75%7.00%
8Interest basisActual/360Actual/360Actual/360
9Term (months)12012060
10Interest-only period (months)1201200
11Amortization (months, 0 = none)0360360
12Contractual maturity (acquisition loan prepaid at refinance)05/06/202912/31/203612/31/2036
13Loan-to-value65.4%50.0%60.0%
14First-year debt service ($)14,726,73618,307,03126,828,750
15NOI used for coverage ($)27,003,36827,003,36830,362,960
16DSCR1.83x1.48x1.13x
17Debt yield7.72%10.09%9.17%
18Debt constant4.21%6.84%8.10%
20REFINANCE SIZING (END OF YEAR 5)
21Forward 12-month NOI at refinance (Year 6) ($)30,362,960
22Refinance valuation cap rate5.50%
24Value at refinance ($)552,053,813
25Refinance loan ($)331,232,288
26Acquisition loan balance repaid ($)267,500,000
27Prepayment cost ($)2,675,000
28Refinance costs ($)3,312,323
29Net cash-out to equity ($)57,744,965
SummaryAssumptionsSourcesRentRollExpensesMonthlyAnnualDebtComps
The loan comparison and refinance sizing blocks of the Debt sheet, as Compound wrote them. We chose the rows; the sheet continues with balances, interest, principal and DSCR for each of the ten years.

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

Loan in place, all notes, on Year-1 NOI1.83Year 1 (acquisition loan)1.48Year 21.49Year 31.53Year 41.57Year 51.62Year 6 (after refinance)1.13Year 71.16Year 81.19Year 91.23Year 101.25Flag threshold set in the request1.25

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

FlagValueTest againstResult
Negative leverage: Year-1 cap rate below acquisition loan coupon5.05%6.75%FLAG
Negative leverage: levered IRR below unlevered IRR4.86%6.22%FLAG
Minimum DSCR, years 1-10, below threshold1.13x1.25xFLAG
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

Loan in place: coupon (filing)4.15Levered IRR (model)4.86Cap rate on reported trailing NOI5.03Year-1 cap rate (model)5.0510-year Treasury par yield, 11/13/20265.15Exit cap rate (analyst assumption)5.5Unlevered IRR (model)6.22Acquisition loan coupon6.75Year-5 refinance coupon7

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

10000_Santa_Monica_Acquisition_Pro_Forma.xlsx
F51fx=Assumptions!F155
CDEFGH
48Growth \ Exit cap5.00%5.25%5.50%5.75%6.00%
492.0%2.8%2.0%1.2%0.5%(0.2%)
502.5%4.7%3.9%3.1%2.4%1.7%
513.0%6.4%5.6%4.9%4.1%3.5%
523.5%8.1%7.3%6.5%5.8%5.1%
534.0%9.6%8.8%8.0%7.3%6.7%
SummaryAssumptionsSourcesRentRollExpensesMonthlyAnnualDebtComps
The sensitivity block of the Summary sheet, as Compound wrote it. Rows are long-run rent growth and columns are the exit cap rate. The values link to a what-if data table on the Assumptions sheet, and the base case is 3.0% growth at a 5.50% exit cap.

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

AvalonBay Los Angelesregion, net of depreciation$197,065AvalonBay Los Angeles region, gross$308,801Avalon Playa Vista, gross$369,741Avalon Wilshire, gross$441,192Avalon West Hollywood, gross$536,595AVA Hollywood at La Pietra Place, gross$539,596Avalon Santa Monica on Main, gross$829,128Subject at the purchase price$1,903,915Subject at the Year-10 sale price (model)$2,230,163

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 · Free

FAQ

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.

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

See this workflow on your own deal

Try it now