logo-mini

Financial Modeling

Financial Modeling in Excel

Course Duration & Payment Details

Day: Sundays only
Timing: 02:00 to 05:00pm
Duration: 18 hours
Starting from: Sunday, 09 January 2022
Last date of registration: Sunday, 02 January 2022

Actual Fee: 12,000/-  | Early bird discount: 9,000/-
How to Pay: Online Payment
Bank: Habib Bank Limited
Title: Irfan
Account No: 0011557900292501 | PK02HABB0011557900292501

Training Highlights

  • Identifying and applying forecasting techniques and functions offered by Excel
  • Working with Advanced Functions
    • VLookup, Multi Vlookup, Hlookup, Xlookup, Index, Match, Offset, Indirect Functions
    • SumIF, SumIFS, CountIF, CountIFS, Subtotal
    • Logical Function e.g.IF & Nested IF Function
  • Financial Functions
    • PMT, IPMT, PPMT and Forecast
    • IRR, RATE, PV, FV, NPV, XNPV
  • Working with Conditional Formatting
  • Data Validation
  • Custom Formatting
  • Sparklines
  • Sales Summary Report
  • Dashboard
    • Dashboard Prerequisites
    • Get Data from different resources
    • Creating Pivot Table
    • Calculated Fields
    • Working with Slicers
    • Create a relationship with data files and dimensions
    • Visualization Techniques
    • Building a Financial Dashboard
  • Working with Macros
    • Data Security
    • Linking Data
  • Solver Based Optimal Business Modeling
  • Working with Solver
  • Optimizing Workbook Models with “What-If”
    • Goal Seek
    • Scenario Manager
    • Data Table
  • Dynamic Financial Reports using Business Intelligence techniques
    • Working with Data Modeling (Relationship)
    • Profit & Loss Statements
    • Cash flow Reports
    • Loan Amortization
    • Bank Reconciliation
  • Three Statement Model & Ratio Analysis
    • Structure and layout of three statement model
    • Input historical data into excel
    • Create Income statement & Balance sheet assumptions
    • Forecast the income statement, balance sheet &Cash flows
    • Ratio Analysis
    • Graphical representation of ratios
  • Financial Model for New Business
    • Basic Knowledge
    • Financial Ratios
    • Investment & Finance Parameters
    • Shareholdings and Dividends
    • Income Statement & Balance Sheet Analysis
    • Cash Flows Analysis