Senior Modeller - Carnegie Consulting

The Opportunity:

• 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 Pager

• 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