How to Build Board-Ready Sales Forecasts

Forecasting off pipeline stages is like using self-tanner before a beach trip. It gives you false confidence, washes off fast, and fools absolutely no one who gets too close. “30 opps in stage 3 × 40% = $1.2M forecasted.” Bueno. Now subtract the 9 deals that haven’t moved in 30+ days. Then subtract the 5 with no economic buyer involved. And the 8 that don’t have next steps or a MAP. Still $1.2M? lol nah...didn't think so. Stage-based forecasting is pretty broken, mainly because pipeline stages are opinions. Velocity and conversion, on the other hand, are facts. Buyers don’t care what CRM column they’re sitting in. They care about friction, fit, and fear. And your forecast should reflect all three. Here’s how to fix it: 1. Pair conversion rate with conversion velocity. - Let’s say Stage 3 deals have a 30% win rate.  - But they take 52 days to close on average. - If it’s day 50 of the quarter, and that deal just hit Stage 3? It’s not real revenue. It’s next quarter’s homework. One RevOps team I know added “days to close by stage” into their forecast model. They realized 63% of late-stage pipeline wouldn’t close in time based on historical cycle length. The result? They re-weighted forecastable revenue by stage age × velocity. Forecast accuracy jumped 21% in two quarters. 2. Use behavioral signals, not just stage tags Stop assuming every Stage 4 opp has a 60% chance of closing. Start tagging based on buyer actions - not rep motion. What to track: - Was an economic buyer involved in the last call? - Did the buyer ask about implementation timeline? - Has procurement been looped in? - Are multiple stakeholders engaged and documented? Deals with 3+ of these signals close 2 - 3x more often. AND they close faster. Build a behavioral scoring model and overlay it on top of your CRM stages. 3. Build pipeline coverage by real math Forget the “3x coverage” rule of thumb. If your conversion rate from Stage 2 to Close is 18%, and your quarterly target is $1M, you don’t need $3M in pipeline. You need $5.56M in qualified opps. Idea: A CRO we work with built a stage by stage conversion model with time-based decay curves. They found that 22% of their pipeline had aged out of viable range, and 19% of Stage 1 deals had <5% chance of conversion. So they cut their pipeline headline by 41% - and finally forecasted accurately for the first time in six quarters. tl;dr = Forecasting isn’t about hope. It’s judgment × math × motion. If you’re still forecasting based on pipeline stage alone, you don’t have a sales process. You have a spreadsheet-shaped fantasy. And fantasy doesn’t hit number.

Founder-Led Sales Bootcamp #13: Forecast like a CRO, not a dreamer Let’s be honest: most early-stage sales forecasts are just…hopeful guesses. “I’ve got 5 deals that feel warm.” “I think one or two should close.” But you can’t afford to guess. You need a system. A number you believe in. One that stands up to scrutiny. That’s where proper forecasting comes in. Not just spreadsheets - but structure. Here’s how to forecast like a CRO, even as a solo founder: 1️⃣ Bucket your deals Use 3 clear stages: Commit – Signed off internally, close is 90%+ Best Case – Strong intent, but still open dependencies (60%) Pipeline – Early-stage interest, no clear signals yet (25%) 2️⃣ Assign probabilities Multiply each deal by its likelihood. A £10k Commit = £9k. A £10k Pipeline = £2.5k. Then total it up. 3️⃣ Weight based on past accuracy If your last quarter closed at 60% of forecast, adjust down. Don’t lie to yourself. Your hiring plans depend on this. 4️⃣ Track conversion rate by stage Discovery → Proposal → Closed. You need to know where deals die, not just where they enter. 5️⃣ Update every week Deals move fast. So should your forecast. A rolling 12-week view will help you spot dry spells before it’s too late. Quick action plan: 💡Build a simple forecast sheet with columns for stage, value, probability, and weighted value. 💡Audit your current deals into Commit / Best Case / Pipeline. Be ruthless. 💡Add a forecast trend line - what did you predict vs what did you close over the last 3 months? Forecasting isn’t just a sales task - it’s strategy.

