Using best practice modelling rules and Excel shortcuts, based on real historical financial statements, participants will learn how to forecast and put together a fully integrated financial model. This training will give them the basic modelling fundamentals to continue working on their in-house mod
Using best practice modelling rules and Excel shortcuts, based on real historical financial statements, participants will learn how to forecast and put together a fully integrated financial model. This training will give them the basic modelling fundamentals to continue working on their in-house models.
Key Topics
Using Excel keyboard shortcuts
Using standards for best practise
Understanding circular references and iteration
Modeling a detailed three-statement financial model step-by-step
Modeling a detailed debt schedule include a cash sweep
Finding errors and integrity checking
Who Should Attend?
Financial analysts in investment banks
Junior equity research
Junior investment managers
Finance functions at corporations
City Training UK (“City Training”) is a world leading provider of premium public courses, in-house training and courses for universities and schools.
City Training was founded and is currently managed by several ex-investment bankers who are trainers themselves and passionate about training.
We work with a team of expert trainers, who are among the most experienced specialists in their respective fields. You and your team will benefit from the knowledge, experience and creative approach of a professional with years’ of experience in your sector using recent case studies in your industry.
Why Choose City Training?
Client Focus – A small London-based friendly team dedicated to its clients and tailoring courses to your business.
Experience and professionalism – Our trainers all held senior positions in the City, Wall Street or other leading financial centres and are talented lecturers. Practical Programmes – Up-to-date, practical training including all the latest trends and recent case studies in your field
From heads of departments to credit analysts, recent graduate joining M&A, vice-president in private equity, middle office risk professionals, our trainers have trained thousands of professionals at the following leading institutions worldwide.
The course will emphasize some important financial concepts that will assist in building vigorous models. It is designed to give you the information you need without making you wade through cumbersome explanations and endless technical background.
This programme will train you how to build robust forecast models for companies. You will progressively build an integrated balance sheet, profit and loss, and cash flow forecasting model.
Learn to use conceptual knowledge, practical and functional skills to design and implement precise financial solutions.
We offer courses in financial spreadsheet modeling for both finance professionals. If you are looking for an introduction to financial modeling, a practical guide, a refresher or to enhance your existing understanding then we have the right course for you.
This two-day course is designed for those looking to expand their financial modelling skills. Numerous hands-on practical Excel exercises are used to demonstrate different functionality in a modelling context.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy