financial-scenario-planner
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChineseFinancial Scenario Planner
财务场景规划工具
Frameworks for building multi-scenario financial models, stress testing assumptions, sensitivity analysis, and probability-weighted financial planning.
用于构建多场景财务模型、压力测试假设、敏感性分析以及概率加权财务规划的框架。
Scenario Analysis Framework
场景分析框架
Three-Scenario Model
三场景模型
SCENARIO PLANNING TEMPLATE:
BEAR CASE BASE CASE BULL CASE
(Pessimistic) (Expected) (Optimistic)
Probability: 20-25% 50-60% 20-25%
REVENUE ASSUMPTIONS:
Growth rate: [X%] [X%] [X%]
New customers: [N] [N] [N]
Churn rate: [X%] [X%] [X%]
ARPU change: [X%] [X%] [X%]
Market size: [$ ] [$ ] [$ ]
COST ASSUMPTIONS:
COGS margin: [X%] [X%] [X%]
Headcount growth: [N] [N] [N]
Salary inflation: [X%] [X%] [X%]
Marketing spend: [$ ] [$ ] [$ ]
Capex: [$ ] [$ ] [$ ]
EXTERNAL FACTORS:
Interest rates: [X%] [X%] [X%]
Inflation: [X%] [X%] [X%]
FX rates: [X ] [X ] [X ]
Regulatory: [Impact] [Impact] [Impact]
PROJECTED OUTCOMES:
Revenue: [$ ] [$ ] [$ ]
EBITDA: [$ ] [$ ] [$ ]
Net income: [$ ] [$ ] [$ ]
Cash position: [$ ] [$ ] [$ ]
Runway (months): [N] [N] [N]
EXPECTED VALUE:
E[Revenue] = P(bear) x Rev(bear) + P(base) x Rev(base) + P(bull) x Rev(bull)SCENARIO PLANNING TEMPLATE:
BEAR CASE BASE CASE BULL CASE
(Pessimistic) (Expected) (Optimistic)
Probability: 20-25% 50-60% 20-25%
REVENUE ASSUMPTIONS:
Growth rate: [X%] [X%] [X%]
New customers: [N] [N] [N]
Churn rate: [X%] [X%] [X%]
ARPU change: [X%] [X%] [X%]
Market size: [$ ] [$ ] [$ ]
COST ASSUMPTIONS:
COGS margin: [X%] [X%] [X%]
Headcount growth: [N] [N] [N]
Salary inflation: [X%] [X%] [X%]
Marketing spend: [$ ] [$ ] [$ ]
Capex: [$ ] [$ ] [$ ]
EXTERNAL FACTORS:
Interest rates: [X%] [X%] [X%]
Inflation: [X%] [X%] [X%]
FX rates: [X ] [X ] [X ]
Regulatory: [Impact] [Impact] [Impact]
PROJECTED OUTCOMES:
Revenue: [$ ] [$ ] [$ ]
EBITDA: [$ ] [$ ] [$ ]
Net income: [$ ] [$ ] [$ ]
Cash position: [$ ] [$ ] [$ ]
Runway (months): [N] [N] [N]
EXPECTED VALUE:
E[Revenue] = P(bear) x Rev(bear) + P(base) x Rev(base) + P(bull) x Rev(bull)Scenario Trigger Events
场景触发事件
| Scenario Driver | Bear Trigger | Base Assumption | Bull Trigger |
|---|---|---|---|
| Market demand | Recession, -15% | Steady growth, +5% | Market expansion, +20% |
| Competition | New entrant takes 20% share | Stable competition | Competitor exits market |
| Regulation | Restrictive new regulation | Status quo | Deregulation/favorable policy |
| Technology | Disruption makes product obsolete | Incremental improvement | Breakthrough advantage |
| Funding | Cannot raise next round | Raise at expected terms | Oversubscribed round |
| Key personnel | Lose critical team members | Normal retention | Key strategic hires |
| 场景驱动因素 | 熊市触发条件 | 基准假设 | 牛市触发条件 |
|---|---|---|---|
| 市场需求 | 经济衰退,下降15% | 稳定增长,增长5% | 市场扩张,增长20% |
| 竞争环境 | 新进入者抢占20%市场份额 | 竞争格局稳定 | 竞争对手退出市场 |
| 监管政策 | 出台限制性新法规 | 维持现状 | 放松监管/出台利好政策 |
| 技术发展 | 技术颠覆导致产品过时 | 渐进式技术改进 | 突破性技术优势 |
| 融资情况 | 无法完成下一轮融资 | 按预期条款完成融资 | 融资超额认购 |
| 核心人员 | 流失关键团队成员 | 人员留存率正常 | 引入关键战略人才 |
Sensitivity Analysis
敏感性分析
One-Variable Sensitivity Table
单变量敏感性分析表
REVENUE SENSITIVITY TO PRICE CHANGE:
Price Change: -20% -10% Base +10% +20%
Volume Impact: +10% +5% Base -3% -8%
Revenue: [$ ] [$ ] [$ ] [$ ] [$ ]
Gross Profit: [$ ] [$ ] [$ ] [$ ] [$ ]
Net Income: [$ ] [$ ] [$ ] [$ ] [$ ]REVENUE SENSITIVITY TO PRICE CHANGE:
Price Change: -20% -10% Base +10% +20%
Volume Impact: +10% +5% Base -3% -8%
Revenue: [$ ] [$ ] [$ ] [$ ] [$ ]
Gross Profit: [$ ] [$ ] [$ ] [$ ] [$ ]
Net Income: [$ ] [$ ] [$ ] [$ ] [$ ]Two-Variable Sensitivity (Tornado Chart Data)
双变量敏感性分析(龙卷风图数据)
TORNADO CHART DATA — NET INCOME SENSITIVITY:
Variable | Low Value | High Value | Low Impact | High Impact
Revenue growth | 5% | 25% | -$500K | +$800K
Customer churn | 8% | 2% | -$400K | +$300K
COGS margin | 45% | 35% | -$350K | +$350K
Headcount | +15 | +5 | -$300K | +$200K
Interest rates | 7% | 4% | -$150K | +$100K
FX rates | -10% | +5% | -$120K | +$60K
INTERPRETATION:
- Revenue growth has the highest impact on outcomes
- Focus risk mitigation on top 3 variables
- Variables below $100K impact are noiseTORNADO CHART DATA — NET INCOME SENSITIVITY:
Variable | Low Value | High Value | Low Impact | High Impact
Revenue growth | 5% | 25% | -$500K | +$800K
Customer churn | 8% | 2% | -$40K | +$300K
COGS margin | 45% | 35% | -$350K | +$350K
Headcount | +15 | +5 | -$300K | +$200K
Interest rates | 7% | 4% | -$150K | +$100K
FX rates | -10% | +5% | -$120K | +$60K
INTERPRETATION:
- Revenue growth has the highest impact on outcomes
- Focus risk mitigation on top 3 variables
- Variables below $100K impact are noiseBreak-Even Analysis
盈亏平衡分析
BREAK-EVEN CALCULATOR:
FIXED COSTS (Monthly):
Salaries: $______
Rent/facilities: $______
SaaS/tools: $______
Insurance: $______
Other fixed: $______
TOTAL FIXED: $______
VARIABLE COSTS (per unit):
COGS: $______
Commission: $______
Payment processing: $______
Support cost: $______
TOTAL VARIABLE: $______
PRICING:
Average selling price: $______
Contribution margin: $______ (price - variable cost)
Contribution %: _____%
BREAK-EVEN:
Units: Fixed costs / Contribution margin = _____ units
Revenue: Fixed costs / Contribution % = $______
MONTHS TO BREAK-EVEN:
At current growth rate: _____ months
At optimistic rate: _____ months
At pessimistic rate: _____ monthsBREAK-EVEN CALCULATOR:
FIXED COSTS (Monthly):
Salaries: $______
Rent/facilities: $______
SaaS/tools: $______
Insurance: $______
Other fixed: $______
TOTAL FIXED: $______
VARIABLE COSTS (per unit):
COGS: $______
Commission: $______
Payment processing: $______
Support cost: $______
TOTAL VARIABLE: $______
PRICING:
Average selling price: $______
Contribution margin: $______ (price - variable cost)
Contribution %: _____%
BREAK-EVEN:
Units: Fixed costs / Contribution margin = _____ units
Revenue: Fixed costs / Contribution % = $______
MONTHS TO BREAK-EVEN:
At current growth rate: _____ months
At optimistic rate: _____ months
At pessimistic rate: _____ monthsMonte Carlo Simulation Design
蒙特卡洛模拟设计
Simulation Framework
模拟框架
MONTE CARLO SETUP:
STEP 1: IDENTIFY VARIABLES
List all uncertain inputs that affect the outcome.
For each variable, define:
- Distribution type (normal, uniform, triangular, lognormal)
- Parameters (mean, std dev, min, max)
STEP 2: DEFINE DISTRIBUTIONS
Revenue growth: Normal(mean=15%, std=5%)
Customer churn: Triangular(min=2%, mode=5%, max=12%)
COGS margin: Uniform(min=30%, max=45%)
Headcount growth: Discrete([5, 8, 10, 12, 15], probs=[0.1, 0.2, 0.4, 0.2, 0.1])
STEP 3: RUN SIMULATIONS
Iterations: 10,000 (minimum for stable results)
For each iteration:
1. Sample random value from each distribution
2. Calculate outcome (revenue, profit, cash flow)
3. Store result
STEP 4: ANALYZE RESULTS
Mean outcome: $______
Median outcome: $______
Standard deviation: $______
5th percentile (VaR): $______ (worst 5% of outcomes)
95th percentile: $______ (best 5% of outcomes)
Probability of loss: _____%
Probability of target: _____%
STEP 5: INTERPRET
"There is a 90% probability that net income will fall between
$______ and $______, with an expected value of $______."MONTE CARLO SETUP:
STEP 1: IDENTIFY VARIABLES
List all uncertain inputs that affect the outcome.
For each variable, define:
- Distribution type (normal, uniform, triangular, lognormal)
- Parameters (mean, std dev, min, max)
STEP 2: DEFINE DISTRIBUTIONS
Revenue growth: Normal(mean=15%, std=5%)
Customer churn: Triangular(min=2%, mode=5%, max=12%)
COGS margin: Uniform(min=30%, max=45%)
Headcount growth: Discrete([5, 8, 10, 12, 15], probs=[0.1, 0.2, 0.4, 0.2, 0.1])
STEP 3: RUN SIMULATIONS
Iterations: 10,000 (minimum for stable results)
For each iteration:
1. Sample random value from each distribution
2. Calculate outcome (revenue, profit, cash flow)
3. Store result
STEP 4: ANALYZE RESULTS
Mean outcome: $______
Median outcome: $______
Standard deviation: $______
5th percentile (VaR): $______ (worst 5% of outcomes)
95th percentile: $______ (best 5% of outcomes)
Probability of loss: _____%
Probability of target: _____%
STEP 5: INTERPRET
"There is a 90% probability that net income will fall between
$______ and $______, with an expected value of $______."Distribution Selection Guide
分布选择指南
| Variable Type | Recommended Distribution | Parameters | When to Use |
|---|---|---|---|
| Growth rate | Normal | Mean, Std Dev | Symmetric uncertainty |
| Market size | Lognormal | Mean, Std Dev | Right-skewed, can't be negative |
| Project cost | Triangular | Min, Mode, Max | Expert estimates with bounds |
| Binary events | Bernoulli | Probability | Will/won't happen (regulation, deal) |
| Time to event | Exponential | Rate | Customer lifetime, time to churn |
| Counts | Poisson | Rate | Number of events in a period |
| 变量类型 | 推荐分布 | 参数 | 使用场景 |
|---|---|---|---|
| 增长率 | 正态分布 | 均值、标准差 | 不确定性呈对称分布 |
| 市场规模 | 对数正态分布 | 均值、标准差 | 右偏分布,数值不能为负 |
| 项目成本 | 三角分布 | 最小值、众数、最大值 | 基于专家估算且有明确上下限 |
| 二元事件 | 伯努利分布 | 概率 | 事件发生/不发生(如监管政策、交易达成) |
| 事件发生时间 | 指数分布 | 速率 | 客户生命周期、客户流失时间 |
| 事件计数 | 泊松分布 | 速率 | 某一时间段内的事件数量 |
Cash Flow Stress Testing
现金流压力测试
Runway Calculator
现金流 Runway 计算器
CASH RUNWAY ANALYSIS:
Current cash: $______
Monthly burn rate: $______
Monthly revenue: $______
Net monthly cash flow: $______ (revenue - burn)
SCENARIO RUNWAYS:
Current trajectory: ______ months
If revenue drops 20%: ______ months
If revenue drops 50%: ______ months
If revenue goes to 0: ______ months (pure burn runway)
TRIGGER POINTS:
6-month runway remaining: Begin fundraise / cut costs
3-month runway remaining: Emergency cost reduction
1-month runway remaining: Wind-down planning
COST REDUCTION LEVERS (by impact):
Lever | Monthly Savings | Feasibility
Freeze hiring | $______ | High
Reduce marketing 50% | $______ | Medium
Renegotiate vendor terms | $______ | Medium
Reduce headcount 10% | $______ | Low (last resort)
Eliminate office space | $______ | MediumCASH RUNWAY ANALYSIS:
Current cash: $______
Monthly burn rate: $______
Monthly revenue: $______
Net monthly cash flow: $______ (revenue - burn)
SCENARIO RUNWAYS:
Current trajectory: ______ months
If revenue drops 20%: ______ months
If revenue drops 50%: ______ months
If revenue goes to 0: ______ months (pure burn runway)
TRIGGER POINTS:
6-month runway remaining: Begin fundraise / cut costs
3-month runway remaining: Emergency cost reduction
1-month runway remaining: Wind-down planning
COST REDUCTION LEVERS (by impact):
Lever | Monthly Savings | Feasibility
Freeze hiring | $______ | High
Reduce marketing 50% | $______ | Medium
Renegotiate vendor terms | $______ | Medium
Reduce headcount 10% | $______ | Low (last resort)
Eliminate office space | $______ | MediumPersonal Finance Stress Test
个人财务压力测试
PERSONAL FINANCIAL STRESS TEST:
INCOME SCENARIOS:
Current income: $______/month
Reduced income (-20%): $______/month
Job loss (0 income): $______/month
Disability (partial): $______/month
FIXED OBLIGATIONS:
Housing (mortgage/rent): $______
Insurance premiums: $______
Debt payments: $______
Utilities: $______
TOTAL FIXED: $______
EMERGENCY RESERVES:
Liquid savings: $______
Investment (accessible): $______
Credit available: $______
TOTAL RESERVES: $______
SURVIVAL METRICS:
Months covered (fixed only): ______
Months covered (full spending): ______
Months if income drops 20%: ______
Target: 6+ months of full spending coverage
WHAT-IF ANALYSIS:
"If [EVENT] happens, I can sustain for [N] months
by cutting [EXPENSES] and drawing on [RESERVES]."PERSONAL FINANCIAL STRESS TEST:
INCOME SCENARIOS:
Current income: $______/month
Reduced income (-20%): $______/month
Job loss (0 income): $______/month
Disability (partial): $______/month
FIXED OBLIGATIONS:
Housing (mortgage/rent): $______
Insurance premiums: $______
Debt payments: $______
Utilities: $______
TOTAL FIXED: $______
EMERGENCY RESERVES:
Liquid savings: $______
Investment (accessible): $______
Credit available: $______
TOTAL RESERVES: $______
SURVIVAL METRICS:
Months covered (fixed only): ______
Months covered (full spending): ______
Months if income drops 20%: ______
Target: 6+ months of full spending coverage
WHAT-IF ANALYSIS:
"If [EVENT] happens, I can sustain for [N] months
by cutting [EXPENSES] and drawing on [RESERVES]."Scenario Planning Process
场景规划流程
Workshop Format
工作坊流程
SCENARIO PLANNING WORKSHOP:
PHASE 1: IDENTIFY UNCERTAINTIES (30 min)
- List all factors that could impact the plan
- Rate each: Impact (1-5) x Uncertainty (1-5)
- Select top 2 with highest combined score
- These become the axes of your scenario matrix
PHASE 2: BUILD SCENARIOS (45 min)
Using the 2x2 matrix:
Factor A: Low Factor A: High
Factor B:
High Scenario 1: Scenario 2:
[Name and narrative] [Name and narrative]
Factor B:
Low Scenario 3: Scenario 4:
[Name and narrative] [Name and narrative]
PHASE 3: MODEL FINANCIALS (60 min)
For each scenario:
- Revenue projection (12-36 months)
- Cost structure changes
- Cash flow impact
- Key metrics (CAC, LTV, margins)
PHASE 4: DEVELOP STRATEGIES (45 min)
For each scenario:
- What would we do differently?
- What early warning signals would we see?
- What decisions should we make now?
- What options should we preserve?
PHASE 5: ACTION PLAN (30 min)
- "No regret" moves (good in all scenarios)
- Contingency triggers and responses
- Monitoring dashboard design
- Review cadence (quarterly recommended)SCENARIO PLANNING WORKSHOP:
PHASE 1: IDENTIFY UNCERTAINTIES (30 min)
- List all factors that could impact the plan
- Rate each: Impact (1-5) x Uncertainty (1-5)
- Select top 2 with highest combined score
- These become the axes of your scenario matrix
PHASE 2: BUILD SCENARIOS (45 min)
Using the 2x2 matrix:
Factor A: Low Factor A: High
Factor B:
High Scenario 1: Scenario 2:
[Name and narrative] [Name and narrative]
Factor B:
Low Scenario 3: Scenario 4:
[Name and narrative] [Name and narrative]
PHASE 3: MODEL FINANCIALS (60 min)
For each scenario:
- Revenue projection (12-36 months)
- Cost structure changes
- Cash flow impact
- Key metrics (CAC, LTV, margins)
PHASE 4: DEVELOP STRATEGIES (45 min)
For each scenario:
- What would we do differently?
- What early warning signals would we see?
- What decisions should we make now?
- What options should we preserve?
PHASE 5: ACTION PLAN (30 min)
- "No regret" moves (good in all scenarios)
- Contingency triggers and responses
- Monitoring dashboard design
- Review cadence (quarterly recommended)Reporting Templates
报告模板
Scenario Summary for Stakeholders
面向利益相关者的场景总结
FINANCIAL SCENARIO SUMMARY
Period: [Timeframe]
Prepared: [Date]
Author: [Name]
EXECUTIVE SUMMARY:
[2-3 sentences: key finding and recommended action]
SCENARIO OUTCOMES:
Bear Base Bull
Revenue: $____ $____ $____
EBITDA: $____ $____ $____
Cash (end): $____ $____ $____
Probability: ____% ____% ____%
Expected Value: $____ (probability-weighted)
KEY RISKS:
1. [Risk] — Impact: $____ — Mitigation: [Action]
2. [Risk] — Impact: $____ — Mitigation: [Action]
3. [Risk] — Impact: $____ — Mitigation: [Action]
RECOMMENDED ACTIONS:
1. [No-regret move that's good in all scenarios]
2. [Contingency to prepare now]
3. [Decision to make by specific date]
MONITORING:
KPI | Current | Trigger (Action Needed)
Monthly revenue | $____ | Below $____
Cash runway | ___ mo | Below 6 months
Customer churn | ____% | Above ____%FINANCIAL SCENARIO SUMMARY
Period: [Timeframe]
Prepared: [Date]
Author: [Name]
EXECUTIVE SUMMARY:
[2-3 sentences: key finding and recommended action]
SCENARIO OUTCOMES:
Bear Base Bull
Revenue: $____ $____ $____
EBITDA: $____ $____ $____
Cash (end): $____ $____ $____
Probability: ____% ____% ____%
Expected Value: $____ (probability-weighted)
KEY RISKS:
1. [Risk] — Impact: $____ — Mitigation: [Action]
2. [Risk] — Impact: $____ — Mitigation: [Action]
3. [Risk] — Impact: $____ — Mitigation: [Action]
RECOMMENDED ACTIONS:
1. [No-regret move that's good in all scenarios]
2. [Contingency to prepare now]
3. [Decision to make by specific date]
MONITORING:
KPI | Current | Trigger (Action Needed)
Monthly revenue | $____ | Below $____
Cash runway | ___ mo | Below 6 months
Customer churn | ____% | Above ____%See Also
相关链接
- Finance
- Risk Management
- Data Science
- 财务
- 风险管理
- 数据科学