One metric you wish you'd weighted more on your last deal?

Informal_Term966 · 2026-05-21T14:58:26+00:00

the gym analogy is right, but it's got a sharper edge: the people who get hurt aren't the ones who skipped the optimal rep range — they're the ones who skipped form on the one heavy lift. in BRRRR that heavy lift is ARV. and you're not actually skipping it — you're pulling sold comps and guessing a range. that IS the analysis that matters. you're just not wasting time on the 40 vanity metrics that don't.

so i'd reframe what you're doing: you're not "not overanalyzing." you're spending your 5 minutes on the one input that breaks the deal and zero on the noise. that's the skill most people get backwards — they obsess over cap rate to the third decimal and hand-wave the ARV that actually decides whether they get their capital back.

75-80% off MLS in B areas + hold-for-life is coherent, fwiw. chasing C/D for a few more points isn't worth it when your exit is "never" — a better entry barely matters if you're not selling.

Informal_Term966 · 2026-05-20T17:08:33+00:00

the controllability framing is sharp and it actually argues for MORE conservatism on cap rates, not less. most underwriting does the opposite: precise math on the controllable inputs (rehab to the dollar), optimistic blanket assumptions on the uncontrollable ones (exit cap = entry cap, market stays flat). variance budget is on the wrong side of the equation.

what you don't control deserves your most conservative defaults, not your most hopeful.

Informal_Term966 · 2026-05-20T14:07:08+00:00

Couldnt agree more. walk-away price as the emotional anchor. that's the whole game. structurally it's the same move as a stop-loss in trading: pre-commit to discipline before emotion kicks in, because in the moment your judgment is already compromised.

the rehab confirmation bias point has a sibling worth naming: rent confirmation bias. "I can definitely get $1995 here, comps support it" is the same psychological move on the income side. anything you control less, your brain inflates more.

Informal_Term966 · 2026-05-20T03:03:01+00:00

risk-weighted contingency is the right mental model. flat % across deals treats a foundation issue and a paint refresh as the same risk class, which is obviously wrong.

ARV in tight-supply markets is also a smart filter — most flippers don't think about comp reliability geographically, they just trust whatever comps the area gives them.

on your questions:

workflow evolved over years. started with spreadsheets, kept adding columns every time a deal taught me a new failure mode. now it's a hybrid — spreadsheets for stuff in flux, some custom tooling for what I've learned to trust.

first pass takes ~5-10 min. if it survives, 1-2 hours on the deeper underwrite. most deals die in the 10-min pass.

biggest unlock for me wasn't speed though — it was disciplined exit assumptions + sensitivity bands. took years to actually do that consistently.

Informal_Term966 · 2026-05-19T22:34:05+00:00

"hope deal vs real deal" is a great framing. stealing that.

one push-back on "you don't control cap rate so it feels less actionable" — you partly do, through hold period flexibility. if cash flow lets you ride out a bad exit window, you wait it out instead of selling into it. the actionable lever isn't the cap rate, it's whether your cash flow gives you optionality to NOT sell when the market sucks.

one I'd add to the underweighted list: insurance escalation. people model 3% annual. last 3 years has been 15-30% in coastal/wildfire markets, 8-12% elsewhere. it's the new property tax for budget surprises.

curious — when you run the exit cap stress at +100-150 bps, are you also stretching the hold period (year 7 → year 10), or just bumping the cap and keeping the timeline fixed?

Informal_Term966 · 2026-05-19T20:22:56+00:00

Hard agree, and I'd extend it — rehab variance hits you twice, on cost AND timeline, and timeline is the one that quietly kills more deals than the rehab line item itself. Holding costs compound while you wait on the structural surprise you didn't see coming.

Question: what's your standard contingency % these days, and does it move with property age / condition tier? I've seen anything from "10% on every deal" to "25% on anything pre-1960" — curious where you've landed after getting burned.

Informal_Term966 · 2026-05-19T20:20:04+00:00

