Senior Modeller - Carnegie Consulting - eFinancialCareers : Job Details

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