Don't blindly run (obvious) spreadsheet prompts. Here are 30 prompts to make sheets board-ready: Setup & foundation: "Build me a [TYPE] spreadsheet from this data." "List your top 10 assumptions before executing." "Use named ranges so formulas read like English." "Keep all inputs on an Assumptions tab." "Format for board projection: clean palette, frozen rows." Building the structure: "Add a Dashboard tab with KPI tiles." "Add Base / Bull / Bear scenario toggle." "Add a P&L tab linked to the Revenue tab." "Build a 12-month forecast by service line." "Add a Funnel tab: audience → leads → deals." Analysis without formulas: "What trends stand out in 2026 vs 2025?" "Compare actuals to budget, explain 3 variances." "Categorize these transactions into expense types." "Which line items grow faster than revenue?" "Find the deals that closed fastest - what's in common?" Editing in Google Sheets: "Visualize @Revenue as a stacked bar." "Summarize @Funnel in 5 bullets." "Add conditional formatting on margin %." "Translate @Dashboard into French." "In @Assumptions, push Bull more optimistic — stay realistic." Debugging and cleanup: "Explain what the formula in [CELL] does in English" "Trace [CELL] back to its source inputs." "Why is [CELL] showing # REF / # VALUE / # DIV/0?" "Find any hardcoded numbers inside formulas." "Show me how [CELL] connects to the Assumptions tab." Advanced moves: "Add a data table for revenue at diff growth rates." "Add a Monte Carlo simulation on key drivers." "Convert this monthly model to weekly granularity." "Stress-test the model — what breaks first?" "Reconcile @Revenue tab with @P&L tab — find mismatches." These prompts are everywhere now. Board decks. Investor models. Monthly reviews. Even messy bank exports. The formula bar used to be the bottleneck. Now it's knowing what to ask. They sound simple. But they do an analyst's work. Here's how to actually build board-ready sheets: 1. Force the AI to expose its logic. Before anything, ask "list your top 10 assumptions." Non-negotiable. 2. Separate inputs from logic. Keep every assumption on its own tab. Pull hardcoded numbers inside formulas out where you can see them. 3. Make it readable. Not "=B4C71.12." But named ranges that read like English. If a board member can't follow it, it's not board-ready. 4. Audit before you send. Ask "trace this cell back to its source inputs" & "reconcile the Revenue tab with the P&L tab." 5. Stress-test it. "What breaks first?" Find the edge case in the model, not in the meeting. Don't trust a spreadsheet you can't explain. Read the full Excel guide: https://lnkd.in/d6rM-GSm. Send it to your finance team. Thank me later.

This simple framework TRIPLED this sales team’s forecast accuracy in 60 days. I was recently working with a sales leadership team that was frustrated with their forecasting process. "Marcus, our reps just give us random numbers. Some sandbag, some are overly optimistic, and I never know what to actually tell my board." (Mhhh… this sounds oddly, familiar, doesn’t it? 😉) Here’s a tip that costs you $0 to implement: Start implementing Monthly Business Reviews with one crucial distinction: separating COMMITMENTS from STRETCH GOALS. Here's the framework I implemented that tripled their forecast accuracy in just 60 days: 1️⃣ Redefine what a forecast means COMMITMENT: "This is my take-it-to-the-bank number. I will 100% deliver this, or I've failed." STRETCH GOAL: "This is what I'm aiming for if everything goes perfectly." 2️⃣ Create visual accountability: Every rep shares their commitment AND stretch goal monthly. Track actual performance against both numbers. Make the results visible to the entire team. Highlight who consistently hits their commitments. 3️⃣ Challenge sandbagging in real time: When a rep commits to a low number, let the team challenge them publicly. "Wait - don't you have the XYZ deal that's $450K by itself? Plus everything else?". Let peer pressure drive realistic commitments. 4️⃣ Connect to bigger motivations Have reps document their "BHAGs" (Big Hairy Audacious Goals). What would they achieve if they knew they couldn't fail? What personal goals would hitting their numbers enable? What specific daily actions will drive those results? The magic happens when reps have to publicly state their commitments month after month. When someone consistently misses their commitments, it's no longer just a conversation with their manager. It's a reputation issue with the entire team. One VP of Sales told me: "Before, I never knew which numbers to believe. Now, I can actually make reliable commitments to my board because I know exactly which deals are solid and which are aspirational." The best part? This framework takes less than 5 minutes per rep to implement in your team meetings. — Sales leaders, want me to come in and train you and your team? Go here: https://lnkd.in/gfn_qi9E

