Course Objective:

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

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)

§  Using Form Controls for interactive inputs / variables

1.0 Single Cash Flow    

1.1 Present Value

            1.2 Future Value

2.0 Annuity

            2.1 Present Value

            2.2 Future Value

3.0 NPV Using Constant Discounting

            3.1 Nominal Rate

            3.2 Real Rate

4.0 NPV Using General Discounting

            4.1 Nominal Rate

            4.2 Real Rate

5.0 Loan Amortization

            5.1 PMT function

            5.2 Sensitivity Analysis

6.0 Goal Seek

            6.1 Determining amount to invest to reach a future amount

            6.1 Determining Real Return given inflation rate

            6.3 Determining Basis Salary given Net Salary

7.0 Data Tables

            7.1 Single-Input Data Table

            7.2 Double-Input Data Table

8.0 Scenario Manager (example, for Flexible Budgeting)

9.0 Solver

9.1 Determination of Product / Service Mix for optimal results (Profit Maximization, Cost                                                    Minimization or Target Profit) given certain constraints (Demand, Supply, Capital etc.)

9.2 Optimizing Make or Buy Decisions

10.0 Multidimensional Data Analysis – Pivot-Tables and Pivot-Charts