Markdown Editor

Finance Case Analysis Template (Case Method, Teaching Note)

Decision maker and question, situation and issue diagnosis, WACC and NPV/IRR analysis, valuation, alternatives scoring, recommendation, implementation, teaching note

学術フルBusiness-school case method (HBS, Ivey named only)financecaseanalysismath

使い方: Use it when you write up a business-school corporate finance, valuation or investment case for class, an exam or a case competition. Fill the decision question and the financial analysis first, building your own exhibits from the case, then write the one-page summary last. The main pitfall is ranking alternatives by IRR or payback when they differ in size; compare NPV and capital at risk instead.

プレビュー

Finance Case Analysis: [Case title]

Written analysis of a business-school finance case for class submission, a case exam or a case competition: corporate finance (capital budgeting, cost of capital, financing and payout), valuation (DCF, multiples, transactions) and investment cases. It follows the case method used at business schools such as Harvard Business School and Ivey Business School (named for orientation only): identify the decision maker and the decision, analyse the situation with your own exhibits, compare alternatives against stated criteria, and recommend an action with an implementation plan. An optional teaching-note section supports instructors and competition coaches. Replace every [bracketed] value and every row marked Example. This is a document format, not financial, investment, tax, legal or accounting advice.

Document control

FieldValue
Document ID[CASE-001]
Case title[Case title]
Case reference[Author(s), publisher, product number, year]
Case type[Capital budgeting / Cost of capital / Financing / Payout / Valuation / M&A / Investment]
Course or competition[Course code and name / Competition name and round]
Instructor or judge panel[Name]
Authors[@student-1], [@student-2], [@student-3]
Submission limits[N pages plus N pages of exhibits; font; file format]
Due dateYYYY-MM-DD HH:MM
Version[0.1]
Status[Draft / Team review / Submitted / Graded]
Owner[@student-1]
Approvers/reviewers[@team-members], [@faculty-advisor]
Last updatedYYYY-MM-DD
Classification[Course use only]

Approvals

RoleNameDecisionDate
Team lead[@student-1][Approved for submission]YYYY-MM-DD
Team member[@student-2][Approved]YYYY-MM-DD
Faculty advisor (competitions)[@faculty-advisor][Reviewed]YYYY-MM-DD

Revision history

VersionDateAuthorChange
0.1YYYY-MM-DD[@student-1]Decision question, situation analysis
0.2YYYY-MM-DD[@student-2]Financial analysis and exhibits
1.0YYYY-MM-DD[@student-1]Submitted version

Contents

1. Case identification and decision maker

ItemValue
OrganisationLunaris Home Goods (fictional online home goods retailer, IFRS reporter, functional currency EUR, financial year = calendar year) (Example)
Decision maker[Name], Chief Financial Officer (Example)
Decision deadlineBoard meeting, [month year] (Example)
AuthorityCFO recommends; board approves capital expenditure above EUR 2.5m (Example)
Case date[Month year in which the case is set]
Currency and unitsEUR millions unless stated (Example)
Other stakeholdersHead of operations, Vietnam country manager, lenders, shareholders (Example)

Summarise the case in three sentences: who, what is at stake, why now.

Example: Lunaris Home Goods sells furniture, kitchenware and home textiles online to consumers in Europe and Southeast Asia. Order growth in Vietnam has outrun the third-party warehouse it uses, causing late deliveries and rising refunds. The CFO must recommend to the board how to add fulfilment capacity in Ho Chi Minh City within budget and without breaching the group's leverage covenant.

2. Executive summary and recommendation

Recommendation: [one sentence: what to do, how much, by when].

Example: Lease and fit out a fulfilment centre in phases (Alternative C), at an initial outlay of EUR 5.0m, with a pre-agreed trigger to expand if Vietnamese order volume exceeds [N] orders a day for two consecutive quarters.

PointSummary (Example)
ValuePositive NPV of EUR 3.29m at a 10.16% project discount rate; IRR 24.6%
RiskLowest capital at risk among the options that give operational control; NPV stays positive under every sensitivity tested
StrategyKeeps control of service quality, which is the cause of refunds, while preserving the option to build later
Main riskLease terms in the second phase; mitigated by negotiating an option on adjacent space now
What we gave upAlternative A has the highest NPV (EUR 4.81m) but puts EUR 12.0m at risk before demand is proven

3. Decision question and scope

Decision question: [Should / how should] [decision maker] [action] given [binding constraint]?

