Download the files for the course

Enter your information to receive the files you need to complete this resource in your inbox.

Assumptions & Forecast Controls

Your starting point

Open your completed CP03 workbook. Compare with the matching cumulative reference only after attempting the exercise.

Your objective

  • Store all Base management assumptions in one place, one row per driver and one column per forecast year.
  • Distinguish fixed source facts, management forecasts and contractual/modeling rules; keep stored precision.
Source evidence / new releaseWhere to find it
Student source workbookD07_Base_Assumptions.xlsx (Base only)
Forecast years / unit2026–2030 in H:L; USD thousands unless row says units, days, ratios, $/unit or headcount
Current control stageBase selected (scenario 1). Preserve 2022–2025 history and opening balances.

Why this step matters

Forecast management assumptions are live drivers, not extra historical facts. For instance, receivable days change closing AR; supplier cost changes merchandise margin. Source facts are not automatically revised when forecasts change.

Build instructions

  • 1. Open D07_Base_Assumptions.xlsx, read its Orientation and Dictionary. Select the Base scenario values only.
  • 2. For every row in the Assumptions register, preserve one annual 2026–2030 number per driver. Input dollars in USD thousands and rates as stored ratios (0.06 means 6%).
  • 3. Keep 2022–2025 fixed facts locked conceptually; leave withheld scenario records and instructor benchmarks out.
  • 4. Check 45 management/convention assumption identifiers in each of five years, then keep Base selected. Do not create forecast earnings at this stage.

Cell-by-cell examples from the corresponding workbook

For rows in H, continue the formula pattern through L unless the source year or fixed absolute address requires a different copying direction. Historical E:G rows cover 2023–2025. Do not put forecast formulas into an unbuilt stage.

DestinationExact formula or fixed input (selected examples)
Assumptions!H150.06 (source/assumption; do not replace with another driver)
Assumptions!H160.03 (source/assumption; do not replace with another driver)
Assumptions!H170.035 (source/assumption; do not replace with another driver)
Assumptions!H261 (source/assumption; do not replace with another driver)
Assumptions!H300.045 (source/assumption; do not replace with another driver)
Assumptions!H4246 (source/assumption; do not replace with another driver)
Assumptions!H4365 (source/assumption; do not replace with another driver)
Assumptions!H4450 (source/assumption; do not replace with another driver)
Assumptions!H49350 (source/assumption; do not replace with another driver)
Assumptions!H523000 (source/assumption; do not replace with another driver)
Assumptions!H610.06 (source/assumption; do not replace with another driver)
Assumptions!H642500 (source/assumption; do not replace with another driver)
Assumptions!H65500 (source/assumption; do not replace with another driver)
Assumptions!H66430 (source/assumption; do not replace with another driver)

Verify after the exercise

Verification itemReference after the exercise
2026 safety volume-growth assumption6.000%
2026 revolving commitment2,500.00000

Common mistakes and repairs

  • A percent is 0.06 in storage, not 6; keep numeric forecast capex authoritative in D07.
  • Never overwrite the 2022–2025 historical facts to force a forecast result.

Interpretation questions

  • 1. Which assumptions are commercial preferences versus lender obligations?
  • 2. What forecast changes when the AR-days target increases by ten days?

Before moving to the next checkpoint

Confirm the intended cells for this stage, retain their formulas, restore Base assumptions and save a distinct working copy. Use the matching cumulative reference to review your work only afterward. A mathematically equivalent transparent formula is acceptable when signs, timing, controls and input response agree.

Next: Chapter 5 - Revenue Forecasting

How to get started

1
arrow-down-blue

Tell us about your project

2
arrow-down-blue

Interview candidates

(We’ll provide bios within 48 hours on average)

3

Select your consultant and start work

Find a Consultant in Our Retail Practice

or email us at: [email protected]