This course addresses a number of important accounting issues and key factors in financial modelling. You will be introduced to best practice financial modelling techniques, whilst focusing on both the incomings and outgoings that need to be managed in financial modelling processes. Areas such as income statements, cash calculations, balance sheets, assets and liabilities taxation, and analysing financial data in graphics and data tables are all covered.
- Develop robust, fully integrated financial forecasting models, which include sensitivity analysis, data tables and graphics
- Explain the adjustments that have to be made to the accounting profit to give taxable profit
- Understand tax coding and computation, managing tax loss and modelling of deferred tax
- Demonstrate a knowledge of modelling, income statements, cash calculations, non-current assets and non-current liabilities
- Best Practice Modelling. Introduces how to model a company’s accounts. The four key stages of modelling: Planning, Documentation, Building and Finalisation.
- Income Statements. What should be shown in an income statement and how it needs to be disclosed?
- Cash. Introduces the most important calculation in most financial models – the cash calculation
- Balance Sheet. Showing what a company owns and what it owes. Working out current assets and current liabilities using ratios
- Non-current Assets. Modelling fixed assets. Depreciation – What it is, why we need it, how to model depreciation? Goodwill – How it arises, how it is dealt with in a company’s accounts and how it should be modelled.
- Non-current Liabilities. The different types of debt used by a company. How these should be modelled and how to work out the interest on them accurately
- Taxation. The adjustments that have to be made to the accounting profit to give the taxable profit and the reasons for these adjustments. How to code a basic tax computation and how to deal with tax losses.
- Deferred Tax. What deferred tax is and why it arises. How to model deferred tax on tax losses and deferred tax on accelerated capital allowances.
- Sensitivity Analysis. What sensitivity analysis is? Two ways of incorporating sensitivity analysis into a mode and how easy it is to add it to a well written model.
- Data Tables & Graphics. What data tables are and how useful they can be. How to add data tables to a model and use the results to plot appropriate graphic
The Advanced course is aimed at individuals with a working knowledge of Excel and an accounting background, who wish to master accounting related issues such as cash flow, sensitive analysis and taxation.
2 days, 10am to 5.30pm / 15 hours
Hand-outs and recommended text
A certificate of attendance will be issued to participants who have attended and completed the