Because a wrong forecast is the worst start... This infographic shows how to create a sales forecast in Excel step-by-step: 1️⃣ Unify Data with Power Query ↳ In Excel → Data → Get Data, import historical sales from various files (CSV, ERP exports) into a single table 2️⃣ Build a Time Series Table ↳ Organize dates in forecast buckets in rows, with products or categories in columns, and fill with sales units or revenue 3️⃣ Leverage Advanced Statistical Functions ↳ Use FORECAST.ETS (handles seasonality) or FORECAST.ETS.SEASONALITY to detect peaks and troughs automatically 4️⃣ Try Weighted and Exponential Moving Averages ↳ Create your own Weighted Moving Average by assigning higher weights to recent months, or use exponential smoothing 5️⃣ Check Forecast Accuracy and Bias ↳ Calculate WMAPE, and Bias in separate columns to measure how far off your forecast is and whether you’re consistently over or under 6️⃣ Create a “Scenario” Sheet for Adjustments ↳ Build a small table where you can adjust known events—promotions, price changes—and link these cells to your forecast formula as offsets 7️⃣ Build an Interactive Dashboard ↳ Use PivotTables, Slicers, and Charts to let stakeholders filter by region, product line, or date range Other suggestions to add?

We'll be at $100M ARR in 18 months. Current revenue? $50K MRR. I immediately passed. It's good to be ambitious, but delusional? That's a no. Not because $100M is not going to happen. Because the path to get there was pure fantasy. Here's the model he showed me: "We'll hire 20 salespeople who will each close $400K annually." Let me check the math: 20 × $400K = $8M ✓ But your CAC is $10K per customer Average deal size is $25K annually So each rep needs 16 customers per year At 6-month sales cycle, that's 96 deals in pipeline per rep That's 1,920 qualified leads needed in month one His current lead gen? 40 leads monthly. The math doesn't math. Founders reverse-engineer projections from outcomes they want instead of building up from unit economics. One founder I backed showed me this: "Month 1: $100K. Month 18: $2M. Here's the exact path he walked through: Current CAC: $3K, close rate 15%, sales cycle 3 months - To hit $2M need 80 customers - At 15% close need 533 leads - Current marketing: 30 leads monthly - Need to 10x marketing = $X spend Here's monthly spend breakdown Here's how close rate improves as we refine positioning Every assumption defended with logic. Still aggressive, but believable. He raised $3M. How to build credible projections: 1. Start with current unit economics. 2. Show how they improve with specific initiatives. 3. Model customer acquisition month by month. Build UP to revenue, don't work backward from it. Ambitious is good. Delusional is disqualifying. #StartupProjections #Fundraising #VentureCapital

Forecasts lose trust when they have bad assumptions and poor traceability. If someone can’t quickly answer “where did this number come from?” you're in trouble. --------------- This P&L was from a former client. I've changed the numbers and line items for educational purposes so you can learn. --------------- ① Document the source of every major line item A forecast should never force the reader to hunt for assumptions. Each major P&L line here clearly ties back to a supporting schedule, such as: • Revenue build • Cost build • Expense build • Capex schedule • Debt service schedule • Tax schedule Source references allow for: • Auditability. You can validate logic. • Speed. You don’t waste time re-deriving assumptions. • Change management. Adjustments flow cleanly. • Credibility. Users trust what they can trace. • Inheritance. Others can update it too. If you want to go even further, you may consider trying each source reference into a hyperlink. ② Operating statistics, not just financial outputs Most end-users won't scrub every single line of your income statement. They shouldn’t have to. Because they want answers to more direct questions like: How much are sales growing? Are margins improving or getting compressed? Is productivity per employee expanding or deteriorating? Operating stats like what we have here translate raw financials into signals: • Revenue growth • EBITDA growth • Gross margin • EBITDA margin • Revenue per employee • Headcount trends ③ Operating stats as logic checks Here’s where things get interesting. In the example I share: • Revenue growth jumps to 22.3%, then settles into 12% annually • Recast EBITDA growth is negative, then ramps aggressively, then plateaus That pattern looks odd and it isn’t automatically wrong. It demands explanation. Questions a strong model should provoke and then answer: • What drives the sudden acceleration in revenue? • Why does profitability lag before inflecting up? • Which assumptions cause margin expansion? • If growth normalizes, should EBITDA behavior follow the same pattern? Operating statistics expose non-obvious inconsistencies that the full P&L often hides in the individual line items. If you can trace every number to a clear source, focus attention on the drivers that matter, and quickly spot when the story stops making sense, you have more than a business model. You uphold your credibility. And you have a plan that others are willing to rely on.

