 Corporate
Financial Modeling Course (Excel 2003, Excel 2007, Excel 2010 &
Excel 2011 for Apple)
This course is aimed at
intermediate to advanced users with an emphasis on users who can perform
functions like VLOOKUP and SUMIF.
If you are not sure what you or your organisations skill level is,
download this file
 ,
complete the Instructions and Questions sheets and email back to us for
a free skill assessment (South Africa and African countries only)
- Click here to go
back to the Live Training
Home Page
- For details on
timing refer to the schedule on the right
- For information on
pricing and venue please mail
adrian@AuditExcel.co.za or
Get
Price and Venue details |
|
Search the site
Advanced Excel Training Courses
Contact us for more
information on 011 563 3805/ 083 272 2552 or
info@AuditExcel.co.za
Excel Course in Rivonia
and Sandton, Johannesburg
Download Price and venue and see dates below
13- 17
Feb 2012 (less 10%)
12- 16
Mar 2012 (less 20%)
16-20
April 2012
14-18
May 2012
11-15
June 2012
18-20
July 2012
13- 17
Aug 2012
17- 21
Sep 2012
15-19
Oct 2012
12- 16
Nov 2012
Get
Price and Venue details
Watch a video clip of what you will learn
Featured Product
Online Excel training based
on the Excel for dummies series.
For a sample register by
clicking on this
link for a trial
Contact Details
Mail:
info@AuditExcel.co.za
Call: Adrian + 27 83 272 2552
Miricle Solutions cc PO Box
2683 Rivonia
2128 |
Who should attend
|
|
Contents
|
INTRODUCTION
This application-driven, hands-on
practical 2-day programme introduces the delegate to some of the
advanced functions and routines in Excel 2003 and Excel 2007, and leads delegates
through various financial modeling techniques, using Excel as
the tool.
It focuses on the basic nuts & bolts of
financial model preparation and structure, and provides the
delegate with useful modeling techniques than can be immediately
applied in the work place. This is a very hands-on,
non-intimidating, course – delegates work through various
practical exercises under the supervision, and with the help, of
the instructor to get to grips with practical modeling
techniques and, as a valuable spin-off, advanced Excel functions
useful (and essential) in the preparation of corporate financial
models.
WHO SHOULD ATTEND
o Financial officers, budget officers,
middle and senior management
o Persons involved in the construction
of project models
o All persons involved in the
construction and use of financial models, including budgets,
projections, evaluations, cash flows, projects, etc.
PRE REQUISITE'S
Delegates should be familiar with
Microsoft Excel (though not necessarily expert in the use
thereof, as any relevant Excel function pertinent to an exercise
will be discussed prior to tackling the exercise).
Excel knowledge required:
1. Basic Excel skills
a. Opening &
closing files
b. Moving around
the spreadsheet
c. Inserting &
deleting rows and columns
d. Inserting text &
formulas
e. Deleting cells
f. Copying formulas
g. Printing
2. Basic formulas (+-*/) e.g.
=C5+C7+sum(C9:C12), and =D5*D6/12
3. Formatting |
|
OUTCOMES
By the end of this 3-day
course delegates will know how to structure models correctly, and will
appreciate the necessity for so doing. They will understand the
interaction between Income Statements, Balance Sheets, and Cash Flow
statements in financial models, and the necessity for having them
What the delegates will learn (from an Excel 2003, Excel 2007
and Excel 2010 viewpoint):
The focus of the Financial Modelling course is to create a
financial or business model that has:
- Different time periods (months into years)
- Macro Economic factors (inflation, exchange rates, sales prices,
volumes) that affect the financial model
- Income Statement- forecasting
- Sales (Volume/ price/ exchange rates/ inflation)
- Cost of sales (margin)
- Fixed Costs- step ups based on volume
- Variable Costs- step ups/ linked to volume
- Depreciation- current assets and forecast capex
- Interest- amortization schedule
- Tax- handling assessed losses, SARS creditor and semi annual
payments
- Dividends- amount available based on retained income and cash
- Balance Sheet- forecasting
- Starting balance sheet
- Equity contributions
- Linking to the Income Statement
- Fixed Assets
- Working Capital- debtors, creditors and inventory
- Cash- NOT a balancing number- Calculated
- Debt schedules for handling different types of debt
- Cash Flow
- Linked to the Income Statement and Balance Sheet
- Interest charged versus interest paid
- Tax Charged versus Tax paid
- Valuations
- Free Cash Flow
- Terminal Values
- WACC
- Ratios
- Excel's inbuilt tools versus manual calculations- NPV, IRR,
XNPV, XIRR
- Debt covenants
- Sensitivities
- Scenarios
- Data Tables
- Goalseeking
- Building a financial model so that last minute sensitivities
can be created
- Reporting
- Changing reporting periods easily
|
.gif)
.gif)
