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.
A financial model is a tool that usually comes as an integrated part of any ‘spreadsheet software’, like Microsoft Excel to forecast the financial prediction of the business in the future. I
This course is designed to develop your financial modeling skills through the evaluation and analysis of real-life case studies. It will also develop your knowledge and understanding of finance enabling you to make financial decisions, which will reduce costs, increase profit and minimize risk.
This course provides a comprehensive exploration of advanced financial modelling techniques, data analysis methods, and analytical tools, offering the knowledge and practical skills needed to make sound financial decisions.
Financial modelling is the method performed to build a financial representation of a company. Financial analyst forecasts future earnings and performance of the company using these financial models.
The modern business professional needs to be able to use spreadsheet software such as Excel to support good business decisions. This course offers training in the enhanced use of spreadsheets to support both short-term and long-term financial decisions.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy