This practical course will give you an overview of the basics in Financial Modelling and will teach you how to use Excel in creating cash flow models.
What will I get out of the course?
By introducing you to the mechanics of cash flow models and the most relevant functions in Excel the course aims at giving you confidence in using the model on your own. At the end of the lesson you will be given a sample file which will guide you in structuring a model of your own and strengthen the knowledge of the topics covered.
How is the course structured?
The course starts with an introduction to the main concepts of financial modelling. It then proceeds to the practical part on how to create a model in Excel. In that part I will be introducing most relevant formulas and techniques to help us create a self-contained cash flow model.
Where can I apply the skills gained?
Cash Flow model is one of the fundamental tools whether you working on securing financing for a new company or building a business case for your project. It helps you in understanding the main financial drivers of your venture and clarifies the links between your main drivers and main outputs such as revenues, profits or cash flow. With the knowledge on how to design your own model you increase control over your finances and you decrease reliance on others.
What do I need to bring?
Bring bring pen, paper and laptop. You can also download a sample model before the lesson and bring it on your laptop (click here to download it).
For more on other courses provided go to: http://www.challengejp.com/excel-courses/
Hi. My name is Jacek and I love Excel! With over 10 years of experience working in Business, Finance and Data Analysis I am looking forward to help you learn, understand and apply Excel through my group and individual courses.