A finished MKT-433 Topic 7 stage-weighted pipeline forecast example, replacing default stage probabilities with the firm's recorded conversion rates and adjusting for deal age. Searches like "mkt 433 topic 7 assignment example", "mkt433 topic 7 sample" and "mkt-433 topic 7 example" land here.
What a finished MKT-433 Topic 7 stage-weighted pipeline forecast looks like
Two calculations sit side by side in the finished forecast. The first uses the probabilities the software shipped with, 20 percent for qualified deals, 50 for proposals, 75 for negotiation and 90 for verbal agreement. Applied to an illustrative pipeline of deals dated to close this quarter, $4.0 million qualified, $2.5 million at proposal, $1.2 million in negotiation and $0.5 million verbal, it predicts $3.4 million. The second uses rates drawn from eight quarters of the installer's won and lost deals: 12, 30, 55 and 80 percent. The same pipeline then predicts about $2.3 million. Both sums are shown in full. The example then adjusts for age, since deals open far longer than the typical sales cycle tend to close less often, and states the forecast as a range with the assumptions a reader could challenge.
How an MKT-433 Topic 7 example is structured
The forecast is built in five steps a finance reader could repeat. The first section describes the pipeline as it stands, by stage and value, limited to deals dated to close this quarter. The second section explains how historical rates were calculated: every deal that entered each stage over eight quarters, divided into those later won and those lost or abandoned, with deals still open excluded. The third section applies both the default and the historical rates in a pair of tables and reports the gap between them. A fourth section adjusts for deal age, lowering the weight on opportunities that have sat in one stage far longer than the median. The fifth converts the result into a range, using the spread of quarterly outcomes the history shows. A closing section lists the assumptions that would move the figure most and names who owns each one.
Default probabilities shown and retired
The software's preset rates of 20, 50, 75 and 90 percent are applied first, so the reader sees exactly how much optimism they carry.
Rates drawn from eight quarters
Each stage's probability is the share of deals entering it that were later won, calculated from the installer's own records with still-open deals excluded.
The same pipeline, two sums
Default rates predict $3.4 million and recorded rates about $2.3 million, and both calculations are written out line by line for the reader to check.
Aging deals weighted down
Opportunities that have sat in one stage much longer than the median close less often, so the forecast lowers their weight and says by how much.
A range in place of a point
The spread of past quarterly results supplies the width of the forecast range, which tells finance how much confidence the central figure deserves.
Where marks go in MKT-433 Topic 7
Accepting the probabilities shipped with the software is the costliest shortcut on this topic, since nobody at the firm chose them and they often sit above the firm's own record. Probabilities chosen by feel, even sensible-looking ones, repeat the problem with a different set of numbers. Drafts often compute historical rates with still-open deals counted as losses, which drags every stage's probability down for reasons unrelated to how deals actually end. A forecast that ignores deal age treats a proposal sent last week and one sent nine months ago as equally likely to close. A single figure presented to the dollar implies a precision the pipeline cannot support, and many sections mark it down. Leaving out who owns each assumption gives the reader nobody to question when the quarter misses.
Get an MKT-433 Topic 7 example written to your instructions
Send the MKT-433 Topic 7 instructions and the rubric listed in your classroom, with the pipeline data or case your section supplied. We write a custom example to them, with default and historical stage rates compared, every calculation written out, aging deals adjusted and the forecast given as a range, in 24 to 48 hours. The first one is free.
MKT-433 Topic 7 questions, answered
What is a stage-weighted forecast?
A forecast that multiplies the value of each open deal by the probability that deals at its stage eventually close, then adds the results. It is only as good as the probabilities. The example derives them from the firm's own history, so a proposal-stage deal is weighted by how often proposals have actually become contracts at this installer.
Why exclude open deals when calculating historical rates?
Because their outcome is not known yet. Counting them as losses would understate every stage's conversion rate, and counting them as wins would overstate it. Using only deals that have finished, won or lost, gives a rate based on outcomes. The example notes that the most recent quarters contribute fewer finished deals and weighs them accordingly.
Why adjust for how long a deal has been open?
Because time in a stage carries information. In many pipelines, a deal that has waited far longer than usual at the proposal stage is less likely to close than a fresh one, often because the buyer has stalled or chosen someone else without saying so. Weighting stale deals down corrects an optimism that the stage label alone cannot see.