Financial Ratio Analysis and Credit Risk Formulas
Classified in Economy
Written on in
English with a size of 6.44 KB
Credit Risk Ratios and Liquidity Metrics
Short-Term Liquidity — Stock
- Current Ratio = Current Assets / Current Liabilities (>1 is better)
- Quick Ratio = (Cash + Short-Term Investments + Receivables) / Current Liabilities
- Cash Ratio = (Cash + Short-Term Investments) / Current Liabilities
Short-Term Liquidity — Flow
- Cash Flow Ratio = Cash Flow from Operations / Current Liabilities
- Defensive Interval = (Cash + Short-Term Investments + Receivables) / Capital Expenditures × 365
- Cash Flow to Capital Expenditures = Unlevered Cash Flow from Operations / Capital Expenditures
Long-Term Solvency — Stock
- Debt to Assets = Total Debt / Total Assets
- Debt to Equity = Total Debt / Total Equity
- Long-Term Debt Ratio = Long-Term Debt / (Long-Term Debt + Equity)
Long-Term Solvency — Flow
- Times Interest Earned (TIE) = Operating Income / Net Interest Expense (<1.5 is a danger zone)
- Interest Coverage (Cash) = Unlevered Cash Flow from Operations / Net Cash Interest
- Fixed Charge Coverage = (Operating Income + Fixed Charges) / Fixed Charges
- Fixed Charge Coverage (Cash) = (Unlevered Cash Flow from Operations + Fixed Charges) / Fixed Charges
- CFO to Debt = Unlevered Cash Flow from Operations / Total Debt
Profitability Exercise and Investment Steps
Step 1: Current Ratios
- RNOA = Operating Income / Net Operating Assets
- NBC = Net Financial Expense / Net Financial Obligations
- FLEV = Net Financial Obligations / Common Shareholders' Equity
- ROCE = (Operating Income − Net Financial Expense) / Common Shareholders' Equity
Leverage creates value if: RNOA > NBC
Step 2: After Investment (50/50 Benchmark)
- New Operating Income = Operating Income + (ΔNet Operating Assets × RNOA)
- New Net Operating Assets = Net Operating Assets + ΔNet Operating Assets
- New Net Financial Obligations = Net Financial Obligations + 0.5 × ΔNet Operating Assets
- New Common Shareholders' Equity = Common Shareholders' Equity + 0.5 × ΔNet Operating Assets
- Net Financial Expense = Net Financial Obligations × NBC
- NBC = Borrowing Cost × (1 − Tax)
- Spread = RNOA − NBC
- FLEV = Net Financial Obligations / Common Shareholders' Equity
- ROCE = (Operating Income − Net Financial Expense) / Common Shareholders' Equity
- ROCE = RNOA + ((RNOA − NBC) × FLEV)
Step 3: Find Optimal Debt
- Let D = Debt financing of project (0 ≤ D ≤ ΔNet Operating Assets)
- Net Financial Obligations = Old Net Financial Obligations + D
- Common Shareholders' Equity = Old Common Shareholders' Equity + (ΔNet Operating Assets − D)
- Set NBC = RNOA and solve for D
- If D is outside the feasible range, use a corner solution (D = 0 or D = max)
- Compare ROCE across intervals and pick the highest value
Tiered Interest (After Tax)
- Net Financial Expense = [Bracket 1 × Rate 1 + (D − Threshold) × Rate 2] × (1 − Tax)
Comprehensive Ratio Analysis and Profitability
Balance Sheet Analysis
- Operating Asset Composition = Operating Asset / Total Operating Assets
- Operating Liability Composition = Operating Liability / Total Operating Liabilities
- Operating Liability Leverage (OLLEV) = Operating Liabilities / Net Operating Assets
- Financial Leverage (FLEV) = Net Financial Obligations / Common Shareholders' Equity
- Capitalization Ratio = Net Operating Assets / Common Shareholders' Equity
- (Note: Capitalization − FLEV always equals 1)
Income Statement Analysis
- Operating Profit Margin = Operating Income (After Tax) / Sales
- Sales Profit Margin = Operating Income from Sales (After Tax) / Sales
- Other Items Profit Margin = Operating Income from Other Items / Sales
- Net Comprehensive Profit Margin = Comprehensive Income / Sales
- Expense Ratio = Expense / Sales (1 − Sales Profit Margin = Σ Expense Ratios)
Shareholders' Equity Metrics
- ROCE = Comprehensive Earnings / ½(CSEt + CSEt-1)
- Comprehensive Earnings = CSEend − CSEbeg + Net Dividends
- Dividend Payout = Dividends / Comprehensive Income
- Total Payout = (Dividends + Repurchases) / Comprehensive Income
- Dividends to Book Value = Dividends / (Book Value of CSE + Dividends)
- Total Payout to Book Value = (Dividends + Repurchases) / (Book Value of CSE + Dividends + Repurchases)
- Retention Ratio = (Comprehensive Income − Dividends) / Comprehensive Income = 1 − Payout
- Net Investment Rate = Transactions with Shareholders / Beginning CSE
- Growth Rate of CSE = (Comprehensive Income + Net Transactions) / Beginning CSE
Profitability Summary
- RNOA = Operating Incomet / ½(NOAt + NOAt-1)
- NBC = Net Financial Expenset / ½(NFOt + NFOt-1)
- RNFA = Net Financial Incomet / ½(NFAt + NFAt-1)
- ROCEt = Comprehensive Earnings / ½(CSEt + CSEt-1)
- ROCEt = (Operating Income − Net Financial Expense) / (Net Operating Assets − Net Financial Obligations)