Real Estate Novation Agreement Calculator in Excel: Novate or Assign

A wholesaler in Fort Worth has a 3 bed, 2 bath house under contract at $196,000. His cash buyers top out at $215,000 because they underwrite to seventy percent of after repair value and this house does not need a gut, it needs paint, carpet, landscaping, and a water heater. A retail buyer with an FHA loan will pay $272,000 for it once that work is done. He looks at the gap, sees $76,000, and starts telling people he found a novation deal. The number he will actually collect at the closing table is $38,546. A real estate novation agreement calculator built in Excel exists to find the other $37,454 before he signs anything, because in a novation the costs that eat your spread are costs an assignment never made you pay.

Novation is the third exit, and it is the one most wholesalers get wrong in the same direction. They price it like an assignment with a bigger number on the end. It is not. In a novation you are running a retail sale on someone else's title, which means you pay retail selling costs, you fund the make-ready out of pocket, and you carry the deal for sixty days instead of fourteen. Every one of those is a line item. Here is how to build the model, and more useful, the three numbers in it that tell you when the boring assignment was the better trade.

The Buyer an Assignment Cannot Reach

The reason novation exists at all is a financing problem, not a greed problem. When you assign a contract, your end buyer has to close on a contract that shows your fee, and almost no institutional lender will fund that. FHA and conventional money will not write a loan where the buyer of record inherited a contract carrying a $76,000 assignment fee. So an assignment restricts you to cash and hard money, and cash pays a cash discount. That discount is the $57,000 sitting between $215,000 and $272,000.

A double close solves the disclosure problem and creates a new one. You take title, then resell, which means transactional funding on $196,000, two sets of closing costs, and an end buyer whose lender now sees a same-day resale with zero seasoning. Many underwriters kill it right there.

In a novation, the original seller stays on title until the final closing. You amend the purchase agreement so the end buyer replaces you as the buyer of record, at a new price, with the seller's written consent, and your compensation is documented and paid from the seller's proceeds at closing. Chain of title never breaks, there is no seasoning issue, and the retail buyer's FHA loan funds normally. That is the whole point. You are not hiding a fee, you are getting paid to bring a higher buyer to a seller who agreed to a net.

What the seller actually signs

The seller is not agreeing to a price, the seller is agreeing to a net. In the model that distinction is cell B4, and it is the anchor for everything else. Your original contract at $196,000 becomes "seller nets $196,000 regardless of what the property sells for," and the novation agreement says the excess above that net, less the costs listed in the agreement, is your fee. If the seller thinks in list price instead of net, the deal falls apart the day the property goes live at $279,900 and they see the number on Zillow. Model it as a net and paper it as a net.

Build the Novation Calculator in Excel

One sheet, four blocks. Inputs on top, then the assignment exit, then the novation exit, then the decision. The point of stacking them is that you never evaluate a novation on its own. You evaluate it against the assignment you are giving up.

B7 is separate from B6 on purpose. List price is a marketing decision, sale price is what the model runs on, and putting them in the same cell is how people talk themselves into a spread that never shows up. Set B7 at ninety-seven to ninety-eight percent of list for a make-ready property in a normal market, and lower it the day you take a price cut.

The assignment column is the baseline, not the fallback

Build the assignment exit first, because it is the number the novation has to beat.

Nineteen thousand dollars, fourteen days, zero capital at risk beyond earnest money. That is a real trade and the novation has to be meaningfully better than it, not nominally better.

The novation block is a seller net sheet in disguise

Everything below the sale price is a cost that comes off the top before anyone pays you. Order the rows the way a settlement statement orders them so you can reconcile the sheet against the ALTA at closing line by line.

There is the $37,454. Commissions, concessions, and seller closing costs are 8.2 percent of the sale price and they alone take $22,304. The make-ready takes $12,500 in cash you spend on a house you do not own. Carry, extensions, and paper take $2,650. None of those exist on an assignment, which is why comparing $76,000 to $19,000 is not a comparison, it is a fantasy.

Track the make-ready as spend rather than budget. Point B8 at a transaction tab with =SUMIFS(Reno!D:D,Reno!B:B,"Make-ready",Reno!E:E,"Paid") so the fee in B33 falls in real time as invoices clear. On a $12,500 scope a $3,000 overrun is a quarter of your cushion and you want to watch it move, not discover it at closing.

The Three Numbers That Decide Novate or Assign

The fee in B33 is not the decision. Three derived numbers are, and all three belong on the sheet before you ever present a novation to a seller.

Break-even sale price is your walk-away number

