{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/88aef18dbf424600902961e318246cec\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/88aef18dbf424600902961e318246cec-5886e7b5cb853064.gif","duration":158.549,"title":"Commercial Real Estate Underwriting Tool in Two Minutes","description":"This 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."}