Financial Modelling

Course Objectives

This two-day course is designed to teach you how to build "from scratch" an integrated balance sheet, profit and loss and cash flow forecasting model appropriate for equity valuation and debt related analysis.

Course Approach
 
Tutor-led discussion
PC-based case studies
Design and coding exercises
Financial model construction

Assumed Knowledge

A good knowledge of Excel and accounting is assumed. This knowledge includes the understanding of navigating around worksheets and workbooks; basic data entry; the difference between relative and absolute referencing (ie dollarisation); adding (summing) and subtracting cells and an awareness of what the Excel menus contain

Who Should Attend

Do you have a basic knowledge of Excel and are you, or are you expected to be, involved in any type of financial modelling and forecasting? If so, this course is an excellent development tool for you. It is particularly relevant to corporate and project financiers, finance and project managers, accountants and bankers.

Key Features

•Some Excel Basics and the Basics of Design
•Building the Framework
•Building the Schedules
Building the Debt Schedule
Balancing – Straight Away
•Cash Flows
•Tax and Valuation
•Analysis and Presentation