theonline.mba
← Back to unit 4: Capital Budgeting

FIN 201 · Unit 4 · Lesson 1 of 5

Net Present Value

Capital Budgeting

Lesson

The sign that tells you to build or walk

Summit's Phoenix urgent-care cluster shows NPV (net present value, PV of cash inflows minus outflows at hurdle rate*) of $4.2M at 8.29% WACC. David Park recommends proceed; NPV > 0 means value creation if assumptions hold.

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.

NPV decision rule

Accept independent projects with NPV > 0; reject NPV < 0. Maximizes owner value under assumptions.

Incremental cash flows

Only cash flows that change because of the project; exclude sunk costs.

Discount rate

Use WACC for average-risk projects; adjust for riskier de novo sites if needed.

Working capital in NPV

Include startup receivables and inventory funding.

Salvage and terminal flows

End-of-life equipment sales and site closure costs.


Worked example: Summit urgent-care NPV (5-year sketch)

Part A

CapEx −$18.5M year 0. FCF years 1-5: $3.2M, $3.8M, $4.2M, $4.8M, $5.1M. WACC 8.29%.

Part B

PV inflows ≈ $16 ≈ $16.7M. NPV ≈ $16.7M − $18.5M? Need adjustment - let's use stated NPV $4.2M with 7-year horizon in full model.

Part C

Full workbook 7-year NPV $4.2M > 0 → accept. Check: NPV tab ties to cash flow tab ✓

Part D: Managerial read

Pair with liquidity check; positive NPV does not override covenant breach.


Worked example: Reject negative NPV IT project

EHR analytics module NPV −$1.2M at WACC; defer despite vendor ROI slides.


Common mistakes beginners make

MistakeReality
Including sunk feasibility spendOnly incremental flows
Using accounting profit undiscountedUse cash and discount
Wrong sign on capExOutflows negative
Ignoring working capitalUnderstates initial investment
Hurdle below WACCSubsidizes destroyers of value

Practice problem

−$10M, +$4M/yr years 1-3, r=9%. NPV?

Solution

PV = 4/1.09 + 4/1.09² + 4/1.09³ = $10.06M. NPV ≈ +$0.06M

Check: Near zero; marginal ✓


Practice problem 2

Why NPV preferred to payback alone?

Solution

NPV accounts for magnitude, timing, and risk via discount rate; payback ignores cash after cutoff and time value.

Key takeaways

  • NPV > 0 creates value at hurdle rate
  • Use incremental cash flows
  • Summit urgent-care NPV positive at WACC
  • Include working capital and salvage
  • NPV rule maximizes value

After this lesson

  1. Rebuild Summit urgent-care NPV in Excel
  2. Identify one sunk cost to exclude
  3. Continue to Lesson 2: Internal Rate of Return

Applying Net Present Value at Summit Health Systems scale

When Summit Health Systems evaluates net present value, 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 Net Present Value

Imagine Summit's quarterly review for net present value. 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. Net Present Value 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 (Net Present Value)

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. Net Present Value 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: Net Present Value at Summit

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

When Summit Health Systems evaluates net present value, 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 Net Present Value

Imagine Summit's quarterly review for net present value. 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. Net Present Value 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 (Net Present Value)

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. Net Present Value 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: Net Present Value at Summit

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

When Summit Health Systems evaluates net present value, 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 Net Present Value

Imagine Summit's quarterly review for net present value. 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. Net Present Value 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 (Net Present Value)

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. Net Present Value 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.

Lesson exercise

35 min

Urgent-Care NPV Model

1. Solve marginal NPV practice cold. 2. Open Summit urgent-care cash flows; compute NPV at 8.29% WACC. 3. Check NPV ≈ $4.18M vs lesson. 4. List two incremental costs excluded as sunk.

Deliverable

NPV tab with CF schedule and check to lesson NPV.

Rubric

  • WACC matches assumptions tab
  • CapEx signed negative at t=0
  • NPV check line within rounding
  • Sunk costs excluded with labels