Financial Modelling using Excel Training

Course Outline

Introduction to Financial Modelling 

• Financial modelling fundamentals & Steps in model building
• Concepts of financial modelling

Introduction to Excel  

• Using the Options dialog box
• Customizing toolbars and menus 
• Using relative, absolute, and mixed cell references in formulas

Excel Tools and Techniques 

• Cell referencing
• Naming ranges
• Linking in excel
• Using shortcuts

Excel Functions and Formulas in Finance 

• The difference between a formula and a function
• Understanding to most important functions and formulas
• Finding the function and you need
• Advanced functions and formulas

Applying Scenarios to Financial Model 

• The Differences between types of analysis
• Building Drop-Down scenarios
• Applying sensitivity analysis with data tables
• Using scenario manager to model loan calculations.
• Charting and Presenting Model Output 
• Deciding which data to display
• Conveying your message by charting scenarios
• Deciding which type of chart to use

Building Financial Statements Model

• Entering assumptions
• Calculating revenue
• Calculating expenses
• Building the Income Statement
• Building the Cash Flow Statement
• Building the Balance Sheet
• Building scenarios

Integrating Financial Statements Model 

• Making a reusable budget model template
• Creating dynamic titles
• Calculating cash required for budgeted asset purchases.
• Calculating budgeted depreciation
• Calculating the written-down value of assets for the balance sheet