CDC Senegal Economic and Financial Model Template

This comprehensive financial and economic model is specifically designed for the Caisse des Dépôts et Consignations du Sénégal (CDC SN). It serves as a robust framework for managing the unique dual mission of a public financial institution: securing public deposits and financing long-term national development. The template translates complex institutional mandates into a structured financial environment, allowing users to simulate the triple transformation of maturity, liquidity, and risk that defines the CDC's economic role.

The template is organized into several integrated modules. It begins with the Institutional Framework, where legal missions and statutory attributes are defined. The core of the tool consists of detailed sheets for the Economic Model, covering resource modeling such as judicial consignments, regulated savings, and management mandates. On the application side, it provides dedicated sections for valuing diverse asset classes including sovereign bonds, strategic equity participations, real estate portfolios, and large-scale infrastructure projects. The financial output is presented through professional-grade Balance Sheets and Income Statements (P&L), which automatically calculate key performance indicators like Net Banking Income (PNB), Gross Operating Profit (RBE), and Return on Equity (ROE).

This tool is particularly useful for financial directors, risk managers, and institutional planners who need to solve the challenge of maintaining high liquidity and solvency while engaging in long-term territorial development. It helps track regulatory ratios such as the Liquidity Coverage Ratio (LCR) and Net Stable Funding Ratio (NSFR), ensuring that the institution remains compliant with West African Monetary Union (UMOA) standards and specific national laws. By centralizing data from various departments—from legal consignments to infrastructure investment—it provides a single source of truth for strategic decision-making and stress testing.

How to use this template:

1. Start by configuring the Institutional and Regulatory parameters, including the current legal reserve requirements and prudential ratio thresholds (e.g., 8% solvency ratio).
2. Populate the Resource and Employment sections with current data, entering details for judicial deposits, savings accounts, and existing investment portfolios across bonds, equity, and loans.
3. Utilize the ALM (Asset-Liability Management) and Risk modules to calculate maturity gaps, duration sensitivities, and credit risk metrics like Probability of Default (PD) and Loss Given Default (LGD).
4. Review the generated Financial Statements and Performance Dashboards to assess the institution's profitability and impact on public policy goals.

Expected benefits include significantly reduced time for regulatory reporting, enhanced precision in liquidity forecasting, and a more scientific approach to asset allocation and risk mitigation.