Janos S.

Real Estate Financial Modeling | Waterfalls & Model Review | Claude AI

Hello there! I build and underwrite real estate financial models for commercial development and acquisition projects, including lender underwriting, private equity raises, capital stack structuring, senior debt sizing, and equity waterfall structuring. From emerging sponsors to institutional investors, I design clean, bank-ready Excel models that support capital raises and credit committee approval. I’ve supported transactions totaling $470M+ across USA, Portugal, Germany in development, acquisition and structured finance deals. I also run deal screening and reporting pipelines with Claude AI on live mandates. 1. The problem I solve: Sponsors come to me when the capital structure is more complex than their template can handle, or when a lender or LP has questioned the numbers. You focus on closing the deal. I make sure the model is not what holds it up. 2. Services I offer: ◾ Development and acquisition underwriting for multifamily, mixed-use, and student housing ◾ GP/LP waterfalls with IRR hurdles, catch-up provisions, and promote calculations ◾ Capital stack modeling across senior debt, mezzanine, and preferred equity layers ◾ Forward funding and milestone payment structures ◾ Model audits and restructuring to fix errors and improve usability ◾ Single-family residential build-to-sell, deal-level models and fund-level roll-ups with capital recycling ◾ LIHTC modeling, credit pricing, and investor exits ◾ Lender covenant testing with DSCR, debt yield, and LTV sensitivity analysis ◾ Development pro formas with construction draws, lease-up assumptions, and stabilization timing ◾ Downside stress testing and scenario modeling for equity and debt stakeholders 3. My background: ▪ Experience at financial services and consultancy firms including Deloitte, Mazars, BDO, and OTP Bank ▪ Project Finance, Corporate Finance, and Audit foundation ▪ Models built for Investment Committee and Risk Committee review Areas of expertise include: ▸ Multifamily and commercial real estate underwriting ▸ GP/LP waterfall structuring ▸ Capital stack structuring ▸ Debt sizing (DSCR, LTC, LTV) ▸ Forward funding structures ▸ Development pro forma modeling ▸ Sensitivity and downside scenario analysis ⚡ AI DEAL SCREENING & REPORTING I use Claude on live mandates, not as a demo. Screening: on a distressed multifamily pipeline I scored 1,962 NYC buildings down to a 66-property priority tier. Layered composite scoring, one tab per raw data layer, refreshed by swapping the layer rather than rebuilding the model. Every dataset ID verified against the live API before shipping, which caught two widely cited sources that were either frozen or did not exist. Reporting: QuickBooks-integrated reporting and financial statement rebuilds where every figure carries a source flag back to the ledger, the bank statement or the feed it came from. That is what makes the number auditable rather than plausible. Feel free to message me if you'd like to review or discuss a deal in your pipeline. I will tell you what I would look at first and whether the work is worth doing.