Gaining sound and practical insights in financial model building, comparing financial values and evaluating financial risks
This course will focus on the tools and techniques available in Microsoft Excel which will enable you to develop, run and review financial models across multiple scenarios. More than that, the course will bring you right up to date in terms of what Excel is capable of now. You will gain a sound and practical insight in financial modeling building, comparison of financial values and evaluation of financial risks.
Session 1: Working with Financial Statements Income Statement Balance Sheet Statement of Cash Flow
Session 2: Budget Models
Session 3: Variance analysis and breakeven analysis
Session 4: Business Intelligence 1
Session 1: Capital Budgeting, Risk Assessment and Simulations Calculating the Cost of Capital
Session 2: Risk Modeling
Session 3: Dynamic Array Functions and Business Simulations
Session 4: Business Intelligence 2