Sensitivity, Scenario, and Break-Even Analysis

What breaks the urgent-care yes

David Park presents tornado chart: NPV most sensitive to visits per day and payer reimbursement. Downside scenario (recession) still shows NPV > 0 but payback stretches. Break-even visits/day = 92 vs base 110.

Summit Health Systems is a multi-site outpatient healthcare operator considering expansion and refinancing and the anchor company for FIN 201. Latest annual revenue is $310M, $52M EBITDA (16.8% margin), and $180M net debt (3.5x net debt to EBITDA). CFO David Park and Treasurer Lina Morales manage 42 outpatient sites and a capital structure that links directly to the topics in this course: time value of money, cost of capital, capital budgeting, and valuation.

You will reuse the same reconciled workbook tabs across lessons so numbers tie from TVM through WACC to DCF. When a spreadsheet line disagrees with a lesson table, fix the assumption footnote before presenting to lenders or the board.

One-way sensitivity

Change one input, hold others; tornado charts rank drivers.

Scenario analysis

Coherent bundles: recession, rate shock, labor inflation.

Break-even volume and price

Solve for input where NPV=0 or EBIT=0.

Monte Carlo (preview)

Simulate input distributions for probability of NPV>0.

Decision triggers

Pre-write kill criteria: if visits < 95/day by month 9, pause marketing spend.

Part A

Part B

Break-even visits ≈ 92/day (NPV=0).

Part C

Check: Base NPV $4.2M within range ✓

Part D: Managerial read

Board approves with marketing trigger at 95 visits/day month 9.

Base NPV $3M. Visits −10% cuts NPV to $1M. Linear approximation: NPV at −5% visits?

Solution

Slope ≈ ($3M−$1M)/10% = $0.2M per 1% visits. −5% → $2M NPV (linear approx).

Check: Midpoint ✓

Write one kill criterion for Summit urgent-care.

Solution

If average visits/day < 95 in months 7-9, freeze lease marketing spend and review staffing plan.

Key takeaways

• Sensitivity ranks value drivers
• Scenarios bundle macro and ops shocks
• Break-even solves threshold inputs
• Summit NPV sensitive to visits and reimbursement
• Pair analysis with kill criteria

1. Build tornado chart for Summit project
2. Draft three scenarios with NPV
3. Return for quiz; start Unit 5: Financing the Firm

Applying Sensitivity, Scenario, and Break-Even Analysis at Summit Health Systems scale

When Summit Health Systems evaluates sensitivity, scenario, and break-even analysis, CFO David Park and Treasurer Lina Morales start from reconciled facts: $310M revenue, $52M EBITDA, $180M net debt, and 8.29% WACC on the assumptions tab. capital budgeting with NPV, IRR, and sensitivity is not abstract for an outpatient platform with 42 sites and payer collection cycles near 42 DSO days. A lesson concept becomes operational when tied to the same spreadsheet tabs used in committee: cash flow, debt schedule, returns, and valuation bridge.

Consider how a 50 basis point change in WACC affects Summit's urgent-care NPV. At roughly $18.5M capEx and mid-single-digit million annual free cash flows, NPV shifts by several hundred thousand dollars without any visit volume change. That sensitivity is why David Park insists every recommendation show a rate and margin band, not a single hero number. Finance credibility at Summit comes from reconciled tables that survive lender diligence, not from precision without footnotes.

The capital budgeting with NPV, IRR, and sensitivity workflow deliberately separates historical actuals, forecast assumptions, and market-implied data (comps, yields). Historical cash bridges explain why the revolver drew despite positive EBITDA. Forecast paths feed NPV and DCF. Market yields price bonds and inform cost of debt. When those layers blur, teams argue from incompatible baselines. Label each input in your FIN 201 workbook: actual FY2025, budget FY2026, or market as-of date.

Document definitions alongside every metric. Summit's EBITDA add-backs list legal settlements and start-up losses at de novo sites. Net debt includes revolver drawn balance and capitalized leases per lender definition. WACC uses market equity value from the last PE mark unless public trading exists. Cost of debt blends note coupon, term loan margin, and commitment fees on undrawn revolver capacity when computing marginal financing. When definitions live in one dictionary, the organization builds memory instead of re-litigating the same bridge each quarter.

