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 release | Where to find it |
|---|---|
| Student source workbook | D07_Base_Assumptions.xlsx (Base only) |
| Forecast years / unit | 2026–2030 in H:L; USD thousands unless row says units, days, ratios, $/unit or headcount |
| Current control stage | Base 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.
| Destination | Exact formula or fixed input (selected examples) |
|---|---|
| Assumptions!H15 | 0.06 (source/assumption; do not replace with another driver) |
| Assumptions!H16 | 0.03 (source/assumption; do not replace with another driver) |
| Assumptions!H17 | 0.035 (source/assumption; do not replace with another driver) |
| Assumptions!H26 | 1 (source/assumption; do not replace with another driver) |
| Assumptions!H30 | 0.045 (source/assumption; do not replace with another driver) |
| Assumptions!H42 | 46 (source/assumption; do not replace with another driver) |
| Assumptions!H43 | 65 (source/assumption; do not replace with another driver) |
| Assumptions!H44 | 50 (source/assumption; do not replace with another driver) |
| Assumptions!H49 | 350 (source/assumption; do not replace with another driver) |
| Assumptions!H52 | 3000 (source/assumption; do not replace with another driver) |
| Assumptions!H61 | 0.06 (source/assumption; do not replace with another driver) |
| Assumptions!H64 | 2500 (source/assumption; do not replace with another driver) |
| Assumptions!H65 | 500 (source/assumption; do not replace with another driver) |
| Assumptions!H66 | 430 (source/assumption; do not replace with another driver) |
Verify after the exercise
| Verification item | Reference after the exercise |
|---|---|
| 2026 safety volume-growth assumption | 6.000% |
| 2026 revolving commitment | 2,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.