Underwriting: When to Trust Numbers Over a Good Story

Every investor has heard the story. It’s the one about the charming bungalow with 'good bones' in an 'up-and-coming' neighborhood, a forgotten gem just waiting for a little TLC. This narrative is powerful, painting a picture of diamond-in-the-rough potential that’s easy to fall in love with. The problem is, you can’t deposit a story in the bank.

In fix-and-flip real estate, the narrative can get you to the front door, but only the numbers should convince you to walk through it as the owner. The emotional pull of a property’s story is the most common trap for new and experienced investors alike. Professional flippers build careers not by falling for good stories, but by executing on good deals. The difference is defined by one thing: ruthless, dispassionate underwriting.

This guide cuts through the noise. We'll break down the process of quantitative deal analysis, showing you how to separate a property's seductive story from its financial reality. Mastering this skill is the line between a profitable business and a costly hobby.

What is the difference between a property's story and its numbers?

A property's story is its qualitative, emotional appeal, while its numbers represent the quantitative, financial facts. The story includes phrases like 'great curb appeal,' 'historic character,' or 'perfect for a young family,' which are subjective and don't have a fixed value.

The numbers, on the other hand, are the objective data that form the basis of your deal analysis. These include the purchase price, the itemized cost of repairs, projected holding costs, financing expenses, closing costs, and the After Repair Value (ARV) supported by comparable sales. A story might suggest a home is in a 'hot' market like Tampa, FL, but only the numbers can tell you if the entry price and rehab costs leave any room for profit in that specific market.

How do you perform initial deal analysis?

You perform initial deal analysis by using a quick, high-level formula to filter out deals that clearly don't work. The most common first-pass filter for flippers is the 70% Rule, which provides an immediate go/no-go signal.

This rule states that you should pay no more than 70% of a property's After Repair Value (ARV), minus the cost of repairs. For example, if a home’s ARV is $400,000 and it needs $50,000 in repairs, the 70% Rule suggests a maximum offer price of $230,000 ($400,000 * 0.70 - $50,000). This isn't a substitute for full underwriting, but it's an essential tool for rapidly screening the dozens of potential deals you need to look at to find one good one. You can run these initial numbers quickly using a 70% Rule calculator.

Where do you find the After Repair Value (ARV)?

The After Repair Value (ARV) is determined by analyzing recent, comparable sales, known as 'comps.' These are properties similar in size, age, condition, and location that have sold—not just listed—within the last 90 to 180 days. To establish a reliable ARV, you need to find at least three to five strong comps. Look for homes within a half-mile radius with a similar square footage (within 10-15%), bedroom/bathroom count, and lot size. Adjust your ARV downward for inferior features (e.g., your subject property backs to a busy road while the comps do not) and upward for superior ones. A powerful deal analyzer can help you pull and evaluate comps efficiently.

What initial numbers should you screen for?

Beyond the 70% rule, the three critical numbers for an initial screen are the purchase price, a realistic rehab estimate, and a conservative ARV. These three variables form the core of your potential profit. If the gap between the purchase price plus rehab and the ARV is too thin, the deal likely isn't worth pursuing. At this stage, you don't need a line-item budget, but you need to know the difference between a $30,000 cosmetic renovation and a $90,000 gut job. A property listed at $300,000 needing $80,000 in work with a solid $425,000 ARV might be a deal; a property at the same price needing the same work with a shaky $400,000 ARV is a pass.

What costs must be included in underwriting?

Comprehensive underwriting must include every single expense associated with the project, which can be categorized into hard costs, soft costs, and selling costs. Forgetting even one category can erase your entire profit margin. These are the non-negotiable line items that separate a back-of-the-napkin guess from a professional financial projection.

What are the primary hard costs?

Primary hard costs are the tangible, direct expenses of acquiring and renovating the property. This starts with the purchase price of the asset itself, followed by acquisition closing costs, which typically run 2-5% of the purchase price and include title insurance, escrow fees, and attorney fees. The largest variable hard cost is the rehab budget. This must be a detailed scope of work with itemized costs for materials and labor, from foundation repair and roofing down to paint and fixtures. Always add a 15-20% contingency to this budget to cover unforeseen problems discovered after demolition.

How do you calculate soft costs?

Soft costs, also known as holding costs, are calculated based on the project's timeline and the cost of capital. These are the time-sensitive expenses you pay every month you own the property. Key soft costs include loan interest (from hard money or private lenders), property taxes, homeowner's insurance, and basic utilities like electricity and water. To calculate them, estimate your project timeline in months (e.g., 2 months for rehab, 1 month for staging/listing, 3 months to sell = 6 months total). Then, multiply the monthly cost of each item by the number of months in your timeline. A six-month project with $2,000/month in soft costs adds $12,000 to your total expenses.

How do you model a real-world deal?

