Financial Analysis Skill
Financial modeling, analysis frameworks, and regulatory awareness for business-minded professionals.
Core Principle
Financial analysis transforms raw numbers into decisions. Every model, ratio, and forecast exists to answer one question: Should we do this?
Financial Statement Analysis
The Three Statements
| Statement |
Measures |
Key Question |
| Income Statement |
Profitability over a period |
Is the business making money? |
| Balance Sheet |
Assets, liabilities, equity at a point in time |
What does the business own and owe? |
| Cash Flow Statement |
Cash movement over a period |
Where is the cash going? |
Key Ratios
Profitability
| Ratio |
Formula |
Meaning |
| Gross Margin |
(Revenue − COGS) / Revenue |
Pricing power and production efficiency |
| Operating Margin |
Operating Income / Revenue |
Core business profitability |
| Net Margin |
Net Income / Revenue |
Bottom-line profitability |
| ROE |
Net Income / Shareholders' Equity |
Return to equity holders |
| ROA |
Net Income / Total Assets |
Asset efficiency |
Liquidity
| Ratio |
Formula |
Healthy Range |
| Current Ratio |
Current Assets / Current Liabilities |
1.5–3.0 |
| Quick Ratio |
(Current Assets − Inventory) / Current Liabilities |
1.0–2.0 |
| Cash Ratio |
Cash / Current Liabilities |
0.5–1.0 |
Leverage
| Ratio |
Formula |
Watch For |
| Debt-to-Equity |
Total Debt / Total Equity |
>2.0 signals high leverage |
| Interest Coverage |
EBIT / Interest Expense |
<1.5 signals debt stress |
| Debt-to-EBITDA |
Total Debt / EBITDA |
>4.0 may limit borrowing capacity |
Financial Modeling
DCF (Discounted Cash Flow)
When to use: Valuing a business, project, or investment based on future cash flows.
Steps:
- Project free cash flows (FCF) for 5–10 years
- Calculate terminal value (perpetuity growth or exit multiple)
- Discount all cash flows to present value using WACC
- Sum = enterprise value
- Subtract net debt → equity value
Key assumptions to document:
- Revenue growth rate and drivers
- Margin trajectory
- Capital expenditure requirements
- Working capital changes
- Discount rate (WACC) and terminal growth rate
Comparable Company Analysis (Comps)
| Step |
Action |
| 1 |
Select peer group (industry, size, geography) |
| 2 |
Gather trading multiples (EV/EBITDA, P/E, EV/Revenue) |
| 3 |
Calculate median and mean multiples |
| 4 |
Apply multiples to target company metrics |
| 5 |
Derive implied valuation range |
Scenario Analysis
Always model three cases:
| Scenario |
Purpose |
Probability Weight |
| Base |
Most likely outcome |
50–60% |
| Upside |
Favorable conditions |
20–25% |
| Downside |
Adverse conditions |
20–25% |
Budgeting & Forecasting
Budget Types
| Type |
Method |
Best For |
| Zero-based |
Justify every line from zero |
Cost control, new initiatives |
| Incremental |
Adjust prior year ±% |
Stable operations |
| Activity-based |
Cost per activity/output |
Service organizations |
| Rolling |
Continuously extend 12-month window |
Dynamic environments |
Variance Analysis
| Variance |
Formula |
Interpretation |
| Favorable |
Actual better than budget |
Outperformance or conservative budget |
| Unfavorable |
Actual worse than budget |
Underperformance or aggressive budget |
| Volume variance |
(Actual units − Budget units) × Budget price |
Demand-driven |
| Price variance |
(Actual price − Budget price) × Actual units |
Pricing/cost-driven |
Real Estate Financial Analysis
Property Valuation Methods
| Method |
Approach |
Best For |
| Cap Rate |
NOI / Property Value |
Income-producing properties |
| Comparable Sales |
Recent sale prices of similar properties |
Residential, land |
| Cost Approach |
Land value + replacement cost − depreciation |
Unique properties |
Key Metrics
| Metric |
Formula |
Target |
| Cap Rate |
NOI / Purchase Price |
4–10% depending on market |
| Cash-on-Cash Return |
Annual Cash Flow / Total Cash Invested |
8–12% |
| DSCR (Debt Service Coverage) |
NOI / Annual Debt Service |
>1.25 |
| GRM (Gross Rent Multiplier) |
Price / Annual Gross Rent |
Lower = better value |
Regulatory Awareness
Key Frameworks (Not Legal Advice)
| Framework |
Scope |
Applies To |
| SOX (Sarbanes-Oxley) |
Financial reporting controls, audit requirements |
US public companies |
| PCI-DSS |
Payment card data security |
Any business processing card payments |
| Basel III/IV |
Capital adequacy, liquidity requirements |
Banks and financial institutions |
| Dodd-Frank |
Financial stability, consumer protection |
US financial institutions |
| IFRS vs GAAP |
Accounting standards |
International vs US reporting |
| MiFID II |
Financial instrument markets |
EU investment firms |
Financial Compliance Patterns
- Segregation of duties: No single person controls an entire financial process
- Audit trails: Every financial transaction traceable to source documentation
- Materiality thresholds: Define what magnitude of error requires disclosure
- Internal controls: Preventive (approvals) and detective (reconciliations)
Anti-Patterns
- Building models without documenting assumptions
- Using a single-point forecast instead of scenarios
- Confusing revenue with cash flow
- Ignoring working capital in projections
- Treating all debt as equivalent (ignoring covenants, maturity, rates)
- Circular references in spreadsheet models without iteration controls
1---2name: financial-analysis-43description: Financial modeling, analysis frameworks, and regulatory awareness for business-minded professionals.4tier: extended5applyTo: '**/*financ*,**/*budget*,**/*revenue*,**/*forecast*,**/*valuation*,**/*accounting*,**/*investment*'6currency: 2026-04-227metadata:8 source: https://skillmd.com/skills/fabioc-aloha/financial-analysis-49---1011# Financial Analysis Skill1213> Financial modeling, analysis frameworks, and regulatory awareness for business-minded professionals.1415## Core Principle1617Financial analysis transforms raw numbers into decisions. Every model, ratio, and forecast exists to answer one question: *Should we do this?*1819## Financial Statement Analysis2021### The Three Statements2223| Statement | Measures | Key Question |24|-----------|----------|-------------|25| **Income Statement** | Profitability over a period | Is the business making money? |26| **Balance Sheet** | Assets, liabilities, equity at a point in time | What does the business own and owe? |27| **Cash Flow Statement** | Cash movement over a period | Where is the cash going? |2829### Key Ratios3031#### Profitability32| Ratio | Formula | Meaning |33|-------|---------|---------|34| Gross Margin | (Revenue − COGS) / Revenue | Pricing power and production efficiency |35| Operating Margin | Operating Income / Revenue | Core business profitability |36| Net Margin | Net Income / Revenue | Bottom-line profitability |37| ROE | Net Income / Shareholders' Equity | Return to equity holders |38| ROA | Net Income / Total Assets | Asset efficiency |3940#### Liquidity41| Ratio | Formula | Healthy Range |42|-------|---------|---------------|43| Current Ratio | Current Assets / Current Liabilities | 1.5–3.0 |44| Quick Ratio | (Current Assets − Inventory) / Current Liabilities | 1.0–2.0 |45| Cash Ratio | Cash / Current Liabilities | 0.5–1.0 |4647#### Leverage48| Ratio | Formula | Watch For |49|-------|---------|-----------|50| Debt-to-Equity | Total Debt / Total Equity | >2.0 signals high leverage |51| Interest Coverage | EBIT / Interest Expense | <1.5 signals debt stress |52| Debt-to-EBITDA | Total Debt / EBITDA | >4.0 may limit borrowing capacity |5354## Financial Modeling5556### DCF (Discounted Cash Flow)5758**When to use**: Valuing a business, project, or investment based on future cash flows.5960**Steps:**611. Project free cash flows (FCF) for 5–10 years622. Calculate terminal value (perpetuity growth or exit multiple)633. Discount all cash flows to present value using WACC644. Sum = enterprise value655. Subtract net debt → equity value6667**Key assumptions to document:**68- Revenue growth rate and drivers69- Margin trajectory70- Capital expenditure requirements71- Working capital changes72- Discount rate (WACC) and terminal growth rate7374### Comparable Company Analysis (Comps)7576| Step | Action |77|------|--------|78| 1 | Select peer group (industry, size, geography) |79| 2 | Gather trading multiples (EV/EBITDA, P/E, EV/Revenue) |80| 3 | Calculate median and mean multiples |81| 4 | Apply multiples to target company metrics |82| 5 | Derive implied valuation range |8384### Scenario Analysis8586Always model three cases:8788| Scenario | Purpose | Probability Weight |89|----------|---------|-------------------|90| **Base** | Most likely outcome | 50–60% |91| **Upside** | Favorable conditions | 20–25% |92| **Downside** | Adverse conditions | 20–25% |9394## Budgeting & Forecasting9596### Budget Types9798| Type | Method | Best For |99|------|--------|----------|100| **Zero-based** | Justify every line from zero | Cost control, new initiatives |101| **Incremental** | Adjust prior year ±% | Stable operations |102| **Activity-based** | Cost per activity/output | Service organizations |103| **Rolling** | Continuously extend 12-month window | Dynamic environments |104105### Variance Analysis106107| Variance | Formula | Interpretation |108|----------|---------|---------------|109| Favorable | Actual better than budget | Outperformance or conservative budget |110| Unfavorable | Actual worse than budget | Underperformance or aggressive budget |111| Volume variance | (Actual units − Budget units) × Budget price | Demand-driven |112| Price variance | (Actual price − Budget price) × Actual units | Pricing/cost-driven |113114## Real Estate Financial Analysis115116### Property Valuation Methods117118| Method | Approach | Best For |119|--------|----------|----------|120| **Cap Rate** | NOI / Property Value | Income-producing properties |121| **Comparable Sales** | Recent sale prices of similar properties | Residential, land |122| **Cost Approach** | Land value + replacement cost − depreciation | Unique properties |123124### Key Metrics125126| Metric | Formula | Target |127|--------|---------|--------|128| Cap Rate | NOI / Purchase Price | 4–10% depending on market |129| Cash-on-Cash Return | Annual Cash Flow / Total Cash Invested | 8–12% |130| DSCR (Debt Service Coverage) | NOI / Annual Debt Service | >1.25 |131| GRM (Gross Rent Multiplier) | Price / Annual Gross Rent | Lower = better value |132133## Regulatory Awareness134135### Key Frameworks (Not Legal Advice)136137| Framework | Scope | Applies To |138|-----------|-------|-----------|139| **SOX** (Sarbanes-Oxley) | Financial reporting controls, audit requirements | US public companies |140| **PCI-DSS** | Payment card data security | Any business processing card payments |141| **Basel III/IV** | Capital adequacy, liquidity requirements | Banks and financial institutions |142| **Dodd-Frank** | Financial stability, consumer protection | US financial institutions |143| **IFRS vs GAAP** | Accounting standards | International vs US reporting |144| **MiFID II** | Financial instrument markets | EU investment firms |145146### Financial Compliance Patterns147148- **Segregation of duties**: No single person controls an entire financial process149- **Audit trails**: Every financial transaction traceable to source documentation150- **Materiality thresholds**: Define what magnitude of error requires disclosure151- **Internal controls**: Preventive (approvals) and detective (reconciliations)152153## Anti-Patterns154155- Building models without documenting assumptions156- Using a single-point forecast instead of scenarios157- Confusing revenue with cash flow158- Ignoring working capital in projections159- Treating all debt as equivalent (ignoring covenants, maturity, rates)160- Circular references in spreadsheet models without iteration controls