The purpose of the workshop is for participants to learn how to build a project finance model using best practice principles. This will include the development of financial statements and the mastering of the main Excel techniques (such as forecasting, risk issues, differing scenarios and optimisation). They will learn how to deal with more problematic modelling issues and gain hands-on experience of applying these skills. By building a complete model, participants will gain the confidence to build and revise their own models.
Many models fail due to inadequate structures and methodology and this workshop offers the opportunity to build a comprehensive financial model using international best-practice principles. The workshop commences with a discussion of objectives and common mistakes and then develops the case model in stages. On completion, participants will have built a complete model for future use and review.
Who should attend?
- Project finance executives
- Financial controllers and managers
- Financial and business analysts
- Project risk managers
The workshop is taught using demonstrations combined with practical and interactive case studies. The exercises in each session reinforce the concepts covered in each of the units. Emphasis is placed on delegates gaining practical, hands-on experience of the design and construction of financial models in Excel. Comprehensive product notes and modelling software are provided for future reference.
Participants will receive printouts of all slides and the Excel spreadsheets used during the workshop plus a selection of templates and add-ins.
Seminář bude velmi praktický a výuka bude probíhat v MS Excelu. Žádáme účastníky, aby si přinesli notebook vybavený Excelem. Účastníci budou provádět praktická cvičení, aby zvládli různé analytické techniky a metody.
Microsoft®, Excel® a Windows® jsou registrovanými ochrannými známkami společnosti MICROSOFT.