Who Should Attend
  • Personnel in Financial Institutions
  • Students from Finance and Business studies Background
  • Anyone who is interested work in Financial institutions
Course Overview

Financial modeling has become an imperative tool for financial decision making in today’s corporate world. Especially during uncertain and turbulent times, there is continuous pressure for properly defined financial models that identify and compare the impact of specific business initiatives and alternative scenarios on a company’s financial position. It is a vital task that provides the foundation for structural business change. The financial modeling technique requires the building of a financial representation of the business on a spreadsheet, and the identification and manipulation of key performance drivers to explore the impact of different operational and financial options. Financial modeling supports the reliability of decision making in many financial areas, such as valuation, forecasting, budgeting and investment appraisals.

The capability to write simple spreadsheets is just not enough. You have to be able to incorporate all the "what if" scenarios and stress any proposal to its limits. Financial Modeling with Excel is such a workshop where knowledge of Finance meets with Technology for better understanding of the Financial World.

The course on Business and Financial Modeling addresses these requirements through an emphasis on a systematic approach to building rigorous and structured financial models with practical applications to model building using Excel.

Objectives of Course
  • Build a financial model from scratch, or modify and improve an inherited model
  • Select the most appropriate formula to achieve the desired outcome
  • Mitigate errors by building in error checks
  • Validate data entry by setting data entry parameters
  • Develop drop-down boxes which enable a model to produce a series of results depending on scenario variable selected
  • Fixing modeling problems, such as circular references
  • Optimizing financial decision based on constraints
We Know What You Need To Know
Course curriculum

Naming of cells and range of cells:

  • Creating name
  • Editing name
  • Deleting name
  • Creating dynamic name ranges using function
  • How naming can help building financial model
  • How naming can save lot of your time

Database Functions:
Vlookup and Hlook up Function:

  • Static Vlookup and Hlookup
  • Dynamic Vlookup and Hlookup
  • Combining vlookup with other functions to customize works and saving a lot of time.

Index Function and Match Function:

  • Index and Match functions can be used together, to create a powerful and flexible formula.
  • Dynamic searching using Vlookup, Match and Index function

Text functions

  • Use Left, Right, Trim, Concatenate etc functions
  • Search function

Dates and Date Functions

  • Date, DatedIf, Datevalue, Days360, Edate, Eomonth, Month, networkdays, Today, Weekday etc functions

Keyboard Shortcuts

  • All activities can be done by using excel shortcuts

Financial Decision making

  • Understanding time value of money
  • Calculating loan  payment
  • Building an amortizing schedule
  • Calculating term of the loan
  • Calculating how much you can borrow
  • Working with interest rate
  • Calculating the future value
  • Calculating Present Value
  • Discounting cash flows
  • Calculating payback period
  • Buying versus leasing decision
  • Use of Cumprinc and Cumipmt functions
  • DCF Valuation for stock pricing

Capital Budgeting decision

  • Determining optimal projects based on certain constraints
  • Evaluating investments by NPV and IRR criteria
  • Computing NPV and IRR when cash flows are received at the beginning of the period
  • Computing NPV and IRR when cash flows are received at irregular intervals.
  • What to do when a project has more than one IRR?

Logical Functions

  • If function and Nested if function
  • If error function

Auditing Tools

  • Trade precedents
  • Trade dependents
  • Checking errors

Sorting, Filtering and Tables

  • Sorting
  • Filtering and advanced filtering
  • Using tables to create dynamic charts

Data Validation Techniques

  • Validating data
  • Minimizing errors
  • Advanced data validation using list

Risk Management and What If analysis

  • Goal Seek
  • Scenario Analysis
  • Sensitivity analysis
  • Monte Carlo Simulation
  • Linear programming using solver function
  • Scenario analysis using Spin buttons, Scroll bars, option buttons, combo boxes etc

Pivot Tables

  • Build a pivot table from database, analyze and display data
  • Consolidation by category and consolidating using pivot tables
  • Pivot charts

Statistical analysis and Business forecasting

  • Summarizing data by using histograms
  • Summarizing data using descriptive statistics
  • Linear Regression analysis
  • Multiple regression analysis
  • Variance, Covariance, Standard deviation
  • Correlation function
  • Analysis of variance: ANOVA
  • Forecast function
  • Random variables and randomization


  • Solving the problem of circular references
  • Countif, countifs, count, counta, countblank functions
  • Sumif, averageif, sumifs, averageifs functions
  • Transpose function
  • Upper, Lower, Proper function
  • Offset function
  • Using offset function for building scrolling table
  • Indirect function
  • Conditional formatting
  • Choose Function
  • Indirect Function