Value-add multifamily screen: 9.26% yield on cost, exit cap flagged

An acquisitions analyst at an institutional apartment investor asks Compound for a one-sheet value-add screen and tests it on a real 157-unit property from the CMBS loan filings, priced at its 2021 appraised value, with a new loan priced off the Treasury yield of November 13, 2026.

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

Short answer

A value-add multifamily screen is a one-sheet model that tests an apartment renovation on yield on cost, debt coverage and levered IRR before full underwriting. Compound's screen of a 157-unit Virginia property at its 2021 appraised value shows a 9.26% yield on cost and flags the exit cap rate its IRR depends on.

Try it now
On this page (10)
  1. 1. Nine inputs, and where each one came from
  2. 2. The subject property: in-place rent from a CMBS filing
  3. 3. Market rent after renovation: ZORI, Apartment List and HUD
  4. 4. The five-year pro forma: rent stepping to market
  5. 5. Going-in cap rate, yield on cost and the loan
  6. 6. Levered IRR, equity multiple and average cash-on-cash
  7. 7. The four flags and the IRR sensitivity
  8. 8. What public data cannot tell you about this deal
  9. 9. Our view: worth a full underwriting, at a real price
  10. 10. FAQ

A 157-unit apartment property outside Richmond, Virginia, bought at its last appraised value and renovated for about $15,000 a unit, shows a 9.26% yield on cost on Compound’s one-sheet screen, against an 8.29% going-in cap rate. The sheet’s levered IRR over five years is 24.4%, and the same sheet raises one of its four flags against it. The model buys at an 8.29% cap rate and sells at 6.50%. With the sale priced at the going-in cap rate, the IRR is 16.3% (our arithmetic, using the workbook’s own cash flows).

You triage value-add apartment teasers on the acquisitions team of an institutional investor, and most of them deserve fifteen minutes before anyone builds a full model. We asked Compound to build that screen and to test it on a real property from public filings. It ran on November 15, 2026 and returned one Excel workbook and a short summary.

Compound picked Oakbrook, a 157-unit property built in 1988 in Glen Allen, Virginia, in the Richmond metro. It is one of three properties securing loan 14 of BANK 2021-BNK33, and the trust’s Form ABS-EE filed on October 28, 2026 is the source of every property figure here. The request set the purchase price at the latest appraised value, and the only appraisal in the filing is $16.7 million, dated February 16, 2021. That price is an assumption of the exercise. Nothing on this page 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:

  • In-place rent is 17.1% below the metro index. Revenue per occupied unit works out to $1,331 a month, against a Zillow ZORI multifamily rent of $1,605 for the Richmond metro.
  • The renovated rent is $1,600, below the best comparable. The HUD two-bedroom Fair Market Rent, asked for as a low-end check, is $1,651 and is the highest of the three benchmarks.
  • Yield on cost is 9.26% against an 8.29% going-in cap rate. The 97 basis points between them clear the 50 basis point minimum in the request.
  • Debt coverage has room. A 65% loan at 6.90% is covered 1.87x in Year 1, against a 1.25x minimum.
  • One flag is raised. The 6.50% exit cap rate is tighter than the going-in rate, and the going-in rate divides 2026 income by a 2021 appraisal.

Property and loan figures come from CMBS loan-level filings on SEC EDGAR. Market rents come from Zillow’s ZORI index, Apartment List’s monthly rent estimates and HUD’s Fair Market Rents. The loan is priced off the Daily Treasury Par Yield Curve. The renovation budget, stabilized expenses, loan spread and exit cap rate are analyst assumptions, and the workbook labels each one that way with the reason for the value.

Prompt to try

