Free Excel templates
A free fix and flip and BRRRR calculator in Excel: one house, two strategies
Hard money on the purchase and the renovation, points, interest, holding, closing and selling costs, profit and return on cash, the 70% rule, then the same house refinanced and rented: four sheets, no macros.
Julian R. Sterling · from The Real Estate Development Manager
The file buys a distressed house for 220,000, renovates it for 60,000 and values it at 340,000 after repairs. As a flip with 90% hard money at 11% plus two points, it makes only 8,700 after six months, 17.6% on the 49,500 of cash put in. The 70% rule says the most to pay was 178,000; the price paid was 42,000 above it. As a BRRRR, the 75% refinance does not even repay the hard money: 57,600 stays in the deal and the rent does not cover the new mortgage.
Free online calculator, no sign-up: fix and flip calculator .
Free online calculator, no sign-up: brrrr calculator .
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
Fix_and_Flip_BRRRR_Calculator.xlsx (14 KB)
This form needs JavaScript. Without it: join the reader list here , then open the downloads page .
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used .
Want every model at once?
The Financial Model Library : all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling ).
Get the Library, $79 →
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
Four sheets. Inputs are blue cells on a pale blue fill on the Inputs sheet.
Read me What the file does and its conventions.
Inputs Purchase, renovation, ARV, closing costs, months, holding costs, hard money terms, selling costs, the rule-of-thumb share, refinance terms, rent and operating costs.
Flip The hard money loan, points, interest, holding, closing and selling costs, total cost, profit, return on cash, annualized return and the maximum offer.
BRRRR and Checks Cash in, hard money repaid, the refinance, cash returned and left in, rent, NOI, mortgage, cash flow and DSCR; then the checks: all OK.
What the worked case returns
Measure Value
Total project cost 331,300
Flip profit 8,700
Cash invested 49,500
Return on cash 17.6% (38.2% annualized)
Maximum offer by the 70% rule 178,000
Price paid above it 42,000
BRRRR refinance at 75% of ARV 255,000
BRRRR cash left in the deal 57,600
BRRRR annual cash flow -1,638
The 70% rule exists for exactly this case. Selling costs alone take 7% of the ARV and financing another 5%, so a purchase price that looks like a discount to the finished value leaves almost nothing once every cost is counted.
How to use it on your own deal
Enter purchase price, renovation budget and ARV on Inputs.
Enter your lender's terms and the months the works will take.
Read the profit and the maximum offer on Flip before making an offer.
For a hold, enter rent and refinance terms and read BRRRR.
Questions people ask about it
Is this template really free?
Yes. The file costs nothing: you enter an email address, the download opens at once, and you can leave the reader list in one click.
Does it use macros or circular references?
No macros and no circular reference.
What is the 70% rule?
A rule of thumb for flips: pay no more than 70% of the after-repair value, less the renovation cost. Here 70% of 340,000 less 60,000, or 178,000.
Can I use it for a real house?
Yes, by replacing the inputs. The house is fictional, and nothing here is investment advice.
Other free templates
LBO model Sources and uses to sponsor IRR, twelve sheets, every figure checked.
Real estate property model Rent roll, cash flow, debt and returns for one asset, empty and ready to fill.
Residual land valuation Development appraisal with the four downside tests and peak debt.
DCF with terminal value Perpetuity growth and exit multiple side by side, with the TV share of value.
Distribution waterfall model Return of capital, pref, catch-up and carry, three catch-up readings, European vs deal-by-deal.
Loan sizing: LTV, LTC, DSCR, debt yield The four lender tests at once, the binding one, and a rate shock.
Direct lending credit model Unitranche underwriting: coverage, leverage, sweep, base, downside and stress.
Data center financial model Turnkey, powered shell and powered land on one campus, levered returns and delay.
13-week cash flow model Liquidity on paper against usable liquidity, a springing covenant and six levers.
Small business acquisition model (SBA loan) SBA 7(a) loan sized in closed form, lender coverage against cash coverage, exit returns.
3-statement financial model Five-year forecast feeding a DCF and an LBO on one case, with a blank build.
Project finance model Solar and storage project, debt sculpted to a 1.35x DSCR, no circularity.
REIT valuation model FFO, AFFO, NAV and the implied cap rate for one REIT, plus an empty template.
Self-storage financial model Cohort rent roll, break-even occupancy, ten-year hold and the bid for one store.
Tax lien certificate yield calculator Bid, minimum charge and redemption month turned into a real annual yield.
Sale and leaseback model Nine buildings, the price split five ways, rent cover on the entity that signs.
PME calculator Kaplan-Schoar PME, PME+, Direct Alpha, IRR and TVPI on one fund's cash flows.
Working capital peg model Five peg definitions, the completion-date effect, locked box against completion accounts.
JV waterfall and promote model Sponsor against capital partner: pref, IRR hurdles and the promote in a two-party JV.
Student housing model A 520-bed scheme from rate card to RevPAB, costs, capex cycle and exit value.
Net effective rent calculator Headline rent to net effective rent after rent-free and incentives, and back again.
VaR and expected shortfall model Parametric VaR and expected shortfall step by step, crisis correlations and a backtest.
Corporate liquidity model Minimum liquidity, revolver headroom and the covenant test that takes the revolver away.
Co-investment fee savings model What an LP co-investment programme saves in fees, its break-even loss rate and deal count.
Accretion and dilution model One deal, four EPS conventions, the twelve-line year-one bridge and the eight charges.
Budget vs actual variance analysis Budget vs actual variance analysis: one quarter against five comparators, with the spread.
Cap rate and exit yield calculator Six entry yields, the one comparable with the exit yield, the sale and the promote.
Comparable company analysis Trading comps and precedent deals, and the control premium turned into synergies.
Fulcrum security recovery model Recovery waterfall that names the fulcrum by arithmetic, across seven enterprise values.
Price volume mix analysis Price volume mix analysis: revenue and gross profit bridge, cross term, margin mix and price.
Private equity fund cash flow model Capital calls, distributions, J-curve, peak capital at work and the over-commitment ratio.
LP secondary pricing model LP interest priced at a discount to NAV: MOIC, IRR, discount against appreciation, stress.
Subscription line IRR calculator Same asset with and without a capital call facility: IRR uplift, multiple drag, cost per point.
Venture capital fund model Fees, carry under five conventions, the J-curve, and gross against net IRR for one fund.
Run-rate EBITDA bridge Reported to adjusted, pro forma and run-rate EBITDA, with the buyer's haircut on every line.
Bank stress test: PPNR, CET1 and MDA Nine quarters of PPNR, provisions and CET1 under base and adverse, against the MDA threshold.
Lease-adjusted leverage calculator EBITDAR, rent multiple and IFRS 16 lease debt, fixed charge cover, and a peer that owns its sites.
Solvency II SCR calculator The standard formula, simplified: modules, correlation matrices, Basic SCR and the ratio.
Implied cap rate calculator The cap rate a REIT share price pays for the buildings, against private market and NAV.
Dimson beta calculator Lagged market regression on smoothed fund returns, against the simple and unsmoothed beta.
Commercial real estate underwriting model Value-add multifamily underwriting, five sensitivities and the maximum bid solved in closed form.
Real estate DCF model Ten-year office DCF, quarter by quarter and lease by lease: the re-letting cycle priced in full.
Borrowing base calculator A borrowing base certificate run live off a 1,880-contract tape, and the advance rate set from stress.
Debt sculpting model A toll road's debt sculpted to a 1.25x DSCR, the binding year, the reserve, and the equity return three ways.
Black-Scholes and binomial option pricing One option priced three ways (closed form, lattice, simulation) and what eight points of volatility are worth.
Safety stock calculator Safety stock at every service level, fill rate solved by bisection, and the three policies priced in euros.
Mortgage note pricing model A non-performing note bid from its foreclosure floor, the workout paths, and an eight-loan tape priced loan by loan.
Forecast bias and accuracy calculator Forecast bias measured against its own noise, the error it removes, and the next forecast corrected.
LCR and NSFR calculator Liquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculator Standardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard model A points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysis List price to pocket price for one account and a whole company: nine leakages, ranked and added up.
Capital call and distribution template Investor register, capital call allocation, distribution and the capital account roll, reconciled.
Value creation bridge Entry equity to exit equity in six buckets with a zero residual, the cross-term and add-ons net of cash.
Aircraft lease model A sale-leaseback priced from the lease rate factor to levered IRR, the residual risk, and the lessor's P&L.
Ship finance model A ship loan with LTV covenants and release prices, a bareboat lease with options, a default, and the fund's waterfall.
Cell tower valuation model One tower with one, two and three tenants, a 1,200-tower portfolio, DCF, debt and returns.
Quality of earnings (QoE) template Reported to diligence-adjusted EBITDA, debt-like items, the NWC peg and the closing statement.
Bond price, DV01 and duration calculator Price, DV01 and modified duration for four Treasuries, roll-down, a DV01-neutral steepener and a hedged client trade.
LTV and CAC unit economics model Customer value by horizon under net revenue retention, the break-even CAC, and the cut test.
ABS, CLO and RMBS waterfall model Three securitisations, monthly or quarterly: auto ABS, a CLO under three default paths, and non-QM RMBS.
Partnership flip tax equity model A solar partnership flip: ITC and bonuses, the flip year, capital accounts, transfer, recapture and HLBV.
Battery storage (BESS) financial model A 200 MW / 800 MWh battery: degradation and augmentation, merchant revenue, three cases, debt and the ITC.
Population stability index (PSI) calculator PSI on fixed score bands from development to out of time, and the applicants a model never saw.
Early payment discount calculator 2/10 net 60 as an annual rate, the cash conversion cycle, supply chain finance and a cash pool.
Discount break-even calculator Volume needed to break even on a price cut, volume a rise can lose, the rebate cliff and payment terms.
NAV facility LTV model Eligible NAV, loan to value, a downside, and the second decline that the first ratio hides.
Reserve-based lending (RBL) model An RBL borrowing base from three reserve reports, the bank price deck, hedges and a deficiency cure.
IPO pricing model An IPO from shares and greenshoe to the discount, the book, the first day and a later block.
Mortgage DTI and underwriting calculator Qualifying income, PITI, housing and debt-to-income ratios, funds to close, the appraisal and FHA and VA files.
Care home valuation model A 70-bed care home from admissions and length of stay to EBITDARM, rent cover and value.
Venture debt model A two-tranche venture loan with fees and warrants, runway, the realized IRR, a recovery and fund economics.
Pro rata and dilution calculator What defending ownership through two rounds costs, when it loses money, and whether a 1:1 reserve binds.
Month-end close and covenant model Close corrections, ASC 606 allocation, budget variances and the covenant certificate.
CMBS deal model A twenty-loan CMBS from the tape to fourteen classes, liquidations, five stresses and surveillance.
Loan amortization schedule Monthly schedule for a fixed-rate loan, with extra payments, payoff date and interest saved.
Rental property calculator Cap rate, cash-on-cash, DSCR and ten-year IRR for one rental bought with a mortgage.
XIRR, NPV and IRR calculator Dated cash flows to XIRR and XNPV, beside IRR and NPV, and the classic NPV() error in numbers.
12-month cash flow forecast Month-by-month cash for a small business: collection timing, supplier timing, buffer and credit line.
Startup financial model (SaaS) 24 months of customers, MRR, burn and runway, the month cash runs out and the round needed.
Private credit fund model A levered direct lending fund: income, leverage, losses, fees and an incentive with a hurdle, to net IRR.
Hotel acquisition model Occupancy, ADR and RevPAR to GOP, management fees, NOI and a five-year levered IRR.
Cap table and exit waterfall SAFE, seed and Series A with pool top-ups, then who gets what at five exit values.
WAULT calculator WAULT to expiry and to break, by rent and by area, with the rent that can end by year.
Brinson attribution model Allocation, selection and interaction by segment, Brinson-Fachler and BHB, reconciled.
Should-cost model A supplier quote rebuilt from kilograms, minutes and rates, and the gap split by driver.
Yield maintenance and defeasance calculator Prepayment premium on a fixed-rate loan, yield maintenance against defeasance, with a rate grid.
DPI, TVPI and net IRR template DPI, TVPI and net IRR on one fund, with and without the NAV, plus PME and a subscription line.
Evergreen vs drawdown fund calculator Evergreen net return against a drawdown fund's IRR on committed capital, and where it reverses.
Family office cost calculator Single-family office cost in dollars and basis points, the multi-family fee and the crossover.
Operational due diligence scorecard ODD rating of fund managers on eight domains, and the fatal flaw that averaging approves.
Co-investment follow-on and reserve model What not following on costs a co-investor, pay-to-play, and the reserve that maximises the multiple.
KYC remediation capacity model KYC back book sized in analyst-days, one-year against five-year plans, outreach and exceptions.
ESG value creation model ESG programme from EBITDA to equity, MOIC and IRR, value protected and the exit multiple.
AUM and net flow forecast model 84 months of gross flows, redemptions, net flows and AUM for a fund sold through platforms.
Loan pricing and return on capital calculator Two loans from margin to net spread and return on capital, the PD at which they tie, floor and prepayment.
Reinsurance model: quota share to cat XL Quota share and sliding scale, surplus, stop loss, cat XL layers, reinstatements and burning cost.
Loan workout options model A defaulted loan's four exits as present values, the indifference price and the provisions.
Fundraising funnel and timeline model A first fund raise as a queue: funnel, meetings, committee dates, first close and burn.
Compound interest and fees calculator Starting early against late, the cost of a 1% fee, and the result after inflation.
Debt snowball vs avalanche calculator Five debts paid off three ways, month by month, and what a starter emergency fund costs.
European Defence Fund funding rate calculator EDF blended funding rate, bonuses, partner co-financing, EDIP windows and evaluation scoring.
Real estate capital stack calculator Value-add and development capital stacks, DSCR, debt yield, blended cost and leverage math.
Fund formation model Fund launch budget, fees by close, second-close equalization and the management company P&L.
Litigation finance model Litigation funding returns by outcome, the waterfall, a cross-collateralized portfolio and an award buy.
Industrial development and letting model A speculative warehouse: monthly carry, weighted letting outcomes, expected margin and land value.
SRT investor return model Significant risk transfer from the investor's side: tranche cash flows, IRR, break-even and stress.
Development appraisal and cost headroom Development appraisal, the break-even construction cost and the real cost overrun headroom.
Secondaries discount to NAV calculator The real discount on an LP secondary: unsmoothed NAV, unfunded commitment and fees to term.
Commercial loan and covenant model A bank's acquisition loan: covenants by quarter through a breach, collateral and return on capital.
Laundromat acquisition model Laundromat purchase: SDE, the offer, the SBA injection, the seller note and coverage.
ASC 842 lease accounting model ASC 842 lessee schedules, entries and classification tests.
Med spa treatment margin and break-even calculator Med spa pricing by the unit and the syringe, contribution per room hour and break-even.
Home care bill rate and break-even calculator Home care agency pricing: the cost of an aide's hour, the bill rate and the break-even.
Auto repair shop acquisition model Auto repair shop purchase: SDE, the offer, the SBA injection, the seller note and coverage.
purchase price allocation model ASC 805 purchase price allocation, goodwill and impairment.
Optometry practice revenue per patient and break-even calculator Optometry practice revenue per patient, the optical's margin and break-even.
Pharmacy margin per prescription and break-even calculator Independent pharmacy economics: the margin per prescription, generic against brand, and the break-even.
This template goes with The Real Estate Development Manager . The book is on Amazon .
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review . The template stays free either way.