B44 says the property has to sell for at least $250,436 for the novation to have been worth doing. Below that you did sixty days of work, fronted $15,150, and made less than the assignment you turned down. That number is the one to write on a sticky note before the listing goes live, because it converts every price cut conversation from a feeling into arithmetic. Your agent wants to drop to $259,900 in week four? Fine, you are still $9,000 ahead of the assignment. Wants to drop to $249,000? You just paid yourself to work for free.

Break-even close probability prices the risk

B43 is the number almost nobody builds. It asks what odds of actually closing the retail sale make this trade rational, given what you lose if it collapses. If the retail buyer walks and the house comes back to you tired, your cash buyer will not honor $19,000 on an aged contract with an annoyed seller, so B41 models a discounted fallback of $12,000, and against $15,150 already spent that is a $3,400 loss. Run =(B20-B42)/(B33-B42) and the answer is 52.8 percent.

Read it plainly. You need better than a coin flip on this closing before novation beats assignment. In a market where inspection-ready make-ready properties go under contract in three weeks and appraise, that is an easy yes. In a market where you are the fourth listing on the street and rates just moved, it is not. Flag it with =IF(B45<B43,"ASSIGN","NOVATE") where B45 is your honest estimate of close probability, and force yourself to type a number into B45 rather than nodding at a vibe.

Return on capital at risk keeps novation in its lane

B39 says the $15,150 you put at risk returns 130.7 percent over 46 extra days, which annualizes past 1,000 percent on =(B36/B37)*(365/B38). That is the honest argument for novation and it is a strong one. It is also the number that stops you from novating a deal where the make-ready is $60,000, because at that scope you are running a flip on someone else's title with none of the upside and all of the exposure. If B37 climbs above about a third of B33, you are not novating anymore, you should be buying the house.

Where Novation Deals Die

Four failure modes, and each one gets a cell.

The appraisal. A financed buyer means an appraiser decides your sale price. Put the appraised value in B46 and the gap in =MAX(0,B7-B46). Assume you eat it, because a buyer at $272,000 with three percent down rarely brings $10,000 in cash to cover a shortfall. Run it: appraisal at $262,000, price drops, and the model recomputes to $29,366. That is still $10,616 better than assigning, which is the useful thing to know before the call, not after.

Every row below $250,436 is red. Build it as a data table off B7 so it recalculates when the make-ready overruns, because the break-even price moves up a dollar for every dollar you overspend on paint.

The seller's patience. Your original contract has an expiration and a novation needs sixty to ninety days. Put the contract end date in B47, the projected close in =B47+B9, and a warning in =IF(TODAY()>B47-14,"EXTENSION DUE","OK"). Sellers who feel strung along cancel, and a canceled contract in week seven costs you the full $15,150 with no fallback at all. Pay the per diem early and cheerfully, it is the least expensive line in the model.

The title company. Plenty of them will not close a novation, and you find out in week six. Confirm in writing before you spend a dollar on make-ready, and confirm specifically that your fee can appear on the settlement statement as a line to your entity. If it cannot, the deal becomes a side agreement, and side agreements around a federally insured loan are where wholesalers get into genuine trouble.

Licensing and marketing. You are marketing a property you do not own. Most novation deals list on the MLS, and in most states listing property for a seller for compensation requires a license, which is why the working structure is a licensed agent on the listing and a documented fee to you. Get the arrangement reviewed by an attorney in your state once, not once per deal. Budget it inside B15 and stop guessing.

The Rule Worth Running

Novate when three conditions hold at once: the make-ready is cosmetic and under about $15,000, the break-even sale price in B44 sits at least eight percent under a comp-supported sale price, and your honest close probability clears B43. On the deal above that is $12,500 of work, a $250,436 break-even against $272,000 of comps, and a 52.8 percent bar. Three yeses, so you novate and collect $38,546 instead of $18,750.

Assign when any one of them fails. The spread on paper is never the argument. A $76,000 gap that turns into $38,546 is a great deal. The same $76,000 gap on a house needing $45,000 of work, in a market where your break-even lands at $268,000 against soft comps, is a sixty day unpaid job with $50,000 of your money in someone else's drywall. The only way to tell those two apart is to build both exits in the same sheet and let the difference in B36 make the decision instead of the size of the number in B24.

The novation model is only as good as the two prices feeding it, and both come from underwriting, not from hope. Your cash buyer ceiling in B5 and your retail sale price in B7 are the entire spread, and if either one is off by five percent the whole decision inverts. The SheetCraft Flip and BRRRR Calculator is where those two numbers get built. It models after repair value off comps, prices the rehab scope line by line so your $12,500 make-ready is a scope and not a guess, and runs the seventy percent rule against holding and financing costs to produce exactly what a cash buyer can pay, which is your B5. Underwrite the deal there, drop the ARV and the buyer ceiling into the novation sheet, and you will know before you call the seller whether this is a $38,546 novation or a $19,000 assignment wearing a costume.