“I triage value-add apartment teasers and want a value-add multifamily screen that takes about fifteen minutes a deal, tested on a real property. From the CMBS loan-level filings, pick one U.S. apartment property of roughly 100 to 250 units, built between 1970 and 1995, in a Mid-Atlantic metro such as Philadelphia, Baltimore, Pittsburgh, Richmond or Virginia Beach, whose average in-place rent, worked out from reported revenue, units and occupancy, sits at least 10% below the Zillow ZORI rent for its metro, and whose latest report gives net operating income, operating expenses, appraised value and the loan terms. Use it as the subject and its latest appraised value as the price. Set current average rent from the filing. Set market rent after renovation from ZORI and Apartment List rent for the metro, with the HUD Fair Market Rent for its ZIP code as a low-end check, and name the highest of those figures as the best comparable. Set the renovation budget as one total figure and stabilized expenses per unit as analyst assumptions, with the expenses checked against what the property reports today. Price one loan at 65% loan-to-value off today's 10-year Treasury yield plus a spread. Build the screen itself as a one-sheet model: an inputs block of nine inputs (price, units, current rent, market rent, renovation budget, stabilized expenses per unit, loan-to-value, rate, exit cap rate); a five-year annual pro forma showing rent stepping to market, stabilized NOI and cash flow after debt service; a returns panel with going-in cap rate, stabilized yield on cost (stabilized NOI over price plus renovation), levered five-year IRR, equity multiple and average cash-on-cash; and a two-way sensitivity of levered IRR to exit cap rate at plus and minus 25 basis points and market rent at plus and minus 5%. Flag a yield on cost less than 50 basis points above the going-in cap rate, a DSCR below 1.25x, an exit cap rate tighter than the going-in rate, and an assumed renovated rent more than 20% above the best comparable. 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.

Nine inputs, and where each one came from

The screen has nine inputs, and the Assumptions sheet gives a source or a reason beside each one. Four of the nine are analyst assumptions.

Value_Add_MF_Screen_Oakbrook.xlsx
C9fx=C42
BCDE
5SCREEN INPUTS (feed the Model sheet)
6InputValueUnitSource / basis
7Purchase price16,700,000$Latest appraised value of the subject (row 33, MAI appraisal); used as price per Request
8Units157unitsCMBS filing (row 31)
9Current average in-place rent1,331$/unit/moWorked out from the CMBS filing: period revenue / (units x occupancy x months) (row 42)
10Market rent after renovation1,600$/unit/moAnalyst assumption: set at the Zillow ZORI multifamily rent for the metro (row 62), above Apartment List (row 64) and below the HUD 2BR FMR (row 65); renovated 1988 garden units should reach metro average asking rent
11Renovation budget (total)2,355,000$Analyst assumption: about $15,000 per unit x 157 units for interior upgrades (kitchens, baths, flooring, fixtures) plus light exterior work on 1988 garden product
12Stabilized operating expenses per unit7,000$/unit/yrAnalyst assumption: reported Jan-Jun 2026 opex annualizes to $6,673/unit (row 43); about 5% added for property tax reassessment at sale and insurance
13Loan-to-value65.0%%Request
14Interest rate6.90%%10-year Treasury par yield plus spread (rows 57 to 59)
15Exit cap rate6.50%%Analyst assumption: market cap rate for renovated 1980s suburban garden apartments in Richmond; deliberately not the 8.3% going-in cap, which rests on a 2021 appraisal
AssumptionsModelSources
The nine screen inputs from Compound's Assumptions tab, rows 5 to 15, as Compound wrote them. Blue values are typed inputs; black values are formulas that point at the filing rows lower on the sheet.

Read the Source column before the values. Units and the current rent are formulas on figures from the CMBS filing. The price is the filing’s appraised value, used because the request said so, and loan-to-value is marked “Request”. The interest rate is a sourced Treasury yield plus an assumed spread. The other four inputs are labeled “Analyst assumption”, each with its reasoning:

InputValueCompound’s stated basis
Market rent after renovation$1,600 a monthSet at the ZORI multifamily rent for the metro, above Apartment List and below the HUD two-bedroom Fair Market Rent
Renovation budget$2,355,000About $15,000 a unit across 157 units for interiors plus light exterior work
Stabilized expenses$7,000 a unit a yearReported expenses annualize to $6,673 a unit; about 5% added for a tax reassessment at sale and insurance
Exit cap rate6.50%A market rate for renovated 1980s suburban garden apartments in Richmond, set apart from the going-in rate because that rate rests on a 2021 appraisal

Those four are the ones you would overwrite first on your own deal. The Model sheet holds no typed numbers, so changing a blue cell on the Assumptions sheet moves the pro forma, the returns, the flags and the sensitivity grid together.

Below the nine inputs the sheet has a block of conventions that stay fixed from deal to deal: 5% vacancy and credit loss, 2% rent growth, 3% expense growth, 2% selling costs and the pace at which units reach market rent. The 2% rent growth is a long-run rate. The same cell’s note records that Richmond metro rents are up 0.1% year over year on Apartment List’s October 2026 figures, so the first years of the pro forma grow faster than the latest reading.

