Corporate Finance Analyst & Modeling Training

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.

Content:

• Module 1- Financial Modeling
  • 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
• Module 2 - Financial Statement Alalyst
  • 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
• Module 3 - Corporate Finance
  • 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
    • 4. WACC
  • 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
    • 2. LSMW
    • 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
• Module 5 - Advnace Excel
  • 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.