Enhance your underwriting and deal analysis processes with these meticulously crafted real estate waterfall models. Whether you're analyzing a fresh construction project or an acquisition, robust financial planning is pivotal from inception. In this regard, access to swift and precise tools becomes indispensable - and that's precisely what these spreadsheets offer.
Every facet of your deal is thoughtfully considered within these models. I provide integrated input assumptions and schedules for aspects such as rent rolls, acquisition/financing, equity requirements, operations, growth and stabilization, and exit/terminal value. Output summaries display key metrics including internal rate of return (IRR), equity multiples, and discounted cash flow (DCF) analysis, covering the entire deal as well as limited and general partnerships (LP/GP) views. Elevate your real estate financial analysis with these comprehensive and user-friendly tools.
- General Real Estate Model - Self-storage, apartment buildings, multi-family, and more.
- Rental Property Scaling - Inputs for up to 100 properties and fund / solo investor version.
- Condo / New Home Development - Model new housing units, costs, and their sale over time.
- STR (Short-term Rentals) - Up to 20 properties with seasonality, pricing, debt, and equity.
- Assisted Living Facility - Robust room rate assumptions, staffing, and more.
- Hotels - Model daily rates, seasonality, up to 20 room types, and more.
- Mixed-Use - Up to 7 'use types' each uniquely configurable. Includes sq. ft. version.
- Mobile Home Park(s) - Acquisition or development of up to 40 parks over time.
- Multi-family - For acquisitions and annual only. Includes REFI option and waterfall.
- IRR Sensitivity (Occupancy vs. Hold Period+) - See how occupancy rates effect IRR.
- Rental Property ROI Calculator - Single property acquisition, up to 30 years.
- Unit-Based Acquisition Model - Model unit types, rent per sq. ft. renovations, and more.
- Short-term Rental Arbitrage - For leasing properties and putting them on Airbnb.
- Real Estate Flipping Calculator - For flipping activity with renovation.
- Real Estate Development - 3 phases with budget vs. actual views.
- Self Storage - Equity ramping with joint ventures. Up to 6 deals over 15 years.
- Joint Venture Real Estate Financial Model - Basic monthly/annual real estate model.
- Real Estate Brokerage - Model agent scaling, commissions, volume, and fees.
- Property Management Business - Model customer on-boarding, rent/growth, and fees.
- Joint Venture Monthly Waterfall Models - Basic RE model with monthly IRR hurdles.
- Zero Down Seller Financing Strategy - For buying portfolios and REFI.
- IRR Pref. Waterfall: - 3 IRR Hurdles with GP promotes for each threshold.
- IRR Pref. Waterfall (2): - 3 IRR Hurdles + GP catch-up provision.
- Preferred Equity - All equity repaid plus preferred return plus option for equity kicker to LP.
- Preferred Return - Simple preferred return. Bonus version has an extra profit share tier.
- Preferred Return (2) - Simple interest / 3 hurdles / non-compounding. Manual equity repay.
- Cost Segregation Study - Do your own cost segregation study and benefit estimate.
- Cost Basis Calculator - An algorithm that walks the user through all various adjustments.
- Depreciation Recapture Analysis - Estimate tax liability basis when selling a property.
- Tenant and Lease Management - Reporting template for tenant #s, rent, vacancies, and more.
- Rent vs Buy - Run many scenarios with input assumptions for renting vs. buying a home.
- Real Estate Checklist - A nice Google Sheet organizer for anyone in real estate biz.
- Seller Financing - Includes 3 amortization schedule for different loan types and tax basis.
