Integrated Three Statement Financial Modelling

FP&A leader rising above the noise

Lead with Impact and influence with integrated three statement financial modelling powered by Anaplan.

Build integrated plans across multiple scenarios and leverage integrated planning to understand the outcomes of your strategic options. Truly influence the strategic outcomes of your organisation by becoming the steward of the whole financial landscape.

Develop impactful strategic solutions to your most complex business challenges and gain insights across multiple integrated scenarios. Test assumptions, challenge the status quo and carve out opportunities that will win in your competitive environment.

Achieve with confidence, trust that all possible outcomes have been mapped accurately across your entire organisation and know that your analysis has integrity, your plan is robust and your numbers are sound. Attain all this while your competitors continue to struggle with outdated, siloed and slow systems and processes.

Realise the full value of your Anaplan platform with a complete three statement financial planning solution.

An integrated data platform built within your Anaplan platform is at the heart of your financial model and ensures your data is always accessible, of a high quality and can act as a single source of the truth. The solution starts with understanding, designing and building a complete data model in Anaplan from which actuals data can be extracted and modelled.

The solution then progresses to the design and build of a comprehensive statement of financial performance along with the forecasting and budgeting processes that build up financial projections. This is the foundation of your analysis of organisational performance from sales, operational, financial, logistical and more.

From here the solution moves onto the statement of financial position where your financial and investment strategies are modelled and their impact on performance analysed.

These strategies lead directly into how your organisation manages it’s cash position across operational, investment and financing activities. It is the statement of cash flows which provides you with the a comprehensive view of movements across all three.

Your comprehensive financial data model while providing integrated financial reporting across all three key statements is enhanced with the ability to model and report across multiple scenarios and currencies.

Your reporting will include rate, volume and mix analysis if applicable alongside all other standard variances, ratios and key performance indicators. Industry specific measures can also be integrated seamlessly along with detailed financial or mathematical calculations.

Comprehensive Data Model

  • Data imports from source systems

  • Data cleansing

  • Data export to financial models

  • List & hierarchy management

    • List properties and metadata

    • Hierarchy design and build

  • User management

  • Model security

Statement of Financial Performance

  • Revenue planning

  • Gross margin & profitability planning

  • Overheads planning

    • Travel & Entertainment

    • Rent, rates and utilities

    • Marketing, promotion & brand

    • Ecommerce, digital and website

    • Workforce planning

    • Research & development

    • Legal

    • Financing

    • Tax planning

    • Insurance

    • Logistics

    • Administration

    • Projects

  • Interest

  • Tax

Statement of Financial Position

  • Investment planning

    • Net present value analysis

    • Internal rate of return analysis

    • Payback analysis

  • Project Planning

    • Capex ratio

  • Funding Planning

    • Debt

    • Equity

    • Weighted average cost of capital

    • Debt to equity ratio

    • Return on equity

Statement of Cash Flows

  • Operating cashflows

    • Working capital planning

    • Debtor days

    • Aged debtors analysis

    • Creditor days

    • Accounts Receivable Turnover

    • Accounts payable turnover

    • Current and quick ratio

    • Inventory turnover

  • Investing cashflows

  • Funding cashflows

Enhanced with…

  • Scenario planning

  • Variance analysis

  • Rate, volume and mix analysis

  • Multi currency conversion

Supported by best practice Anaplan design & architecture

Anaplan user experience

  • Standardised navigation design ensures your users are able to easily and simply navigate the model.

    Designed to be consistent, structures, colours and navigation prompts create a welcoming workspace where your users are able to locate their desired page with ease.

  • Designed using an approach known as progressive disclosure, your dashboards will allow users to easily explore, extrapolate and examine data at all levels of abstraction.

    Enabling your users to extract top level trends, summary point patterns and base layer analysis your user dashboards will be built in successive layers, each layer linked to the next and containing increasingly more detail.

    Designed to empower your users to answer key questions, this layered design offers your team the ability to gain access to the insights they seek no matter what level of detail is required within a single model.

  • From yearly financial statements, quarterly earnings calls to monthly departmental performance reviews Anaplan management reporting pages are designed to meet your key reporting requirements.

    With the ability to add custom images, build dynamic charts and connect live with model outputs your management reports will be custom designed and built to serve all you key model stakeholders.

  • Designed to enable access to your Anaplan application while away from your desk.

    The mobile app function ensures that you are never too far away from the insights you need.

  • Built to allow continued use of your go-to financial analysis tool, Excel.

    The Office extensions allow your users to view, manipulate and upload changes to key Anaplan tables from within an Anaplan Excel add-in.

    Data is refreshed and updated live whenever the underlying model is changed allowing your team to integrate Anaplan outputs into any number of existing Excel models

Anaplan functional design

  • Built to integrate seamlessly with all key data imports.

    Data integration settings are built to ensure that your Anaplan model is always utilising the most current data sets from other connect systems within your organisation.

  • Processes designed to simplify the management of all your planning dimensions ensures that your Anaplan hierarchies are always current and true.

    Use of multiple list types, parallel hierarchies and varying roll-ups necessitates a robust approach to list and hierarchy management.

    Balanced, ragged and flat list are used in combination with Anaplan automation process to build, amend and restructure hierarchies.

    New items are added with ease, integrated into all relevant hierarchal structures.

    Redundant items are validated before being removed automatically to ensure your model remains lean and efficient.

    Hierarchy metadata properties are validated, inconsistencies flagged and omissions highlighted for attention.

    Your model list management processes will require minimal intervention. If required, your Anaplan team will always know where to focus their admin to ensure efficient resolution when it can not be automated.

  • Your users are at the heart of your Anaplan application.

    User management process design focused on ensuring Anaplan permissions and access rights are managed centrally and in a separate dedicated user management model.

    This can also be further isolated in its own dedicated workspace to provide an additional layer of security.

    A centralised user management model acts as a security hub and ensures consistency across all you Anaplan models.

  • Your planning dimensions will be associated with a variety of metadata properties or attributes.

    Designed to ensure consistency your metadata management will ensure that a single point acts as the sole source of metadata for all affected dimensions and hierarchies.

    This minimises metabata conflicts, that parallel hierarchies are assigned consistent properties and data can be effectively moved across and within these dimensions.

  • Your Anaplan application will evolve.

    Designed from the start to scale as you grow and to flex as you move forward your Anaplan applications will utilise Anaplan’s development tool, Application Lifecycle Management (ALM).

    ALM creates a sandbox development environment to design, build and test new functionality.

    Used throughout the build process of you integrated three statement model it is a key resource in maintaining the integrity and efficiency of your model in the medium to long term.

    The design of your Anaplan application will ensure that ALM will work seamlessly.