Financial modeling in excel is the process of creating a representation of a financial situation or problem using a spreadsheet software, such as Microsoft Excel. This involves inputting financial data, such as revenues, expenses, assets, and liabilities, and using formulas and functions to calculate financial metrics, such as profitability, cash flow, and return on investment. Financial modeling is often used to forecast future financial performance, assess the feasibility of a business idea, or evaluate the potential impact of a financial decision. It is a valuable tool for financial analysts, investors, and business owners to make informed decisions and plan for the future.

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