# Financial Health Dashboard A 12-month financial-health pack: fifteen ratios across liquidity, solvency, profitability, and efficiency families, computed from a compact operating P&L and a self-balancing balance-sheet roll-forward, with a one-page dashboard showing latest, 12-month average, green and amber thresholds, status, and industry benchmark per ratio. - Canonical: https://finamodel.com/excel-dashboard/financial-health - Excel download: https://finamodel.com/templates/financial-health.xlsx - Category: Corporate Finance - Model type: Operating model - Difficulty: Intermediate - Audiences: CFOs & FP&A, Founders & operators, CFOs, FP&A teams, Controllers, Lenders - Tags: ratios, liquidity, solvency, profitability, efficiency ## Overview See your business’s financial health in one view. This Excel dashboard brings together fifteen ratios across liquidity, leverage, profitability and operating efficiency. Review cash coverage, debt levels, margins and collection performance side by side to understand where the business is strong and where it needs attention. Each metric shows its latest result alongside a 12-month average, threshold levels and an industry benchmark. Traffic-light indicators make exceptions easy to identify, while the monthly ratio history helps you distinguish a recent change from a persistent issue. Set thresholds that reflect your business and reporting priorities so the status indicators provide useful context for each review. Use the dashboard for monthly finance meetings, management reporting and board updates. CFOs, finance teams and business owners can start with the summary, identify the ratios that warrant discussion, then refer to the supporting financial statements for detail. It gives everyone a consistent view of performance and a clear starting point for questions about liquidity, profitability and debt capacity. ## What's included - Assumptions sheet with named-range P&L drivers, opening BS, working-capital days, capital plan, and per-ratio thresholds - 12-month Income Statement: revenue, COGS, gross profit, opex, EBITDA, depreciation, EBIT, interest, EBT, tax, net income - 12-month Balance Sheet with cash as the plug that ties total assets to liabilities plus equity, with a balance-check row that resolves to zero - Ratios sheet with 15 ratios across four families: liquidity (3), solvency (4), profitability (5), efficiency (3) - Direction-aware traffic-light logic so leverage ratios trigger correctly when higher is worse - Dashboard with latest, 12-month average, green and amber thresholds, status string, and industry benchmark per ratio - 12-month P&L from compounded revenue, COGS, opex, depreciation, interest, tax to net income - 12-month balance-sheet roll-forward with cash as the plug that ties total assets to liabilities-plus-equity - 15 ratios across four families: liquidity (3), solvency (4), profitability (5), efficiency (3) - Dashboard with latest, 12-month average, green and amber thresholds, status, and industry benchmark per ratio - Direction-aware status logic so leverage ratios trigger correctly when higher is worse - Balance-check row that resolves to zero across all 12 months ## Built for monthly close reviews When the books close, the CFO wants every ratio recalculated and flagged on one page. This template builds the ratios off a compact IS and BS so a single replacement of the P&L drives the entire dashboard. ## Designed for lender covenant monitoring Threshold inputs live as named ranges on the Assumptions sheet - wire them to your covenant levels (e.g. min interest coverage 3.0x, max debt-to-equity 2.0x) and read the status column as an early-warning panel. ## Audit-friendly mechanics Cash is the plug that ties the balance sheet, the balance-check row resolves to zero in every period, every formula is one or two operations, and the workbook passes static-value, self-reference, dead-assumption, and unused-named-range scans. ## Built for monthly close reviews When the books close, the CFO wants every ratio recalculated and flagged on one page. This template builds the ratios off a compact IS and BS so a single replacement of the P&L drives the entire dashboard. ## Designed for lender covenant monitoring Threshold inputs live as named ranges on the Assumptions sheet - wire them to your covenant levels (e.g. min interest coverage 3.0x, max debt-to-equity 2.0x) and read the status column as an early-warning panel. ## Audit-friendly mechanics Cash is the plug that ties the balance sheet, the balance-check row resolves to zero in every period, every formula is one or two operations, and the workbook passes static-value, self-reference, dead-assumption, and unused-named-range scans. ## Workbook structure ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: P&L bases, opening roll-forward balances, working-capital days, capital plan, thresholds, direction codes. - Revenue base and monthly growth - COGS / opex / depreciation / interest / tax rates - Opening PP&E, debt, equity - DSO, DIO, DPO, accrued-expense days - Monthly capex, debt amortisation, dividend payout - Per-ratio green and amber thresholds (15 ratios x 2) - Per-ratio direction code (1 = higher better, -1 = lower better) ### Income_Statement 12-month P&L from compounded base values: revenue → net income. - Revenue compounds monthly at Rev_Growth - COGS and opex as ratios of revenue - Depreciation on prior-month PP&E at Dep_Rate / 12 - Interest on prior-month debt at Int_Rate / 12 - Tax floored at zero with MAX(EBT, 0) × Tax_Rate ### Balance_Sheet 12-month BS roll-forward with cash as the balancing plug and a check row. - AR = Revenue × DSO / 30; Inventory = COGS × DIO / 30 - AP = COGS × DPO / 30; Accrued = Opex × Accrued_Days / 30 - Net PP&E rolls with monthly capex less depreciation - Long-term debt amortises at Debt_Amort per month, floored at zero - Equity grows with retained earnings (NI × (1 - Payout_Ratio)) - Cash = Total liab + equity − AR − Inventory − Net PP&E - Balance check = Total assets − Total liab + equity = 0 every period ### Ratios 12-month matrix of fifteen ratios across four families. - Liquidity: current, quick, cash - Solvency: debt-to-equity, debt-to-assets, equity ratio, interest coverage - Profitability: gross, EBITDA, net margin, ROA, ROE (ROA / ROE annualised by ×12) - Efficiency: asset turnover, inventory turnover (annualised), days sales outstanding - Divide-by-zero guards on every denominator ### Dashboard One row per ratio: latest, 12-month average, green, amber, status, benchmark. - Latest = period-12 ratio - 12-mo avg = AVERAGE across all 12 months - Green / amber pulled from Assumptions - Status: direction-aware Healthy / Watch / Off track - Benchmark column lists industry-typical band per ratio ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: P&L bases, opening roll-forward balances, working-capital days, capital plan, thresholds, direction codes. - Revenue base and monthly growth - COGS / opex / depreciation / interest / tax rates - Opening PP&E, debt, equity - DSO, DIO, DPO, accrued-expense days - Monthly capex, debt amortisation, dividend payout - Per-ratio green and amber thresholds (15 ratios x 2) - Per-ratio direction code (1 = higher better, -1 = lower better) ### Income_Statement 12-month P&L from compounded base values: revenue → net income. - Revenue compounds monthly at Rev_Growth - COGS and opex as ratios of revenue - Depreciation on prior-month PP&E at Dep_Rate / 12 - Interest on prior-month debt at Int_Rate / 12 - Tax floored at zero with MAX(EBT, 0) × Tax_Rate ### Balance_Sheet 12-month BS roll-forward with cash as the balancing plug and a check row. - AR = Revenue × DSO / 30; Inventory = COGS × DIO / 30 - AP = COGS × DPO / 30; Accrued = Opex × Accrued_Days / 30 - Net PP&E rolls with monthly capex less depreciation - Long-term debt amortises at Debt_Amort per month, floored at zero - Equity grows with retained earnings (NI × (1 - Payout_Ratio)) - Cash = Total liab + equity − AR − Inventory − Net PP&E - Balance check = Total assets − Total liab + equity = 0 every period ### Ratios 12-month matrix of fifteen ratios across four families. - Liquidity: current, quick, cash - Solvency: debt-to-equity, debt-to-assets, equity ratio, interest coverage - Profitability: gross, EBITDA, net margin, ROA, ROE (ROA / ROE annualised by ×12) - Efficiency: asset turnover, inventory turnover (annualised), days sales outstanding - Divide-by-zero guards on every denominator ### Dashboard One row per ratio: latest, 12-month average, green, amber, status, benchmark. - Latest = period-12 ratio - 12-mo avg = AVERAGE across all 12 months - Green / amber pulled from Assumptions - Status: direction-aware Healthy / Watch / Off track - Benchmark column lists industry-typical band per ratio ## Features - **Direction-aware traffic lights:** Every ratio carries a direction code (1 = higher better, -1 = lower better) so the status string reads correctly for both liquidity and leverage metrics off the same threshold input. - **Self-balancing balance sheet:** Cash is computed as the plug that ties total assets to total liabilities plus equity, so the BS balances every period without manual cash-line maintenance. - **Industry benchmarks baked in:** Each Dashboard row carries a typical benchmark band (current ratio 1.5-3.0x, EBITDA margin 15%+, DSO 30-60 days) so the reader can sanity-check the threshold inputs at a glance. ## Use cases - **CFO monthly close review:** Drop the close numbers into the P&L and BS sheets and walk into the close meeting with every ratio recalculated and flagged - no separate ratio worksheet to maintain. - **Lender covenant monitoring:** Wire the threshold inputs to the loan covenants (e.g. min interest coverage 3.0x, max debt-to-EBITDA 4.0x) and use the status column as an early-warning panel. - **Board KPI pack:** Hand the Dashboard sheet to the board as a one-page financial-health snapshot anchored in latest, 12-month average, and a status string per ratio. ## Frequently asked questions ### What is a financial health dashboard? A financial health dashboard ties a small set of P&L and balance-sheet flows to a panel of ratios across liquidity, solvency, profitability, and efficiency families, then flags each ratio against a threshold. It is how CFOs, controllers, and lenders read the state of a business at a glance without scrolling through a full 3-statement model. ### How is cash calculated on the balance sheet? Cash is the plug that ties total assets to total liabilities plus equity: Cash = (Total liab + Equity) − AR − Inventory − Net PP&E. This makes the balance check row resolve to zero in every period and keeps the model self-consistent without a separate cash-flow statement. ### Why are some ratios direction-flipped? Higher leverage is worse, so debt-to-equity and debt-to-assets earn a "Healthy" status when the ratio is below the green threshold, not above it. The Assumptions sheet carries a per-ratio direction code (1 = higher better, -1 = lower better) and the Dashboard status formula flips its comparator accordingly. ### Are the profitability ratios annualised? Yes for ROA, ROE, asset turnover, and inventory turnover - these multiply the monthly numerator by 12 before dividing by the period balance so the figures read on a comparable annual basis. Gross margin, EBITDA margin, and net margin are intra-period and need no annualisation. ### Can I plug in my own P&L and balance sheet? Yes. Replace the formula-driven cells on the Income_Statement and Balance_Sheet sheets with recorded numbers in the same row layout. The Ratios and Dashboard sheets recalculate immediately. The balance check row will catch any inconsistency between recorded assets and liabilities-plus-equity. ## Related dashboards - [Board Reporting Pack Dashboard](https://finamodel.com/excel-dashboard/board-reporting) - [Cash Flow Dashboard](https://finamodel.com/excel-dashboard/cashflow) - [Income Statement Dashboard](https://finamodel.com/excel-dashboard/income-statement) - [Budget vs Actuals Tracker Dashboard](https://finamodel.com/excel-dashboard/budget-vs-actuals)