Extended Summit scenario: cross-functional read for Sensitivity, Scenario, and Break-Even Analysis

Imagine Summit's quarterly review for sensitivity, scenario, and break-even analysis. Operations reports visit growth and staffing ratios by site cluster. Treasury reports forward SOFR curve and bond mark-to-market. Strategy proposes two urgent-care markets with different payer density. A weak capital budgeting with NPV, IRR, and sensitivity answer addresses only one function. A strong answer shows how evidence flows: cash bridge explains liquidity, CAPM and comps set hurdle and valuation band, NPV and IRR rank projects, sensitivity states kill criteria before capEx commits.

Work a conservative arithmetic example on $310M revenue scale. Suppose reimbursement pressure trims EBITDA margin 40 bps next year while visit volume still grows 4%. EBITDA dollars may flatline even as accounting revenue rises, a classic outpatient pattern when rate and volume move opposite directions. Finance should show both margin and volume drivers in project cash flows, not a single consolidated growth assumption. Pair the downside with covenant math: net debt/EBITDA at 3.5x has limited headroom to a 4.0x covenant if EBITDA slips 8% without paydown.

Stakeholder conflict is normal. Sponsors want IRR above 14.2% on roll-ups. Lenders want deleveraging toward 3.0x. Operators want imaging and IT maintenance funded. Sensitivity, Scenario, and Break-Even Analysis gives language to negotiate with explicit tradeoffs: delaying one cluster frees $18.5M capEx and $0.6M annual interest if paired with paydown, but may forgo positive NPV if visits materialize. Present those forks with reconciled spreadsheets, not adjectives.

Translate lessons to your own context by replacing Summit names while keeping structure. Pick one capital decision you face. Write decision ask, incremental cash flows, discount rate with components, downside scenario, and equity bridge footnotes before recommending. If you cannot write those elements, you are not ready to present to a board regardless of how polished the slides look.

Spreadsheet discipline and FIN 201 integration (Sensitivity, Scenario, and Break-Even Analysis)

Summit's master model links capital budgeting with NPV, IRR, and sensitivity to prior units explicitly. Time value lessons justify discount factors on the NPV tab. Bond lessons feed cost of debt and duration discussion in treasury memos. CAPM populates cost of equity. WACC becomes the hurdle on capital budgeting. DCF and comps converge on enterprise value, then equity per share. Sensitivity, Scenario, and Break-Even Analysis should be traceable across tabs: change WACC in assumptions and watch NPV, DCF equity, and implied EV/EBITDA move together.

Use check lines after every major section. Cash bridge ending cash must match balance sheet cash movement. NPV sum of PVs must equal spreadsheet NPV function. Enterprise value minus net debt must equal equity value on the bridge. Per-share value times diluted shares must reconcile to equity within rounding. David Park's team rejects models that fail two checks, even if strategic narrative is compelling.

If you are studying outside healthcare, substitute your company but keep numeric discipline. A SaaS firm replaces visits with ARR and churn; a manufacturer replaces payer mix with customer concentration. The habits from FIN 201 remain: define terms, show checks, separate historical from forecast, and tie recommendations to kill criteria under uncertainty.

ACC 101 (Financial Accounting) taught statement articulation; ACC 102 (Managerial Accounting) taught operational margins. FIN 201 completes the loop from accounting outputs to discount rates and investment decisions. When you present to executives, integrate the stack: accounting explains what happened, finance prices what to do next, and both must reconcile to the same cash timeline.

Judgment under uncertainty: Sensitivity, Scenario, and Break-Even Analysis at Summit

Uncertainty is not an excuse for delay; it is a reason for structured scenarios and real options. Sensitivity, Scenario, and Break-Even Analysis equips you to state what you know, what you assume, and what would falsify the recommendation. For Summit urgent-care, falsifiers include reimbursement cuts, visit shortfalls, and WACC spikes from rating downgrade. Each falsifier maps to a metric owner and review date.

