Am I Overestimating Rental Expenses, or Is Cash Flow Really This Difficult in Today's

Am I Overestimating Rental Expenses, or Is Cash Flow Really This Difficult in Today's

Ambler, PA · Member since 2017 · 28 posts · 15 votes

Hey everyone,

I'm relatively new to real estate investing and have been putting together an Excel calculator to analyze potential rental properties, primarily using the BRRRR strategy.

I've based much of my calculator on Chapter 5 of Brandon Turner's The Book on Rental Property Investing, factoring in:

  • Vacancy: 5%

  • Routine repairs and maintenance: 8%

  • Property management: 10%

  • Leasing/turnover: 1%

  • Capital expenditure reserves: 7%

  • Property taxes and insurance

  • Landlord-paid utilities and other operating expenses

  • Mortgage payments based on a 30-year mortgage at 7.5%

For clarification, the loan balance I enter is what I expect to owe after refinancing, not necessarily the original purchase price.

What's surprising to me is that almost every property I analyze produces negative cash flow. Even when I run scenarios where I'm purchasing a property significantly below asking price, sometimes by $100,000–$200,000, and reduce my projected mortgage balance accordingly, the numbers still struggle to work.

Here is an actual property I'm using as an example in the attached calculator:

17 W 4th St, Lansdale, PA 19446

  • Asking price: $379,900

  • Property type: Duplex

  • Rental income per unit: $1,600 (previous rental income)

  • Total monthly rental income: $3,200

  • Assumed loan balance after refinancing: $380,000

  • Calculated monthly net cash flow: -$1,412

  • Calculated annual net cash flow: -$16,944

Even if I reduced the loan balance to $200,000, nearly $180,000 below the asking price, my calculator would still show a monthly loss of approximately $153.

My goal is to generate at least $300–$500 per month in net cash flow after accounting for all expenses and reserves.

I've attached my Excel calculator and would appreciate some feedback from experienced investors.

  • Is there anything wrong with my formulas or overall approach?

  • Am I overestimating certain expenses or potentially double-counting anything?

  • Are my expectations for monthly cash flow unrealistic?

  • Or is finding positive cash-flow properties simply this difficult in the current market?

I'm primarily looking at single-family and small multifamily properties in eastern Pennsylvania.

I'm trying to educate myself before purchasing my first investment property, so any constructive criticism or feedback would be appreciated. I'd rather find out now that I'm doing something wrong than after purchasing a property.

Thanks in advance!

2Reply
2,357 views

Most Popular Reply

Erik EstradaBusiness Member
Lender · Los Angeles, CA · Member since 2022 · 7k+ posts · 1k+ votes
6d

Eric, your formulas aren't the problem. The deal is.

At $380K and 7.5% on a 30-year, principal and interest is about $2,657. Your numbers imply roughly $960 a month in taxes and insurance, so the rent covers only about 0.88x the payment before any reserves. A DSCR lender would see that too: under 1.0, most will cut the loan amount or price it up.

Working backward from $3,200 rent with your 31% reserves, the loan has to be about $178K to break even. Just to hit a 1.0 DSCR, it's about $320K. That's why $200K still lands slightly negative.

So the levers are the purchase price and the rehab spread, not your expense assumptions. A BRRRR refi usually caps at 75% of appraised value, so to pull most of your cash out at a $250K loan you'd need it to appraise around $330K or more after the work. Or you look at a higher rent-to-price market.

Your reserve percentages look reasonable for a duplex. I wouldn't cut them to make a deal pencil.

Erik

LuxePrivate Investments LLC 571 Reviews
See this reply in the discussion

17 Replies

