The Investor S Guide to Building a Flip Pro Forma That Works

A flip pro forma is a financial projection that estimates the profitability of a real estate investment deal by accounting for acquisition cost, renovation expenses, holding costs, and projected sale price. For real estate investors, building an accurate pro forma is the difference between a deal that sounds good and a deal you can actually execute profitably. This guide walks you through creating a pro forma that captures reality, not optimism.

TL;DR

• A flip pro forma projects all costs (purchase, rehab, holding, and sale) against estimated exit price to calculate profit and return on investment (ROI).

• The most common mistakes are underestimating renovation costs, ignoring holding costs, and overestimating the after-repair value (ARV), all of which compress margins.

• Use comparable sales, not wishful thinking, to set ARV; build contingency buffers into every cost category; and stress-test your numbers under slower market conditions.

The Core Components of a Flip Pro Forma

A working flip pro forma has five main expense categories. Understanding each one and how to populate it with defensible numbers is the foundation of deal analysis.

Purchase Price and Closing Costs. Start with the offer price you are negotiating or have agreed to. Add closing costs, which typically include title insurance, appraisal, inspection, recording fees, and lender fees. If you are using a hard money lender or private money, closing costs can range from 2 to 5 percent of the purchase price depending on your lender and deal structure. Do not skip these; they are real money leaving your account.

Acquisition Costs. Beyond closing costs, you may pay for a professional inspection, appraisal, survey, or title search before purchase. Some of these are rolled into closing, but some are paid out of pocket upfront. Estimate conservatively and include any legal fees if an attorney reviews the purchase agreement.

Renovation Costs (Hard Costs). This is where most flippers go wrong. Divide the property into systems: structure and foundation, roof, exterior (siding, windows, doors), kitchen, bathrooms, flooring, walls and paint, electrical, plumbing, HVAC, and any special items (new fence, deck, driveway). For each category, get at least two bids from licensed contractors. Do not rely on estimates from contractors you have never worked with or who refuse to walk the property in person. Budget for the full scope: labor, materials, permits, and inspections. Permit costs vary by municipality; contact your local building department or a general contractor familiar with your area to understand the typical cost.

