Advanced Excel Modelling Course
|
Location: London (Central) |
Dates: 11.09.2012 - 12.09.2012 | Duration: 2 Days | Price: 1,125.00 GBP |
|
This course will teach participants how to construct a financial forecast of any industrial company. Attention is paid both to isolating the business drivers and ensuring that assumptions and results pass reality checks, and to the mechanics of proper treatment of fixed assets, working capital requirements, provisions, equity capital requirements, and the allocation of net cash flows between long term debt, short term debt, and cash. All required accounting principles are explained as encountered, and only a basic familiarity with spreadsheets is assumed. Teaching method Over the course of the two days participantss will build a fully integrated financial forecast – profit and loss account, cash flow statement and balance sheet – for a case company. The training process is an alternation between discussion of the relevant issues and supervised production of a model and interpretation of its conclusions. Participants will receive the final version which is a template that can be readily converted to meet their future corporate modelling requirements. Participants will be required to bring a laptop with Excel loaded to the course. Course categories:Debt / Fixed Income Courses, Asset Management Courses, Derivatives Courses, Equities Courses, Financial Modelling, Hedge Funds Courses, Financial Modelling Inhouse |
|||
|
Day one General introduction Participants review spreadsheet model outline and structure Populating the history Participants discuss and enter historical financials for target company Operating drivers Participants discuss forecast drivers for target company and project revenue and EBIT or EBITDA for the group or company Modelling fixed assets Participants model property, plant and equipment and intangible assets, calculate fixed asset turns, and assess realism of capital expenditure projections Modelling working capital Participants calculate historical working capital requirements for target company, discuss forecast drivers, and project balance sheet items and annual movements in working capital Modelling provisions Participants project deferred tax, pension and restructuring provisions for the target company and discuss differences between their drivers and likely forecast assumptions |
Day two Associates Participants project profits, dividends and book values for associated companies, and discuss how these line items are reflected in consolidated accounts Minorities The distinction is drawn between disparate minority interests and a single large minority interest, and the implied treatment of each. Participants project profits, dividends and book values for minorities, and discuss their connection to group financial statements Shareholders’ funds Participants model simple accrual of retentions and then add a routine to permit capital increases or decreases Cash flow statement Participants connect cash flows down to change in net debt Net debt Participants allocate net cash flow between long and short term debt and cash Closing the model Participants connect and check balance sheets, take interest charges to the profit and loss, and produce and interpret resulting ratios, for various scenarios |
||
|
CONTACT US |
|||
 |
Email: info@financialveritas.com Phone: +44 208 133 5917 |
 |
 |
