Financial Modelling

"COURSE OUTLINE 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"