Financial Modeling – Financial Modeling refers to the process of building a structure that integrates the Balance Sheet, Income Statement, Cash Flow Statement and supporting schedules to enable decision making in areas like, Business Planning and Forecasting, Equity Valuation, Credit Analysis/Appraisal, Merger/acquisition analysis, Project Appraisal etc.

Trainees learn how to build full, dynamic Financial Statement Projection models in Excel from scratch, using real case studies and sensitivity analysis.

Participants develop a model completely from scratch, inputting historical data and assumptions to project financial statements using step-by-step instruction on selecting and developing appropriate projection drivers. At completion, participants will have developed a complete and integrate three-statement model using various supporting schedules.


Understanding an integrated financial Model

Building Integrated Model – Financial Statements & Projections for an Equity

1. Creating a template for integrated model
2. Making Assumptions for forecast
3. Developing various schedules
4. Depreciation – Capital Expenditure Phasing, SLM and % methods
5. Working capital
6. Debt and Interest
a) Integrating all the financial statements
b) Summarizing financial statements

Building Integrated Model – Valuation

1. Using DCF and comparables
2. Summarizing financial statements
Advanced Modelling concepts and techniques
Common Modeling errors- circular reference errors to avoid


Financial Statements – P/L, B/S, C/F statements reflecting operating, Investing activities for business.

1. Understanding the purpose
2. Understanding of key headers and sub-headers
3. Format of the financial statements
4. General Accounting Principles and best practices
5. Navigating the Annual Report

Common size Analysis – Horizontal and Vertical

Financial Ratio Analysis
1. Activity Ratios
2. Liquidity Ratios
3. Solvency Ratios
4. Profitability Ratios
5. Rate of return
6. DuPont Analysis
7. Other important ratios


Time value of money
1. NPV and IRR
2. Future Value
3. Excel formulas like NPV, XNPV, IRR, XIRR, PV, FV, etc.

Understanding of Debt
1. Understanding schedules for debt repayment and interest repayment
2. Developing the schedules on excel

Capital Structure and Cost of Capital 1. Debt and Equity
2. Cost of Debt
3. Cost of Equity

Understanding tax shield

Measure of Leverage
1. Impact of leverage on cost of capital

CAPM model and Beta calculation
1. Understanding of Beta
2. Levered and Unlevered Beta
3. Calculation of levered Beta
4. Calculation of cost of equity

Free Cash Flow
1. Free Cash flow to Firm
2. Free Cash flow to Equity

Valuation: Valuation for the companies
1. DCF Valuation
2. Relative Valuation
3. Transaction Valuation

Module 4 - SAP FICO
Module 4,1A. Overview

1. Introduction
2. SAP R/3 Architecture
3. ASAP Methodology

Module 4,1B. General Ledger Accounting

1. Organization Structure Financial Accounting Global
2. Setting Fiscal Year Variant
3. GL Master Data
4. Parking hold sample recurring accrual deferral documents
5. Reversal of documents
6. New G/L Accounting
7. Parallel Currencies
8. Foreign Currencies Exchange
9. Interest Calculation
10. Business Process
11. Credit management

Module 4,1C. Accounts Payable

1. Vendor Master Data
2. Spl.G/I Transaction Payment Term & Cash Discount
3. Outgoing Payment
4. Advance payments
5. Purchase returns
6. Vendor accounts for Ranges Number
7. Vendor group (MM and FI vendors)
8. Vendors for tolerance group
9. Extended withholding tax
10. Bank House

Module 4,1D. Automation Payment Programme Account Receivable

1. Customer group (SD and FI customers)
2. Vendor Master Record
3. Incoming Payment
4. Input & output tax
5. FICOlls of exchange
6. Lockboxes
7. Dunning Process
8. Correspondence

Module 4,1E. Asset Accounting

1. Chart of deprecation
2. Account determination
3. Integration with FI
4. Deprecation keys
5. Asset master
6. Sub asset master
7. Asset report
8. Deprecation run
9. Sale of asset
10. Transfer of asset
11. Scrapping of asset
12. Capital work in progress

Module 4,2A. General Controlling

1. Controlling area
2. No. ranges for controlling documents
3. Versions
4. Cost element accounting
5. Cost center accounting
6. Repost line items
7. Repost of cost
8. Actual overhead assessment
9. Planning cost center and cost element
10. Budgeting

Module 4,2B. Internal Orders

1. Order Type Internal Order
2. Planning Internal Order Wise
3. View Internal Order Wise Report
4. Settlement Profile
5. Budget Profile

Module 4.2C. Profit Centre Accounting (PCA)

1. Controlling settings
2. Dummy profit center
3. Actual data
4. Profit center
5. Assignment of revenue elements
6. Choose accounts
7. Creation of cost object
8. Planning profit and loss items
9. Planning balance sheet items
10. Transfer of pricing

Module 4.2D - ProfitaFICOlity Analysis (CO-PA)

1. Operating concern
2. ProfitaFICOlity segments
3. Assignment of controlling area to operating concern
4. Activate profitaFICOlity analysis
5. Mapping of conditions to COPA values
6. Drill down report
7. Report painter

Module 4.2E - Product Costing

1. Creation of secondary cost element
2. Activity type
3. Price calculation
4. Work center
5. Routing
6. Cost sheet
7. Cost estimate with quantity structure
8. Cost estimate without quantity structure
9. Work in progress

Module 4.2F - Integration

1. Procurement cycle
2. Integration with MM
3. Sales process
4. Integration with SD
5. Integration with asset accounting
6. Integration with controlling
7. Integration with PP

Module 4.2G - Reports

1. Financial statement version
2. GL reports accounts payable reports
3. Accounts receivable reports
4. Assets
5. Cash book reports
6. Copa reports

Module 4.2H - Real Time Scenarios

1. Resolving tickets
3. Implementation overview
4. Support and maintenance process

Module 4.2I - General Views

1. MTO (Make to order)
2. MTS (Make to stock)
3. Repetitive manufacturing

Module 4.2J - Retailing (Industry add-on)

1. Consumer based (apparel and foot where)
2. Retailing stores


Provide Basic Understanding of Excel, make user familiar to create formula and give platform to make good analysis and introduce Powerful tools of advance excel so that user can make advance analysis with the help of those tools Topics Covered Introduction, Basic Undersatanding , Sum,Count, Counta, Countblank, Average, Max, Large Min, Abs, Sumif, Countif, Lower, Upper, Proper, Trim, Len, Left, Right, Mid, Concatenate, Subtotal,And, Or, Day, Year, EOmonth, Edate, Networkdays, Today, Weekday, Weeknumber, Workday, Find,Search Vlookup, Hlookup,Day and Time Calculation, Numeric Calculation, If Logical Condition, Dynamic Pivot, Dynamic Chart, Conditional Formating, Dated if, What Ifanalysis, Match index, Offset function, User form function in excel, Data validation, Advance filter, Sorting, Group & ungroup, Data split, Text function (data sepration), Substitue

Regular Batch: 35-40 Sessions* (2hrs per session)

Weekend Batch: 20-25 Sessions* (3hrs per session)

Fast Track: 15-20 Sessions* (4hrs per session)

Eligibility : 12th+ Having basic knowledge of Computer

+91 7065737300