The subject property: in-place rent from a CMBS filing

A CMBS filing gives revenue, units and occupancy, and the screen turns those into a rent. Oakbrook’s works out to $1,331 a month for each occupied unit, and that figure includes other income.

Value_Add_MF_Screen_Oakbrook.xlsx
C42fx=C39/(C31*C35*C38)
BCD
28SUBJECT PROPERTY (CMBS loan-level filing)
29Property nameOakbrook
30Location (4140 Fairlake Lane, Henrico County, Richmond MSA)Glen Allen, VA 23060
31Units157units
32Year built1988year
33Appraised value (latest reported)16,700,000$
34Appraisal date16-Feb-2021date
35Physical occupancy97.0%%
36Financials period start1-Jan-2026date
37Financials period end30-Jun-2026date
38Months in period6months
39Revenue (period)1,216,322$
40Operating expenses (period)523,824$
41Net operating income (period)692,498$
42Current average in-place rent1,331$/unit/mo
43Annualized operating expenses per unit6,673$/unit/yr
44Annualized net operating income1,384,996$
45Debt service allocated to property (period)191,036$
46DSCR on NOI, as reported3.62xx
AssumptionsModelSources
The subject property block from Compound's Assumptions tab, rows 28 to 46, without the Source column. On the sheet each row cites SEC Form ABS-EE, BANK 2021-BNK33, filed 28-Oct-2026, Exhibit 102.

The filing reports six months of operations, January through June 2026: revenue of $1,216,322, operating expenses of $523,824 and net operating income of $692,498, at 97.0% physical occupancy. Compound divided revenue by units, occupancy and months to get the rent, and annualized the other two lines by doubling the six months, which takes no account of costs that fall unevenly through the year. Expenses come to $6,673 a unit a year and net operating income to $1,384,996.

The rent formula is in the formula bar above. Its Source cell carries a caution that matters for the rest of the screen: the figure “includes other income”. Parking, fees and utility reimbursements are inside the $1,331, so the rent that tenants pay is lower. The request’s selection test needed in-place rent at least 10% below ZORI, and the sheet shows 17.1%.

Compound’s summary adds that among the five metros named in the request, Oakbrook was the only property in the CMBS data that met every test and had a full latest report.

The filing also describes the debt on the property today. Loan 14 is $26.0 million, interest-only at a fixed 3.93%, secured by three properties and maturing on May 1, 2031. The filing allocates $191,036 of debt service to Oakbrook for the six months and reports coverage of 3.62x on net operating income. A buyer of one property would need it released from a three-property loan, which is one of the questions for the seller further down.

Market rent after renovation: ZORI, Apartment List and HUD

The renovated rent is the input that carries the most judgment, so the request asked for three public benchmarks and a named best comparable. The low-end check came back as the highest of the three.

Value_Add_MF_Screen_Oakbrook.xlsx
C67fx=MAX(C62,C64,C65)
BCDE
61MARKET RENT (Richmond, VA MSA)
62Zillow ZORI, multifamily, Sep-20261,605$/moZillow Observed Rent Index, multifamily, smoothed, Richmond VA MSA (CBSA 40060), Sep-2026
63Zillow ZORI, all homes plus multifamily, Sep-2026 (reference)1,706$/moZillow Observed Rent Index, all homes plus multifamily, smoothed, Richmond VA MSA, Sep-2026
64Apartment List median rent, metro, Oct-20261,463$/moApartment List Rent Estimates Summary 2026_10, Richmond, VA metro, all bedroom sizes
65HUD Fair Market Rent, 2BR, FY2027 (low-end check)1,651$/moHUD FMR, Richmond VA HUD Metro FMR Area, which covers ZIP 23060 (Henrico County); FY2027, effective 1-Oct-2026; gross rent incl. utilities
66HUD Fair Market Rent, 1BR, FY2027 (reference)1,517$/moHUD FMR, Richmond VA HUD Metro FMR Area, FY2027
67Best comparable (highest of rows 62, 64, 65)1,651$/moFormula
68In-place rent vs ZORI multifamily(17.1%)%Formula: selection test needs -10% or lower
69Renovated rent vs best comparable(3.1%)%Formula: flag above row 74
AssumptionsModelSources
The market rent block from Compound's Assumptions tab, rows 61 to 69, as Compound wrote it. Negative percentages are in parentheses.

