All modules

Cash-in or cash-out refinance

Replacing the old loan with a new loan.

A new loan pays off the old one. If the new loan is bigger, the extra goes back to the investors. If it is smaller, the investors put in the difference. Drag the loan and the valuation, and watch the middle bars.

Investors' return on the $7.0M they put in
Realized MOIC0.56x0.21x+0.35x
Unrealized MOIC1.57x1.91x−0.34x
Total MOIC2.13x
Cash in hand versus still in the building
Today
2.13x
After
2.13x
Realized: cash in handUnrealized: still in the building, cash only when it sells
Investors' return on the $7.0M they put in
Realized MOIC0.56x0.21x+0.35x
Unrealized MOIC1.57x1.91x−0.34x
Total MOIC2.13x
  • Value$26.0M
  • Equity$13.4M
  • Old loan balance$12.6M
Where it comes from
  • New loan$15.0M
Where it goes
  • Sent to the investors$2.4M
  • Pays off the old loan$12.6M
  • Value$26.0M
  • Equity$11.0M
  • New loan balance$15.0M

Swipe sideways to see all three bars.

$26.0M+$6.0M since the $20.0M purchase
$10.0M$36.0M
$15.0M+$2.4M against the $12.6M old balance
$8.0M$26.0M: the building's whole value
What just happened

The investors get $2.4M back at closing. They have now realized 0.56x of their money and still have 1.57x in the building: 2.13x in all, the same as before. The refi moved money out of the building and into their pockets without creating any, and the loan is bigger than before.

Relevant formulas
Equity today value minus the old loan$26.0M − $12.6M = $13.4M
Cash to the investors new loan minus the old loan$15.0M − $12.6M = $2.4M
Equity after value minus the new loan$26.0M − $15.0M = $11.0M
Realized MOIC cash already distributed plus the cash out, divided by what the investors put in($1.5M + $2.4M) ÷ $7.0M = 0.56x
Unrealized MOIC equity after, divided by what the investors put in$11.0M ÷ $7.0M = 1.57x
Total MOIC realized plus unrealized0.56x + 1.57x = 2.13x
Ask AI about this module

Answers come from Claude and can be wrong. The formula card is the source of truth.

Tell Keaton what was confusing or broken