Example: How should Lunaris add fulfilment capacity in Vietnam over the next eight years to fix delivery performance, while keeping net debt to EBITDA below the 2.5x covenant?

In scopeOut of scope
Options for fulfilment capacity in Vietnam (Example)Expansion into new countries (Example)
Financing of the chosen option within the existing facility (Example)Refinancing the group capital structure (Example)
Eight-year evaluation horizon (Example)Product pricing decisions (Example)

4. Situation analysis

4.1 Business and industry

[Business model, revenue drivers, cost structure, competitors, market growth, regulation. Cite case exhibits by number.]

4.2 Financial position

Build a short exhibit from the case financials. Show the ratios that bear on the decision.

Metric (Example)FY2025CalculationComment
Revenue240.0Case Exhibit [N]Growing 18% a year
EBITDA31.2Case Exhibit [N]
EBITDA margin13.0%31.2 / 240.0Below listed peers
Net debt54.6Borrowings less cash
Net debt / EBITDA1.75x54.6 / 31.2Covenant maximum 2.5x
EBIT19.2Case Exhibit [N]
Interest cover6.0x19.2 / 3.2Interest expense 3.2

Headroom check: at the covenant maximum of 2.5x, net debt could reach 2.5 x 31.2 = EUR 78.0m, so the debt-funded headroom is 78.0 - 54.6 = EUR 23.4m before any EBITDA change. A EUR 12.0m build fits, but uses more than half of it.

4.3 Constraints and stakeholder positions

StakeholderPositionEvidence in the caseImplication
Head of operations (Example)Wants own buildingInterview, case p. [N]Values control over cost
Vietnam country manager (Example)Wants speedRefund trend exhibitValues time to capacity
Lenders (Example)Covenant 2.5xFacility summaryLimits debt funding

5. Issue diagnosis

IDIssueSymptom or causeEvidencePriority
ISS-001 (Example)Capacity shortfallCauseUtilisation above 95% for 6 monthsHigh
ISS-002 (Example)Picking accuracyCauseError rate trendHigh
ISS-003 (Example)Late deliveriesSymptomCustomer complaintsFollows from 001 and 002
ISS-004 (Example)Forecast errorContributingVariance to planMedium

6. Financial analysis

6.1 Cash flow rules

  • Use incremental, after-tax cash flows: include opportunity costs and working capital; exclude sunk costs and allocated overheads that do not change.
  • Discount nominal cash flows at a nominal rate, real at real.
  • Keep financing out of project cash flows when you discount at WACC; financing effects are in the rate.
  • State the timing convention (end of year unless stated) and the terminal or salvage value.

6.2 Cost of capital

ke=rf+β×ERPk_e = r_f + \beta \times ERP
WACC=EVke+DVkd(1−t)WACC = \frac{E}{V} k_e + \frac{D}{V} k_d (1 - t)
Input (Example)ValueSource
Risk-free rate rfr_f3.0%Assumption A-01
Equity beta β\beta1.20Assumption A-02 (peer median, relevered)
Equity risk premium5.5%Assumption A-03
Cost of equity kek_e3.0% + 1.20 x 5.5% = 9.6%Computed
Pre-tax cost of debt kdk_d6.0%Facility margin plus base rate
Tax rate tt20%Assumption A-04
After-tax cost of debt6.0% x (1 - 0.20) = 4.8%Computed
Target weights E/V, D/V70% / 30%Assumption A-05
WACC0.70 x 9.6% + 0.30 x 4.8% = 6.72% + 1.44% = 8.16%Computed
Country risk premium for the project2.0%Assumption A-06
Project discount rate10.16%Computed

Say whether you add a country risk premium to the rate or adjust the cash flows instead, and why. Do not do both. Adding the premium to the whole WACC, as here, is a simplification; many practitioners add it to the cost of equity only, often scaled by the project's exposure to the country. Match currencies: discount EUR cash flows at a EUR rate, or convert VND cash flows at forecast forward rates before discounting.

6.3 Capital budgeting results

NPV=∑t=0TCFt(1+r)t,0=∑t=0TCFt(1+IRR)tNPV = \sum_{t=0}^{T} \frac{CF_t}{(1+r)^t}, \qquad 0 = \sum_{t=0}^{T} \frac{CF_t}{(1+IRR)^t}

Incremental cash flows, EUR millions, end of year, year 8 includes salvage value (A: 1.5, C: 0.5):

