Mortgage Pipeline Forecasting: A Practitioner's Playbook

Mortgage Pipeline Forecasting: A Practitioner’s Playbook Mortgage pipeline forecasting estimates the share of locked loans in a lender’s pipeline that will actually fund, then uses that estimate to size hedge coverage. The core metric is pull-through: funded loan volume divided by locked loan volume within a given observation window, as MCT’s pull-through primer lays out. The recommendation for anyone running a secondary marketing desk in 2026 is straightforward. Build loan-level, stage-adjusted expected funded volume, not a single blended pull-through number for the whole pipeline. Layer in a market beta adjustment so hedge coverage moves with rate direction instead of lagging it. Treat forecast accuracy as a margin protection tool, not a reporting exercise. A pipeline that’s over-hedged bleeds carry cost every day; one that’s under-hedged exposes the lender to price risk on every basis point move. Key Takeaways Accurate mortgage pipeline forecasting combines loan-level, stage-adjusted pull-through estimates with a market beta adjustment to set hedge coverage that tracks actual rate risk. Point Details Define pull-through precisely Calculate funded volume divided by locked volume within a set window, by stage, not as one blended pipeline figure. Model at the loan level Score FICO, channel, loan officer, and pricing context individually, then sum into expected funded volume. Adjust for market beta Regress historical pull-through deviation against rate moves to size hedges dynamically rather than statically. Govern with a fixed cadence Run daily drift checks, weekly hedge reviews, and quarterly stress tests against multiple rate regimes. Automate borrower and pipeline signals Loan Officer AI centralizes stage tracking, refi/HELOC detection, and automated follow-up to reduce fallout that pure rate models miss. Table of Contents Why Mortgage Pipeline Forecasting Matters for Hedging and Margin How Should You Structure Pipeline Stages for Forecasting? What Loan-Level Data Actually Improves Pipeline Forecasts? What Daily Signals Should Feed a Live Pipeline Forecast? How Do You Calculate Market Beta for Pull-Through Forecasting? How Do You Calculate Pipeline-Level Pull-Through Step by Step? Which Forecasting Model Should You Use: Logistic Regression or Machine Learning? What Data and Tools Do You Need for Live Forecasting? How Should You Govern and Monitor Pipeline Forecasts? How Do Economic Indicators and Housing Trends Affect Pipeline Forecasts? How Does Pipeline Forecasting Fit Into Enterprise Risk Management? What Are the Biggest Pitfalls in Mortgage Pipeline Forecasting? How Should You Stress Test Pipeline Forecasts? What Role Does Technology Play in Forecast Accuracy? Why Integrated Borrower Signals Change What Forecasting Can Actually Do How Loan Officer AI Supports Pipeline Forecasting in Practice Frequently Asked Questions Sources Why Mortgage Pipeline Forecasting Matters for Hedging and Margin Get the forecast wrong in either direction and it costs money. Over-hedge the pipeline and you’re carrying excess TBA or forward commitments that generate negative carry and transaction costs with no offsetting risk reduction. Under-hedge it and a sudden rate move against an unhedged slice of locked loans erodes margin loan by loan, often invisibly until month-end reconciliation. Statistic Callout: A random forest model built on a large U.S. lender dataset predicted loan fallout with roughly 74% accuracy, a meaningful jump over cruder heuristic approaches that treat every loan in a stage identically. Three KPIs deserve a permanent spot on the secondary desk’s dashboard: Pull-through volatility, measured week over week against a rolling baseline. Hedge tracking error, the gap between hedge notional and actual funded notional at settlement. Funded timing variance, since a loan that funds three weeks later than modeled still creates duration mismatch even if the volume estimate was correct. How Should You Structure Pipeline Stages for Forecasting? A forecast built on a single blended pull-through rate is a forecast built on sand. Loans in different stages carry wildly different fallout risk, and lumping them together hides the signal you actually need. A workable stage taxonomy looks like this: Application — earliest stage, highest fallout risk, most sensitive to shopping and rate competition. Approval — underwriting conditions cleared, borrower commitment more established. Clear to close (CTC) — nearly all conditions satisfied, fallout risk drops sharply. Committed — rate locked with a defined expiration, borrower has skin in the game. Pre-fund — closing scheduled, fallout is now almost entirely operational (title issues, wire delays) rather than borrower choice. Time-in-stage matters as much as the stage label itself. A loan that’s spent six days in CTC behaves differently than one that just arrived there, and operational levers like lock-desk policy that push commitment deeper into the process measurably raise pull-through certainty. The longer a loan sits deep in the pipeline without falling out, the less sensitive its outcome becomes to a rate move elsewhere in the market. Pro Tip: Track median time-in-stage separately for each loan officer or branch. A branch with unusually fast CTC times often has looser underwriting discipline, and that shows up later as elevated fallout, not as a forecasting win. What…