Real Estate Finance And Investment

Getting Your First Multi-Family Deal Underwritten Without Losing Money

Most people walk into their first real estate deal thinking they need a perfect spreadsheet before they make an offer. They don't. What they actually need is a repeatable process that catches the things that kill deals on the back end. I've seen good deals die because someone forgot to account for a tenant's lease riding through a major renovation, and I've seen mediocre deals pull cash flow from day one because the numbers were built around real vacancy assumptions instead of hopeful ones. Real Estate Finance And Investment isn't just about knowing what cap rate means. It's about understanding how the money moves between acquisition, operations, and exit, and which moving parts can quietly eat your returns. The finance side determines whether a deal is actually viable after you account for debt service, reserves, and the inevitable surprises. The investment side determines whether the market and asset type align with your risk tolerance. Treat them as separate exercises and you'll misprice everything. Here's a specific problem I ran into last year. I was underwriting a 12-unit building in the Midwest where the seller claimed 92% occupancy. The rent rolls showed long-term tenants with below-market leases, but the real issue was an expiring Section 8 contract on four units. The subsidy was worth roughly $180 a month per unit, and it dropped after month three of ownership. My initial pro forma projected positive cash flow for year one because I hadn't accounted for that cliff. The fix was straightforward: I built the subsidy phase-out into the model as a three-month ramp-down starting at closing, not year two. That adjusted the DSCR from 1.42 to 1.08, which barely cleared the lender's threshold. We renegotiated the purchase price by $14,000 and walked away clean.

How to Structure Your Acquisition Model

Start with the hard numbers before you add any comfort assumptions. Input the purchase price, closing costs, rehab budget, and debt terms. Then layer in operating income using actual lease data, not market rent schedules. Market rents are a marketing tool. Actual rents are what show up on your bank statement. For vacancy, use a blended figure based on the property's actual turnover history over the past 24 months. If the seller hasn't provided records, assume 8% for class B and 6% for class A in most markets. Don't go lower without documented lease renewals already in place. Operating expenses should include property management at 5 to 8 percent of gross income, maintenance reserves at $150 to $300 per unit per year, and insurance that reflects the actual construction type. A wood-frame building in an earthquake zone will cost significantly more to insure than a steel-and-concrete structure in the same market, even if the rents are identical.

The debt service calculation is where most beginners underestimate. Commercial loans today often come with 25-year amortization but 5 or 7-year terms. The balloon payment at year five or seven is a real liability. Run your model through the full amortization schedule, not just the monthly payment. I typically build in a refinance assumption at year three or four at slightly higher rates to test whether the property can carry itself if the market tightens before the balloon hits.

Underwriting the Exit

The exit is the part everyone rushes through. You're holding the asset for three to seven years. At the end of that period, you either sell or refinance. Both require an exit cap rate that's typically 25 to 50 basis points wider than your entry cap rate to account for market risk and holding period costs. If you bought at a 6.5% cap and exit at 7%, your net sale proceeds drop by roughly 12 percent compared to a static cap assumption. I once underwrote a value-add deal where the seller's broker provided a pro forma showing a 5.5% exit cap. That was aggressive for the submarket. I held at 6% for the sell scenario and built in a 150 basis point spread from entry. The equity multiple fell from 2.1x to 1.6x. Still a solid return, but it changed the hold period recommendation from five years to six. The extra year let the value-add stabilization hit before the sale. Don't confuse exit cap rate with going-in cap rate. The going-in number reflects current income and risk at acquisition. The exit cap reflects stabilized income and risk at disposition. Using the same number for both is a common mistake that inflates projected returns by 20 to 40 percent.

Sensitivity Analysis Without Overcomplicating It

Build a simple sensitivity table. Change two variables: rental income and expense growth. Run scenarios at minus 10%, flat, plus 10%, and plus 20% for each. The matrix gives you a clear picture of where the deal breaks and where it thrives. You don't need Monte Carlo simulations. A five-by-five grid takes about 20 minutes and tells you more than a glossy annual report that assumes everything goes right. The breaking point for most starter deals is a combination of higher vacancy and higher interest rates. When debt service rises and income falls simultaneously, cash flow vanishes faster than most investors expect. I flag this early in every deal I review. If the pro forma shows negative cash flow in the downside scenario, the deal needs a bigger down payment, a longer hold period, or a lower purchase price.

Common Pitfalls in Real Estate Finance And Investment

One pitfall that catches experienced investors regularly is ignoring capital expenditure timing. Roof replacements, HVAC conversions, and parking lot resurfacing don't happen evenly across the hold period. They cluster. A 20-unit property in a moderate climate might need a $120,000 roof in year two and $60,000 in unit upgrades in year four. If you spread those evenly across the model, you're understating the cash impact in critical years. Another issue is double-counting value. When a property has existing deferred maintenance that you plan to fix, don't add the after-repair value without subtracting the cost of repairs from your exit calculation. The market prices in the work. If you claim full ARV and don't deduct the rehab cost, your exit is artificially inflated by the entire improvement budget. Financing assumptions also tend to be optimistic. New investors often model at the rate they qualify for today. But commercial lending has tightened significantly since 2022. Many lenders now require minimum DSCR of 1.20 to 1.25 and are hesitant to finance properties with high borrower concentration or unusual structures. Test your model at the tighter terms. If the deal still works, you've built in a margin of safety. If it doesn't, you saved yourself from a costly offer rejection later.

Quick Reference Numbers for Early-Stage Deals

Class B multifamily in secondary markets typically yields a 6% to 8% cap at entry, with 5 to 10% annual appreciation over a five-year hold. Value-add deals target 10% to 14% IRR, but only if the stabilization timeline is realistic. A three-year rehab with 18 months of leasing is common. Don't compress that to 18 months unless you have a track record of executing similar projects on schedule. Single-family rental portfolios follow different math. Acquisition costs are lower per unit but management intensity is higher. Self-managing 20 single-family homes is not sustainable past a certain point. At that scale, professional management at 8 to 10% of collected rent becomes necessary, and it changes the yield picture considerably. The tools you use don't matter as much as the discipline behind them. Excel, Yardi, RealData, or a paper notebook — the model needs to be transparent, auditable, and easy to update when actual performance diverges from projections. I keep a shadow ledger alongside my pro forma so I can compare assumed versus actual within 30 days of closing. That feedback loop is what separates investors who learn from those who just repeat the same mistakes.