Financial Modelling Excel Masterclass

DESCRIPTION
This course is directed at experienced Excel users who are wanting to take their spreadsheets to a new level. You will learn how to create robust and professional models utilizing Excel functionality that most Excel users do not know how to use.

Day 3 uses all the techniques from Day 1 & 2 plus a few new techniques to pull together a financial model.

Day 3 will cover:

• Importing data to work with
• Reformat data to Excel friendly format
• Enhancing Your Spreadsheet with a little VBA
• Use Historical Financial Statements to calculate Free Cash Flow
  
  • Ratio Analysis
  • Transposing data
  • Check the Annual Compounded Rate
  • Trend Analysis
• Project Future Cash Flow
• Valuation
  
  • Discount Cash Flow to Present Value
  • Terminal value
  • Enterprise Value
• Sensitivity Analysis
  
  • Using What-If Analysis
  • Using Data Tables
• Goal Seek
  
  • Using Goal Seek
  • Applying Goal Seek
• Data Tables
  
  • Using Data Tables
  • Creating a one-variable Data Table
  • Creating a two-variable Data Table
  • Speeding up calculations with Data Tables
• Scenario Manager
  
  • Using Scenario Manager
  • Adding a Scenario
  • Showing a Scenario
  • Deleting a Scenario
  • Editing an existing Scenario
  • Summarising Scenarios
• Solver
  
  • Using Solver
  • Installing Solver
  • Applying Solver
  • changing a Constraint
  • Deleting a Constraint
• Using the Formula Auditing Toolbar
  
  • Tracing Precedents
  • removing Precedent Arrows
  • Tracing Dependents
  • Removing Dependent Arrows
  • Adding a new comment
  • Evaluating Formulas one step at a time
• Using the Watch Window
  
  • Adding a Watch to a cell
  • Adding a Watch to all the cells with Formulas
  • Displaying a cell in the Watch Window
  • Deleting a watch
  • Hiding the Watch Window
• Protecting your work
• Creating Reports
• Print Areas