Capstone · Week 3
Revenue Streams
Build a clear unit‑economics table. Use Goal Seek to hit a target margin and explain what price or volume you need.
Check expectations on Rubrics.
What to include
Make the math visible
- Assumptions: price, variable cost, fixed cost.
- Outputs: margin %, break‑even units, key drivers.
- Goal Seek: snapshot of inputs and the goal you solved for.
- Short note: what change improves margin the most?
Excel Requirements
Dynamic unit‑economics and break‑even
- Set up inputs for price, variable cost per unit, and monthly fixed cost.
- Compute contribution margin per unit and margin %.
- Compute break‑even units = fixed cost ÷ contribution per unit.
- Use Goal Seek to hit a target margin % by changing price or cost.
Quality Checks
Reliable numbers that update
- Inputs are clearly labeled; outputs change when inputs change.
- Break‑even formula is correct and uses references to inputs.
- Goal Seek notes show both the target and the changing cell.
- No hard‑coded totals; all key values come from formulas.
Submission
What to turn in
- Excel file with inputs, outputs, and a note about Goal Seek results.
- Short written explanation (4–6 sentences) of your main driver.