The best CEOs plan for 3 different scenarios at once (this transformed my approach to uncertainty): I used to create one "realistic" forecast each year. Then spend 12 months explaining why we missed it. Everything changed when I learned this framework from a mentor who'd scaled multiple companies: Plan 3 scenarios. Execute 1. Adapt quickly. 📊 BASE CASE (95% likely) "What happens if we maintain current performance?" - Focus on core strengths - Maintain spending discipline   - Protect 12+ months runway 🎯 STRETCH CASE (50/50 shot) "What can we achieve with focused execution?" - Expand into 1-2 new areas - Invest in proven ROI initiatives - Keep 6-12 months buffer 🚀 BOLD CASE (25% moonshot) "What's possible if everything goes right?" - Transform multiple areas - Accept lower margins for growth - Operate with 3-6 months runway The magic isn't having 3 spreadsheets. It's what happens when reality unfolds: Q1 tracking to BASE? → You've already planned for efficiency → Team knows exactly what to protect → No panic, just execution Q2 hitting STRETCH markers?  → Green light those strategic hires → Unlock the growth investments → Everyone knows the playbook Q3 approaching BOLD territory? → Time to accelerate aggressively → The plan is already approved → Full speed ahead Instead of surprising your team with pivots, they know all 3 paths from day one. Instead of emergency board meetings, you just point to which scenario you're tracking. Instead of reactive decisions, you make proactive moves based on clear triggers. The result? - Your team trusts the plan - Your investors respect your risk management - You sleep better knowing you're prepared Most importantly: You stop being surprised by reality. And start being ready for it. Every successful scale-up I know uses some version of this. Because uncertainty isn't the enemy. Being unprepared for it is. P.S. Ready to build your 3-scenario plan? Download my framework free:  https://lnkd.in/dhn9y3zq ♻️ Repost to help a leader in your network. Follow Eric Partaker for more planning insights. — 📢 Want to lead like a world-class CEO? Join one of my FREE TRAININGS THIS WEEK: "How to Develop the Mindset Shared by the World's Best CEOs" Wed, July 16th, 12 noon Eastern / 5pm UK time https://lnkd.in/dJRpFXnb "How to Successfully Scale Your Company & Become a World-Class Leader" Fri, July 18th, 12 noon Eastern / 5pm UK time https://lnkd.in/djt83NUz 📌 LAST CHANCE TO APPLY for the CEO Accelerator cohort, starting July 23rd. Learn more here and join 40+ Founders & CEOs: https://lnkd.in/dbE5rkYB

(FMCG Blueprint) Sales forecasting in FMCG is both an art and a science. Let’s break it down using some basic matrices with a relatable example. Imagine we’re working for a brand that sells a spicy instant noodle, “HotBowl Ramen”. 1. Historical Sales Data (Your Crystal Ball) The first step is to look at past sales. For example: Month Sales (Units) January 10,000 February 11,000 March 10,500 April 12,000 Now, let’s assume you notice a 5% growth trend every month. For May, you might forecast: May Sales = April Sales * (1 + Growth Rate) = 12000 * (1 + 0.05) = 12600 Tip: This works well unless your sales suddenly nosedive because people discovered a new health fad: “No-Spice Life!” 2. Seasonality (Your FMCG Calendar) People eat more noodles in winter because “cozy food” vibes. Let’s adjust for seasonality: • Winter months: Add 10% • Summer months: Subtract 15% If your May forecast is 12,600 units but May is peak summer, adjust like this: Adjusted Sales = Base Sales * (1 - 0.15) = 12600*0.85 = 10,710 Reality Check: Your product is spicy. Some brave souls will still eat it even in May, sweating like they’re in a sauna. 3. Market Dynamics (Your Frenemy) Suppose your competitor, “MildBowl Ramen,” launches a huge promotion in May. You estimate a 10% impact on your sales. Final Sales Forecast = Adjusted Sales * (1 - 0.1) = 10710*0.9 = 9,639 4. Promotional Impact (Buy One, Cry One Free?) Now, your marketing team swoops in with a “Buy 1 Get 1 Free” promo. Promotions can boost sales by 20%, so: Promo Adjusted Sale = 9639*1.2 =11,566.8 Realistic Case Summary Step Forecasted Sales Base Sales Forecast 12,600 Seasonality Adjustment 10,710 Competitor Impact 9,639 Promo Impact 11,566 Funny Perspective Imagine your boss: • Before Forecast: “We need 15,000 units this month!” • After Your Analysis: “Hmm… okay, but let’s add another promo to reach 12,000 at least!” Your real hero? The customer who eats your spicy noodles even in May, sweating but happy. Moral: Forecasting is like cooking ramen—balance your ingredients (data) and adjust for taste (market trends)!