Zillow’s ZORI multifamily series puts the typical asking rent in the Richmond metro at $1,605 for September 2026. Compound used that series for the test and kept the all-homes series, $1,706, on the sheet as a reference. Apartment List’s median for the metro across all bedroom sizes is $1,463 for October 2026. The HUD Fair Market Rent for a two-bedroom unit in fiscal 2027 is $1,651, and the one-bedroom figure is $1,517.

Oakbrook's in-place rent against four Richmond metro benchmarks

Dollars per unit per month. The in-place figure is revenue over occupied units and includes other income

In-place rent, Oakbrook(revenue over occupied units)$1,331Apartment List median rent, Richmond metro$1,463Renovated rent assumed in the screen$1,600Zillow ZORI, multifamily$1,605HUD Fair Market Rent, 2-bedroom$1,651Zillow ZORI, all homes plus multifamily$1,706

Compound's Assumptions tab, rows 10, 42 and 62 to 65: SEC Form ABS-EE for BANK 2021-BNK33; Zillow ZORI, September 2026; Apartment List, October 2026; HUD Fair Market Rents, fiscal 2027.

First, the HUD figure. Compound’s summary says HUD publishes no ZIP-level Small Area Fair Market Rent for 23060, so the check uses the Fair Market Rent for HUD’s Richmond metro area, which covers that ZIP. A Fair Market Rent is a gross rent with utilities included, for a two-bedroom unit. That explains how a figure meant as a floor can sit above an asking-rent index for all apartment sizes. The MAX formula names it the best comparable because the request defined best comparable as the highest of the three.

Second, the assumed rent. At $1,600 the renovated rent is 3.1% below the best comparable, so the fourth flag stays quiet, and it is well above Apartment List’s $1,463. The lift from $1,331 to $1,600 is $269 a month, or 20.2% (our arithmetic). Because the starting figure includes other income and the target is rent alone, the true lift in rent would have to be larger than that for the model’s revenue to hold.

The five-year pro forma: rent stepping to market

The pro forma blends two rents each year, weighted by the share of units already renovated. Net operating income rises from $1.40 million in Year 1 to $1.86 million in Year 5.

Value_Add_MF_Screen_Oakbrook.xlsx
D21fx=D19*(1-D18)+D20*D18
BCDEFGH
16FIVE-YEAR PRO FORMA
17Year 0Year 1Year 2Year 3Year 4Year 5
18Share of units at market rent (%)25%60%90%100%100%
19In-place rent, unrenovated units1,3311,3581,3851,4131,441
20Market rent, renovated units1,6001,6321,6651,6981,732
21Average rent per unit per month1,3981,5221,6371,6981,732
22Gross potential rent2,634,5102,868,0283,083,4833,198,9053,262,884
23Vacancy and credit loss(131,726)(143,401)(154,174)(159,945)(163,144)
24Effective gross income ($)2,502,7852,724,6272,929,3093,038,9603,099,739
25Operating expenses(1,099,000)(1,131,970)(1,165,929)(1,200,907)(1,236,934)
26Net operating income ($)1,403,7851,592,6571,763,3801,838,0531,862,805
27Debt service (interest-only)(748,995)(748,995)(748,995)(748,995)(748,995)
28Cash flow after debt service ($)654,790843,6621,014,3851,089,0581,113,810
29DSCR (x)1.87x2.13x2.35x2.45x2.49x
AssumptionsModelSources
The five-year pro forma from Compound's Model tab, rows 16 to 29, as Compound wrote it. Green values link to the Assumptions sheet. Negative values are in parentheses.

A screen replaces the renovation schedule with one line, the share of units at market rent: 25% in Year 1, 60% in Year 2, 90% in Year 3 and 100% from Year 4. Compound’s note on the Assumptions sheet ties the pace to renovating about 50 units a year as leases turn over.

The average rent in each year is the weighted blend in the formula bar. Both rents grow 2% a year from Year 2. The blend is $1,398 in Year 1 and $1,698 in Year 4, when every unit is at the market figure.

Gross potential rent less 5% for vacancy and credit loss gives effective gross income of $2,502,785 in Year 1. Operating expenses start at $1,099,000, which is $7,000 for each of 157 units, and grow 3% a year. Debt service is $748,995 in every year because the loan is interest-only for the five-year hold.

Net operating income: reported today and five years of the screen

