House Flip Budget & Profit Tracker Spreadsheet

House flipping profit margins have dropped to their lowest level since 2007. The average gross ROI fell to 25.5% in 2025, with typical gross profit of roughly $66,000 per flip — down from ROIs exceeding 50% at the peaks of 2016 and 2021. The median purchase price for flipped properties hit $259,700, the highest on record, while renovation costs and carrying expenses typically consume 20–33% of the after-repair value.

The margin compression is real, and it changes the game fundamentally. In a high-margin market, imprecise budgeting still produces profit. In a tight-margin market, a single underestimated cost line — an unexpected foundation issue, two extra months of carrying costs, a market shift during renovation — can turn a profitable flip into a loss. According to ATTOM Data, roughly one in five flips fails to achieve a profitable sale.

This spreadsheet exists to prevent that outcome. It tracks every cost category across the full lifecycle of a flip — acquisition, renovation, holding, and selling — so you know your projected profit before you buy and can monitor actual costs against budget throughout the project.

Disclaimer: This tool is provided for informational and educational purposes only. It does not constitute financial or investment advice. House flipping carries significant risk, including potential loss of capital. Consult a qualified financial advisor or real estate professional before making investment decisions. SpreadsheetTemplates.info is not responsible for decisions made based on the information provided.

Why Most Flip Budgets Fail#

The flippers who lose money almost always share the same failure pattern: they accurately estimated the purchase price and renovation costs but missed the secondary expenses that erode margin from every direction.

Holding Costs Are the Silent Killer#

Every month you own the property before selling, you are paying for it — hard money or bridge loan interest (typically 10–14% annualised in 2026), property taxes (prorated monthly), insurance (vacant property policies cost more than standard homeowner policies), utilities (required during renovation and showing), and security or lawn maintenance for vacant properties.

On a $250,000 acquisition financed with a hard money loan at 12%, monthly interest alone is $2,500. Add $500 for taxes, insurance, and utilities, and you are spending $3,000/month just to hold the property. A two-month delay — an optimistic underestimate for most renovation projects — costs $6,000. The average flip takes 166 days from purchase to resale. Budget accordingly.

Renovation Contingencies Are Not Optional#

Experienced flippers budget a 15–20% contingency on top of their renovation estimate. Beginners often skip this, then discover knob-and-tube wiring behind the walls, termite damage in the framing, or a foundation crack that the inspection missed. In 2026, with tariffs increasing the cost of imported building materials and labour costs still elevated, renovation budgets face upward pressure from every direction.

Selling Costs Are Larger Than You Think#

Agent commissions, seller closing costs, transfer taxes, staging, and professional photography typically consume 7–10% of the sale price. On a $350,000 sale, that is $24,500–$35,000. Many new flippers budget only for the agent commission and are surprised by closing costs, title insurance, and transfer taxes that vary significantly by state and municipality.

What the Spreadsheet Tracks#

The flip budget tracker is organised into four cost sections that mirror the lifecycle of a flip project, plus a profit summary dashboard.

Section 1: Acquisition Costs#

This section captures every cost associated with purchasing the property. You enter the purchase price, buyer closing costs (typically 2–3% for cash purchases, 3–5% for financed), inspection and due diligence costs, appraisal fee (if financed), title search and insurance, recording fees, any points or origination fees on the financing, and initial property securitisation costs (lock changes, boarding, etc.). The total acquisition cost is the true denominator for your ROI calculation.

Section 2: Renovation Budget#

The renovation section breaks costs into standard categories, each with a budgeted amount and actual spend column. Categories include kitchen (cabinets, countertops, appliances, plumbing, electrical), bathrooms (fixtures, tile, vanity, plumbing), roof and exterior (roofing, siding, gutters, paint, landscaping), flooring (hardwood, tile, carpet, LVP throughout), electrical (panel upgrade, rewiring, fixtures), plumbing (pipe replacement, water heater, supply lines), HVAC (furnace, AC, ductwork), structural (foundation, framing, load-bearing modifications), painting and finishes (interior paint, trim, hardware), permits and fees, and a contingency line (default 15% of total renovation budget).

