The course participants gained a deeper understanding of efficient modelling and a general improvement in their Excel skills. The training has been delivered in German using F1F9 staff based in Germany and has been held annually since 2015. Since 2015 and supported by WKGT’s in-house FAST modelling champions, we have delivered several intensive in-house financial modelling courses and provided ongoing post-course learning in the form of online tutorials and support from our modelling experts. The participants included junior team members as well as seasoned professionals from varied service lines including Corporate Finance, M&A, Audit & Assurance, and Valuation. The course has been popular and in high demand – with participants enjoying the study material and the opportunity to present their work to senior colleagues.įollowing a recommendation from Grant Thornton UK, Warth & Klein Grant Thornton (WKGT) with offices in Hamburg and Düsseldorf, Germany, engaged F1F9 to enhance proficiency in financial modelling in Excel, within the organisation. Mubadala’s commitment to a single financial modelling standard has resulted in its analysts understanding the importance of a common approach and honing their technical skills.

We continue to work with Mubadala’s learning and development team in improving the design of the programme. This included the development of further case studies relevant to the work being undertaken (including a hotel and a satellite). Since running the early programmes, we have amended the course material to give it a more general appeal (suitable for analysts for whom modelling is not core but nonetheless important). Based on a real-world case study, the training took participants through all the requirements for financial modelling from basic skills and drills in Excel to the design and construction of a highly complex set of financing requirements. Our initial brief was to run a programme for Mubadala’s core modellers – those professionals who work with financial models of considerable complexity on a daily basis. At the final stage of the programme, participants are required to present to senior members of the organisation. Our training programme uses a variety of learning approaches: self-study backed up with support from our team of modellers, informal and formal assessments, instructor-led classroom sessions and webinars. We have taught over 200 analysts from a wide variety of sectors. We have been working with Mubadala to standardise their approach to financial modelling (“The Mubadala Way”) since 2012. The staff we have trained are now equipped to build better structured, more robust models and have direct access to F1F9 resource wherever it adds value. We recently supplemented this engagement with a ‘model clinic’ and remediation work to a tax model that the Energia Group identified as a priority for development.Īs a result of this work, the Energia Group has realised significant efficiencies in their modelling practices. In response to this we delivered a series of in-house training courses on best practice excel modelling to finance delegates from businesses across the Group. Subsequently, Energia Group expressed a desire to improve and standardise their range of financial reporting and forecasting models. In 2018, F1F9 created a best practice budgeting and reporting model for Power NI, followed by two smaller builds looking in more detail at specific elements of the business. Their parent is the Energia Group, a leading integrated Irish energy business with substantial businesses in both the Republic of Ireland and Northern Ireland. Power NI is the largest electricity company in Northern Ireland. The new process has been fully adopted within Virgin Trains and F1F9 are providing ongoing support. We worked in close collaboration with our Virgin Trains contacts and completed the work in 2 months. The reporting process is now simple and more accurate with a rapid turnaround. This dramatically increased budgeting and forecasting efficiency as well as reducing the risk of errors. Duplication of common inputs led to inconsistency.į1F9 created a new process for updating, analysing and communicating large financial datasets in 8 Excel financial models which take inputs from core non-Excel management information systems. Over 80 spreadsheets were in use across 11 departments for the budget process alone. The company’s previous process for budgeting, reporting actuals and updating forecasts was complex and time-consuming, with the complexity leading to errors in the final output. It operates long-distance passenger services on the West Coast Main Line between London, West Midlands, North West England, North Wales and Scotland. Virgin Trains is a train operating company that has operated the InterCity West Coast franchise since 1997.

F1 f9 macro download