Dollars. The first bar annualizes the six months the filing reports

Reported Jan-Jun 2026, annualized$1,384,996Year 1$1,403,785Year 2$1,592,657Year 3$1,763,380Year 4$1,838,053Year 5$1,862,805

Compound's Assumptions tab, cell C44, and Model tab, row 26.

Year 1 is a useful sanity check. The model’s $1,403,785 is 1.4% above the annualized income the property reports today (our arithmetic). A quarter of the units earning the higher rent is nearly offset by the higher expense assumption and by 5% vacancy against the 97.0% occupancy in the filing. The growth arrives in Years 2 and 3, where the renovations are.

If your plan needs the schedule itself, with units taken offline, a premium per renovated unit and loss-to-lease tracked apart, that is the multifamily value-add pro forma, a monthly model.

Going-in cap rate, yield on cost and the loan

Yield on cost is stabilized net operating income over price plus renovation, and it is the first number a value-add screen should print. Here it is 9.26%, 97 basis points above the going-in cap rate.

The going-in cap rate is annualized reported income over the price: $1,384,996 over $16.7 million, or 8.29%. Stabilized net operating income, in Year 1 dollars with every unit at $1,600, is $1,764,680. Total cost is $19,055,000 once the $2,355,000 renovation is added to the price. The yield on that cost is 9.26%.

The screen's five rates, in percent

The exit cap rate sits below both the going-in cap rate and the rate on the new loan

10-year Treasury, Nov 13, 20265.15Exit cap rate (analyst assumption)6.5New loan rate (Treasury plus spread)6.9Going-in cap rate8.29Stabilized yield on cost9.26

Compound's Assumptions tab, rows 15 and 57 to 59, and Model tab, cells C40 and C43. Treasury: Daily Treasury Par Yield Curve, 10-year, close of November 13, 2026.

The loan is one line. The 10-year Treasury par yield closed at 5.15% on November 13, 2026, and Compound added a spread of 1.75%, labeled as its assumption for a 65% loan-to-value, five-year value-add apartment loan. The all-in rate is 6.90%. At 65% of the price the loan is $10,855,000, and equity is $8,200,000 because the renovation budget is funded with equity at close. That makes the loan 57.0% of total cost (our arithmetic).

At this price the debt helps. The going-in cap rate is 139 basis points above the loan rate (our arithmetic), so each borrowed dollar adds to the cash return from the first year. Coverage is 1.87x in Year 1 and rises to 2.49x by Year 5. The filing shows 3.62x today on the 3.93% loan from 2021.

Levered IRR, equity multiple and average cash-on-cash

The returns panel shows a 24.4% levered IRR, a 2.68x equity multiple and an 11.5% average cash-on-cash return. Most of the cash arrives at the sale.

Value_Add_MF_Screen_Oakbrook.xlsx
C44fx=IRR(C37:H37)
BCDEFGH
31Purchase price(16,700,000)
32Renovation budget(2,355,000)
33Loan proceeds10,855,000
34Exit value (Year 5 NOI / exit cap)28,658,541
35Selling costs(573,171)
36Loan repayment(10,855,000)
37Levered cash flow ($)(8,200,000)654,790843,6621,014,3851,089,05818,344,180
39RETURNS
40Going-in cap rate (annualized reported NOI / price)8.29%
41Stabilized NOI, Year 1 dollars ($)1,764,680
42Total cost: price plus renovation ($)19,055,000
43Stabilized yield on cost (%)9.26%
44Levered 5-year IRR (%)24.4%
45Equity multiple (x)2.68x
46Average cash-on-cash (%)11.5%
47Minimum DSCR (x)1.87x
48Loan amount ($)10,855,000
49Equity invested ($)8,200,000
AssumptionsModelSources
The levered cash flow and returns panel from Compound's Model tab, rows 31 to 49, as Compound wrote them. Negative values are in parentheses.

The equity puts in $8,200,000 at Year 0. It receives between $654,790 and $1,113,810 a year from operations and $18,344,180 in Year 5, when the property is sold. The sale is Year 5 net operating income of $1,862,805 over the 6.50% exit cap rate, which is $28,658,541, less 2% selling costs of $573,171 and repayment of the $10,855,000 loan. The sheet capitalizes the income of Year 5, the year of the sale. A model that prices the sale on the following year’s income would show a higher value at the same cap rate.