You model a real-world deal by creating a detailed spreadsheet or using a deal analysis tool to project every cost and revenue source from acquisition to disposition. This moves beyond estimates to a line-by-line financial plan. Assumptions must be clearly stated and conservative.

Let's model a hypothetical flip in Phoenix, AZ. You find a 1,800 sq. ft. single-family home that's structurally sound but cosmetically dated. Comps of renovated homes in the neighborhood solidly support a $500,000 ARV.

Assumptions:

* Financing: 90% of purchase and 100% of rehab via a hard money loan at 12% annual interest.

* Project Timeline: 6 months (2 months rehab, 4 months listing/selling).

* Rehab Contingency: 15%.

* Selling Costs: 6% total (commissions, closing costs).

Here is how the numbers break down:

This detailed model shows a healthy potential profit, but it also highlights how quickly costs can add up. Without this level of detail, it's impossible to know if the deal is truly viable.

When does a compelling story become dangerous?

A compelling story becomes dangerous the moment it causes you to ignore, bend, or override what the numbers are telling you. This happens when investors get attached to a property and start making emotional decisions. Common danger zones include overpaying due to a bidding war because you 'fell in love with the neighborhood,' underestimating repairs because the house 'feels solid,' or banking on appreciation in a 'hot' area instead of creating value through forced equity.

The story of a neighborhood 'about to pop' is speculation, not investment. The story that a house 'just needs paint' can hide thousands in termite or foundation damage. The numbers are your defense against these expensive narratives.

How do you stress-test your underwriting?

You stress-test your underwriting by running 'what if' scenarios to see how your profit is affected by negative events. This is a critical step that prepares you for reality, as no project ever goes exactly to plan. Change the key variables in your financial model: What happens to your profit if the rehab budget goes 20% over? What if the project takes nine months to sell instead of six, adding three more months of holding costs? What if the market softens and your ARV comes in 5% lower than projected?

Using our Phoenix deal from before, a 5% lower ARV ($475,000) would reduce the profit from $58,100 to $33,100. If it also takes three extra months to sell, the additional holding costs ($13,350) would drop the profit to just $19,750. Running these scenarios reveals the deal's risk profile. If a single adverse event wipes out all profit, the deal is too risky.

How do market conditions influence your deal analysis?

Market conditions are the backdrop for every deal and must heavily influence the assumptions in your underwriting. The same property can be a great deal in one market and a terrible one in another. Your analysis must adapt to local realities, which you can research on dedicated markets pages.

In a rapidly appreciating seller's market, like we saw in places like Phoenix, AZ in recent years, you could be more confident in your ARV but had to be hyper-aggressive on acquisition to compete. In a cooling or buyer's market, you must be far more conservative with your ARV projections and expect longer holding times. Your profit margin needs to be wider to compensate for the increased risk of price drops and extended days on market. Your underwriting for a property in a stable, slow-moving market will look very different from one in a volatile, high-growth area.

The Bottom Line

A good story might be what catches your eye, but it should never be what signs your check. Successful real estate flipping is a business of financial discipline, not architectural romance. Every decision, from the initial offer to the final finishes, must be validated by a conservative, numbers-driven underwriting process. By learning to stress-test your assumptions, account for every cost, and let the data make the final call, you move from an amateur hoping for the best to a professional engineering a profit.

Frequently asked questions

What is the biggest mistake new flippers make in deal analysis?

The biggest mistake is underestimating rehab costs and the project timeline. New investors often look at a property with optimism, failing to budget for the hidden problems that inevitably arise or the true time it takes for contractors, inspections, and marketing. Always add a 15-20% contingency to your rehab budget and be realistic about holding times.

How accurate does my initial ARV need to be?

Your initial ARV should be as accurate as possible, but it is always an estimate. Base it strictly on recently sold, highly comparable properties—not on active listings or what you 'hope' to get. It's best practice to establish a conservative price range and use the lower end for your primary underwriting to create a buffer.

Can I trust a contractor's estimate for my underwriting?

A contractor's estimate is a critical starting point, but it should not be taken as the final number. Always get multiple bids to ensure the price is fair. More importantly, you must include your own contingency fund of 15-20% on top of the contractor's bid to cover change orders and unforeseen issues they couldn't have predicted.

What is a good profit margin for a flip?

This varies significantly by market, deal size, and risk level, but most professional flippers target a net profit of at least 15% of the total project cost. On smaller, quicker cosmetic flips, some may accept a 10% margin, while on larger, riskier projects, they may require a margin of 25% or more to justify the investment.

How does financing affect my underwriting?

Financing dramatically affects underwriting as it is one of the largest expenses. The cost of capital—whether it's a 12% interest hard money loan or cash from your bank account (which has an opportunity cost)—is a major line item. The terms of your loan will directly impact your holding costs, down payment requirement, and ultimately, your net profit and return on investment.