FIN 201 · Unit 1 · Lesson 4 of 5
Present and Future Value
Financial Decision Foundations
Lesson
The calculator every CFO keeps open
Lina Morales priced two refinancing options: pay $1.8M fees today to save $2.8M interest over five years. Before recommending, she converted every fee and savings stream to present value (PV, value today*) using Summit's after-tax borrowing cost.
Future value (FV, compounded worth at a future date*) answers savings questions: what idle cash grows to if invested. PV answers investment questions: what future benefits are worth today. FIN 201 expects you to move both directions with a timeline, not memorized buttons only.
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.
Single-period formulas
FV = PV × (1 + r)^n and PV = FV / (1 + r)^n for a single cash flow. For n = 1, FV = PV × (1 + r).
Always match r to the period: annual rate with annual periods; divide annual rate by 12 only if cash flows are monthly.
Multiple cash flows on a timeline
Real projects spit out sequences. PV of a stream is the sum of each flow's PV. Summit's refinancing saves $560K per year for five years; each year discounts separately.
Calculator and spreadsheet hygiene
Document: CF0, CF1..CFn, rate, period convention. David Park's team stores rate assumptions in a locked assumptions tab so auditors can reproduce PV.
Sign convention: outflows negative, inflows positive. Mixing signs inverts NPV silently.
After-tax versus pretax rates
Debt-related decisions often use after-tax cost: r_after = r_pretax × (1 − tax rate). Summit tax rate 25%, term loan 7.8% → after-tax ≈ 5.85% for refunding analysis.
Link to bond and stock lessons
Bond prices are PV of coupons plus principal. Stock dividends are PV of expected payouts. The mechanics you practice here reappear in Units 2 and 6.
Worked example: Summit refinancing fee tradeoff
Part A: Cash flows
Today: fee outflow −$1.8M Years 1-5: interest savings +$560K/year (pretax) Discount at after-tax cost of debt 5.85%
Part B: PV of savings
PV annuity factor 5 years at 5.85% ≈ 4.24 PV savings ≈ $560K × 4.24 = $2.37M NPV ≈ $2.37M − $1.8M = $0.57M
Check: PV benefits > fee; positive NPV ✓
Part C: FV check
If fees stay in cash earning 4.2%, FV in 5 years: $1.8M × (1.042)^5 = $2.20M, still below cumulative savings PV at risk-adjusted rates.
Part D: Managerial read
Recommend proceed if legal and covenant review clears; attach sensitivity at ±100 bps on rates.
Worked example: Lump sum vs phased capEx
Urgent-care build: $18.5M today vs $10M now + $9M in 12 months. Discount second tranche at 8%: PV = $10M + $9M/1.08 = $18.33M. Phasing saves ~$170K PV if second tranche can be delayed without penalty.
Check: $9M/1.08 = $8.33M; total $18.33M ✓
Common mistakes beginners make
| Mistake | Reality |
|---|---|
| Using FV formula for uneven streams without summing | Discount each flow |
| Annual rate on monthly flows without adjustment | Convert rate or period |
| Forgetting fees in NPV | Include all incremental cash flows |
| Pretax savings with after-tax rate mismatch | Be consistent on tax treatment |
| Wrong sign on outflows | Outflows negative in NPV mode |
Practice problem
Cash flows: −$5M today, +$2M year 1, +$2.5M year 2, +$3M year 3. Discount at 9%. Compute NPV.
Solution
PV = −$5M + $2M/1.09 + $2.5M/(1.09)^2 + $3M/(1.09)^3
= −$5M + $1.83M + $2.10M + $2.32M = $1.25M
Check: Sum of positive PVs $6.25M − $5M ✓
Practice problem 2
Summit wins a $4M grant payable in 18 months. Risk-free 4.2%. PV? Why might David Park still discount at 7%?
Solution
18-month PV at 4.2%: $4M / (1.042)^1.5 ≈ $3.76M.
Higher rate reflects grant compliance risk, clawback, or spending restrictions delaying deployment.
Key takeaways
- PV sums future cash at a stated discount rate
- FV compounds today's cash forward
- Refinancing decisions compare PV of costs and benefits
- After-tax rates apply to debt-related cash flows
- Signs and period conventions must be explicit
After this lesson
- Replicate Summit refinancing NPV in a spreadsheet with a check line
- Find a 10-K note that discusses present value of lease liabilities
- Continue to Lesson 5: Annuities, Perpetuities, and Growing Cash Flows
Applying Present and Future Value at Summit Health Systems scale
When Summit Health Systems evaluates present and future 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. financial decision foundations and time value of money 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 financial decision foundations and time value of money 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 Present and Future Value
Imagine Summit's quarterly review for present and future 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 financial decision foundations and time value of money 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. Present and Future 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 (Present and Future Value)
Summit's master model links financial decision foundations and time value of money 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. Present and Future 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: Present and Future Value at Summit
Uncertainty is not an excuse for delay; it is a reason for structured scenarios and real options. Present and Future 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 Present and Future Value at Summit Health Systems scale
When Summit Health Systems evaluates present and future 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. financial decision foundations and time value of money 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 financial decision foundations and time value of money 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 Present and Future Value
Imagine Summit's quarterly review for present and future 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 financial decision foundations and time value of money 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. Present and Future 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 (Present and Future Value)
Summit's master model links financial decision foundations and time value of money 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. Present and Future 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: Present and Future Value at Summit
Uncertainty is not an excuse for delay; it is a reason for structured scenarios and real options. Present and Future 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 Present and Future Value at Summit Health Systems scale
When Summit Health Systems evaluates present and future 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. financial decision foundations and time value of money 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 financial decision foundations and time value of money 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 Present and Future Value
Imagine Summit's quarterly review for present and future 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 financial decision foundations and time value of money 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. Present and Future 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.
Lesson exercise
35 minRefinancing NPV Spreadsheet
Deliverable
Spreadsheet tab Refi_NPV with base and sensitivity rows.
Rubric
- • Annuity PV formula or NPV() matches lesson
- • Fee included as t=0 outflow
- • Check line compares PV benefits to fees
- • Sensitivity shows directional impact