Financial Statement Analysis Framework - Laundromat Expansion Case Study
This case study applies the Financial Statement Analysis framework from the finance curriculum to a real-world laundromat expansion decision. It walks through each step of the framework — from articulating purpose, to collecting and processing data, to communicating conclusions — grounding abstract concepts in a concrete business context. case-study
1. Articulate the Purpose and Context
The first step in any financial statement analysis is defining clear objectives. In this scenario, the analyst’s objectives center on expansion viability:
- Calculate profitability ratios (gross margin, operating margin, net margin, ROA, ROE) to understand current performance
- Assess debt capacity for expansion financing, connecting to capital structure theory
- Evaluate the financial position for either acquiring an existing laundromat or entering a 5-year lease with equipment financing
- Determine the optimal financing mix (credit cards, term loans, equipment financing)
Key Questions to Answer: ratio-analysis
The key questions map directly to ratios covered in the finance curriculum: the current debt-to-equity ratio (a leverage measure), the debt service coverage ratio (DSCR), whether the business can support additional debt payments, and the projected ROI on expansion.
2. Collect Data - App Requirements
Data collection is the foundation of reliable analysis. The finance curriculum emphasizes the importance of using multiple information sources beyond just financial reports. In a small business context, this means building systematic data capture from the ground up. data-collection
Source Documents to Track
Daily Operations encompass machine usage logs (revenue per machine), cash collections, credit card receipts, utility meter readings, supply inventory counts, and maintenance logs. These feed directly into the revenue and expense recognition discussed below.
Monthly Documents include bank statements, credit card statements, utility bills, rent/lease invoices, payroll records, insurance statements, and tax remittances. These form the basis for the periodic financial statements that the framework requires.
App Data Architecture
Revenue Module:
- Machine ID
- Transaction timestamp
- Payment method
- Amount
- Service type (wash/dry/combo)
Expense Module:
- Vendor
- Category (utilities/supplies/maintenance/labor)
- Invoice date/number
- Payment date
- Amount
Asset Module:
- Equipment inventory
- Purchase date/cost
- Depreciation schedule
- Maintenance history
Finance Connection
The asset module’s depreciation schedule connects to the HP 12c depreciation functions (
f SL,f SOYD,f DB) covered in the calculator guide.
3. Process Data - IFRS Compliance ifrs
Processing data means applying proper accounting standards. Under IFRS 15 (Revenue Recognition), revenue is recognized when the service is completed. Prepaid cards represent deferred revenue until the customer actually uses the wash — a concept that connects to the income statement analysis topics in the curriculum.
Key Ratios to Calculate ratio-analysis
The ratios below map to the Financial Analysis Techniques chapter and are calculator-friendly using the HP 12c:
Profitability:
- Gross Margin = (Revenue - Direct Costs) / Revenue
- EBITDA Margin = EBITDA / Revenue
- Net Margin = Net Income / Revenue
Leverage:
- Debt-to-Equity = Total Debt / Total Equity
- DSCR = EBITDA / Total Debt Service
- Interest Coverage = EBIT / Interest Expense
Efficiency:
- Revenue per Machine
- Utilization Rate = Actual Usage / Available Hours
- Customer Acquisition Cost
Common-size statements express all P&L items as a percentage of revenue and balance sheet items as a percentage of total assets. This technique, covered extensively in the finance FSA curriculum, makes comparisons across time periods and against competitors meaningful regardless of absolute size.
4. Analyze/Interpret - Dashboard Design
The analysis phase translates processed data into actionable intelligence. A well-designed dashboard mirrors the analytical hierarchy taught in the finance curriculum, moving from high-frequency operational data to strategic decision support. dashboard
Executive Dashboard Components
Daily Metrics track revenue against prior day, week, and year; a machine utilization heat map; and the current cash position. These provide the operational pulse that feeds into weekly and monthly analysis.
Weekly Metrics include revenue and expense run rates alongside working capital changes — connecting directly to the finance’s coverage of liquidity management.
Monthly Metrics form the core analytical output: a P&L with variance analysis, balance sheet snapshot, cash flow waterfall, and key ratios with trend lines. This is where the DuPont analysis and ratio decomposition from the curriculum become most practical.
Expansion Analysis Module brings in capital allocation concepts: scenario modeling (buy vs. lease), projected cash flows using TVM principles, break-even analysis, and financing options comparison.
5. Develop and Communicate Conclusions
Communicating conclusions requires translating quantitative findings into clear decision criteria. The decision framework below uses threshold-based rules that connect ratio analysis to action — a practical extension of the ethical standards around diligence and reasonable basis: decision-framework
IF DSCR > 1.5 AND Debt-to-Equity < 2.0
THEN: Strong position for expansion
IF Cash Flow covers new debt service + 20% buffer
THEN: Proceed with financing application
IF ROI on expansion > Cost of Capital + 5%
THEN: Project is financially viable
The final report structure follows professional standards: Executive Summary (1 page), Current Financial Position, Expansion Scenarios Analysis, Financing Recommendations, Risk Assessment, and Implementation Timeline. This mirrors the research report structure discussed in the Equity Investments topic on company analysis.
6. Follow-up - Monitoring Framework monitoring
The framework does not end with the initial analysis. Ongoing monitoring ensures the business stays on track and provides early warning signals — analogous to the risk management concepts in the finance curriculum.
Weekly Reviews cover revenue tracking vs. projection, expense monitoring, and cash position. Monthly Reviews deepen into full financial statement review, ratio analysis, and variance analysis. Quarterly Reviews take the strategic view: reforecasting based on actuals, debt covenant compliance, and strategic plan adjustments.
Key Triggers for Action
- DSCR falls below 1.25
- Cash reserves below 2 months of expenses
- Revenue decline exceeds 10% for 2 consecutive months
These thresholds should prompt immediate review of the expansion plan and potentially trigger the contingency scenarios modeled in Step 4.
Practical Next Steps
The path from theory to execution involves five sequential steps: collecting 6-12 months of historical data, building the data-capture app with these specific data points, creating automated ratio calculations (leveraging the HP 12c or spreadsheet tools), developing the dashboard prototype, and finally running expansion scenarios with real data.
Quick Win: Essential Metrics to Start Tracking Tomorrow quick-wins
Not everything requires the full framework. These metrics can be captured immediately and yield insight within weeks.
Daily Tracking starts simple: revenue per machine (a log of Machine ID, Date, and Revenue), number of cycles per machine, and the cash vs. card payment split.
Weekly Tracking builds the habit: cash position every Monday morning, total revenue compared to the same week last year, and machine downtime hours.
Monthly Tracking adds depth: all-in cost per wash (Utilities + Supplies + Maintenance divided by Total Washes), customer count (unique if trackable via loyalty program), and maintenance cost per machine age cohort.
Unit Economics unit-economics
These four metrics form the economic engine analysis — connecting microeconomic concepts of cost structure to real business decisions:
| Metric | Formula |
|---|---|
| Revenue per wash cycle | Direct measurement |
| Gross profit per wash | Revenue per wash - Variable costs per wash |
| Payback period per machine | Machine cost / Monthly gross profit per machine |
| Break-even utilization rate | Fixed costs / (Revenue per wash - Variable cost per wash) |
Related Topics in the Vault
- Financial Statement Analysis — the full finance topic area
- Corporate Issuers — capital allocation, working capital, capital structure
- Ethics — diligence, reasonable basis for recommendations
- Calculator Guide — HP 12c functions for TVM, NPV, IRR, depreciation