Financial Modelling - Crash Course

pic
Jacek Polewski Excel Expert with over 10 years of Commercial Experience 5.00
Past course

What this course covers


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).

Topics Covered:

  1. What is a Cash Flow Model and why should you use it
  2. How to structure a model
  3. Using Excel in creating a model
  4. Keeping your model concise, easy to modify and present
  5. Overview of sensitivity analysis and other techniques

For more on other courses provided go to: http://www.challengejp.com/excel-courses/

Your instructor


pic
Jacek Polewski Excel Expert with over 10 years of Commercial Experience

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.

Other suggested courses


Type

Location course

When
Tue 09 May 2017, 18:30-20:30
Add to my calendar
Where

eOffice Soho, Holden House, 57 Rathbone Place, London
Postcode: W1T 1JU


Category

Finance courses

Skills and Topics

excel course, excel lesson, excel training, excel help, financial model, cash flow, finance

Level

Beginner

Prerequisites

General familiarity with Excel is required. You will be given access to discounted individual Excel lesson should you decide you need more help at the end of the workshop.

Rating
Not yet rated
Share


Follow Course

Print
Click below for a print-friendly layout
 Print Course
Course Reviews
No reviews yet