Holding Costs. These are the ongoing expenses while the property is being renovated and held for sale. Include property taxes (pro-rated monthly if known, or estimated from the county assessor), insurance (landlord or builder's risk, depending on occupancy status), utilities (electric, gas, water, sewer if you are paying them), HOA fees if applicable, and any maintenance or security during the flip. Many new investors forget holding costs or radically underestimate the timeline, which crushes profit. A typical flip might hold 3 to 6 months; a slower market or unexpected rehab delays can push it to 9 to 12 months. Build in a buffer.

Soft Costs and Financing Costs. Soft costs include project management, permits and inspections, architect or designer fees, contractor general liability insurance, and contingency (usually 10 percent of hard costs, though some projects warrant 15 to 20 percent). If you are borrowing, include interest on the construction loan, origination fees, and any bridge financing costs. Hard money lenders typically charge 1 to 3 points upfront and 10 to 18 percent annual interest on the balance drawn.

Selling Costs. You will pay real estate commission (typically 5 to 6 percent of sale price in most markets), closing costs on the sale side (title insurance, escrow, transfer tax if applicable, HOA transfer fees), and any seller concessions or repairs required by the buyer's lender or inspection. Some markets have transfer taxes; confirm with your county or a local closing attorney what applies to your state and property type.

Estimating After-Repair Value (ARV)

ARV is the estimated market value of the property after renovation is complete. This is where emotion creeps in and destroys deals. ARV is not what you wish the house is worth; it is what comparable properties actually sold for in the past 30 to 90 days.

Pull three to five comparable sales of similar properties in the same neighborhood with similar square footage, bedroom/bathroom count, lot size, and condition. Use your local MLS (or a service like Zillow, Redfin, or Realtor.com for reference), but verify sales prices through county public records or a real estate agent with MLS access. Apply adjustments: if your property has a nicer kitchen than a comp, value that difference based on typical cost and market recovery (usually 50 to 70 percent of hard cost). Be conservative. If there is any doubt, use the lower comparable.

A common trap: using list prices or pending sales instead of closed sales. The market tells the truth only through what actually sold. After-repair value should also assume the property is in "like-new" or "good move-in ready" condition. If you are targeting the entry-level market, do not use luxury comps; if you are in a neighborhood with a ceiling price, do not assume you can break it with a nicer kitchen.

Building the Pro Forma Template

Create a simple spreadsheet with two columns: line items and dollar amounts. Organize it in this order:

Uses of Funds (where money goes):

• Purchase Price

• Closing Costs on Purchase

• Renovation Hard Costs (by system)

• Permits and Inspections

• Project Management

• Contingency (10-20 percent of hard costs)

• Property Taxes (monthly rate x estimated holding months)

• Insurance (monthly rate x estimated holding months)

• Utilities

• Loan Interest or Hard Money Costs

• Sale Commissions and Closing Costs

• Total Uses of Funds

Sources of Funds (where money comes from):

• Cash Invested (your down payment and any cash into rehab)

• Loan Proceeds (if financing)

• Sale Price (projected closing amount)

• Total Sources of Funds

Profit and Return:

• Gross Profit (Sale Price minus Total Uses of Funds)

• Cash-on-Cash Return (Gross Profit divided by Cash Invested)

• Profit Margin (Gross Profit divided by Sale Price)

Many investors also calculate a "minimum acceptable return" and compare it to the deal's projected return. A common rule is targeting at least 15 to 20 percent net profit margin or a cash-on-cash return of 25 to 50 percent, depending on your risk tolerance and local market conditions. This varies widely, so set your own threshold and stick to it.

Stress-Testing Your Pro Forma

Run your numbers under three scenarios: base case, pessimistic case, and optimistic case. The base case uses your best estimates. The pessimistic case assumes ARV is 10 percent lower, renovation costs run 15 percent over budget, and holding time extends two months longer. The optimistic case does the reverse. If profit disappears or turns negative under the pessimistic scenario, you do not have enough margin for error. Real deals survive pessimistic scenarios.

Also test sensitivity: what happens if you hold the property three months longer? What if hard costs spike 20 percent? If a single variable can eliminate your profit, the deal is too fragile to execute.

Common Pro Forma Mistakes

Underestimating Renovation Costs. Contractors underestimate, hidden issues emerge (rotten framing, outdated wiring, bad plumbing), and scope creep happens. Get bids in writing and add a 15 percent contingency minimum.

Ignoring or Minimizing Holding Costs. Flips almost always take longer than planned. Do not estimate three months if historical data in your market shows six months is typical. The difference directly impacts profit.

Overestimating ARV. This is the most common error. Use sold prices only, apply conservative adjustments, and if you are uncertain, use the lower comp. A 10 percent overestimate in ARV can wipe out 30 percent of projected profit.

Forgetting Sale Costs. Real estate commission, title insurance, transfer taxes, and lender payoff fees add up to 6 to 10 percent of sale price. They are not optional.

Ignoring Financing Costs. If you are using a hard money or private lender, those interest costs are real and material. Factor them into every deal.

When to Walk Away

A pro forma tells you when a deal does not work. If the math shows a profit of only 5 percent or if contingency is zero, walk. Do not rely on the market improving or on your ability to cut costs mid-project. Build margin, hit your numbers, and repeat. A disciplined pro forma process keeps you from buying deals that feel right but perform poorly.

Frequently Asked Questions

How detailed should renovation cost line items be?

Break down costs by building system (roof, electrical, plumbing, kitchen, bathrooms, flooring, etc.) and include labor and materials separately if possible. The more detail you capture during bidding, the fewer surprises appear during execution. At minimum, separate hard costs (construction) from soft costs (permits, management, contingency). Vague categories like "miscellaneous rehab" hide errors and make it hard to track actuals against budget.

Should I include a profit markup on my own labor or project management?

If you are actively managing the project yourself, many investors do add a small project management fee (typically 3 to 10 percent of hard costs) to account for your time. However, be conservative and consistent. If you include it, acknowledge that this money comes from profit and is compensation for work, not additional profit. Some investors prefer to keep pro formas clean (costs only) and allow their target ROI to cover their labor implicitly.

What holding period should I assume in a pro forma?

Use your market's historical average. In a fast market, four to five months might be realistic; in a slower market, six to nine months is safer. Ask local agents how long similar properties take to sell after listing. Add one month for renovation delay buffer. If your market data is unavailable, assume a minimum of six months. It is better to over-estimate holding time and close faster than the reverse.

How should I adjust comparable sales for differences in condition or features?

Use cost-based adjustments for major systems (if a comp sold without a new roof and yours has one, subtract the cost of a new roof from the comp's price or vice versa). For cosmetic differences (paint, flooring), research typical cost per square foot and apply modestly, usually capturing 40 to 60 percent of the hard cost as market value. When in doubt, be conservative. If adjustments feel large, use a different comparable instead. Many flippers use a "dollars per square foot" approach: calculate price per square foot for each comparable, average them, and apply the average to your property's square footage as ARV, adjusting only for major condition gaps.

Sources

• U.S. Census Bureau, QuickFacts, housing, ownership, and local market context.

• U.S. Department of Housing and Urban Development, official guidance on buying, financing, and distressed property.

• GoliathData real-estate records, distressed-property and market data compiled from public records.