Jump to latestLatest
  • Erik EstradaBusiness Member
    Lender · Los Angeles, CA · Member since 2022 · 7k+ posts · 1k+ votes
    6d

    Eric, your formulas aren't the problem. The deal is.

    At $380K and 7.5% on a 30-year, principal and interest is about $2,657. Your numbers imply roughly $960 a month in taxes and insurance, so the rent covers only about 0.88x the payment before any reserves. A DSCR lender would see that too: under 1.0, most will cut the loan amount or price it up.

    Working backward from $3,200 rent with your 31% reserves, the loan has to be about $178K to break even. Just to hit a 1.0 DSCR, it's about $320K. That's why $200K still lands slightly negative.

    So the levers are the purchase price and the rehab spread, not your expense assumptions. A BRRRR refi usually caps at 75% of appraised value, so to pull most of your cash out at a $250K loan you'd need it to appraise around $330K or more after the work. Or you look at a higher rent-to-price market.

    Your reserve percentages look reasonable for a duplex. I wouldn't cut them to make a deal pencil.

    Erik

    LuxePrivate Investments LLC 571 Reviews
  • Member since 2023 · 194 posts · 80 votes
    6d

    Eric, Erik's math is right, the deal is the problem, not your formulas. The one line I would look at hardest as an operator is vacancy plus leasing and turnover. You have 5% vacancy and 1% turnover, and those two lines are where real-world results swing the most.

    We run 236 doors in Memphis, mostly single-family, and our turnovers run on a 21-day schedule that starts before move-out. A vacant week on a 3BR Section 8 house here runs roughly $350-$490 in lost rent, and a slow turn eats a whole year of your 5% vacancy assumption in a few weeks. Vacancy costs more than most repairs.

    So I would not cut the reserves to make a deal pencil. If anything, stress-test the deal at a longer vacancy and a slower turn, and only buy the ones that still work.

  • Realtor · Columbus, Franklin County · Member since 2026 · 195 posts · 74 votes
    6d

    @erics226 Eric, your expense percentages are reasonable, and the replies are right that the debt is the problem on this one. One way to make your calculator more useful: run it backwards. Put in the rent, your expense percentages, the real tax bill and an insurance quote, then solve for the loan amount that still leaves the cash flow you want at 7.5%. That's your maximum refinance loan. Divide it by the lender's cash-out LTV and you get the ARV the deal needs, and from there your maximum all-in price for purchase plus rehab. On a BRRRR, also check the refinance lender's DSCR minimum, because the refi is sized off the appraiser's market rent, not the old lease. If a duplex renting for $3,200 needs an ARV the sold comps don't support, the calculator is telling you the price is too high for a rental, not that the math is wrong. What ARV do the sold comps support on that one?

  • Michael K GallagherBusiness Member
    Real Estate Agent · Columbus OH · Member since 2018 · 1k+ posts · 1k+ votes
    6d

    we are getting seller concessions to buy down interest rates to get investor deals done, but it is still taking a very solid rent to price ratio to make it work.

  • Noah WrightBusiness Member
    Lender · USA, Nationwide · Member since 2024 · 595 posts · 173 votes
    6d

    Nothing in your setup looks double-counted. Leasing sits apart from vacancy and capex sits apart from repairs, so the percentages hold up. The gap is that the sheet only models the loan after the refi. On a BRRRR you carry a first loan to buy and fix the place, and on the hard money or bridge side that commonly means 1 to 3 points up front plus interest-only payments, with taxes, insurance and utilities running while the units sit empty. Whatever the refi doesn't pay back stays in the deal as your own cash, so it belongs on the sheet right next to the cash flow line. Adding a tab for that phase now, before the first offer, is a habit that saves people on their first deal. What do you expect the rehab to cost, and how long would you hold before the refi?

  • Member since 2017 · 131 posts · 73 votes
    6d

    eric, everyone's right that the debt is the problem at $3,200. the one line nobody has touched is the rent itself. $1,600 a side is what a family pays for the whole unit. if each side has 3 bedrooms, the same building rented by the room is a different deal. it's how we rent all of ours.

    it isn't free money though, so if you model it, change these lines too: you pay every utility plus internet for both sides, you furnish each room and the shared spaces once, you pay a cleaner for the kitchens and bathrooms, and rooms turn over more often than families, so more vacancy and turnover cost than your 5% and 1%.

    pull 10 room listings near the train station to get a real room rent instead of guessing, and call the borough first. some towns cap how many unrelated people can share a unit and some want a rental license per unit, and that answer decides whether this works before the spreadsheet does.

    our own rule is a house has to clear $1,000 a month after the mortgage and every one of those costs, or we pass. under that, one bad turnover wipes out the year.

  • G. Brian DavisPro Member
    Investor · Hatboro, PA · Member since 2016 · 3k+ posts · 906 votes
    6d

    I don't think your calculator is the problem. I actually like that you're being conservative with vacancy, repairs, CapEx and management instead of leaving those out just to make a deal cash flow. At $3,200 in rent, though, a $380K loan at 7.5% is simply a lot of debt for the income the property produces. Even getting the loan down to $200K and still being slightly negative tells me the issue is probably the basis, not the spreadsheet. That’s actually useful information. I’d keep your assumptions and let the numbers tell you what you need to pay. If the property only works at a price significantly below the asking price, then that’s your offer or you move on. There will always be another property.

  • Joseph ScoreseBusiness Member
    Banker · Philadelphia · Member since 2009 · 2k+ posts · 650 votes
    5d

    Eric, first off, I give you credit for doing the homework before jumping into your first investment. Too many investors learn these lessons after closing.

    I've been in mortgage banking, private lending, and real estate for over 20 years, and I can tell you that what you're experiencing is pretty common in today's market, especially throughout eastern PA and NJ.

    I don't think you're necessarily overestimating expenses. If anything, many investors underestimate maintenance, capital improvements, property taxes, and insurance.

    One thing that jumps out at me is the $380K refinance balance against $3,200 in monthly rental income. That's a lot of debt for the property to support. Even with DSCR financing, the rental income still needs to justify the loan amount.

    I'd also take another look at your vacancy, maintenance, turnover, and capital expenditure assumptions to make sure you're not overlapping expenses. That doesn't mean eliminating reserves just to make the numbers look better.

    With BRRRR, the real opportunity is buying at the right price, creating equity through renovations, increasing rental income where the market supports it, and refinancing into a manageable payment.

    One thing I've learned over the years: You can't finance your way out of a bad acquisition.

    Your goal of $300–$500 monthly cash flow isn't unreasonable, but it may require looking at different properties, markets, or smaller multifamily opportunities.

    I'm also a big believer in running the numbers at different refinance amounts. Sometimes leaving more equity in the property makes more sense than trying to pull every dollar back out.

    Eric, I'm familiar with the Lansdale and surrounding markets. I'd be happy to compare notes on your numbers and share how we evaluate BRRRR opportunities from a lending perspective.

    Keep asking questions and running the numbers. Passing on a deal that doesn't work is just as important as finding one that does.

    Joseph V. Scorese
    Senior VP Business Development | Built Lending
    Nationwide Direct Private Lender

    • Ambler, PA · Member since 2017 · 28 posts · 15 votes
      2d

      Hey,

      Thank you very much for the feedback. Seems like every property i look at in the Lansdale and surrounding areas you would need to buy the property at 50% of the asking to have a shot at cash flow. Could just be a very tough market or me being to conservative with my number. Would love to connect with someone who knows the area.

  • Ryan BrownPro Member
    Real Estate Agent · Louisville, KY · Member since 2022 · 140 posts · 46 votes
    5d

    Eric, I don't think you're overestimating. Your reserve percentages are reasonable, and I wouldn't cut them just to make a deal work on paper. Cash flow really is that hard to find right now, especially at 7.5% interest on a 30-year loan.

    We recently tested this in Louisville. We ran every active listing through a cash-flow screen using conservative assumptions like yours: vacancy, repairs, CapEx, management, taxes, insurance and current interest rates. Only 25 listings came out with positive cash flow. That's in a market with much better rent-to-price ratios than most of eastern Pennsylvania. Even the ones that passed were mostly only a little positive, not the $300–$500 a month you're aiming for.

    So your calculator is doing its job. When almost everything comes out negative, the spreadsheet is usually reflecting the market accurately. Erik's point is the right one: the levers are the purchase price, the rehab spread on a BRRRR, and the rent-to-price ratio of the market you buy in. Your expense assumptions aren't the problem.

    A few things I'd keep in mind as you keep analyzing:

    Look for the deals that the averages hide. Properties that have sat on the market a long time, older owners ready to sell, homes that need work most buyers won't take on, and creative terms like seller financing are where the numbers start to work. A house at full asking price on the MLS rarely works.

    Underwrite the refinance carefully. With a 75% loan-to-value cap, your after-repair appraisal decides whether the BRRRR works at all. Get real comparable sales before you commit.

    Rethink the target for your first deal. Some investors accept break-even or small cash flow on the first property, then count on equity, principal paydown and rent growth. That's a valid strategy if you go in knowing that's the plan and have reserves. Just don't fudge the numbers to call something cash flow when it isn't.

    Running the numbers before you buy, instead of after, puts you way ahead of a lot of people. Keep running them. When a deal finally passes a screen this tough, you'll know it's real.

    • Ambler, PA · Member since 2017 · 28 posts · 15 votes
      2d

      Hey,

      Thank you very much for the feedback and suggestions. I will dig into this a little more as you suggested.

  • Virtual Assistant · Remote · Member since 2020 · 159 posts · 70 votes
    5d

    Your percentages are fine. The lender already did the math, and the deal is the problem, not the calculator. But there is one thing worth changing before you buy, and it is how those percentages live after closing.

    A percentage is an underwriting guess. Once you own the place, replace each line with the real number: the actual tax bill, the actual insurance quote, the actual maintenance history on that building. And fund the reserves as real money, a monthly transfer into a separate reserve account, not just a line on the sheet. A 7% capex line you never move is just a number. A transfer that actually leaves the operating account is a roof fund.

    Same with repairs versus capex. Code it right the day the invoice lands, because a $10k roof booked as a repair tells a different story on the P&L and the tax return than the same roof capitalized and depreciated. Keep the percentages for screening deals. Run the books on actuals once you own one.

  • Noah WrightBusiness Member
    Lender · USA, Nationwide · Member since 2024 · 595 posts · 173 votes
    2d

    You're not being too conservative. Your gut check of half of asking lands close to the break-even loan worked out earlier in this thread, so your spreadsheet and your instinct agree, and that's worth trusting. The reason is that small duplexes in towns like Lansdale are often priced by buyers who plan to live in one unit. Their price is set by a paycheck, not by the rent, so an investor counting on a DSCR refi is bidding against people who don't need the $3,200 to cover the payment. That's why the BRRRR deals that pencil in areas like this usually come off-market, need real work, or have rents well under market, and clean listings rarely do. A local agent who works small multifamily in Montgomery County is the right person to find those. How much of your own cash are you willing to leave in a deal after the refi?

  • Chris ColtonPro Member
    Investor · San Antonio, TX · Member since 2026 · 234 posts · 90 votes
    2d

    Hi Eric, I am running into the same thing in San Antonio. Most of the deals I run come out negative too, and I had to learn that the calculator is doing its job when it says no. The one idea that stuck with me is simple. The payment has to fit the rent that is actually coming in, not the rent I hope to get later. If it does not fit, I pass and keep looking. I am still learning, so I keep my expense lines in and let the numbers decide.

  • Ashish AcharyaBusiness Member
    CPA, CFP®, PFS · Sarasota, FL · Member since 2017 · 5k+ posts · 3k+ votes
    1d

    Eric, your expense assumptions aren't crazy, and running the numbers this hard before buying is exactly the right instinct. One thing worth separating in the calculator is cash flow from taxable income, since they won't match. The CapEx reserve and the principal part of your payment are real cash going out but aren't deductible, while depreciation is a deduction that never touches your bank account. A deal can show negative cash flow and a tax loss at the same time, but the tax loss alone won't fix a deal that doesn't cash flow. Use the pre-tax number to decide whether to buy, and treat the tax side as a bonus on a deal that already works.

    INVESTOR FRIENDLY CPA®4.9242 Reviews
    TaxMD® | Tax Planning Software
  • Developer · Member since 2024 · 75 posts · 25 votes
    16h

    Eric, one check that helps sort "expense problem" from "financing problem": run the property with no mortgage at all first.

    Your percentage lines add to 31% of rent, so about $992 a month on $3,200, before taxes, insurance and any landlord-paid utilities. Once those fixed bills are in, a lot of small multifamily lands somewhere around 45-50% of rent in operating expenses, which is roughly what the 50% rule assumes. So your reserves don't look inflated to me. Just make sure taxes, insurance and utilities aren't also sitting inside one of the percentage lines, because that's the usual double-count.

    Then I'd look at five numbers instead of one cash flow figure:

    1. NOI (rent minus operating expenses, no debt). If NOI is healthy but cash flow is negative, the expenses aren't the issue, the loan size is.

    2. Cap rate (NOI / price). If it's below your 7.5% rate, the debt costs more than the property earns and leverage works against you.

    3. DSCR (NOI / annual debt payments). Under 1.0 means the rent can't carry the loan.

    4. Cash-on-cash on the cash you actually leave in after the refi.

    5. The break-even loan amount: work backward from your $300-500 target and see how far it sits from what the refi would give you.

    For BRRRR that fifth number is the useful one, because it tells you what the after-repair value has to be before you ever make an offer.

    Not investment advice, just how I'd structure the sheet.

Join the conversationCreate a free account to reply, vote on answers and follow this thread.