Listening to Our Customers: Why We Built a Dedicated Acquisitions Module

When we launched RE-Modeler, our focus was crystal clear: help developers underwrite ground-up and value-add development projects better than they could in Excel. But our customers had bigger ambitions. They weren't just building—they were also buying stabilized and transitioning properties. Today, we're excited to announce our acquisitions module, built entirely from customer feedback.

The Feedback: "We Need This for Acquisitions Too"

The pattern was unmistakable. Customer after customer told us: "I love the simplicity of the RE-Modeler development tool, but I'm still stuck in Excel for acquisition analysis. Can you help?"

Honestly? We didn't see it coming. When we launched, we thought acquisitions underwriting would be a niche need—something we'd tackle in a much later iteration after perfecting development features. We assumed we could target ground-up construction modeling and that the market for acquisition analysis tools was limited. We were wrong.

The demand was overwhelming. Customers weren't just building—they were building and buying. The same developers underwriting new construction were simultaneously analyzing acquisition opportunities, and they wanted the same speed, accuracy, and ease-of-use for both. The message was clear: acquisitions couldn't wait. So we moved it up the roadmap and built it.

Why Acquisition Underwriting in Excel Falls Short

Rent Roll Management is a Nightmare

In Excel, building and maintaining a detailed rent roll means endless rows of unit-by-unit data: tenant names, lease start dates, expiration dates, in-place rents, market rents, square footage, and more. When you have 100+ units, this becomes unwieldy fast.

Need to model what happens when Unit 203's lease expires in Month 14? Better have perfect formulas that check expiration dates, apply renewal probability, reset rent to market (or renewal bump), account for turnover costs, model vacancy during turnover, and track when the new lease expires. Now multiply that by every unit in the building.

Our solution: The acquisitions module handles rent roll complexity automatically. Enter your units once, specify lease expirations (individual or aggregate), set your renewal assumptions, and the engine projects every lease event accurately. Change your renewal rate assumption? The entire pro forma updates instantly across all units and all months.

Lease Expiration Analysis Requires Complex Logic

Modeling lease rollovers in Excel demands sophisticated IF statements and nested formulas. When does the lease expire? Will the tenant renew or turn? If they renew, what rent do they pay and when does that lease expire? If they turn, how long is the downtime? What's the re-leasing cost? What rent does the new tenant pay?

Get any part of this logic wrong—an off-by-one month error, a circular reference, a formula that doesn't copy correctly—and your entire cash flow projection is invalid. Debugging these errors can take hours, and you might not catch them until a lender or investor questions your numbers.

Our solution: Built-in lease expiration tracking handles all the logic correctly, every time. The system knows each unit's lease end date, applies renewal probability, models turnover accurately, and tracks the cascade of subsequent expirations. You see exactly when each lease event occurs and what financial impact it has. No formulas to debug, no logic errors.

Turnover Analysis is Hard to Visualize

In Excel, understanding your property's lease expiration schedule means staring at rows of dates or building custom pivot tables and charts. When are your big rollover months? How much turnover cost should you budget? What's your re-leasing risk in Year 3?

Our solution: The acquisitions module provides a detailed lease schedule showing exactly what happens each month: which units expire, how many renew vs. turn, turnover costs, vacancy periods, and rent resets. Visual clarity means better decision-making and more confident presentations to partners.

Aggregate vs. Detailed: Different Deals Need Different Approaches

Sometimes you have complete rent roll data with individual lease expirations for every tenant. Other times—especially in early-stage LOI analysis or when seller data is limited—you need to model aggregate assumptions: "Assume an average 10% annual rollover rate" or "All leases expire in Month 36."

In Excel, switching between these approaches means rebuilding your model or maintaining multiple template versions. Neither is efficient.

Our solution: Toggle between aggregate and detailed lease tracking modes with one click. Use aggregate mode for quick initial analysis or when data is limited. Switch to detailed mode when you have complete rent roll information. The same interface handles both approaches seamlessly.

Acquisitions vs. Development: Different Beasts

Understanding why acquisitions need their own module requires understanding how acquisition analysis differs from development underwriting:

These differences aren't cosmetic—they require different modeling infrastructure. A development model optimized for tracking construction progress and lease-up velocity isn't built to handle the granular lease-by-lease analysis that acquisition underwriting demands.

What the Acquisitions Module Does Better Than Excel

1. Intelligent Rent Roll Management

Enter your rent roll once: unit types, counts, square footage, in-place rent, market rent. The system automatically calculates rent per SF, tracks total units and square footage, and validates your inputs. Add or remove unit types instantly without worrying about formula references breaking.

2. Flexible Lease Expiration Modeling

Aggregate Mode: Perfect for initial analysis. Specify a single expiration month for all leases, or model a percentage rolling each year. Great for seller-provided T-12 data without detailed lease schedules.

Detailed Mode: When you have complete lease data, enter individual expiration dates for each unit type. The system tracks every renewal and turnover event separately, providing maximum accuracy.

