Discounted Cash-Flow Valuation

The full Summit DCF on one page

David Park's DCF (discounted cash flow valuation) forecasts unlevered FCF, discounts at 8.29% WACC, adds terminal value at 2.5% growth, and bridges to equity. This is the anchor spreadsheet for FIN 201.

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.

Forecast horizon

5-10 explicit years until business reaches steady state.

Unlevered FCF build

From revenue to EBIT(1−T), add D&A, subtract capEx and ΔNWC.

Terminal value

Growing perpetuity on year T+1 FCF: TV = FCF_{T+1}/(WACC−g).

PV and enterprise value

Sum PV explicit + PV terminal = EV.

Sensitivity and football field

WACC, g, and margin sensitivities in summary chart.

Part A

Base revenue $310M growing 6%. EBITDA margin 16.8% → stable FCF ramp.

Part B

PV explicit period ≈ $198M; TV at 2.5% g ≈ $274M PV → EV ≈ $472M

Part C

Equity $292M after $180M net debt. Check: EV − net debt = equity ✓

Part D: Managerial read

Triangulate with 8.5-9.5x EBITDA comps band.

TV often 55-70% of EV; flag if >80% (forecast-heavy valuation). Summit ~58% in base case.

Year 5 FCF $40M, grow 3%, WACC 9%. TV? PV if discount one period?

Solution

FCF6 = $41.2M. TV = 41.2/(0.09−0.03) = $687M at year 5. PV = 687/(1.09)^5 = $446M

Check: g < WACC ✓

Two reasons DCF differs from comps for Summit.

Solution

Different growth/margin assumptions; control premium in transaction comps vs public trading.

Key takeaways

• DCF sums PV of FCF and terminal value
• Use unlevered FCF with WACC
• Summit EV ≈ $472M base DCF
• Terminal assumptions drive sensitivity
• Bridge EV to equity

1. Complete Summit DCF spreadsheet with check lines
2. Build WACC-g sensitivity table
3. Continue to Lesson 3: Comparable Company Analysis

Applying Discounted Cash-Flow Valuation at Summit Health Systems scale

When Summit Health Systems evaluates discounted cash-flow valuation, 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. enterprise valuation, DCF, comps, and investment recommendations 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 enterprise valuation, DCF, comps, and investment recommendations 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 Discounted Cash-Flow Valuation

Imagine Summit's quarterly review for discounted cash-flow valuation. 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 enterprise valuation, DCF, comps, and investment recommendations 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. Discounted Cash-Flow Valuation 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 (Discounted Cash-Flow Valuation)

Summit's master model links enterprise valuation, DCF, comps, and investment recommendations 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. Discounted Cash-Flow Valuation 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: Discounted Cash-Flow Valuation at Summit

Uncertainty is not an excuse for delay; it is a reason for structured scenarios and real options. Discounted Cash-Flow Valuation 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 Discounted Cash-Flow Valuation at Summit Health Systems scale

When Summit Health Systems evaluates discounted cash-flow valuation, 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. enterprise valuation, DCF, comps, and investment recommendations 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 enterprise valuation, DCF, comps, and investment recommendations 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 Discounted Cash-Flow Valuation

Imagine Summit's quarterly review for discounted cash-flow valuation. 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 enterprise valuation, DCF, comps, and investment recommendations 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. Discounted Cash-Flow Valuation 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 (Discounted Cash-Flow Valuation)

Summit's master model links enterprise valuation, DCF, comps, and investment recommendations 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. Discounted Cash-Flow Valuation 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: Discounted Cash-Flow Valuation at Summit

Uncertainty is not an excuse for delay; it is a reason for structured scenarios and real options. Discounted Cash-Flow Valuation 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 Discounted Cash-Flow Valuation at Summit Health Systems scale

When Summit Health Systems evaluates discounted cash-flow valuation, 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. enterprise valuation, DCF, comps, and investment recommendations 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 enterprise valuation, DCF, comps, and investment recommendations 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 Discounted Cash-Flow Valuation

Imagine Summit's quarterly review for discounted cash-flow valuation. 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 enterprise valuation, DCF, comps, and investment recommendations 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. Discounted Cash-Flow Valuation 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 (Discounted Cash-Flow Valuation)

Summit's master model links enterprise valuation, DCF, comps, and investment recommendations 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. Discounted Cash-Flow Valuation 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.