Year (Example)012345678
A Build own centre-12.02.02.83.23.43.43.43.44.9
B Expand third-party contract-1.50.850.850.850.850.850.850.850.85
C Phased lease and fit-out-5.01.01.41.61.71.71.71.72.2
Measure at 10.16% (Example)A BuildB Third partyC Phased lease
Initial outlay12.01.55.0
PV of inflows16.814.518.29
NPV4.813.013.29
IRR19.2%55.0%24.6%
Profitability index (PV inflows / outlay)1.403.011.66
Simple payback (years)4.21.83.6
Undiscounted net cash flow14.55.38.0

Read the results with care. B has the highest IRR and profitability index because its outlay is small; IRR and payback rank projects of different size badly. NPV measures value added, so A ranks first on value, C second and B third. The question is whether the extra EUR 1.52m of NPV in A over C justifies EUR 7.0m more capital at risk.

6.4 Sensitivity and scenarios

NPV, EUR m (Example)A BuildB Third partyC Phased lease
Base case (10.16%)4.813.013.29
Discount rate +2 pp (12.16%)3.532.702.66
Discount rate -2 pp (8.16%)6.263.364.00
Operating cash flows -10% (years 1 to 8, salvage unchanged)3.202.562.48
Break-even: cut in operating cash flows that sets NPV to zero29.8%66.7%40.8%

All three options keep a positive NPV in every case tested. The break-even line divides each NPV by the present value of operating inflows (excluding salvage): A loses all its value if operating cash flows fall by about 30%, C only at about 41%. Compare these margins with the forecast error in the case history: if past forecasts missed by 25%, A has little room left. Where the case gives probabilities, show scenario-weighted NPV; otherwise state the scenarios and their triggers without inventing probabilities.

6.5 Valuation cases

When the case asks what a company or stake is worth, show at least two methods and reconcile them.

MethodKey inputsValue rangeWeightWhy this weight
DCF (free cash flow to firm)Forecast, WACC, terminal growth or exit multiple[Range][%][Reason]
Trading comparablesPeer set, EV/EBITDA, P/E[Range][%][Reason]
Precedent transactionsDeal set, control premium[Range][%][Reason]
Total[Point estimate]100%
EV=∑t=1NFCFFt(1+WACC)t+FCFFN+1(WACC−g)(1+WACC)NEV = \sum_{t=1}^{N} \frac{FCFF_t}{(1+WACC)^t} + \frac{FCFF_{N+1}}{(WACC - g)(1+WACC)^N}

Check that the terminal growth rate gg is below long-run nominal GDP growth and that terminal value is not an implausible share of the total. For a full valuation deliverable, use Valuation Report (finance/valuation-report); for one method in depth, Comparable Companies Analysis (finance/comparable-companies-analysis).

6.6 Financing and payout cases

When the decision is how to fund or how much to return, show the effect on leverage, coverage, earnings per share and rating headroom for each option, and the covenant test after the transaction.

Measure (Example)BeforeAfter A (debt funded)After C (debt funded)
Net debt, EUR m54.666.659.6
Net debt / EBITDA (FY2025 EBITDA 31.2)1.75x2.13x1.91x
Headroom to 2.5x covenant, EUR m23.411.418.4

7. Alternatives

IDAlternativeDescriptionMain advantageMain drawback
ALT-0 (Example)Status quoStay with current third-party warehouse at current capacityNo outlayRefunds keep rising; does not answer the question
ALT-A (Example)Build own centrePurchase land use rights and build a 20,000 m2 centreHighest NPV; full controlEUR 12.0m at risk; 18-month build
ALT-B (Example)Expand third-party contractLarger space with the current provider, with service-level penaltiesFast, low outlayControl over accuracy stays limited
ALT-C (Example)Phased lease and fit-outLease a building, fit out half now, half on a demand triggerControl plus flexibilityLease renewal risk

8. Evaluation criteria and scoring

Scores from 1 (poor) to 5 (strong). Weighted score = sum of weight x score.

CriterionWeightA BuildB Third partyC Phased lease
Value created (NPV)35%534
Downside risk and capital at risk25%244
Control of service quality20%524
Flexibility (options to expand or exit)10%245
Execution speed and complexity10%253
Weighted score (Example)100%3.653.354.00

Working for C: 0.35 x 4 + 0.25 x 4 + 0.20 x 4 + 0.10 x 5 + 0.10 x 3 = 1.40 + 1.00 + 0.80 + 0.50 + 0.30 = 4.00. Test whether the ranking holds if the value weight rises to 50% (taking 15 points from downside risk); if it flips, say so and explain why you keep or change the answer.