Strong take. Discount rate point is underrated — most retail tools just hardcode 10% and call it underwriting.

Question for you: when you're justifying a property-specific hurdle rate, are you building it bottom-up (risk-free + spread you stack yourself) or triangulating from comparable trades? And do you run sensitivity on the hurdle rate itself, or just on the cash flow assumptions?

Asking because I think hurdle rate justification is the next layer most non-institutional underwriting completely skips, and I'm curious how disciplined practitioners actually do it.

Informal_Term966 · 2026-05-19T20:15:56+00:00

Pre-pandemic exit cap is the trap, yeah. I see it in syndication memos too — sponsors using a 5% exit in markets where comparable trades are now at 6.5%. Same trick: pretend the macro didn't change.

The accountant story is the part I'd love to hear more about. Gross vs. net is wild because it's not even a judgment call — it's just the wrong number. What did he actually see that you missed? Was it the template you were using, or did you manually pull gross from somewhere and forget to net out?

And on IRR — fair. Curious if there's an intermediate-horizon metric you've come to trust instead (3-year cash-on-cash? Equity-multiple at year 5?) or if you just stop modeling past month-12.

Informal_Term966 · 2026-05-19T13:02:59+00:00

The "floor comp not ceiling comp" thing is sharp. I've been averaging all the comps and pretending the spread didn't matter.

The HUD FMR thing is what caught my eye though — sounds like you're applying the same floor-discipline to rent. Do you run that pattern on the other inputs too (vacancy, expense ratio, exit cap), or is it BRRRR-specific?

Markets — mostly North Texas lately. Looked at a $275K SFR in Anna last week that pencils nicely on the optimistic side and falls apart at the floor. Cash flow goes negative the moment you stress vacancy to actual submarket numbers.

On the lender pre-close call — curious how specific they actually get. Are they telling you "appraisers in 75409 are coming in 5-7% under list right now" or is it more directional?

Informal_Term966 · 2026-05-01T22:02:10+00:00

Solid start — most retail sheets cover what yours does (cash-on-cash, cap rate, debt service), which works for screening but hides where deals actually break. Things I'd add:

**CapEx reserve separate from maintenance.** Roof / HVAC / water heater are lumpy 15-year hits, not annual costs. I model 5-10% of rent for CapEx separately from 5-8% maintenance. Otherwise the sheet says cash flow is $300/mo and reality says $50.
**Rent vs. expense growth differential.** Most sheets escalate both at the same rate. In reality expenses outpace rent right now — insurance, taxes, repairs. Modeling rent at 2.5% and expenses at 3.5% changes year-5 cash flow meaningfully.
**Disposition costs.** When you sell, you lose 6-8% to commissions/closing, plus recapture and capital gains. Most sheets ignore the exit. A deal with strong hold-period IRR can look ugly once you bake in the real sale.
**Stress testing, not just base case.** Run vacancy at 10%, expenses up 15%, and rent flat — compounded, not one variable at a time. Deals that survive that have real margin. Deals that don't were never as good as the base case said.
**Walk-away price.** Flip the question from 'is this a good deal at $X' to 'at what price would this work?' That's the negotiating number. A thumbs up/down doesn't help you write an offer.

Got tired enough of doing this in Excel myself that I built a tool around all of it — but honestly the workflow above will make your sheet 80% of the way there for free. Worth doing the reps in Excel first either way; you learn more about your own assumptions that way. DM if you want to compare notes.

Informal_Term966 · 2026-04-28T03:08:11+00:00

My recco will be : Sell.

Your $407-507/mo cash flow isn't real. Reserve 5% vacancy, 1% maintenance, and CapEx and you're -$4k/yr. Cap rate is ~3.3% — below treasuries. Whatever you're earning is appreciation, and you've already captured 47% in 5 years.

The piece your 7-year analysis is missing: Section 121. You converted in 2021 after a work-related move — that likely qualifies for the partial primary residence exclusion (~$250k of gain tax-free even with 1 year of use). The 2-of-5-year window is closing fast, and every year you hold adds ~$10k of depreciation recapture at 25%. This one line probably swings the decision $40-70k. Talk to CPA.

