Analysis of the profitability of a fund’s investment

Equity investment of fund

Context

  • Equity investment in a fund experiencing material profitability pressures, primarily due to rising raw material costs

Objectives

  • Identify the company’s profit and loss centers and implement a detailed profitability monitoring system
  • Establish a sustainable management control system in the medium term

Deliverables achieved

  • Allocation rules by account and by product
  • Reporting with a profit and loss statement by activity
  • Profitability analysis by product or client family and group
  • Presentation of the profitability model analysis
  • Formalized roadmap with action plans, assigned responsibilities, and timeline

Key success factors

  • Involving operational teams in the review of costs and allocation rules
  • Supporting the management team in the implementation of FP&A and in adapting the range of products on offer

Tools used

  • Excel / Power Query

Our other customer cases

Automated business plan modelling. Support for growth operations | Modeling of growth operations | Start-up and SME
Target audit in the context of an acquisition. Audit and internal control | Financial audit | Start-up and SME
Development of an application with a validation workflow for managing annual restatements. Finance transformation | Transformation of the finance function | Mid-cap and large group
Creation of investor reports and monitoring of valuations using Power BI. Development of Power BI dashboards | Modelling and performance analysis | Funds
Long-term support with the financial management of a business unit. Financial and operational management | Outsourced FP&A | Mid-cap and large group
Carried out a transition assignment between two FP&A directors in a mid-cap company. Financial and operational management | Outsourced FP&A | Mid-cap and large group