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.
$299.00 USD
(Bundle Downloadable After Purchase)
Underwriting Templates:
- Multi-Family Acquisitions - Includes T12, forward assumptions, debt, REFI, 3 waterfalls.
- Senior Living Acquisition Model - Biz + real estate, SBA loan options, REFI, pref. waterfall.
- Retail Building Construction - Up to 15 tenants, dynamic lease-up, joint venture, exit.
- Lot Development Model - Individual lot configuration, debt, joint venture, cash flow.
- General Real Estate Model - Self-storage, apartment buildings, multi-family, and more.
- Strip Mall Acquisition - Up to 30 tenants, leverage options, joint venture, IRR table.
- Single Tenant Industrial - Rent per sq. ft., lease-up costs, waterfalls, opex, disposition.
- 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.
Joint Venture Cash Flow Waterfalls:
- 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.
Other Similar Templates for the Real Estate Industry:
- Sale-leaseback Analysis - 4 points of view, NPV output, accounts for tax effects.
- Data Center - Configure bottom-up rack utilization assumptions, pricing, cost/rack.
- 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.
- Land Banking - I don't have this available singularly, but you get it in the bundle.
These underwriting and investment analysis spreadsheets primarily center around acquisitions. Most have an option for joint venture waterfall distributions that drive off of IRR hurdles. Check out only build and rent models here.
Check out all financial model templates in one bundle here. There are also great discounts when buying by category.