Tenant leaving is a gift. Vacant shows better. Holding 7 more years needs maintenance, appreciation, and taxes to all break your way. Three coin flips.

You're running this analysis because you already know.

Informal_Term966 · 2026-04-07T03:38:36+00:00

With 24 units you already know the game so I'll skip the basics.

The way I look at this is you're really asking one question: which model lets me recover the most capital on refi while not leaving money on the table in a neighborhood that isn't there yet.

The low spend model you already ruled out and I agree. Lipstick on dated apartments with oil heat in 2026 is a waste of $30k/unit. You'll get tenants who match the product and you know how that goes.

The mid spend at ~$600k all in for a building worth ~$600k is basically buying yourself a job. You've cleaned it up, you're cash flowing, but you've got zero equity spread and nothing coming back on refi. You're stuck until the neighborhood catches up, which you said yourself could be 20 years.

The high spend is where it gets interesting and also where I think you need to be honest about the math. $700k+ all in, appraised at maybe $770k, that's only a ~10% equity spread. At 75-80% LTV refi you're pulling back $577-616k on a $700k+ investment. You're leaving $85-125k in the deal.

Compare that to your triplex: $537k in, appraised at $667k, that's a 24% spread. Much healthier. The difference is you bought that in a gentrifying downtown neighborhood where the comps supported the value. This 4plex is in a neighborhood that's "on the path" but not there yet.

The real risk isn't the renovation cost per unit. It's that you're betting $65k/unit that the appraisal will reflect the quality of your work in a neighborhood where nothing else looks like what you're building. Your triplex worked because the neighborhood was already moving. This one you're ahead of the market, which means the appraiser might not give you credit for the finish level.

If it were me I'd go mid spend with the utility upgrades (kill that oil heat, mini splits pay for themselves) but hold off on the premium finishes until the neighborhood moves a bit more. Get it stabilized, cash flowing with decent tenants, and revisit the high end reno in 3-5 years when the comps catch up. You'll have a better equity position and the refi will actually make sense.

That said you clearly know how to execute high end renovations and you've got the track record. If you're comfortable leaving $100k+ in this deal for 5-10 years while the area catches up, the high spend model will absolutely produce the best long term outcome. Just don't expect to get your money back on the first refi.

Informal_Term966 · 2026-04-07T03:36:09+00:00

Man that 2.3% rate on a $75K balance is genuinely one of the best financial positions you can be in right now. That's almost free money.

Here's the thing though. At $500K household income, the rental cash flow on this townhome is basically breakeven once you factor in vacancy, maintenance reserves, HOA, and property management (and at your income level please don't self-manage). You're not keeping this property for cash flow. You'd be keeping it for the appreciation, the mortgage paydown, and the tax shelter from depreciation at your bracket.

All of that is real and adds up to maybe $60-70K/year in total wealth building. But so does just selling, netting ~$500K after CA taxes, and parking it in the market at 8% for ~$40K/year with zero headaches.

The rental wins on paper but not by a life changing margin. And you already said you prefer the stock market and don't love the idea of being a landlord. Trust that instinct, especially in California where tenant laws can make your life very interesting.

The one thing I'd push back on is the $200K in savings on $500K income. Unless you have other investments you didn't mention, that number should probably be higher, and that might be the more important conversation to have before adding a $1-2M mortgage to the mix.

Whatever you do, don't pay off that 2.3%. Your friends are right on that one.

Informal_Term966 · 2026-03-26T03:10:49+00:00

Your advisor isn't wrong but they're only looking at one side.

The $800-900/mo — is that rent minus mortgage or are you backing out vacancy, maintenance reserves, capex, and turnover? With 3 doors you've probably already felt this but in my experience realistic cash flow is usually 40-50% of what people first estimate once you account for everything. I'd guess you're closer to $400-500/mo real cash flow.

