Financial Modeling Using Excel

Upon completion of this program, participants should be able to understanding of a spreadsheet ad its benefits, Equip with essential skills of effectively utilizing spreadsheet software in a day-to-day business environment, Be an Excel power-user with the aim of reducing non-value adding tasks and more.

Course Objectives:

• Understanding of a spreadsheet ad its benefits
• Equip with essential skills of effectively utilizing spreadsheet software in a day-to-day business environment
• Be an Excel power-user with the aim of reducing non-value adding tasks.
• Create Financial Models and Investment Models
• Create Scenario Analysis and Dash Boards
• Create Drop-down boxes and scroll-bars for flash analysis
• Understand and apply Forecasting concepts and being able to track forecasting errors
• Apply certain new functions appearing in Excel 2007 onwards
• Perform What If Analysis using:
  • Goal Seek
  • Solver
  • Input Table
  • Scenarios
• Record A Macro and assign it to an Object

Outline:

• Module 1: Financial Models
• Module 2: Building The Financial Model
• Module 3: Forecasting Methods
• Module 4: Price Setting For Products & Services
• Module 5: Cashflow
• Module 6: Form Controls
• Module 7: Extracting And Consolidating Historical Accounting Data
• Module 8: Npv & Irr
• Module 9: Investment Metrics
• Module 10: Important Excel Knowledge