Advanced Excel and Financial Modelling 2016

Topics

• Refresher of Excel fundamentals
• Basic Excel tools
• Basic structure of a model
• Customising Excel
• Model design and consideration of inputs
• Understanding/refresher of financial statements
• Making sure the model has integrity
• Forecasting EBITDA
• Forecasting working capital
• Including checks and balance
• Forecasting financial flows
• Forecasting capex and depreciation
• Forecasting tax
• Trouble shooting circulatory problems
• Sensitivity analysis
• The camera function
• Creating impressive output
• Charting the results

Who should Attend

Financiers, finance managers, accountants and bankers looking to improve their skills in Excel.