video1.0<iframe src="https://www.loom.com/embed/88aef18dbf424600902961e318246cec" frameborder="0" width="1920" height="1440" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>14401920Loomhttps://www.loom.com14401920https://cdn.loom.com/sessions/thumbnails/88aef18dbf424600902961e318246cec-5886e7b5cb853064.gif158.549This Loom demonstrates a fast way to model a real estate equity waterfall without Excel. Ka-Sing Ng, an active CPA with Big 4 experience, shows a 28-unit, $3.6 million multifamily deal held for 5 years at purchase price with 65% loan-to-cost, 6.62% interest rate, and standard LP-GP splits of 30% LP cost and 5% GP cost. It uses NOI of about $219,000 and a 6.25% exit cap rate to produce an LP IRR of 10.67%, and includes a draggable timeline, cash and NOI flow tracking, and a Sankey diagram summarizing sale proceeds by priority. It also shows total lifecycle NOI received.