We added up where the cash comes from (our arithmetic on rows 28 and 34 to 36). Operations return $4.72 million over five years. The sale returns $17.23 million after costs and the loan, which is 79% of everything the equity gets back. The exit value is 1.72x the purchase price and 1.50x the total cost.

The IRR therefore depends heavily on one cell, the exit cap rate. Net operating income grows 27% from today’s annualized figure to the stabilized figure (our arithmetic), and that growth is the renovation. The rest of the gain in value comes from capitalizing the income at 6.50% after buying it at 8.29%.

Average cash-on-cash is the steadier number. At 11.5% it depends on rents, expenses and the loan rate, and the exit cap rate does not enter it.

The four flags and the IRR sensitivity

The request named four tests, and the screen reports each with its value, its threshold and a status. Three pass, and the exit cap rate test fails by 179 basis points (our arithmetic).

Value_Add_MF_Screen_Oakbrook.xlsx
E55fx=IF(C55<D55,"FLAG","OK")
BCDEF
51FLAGS
52TestValueThresholdStatus
53Yield on cost less going-in cap (min 50 bp)0.97%0.50%OK
54Minimum DSCR (min 1.25x)1.87x1.25xOK
55Exit cap rate vs going-in cap rate (exit not tighter)6.50%8.29%FLAG
56Renovated rent premium to best comparable (max 20%)(3.1%)20.0%OK
57Flags raised1
59SENSITIVITY: LEVERED IRR
60Exit cap rate
61Market rent ($/unit/mo)6.25%6.50%6.75%
62Market rent -5%1,52021.9%20.6%19.3%
63Base market rent1,60025.7%24.4%23.2%
64Market rent +5%1,68029.2%27.9%26.7%
AssumptionsModelSources
The flags panel and the IRR sensitivity from Compound's Model tab, rows 51 to 64, as Compound wrote them. The red outline on the FLAG cell is ours. Each sensitivity cell reads a full cash flow row lower on the sheet.

Each flag is an IF formula on live cells, so it changes when an input does. Yield on cost clears its minimum, coverage of 1.87x clears 1.25x, and the renovated rent is under the best comparable, against a ceiling of 20% above it.

Compound explained the flag in its summary: the going-in cap rate rests on a 2021 appraisal, so much of the IRR comes from the cap rate compressing back to a market level. The filing reports no current value, and this page does not estimate one. The note beside the exit cap rate on the Assumptions sheet says the 6.50% was set as a market rate and deliberately kept apart from the going-in rate.

The sensitivity grid moves the exit cap rate by 25 basis points and the market rent by 5% in each direction, as the request asked.

Levered five-year IRR across the sensitivity grid

Nine cases from the workbook, and one of ours with the exit cap rate set equal to the 8.29% going-in rate

Rent -5%, exit cap 6.25%21.9%Rent -5%, exit cap 6.50%20.6%Rent -5%, exit cap 6.75%19.3%Base rent, exit cap 6.25%25.7%Base rent, exit cap 6.50%24.4%Base rent, exit cap 6.75%23.2%Rent +5%, exit cap 6.25%29.2%Rent +5%, exit cap 6.50%27.9%Rent +5%, exit cap 6.75%26.7%Our arithmetic: base rent,exit cap at the going-in rate16.3%

Compound's Model tab, cells D62 to F64. The last bar is our arithmetic: the workbook's levered cash flows with the Year 5 sale repriced at the going-in cap rate.

The grid runs from 19.3% to 29.2%. Rent matters more than the cap rate inside it: a 5% cut in market rent takes the base case from 24.4% to 20.6%, and 25 basis points on the exit cap rate takes it to 23.2%.

All nine cells sit inside the flagged condition, because 6.75% is still far below 8.29%. To see what the flag is worth, we repriced the sale at the going-in cap rate, keeping every other cell (our arithmetic). The exit value falls to $22.5 million, the equity multiple to 1.94x and the IRR to 16.3%. Coverage and yield on cost are unchanged. About eight points of IRR depend on what the property is worth today, which the filing does not report.

What public data cannot tell you about this deal

