Tools and Techniques of Financial Modeling

In today’s challenging environment business decisions are increasingly based on numbers rather than ideas. Any decision on company policy has to be backed by detailed and accurate data that can stand the scrutiny of both management and stakeholders. This is especially true for financial planning where consistent and correct application of modeling techniques can help you accurately forecast ‘what if’ scenarios and design realistic forecasts which in turn lead to successful business decisions. Your ability to construct a better and more comprehensive financial model will determine the success or failure of your organization’s growth and development. This practical course will help to take your analytical skills to the next level of accuracy. Intensive and hands-on, the course is designed to equip you with step-by-step guides for effectively structuring and managing an accurate financial model.

Financial Model Features I
  • Format, Layout, Border
  • Colors, Input Validation, Combo Boxes, Scroll Bars
  • Conditional Formatting, Text, Version Control
  • Use of Range Names, Comments
Financial Model Features II
  • Sensitivity analysis and Decision Making
  • Input based Sensitivity Analysis
  • Using Data Tables
  • Scenario Manager
  • output based Sensitivity Analysis
  • Goal Seek and Solver
Financial Modeling Example Introduction
  • Loan Model
  • Lease Model
  • Investment Model
  • Project Finance Model
Financial Modeling Formulas and Functions
  • Core functions for financial Modeling
  • Arithmetic
  • Logical
  • Financial
  • Lookup and Reference
  • Database
  • Date and Array
Model Navigation, Security, Printing and More Functions
  • Custom Views and Printing
  • Hyper Links
  • Model Navigation
  • Security, Sharing and Passwords
  • Statistical functions, Text, Information Functions
Financial Modeling Example
  • Financial Projection Model
  • Projected Income Statement
  • Projected Balance Sheet
  • Projected Cash Flow
  • Ratio Analysis
  • Sensitivity Analysis
  • Maintaining Minimum Cash Balance
  • Balancing the Balance Sheet
  • Free Cash Flows
VBA and Macros for Financial Modeling
  • Introduction to VBA and Macros
  • Printing using VBA
  • Balancing the Balance Sheet Using Macro
  • Some useful codes
VBA, Auditing and Risk Analysis
  • VBA Working with User Forms
  • Adding Controls to a User Form
  • Custom Tabs in VBA
  • Auditing Spread Sheet
  • Risk Analysis

About Us

We are a training company that has expertise in providing trainings services:

   Online

   In-house

   One to One

We strongly believe in excellence.

Get in touch



Ali Asjad Trainings
86-C PCSIR Staff Cooperative Housing Society,
College Road, Lahore