Financial Modelling, Project Financing & Budgeting forecasting with Business Intelligence

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.

DAY ONE

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

DAY TWO

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