The Fixer Underwriting Sheet: How Silicon Valley Investors Price a Distressed Home Before They Bid

By Brad Bell — Coldwell Banker Global Luxury — Silicon Valley native, top 1% of realtors nationally

Most Silicon Valley flips are won or lost before a single contractor is hired. The renovation budget gets the attention, but the number that actually determines the outcome is the offer ceiling — the maximum you can pay and still hit your return. Here is the underwriting sheet I walk investor clients through before they write an offer on a distressed property.

Why the Offer Ceiling Comes First

I have written before about how to budget a Silicon Valley renovation line by line. That work matters, but it happens after the decisive moment. The decisive moment is the offer, and by then the ceiling is either right or the deal is already compromised.

In a market where a correctly priced West Valley home can go pending in under two weeks, an investor cannot afford to build the number in the middle of a bidding process. The ceiling has to be calculated before you see competition, written down, and treated as a hard stop.

The sheet has five inputs. Get all five honest and the deal underwrites itself.

Input One: After-Repair Value, Comped Honestly

Everything downstream depends on this number, and it is where optimism does the most damage.

The rules I apply:

• Six months maximum on comp age. In this market, anything older is a different market.
• Same school assignment, without exception. A comp three blocks away with a different high school feed is not a comp. In Sunnyvale and parts of Santa Clara, this alone can invalidate half your set.
• Comp to the finished product, not to aspiration. If your budget produces a very good renovation, comp to very good renovations. Comping a mid-tier remodel against a full architectural rebuild is the most common way investors talk themselves into a bad ceiling.
• Adjust for lot and layout before you adjust for finishes. Finishes are what you control. Lot size, orientation, street, and floor plan are what you inherit, and buyers price them heavily.

Take the conservative end of the resulting range. If the honest ARV band is $2.6M to $2.9M, underwrite at $2.6M. The upside is a bonus, not a plan.

Input Two: Renovation Cost, With the Right Contingency

Get a real contractor number, not a per-square-foot estimate, before the offer if the transaction allows it. Then apply two adjustments that investors skip.

Contingency. Ten percent on a cosmetic refresh. Twenty percent minimum on anything touching foundation, roof structure, electrical service, sewer lateral, or a permitted addition. Silicon Valley’s older housing stock reliably produces at least one surprise, and the surprises are rarely cheap.

Permit timeline as a cost, not a footnote. Every month a permit sits in review is a month of carrying cost. Jurisdictions in this county vary substantially in turnaround. If your plan requires a structural addition, underwrite the timeline you will actually get, not the one you hope for.

Input Three: Carrying Costs Nobody Puts on the Sheet

This is where thin deals become losing deals. For a hold period, count every one of these:

• Hard money or bridge interest, at the actual rate and the actual draw schedule
• Property taxes, prorated for the full hold
• Insurance, including any vacancy or builder’s risk premium
• Utilities during construction
• Staging for the resale marketing period
• Security, dumpsters, portable facilities, and site costs

Then underwrite the hold period honestly. If your plan says four months, run the sheet at six. Permit delays, inspection scheduling, and a resale marketing period each add weeks that the optimistic version of the plan never includes.

Input Four: Sale-Side Costs. Input Five: Required Return.

Sale-side costs are the easiest to model and the easiest to forget: commissions, transfer taxes at the applicable city and county rates, escrow and title, any negotiated buyer credits, and the repair concessions that emerge from the buyer’s inspection even on a fully renovated property.

Required return is a decision, not a calculation, and it should be measured on total return rather than a headline cap rate. Decide what makes the project worth your capital and your months, in dollars, before you look at a specific property. An investor who decides the target number in advance is disciplined. An investor who backs into it after falling in love with a house is not.

The Ceiling Formula

Conservative ARV, minus renovation cost including contingency, minus carrying costs at the realistic hold period, minus all sale-side costs, minus your required return. What remains is the maximum offer. Not the target offer — the maximum.

Write it down before you tour the property a second time. If the market takes the property above that number, you did not lose the deal. You avoided one.

Where Silicon Valley Breaks the Standard Playbook

Three local factors that generic investing advice does not account for.

The land-to-improvement ratio is inverted here. On many valley lots, the dirt carries most of the value. That compresses the return on cosmetic work and raises the return on anything that adds permitted square footage or a functional second unit. Run both scenarios before committing to a scope.

School boundaries create hard price walls. They do not fade with distance the way most neighborhood premiums do. A boundary is a cliff, and it belongs in your comp selection, not in your adjustments.

Velocity is your friend on the exit. Fast markets shorten holds, and shortening a hold is the most reliable way to improve a return without touching the purchase price. This spring, Saratoga was averaging roughly eleven days on market at about 101 percent of list and Los Gatos roughly thirteen days at about 100 percent. A properly renovated, correctly priced product moves quickly here — which means the exit assumption in your sheet should reflect a fast market, and your renovation quality has to earn it.

A note: this is a framework, not tax or investment advice. Depreciation recapture, capital gains treatment, and exchange eligibility should be reviewed with your CPA before you commit capital.