Course Objective:

To equip participants with relevant methods and techniques for building Financial Models and carrying out What-if analysis

Course Outline:

Deterministic Models (Profitability Analysis, Cost Analysis, Budget Analysis etc.)

Stochastic Models ( i.e. incorporation of chance and probability in your model)

Optimization Models (incorporation of existing constraints in your model)

Understanding relevant Financial functions in Excel

Using Data Tables for Sensitivity Analysis

Using Goal Seeking to determine how much money to set invest each month to reach a given future value at a given interest rate

Using Scenario Manager for Budget Reviews and Flexible Budgeting

Using Solver for Maximizing profit or Minimizing cost giving certain constraints like Capital, Demand and Supply

Optimal Capital Expenditure Scheduling