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.
“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.”
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.
| B | C | D | E | |
|---|---|---|---|---|
| 5 | SCREEN INPUTS (feed the Model sheet) | |||
| 6 | Input | Value | Unit | Source / basis |
| 7 | Purchase price | 16,700,000 | $ | Latest appraised value of the subject (row 33, MAI appraisal); used as price per Request |
| 8 | Units | 157 | units | CMBS filing (row 31) |
| 9 | Current average in-place rent | 1,331 | $/unit/mo | Worked out from the CMBS filing: period revenue / (units x occupancy x months) (row 42) |
| 10 | Market rent after renovation | 1,600 | $/unit/mo | Analyst 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 |
| 11 | Renovation 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 |
| 12 | Stabilized operating expenses per unit | 7,000 | $/unit/yr | Analyst assumption: reported Jan-Jun 2026 opex annualizes to $6,673/unit (row 43); about 5% added for property tax reassessment at sale and insurance |
| 13 | Loan-to-value | 65.0% | % | Request |
| 14 | Interest rate | 6.90% | % | 10-year Treasury par yield plus spread (rows 57 to 59) |
| 15 | Exit cap rate | 6.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 |
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:
| Input | Value | Compound’s stated basis |
|---|---|---|
| Market rent after renovation | $1,600 a month | Set at the ZORI multifamily rent for the metro, above Apartment List and below the HUD two-bedroom Fair Market Rent |
| Renovation budget | $2,355,000 | About $15,000 a unit across 157 units for interiors plus light exterior work |
| Stabilized expenses | $7,000 a unit a year | Reported expenses annualize to $6,673 a unit; about 5% added for a tax reassessment at sale and insurance |
| Exit cap rate | 6.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.
| B | C | D | |
|---|---|---|---|
| 28 | SUBJECT PROPERTY (CMBS loan-level filing) | ||
| 29 | Property name | Oakbrook | |
| 30 | Location (4140 Fairlake Lane, Henrico County, Richmond MSA) | Glen Allen, VA 23060 | |
| 31 | Units | 157 | units |
| 32 | Year built | 1988 | year |
| 33 | Appraised value (latest reported) | 16,700,000 | $ |
| 34 | Appraisal date | 16-Feb-2021 | date |
| 35 | Physical occupancy | 97.0% | % |
| 36 | Financials period start | 1-Jan-2026 | date |
| 37 | Financials period end | 30-Jun-2026 | date |
| 38 | Months in period | 6 | months |
| 39 | Revenue (period) | 1,216,322 | $ |
| 40 | Operating expenses (period) | 523,824 | $ |
| 41 | Net operating income (period) | 692,498 | $ |
| 42 | Current average in-place rent | 1,331 | $/unit/mo |
| 43 | Annualized operating expenses per unit | 6,673 | $/unit/yr |
| 44 | Annualized net operating income | 1,384,996 | $ |
| 45 | Debt service allocated to property (period) | 191,036 | $ |
| 46 | DSCR on NOI, as reported | 3.62x | x |
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.
| B | C | D | E | |
|---|---|---|---|---|
| 61 | MARKET RENT (Richmond, VA MSA) | |||
| 62 | Zillow ZORI, multifamily, Sep-2026 | 1,605 | $/mo | Zillow Observed Rent Index, multifamily, smoothed, Richmond VA MSA (CBSA 40060), Sep-2026 |
| 63 | Zillow ZORI, all homes plus multifamily, Sep-2026 (reference) | 1,706 | $/mo | Zillow Observed Rent Index, all homes plus multifamily, smoothed, Richmond VA MSA, Sep-2026 |
| 64 | Apartment List median rent, metro, Oct-2026 | 1,463 | $/mo | Apartment List Rent Estimates Summary 2026_10, Richmond, VA metro, all bedroom sizes |
| 65 | HUD Fair Market Rent, 2BR, FY2027 (low-end check) | 1,651 | $/mo | HUD FMR, Richmond VA HUD Metro FMR Area, which covers ZIP 23060 (Henrico County); FY2027, effective 1-Oct-2026; gross rent incl. utilities |
| 66 | HUD Fair Market Rent, 1BR, FY2027 (reference) | 1,517 | $/mo | HUD FMR, Richmond VA HUD Metro FMR Area, FY2027 |
| 67 | Best comparable (highest of rows 62, 64, 65) | 1,651 | $/mo | Formula |
| 68 | In-place rent vs ZORI multifamily | (17.1%) | % | Formula: selection test needs -10% or lower |
| 69 | Renovated rent vs best comparable | (3.1%) | % | Formula: flag above row 74 |
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
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.
| B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|
| 16 | FIVE-YEAR PRO FORMA | ||||||
| 17 | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| 18 | Share of units at market rent (%) | 25% | 60% | 90% | 100% | 100% | |
| 19 | In-place rent, unrenovated units | 1,331 | 1,358 | 1,385 | 1,413 | 1,441 | |
| 20 | Market rent, renovated units | 1,600 | 1,632 | 1,665 | 1,698 | 1,732 | |
| 21 | Average rent per unit per month | 1,398 | 1,522 | 1,637 | 1,698 | 1,732 | |
| 22 | Gross potential rent | 2,634,510 | 2,868,028 | 3,083,483 | 3,198,905 | 3,262,884 | |
| 23 | Vacancy and credit loss | (131,726) | (143,401) | (154,174) | (159,945) | (163,144) | |
| 24 | Effective gross income ($) | 2,502,785 | 2,724,627 | 2,929,309 | 3,038,960 | 3,099,739 | |
| 25 | Operating expenses | (1,099,000) | (1,131,970) | (1,165,929) | (1,200,907) | (1,236,934) | |
| 26 | Net operating income ($) | 1,403,785 | 1,592,657 | 1,763,380 | 1,838,053 | 1,862,805 | |
| 27 | Debt service (interest-only) | (748,995) | (748,995) | (748,995) | (748,995) | (748,995) | |
| 28 | Cash flow after debt service ($) | 654,790 | 843,662 | 1,014,385 | 1,089,058 | 1,113,810 | |
| 29 | DSCR (x) | 1.87x | 2.13x | 2.35x | 2.45x | 2.49x |
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
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
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.
| B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|
| 31 | Purchase price | (16,700,000) | |||||
| 32 | Renovation budget | (2,355,000) | |||||
| 33 | Loan proceeds | 10,855,000 | |||||
| 34 | Exit value (Year 5 NOI / exit cap) | 28,658,541 | |||||
| 35 | Selling costs | (573,171) | |||||
| 36 | Loan repayment | (10,855,000) | |||||
| 37 | Levered cash flow ($) | (8,200,000) | 654,790 | 843,662 | 1,014,385 | 1,089,058 | 18,344,180 |
| 39 | RETURNS | ||||||
| 40 | Going-in cap rate (annualized reported NOI / price) | 8.29% | |||||
| 41 | Stabilized NOI, Year 1 dollars ($) | 1,764,680 | |||||
| 42 | Total cost: price plus renovation ($) | 19,055,000 | |||||
| 43 | Stabilized yield on cost (%) | 9.26% | |||||
| 44 | Levered 5-year IRR (%) | 24.4% | |||||
| 45 | Equity multiple (x) | 2.68x | |||||
| 46 | Average cash-on-cash (%) | 11.5% | |||||
| 47 | Minimum DSCR (x) | 1.87x | |||||
| 48 | Loan amount ($) | 10,855,000 | |||||
| 49 | Equity invested ($) | 8,200,000 |
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).
| B | C | D | E | F | |
|---|---|---|---|---|---|
| 51 | FLAGS | ||||
| 52 | Test | Value | Threshold | Status | |
| 53 | Yield on cost less going-in cap (min 50 bp) | 0.97% | 0.50% | OK | |
| 54 | Minimum DSCR (min 1.25x) | 1.87x | 1.25x | OK | |
| 55 | Exit cap rate vs going-in cap rate (exit not tighter) | 6.50% | 8.29% | FLAG | |
| 56 | Renovated rent premium to best comparable (max 20%) | (3.1%) | 20.0% | OK | |
| 57 | Flags raised | 1 | |||
| 59 | SENSITIVITY: LEVERED IRR | ||||
| 60 | Exit cap rate | ||||
| 61 | Market rent ($/unit/mo) | 6.25% | 6.50% | 6.75% | |
| 62 | Market rent -5% | 1,520 | 21.9% | 20.6% | 19.3% |
| 63 | Base market rent | 1,600 | 25.7% | 24.4% | 23.2% |
| 64 | Market rent +5% | 1,680 | 29.2% | 27.9% | 26.7% |
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
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 · FreeFAQ
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.