Each line tracks budgeted vs actual cost, with a running variance column showing where you are over or under budget in real time. The total renovation variance is the earliest warning sign that your flip is going off-plan.

Section 3: Holding Costs#

Holding costs are calculated monthly and multiplied by your projected hold period. Line items include loan interest (monthly payment or interest-only amount), property taxes (prorated), insurance (vacant property or builder’s risk policy), utilities (electricity, water, gas), lawn care and maintenance, security (if needed for vacant property), and any HOA or association fees.

A critical feature: the spreadsheet models holding costs at your projected timeline and at “projected + 2 months” to show the profit impact of a delay. This is the number that kills flips — if a two-month delay turns your $25,000 profit into a $5,000 profit, the deal has insufficient margin to proceed safely.

Section 4: Selling Costs#

Selling costs are estimated based on the projected sale price (ARV). Line items include listing agent commission (typically 2.5–3% of sale price), buyer’s agent commission (typically 2.5–3%), seller closing costs (1–2%), transfer taxes (varies by jurisdiction), title insurance, staging ($2,000–$5,000 for a typical flip), professional photography and marketing ($500–$1,500), and any concessions or credits to the buyer.

Profit Summary Dashboard#

The dashboard at the top of the spreadsheet shows the projected ARV (after-repair value), total project cost (acquisition + renovation + holding + selling), projected gross profit (ARV minus total project cost), projected ROI (gross profit ÷ total cash invested × 100), and profit per month (gross profit ÷ hold period in months — a useful metric for comparing the efficiency of different projects).

The dashboard updates in real time as you enter actual costs, so you always know where you stand relative to your original projections.

How to Use the Spreadsheet#

Step 1: Run the 70% Rule before entering anything. The 70% Rule is the standard screening formula: Maximum Allowable Offer (MAO) = ARV × 70% – Estimated Renovation Costs. If the property is listed above your MAO, negotiate or walk away. In 2026’s tighter margin environment, some investors adjust to 65% in slow markets or 75% in competitive ones. This spreadsheet does not replace that initial screen — it refines it with precise cost data.

Step 2: Enter acquisition details from your purchase contract. Use actual contract figures, not estimates. Include all closing costs from the closing disclosure or settlement statement.

Step 3: Build the renovation budget with contractor bids. Get at least two bids for every major category. Enter the chosen bid in the budget column. Add the 15–20% contingency. If you cannot get bids during due diligence (before closing), use per-square-foot estimates: $15–$30/sqft for cosmetic renovations, $40–$75+/sqft for structural or major system work.

Step 4: Estimate holding costs based on your financing terms and projected timeline. Be honest about the timeline. If your contractor says six months, budget for eight. The national average flip takes 166 days — and that includes experienced investors who have refined their processes over dozens of projects.

Step 5: Calculate selling costs based on your ARV estimate. Verify the ARV with comparable sales data (recent sales of similar homes in the same neighbourhood within the past 3–6 months). Overestimating ARV is the other common flip-killer — the spreadsheet shows your profit at three ARV scenarios (conservative, expected, and optimistic) so you can assess the risk.

Step 6: Review the profit dashboard. If the projected ROI at your conservative ARV estimate is below 15%, the deal may not have sufficient margin to absorb cost overruns. If the “projected + 2 months” scenario shows a loss, the deal is too time-sensitive to proceed safely.

Download: House Flip Budget & Profit Tracker — Excel (.xlsx)

The 2026 Flipping Market#

Several factors are shaping the economics of house flipping this year.

Tighter margins are the new normal. With average ROIs at 25.5% gross (and significantly lower net after carrying and selling costs), the “easy money” era of flipping is definitively over. Successful flippers in 2026 are those who control costs meticulously, execute renovations on tight timelines, and price their ARV conservatively.

Financing costs remain elevated. Hard money and bridge loan rates at 10–14% make every month of holding expensive. About 62% of flips are purchased with cash, which eliminates interest costs but ties up capital. For investors using leverage, the carrying cost clock is the single most important factor in profitability.

