Financial Modeling Consultant
Posted 5 days ago by Carnegie Consulting
£125 Per hour
Undetermined
Remote
London Area, United Kingdom
Summary: The role of Financial Modeling Consultant involves creating a comprehensive financial operating model for a recently acquired Environmental Services Business, focusing on detailed reporting and scenario analysis. The consultant will be responsible for developing various financial outputs, including P&L, cash flow, and debt calculations, to support strategic decision-making. This project is expected to last 6-8 weeks and can be performed remotely. The ideal candidate will have extensive experience in corporate finance and advanced financial modeling.
Key Responsibilities:
- Create a master financial operating model for the Environmental Services Business.
- Develop outputs including P&L, cash flow, and balance sheet analyses.
- Perform scenario-based analysis and sensitivity testing on key sales variables.
- Engage with senior leaders and investors to provide data-driven insights.
- Ensure the model accommodates various financial calculations and reporting requirements.
Key Skills:
- Advanced financial modeling expertise.
- Strong background in corporate finance and strategic planning.
- Experience in building custom financial models.
- Ability to perform complex scenario analysis.
- Excellent analytical and communication skills.
Salary (Rate): £125.00/hr
City: London
Country: United Kingdom
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: Other
The Opportunity: (6-8 week project) My client (CFO of a recently acquired Environmental Services Business) is keen to hire a highly accomplished financial modeler to create a “master” financial operating model The firm has recently been acquired by a US based Private Equity investor and ongoing future reporting requirements will be detailed and challenging It is key that the model can manage a wide range of outputs, as well as perform a wide range of scenario-based analysis Calculated outputs will include: P&L Monthly / Outturn, AND P&L Run Rate Methodology Outputs Balance Sheet – Monthly / Outturn Cashflow (including working capital (WC) analysis – Monthly / Outturn, AND Cashflow 13-week forward view from Monthly Cashflow Debt calculations (including synergies & add backs) – Covenants Valuations – EV to Equity & Investor Returns / Waterfall Monthly Board Deck Outputs Capitalization Table (calculated equity and debt on bolt-ons) Variance-Covariance (VCP) and Regression & Optimization (R&O) Summary Income Tax AND Debt Interest Schedules Acquisition Deal One Page Scenario Analysis: Budget, Forecast, and Bank will be direct inputs to calculate the scenario The Run Rate should follow the defined ‘run rate methodology.’ Other scenarios will be % sensitivity-based from the Forecast on the defined key sales variables / with a cost relationship mapped to revenue (so will need to be flexed as appropriate) Flex vehicle capex based on the P&L inputs, assumptions, i.e. number of rounds Turn on or off R&Os Add or turn off core model bolt-ons Bolt-ons will need to follow into the Cap Your Experience: You will be a highly experienced project-based Corporate Finance professional specialising in advanced financial modelling, strategic planning, and analysis Your experience will demonstrate your ability to build and executing custom financial models and provide analysis that empowers senior leaders to make data-driven decisions, engage with investors confidently, and achieve strategic milestones This piece of work is projected to last 6 – 8 weeks and you must be able to commit to this. Start date is “yesterday”!! The role can be 100% remote if required, so, your physical location is not that important. My client’s office is based in Holborn for those keen and able to have some office presence