Financial Modeling
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 (26 street, Badar Commercial, DHA Karachi)
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