Tariffs are increasing material costs. The 25% tariff on imported building materials is flowing through to renovation budgets. Lumber, fixtures, appliances, and specialty items sourced internationally all face cost pressure. Budget 10–15% above 2024 material costs for the same scope of work.

Buyer expectations have risen. In a market where homes sit longer (buyers are rate-sensitive and more discerning than in 2021–2022), flippers must deliver finishes that meet current expectations: quartz or stone countertops, LVP or hardwood flooring, modern fixtures, and energy-efficient systems. Cutting corners on finishes to save budget often results in longer days on market, which increases holding costs and erodes margin from the other direction.

For a comprehensive overview of all real estate analysis tools, see our complete guide to real estate investment spreadsheet tools. If you are evaluating whether to flip or hold a property as a rental, our rental property ROI calculator models the buy-and-hold scenario for comparison.

Frequently Asked Questions#

What ROI should I target on a house flip in 2026?

Target a minimum 15–20% net ROI (after all costs including holding and selling) to provide adequate margin for unexpected expenses. At the national average gross ROI of 25.5%, net ROI after carrying and selling costs is typically 10–18%. Deals with projected net ROI below 10% have insufficient cushion — one cost overrun or market shift can eliminate the profit entirely.

How do I estimate renovation costs if I cannot get contractor bids before closing?

Use per-square-foot benchmarks as a starting point: $15–$30/sqft for cosmetic work (paint, flooring, fixtures, landscaping), $40–$75/sqft for moderate renovation (kitchen and bathroom remodels, systems updates), and $75–$120+/sqft for extensive work (structural changes, full gut renovations). Always add a 15–20% contingency. These are rough guides — actual costs vary by region, market conditions, and property condition.

Should I manage the renovation myself or hire a general contractor?

A general contractor (GC) typically adds 15–25% to the cost of subcontractor work but manages scheduling, permits, inspections, and quality control. Self-managing saves that markup but costs your time and requires construction knowledge. For your first few flips, a GC is almost always worth the cost — the mistakes you avoid and the time you save more than offset the fee. As you gain experience and build subcontractor relationships, self-management becomes more feasible.

What is the 70% Rule and should I follow it strictly?

The 70% Rule states: Maximum Allowable Offer = ARV × 70% – Renovation Costs. The 30% cushion covers holding costs, selling costs, and your profit margin. In 2026’s market, this rule remains a useful screening tool but should be adjusted for local conditions. In competitive markets with fast sales, 75% may work. In slow markets where homes sit for months, 65% provides necessary protection. The spreadsheet calculates your actual margin — use the 70% Rule for initial screening and the spreadsheet for the decision.

How long does a typical flip take?

The national average is approximately 166 days from purchase to resale. Cosmetic flips (paint, flooring, fixtures only) can be completed in 2–3 months. Moderate renovations (kitchen and bathroom remodels, systems updates) typically take 4–6 months. Extensive renovations (structural work, additions, full gut) can take 6–12 months. Always add a buffer — renovation timelines almost universally run longer than projected.

What are the most common cost overruns on flips?

The top five: (1) hidden structural or systems issues discovered during demolition (foundation problems, water damage, outdated electrical or plumbing), (2) permit delays and inspection failures requiring rework, (3) scope creep (adding work during renovation that was not in the original plan), (4) material cost increases between bid and purchase, and (5) extended holding period due to construction delays or slower-than-expected sale. The contingency line and the “projected + 2 months” holding cost scenario in the spreadsheet are designed to account for these.

Should I flip or hold as a rental?

This depends on your investment goals, the property’s cash flow potential, and the current market. Our rental property ROI calculator can model the buy-and-hold scenario for the same property. In general, flipping generates a lump-sum profit but requires ongoing deal sourcing. Buy-and-hold generates ongoing cash flow and long-term appreciation. Many experienced investors do both — flipping to generate capital and buying-and-holding to build wealth.