Every sourced figure on the screen is a filing, an index or a benchmark rate. The numbers that decide the deal sit with the seller, and Compound’s summary lists what to ask for.

  • The price. The only valuation in the filing is the February 16, 2021 appraisal made when the loan was securitized. A current asking price or appraisal replaces the first input and resets the going-in cap rate. For scale, today’s annualized income at the 6.50% exit cap rate would be about $21.3 million, which is 28% above the appraisal (our arithmetic). That figure illustrates the gap between the two rates and is no estimate of the property’s value.
  • The rent roll. The filing gives total revenue. A current rent roll gives the unit mix, the rent on each unit, the rents on recently leased and renovated units, and other income as its own line. That turns the $1,331 into a rent and shows the true gap to market. A rent roll analysis is the next step once you have it.
  • Comparable rents. ZORI, Apartment List and the HUD figure all describe the whole metro. The seller’s leasing history and nearby renovated properties set the $1,600.
  • Operating expenses. The filing reports one expense total for six months. A trailing-twelve-month statement with real estate taxes, insurance, payroll and utilities broken out tests the $7,000 a unit.
  • The renovation budget. $15,000 a unit is an assumption. The filing records that the property was last renovated in 2004. The capital spending history since then and a property condition report show how much of the budget deferred maintenance would take.
  • The loan release. The property is one of three behind a single loan. Compound’s summary notes that the loan is locked out until January 31, 2031, so a buyer needs the release price and terms for taking one property out.
  • The new loan. The 1.75% spread is an assumption. A lender’s quote sets the rate, the proceeds, any amortization and the reserves.

Closing costs, loan fees and replacement reserves enter with the full model.

Our view: worth a full underwriting, at a real price

We would move this deal from the screen to a full underwriting and would not quote the 24.4% to anyone. The results that do not depend on the sale are a 9.26% yield on cost and 1.87x coverage at a 6.90% loan, and both are still measured on a price from February 2021.

The case for the deal is in the cells that do not depend on the sale. Income today covers new debt at today’s rates with room. The renovation adds 97 basis points of yield. Two figures do not depend on the price either: in-place revenue per unit is 17.1% below the metro’s multifamily asking rent, and net operating income grows 27% from today’s annualized figure to the stabilized one (our arithmetic).

The case against is that the cap rate, the yield on cost and the coverage on a 65% loan are all measured on a price from February 2021. If the seller’s price is closer to what today’s income is worth at a market cap rate, the going-in cap rate falls toward the exit rate, the yield-on-cost spread narrows, and leverage that helps at 8.29% may stop helping. The flag pointed at the input that makes the screen look better than the deal may be.

A screen like this tells you which two or three numbers to ask for. To compare a few dozen deals on shared assumptions, see real estate deal pipeline screening. For the full acquisition model with a debt schedule and scenarios, see the real estate pro forma.

Value-add multifamily screen (Excel)Compound’s workbook from this run: an Assumptions sheet with a source or reason beside every input, the one-sheet Model with nine inputs, a five-year pro forma, the returns panel, four flags and the IRR sensitivity, and a Sources sheet.Download · Free

FAQ

What is yield on cost in a value-add multifamily deal?

Yield on cost is stabilized net operating income divided by the purchase price plus the renovation budget. It measures what the finished business plan earns on every dollar spent. In this screen it is $1,764,680 over $19,055,000, or 9.26%, against an 8.29% going-in cap rate.

How much should yield on cost exceed the going-in cap rate?

The spread has to pay for the renovation risk, the downtime and the capital. This screen flags any deal where the spread is under 50 basis points, a threshold set in the request and held in a cell you can change. Comparing yield on cost with the cap rate at which renovated properties sell shows the value the renovation creates.

Why flag an exit cap rate below the going-in cap rate?

A lower exit cap rate means the model sells each dollar of income for more than it paid. That can be justified when the property is repositioned or the purchase is below market, but it adds return that does not come from operations. Here the exit rate is 6.50% and the going-in rate is 8.29%. Repricing the sale at the going-in rate takes the IRR from 24.4% to 16.3% (our arithmetic).

Can you work out in-place rent from a CMBS filing?

Approximately. The loan-level filing reports revenue, units and occupancy for a period, and revenue divided by occupied units and months gives revenue per unit per month. That figure includes other income such as parking and fees, so it overstates rent. The workbook says so beside the formula, and a rent roll from the seller replaces it.

How is a value-add screen different from a value-add pro forma?

A screen fits on one sheet, uses annual periods and takes the renovation as one budget and a share of units at market rent each year. A pro forma schedules units by month, tracks downtime and loss-to-lease, and models the loan in detail. The screen decides which deals get the pro forma.

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