Financial Accounting and Statement Analysis Formulas
Liquidity
Current Ratio = Current Assets ÷ Current Liabilities
Quick Ratio = (Cash + A/R + Short-term Investments) ÷ Current Liabilities
Working Capital = Current Assets − Current Liabilities
- High Working Capital: Strong ability to pay short-term debts
- Low Working Capital: Higher liquidity risk
- Impacts operating cash flows on the Statement of Cash Flows
Contingent Liabilities (Warranties)
Record liability and expense if both criteria are met:
- Probable future loss
- Amount can be reasonably estimated
Bonds Payable
A bond is a promise to repay principal plus periodic interest.
Advantages
- Stockholders maintain control
- Interest is tax deductible
- Can increase earnings (leverage)
- Flexible financing terms
Disadvantages
- Bankruptcy risk
- Cash flow burden
Shareholders’ Equity
- Common Stock = Par Value × Shares Issued
- APIC = Amount above par value
- Retained Earnings = Beginning RE + Net Income − Dividends
- Treasury Stock = Cumulative repurchases (contra equity)
- Outstanding Shares = Issued Shares − Treasury Shares
Price-to-Book Ratio
Book Value per Share = (Equity − Preferred Equity) ÷ Common Shares
Price-to-Book = Market Price ÷ Book Value per Share
Interpretation
- Low P/B: Undervalued or potential problems
- High P/B: Overvalued or strong growth expectations
Earnings Per Share (EPS)
EPS = (Net Income − Preferred Dividends) ÷ Weighted Average Common Shares
Retained Earnings
Ending RE = Beginning RE + Net Income − Dividends
Stock Transactions Table
| Transaction | Cash | Common Stock | APIC | Retained Earnings | Treasury Stock |
|---|---|---|---|---|---|
| Issue Stock | ↑ | ↑ | ↑ | — | — |
| Cash Dividend | ↓ | — | — | ↓ | — |
| Stock Dividend | — | ↑ | ↑ | ↓ | — |
| Stock Split | — | — | — | — | — |
| Buy Treasury Stock | ↓ | — | — | — | ↑ |
| Sell Treasury Stock | ↑ | — | ↑ | — | ↓ |
Stock Split, Dividend, and Repurchase
Stock Split
- Increases shares
- No equity change
- Reduces price per share
Stock Dividend
- Decreases Retained Earnings
- Increases Common Stock + APIC
- No total equity change
Share Repurchase
- Decreases equity
- Decreases shares outstanding
- Increases EPS
Statement of Cash Flows
- Operating Activities
- Investing Activities
- Financing Activities
Indirect Method (Cash from Operations)
Net Income
- + Depreciation / Amortization
- − Gains / + Losses
- − Increase in Current Assets
- + Decrease in Current Assets
- + Increase in Current Liabilities
- − Decrease in Current Liabilities
Working Capital Rules
| Change | Cash Effect |
|---|---|
| ↑ Asset | − Cash |
| ↓ Asset | + Cash |
| ↑ Liability | + Cash |
| ↓ Liability | − Cash |
| Depreciation | + Cash |
| Gains | − Cash |
| Losses | + Cash |
Cash Flow Structure
| Section | Includes |
|---|---|
| Operating | Net income, depreciation, WC changes |
| Investing | PPE purchase/sale, investments |
| Financing | Debt, stock, dividends |
Cash Flow Ratios
Operating Cash Flow ÷ Current Liabilities = Liquidity strength
Operating Cash Flow ÷ CAPEX = Ability to reinvest
Free Cash Flow = CFO − CAPEX
Forecasting the Income Statement
Revenuet = Revenuet−1 × (1 + growth rate)
Expenses = % of Sales × Revenue
EBT = Revenue − Expenses
Tax = EBT × Tax Rate
Net Income = EBT − Tax
Forecasting the Balance Sheet
- Accounts (A/R, Inventory, etc.) = % of Sales
- Retained Earnings = Beg RE + Net Income − Dividends
- Plug: Cash adjusts to balance the equation
Accounting Equation
Assets = Liabilities + Equity
Cash Flow Identity
Ending Cash − Beginning Cash = Net Change in Cash
Net Change = Operating + Investing + Financing
Key Cash Flow Examples
Operating Example Adjustments
- A/R increase → subtract
- Inventory increase → subtract
- A/P increase → add
- Wages payable increase → add
Investing
- Purchase PPE → negative cash
- Sale PPE → positive cash
Financing
- Issue stock → positive cash
- Debt repayment → negative cash
- Dividends → negative cash
Net Cash Flow from Operating Activities
| Example (Given Data) | Formula / Action |
|---|---|
| Net income = 112,000 | Start CFO with Net Income |
| Accounts receivable: 48,000 → 56,000 | ΔAR = End − Beg = +8,000 → CASH effect = (8,000) |
| Inventory: 66,000 → 60,000 | ΔInv = (6,000) decrease → CASH +6,000 |
| Prepaid insurance: 5,000 → 7,000 | Increase = (2,000) → CASH (2,000) |
| Accounts payable: 18,000 → 22,000 | Increase = +4,000 → CASH +4,000 |
| Wages payable: 15,000 → 11,000 | Decrease = (4,000) → CASH (4,000) |
| Final CFO | Net income +/− all working capital changes |
Indirect Method Adjustment Rules
| Item | Cash Effect |
|---|---|
| Asset increase (AR, Inventory, Prepaid) | SUBTRACT |
| Asset decrease | ADD |
| Liability increase (AP, wages payable, accruals) | ADD |
| Liability decrease | SUBTRACT |
| Noncash expense (depr, amortization) | ADD |
| Gains | SUBTRACT |
| Losses | ADD |
Statement of Cash Flows Structure
| Section | Includes | Formula |
|---|---|---|
| Operating | Net income + working capital + noncash | Indirect method adjustments |
| Investing | PPE, intangibles, investments | Cash in/out investing assets |
| Financing | Debt, stock, dividends | Cash from owners/creditors |
Full Cash Flow Template
| Example Item | Classification |
|---|---|
| Net income | Operating |
| Depreciation / Amortization | Operating (ADD) |
| Gain on sale | Operating (SUBTRACT) |
| Loss on sale | Operating (ADD) |
| Accounts receivable ↑ | Operating (SUBTRACT) |
| Inventory ↓ | Operating (ADD) |
| Accounts payable ↑ | Operating (ADD) |
| Accrued liabilities ↓ | Operating (SUBTRACT) |
| Purchase land | Investing (OUTFLOW) |
| Sale equipment | Investing (INFLOW) |
| Issue stock | Financing (INFLOW) |
| Repay debt | Financing (OUTFLOW) |
| Dividends paid | Financing (OUTFLOW) |
Net Cash Flow Summary Formula
| Example | Formula |
|---|---|
| Beginning cash = 22,000 | Ending cash = Beg + Net change |
| Ending cash = 15,000 | Net change = Ending − Beginning |
Working Capital and Liquidity Ratios
| Ratio | Formula | Interpretation |
|---|---|---|
| Current ratio | Current Assets ÷ Current Liabilities | Ability to pay short-term debt |
| Quick ratio | (CA − Inventory) ÷ CL | Strict liquidity |
| Working capital | CA − CL | Safety buffer |
Cash Flow Ratios
| Ratio | Formula |
|---|---|
| CFO to Current Liabilities | CFO ÷ Average Current Liabilities |
| CFO to CAPEX | CFO ÷ CAPEX |
| Free Cash Flow | CFO − CAPEX |
Interpretation
| Value | Meaning |
|---|---|
| High CFO/CL | Strong liquidity |
| Low CFO/CL | Weak liquidity |
| CFO/Capex > 1 | Can fund investments internally |
| CFO/Capex < 1 | Needs external financing |
Forecasted Income Statement Rules
| Line Item | Forecast Method |
|---|---|
| Revenue | Prior × (1 + growth %) |
| COGS, SG&A | % of revenue |
| Depreciation | GIVEN |
| Interest | NO CHANGE |
| Other income/expense | NO CHANGE |
| Tax expense | Tax rate × EBT |
Forecasting Balance Sheet Rules
| Item | Formula |
|---|---|
| AR | % of sales |
| Inventory | % of sales |
| AP | % of sales |
| Accruals | % of sales |
| PPE | Beg + CAPEX − Depreciation |
| Retained earnings | Beg + Net income − dividends |
Capital Transactions
| Event | Effect |
|---|---|
| Stock issuance | +Equity, +Cash |
| Stock repurchase | −Equity, −Cash |
| Dividends | −Retained earnings, −Cash |
| Bond issuance | +Cash, +Liability |
| Bond repayment | −Cash, −Liability |
Shareholder Equity
| Term | Meaning |
|---|---|
| Retained earnings | Cumulative NI − dividends |
| Treasury stock | Shares repurchased |
| Outstanding shares | Issued − Treasury |
Price to Book
| Formula | Meaning |
|---|---|
| Market price ÷ Book value per share | Compare market vs accounting value |
Stock Effects
| Action | Effect |
|---|---|
| Stock split | No total equity change, more shares |
| Stock dividend | ↓RE, ↑shares |
Base Inputs (Given)
Net Sales = 33,002
Net Income = 4,927
Dividends = 2,853
CAPEX % = 3.7% of sales
Depreciation = 950 (given)
Amortization = 1,914 (given)
Current Asset Formulas
Accounts Receivable
Formula: 20.4% × Net Sales
= 0.204 × 33,002
= 6,732.41
Note: 20.4% comes from problem assumption; 33,002 comes from forecasted net sales.
Inventory
Formula: 12.3% × Net Sales
= 0.123 × 33,002
= 4,059.25
Note: 12.3% = assumption; 33,002 = net sales.
Other Current Assets
Formula: 7% × Net Sales
= 0.07 × 33,002
= 2,310.14
Tax Assets
Formula: 5% × Net Sales
= 0.05 × 33,002
= 1,650.10
Non-Current Assets
Goodwill
Formula: NO CHANGE
= prior balance = 39,959
Note: Comes directly from prior balance sheet (FY2019).
Other Assets
Formula: 3.3% × Net Sales
= 0.033 × 33,002
= 1,089.07
CAPEX (PP&E Adjustment)
Formula: 3.7% × Net Sales
= 0.037 × 33,002
= 1,221.07
Ending PP&E Logic
Formula: Beginning PP&E + CAPEX − Depreciation
= 4,675 + 1,221.07 − 950
= 4,946.07
Note: 4,675 = prior balance sheet; 950 = given depreciation; CAPEX = calculated above.
Intangibles
Formula: Beginning + CAPEX − Amortization
= 20,560 + 1,221.07 − 1,914
= 19,867.07
Note: 20,560 = prior balance sheet; 1,914 = given amortization.
Current Liabilities
Accounts Payable
Formula: 6.4% × Sales
= 0.064 × 33,002
= 2,112.13
Accrued Compensation (Current)
Formula: 7.2% × Sales
= 0.072 × 33,002
= 2,376.14
Accrued Income Taxes (Current)
Formula: 1.9% × Sales
= 0.019 × 33,002
= 627.04
Other Accrued Expenses
Formula: 9.6% × Sales
= 0.096 × 33,002
= 3,168.19
Non-Current Liabilities
Accrued Compensation & Retirement
Formula: NO CHANGE
= prior balance = 1,651
Accrued Income Taxes (Non-Current)
Formula: 9.3% × Sales
= 0.093 × 33,002
= 3,069.19
Deferred Tax Liabilities
Formula: 4.2% × Sales
= 0.042 × 33,002
= 1,386.08
Other Liabilities
Formula: 2.5% × Sales
= 0.025 × 33,002
= 825.05
Returns and Equity
Retained Earnings
Formula: Beginning RE + Net Income − Dividends − Noncontrolling Interest
= 26,270 + 4,927 − 2,853 − 19
= 28,325
Note: 26,270 = prior RE; 4,927 = NI; 2,853 = dividends; 19 = given noncontrolling interest.
- % of sales ALWAYS uses 33,002
- Any “NO CHANGE” = prior balance sheet number
- CAPEX ALWAYS = % × sales (3.7%)
- Depreciation/amortization ALWAYS GIVEN (not %)
- Retained earnings ALWAYS: NI − dividends ± adjustments
- Plug cash LAST if needed
If you want next, I can turn all your material into a true 1-page ultra cheat sheet (tight, printable, no explanations, just formulas and arrows) that fits.
