Financial Spreading

Collecting, spreading & analyzing financial statement data

Financial Spreading Module

Software solution for spreading & analysis of financial statements

Capturing and spreading financial statements and calculating financial ratios are key processes in credit risk management. The Financial Spreading software offers a comprehensive feature set for collecting, spreading, and analyzing financial statement data, which includes but is not limited to balance sheets, profit and loss statements and cash flow statements. Using fully configurable financial spreading templates, the software can calculate financial ratios no matter the complexity – and generate financial analysis reports. These reports can include peer-group analysis to benchmark counterparties with similar companies in the same market or industry.

ACTICO's Financial Spreading Module


Key Features

Capture financial statements

The application allows users to capture, analyze and manage financial statements within a central web-based application. The system supports various accounting standards, such as IFRS, US-GAAP and other local GAAPs. 

Financial analysis

The module automatically calculates financial ratios, which can be integrated into further risk rating and loan origination processes. Formulas are administered through MS Excel spreadsheets to calculate financial ratios, which provides a high level of flexibility.

Peer-group analysis

The Financial Spreading software has a wide range of comparison functionalities. This includes multi-year trend analysis of a single counterparty and comparison of companies with their peer groups.

Generate reports & analyses

The Financial Spreading module lets you generate reports in various formats, such as PDF, MS Word, and MS PowerPoint. The reports are fully configurable and may contain comprehensive counterparty analysis (e.g. peer-group analysis).

Financial covenants

The software enables financial covenants to be set up and tracked within the application. Covenants can be defined on an obligor or facility level and are subject to the specific credit policies of a financial institution.

Import & export data

Financial statements can be imported and exported via MS Excel. In addition, financial data can be obtained from external data sources, such as local credit bureaus or other data providers.

features
"Our counterparty risk rating process includes both a complex qualitative risk assessment and a quantitative analysis based on the company’s financials."
Credit Risk Team, Volkswagen Financial Services

Benefits

Centralized data collection

All raw and derived financial statement data is stored in a centralized database. This includes financial statements that have been captured by analysts using the web-based front-end and statements that have been imported from external data sources.

Maximum flexibility

The Financial Spreading module can be fully adapted to meet individual requirements. All configurations, such as changes to the financial templates or financial ratios, can be performed using MS Excel spreadsheets. This ensures maximum flexibility, accelerates time-to-market and reduces overall total cost of ownership.

High scalability

The Financial Spreading module is based on the most current state-of-the-art technologies and system architecture. The platform has been designed for high availability and high scalability in the enterprise software segment. All data is stored in a centralized database and is available for data analysis and reporting requirements.

Version management & auditability

New or updated spreading templates are uploaded into the web application and activated by users with specific privileges. This ensures that only authorized users can deploy and/or activate new spreading templates.

Easy-to-use front end

End users, such as financial analysts, credit analysts, are provided with web-based user interfaces to perform the process of financial spreading and analysis. These interfaces are used to collect, import, spread, analyze, and consolidate financial statement data.

Seamless integration

The Financial Spreading module seamlessly integrates with a bank’s existing internal system, e.g. core banking system. A standard interface provides access to financial data from related key processes in commercial banking, such as risk rating, loan underwriting, and origination.