3. Sophisticated Turnover Assumptions

Set renewal rate (% of expiring tenants who renew), renewal rent bump (% increase for renewing tenants), new lease duration for renewals, turnover downtime (months of vacancy), and turnover cost per unit. The engine applies these assumptions consistently across all lease events throughout your hold period.

4. Triple Net (NNN) Reimbursements

For commercial properties, model NNN reimbursements on a per-SF basis with growth assumptions. The system calculates reimbursement income alongside base rent, providing accurate total revenue projections.

5. Comprehensive Operating Expense Modeling

Track personnel, marketing, repairs & maintenance, utilities, property taxes, insurance, management fees, and other operating expenses. Apply expense growth rates and see how operating margin trends over your hold period.

6. Value-Add and Repositioning Scenarios

Model capex budgets for property improvements. Track how capital investment drives rent growth from in-place rents to market rents. See the ROI on your value-add business plan.

7. Exit Analysis and Returns

Project exit value using cap rate assumptions. Calculate IRR, equity multiple, and cash-on-cash returns. Understand how your repositioning strategy drives value creation.

Real-World Use Cases

Use Case 1: Stabilized Multifamily Acquisition

You're underwriting a 150-unit stabilized apartment building. The seller provides a rent roll with 150 individual leases expiring over the next 24 months, plus T-12 operating statements. In Excel, this means 150 rows of lease data, complex expiration formulas for each tenant, and dozens of linked worksheets.

With the acquisitions module: Import the rent roll, specify individual lease expirations in detailed mode, set renewal assumptions based on market comps, and hit calculate. The system generates a complete 60-month pro forma showing every lease event, turnover cost, vacancy period, and rent adjustment. Change your renewal rate assumption from 70% to 75%? The entire model updates in seconds.

Use Case 2: Value-Add Office Acquisition

You're buying a 50,000 SF office building with in-place rents at $20/SF when market is $28/SF. Half the building has leases expiring in the next 18 months—your value-add opportunity. You plan $1M in capex for common area improvements to justify market rent on rollovers.

With the acquisitions module: Model the existing rent roll with staggered lease expirations, separate in-place and market rents, add your $1M capex budget, and project NOI as leases roll to market. The system shows you exactly when rent bumps occur, how much additional NOI you capture, and what your stabilized exit value looks like. Sensitivity analysis on renewal rates and re-leasing downtime helps you stress-test the business plan.

Use Case 3: Early-Stage LOI with Limited Data

You're submitting an LOI on a retail center. The broker's package includes T-12 income but no detailed lease schedule. You need to underwrite quickly based on aggregate assumptions.

With the acquisitions module: Use aggregate mode to model average lease expiration timing (e.g., "leases turn at 10% per year"), apply market rent assumptions, estimate turnover costs, and project returns. Quick, reasonable, and sufficient for LOI pricing. If you win the deal and get detailed lease data during due diligence, switch to detailed mode without rebuilding your model.

Customer Feedback Drives Product Development

Building software is about solving real problems for real users. Every feature in our acquisitions module came directly from customer conversations:

• "Can you handle individual lease expirations?" → Detailed lease tracking mode
• "Sometimes I just need to model 10% annual roll without unit-by-unit data." → Aggregate expiration mode
• "I need to see turnover costs and downtime separately from rent loss." → Dedicated turnover cost tracking and vacancy modeling
• "My commercial properties have NNN reimbursements." → Triple net revenue modeling
• "I want to model rent bumps on renewals vs. market rent on new leases." → Separate renewal bump and market rent logic

We didn't build features we thought customers should want. We built the features they told us they needed, because they were doing this work painfully in Excel every day.

The Unified Platform Advantage

With both development and acquisition modules in one platform, you get:

• One login, one interface: No more switching between different Excel templates or file structures
• Consistent assumptions: Use the same expense growth rates, exit cap rates, and financing assumptions across all deals
• Portfolio-level view: See all your development and acquisition projects in one place
• Shared knowledge base: Historical deals—whether development or acquisition—become institutional knowledge
• Team efficiency: Train analysts once on one platform, not separate systems for different deal types

What's Next

The acquisitions module is live today, but we're not done. Based on ongoing customer feedback, we're already working on:

• Rent roll import from Excel/CSV files (because manually entering 200 leases shouldn't be necessary)
• Lease-by-lease reporting showing individual tenant economics
• Portfolio aggregation for multi-property acquisitions
• Market rent comps integration for data-driven assumptions
• Historical lease rollover analysis to validate renewal rate assumptions

If you have ideas for what would make acquisition underwriting even better, we want to hear them. This module exists because customers spoke up. Your feedback shapes what we build next.

Try It Today

If you're already using RE-Modeler for development projects, the acquisitions module is live in your account now. If you're not yet a customer but you're tired of wrestling with Excel for acquisition underwriting, we'd love to show you what purpose-built software can do.

Because whether you're building or buying, your underwriting deserves better tools than spreadsheets built for accountants in 1985.