Example: with value at 50% and downside risk at 10%, A scores 0.50 x 5 + 0.10 x 2 + 0.20 x 5 + 0.10 x 2 + 0.10 x 2 = 4.10 and C scores 4.00, so the ranking flips. We keep C because the board has signalled that capital at risk before demand is proven is its main concern (case p. [N]); say this openly in the presentation rather than hiding the flip.

9. Recommendation

[Recommendation in two or three paragraphs: the action, the amount, the timing, the reasons and the conditions that would change it.]

Example: Recommend Alternative C. It creates EUR 3.29m of value at the project discount rate, keeps net debt to EBITDA at 1.91x after funding, and fixes the root cause of refunds by bringing picking operations in house. It gives up EUR 1.52m of base-case NPV relative to building, but avoids committing EUR 12.0m before demand in Vietnam is proven. Revisit the build option if daily orders exceed the expansion trigger for two consecutive quarters, or if the lease cannot be renewed on terms within [N]% of the current rent.

10. Implementation, risks and contingencies

IDRiskLikelihoodImpactMitigationOwner
RSK-001 (Example)Lease renewal on worse termsMediumHighNegotiate renewal option and adjacent-space option now[@cfo]
RSK-002 (Example)Order growth slower than forecastMediumMediumPhase 2 only on trigger[@country-manager]
RSK-003 (Example)FX: EUR-funded outlay, VND operating costsMediumLowNatural hedge from local revenue; review with the treasury policy[@treasurer]
RSK-004 (Example)Staffing and training delayLowMediumHire supervisors before fit-out completes[@head-of-operations]
KPI (Example)BaselineTarget after 12 months
On-time delivery[%][%]
Refund rate[%][%]
Cost per order, EUR[Value][Value]

11. Assumptions log

IDAssumptionValueBasisSensitivity tested
A-01 (Example)Risk-free rate3.0%[Government bond yield as of case date, source]Rate +/- 2 pp
A-02 (Example)Equity beta1.20Peer median, relevered at target D/ERate +/- 2 pp
A-03 (Example)Equity risk premium5.5%[Survey or textbook source]Rate +/- 2 pp
A-04 (Example)Tax rate20%[Case statement or statutory rate as of case date]Not tested
A-05 (Example)Target capital structure70% equity, 30% debtCase Exhibit [N] and management targetNot tested
A-06 (Example)Country risk premium2.0%[Source]Included in rate tests
A-07 (Example)Salvage valuesA 1.5, C 0.5Depreciated fit-out and resale estimates[Test]
A-08 (Example)Cash flows nominal, end of yearConventionNot applicable

12. Class discussion and competition preparation

Likely questionOur answer in one lineSupporting exhibit
Why not build if NPV is highest? (Example)Capital at risk and covenant headroom; build stays open as a phase 36.3, 6.6
Is the 2% country premium double counting? (Example)Cash flows are base-case expectations, not haircut, so the premium is in the rate only6.2
What would change your mind? (Example)Order volume above trigger or lease terms outside range9

Rehearse answers aloud and time them: a good reply to a cold call or a judge's question takes under 30 seconds, gives the number first and points to the exhibit. When a questioner attacks an assumption you cannot defend, concede it, show the sensitivity that covers it (section 6.4) and explain why the recommendation still holds. Assign each team member the questions on the sections they wrote, and keep one person responsible for the numbers so the team never gives two different figures for the same NPV.

Numbers to know without notes: [NPV of the recommendation, IRR, covenant ratio after funding, the break-even assumption].

For case competitions, add: the time limit for the presentation, the slide count, the judging criteria as published by the organiser, and a rehearsal log with timings. Keep the same structure as this document so the deck and the written analysis tell one story.

13. Optional teaching note

13.1 Learning objectives

IDAfter the session, participants canEvidence
LO-01 (Example)Separate incremental from non-incremental cash flowsCash flow exhibit
LO-02 (Example)Build a project discount rate and justify a country risk adjustmentWACC exhibit
LO-03 (Example)Explain why IRR and payback can rank projects of different size wronglyRanking discussion
LO-04 (Example)Weigh value against flexibility and capital at riskScoring matrix

13.2 Audience and placement

[Course, level (MBA core, master's elective, executive education), prerequisite topics, position in the syllabus and session length.]

13.3 Assignment questions

  1. [Question that forces the decision.]
  2. [Question that requires the main calculation.]
  3. [Question about a qualitative trade-off.]

13.4 Session plan

BlockMinutesActivityBoard plan
Opening (Example)10Vote: build, outsource or lease?Vote tally
Analysis (Example)30Cash flows and WACC built from the classNPV table
Debate (Example)25Value versus flexibilityScoring matrix
Wrap-up (Example)10What the CFO did (if known) and lessonsThree takeaways
Total75

13.5 Expected analysis and common mistakes

Mistake (Example)Why it is wrongHow to redirect
Ranking by IRRIgnores scale of investmentAsk for NPV per euro of capital and the incremental IRR of A over C
Including allocated head-office costsNot incrementalAsk which costs change if the project is rejected
Discounting interest paymentsDouble counts financingAsk what the WACC already contains

13.6 Epilogue

[What happened after the case date, if public and if the case is based on a real organisation; otherwise state that the case is fictional.]

14. Appendix: calculations and exhibits

14.1 Exhibit list

ExhibitTitleSourceReferred to in
EX-01 (Example)Financial position and covenant headroomBuilt from case financials4.2
EX-02 (Example)Cost of capital buildAssumptions A-01 to A-066.2
EX-03 (Example)Cash flows and NPV by alternativeBuilt6.3
EX-04 (Example)Sensitivity tableBuilt6.4
EX-05 (Example)Scoring matrixBuilt8

14.2 Present value working for Alternative A

Discount factor at 10.16% for year tt is 1/(1.1016)t1/(1.1016)^t. Values in EUR millions, rounded to three decimals.

Year (Example)Cash flowPresent valueCumulative PV
0-12.0-12.000-12.000
12.01.816-10.184
22.82.307-7.877
33.22.394-5.483
43.42.309-3.175
53.42.096-1.079
63.41.9030.824
73.41.7272.551
84.92.2594.810

The discounted payback falls in year 6 (5 + 1.079 / 1.903 = 5.6 years). Simple payback: cumulative undiscounted cash flow is -0.6 after year 4, so payback is 4 + 0.6 / 3.4 = 4.2 years.

14.3 Model hygiene checklist

  • Inputs in one place, separated from calculations and outputs.
  • Every hard-coded number traced to the case or the assumptions log.
  • Signs consistent: outflows negative, inflows positive.
  • Units and currency labelled on every exhibit.
  • Totals cross-checked; scoring weights sum to 100%.
  • Spreadsheet file name and version recorded in Document control.

15. Glossary and references

15.1 Glossary

TermMeaning
Case methodTeaching by discussion of a real or realistic decision, where participants analyse and recommend before the class
Decision makerThe protagonist who must act, and whose constraints frame the analysis
Incremental cash flowThe change in the firm's cash flows caused by the decision
NPVNet present value: the sum of discounted cash flows, including the outlay
IRRInternal rate of return: the discount rate at which NPV is zero
Profitability indexPresent value of inflows divided by the initial outlay
WACCWeighted average cost of capital: the blended required return of debt and equity holders
CAPMCapital asset pricing model: cost of equity as risk-free rate plus beta times the equity risk premium
Country risk premiumAn extra return required for exposure to a country's economic and political risk
CovenantA financial condition in a loan agreement, such as a maximum net debt to EBITDA
Teaching noteThe instructor's plan for a case: objectives, questions, session plan and analysis

15.2 References

ReferenceUse
[Case: author(s), title, publisher, product number, year]The case analysed (cited, not reproduced)
[Corporate finance textbook: author(s), title, edition, publisher, year]Methods (cited, not reproduced)
[Data source for risk-free rate, ERP, peer betas, with date]Assumptions A-01 to A-03
Harvard Business Publishing and Ivey Publishing (case publishers, named for orientation)Source of licensed cases; obtain cases and teaching notes through your institution
Investment Appraisal (finance/investment-appraisal) and Valuation Report (finance/valuation-report)Practitioner versions of the same analysis

Standard and licence note

Structure aligned with the case method as practised in business-school finance teaching and case competitions, and with standard corporate finance techniques (incremental cash flow analysis, NPV and IRR, CAPM and WACC, sensitivity analysis and multi-criteria scoring), which are general methods and are explained here in original wording. Harvard Business School, Harvard Business Publishing, Ivey Business School and Ivey Publishing are named only to identify the method and the usual case sources; no case text, exhibit, teaching note or publisher material is reproduced, and this template is not affiliated with or endorsed by them. Published cases are copyrighted: obtain them through your institution and cite them. Lunaris Home Goods and all figures in the examples are fictional. This template is original text written for this collection. Check your course or competition rules for the current submission requirements before use. Template licence: MIT.

関連テンプレート