Logo - Keyrus
  • Playbook
  • Services
    Data advisory & consulting
    Data & analytics solutions
    Artificial Intelligence (AI)
    Enterprise Performance Management (EPM)
    Digital & multi-experience
  • Insights
  • Partners
  • Careers
  • About us
    What sets us apart
    Company purpose
    Innovation & Technologies
    Committed Keyrus
    Regulatory compliance
    Investors
    Management team
    Brands
    Locations
  • Contact UsJoin us

Optimize Cash Flow and Improve Financial Control with a 13-Week Cash Forecasting Solution

Background

Our client is a leading global biopharmaceutical company that focuses on developing medicines for psychiatric and neurological disorders. Their patient-inspired science, integrated research strategy, and sophisticated development capabilities enable them to pursue the development and commercialization of innovative new medicines. With a team of over 2,100 professionals, they are headquartered in Europe and have R&D and manufacturing facilities in the US.

Challenge

The Treasury team relied on Microsoft Excel for cash flow planning, forecasting, and reporting, which required extensive manual effort to consolidate and reconcile data across various systems. With each new data update, like the addition of customers, significant time was spent adjusting the Excel model to accommodate these changes. The team aimed to reduce the time spent on data collection and model adjustments, allowing them to focus more on analysis and reporting for better cash flow insights.

Approach

Keyrus assisted with designing, developing, and deploying an automated 13-week cash forecasting model in Anaplan. The model includes a detailed projection of expected cash receipts and disbursements from operating activities, cash from investing and financing, and bank balances. An automated process was developed to automate source data loads and calculate strategic cash flow metrics. The model was configured for users to drill down from summarized reports to source transactional data. Treasury, Finance and Accounting can quickly conduct scenario modeling for instant insights and improved decision making.

Key results

01
Automate data collection and cash flow calculations
02
Enhanced visibility into cash flow drivers
03
Improved decision making enabled by scenario modeling

Benefits

The treasury and finance teams can now spend their time analyzing and reporting cash flow data instead of collecting and reconciling data. They can efficiently produce a clear, detailed view of cash inflows and outflows over a 13-week period, enabling them to better understand their short-term liquidity position. Scenario modeling capabilities empower the team to simulate different financial outcomes, helping them make informed decisions based on the potential risks and rewards of various strategies.

Technology partners

Anaplan

Anaplan is a cloud-based SaaS solution that helps organizations optimize performance and drive digital transformation with confidence and agility.

150+

certified consultants

200+

clients

10+

years of partnership

Share this key play

whatsapptwitter
linkedinfacebookworkplace

More key plays

Enhancing Operational Process Performance with a Modern Cloud Platform
Smarter, Faster, and Scalable: How Keyrus Leveraged GenAI and UNSPSC for Product Classification
Faster Power BI Reports and Better Use of Premium Capacity: How We Helped Pernod Ricard Do It
How We Enabled Massport to Gather Data about their Infrastructure Conditions to Achieve Agency's Mission and Goals
Connect Operations, Finance, and Vendors into One Seamless Vendor Management Process
Driving revenue growth management through gross-to-net optimization
Transforming maritime planning to drive operational efficiency and profitability
Boost sales with targeted marketing campaigns and multi-channel communication
Data, Technology & Digitalization for One of the Biggest Agro Companies in Brazil
Increase conversion rates for online customers
Logo - Keyrus
New York City

252 West 37th st., Suite 1400 New York, NY 10018

Phone:+1 646 664 4872