Certificate in Financial Modeling

Introduction to Modeling: Using Excel as a spreadsheet, Effective construction of a model The Fundametals of Model building: Setting up date flexibility throughout the model using EDATE, EOMONTH and other date functions, Formatting data professionally, Maximum use of Excel applications Auditing: Using existing models, How to become comfortable with ‘new’ models Basics of Financial Modeling: Projection of P&L, balance sheet and cash flow, Professional use of excel -protection, range names, data validation Professional Models: What is a good model? Modeling - from basic to professional Build your own model: Building models from scratch, Building a model with assumptions and key drivers LBO Modeling: LBO financing concept reviewed, Different leverage options