About the course
Learn to model an integrated set of Financial Statements
The Course takes the user step by step through the process of modelling the Income Statement, the Cashflow Statement and the Balance Sheet. Starting from a clean spreadsheet, the user learns to analyse historical trends, identify key "Drivers", seek additional information and make defensible model assumptions. Next, the user learns how to accurately and efficiently convert the model assumptions into an integrated set of pro-forma financial statements.
Each core module covers:
- Forecasting Methods
- Model Assumptions
- Cell by cell modelling instructions
- Demonstration Video
- "Check" spreadsheets to verify work completed
- Detailed notes as an on-going reference The Course also covers modelling best practice, a discussion of key management ratios and instructions on how to use the model to carry out different types of analyses.
Atul has worked as a senior project financier with Australian, Japanese and French banks for over 15 years. He has core expertise in structuring debt and equity for infrastructure projects (toll roads, airports, rail, pipelines), public private partnerships (schools, convention centres, hospitals...
Videos and materials
Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.
We are happy to help you find a suitable online alternative.