Reusable worksheet

Case study worksheet

Copy this structure into slides, a spreadsheet, or your notes. The point is to force every recommendation to connect to a fact from the case.

1. Fact base

AreaWhat to record
HouseholdNames or client labels, ages, dependents, jobs, stated goals, time horizons.
IncomeGross income, after-tax income, predictable bonuses, benefits, employer matches.
AssetsChecking, savings, retirement, education accounts, vehicles, home equity, taxable investments.
DebtsBalance, rate, payment, term, collateral, whether the debt is secured or unsecured.
InsuranceHealth plan, life insurance, disability, renters/homeowners, auto, deductibles.
TaxesFiling status, credits/deductions, retirement account type, HSA/FSA eligibility, taxable events.

2. Assumption log

Because the cases are intentionally incomplete, assumptions are allowed when they are reasonable and clearly labeled.

3. Recommendation template

RecommendationCase factActionFunding sourceExpected result
Example: credit-card payoffHigh APR revolving balancePay minimums on all debts, then add extra cash to the highest APR card.Monthly surplus, reduced variable spending, or bonus/inheritance.Lower interest expense and improved cash flow.