Skip to the valuation

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.

A1
600 SF
Units
81
In-place rent
$770
Target (as-is)
$770
$1.28/SF
Monthly gap to target, per unit
At target
A2
700 SF
Units
52
In-place rent
$837
Target (as-is)
$837
$1.20/SF
Monthly gap to target, per unit
At target
A3
750 SF
Units
95
In-place rent
$902
Target (as-is)
$913
$1.22/SF
Monthly gap to target, per unit
+$10.95+1.21%
A4TH
523 SF
Units
20
In-place rent
$776
Target (as-is)
$776
$1.48/SF
Monthly gap to target, per unit
At target
A5TH
780 SF
Units
12
In-place rent
$1,001
Target (as-is)
$1,001
$1.28/SF
Monthly gap to target, per unit
At target
B1
900 SF
Units
48
In-place rent
$1,127
Target (as-is)
$1,127
$1.25/SF
Monthly gap to target, per unit
At target
B2TH
854 SF
Units
24
In-place rent
$1,117
Target (as-is)
$1,117
$1.31/SF
Monthly gap to target, per unit
At target
B3TH
956 SF
Units
20
In-place rent
$1,231
Target (as-is)
$1,231
$1.29/SF
Monthly gap to target, per unit
At target
B4
1,000 SF
Units
48
In-place rent
$1,193
Target (as-is)
$1,193
$1.19/SF
Monthly gap to target, per unit
At target
Total400$955 avg$12,485 a year

The market benchmark is $770 to $1,240, depending on the plan.

Rental comparables — 10 selected

Comparables used to set market rent

Comp 1
Comp 1 · 376 units · Used in valuation
Avg size
634 SF
Observed rent
$764
Rent / SF
$1.21
Comp 1
Comp 1 · 376 units · Used in valuation
Avg size
819 SF
Observed rent
$1,068
Rent / SF
$1.30
Comp 1
Comp 1 · 376 units · Used in valuation
Avg size
1,018 SF
Observed rent
$1,168
Rent / SF
$1.15
Comp 2
Comp 2 · 384 units · Used in valuation
Avg size
643 SF
Observed rent
$827
Rent / SF
$1.29
Comp 2
Comp 2 · 384 units · Market context · not used in rent conclusion
Avg size
943 SF
Observed rent
$929
Rent / SF
$0.99
Comp 3
Comp 3 · 426 units · Used in valuation
Avg size
622 SF
Observed rent
$716
Rent / SF
$1.15
Comp 3
Comp 3 · 426 units · Used in valuation
Avg size
982 SF
Observed rent
$959
Rent / SF
$0.98
Comp 4
Comp 4 · 300 units · Used in valuation
Avg size
595 SF
Observed rent
$778
Rent / SF
$1.31
Comp 4
Comp 4 · 300 units · Used in valuation
Avg size
761 SF
Observed rent
$1,101
Rent / SF
$1.45
Comp 5
Comp 5 · 360 units · Market context · not used in rent conclusion
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.

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

  1. Property Tax$659,119
  2. Payroll & Benefits$431,473
  3. Property Insurance$344,793
  4. Utilities$297,626
  5. Management Fee$136,659
  6. Contract Services$127,759
  7. General & Administrative$57,769
  8. Repairs & Maintenance$38,225
  9. Professional Fees$37,022
  10. Turnover / Make Ready$36,161
  11. Advertising & Marketing$31,478
  12. Other Operating Expenses$86
Total operating expenses$2,198,169

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

  1. 6.50% cap$35,980,000
  2. 6.25% capmidpoint$37,420,000
  3. 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.

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%

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

  1. Larceny1.55×
  2. Tornado1.40×
  3. Motor Vehicle Theft1.39×
  4. Burglary1.29×
  5. Murder1.28×
  6. Crime1.18×
  7. Hail0.95×
  8. Particulate Matter0.93×
  9. Air Pollution0.82×
  10. Ozone0.81×
  11. Hurricane0.66×
  12. Earthquake0.27×
  13. Wind0.24×