Streamline your real estate underwriting and deal analysis with these Excel-based models, built for everything from ground-up construction to property acquisitions. The templates cover acquisition/build, stabilize, and exit as well as include DCF analysis and integrated GP/LP joint venture waterfalls.
$299.00 USD
(Immediately Downloadable After Purchase)
Underwriting Templates:
- Hotel Analysis - Advanced - Bookings, residence unit sales, joint venture, and more.
- Fix and Flip Scaling Model - Model 3 property types over a 10 year period, joint venture.
- 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 (new) - 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.
- New Home Development - Home builders can use this model for cash flow planning.
- 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:
- Office-as-a-Service - Dynamic timelines / utilization, pricing, leverage, more.
- Event Venue Business - Dynamic event assumptions, 4 joint venture scenarios, debt, more.
- Warehouse Fulfillment Operator - Model seasonality, activity, volume, and more.
- 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.
