New: Personal Budget with debt payoff & refi calculator · $49 Excel template.New: Personal Budget · $49Shop now →
Quigley Capitalby Patrick Quigley
Shop models
Home  /  Free templates  /  Max Offer Calculator

Free Excel template

Free Max Offer Calculator

A max offer calculator works backwards from the after repair value (ARV) to the most you can pay for a flip. In the sample, a $462,113 ARV and $25,135 of repairs give a max offer of $338,710, with a 70% rule check.

Download free (.xlsx)

No sign-up, no email. Excel for Windows, no macros.

Max Offer Calculator filled in with a sample flip

How to use it

  1. Type the after repair value (ARV) and your repair estimate in the light yellow cells.
  2. Check the flip assumptions (resale price, profit, months held, loan and costs) and your own margin. Doing the flip yourself? Set Your margin to 0%.
  3. Read your max offer. The cost waterfall shows how the ARV becomes your offer, next to the 70% rule.