Deal Journey — Sample Multifamily Deal
The Answer
Loading the 3D view…
Sample Multifamily Deal
400 units · 306,886 SF · Year built 1981 · multifamily · Not graded
Illustrative locations
Cactus valuation
$35,980,000 – $38,980,000
Midpoint $37,420,000 · 6.25% going-in cap rate
Critical assumptions
Chosen for what each one moves the value and any changes you made.
- Current Market Cap RateAt 6.50%, value moves $1,440,000; levered IRR moves 183 bpsLimited evidence6.25%Low confidence; material valuation or return sensitivity
- Property Tax GrowthAt 3.5%, value is unchanged; levered IRR moves 38 bps3%Low confidence; model sensitivity tested
- Annual Rent GrowthAt 3.5%, value is unchanged; levered IRR moves 157 bpsLimited evidence3%Low confidence; material valuation or return sensitivity
- ConcessionsAt 1.7%, value moves $360,000; levered IRR moves 1 bpsLimited evidence1.2%Low confidence; material valuation or return sensitivity
- Other Income GrowthAt 3%, value is unchanged; levered IRR moves 23 bps2.5%Low confidence; model sensitivity tested
- Tax Assessment RatioAt 99.5%, value and levered IRR are unchanged100%Low confidence; model sensitivity tested
- Property Tax RateAt 2.5%, value and levered IRR are unchanged2%Low confidence; model sensitivity tested
The deal in brief
One finding per chapter. Select a line to read the chapter.
Chapter 1 · Where does the income come from?
The Income Story
$12,485 a year
: 1 of 9 plans rent below target, and the valuation closes the gap over 24 months.
A3 has the widest gap to target, at $10.95 a month
Each plan's gap to target rent, per unit per month. Together the plans add $12,485 a year.
In-place rent is what tenants pay now. Target (as-is) is the achievable rent this valuation uses.
- Units
- 81
- In-place rent
- $770
- Target (as-is)
- $770$1.28/SF
- Monthly gap to target, per unit
- At target
- Units
- 52
- In-place rent
- $837
- Target (as-is)
- $837$1.20/SF
- Monthly gap to target, per unit
- At target
- Units
- 95
- In-place rent
- $902
- Target (as-is)
- $913$1.22/SF
- Monthly gap to target, per unit
- +$10.95+1.21%
- Units
- 20
- In-place rent
- $776
- Target (as-is)
- $776$1.48/SF
- Monthly gap to target, per unit
- At target
- Units
- 12
- In-place rent
- $1,001
- Target (as-is)
- $1,001$1.28/SF
- Monthly gap to target, per unit
- At target
- Units
- 48
- In-place rent
- $1,127
- Target (as-is)
- $1,127$1.25/SF
- Monthly gap to target, per unit
- At target
- Units
- 24
- In-place rent
- $1,117
- Target (as-is)
- $1,117$1.31/SF
- Monthly gap to target, per unit
- At target
- Units
- 20
- In-place rent
- $1,231
- Target (as-is)
- $1,231$1.29/SF
- Monthly gap to target, per unit
- At target
- Units
- 48
- In-place rent
- $1,193
- Target (as-is)
- $1,193$1.19/SF
- Monthly gap to target, per unit
- At target
The market benchmark is $770 to $1,240, depending on the plan.
Rental comparables — 10 selected
Comparables used to set market rent
- Avg size
- 634 SF
- Observed rent
- $764
- Rent / SF
- $1.21
- Avg size
- 819 SF
- Observed rent
- $1,068
- Rent / SF
- $1.30
- Avg size
- 1,018 SF
- Observed rent
- $1,168
- Rent / SF
- $1.15
- Avg size
- 643 SF
- Observed rent
- $827
- Rent / SF
- $1.29
- Avg size
- 943 SF
- Observed rent
- $929
- Rent / SF
- $0.99
- Avg size
- 622 SF
- Observed rent
- $716
- Rent / SF
- $1.15
- Avg size
- 982 SF
- Observed rent
- $959
- Rent / SF
- $0.98
- Avg size
- 595 SF
- Observed rent
- $778
- Rent / SF
- $1.31
- Avg size
- 761 SF
- Observed rent
- $1,101
- Rent / SF
- $1.45
- Avg size
- 1,046 SF
- Observed rent
- $1,175
- Rent / SF
- $1.12
Chapter 2 · What reduces that income?
Revenue Reality
$4,606,981
in Year 1. The property is 88.5% occupied today; the valuation assumes 92% once stabilized.
Vacancy takes the most rent, $408,887; other income adds back $576,848
Year 1, from the rent the property could bill to the income it collects.
- Gross potential rent$4,585,764
- Renovation downtime$0
- Vacancy−$408,887
- Bad debt−$91,715
- Concessions−$55,029
- Net rental income$4,030,133
- Other income$576,848
- Dated income changes$0
- Effective gross income$4,606,981
Valuations are rounded to the nearest $10,000, value per unit to $100, and value per SF to $1. Other amounts are rounded to whole dollars. Displayed rows may differ from totals because of rounding; totals use the unrounded model values.
Income statement
Cactus kept all 12 T-12 income lines as reported.
- T-12
- $4,714,715
- T-12
- $271,597
- T-12
- $121,256
- T-12
- $114,116
- T-12
- −$148,082
- T-12
- −$387,658
Valuations are rounded to the nearest $10,000, value per unit to $100, and value per SF to $1. Other amounts are rounded to whole dollars. Displayed rows may differ from totals because of rounding; totals use the unrounded model values.
Chapter 3 · What does it cost to operate?
The Cost Story
$2,410,534
. Cactus kept all 12 T-12 expense lines as reported.
Property Tax is the largest cost at $659,119, then payroll & benefits at $431,473
T-12 operating expenses, Jun 1, 2024 – May 31, 2025
- Property Tax$659,119
- Payroll & Benefits$431,473
- Property Insurance$344,793
- Utilities$297,626
- Management Fee$136,659
- Contract Services$127,759
- General & Administrative$57,769
- Repairs & Maintenance$38,225
- Professional Fees$37,022
- Turnover / Make Ready$36,161
- Advertising & Marketing$31,478
- Other Operating Expenses$86
Valuations are rounded to the nearest $10,000, value per unit to $100, and value per SF to $1. Other amounts are rounded to whole dollars. Displayed rows may differ from totals because of rounding; totals use the unrounded model values.
Operating expenses
Cactus kept all 12 T-12 expense lines as reported.
- Reported
- $659,119
- Normalized
- $659,119
- Reported
- $431,473
- Normalized
- $431,473
- Reported
- $344,793
- Normalized
- $344,793
- Reported
- $297,626
- Normalized
- $297,626
- Reported
- $136,659
- Normalized
- $136,659
- Reported
- $127,759
- Normalized
- $127,759
Valuations are rounded to the nearest $10,000, value per unit to $100, and value per SF to $1. Other amounts are rounded to whole dollars. Displayed rows may differ from totals because of rounding; totals use the unrounded model values.
- T-12 NOI as reported
- $2,410,534
- Income adjustments
- $0
- Expense adjustments
- $0
- Normalized T-12 NOI
- $2,410,534
- Rounding
- Valuations are rounded to the nearest $10,000, value per unit to $100, and value per SF to $1. Other amounts are rounded to whole dollars. Displayed rows may differ from totals because of rounding; totals use the unrounded model values.
Chapter 4 · Why does Cactus believe this valuation?
Why This Value
$2,338,524 ÷ 6.25% ≈ $37,420,000
divided by the . That is $93,500 per unit and $122 per square foot.
At a 6.50% cap, the value is $35,980,000
Cap-rate sensitivity at the rates shown, on the same $2,338,524 valuation NOI
- 6.50% cap$35,980,000
- 6.25% capmidpoint$37,420,000
- 6.00% cap$38,980,000
Sale comparable evidence was not available for this property, so the value rests on the NOI and cap rate above.
From normalized T-12 NOI to valuation NOI
Valuation basis: Year 1 Underwritten
- Normalized T-12 NOI
- $2,410,534
- Valuation changes
- −$72,011
- Valuation NOI
- $2,338,524
What moved it: the normalized T-12 against Year 1, the year the valuation capitalizes.
- Normalized T-12
- $4,608,704
- Year 1
- $4,606,981
- Normalized T-12
- $2,198,169
- Year 1
- $2,268,457
Value story
Sample Multifamily Deal is valued on its current rent-roll income and trailing operating costs. The cap rate is provisional because no local cap-rate or sale evidence was available.
Chapter 5 · What does a buyer earn at this price?
The Buyer's Math
7.57%
at the valuation midpoint over the 84-month hold, with a 1.58× equity multiple.
The buyer's deal at the modeled price
Saved price and returns from the current analysis.
Modeled purchase price
$37,416,383
Valuation midpoint
$37,420,000
The price matches the valuation
Capital stack
- Loan
- $24,320,649
- Buyer's cash at close
- $13,713,104
Gross exit value $41,140,000 at a 6.75% exit cap
Return profile
Returns at $37,416,383
Levered IRR
7.57%
Equity multiple
1.58×
Minimum DSCR
1.19×
Debt yield
9.62%
Financing
Acquisition debt and minimum hold-period coverage
- Loan amount
- $24,320,649
- Initial equity
- $13,713,104
- Minimum DSCR
- 1.19×
- Debt yield
- 9.62%
Exit
Hold and sale outputs from the current model
- Exit NOI implied
- $2,777,119
- ÷ Exit cap
- 6.75%
- = Gross exit value
- $41,140,000
- − Selling costs
- −$617,137
- = Net sale proceeds before debt payoff
- $40,525,360
- Hold period
- 84 mo
- Levered profit
- $7,980,332
Levered cash flow runs from $604,176 in Year 1 to $692,817 in Year 7, with a low of $416,254 in Year 3
Levered cash flow to the buyer, by year of the hold
Some source fields were unavailable.
- Effective gross income
- $4,606,981
- NOI
- $2,338,524
- Renovation CapEx
- $0
- Debt service
- $1,634,348
- Levered cash flow
- $604,176
- Effective gross income
- $4,697,073
- NOI
- $2,361,992
- Renovation CapEx
- $0
- Debt service
- $1,634,348
- Levered cash flow
- $624,644
- Effective gross income
- $4,813,864
- NOI
- $2,409,447
- Renovation CapEx
- $0
- Debt service
- $1,887,103
- Levered cash flow
- $416,254
- Effective gross income
- $4,955,304
- NOI
- $2,478,843
- Renovation CapEx
- $0
- Debt service
- $1,887,103
- Levered cash flow
- $482,467
- Effective gross income
- $5,100,914
- NOI
- $2,550,249
- Renovation CapEx
- $0
- Debt service
- $1,887,103
- Levered cash flow
- $550,595
- Effective gross income
- $5,250,815
- NOI
- $2,623,723
- Renovation CapEx
- $0
- Debt service
- $1,887,103
- Levered cash flow
- $620,693
- Effective gross income
- $5,405,135
- NOI
- $2,699,326
- Renovation CapEx
- $0
- Debt service
- $1,887,103
- Levered cash flow
- $692,817
Year 8 to Year 10 come after the 84-month hold and are shown for reference only.
Chapter 6 · What could affect this deal?
Risk & Market Watch
6 of 13
area indexes run above the national average around the property. They describe the area, not this parcel, and do not change the valuation.
Larceny is highest at 1.55×; wind is lowest at 0.24×
Area index for the subject area, as a multiple of the national average
- Larceny1.55×
- Tornado1.40×
- Motor Vehicle Theft1.39×
- Burglary1.29×
- Murder1.28×
- Crime1.18×
- Hail0.95×
- Particulate Matter0.93×
- Air Pollution0.82×
- Ozone0.81×
- Hurricane0.66×
- Earthquake0.27×
- Wind0.24×
Market developments · 18
About this data
- Parcel records
- Available
- Community indexes
- Available
- Market web evidence
- Available
- Forward climate risk
- Unavailable
community data source does not disclose a field-level measurement vintage in this response.
Climate values are historical normals, not forward-looking property climate-loss estimates.
Community V4 did not return aggregate school count or rating fields; no separate school endpoint was called.
Some web claims or details could not be verified; retained findings include their limitations.
Some findings rely on search excerpts because full articles were not retrieved.
Some collected sources were outside this review's research budget.
Some property web details remain unverified, including dates where not disclosed.
Location indexes are area context, not property-loss predictions.
Market Watch never changes the underwriting automatically.