Probability-weighted thinking helps boards. Instead of arguing single-point NPV $4.2M, finance presents base, recession, and rate-shock cases with assigned probabilities and expected NPV. The expected value is not always the decision; risk appetite and liquidity may favor a conservative case. The lesson is to make those preferences explicit rather than hiding them inside unstated assumptions.

Ethics appear when stretching payables, aggressive revenue recognition, or cherry-picked comps inflate valuation ahead of a transaction. FIN 201 emphasizes reconciliation precisely because small definitional shifts move EV/EBITDA multiples and equity bridges. Summit's CFO office should welcome dissenting scenarios from treasury and operations, then document why the committee chose one path. Dissent makes the model stronger, not weaker.

Applying Sensitivity, Scenario, and Break-Even Analysis at Summit Health Systems scale

When Summit Health Systems evaluates sensitivity, scenario, and break-even analysis, CFO David Park and Treasurer Lina Morales start from reconciled facts: $310M revenue, $52M EBITDA, $180M net debt, and 8.29% WACC on the assumptions tab. capital budgeting with NPV, IRR, and sensitivity is not abstract for an outpatient platform with 42 sites and payer collection cycles near 42 DSO days. A lesson concept becomes operational when tied to the same spreadsheet tabs used in committee: cash flow, debt schedule, returns, and valuation bridge.

Consider how a 50 basis point change in WACC affects Summit's urgent-care NPV. At roughly $18.5M capEx and mid-single-digit million annual free cash flows, NPV shifts by several hundred thousand dollars without any visit volume change. That sensitivity is why David Park insists every recommendation show a rate and margin band, not a single hero number. Finance credibility at Summit comes from reconciled tables that survive lender diligence, not from precision without footnotes.

The capital budgeting with NPV, IRR, and sensitivity workflow deliberately separates historical actuals, forecast assumptions, and market-implied data (comps, yields). Historical cash bridges explain why the revolver drew despite positive EBITDA. Forecast paths feed NPV and DCF. Market yields price bonds and inform cost of debt. When those layers blur, teams argue from incompatible baselines. Label each input in your FIN 201 workbook: actual FY2025, budget FY2026, or market as-of date.

Document definitions alongside every metric. Summit's EBITDA add-backs list legal settlements and start-up losses at de novo sites. Net debt includes revolver drawn balance and capitalized leases per lender definition. WACC uses market equity value from the last PE mark unless public trading exists. Cost of debt blends note coupon, term loan margin, and commitment fees on undrawn revolver capacity when computing marginal financing. When definitions live in one dictionary, the organization builds memory instead of re-litigating the same bridge each quarter.

Extended Summit scenario: cross-functional read for Sensitivity, Scenario, and Break-Even Analysis

Imagine Summit's quarterly review for sensitivity, scenario, and break-even analysis. Operations reports visit growth and staffing ratios by site cluster. Treasury reports forward SOFR curve and bond mark-to-market. Strategy proposes two urgent-care markets with different payer density. A weak capital budgeting with NPV, IRR, and sensitivity answer addresses only one function. A strong answer shows how evidence flows: cash bridge explains liquidity, CAPM and comps set hurdle and valuation band, NPV and IRR rank projects, sensitivity states kill criteria before capEx commits.

Work a conservative arithmetic example on $310M revenue scale. Suppose reimbursement pressure trims EBITDA margin 40 bps next year while visit volume still grows 4%. EBITDA dollars may flatline even as accounting revenue rises, a classic outpatient pattern when rate and volume move opposite directions. Finance should show both margin and volume drivers in project cash flows, not a single consolidated growth assumption. Pair the downside with covenant math: net debt/EBITDA at 3.5x has limited headroom to a 4.0x covenant if EBITDA slips 8% without paydown.

Stakeholder conflict is normal. Sponsors want IRR above 14.2% on roll-ups. Lenders want deleveraging toward 3.0x. Operators want imaging and IT maintenance funded. Sensitivity, Scenario, and Break-Even Analysis gives language to negotiate with explicit tradeoffs: delaying one cluster frees $18.5M capEx and $0.6M annual interest if paired with paydown, but may forgo positive NPV if visits materialize. Present those forks with reconciled spreadsheets, not adjectives.

