A Sample Flip Pro Forma and How to Stress-Test Your Margins
An inside look at how pros push numbers until they break.
Tennessee, Goliath Teammate
Key Takeaways
- A flip pro forma is a financial projection of a flip from purchase to resale: revenue, costs, timeline and projected return.
- In the sample deal ($160,000 purchase, $40,000 rehab, $270,000 ARV, 4-month timeline), total project cost is $235,233 and projected profit is $34,767: a 12.9% margin on ARV but only a 14.8% return on cost, which falls short of the 20% minimum return on total cost this guide recommends.
- Stacking four common problems (a 10% rehab overage, a 5% lower ARV, 3 extra weeks on market and a $7,000 buyer credit) cuts that profit to about $14,000, or 5.2% of ARV.
- A safe flip targets at least a 20% return on total cost, a $25,000 net profit buffer and a 10% ARV margin.
- Experienced flippers run three pro formas per deal (base case, worst case, best case) and buy only when the worst case still makes money.
There’s a saying among seasoned flippers: “You don’t lose money in the sale, you lose it in the numbers.”
And they’re right.
You can buy in a hot neighborhood, nail the rehab, and still walk away with a fraction of the profit you expected… because the numbers didn’t work in your favor from the start.
That’s why a solid flip pro forma, and the ability to stress-test your margins before you close, isn’t optional. A pro forma is the foundation of every profitable flip.
In this guide, we’ll walk you through:
- What a real flip pro forma should look like (with line items most newbies forget)
- How to test your margins against real-world volatility
- The critical stress points that separate flops from winners
- Tools and formulas to run the numbers like a lender
Let’s start with the foundation.
What Is a Flip Pro Forma?
A pro forma is a financial projection. In flipping, a pro forma is a model of how your project should perform, from purchase to resale. A flip pro forma includes revenue, costs, timelines, and projected returns.
Think of the pro forma as your pre-game strategy. If you don't know your margins before you demo a wall, you're flying blind.
What Does a Sample Flip Pro Forma Look Like?
A sample flip pro forma groups every cost into acquisition, rehab and carrying, and disposition, then subtracts the total from the ARV. Let’s break down a sample deal, assuming the following baseline:
- Purchase Price: $160,000
- Rehab Budget: $40,000
- ARV (After Repair Value): $270,000
- Timeline: 4 months
Pro forma section | Total |
|---|---|
Acquisition (purchase, buyer closing costs, title, escrow, inspections) | $166,000 |
Rehab and holding (rehab, permits, insurance, utilities, taxes, hard money interest) | $49,033 |
Disposition (6% agent commission, seller closing costs, staging and cleaning) | $20,200 |
Total project cost | $235,233 |
ARV | $270,000 |
Projected profit | $34,767 |
Here’s how the basic flip pro forma might look line by line:
Acquisition
- Purchase Price: $160,000
- Closing Costs (Buyer Side): $4,000
- Title, Escrow, Inspections: $2,000
- Total Acquisition Cost: $166,000
Rehab & Carrying Costs
- Rehab Budget: $40,000
- Permit Fees: $1,500
- Insurance (4 months): $800
- Utilities (Electric/Water/Gas): $600
- Property Taxes (4 months): $800
- Loan Interest (Hard Money, 10%): $5,333
- Total Holding Costs: $49,033
Disposition Costs
- Agent Commission (6% of $270K): $16,200
- Closing Costs (Seller Side): $3,000
- Staging & Cleaning: $1,000
- Total Selling Costs: $20,200
Total Project Cost
- Acquisition: $166,000
- Holding: $49,033
- Disposition: $20,200
- Total Cost: $235,233
Projected Net Profit
- ARV: $270,000
- Minus Total Cost: $235,233
- Projected Profit: $34,767
That’s a 12.9% margin on the ARV, or about a 14.8% return on cost ($34,767 divided by $235,233).
For a national reference point, ATTOM’s 2025 Year-End U.S. Home Flipping Report (March 2026) put the typical flip’s gross profit at $65,981, a 25.5% return on the purchase price. ATTOM’s gross figure excludes rehab and other expenses, which is exactly the gap a full pro forma fills.
This sample falls short of the rule. It clears the $25,000 net profit buffer and the 10% ARV margin, but its 14.8% return on cost misses the 20% minimum, so as modeled it is not a passing deal. Spotting that before you close is exactly what a pro forma is for.
Sounds good? Not yet. Now let’s stress test it.
What Could Go Wrong When You Stress-Test a Flip?
Stress-testing a flip means re-running the pro forma under realistic problems. A $35K profit looks solid on paper until the real world hits.
Stress scenario | What changes | Profit after |
|---|---|---|
Rehab runs 10% over budget | +$4,000 in costs plus extra holding time | ~$28,000 |
ARV falls 5% to $256,500 | Commission drops slightly, gross revenue drops more | ~$21,000 |
3 extra weeks on market | Carrying costs rise from $49K to ~$51K | another ~$2K lower |
Buyer negotiates a $7K credit | Comes directly out of profit | ~$14K (5.2% of ARV) |
What If Rehab Runs Over Budget?
Even a 10% overage on your $40K rehab means:
+$4,000 in extra costs
Plus extended holding time = higher interest, taxes, and insurance
Profit drops to ~$28,000
What if ARV Falls by 5%?
If the resale market softens and your ARV drops to $256,500:
Agent commission drops slightly
But so does gross revenue
Now your net profit is ~$21,000
What If You Sit on the Market for 3 Extra Weeks?
Add 3 weeks to your holding time:
Loan interest rises
Taxes, insurance, and utilities increase
Carrying costs go from $49K to ~$51K
Profit could drop another ~$2K
What if the Buyer Negotiates a $7K Credit?
Between inspections and lender requirements, a $7,000 price reduction or credit is common:
That comes directly out of your profit
You’re now looking at ~$14K profit, or a 5.2% return on ARV
That’s not great.
What Profit Thresholds Should a Flip Pro Forma Hit?
A flip pro forma should hit three thresholds before you ever close. Aim for at least:
- Minimum 20% return on total cost
- Minimum $25,000 net profit buffer
- Minimum 10% ARV margin
The sample deal above meets two of these three thresholds and misses the 20% return on total cost.
Why?
Because every flip gets hit by unexpected costs, slower markets, flaky contractors, or buyer demands. And if your margin can’t absorb a few punches, it’s not a deal.
Which 10 Line Items Do New Flippers Forget?
New flippers forget 10 line items most often. Here’s where rookies lose money fast, by forgetting these key costs in their pro forma:
- Permit fees
- Insurance (especially during vacancy)
- Staging costs
- Final cleaning or junk haul-off
- Post-repair pest control
- Seller-paid credits
- HOA transfer fees or dues
- Transfer taxes
- Final utility shut-off overlap
- Price adjustments after buyer inspection
Any one of these line items can knock a few grand off your margin. Combined, they’re often fatal.
How Do You Build a “What If” Margin Test?
A “what if” margin test is a copy of your pro forma with conservative scenarios plugged in. Stress testing means plugging in conservative scenarios.
Here’s how to do it:
- Build your standard pro forma
- Duplicate the spreadsheet and rename it “Stress Test”
- Apply the following pressure variables:
- Rehab +15%
- ARV –5%
- Holding time +45 days
- Buyer requests $7,500 credit
- See if your profit is still >$20K
- If not, renegotiate or walk
This quick test simulates a real-world imperfect outcome. If you’re only profitable when everything goes perfectly, you’re not ready to flip.
How Do Lenders Underwrite Flip Deals (And Why Should You Too)?
Hard money lenders are not your friends, but hard money lenders are great at underwriting risk.
Here’s what hard money lenders evaluate before approving your deal:
- Loan-to-ARV (Max 70%)
- Loan-to-Cost (Max 90%)
- Exit strategy viability
- Borrower experience
- Timeline feasibility
- Market comp reliability
You should underwrite yourself the same way, and only fund deals where you’d lend to yourself.
How Do Taxes Affect Your Flip Profit?
Taxes come out of flip profit too. That $35K profit? Uncle Sam wants his cut.
If you flip in an LLC or as a sole prop, expect 15%–37% ordinary income tax
After taxes, your $35K could be closer to $24K–$28K
Meaning your post-tax margin may be 9% or less
Build that into your stress test, especially if you’re flipping more than one house a year.
What Tools Can You Use to Build Pro Formas?
You don’t need expensive software to run your numbers. Start with these:
Google Sheets / Excel – Customizable, easy to duplicate for stress tests
Flipster / Rehab Valuator – More automated, but less flexible
PropStream Comp Reports – Plug ARV into your spreadsheet
Your phone’s calculator + Notion – For quick deal vetting on the go
Make sure every deal you evaluate goes through a standardized template, not napkin math.
What Do Experienced Flippers Do Differently?
Most new flippers run one pro forma per deal.
Experienced flippers run three:
- Base Case – Their best estimate
- Worst Case – Stress test with lower ARV, longer hold, higher rehab
- Best Case – For upside scenarios (rare)
Then experienced flippers only proceed if the worst-case scenario is still profitable.
They don’t just ask, “Can I make money?” They ask: “If everything goes wrong, will I lose money?”
That’s how pros stay in the game.
What Margin Guardrails Should You Check Before an Offer?
Before you ever make an offer, run this six-question checklist:
- Do I have at least 10% ARV spread after all costs?
- Will I clear $25K+ net profit after closing costs and credits?
- If I go 6 weeks over schedule and 15% over rehab, will I still profit?
- Have I included every fee, tax, and holding cost in my model?
- Have I tested my numbers at multiple resale price points?
- Have I budgeted for buyer demands after inspection?
If you can answer yes to all six, you’re in a strong position.
If not, adjust your offer or walk away.
Summary: Flipping Is Math First, Hammer Second
The best flippers are spreadsheet warriors before they’re drywall warriors.
They know the real profit happens before they ever buy the house.
A proper pro forma, combined with ruthless stress testing, is what makes the difference between a profitable project… and a painful lesson.
So don’t just trust your gut. Trust your numbers.
Run the math. Test the worst-case. And only then, start the flip.