Tamer Y.

Real Estate Financial Modeling | DCF, Waterfall & Pro Forma Expert

Top-Rated Plus CRE financial modeling specialist. I build institutional-grade Excel models — DCF valuations, equity waterfalls, acquisition underwriting, and development pro formas — for hotel, multifamily, and student housing investors. I build models for real estate private equity firms, value-add multifamily developers, and student housing investors. Projects include ultra-luxury hotel acquisitions across Southern Europe for a London-based private equity firm, multifamily value-add repositioning analysis, and student housing portfolio underwriting across the US. I work as an extension of my clients' deal teams, not as a one-off freelancer. Asset classes I model: • Multifamily • Hotels & Hospitality • Student Housing • Mixed Use • Office • Industrial • Retail • Single-Family • Land Development Core deliverables: • DCF and IRR valuations • LP/GP equity waterfall structures — promote, catch-up, clawback, preferred returns • Debt sculpting based on DSCR, LTV, LTC constraints • Acquisition underwriting and hold/sell analysis • Ground-up development pro formas with construction draw schedules • Joint venture waterfall modeling with multiple capital tiers • Sensitivity and scenario analysis — two-variable data tables, Monte Carlo where needed • Rent roll analysis, forecasting, and market rent benchmarking • Financial projections — P&L, balance sheet, cash flow • Investor-ready offering memorandum financials and investment summaries • VBA macro-enabled dynamic models with automated reporting Every model I deliver is error-proofed, clearly documented, and built so your team can update assumptions and run scenarios independently — not a black box that only I can operate. Let's discuss your project on a Zoom call.