Real estate listings company Zillow this afternoon announced it will end its business unit that buys and sells homes, Zillow Offers, begun in 2018, after determining it was too hard to forecast home prices upward of six months out, and that the business would require too much capital to fund. 

The comapny said the "wind down" of Offers will "take several quarters" and will lead to reduction of the company's workforce by 25%. 

The announcement, which followed a "pause" in the business announced two weeks prior, sent Zillow shares down 8% in late trading, after the stock had already fallen 11% during the regular session. 

As CEO Richard Barton explained in prepared remarks, "We've determined the unpredictability in forecasting home prices far exceeds what we anticipated and continuing to scale Zillow Offers would result in too much earnings and balance-sheet volatility."

The wind-down comes even as Zillow Offers was seeing surging growth. Revenue in the quarter had risen 531%, year over year, to$1.17 billion. 

Back in 2019, Barton had vowed to prove doubters wrong about the economics of the business. Tonight, it seems, the negative ecomomics have prevailed.

The entire Zillow Homes business unit, of which Offers was 99% of the total, had a negative gross profit margin of 36%, and a negative ebitda margin of 32%, meaning that Zillow was losing 36 cents on the dollar, effectively, for every dollar of home sales. (The tiny remaining sliver of Homes is the company's title and escrow services business.)

Zillow's borrowings to fund buying homes has ballooned. According to a document of supplementary financial figures posted by Zillow on its investor relations site, the company's borrowings under its credit facilities were$2.67 billion in the quarter. That is up from$987 million in the June quarter. 

The credit facilities, funded by Goldman Sachs and other banks, are not entirely for home purchases, but in past, the vast majority has been. In the June quarter,$824 million of the$987 million total was for homes purchased. 

In the company's letter to shareholders this afternoon, Zillow explained multiple issues had felled the program, sales of which had quintupled in the three months ended in September. One was the global pandemic, which changed housing patterns, it said.

The end result was that the company was unable to forecast adequately, it said. Zillow expected to have "guardrails" on home prices so that it could ensure a profit as it bought homes from people and then sold them for a profit.

However, forecasting was proving too tough:

We have been unable to accurately forecast future home prices at different times in both directions by much more than we modeled as possible, with Zillow Offers unit economics swinging approximately 1,200 basis points from Q2 to an expected -500 to -700 basis points in Q4 2021. 

In addition to the inability to forecast, Zillow said that to make the business scale adequately, it would require much more capital than the company wanted to take on:

We have offered sellers a fair market price from the start of Zillow Offers, while also being clear that the business would only become consistently profitable at scale. We have determined this large scale would require too much equity capital, create too much volatility in our earnings and balance sheet, and ultimately result in far lower return on equity than we imagined. 

Because of the inability to forecast, Zillow will take multiple hundred-million-dollar write-offs because of lost value of homes, it said this afternoon:

Included in the company's third-quarter financial results is a write-down of inventory of approximately$304 million within the Homes segment as a result of purchasing homes in Q3 at higher prices than the company's current estimates of future selling prices. The company further expects an additional$240 million to$265 million of losses to be recognized in Q4 primarily on homes it expects to purchase in Q4. Additionally, Homes segment Q3 revenue is below the company's previously provided outlook range due to resale capacity constraints that pushed a number of closings into Q4 that were previously expected to close in Q3.

The deep losses on Offers contributed to a rough earnings report this evening for Zillow. 

For September quarter, Zillow's total revenue rose 165%, year over year, to$1.74 billion, yielding a net loss of 95 cents a share.

Analysts had been modeling$2 billion and a 17-cent profit per share.

For the current quarter, the company sees revenue of$2.22 billion to$2.64 billion, above Wall Street's average estimate for$1.96 billion.

Tech Earnings

SMART Global fiscal Q2 results, outlook top expectationsAdobe shares sag as outlook misses expectationsMicron stock jumps as fiscal Q2 results, outlook top expectationsOracle shares rebound, fiscal Q4 view tops expectationsPagerDuty stock surges as fiscal Q4 revenue, forecast top expectationsDocuSign shares plunge, Q1 and year views miss expectationsCrowdstrike reports Q4 revenue of$431 million and$1.45 billion for full yearBroadcom shares jump as fiscal Q1 results, outlook top expectations

• SMART Global fiscal Q2 results, outlook top expectations
• Adobe shares sag as outlook misses expectations
• Micron stock jumps as fiscal Q2 results, outlook top expectations
• Oracle shares rebound, fiscal Q4 view tops expectations
• PagerDuty stock surges as fiscal Q4 revenue, forecast top expectations
• DocuSign shares plunge, Q1 and year views miss expectations
• Crowdstrike reports Q4 revenue of$431 million and$1.45 billion for full year
• Broadcom shares jump as fiscal Q1 results, outlook top expectations