Free Cash Flow Sensitivity Analysis Tool

Analyze the impact of key assumptions on your projected Free Cash Flow.

1. Enter Initial Data & Assumptions

Initial Financials (Current Year - Year 0)

Revenue ($)

COGS as % of Revenue (%)

Operating Expenses as % of Revenue (%)

Depreciation as % of Revenue (%)

CAPEX as % of Revenue (%)

Non-Cash Working Capital (NCWC) as % of Revenue (%)

Tax Rate (%)

Projection & Base Case Assumptions

Projection Years

Base Revenue Growth Rate (%)

Base COGS as % of Revenue (%)

Base CAPEX as % of Revenue (%)

Base NCWC as % of Revenue (%)

Sensitivity Variables

Define ranges for sensitivity analysis. The tool will calculate total FCF for each step within the range, holding other variables constant at their base case values.

Revenue Growth Rate (%) - Min Revenue Growth Rate (%) - Max Revenue Growth Rate (%) - Step

COGS as % of Revenue (%) - Min COGS as % of Revenue (%) - Max COGS as % of Revenue (%) - Step

CAPEX as % of Revenue (%) - Min CAPEX as % of Revenue (%) - Max CAPEX as % of Revenue (%) - Step

Free Cash Flow Sensitivity Analysis Tool

1. Enter Initial Data & Assumptions

Initial Financials (Current Year - Year 0)

Projection & Base Case Assumptions

Sensitivity Variables

2. Free Cash Flow Sensitivity Analysis Results (Total FCF over Projection Period)

3. Detailed FCF Projections (Base Case)