Accountants are trained to look backward. Forecasting requires looking forward. That's why so many accountants struggle with it. You're great at preparing financial statements, so you pay attention to detail. You dive deep into the financials. You compare them to the same quarter of the previous year. But forecasting isn't about what happened. It's about what will happen. Here's how to bridge that gap: 𝟭. 𝗨𝘀𝗲 𝘆𝗼𝘂𝗿 𝗮𝗰𝗰𝗼𝘂𝗻𝘁𝗶𝗻𝗴 𝘀𝗸𝗶𝗹𝗹𝘀 𝘁𝗼 𝗶𝗱𝗲𝗻𝘁𝗶𝗳𝘆 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗱𝗿𝗶𝘃𝗲𝗿𝘀 Take a closer look at the financials. Did marketing expenses increase? Did discounts fluctuate? Did a new feature come online? Your attention to detail is an asset here. 𝟮. 𝗨𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱 𝘆𝗼𝘂𝗿 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗱𝗿𝗶𝘃𝗲𝗿𝘀 Don't just ask budget owners what they think will happen. Ask them why drivers have changed in the past. What are the internal and external factors that contribute? 𝟯. 𝗖𝗿𝗲𝗮𝘁𝗲 𝗿𝗮𝗻𝗴𝗲𝘀 Look at each major driver and create worst-case, best-case, and expected scenarios. Refer back to how much things fluctuated in the past. Ranges from historical data are a good starting point. 𝟰. 𝗖𝗼𝗻𝘀𝗼𝗹𝗶𝗱𝗮𝘁𝗲 Put the scenarios for each business driver on a spreadsheet and calculate what the overall best, worst, and expected outcomes look like. Don't forget to brainstorm probabilities for each case so you can arrive at the weighted average. 𝟱. 𝗔𝘀𝗸 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗽𝗮𝗿𝘁𝗻𝗲𝗿𝘀 𝗳𝗼𝗿 𝘁𝗵𝗲𝗶𝗿 𝗳𝗼𝗿𝗲𝗰𝗮𝘀𝘁 Ask your cross-functional business partners what they think the forecast should be for their respective areas of expertise. 𝟲. 𝗖𝗼𝗺𝗽𝗮𝗿𝗲 𝘁𝗵𝗲𝗶𝗿 𝗳𝗼𝗿𝗲𝗰𝗮𝘀𝘁𝘀 𝘁𝗼 𝘆𝗼𝘂𝗿𝘀 Combining them is a fantastic way to remove bias. Your top-down approach may have been too optimistic. Their bottom-up approach gives you higher-fidelity figures. 𝟳. 𝗗𝗶𝘀𝗰𝘂𝘀𝘀 𝘁𝗵𝗲 𝗱𝗶𝗳𝗳𝗲𝗿𝗲𝗻𝗰𝗲𝘀 Most value is generated in this final step. Make sure you have enough time to talk to your business partners about the differences between their forecasts and yours. It's not about who's right but about what the risks and opportunities are. The bottom line: Your accounting skills aren't a weakness for forecasting. They're a foundation. You just need to point them in a different direction. -Christian Wattig 📌 P.S. If you like this, you'll love my Financial Modeling templates + 46 best practices. Grab them here: https://lnkd.in/eBAmSF_6