Financial Statements
by jakemmarsh
Generate income statements, balance sheets, and cash flow statements with GAAP presentation and period-over-period comparison. Use when preparing financial statements, running flux analysis, or creating P&L reports with variance commentary.
Skill Details
Repository Files
1 file in this skill directory
name: financial-statements description: Generate income statements, balance sheets, and cash flow statements with GAAP presentation and period-over-period comparison. Use when preparing financial statements, running flux analysis, or creating P&L reports with variance commentary.
Financial Statements
Important: This skill assists with financial statement workflows but does not provide financial advice. All statements should be reviewed by qualified financial professionals before use in reporting or filings.
Formats, GAAP presentation requirements, common adjustments, and flux analysis methodology for income statements, balance sheets, and cash flow statements.
Income Statement
Standard Format (Classification of Expenses by Function)
Revenue
Product revenue
Service revenue
Other revenue
Total Revenue
Cost of Revenue
Product costs
Service costs
Total Cost of Revenue
Gross Profit
Operating Expenses
Research and development
Sales and marketing
General and administrative
Total Operating Expenses
Operating Income (Loss)
Other Income (Expense)
Interest income
Interest expense
Other income (expense), net
Total Other Income (Expense)
Income (Loss) Before Income Taxes
Income tax expense (benefit)
Net Income (Loss)
Earnings Per Share (if applicable)
Basic
Diluted
GAAP Presentation Requirements (ASC 220 / IAS 1)
- Present all items of income and expense recognized in a period
- Classify expenses either by nature (materials, labor, depreciation) or by function (COGS, R&D, S&M, G&A) — function is more common for US companies
- If classified by function, disclose depreciation, amortization, and employee benefit costs by nature in the notes
- Present operating and non-operating items separately
- Show income tax expense as a separate line
- Extraordinary items are prohibited under both US GAAP and IFRS
- Discontinued operations presented separately, net of tax
Common Presentation Considerations
- Revenue disaggregation: ASC 606 requires disaggregation of revenue into categories that depict how the nature, amount, timing, and uncertainty of revenue are affected by economic factors
- Stock-based compensation: Classify within the functional expense categories (R&D, S&M, G&A) with total SBC disclosed in notes
- Restructuring charges: Present separately if material, or include in operating expenses with note disclosure
- Non-GAAP adjustments: If presenting non-GAAP measures (common in earnings releases), clearly label and reconcile to GAAP
Balance Sheet
Standard Format (Classified Balance Sheet)
ASSETS
Current Assets
Cash and cash equivalents
Short-term investments
Accounts receivable, net
Inventory
Prepaid expenses and other current assets
Total Current Assets
Non-Current Assets
Property and equipment, net
Operating lease right-of-use assets
Goodwill
Intangible assets, net
Long-term investments
Other non-current assets
Total Non-Current Assets
TOTAL ASSETS
LIABILITIES AND STOCKHOLDERS' EQUITY
Current Liabilities
Accounts payable
Accrued liabilities
Deferred revenue, current portion
Current portion of long-term debt
Operating lease liabilities, current portion
Other current liabilities
Total Current Liabilities
Non-Current Liabilities
Long-term debt
Deferred revenue, non-current
Operating lease liabilities, non-current
Other non-current liabilities
Total Non-Current Liabilities
Total Liabilities
Stockholders' Equity
Common stock
Additional paid-in capital
Retained earnings (accumulated deficit)
Accumulated other comprehensive income (loss)
Treasury stock
Total Stockholders' Equity
TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY
GAAP Presentation Requirements (ASC 210 / IAS 1)
- Distinguish between current and non-current assets and liabilities
- Current: expected to be realized, consumed, or settled within 12 months (or the operating cycle if longer)
- Present assets in order of liquidity (most liquid first) — standard US practice
- Accounts receivable shown net of allowance for credit losses (ASC 326)
- Property and equipment shown net of accumulated depreciation
- Goodwill is not amortized — tested for impairment annually (ASC 350)
- Leases: recognize right-of-use assets and lease liabilities for operating and finance leases (ASC 842)
Cash Flow Statement
Standard Format (Indirect Method)
CASH FLOWS FROM OPERATING ACTIVITIES
Net income (loss)
Adjustments to reconcile net income to net cash from operations:
Depreciation and amortization
Stock-based compensation
Amortization of debt issuance costs
Deferred income taxes
Loss (gain) on disposal of assets
Impairment charges
Other non-cash items
Changes in operating assets and liabilities:
Accounts receivable
Inventory
Prepaid expenses and other assets
Accounts payable
Accrued liabilities
Deferred revenue
Other liabilities
Net Cash Provided by (Used in) Operating Activities
CASH FLOWS FROM INVESTING ACTIVITIES
Purchases of property and equipment
Purchases of investments
Proceeds from sale/maturity of investments
Acquisitions, net of cash acquired
Other investing activities
Net Cash Provided by (Used in) Investing Activities
CASH FLOWS FROM FINANCING ACTIVITIES
Proceeds from issuance of debt
Repayment of debt
Proceeds from issuance of common stock
Repurchases of common stock
Dividends paid
Payment of debt issuance costs
Other financing activities
Net Cash Provided by (Used in) Financing Activities
Effect of exchange rate changes on cash
Net Increase (Decrease) in Cash and Cash Equivalents
Cash and cash equivalents, beginning of period
Cash and cash equivalents, end of period
GAAP Presentation Requirements (ASC 230 / IAS 7)
- Indirect method is most common (start with net income, adjust for non-cash items)
- Direct method is permitted but rarely used (requires supplemental indirect reconciliation)
- Interest paid and income taxes paid must be disclosed (either on the face or in notes)
- Non-cash investing and financing activities disclosed separately (e.g., assets acquired under leases, stock issued for acquisitions)
- Cash equivalents: short-term, highly liquid investments with original maturities of 3 months or less
Common Adjustments and Reclassifications
Period-End Adjustments
- Accruals: Record expenses incurred but not yet paid (AP accruals, payroll accruals, interest accruals)
- Deferrals: Adjust prepaid expenses, deferred revenue, and deferred costs for the period
- Depreciation and amortization: Book periodic depreciation/amortization from fixed asset and intangible schedules
- Bad debt provision: Adjust allowance for credit losses based on aging analysis and historical loss rates
- Inventory adjustments: Record write-downs for obsolete, slow-moving, or impaired inventory
- FX revaluation: Revalue foreign-currency-denominated monetary assets and liabilities at period-end rates
- Tax provision: Record current and deferred income tax expense
- Fair value adjustments: Mark-to-market investments, derivatives, and other fair-value items
Reclassifications
- Current/non-current reclassification: Reclassify long-term debt maturing within 12 months to current
- Contra account netting: Net allowances against gross receivables, accumulated depreciation against gross assets
- Intercompany elimination: Eliminate intercompany balances and transactions in consolidation
- Discontinued operations: Reclassify results of discontinued operations to a separate line item
- Equity method adjustments: Record share of investee income/loss for equity method investments
- Segment reclassifications: Ensure transactions are properly classified by operating segment
Flux Analysis Methodology
Variance Calculation
For each line item, calculate:
- Dollar variance: Current period - Prior period (or current period - budget)
- Percentage variance: (Current - Prior) / |Prior| x 100
- Basis point change: For margins and ratios, express change in basis points (1 bp = 0.01%)
Materiality Thresholds
Define what constitutes a "material" variance requiring investigation. Common approaches:
- Fixed dollar threshold: Variances exceeding a set dollar amount (e.g., $50K, $100K)
- Percentage threshold: Variances exceeding a set percentage (e.g., 10%, 15%)
- Combined: Either the dollar OR percentage threshold is exceeded
- Scaled: Different thresholds for different line items based on their size and volatility
Example thresholds (adjust for your organization):
| Line Item Size | Dollar Threshold | Percentage Threshold |
|---|---|---|
| > $10M | $500K | 5% |
| $1M - $10M | $100K | 10% |
| < $1M | $50K | 15% |
Variance Decomposition
Break down total variance into component drivers:
- Volume/quantity effect: Change in volume at prior period rates
- Rate/price effect: Change in rate/price at current period volume
- Mix effect: Shift in composition between items with different rates/margins
- New/discontinued items: Items present in one period but not the other
- One-time/non-recurring items: Items that are not expected to repeat
- Timing effect: Items shifting between periods (not a true change in run rate)
- Currency effect: Impact of FX rate changes on translated results
Investigation and Narrative
For each material variance:
- Quantify the variance ($ and %)
- Identify whether favorable or unfavorable
- Decompose into drivers using the categories above
- Provide a narrative explanation of the business reason
- Assess whether the variance is temporary or represents a trend change
- Note any actions required (further investigation, forecast update, process change)
Related Skills
Attack Tree Construction
Build comprehensive attack trees to visualize threat paths. Use when mapping attack scenarios, identifying defense gaps, or communicating security risks to stakeholders.
Grafana Dashboards
Create and manage production Grafana dashboards for real-time visualization of system and application metrics. Use when building monitoring dashboards, visualizing metrics, or creating operational observability interfaces.
Matplotlib
Foundational plotting library. Create line plots, scatter, bar, histograms, heatmaps, 3D, subplots, export PNG/PDF/SVG, for scientific visualization and publication figures.
Scientific Visualization
Create publication figures with matplotlib/seaborn/plotly. Multi-panel layouts, error bars, significance markers, colorblind-safe, export PDF/EPS/TIFF, for journal-ready scientific plots.
Seaborn
Statistical visualization. Scatter, box, violin, heatmaps, pair plots, regression, correlation matrices, KDE, faceted plots, for exploratory analysis and publication figures.
Shap
Model interpretability and explainability using SHAP (SHapley Additive exPlanations). Use this skill when explaining machine learning model predictions, computing feature importance, generating SHAP plots (waterfall, beeswarm, bar, scatter, force, heatmap), debugging models, analyzing model bias or fairness, comparing models, or implementing explainable AI. Works with tree-based models (XGBoost, LightGBM, Random Forest), deep learning (TensorFlow, PyTorch), linear models, and any black-box model
Pydeseq2
Differential gene expression analysis (Python DESeq2). Identify DE genes from bulk RNA-seq counts, Wald tests, FDR correction, volcano/MA plots, for RNA-seq analysis.
Query Writing
For writing and executing SQL queries - from simple single-table queries to complex multi-table JOINs and aggregations
Pydeseq2
Differential gene expression analysis (Python DESeq2). Identify DE genes from bulk RNA-seq counts, Wald tests, FDR correction, volcano/MA plots, for RNA-seq analysis.
Scientific Visualization
Meta-skill for publication-ready figures. Use when creating journal submission figures requiring multi-panel layouts, significance annotations, error bars, colorblind-safe palettes, and specific journal formatting (Nature, Science, Cell). Orchestrates matplotlib/seaborn/plotly with publication styles. For quick exploration use seaborn or plotly directly.