Translate lessons to your own context by replacing Summit names while keeping structure. Pick one capital decision you face. Write decision ask, incremental cash flows, discount rate with components, downside scenario, and equity bridge footnotes before recommending. If you cannot write those elements, you are not ready to present to a board regardless of how polished the slides look.

Spreadsheet discipline and FIN 201 integration (Sensitivity, Scenario, and Break-Even Analysis)

Summit's master model links capital budgeting with NPV, IRR, and sensitivity to prior units explicitly. Time value lessons justify discount factors on the NPV tab. Bond lessons feed cost of debt and duration discussion in treasury memos. CAPM populates cost of equity. WACC becomes the hurdle on capital budgeting. DCF and comps converge on enterprise value, then equity per share. Sensitivity, Scenario, and Break-Even Analysis should be traceable across tabs: change WACC in assumptions and watch NPV, DCF equity, and implied EV/EBITDA move together.

Use check lines after every major section. Cash bridge ending cash must match balance sheet cash movement. NPV sum of PVs must equal spreadsheet NPV function. Enterprise value minus net debt must equal equity value on the bridge. Per-share value times diluted shares must reconcile to equity within rounding. David Park's team rejects models that fail two checks, even if strategic narrative is compelling.

If you are studying outside healthcare, substitute your company but keep numeric discipline. A SaaS firm replaces visits with ARR and churn; a manufacturer replaces payer mix with customer concentration. The habits from FIN 201 remain: define terms, show checks, separate historical from forecast, and tie recommendations to kill criteria under uncertainty.

ACC 101 (Financial Accounting) taught statement articulation; ACC 102 (Managerial Accounting) taught operational margins. FIN 201 completes the loop from accounting outputs to discount rates and investment decisions. When you present to executives, integrate the stack: accounting explains what happened, finance prices what to do next, and both must reconcile to the same cash timeline.

Judgment under uncertainty: Sensitivity, Scenario, and Break-Even Analysis at Summit

Uncertainty is not an excuse for delay; it is a reason for structured scenarios and real options. Sensitivity, Scenario, and Break-Even Analysis equips you to state what you know, what you assume, and what would falsify the recommendation. For Summit urgent-care, falsifiers include reimbursement cuts, visit shortfalls, and WACC spikes from rating downgrade. Each falsifier maps to a metric owner and review date.

Probability-weighted thinking helps boards. Instead of arguing single-point NPV $4.2M, finance presents base, recession, and rate-shock cases with assigned probabilities and expected NPV. The expected value is not always the decision; risk appetite and liquidity may favor a conservative case. The lesson is to make those preferences explicit rather than hiding them inside unstated assumptions.

Ethics appear when stretching payables, aggressive revenue recognition, or cherry-picked comps inflate valuation ahead of a transaction. FIN 201 emphasizes reconciliation precisely because small definitional shifts move EV/EBITDA multiples and equity bridges. Summit's CFO office should welcome dissenting scenarios from treasury and operations, then document why the committee chose one path. Dissent makes the model stronger, not weaker.

Applying Sensitivity, Scenario, and Break-Even Analysis at Summit Health Systems scale

When Summit Health Systems evaluates sensitivity, scenario, and break-even analysis, CFO David Park and Treasurer Lina Morales start from reconciled facts: $310M revenue, $52M EBITDA, $180M net debt, and 8.29% WACC on the assumptions tab. capital budgeting with NPV, IRR, and sensitivity is not abstract for an outpatient platform with 42 sites and payer collection cycles near 42 DSO days. A lesson concept becomes operational when tied to the same spreadsheet tabs used in committee: cash flow, debt schedule, returns, and valuation bridge.

Consider how a 50 basis point change in WACC affects Summit's urgent-care NPV. At roughly $18.5M capEx and mid-single-digit million annual free cash flows, NPV shifts by several hundred thousand dollars without any visit volume change. That sensitivity is why David Park insists every recommendation show a rate and margin band, not a single hero number. Finance credibility at Summit comes from reconciled tables that survive lender diligence, not from precision without footnotes.

