# Chief Risk Officer Dashboard Monitor consolidated risk exposures and heat maps across trading, lending, and operations without fragmented spreadsheets. Aggregate VaR, credit exposure, operational losses, and liquidity gaps by business line against a unified risk appetite framework. - Canonical: https://finamodel.com/templates/cro-model - Excel download: https://finamodel.com/templates/cro.xlsx - Category: Capital Markets - Model type: Operating model - Difficulty: Advanced - Audiences: CFOs & FP&A, Investors & analysts, Chief risk officers, Risk committees, Regulators, Business heads - Tags: Risk management, VaR, Limits, Dashboard ## Overview This Contract Research Organisation (CRO) financial model projects revenue from clinical trial management, consulting services, and laboratory work across multiple therapeutic areas and customer segments. It models active studies by type (oncology, rare disease, etc.), active accounts, consulting utilisation (billable hours, hourly rates), and lab samples processed. Revenue grows from study volume growth, pricing escalation, and customer mix shift toward higher-margin products. The model includes customer concentration risk (top 10 customers), backlog conversion rates, and contract-specific profitability (fixed-price versus FTE/time-and-materials contracts). The model includes operating expense sections for direct labour (clinical research associates, project managers) scaled to study volumes and account count; fixed overhead (IT, facilities, G&A); business development and marketing; and technology investment (EDC/CTMS platform development). Working capital tracks receivables (55–80 day DSO typical for pharma sponsors), unbilled revenue, and deferred revenue. Capex includes laboratory equipment, office build-outs, and technology platform investment. Key margins include gross margin (after direct labour), EBITDA margin (after overhead absorption), and net margin. This model is used by CRO management teams forecasting growth and profitability, PE sponsors evaluating CRO acquisition targets, lenders sizing working capital facilities (especially important given material unbilled receivables and payment delays from pharma sponsors), and public equity analysts researching CRO publicly traded stocks. It addresses the unique challenge of labour-intensive, contract-based business models with long customer sales cycles and complex revenue recognition. ## What's included - Risk appetite framework with risk limits by business line and risk type - Market risk: VaR, Greeks, and stress losses by trading desk - Credit risk: exposure by counterparty, sector, and geography - Operational risk: loss incidents and capital charge calculations - Liquidity risk: funding gaps and coverage ratios ## CRO Model: How the Financial Model Works This CRO model template helps users evaluate whether to invest in, acquire, or expand a contract research organisation. It focuses on study volumes, backlog conversion, staffing utilisation, and margin trajectory. The model is asset-light and labour-intensive, with revenue driven by full-time equivalent billing and fixed-price study contracts. ### Operating Drivers: Backlog, Utilisation, and Pass-Throughs The model's operating logic is anchored in a few core drivers. Revenue is largely contract-driven, so the backlog roll-forward—opening backlog plus new bookings minus cancellations minus revenue recognised—sets the top line. - Book-to-bill ratio, typically 1.1x to 1.3x for growth, indicates whether bookings are outpacing revenue. Service lines are separated: clinical operations uses a backlog burn rate of 25% to 35% per annum, consulting relies on consultant headcount, billable hours, rates, and utilisation, and lab services depends on sample volumes and setup fees. - Billable staff utilisation is modelled at 70% to 80%, reflecting training and bench time. Pass-through costs such as investigator grants and IRB fees are revenue with zero margin and must be offset in COGS to avoid overstated margins. ### Cost and Margin Calculation Flow Costs scale primarily with labour, which represents 70% to 80% of direct costs. Direct labour is built bottom-up from billable headcount and fully loaded cost per head, rather than as a percentage of revenue, allowing operating leverage to show as utilisation improves. - Travel, laboratory consumables, and pass-throughs are added to arrive at gross profit. Operating expenses include SG&A, business development, IT, and facilities, each tied to revenue percentages, headcount, or fixed escalation. - These feed into EBITDA, operating income, and net income, with margins influenced by offshoring and automation but offset by wage inflation. This structure helps users see how hiring, utilisation, and contract mix affect profitability. ### Outputs: Financial Statements and Key Metrics The model produces an income statement, balance sheet, and cash flow statement. It also generates working capital schedules for billed receivables, unbilled receivables, payables, and deferred revenue, plus a debt schedule with term loan amortisation and revolver mechanics. - Key outputs include book-to-bill ratio, DSCR, free cash flow, and balance sheet checks. Validation flags cover gross margin, EBITDA margin, utilisation caps, DSO, and cash floor, helping users catch unrealistic assumptions. - These outputs support evaluating the target's ability to convert backlog into cash and service debt under different growth and margin assumptions. ### Practical Use in Investment and Acquisition Decisions Practically, the model is structured for investors, acquirers, or operators assessing a CRO with roughly $50 million to $500 million in revenue. - It allows testing of scenarios such as changes in new bookings growth, cancellation rates, backlog burn, utilisation, and cost inflation. - The model highlights risks like ignoring pass-throughs, double-counting them, or assuming 100% utilisation, and it enforces checks such as balance sheet balancing and DSCR thresholds. - Because the public download is a values-only preview, users can see the logic and relationships without live formulas; the focus is on understanding how operating drivers translate into financial outcomes rather than predesigned results. ## Consolidated risk heat map Color-coded view of risk exposures relative to limits so you identify breaches and escalation triggers across all business lines at a glance. ## Hierarchical limit management Define limits at firm, business line, desk, and trader levels and cascade approvals and exception tracking through the hierarchy. ## Stress scenario library and P&L impact Maintain historical and hypothetical scenarios and calculate P&L impact across all portfolios instantly to support regulatory submissions and committee reporting. ## Consolidated risk heat map Color-coded view of risk exposures relative to limits so you identify breaches and escalation triggers across all business lines at a glance. ## Hierarchical limit management Define limits at firm, business line, desk, and trader levels and cascade approvals and exception tracking through the hierarchy. ## Stress scenario library and P&L impact Maintain historical and hypothetical scenarios and calculate P&L impact across all portfolios instantly to support regulatory submissions and committee reporting. ## Features - **Consolidated heat map:** Color-coded view of risk exposures relative to limits so you spot breaches and escalation triggers instantly. - **Limit management:** Define hierarchical limits (firm, business line, desk, trader) and cascade approvals and exceptions. - **Stress scenario library:** Maintain historical and hypothetical scenarios and instantly calculate P&L impact across all portfolios. ## Use cases - **Weekly risk committee reporting:** Generate comprehensive risk summary for risk committee with current exposures, breaches, and mitigation plans. - **Regulatory capital and stress testing:** Feed CRO model into capital models and stress tests (CCAR, ICAAP) required by banking regulators. - **Incident tracking and capital allocation:** Log operational losses and use to allocate operational risk capital by business line. ## Frequently asked questions ### What is a CRO dashboard? It is a consolidated risk reporting tool that aggregates market, credit, and operational risk exposures across business lines and tracks them against a firm-wide risk appetite and regulatory limits. ### How do I set risk limits? Start with industry peer benchmarks as a percentage of capital, then adjust based on your risk appetite and business strategy. Cascade limits through the hierarchy. ### What is VaR and how is it calculated? VaR (Value at Risk) is the maximum expected loss at a given confidence level over a time horizon. Common methods include historical simulation, parametric, and Monte Carlo. ### Can I automate data feeds into the dashboard? Yes. Use data warehouse APIs or ETL tools to pull positions, market data, and risk metrics automatically each day, reducing manual input and reconciliation. ### Who uses CRO dashboards? Chief risk officers, risk committees, business heads, and regulators use them for weekly risk reporting, regulatory stress testing under CCAR and ICAAP, and operational capital allocation. ## Related templates - [Credit Stress Testing Framework](https://finamodel.com/templates/stress-testing-model) - [Equity Portfolio Analysis](https://finamodel.com/templates/equity-portfolio-model)