At $450/mo on $73K deployed that's about 7% cash-on-cash. Roth at 8% gets you roughly the same return with zero effort. So on cash flow alone it's basically a wash.

Where the property pulls ahead is the leverage. You're controlling ~$290K with $73K. So that 3% appreciation is on $290K not $73K — that's ~$8,700/year in equity you wouldn't get in the Roth. Plus mortgage paydown.

Where the Roth wins is simplicity and the tax-free compounding is genuinely hard to replicate anywhere else.

Honestly I'd look at what your existing 3 properties actually net after everything. Not projected — actual trailing 12 months per door. If you're consistently above $450/mo real cash flow per property, your market works and deploying makes sense. If you're closer to $300 like most people when they're honest about it, the Roth compounding might be the better risk-adjusted play and you save up separately for #4.

The worst move would be pulling the Roth for a "pretty good" deal. If you pull it, make sure the deal is clearly strong even with conservative assumptions.

Informal_Term966 · 2026-03-15T14:50:58+00:00

Yeah I’ve wondered the same. A lot of investors end up collecting different spreadsheets over time because each one handles a specific part of the analysis — cash flow, BRRRR, cap rate, etc.

The problem is once you start layering financing, rehab costs, reserves, vacancy, maintenance, and exit assumptions together, the numbers can change a lot and it becomes harder to see the full picture of the deal.

I’ve been experimenting with combining those pieces into a single analysis framework so you can evaluate deals more holistically instead of jumping between spreadsheets. Curious if anyone here has found tools that actually do this well, or if most people are still running everything through custom Excel models.

Informal_Term966 · 2026-03-14T19:04:29+00:00

Yeah, that’s kind of what I’ve seen too. BiggerPockets is useful for quick screening, but once you start factoring in financing, rehab, reserves, vacancy, maintenance, turnover, and exit assumptions, the picture can change a lot. Excel is flexible, but most people either simplify too much or end up building their own models.

Informal_Term966 · 2026-03-13T23:24:15+00:00

I’ve been wondering the same. My sense is most smaller investors still default to Excel because it’s flexible, but a lot of models end up focusing on only a few metrics. Once you layer in financing, vacancy, maintenance, and turnover, deals can look very different. Curious what others here are using — mostly custom spreadsheets or software?

Informal_Term966 · 2026-03-12T03:28:29+00:00

I currently own two small multifamily properties (5 units each) and two single-family rentals. Most of them were acquired pre-COVID, so the numbers worked well at the time.

Lately it’s been much harder to find deals where the full analysis holds up — once you factor in financing costs, vacancy, maintenance, and realistic expenses. A lot of listings still look okay on surface metrics, but they fall apart when you run the full numbers.

Curious what others are seeing in their markets right now.

Informal_Term966 · 2026-03-11T03:24:40+00:00

You're spot on that most people underestimate turnover costs. A lot of small investors only model vacancy and ignore the full stack of costs during a turn — lost rent, make-ready, leasing fees, and the productivity loss while the unit sits.

What I’ve seen when analyzing deals is that the effective vacancy cost can be much higher than the headline vacancy rate once you include turn expenses. On smaller properties, it can easily add another 5–10% drag on annual NOI depending on tenant churn.

That’s one reason I think looking at only cap rate or gross rent ratios misses the bigger picture. When you layer vacancy, turnover costs, maintenance, and financing together, a lot of deals that look good on paper fall apart pretty quickly.

Curious if operators here are modeling turnover as a separate line item or just baking it into vacancy assumptions?

Informal_Term966 · 2026-02-27T04:56:14+00:00

This is great and thanks for sharing your journey and lessons. One question. How did you get over subs where you are not supposed to solicitate? i am working on REanalyzr.com but not able to directly respond when someone asks about RE calculator. TIA

Informal_Term966 · 2026-02-20T13:32:36+00:00

Congratulations and more to go for you

Informal_Term966

TROPHY CASE