The capital budgeting with NPV, IRR, and sensitivity workflow deliberately separates historical actuals, forecast assumptions, and market-implied data (comps, yields). Historical cash bridges explain why the revolver drew despite positive EBITDA. Forecast paths feed NPV and DCF. Market yields price bonds and inform cost of debt. When those layers blur, teams argue from incompatible baselines. Label each input in your FIN 201 workbook: actual FY2025, budget FY2026, or market as-of date.

Document definitions alongside every metric. Summit's EBITDA add-backs list legal settlements and start-up losses at de novo sites. Net debt includes revolver drawn balance and capitalized leases per lender definition. WACC uses market equity value from the last PE mark unless public trading exists. Cost of debt blends note coupon, term loan margin, and commitment fees on undrawn revolver capacity when computing marginal financing. When definitions live in one dictionary, the organization builds memory instead of re-litigating the same bridge each quarter.

Extended Summit scenario: cross-functional read for Sensitivity, Scenario, and Break-Even Analysis

Imagine Summit's quarterly review for sensitivity, scenario, and break-even analysis. Operations reports visit growth and staffing ratios by site cluster. Treasury reports forward SOFR curve and bond mark-to-market. Strategy proposes two urgent-care markets with different payer density. A weak capital budgeting with NPV, IRR, and sensitivity answer addresses only one function. A strong answer shows how evidence flows: cash bridge explains liquidity, CAPM and comps set hurdle and valuation band, NPV and IRR rank projects, sensitivity states kill criteria before capEx commits.

Work a conservative arithmetic example on $310M revenue scale. Suppose reimbursement pressure trims EBITDA margin 40 bps next year while visit volume still grows 4%. EBITDA dollars may flatline even as accounting revenue rises, a classic outpatient pattern when rate and volume move opposite directions. Finance should show both margin and volume drivers in project cash flows, not a single consolidated growth assumption. Pair the downside with covenant math: net debt/EBITDA at 3.5x has limited headroom to a 4.0x covenant if EBITDA slips 8% without paydown.

Stakeholder conflict is normal. Sponsors want IRR above 14.2% on roll-ups. Lenders want deleveraging toward 3.0x. Operators want imaging and IT maintenance funded. Sensitivity, Scenario, and Break-Even Analysis gives language to negotiate with explicit tradeoffs: delaying one cluster frees $18.5M capEx and $0.6M annual interest if paired with paydown, but may forgo positive NPV if visits materialize. Present those forks with reconciled spreadsheets, not adjectives.

Translate lessons to your own context by replacing Summit names while keeping structure. Pick one capital decision you face. Write decision ask, incremental cash flows, discount rate with components, downside scenario, and equity bridge footnotes before recommending. If you cannot write those elements, you are not ready to present to a board regardless of how polished the slides look.

Spreadsheet discipline and FIN 201 integration (Sensitivity, Scenario, and Break-Even Analysis)

Summit's master model links capital budgeting with NPV, IRR, and sensitivity to prior units explicitly. Time value lessons justify discount factors on the NPV tab. Bond lessons feed cost of debt and duration discussion in treasury memos. CAPM populates cost of equity. WACC becomes the hurdle on capital budgeting. DCF and comps converge on enterprise value, then equity per share. Sensitivity, Scenario, and Break-Even Analysis should be traceable across tabs: change WACC in assumptions and watch NPV, DCF equity, and implied EV/EBITDA move together.

Use check lines after every major section. Cash bridge ending cash must match balance sheet cash movement. NPV sum of PVs must equal spreadsheet NPV function. Enterprise value minus net debt must equal equity value on the bridge. Per-share value times diluted shares must reconcile to equity within rounding. David Park's team rejects models that fail two checks, even if strategic narrative is compelling.

If you are studying outside healthcare, substitute your company but keep numeric discipline. A SaaS firm replaces visits with ARR and churn; a manufacturer replaces payer mix with customer concentration. The habits from FIN 201 remain: define terms, show checks, separate historical from forecast, and tie recommendations to kill criteria under uncertainty.

ACC 101 (Financial Accounting) taught statement articulation; ACC 102 (Managerial Accounting) taught operational margins. FIN 201 completes the loop from accounting outputs to discount rates and investment decisions. When you present to executives, integrate the stack: accounting explains what happened, finance prices what to do next, and both must reconcile to the same cash timeline.