Corporate Finance Analyst & Modeling Training

Overview

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.

Corporate Finance– Understanding of capital structure and how corporate finance works is quite essential for any professional pursuing his/her career in Finance. It gives a bird’s eye view of an organisation and provides an understanding of how various financing activities impact the valuation of a firm. CFO of any company endeavours to optimize the capital structure by selecting the right financing tools to address the operating and investing needs of a company.

During Training we Provide Topic on :

Module -1. FINANCIAL MODELING

Understanding an integrated financial Model

Building Integrated Model – Financial Statements & Projections for an Equity

• Creating a template for integrated model
• Making Assumptions for forecast
• Developing various schedules

1. Depreciation – Capital Expenditure Phasing, SLM and % methods
2. Working capital
3. Debt and Interest
   • Integrating all the financial statements
   • Summarizing financial statements

Building Integrated Model – Valuation

• Using DCF and comparables
• 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.

• Understanding the purpose
• Understanding of key headers and sub-headers
• Format of the financial statements
• General Accounting Principles and best practices

Navigating the Annual Report

Common size Analysis – Horizontal and Vertical

Financial Ratio Analysis

• Activity Ratios
• Liquidity Ratios
• Solvency Ratios
• Profitability Ratios
• Rate of return
• DuPont Analysis
• Other important ratios

Module 3. CORPORATE FINANCE

Time value of money

• NPV and IRR
• Future Value
• Excel formulas like NPV, XNPV, IRR, XIRR, PV, FV, etc.

Understanding of Debt

• Understanding schedules for debt repayment and interest repayment
• Developing the schedules on excel

Capital Structure and Cost of Capital

• Debt and Equity
• Cost of Debt
• Cost of Equity
• WACC

Understanding tax shield

Measure of Leverage

• Impact of leverage on cost of capital

CAPM model and Beta calculation

• Understanding of Beta
• Levered and Unlevered Beta
• Calculation of levered Beta
• Calculation of cost of equity

Free Cash Flow

• Free Cash flow to Firm
• Free Cash flow to Equity

Valuation: Valuation for the companies

• DCF Valuation
• Relative Valuation
• Transaction Valuation

Module 4.  SAP FICO

Module 4,1A. Overview

Introduction

SAP R/3 Architecture

ASAP Methodology

Module 4,1B. General Ledger Accounting

Organization Structure Financial Accounting Global
Setting Fiscal Year Variant
GL Master Data

Parking hold sample recurring accrual deferral documents

Reversal of documents
New G/L Accounting
Parallel Currencies
Foreign Currencies Exchange
Interest Calculation
Business Process

Credit management

Module 4,1C. Accounts Payable

Vendor Master Data
Spl.G/I Transaction Payment Term & Cash Discount

Outgoing Payment
Advance payments

Purchase returns

Vendor accounts for Ranges Number

Vendor group (MM and FI vendors)

Vendors for tolerance group

Extended withholding tax

Bank House

Module 4,1D. Automation Payment Programme
Account Receivable

Customer group (SD and FI customers)

Vendor Master Record
Incoming Payment
Input & output tax

FICOlls of exchange

Lockboxes
Dunning Process
Correspondence

Module 4,1E. Asset Accounting

Chart of deprecation

Account determination

Integration with FI

Deprecation keys

Asset master

Sub asset master

Asset report

Deprecation run

Sale of asset

Transfer of asset

Scrapping of asset

Capital work in progress

Module 4,2A. General Controlling

Controlling area

No. ranges for controlling documents

Versions

Cost element accounting

Cost center accounting

Repost line items

Repost of cost

Actual overhead assessment

Planning cost center and cost element

Budgeting

Module 4,2B. Internal Orders

ORDER TYPE INTERNAL ORDER

PLANNING INTERNAL ORDER WISE

VIEW INTERNAL ORDER WISE REPORT

SETTLEMENT PROFILE

Budget profile

Module 4,2C. Profit Centre Accounting (PCA)

Controlling settings

Dummy profit center

Actual data

Profit center

Assignment of revenue elements

Choose accounts

Creation of cost object

Planning profit and loss items

Planning balance sheet items

Transfer of pricing

Module 4,2D. ProfitaFICOlity Analysis (CO-PA):

Operating concern

ProfitaFICOlity segments

Assignment of controlling area to operating concern

Activate profitaFICOlity analysis

Mapping of conditions to COPA values

Drill down report

Report painter

Module 4,2E. Product Costing:

Creation of secondary cost element

Activity type

Price calculation

Work center

Routing

Cost sheet

Cost estimate with quantity structure

Cost estimate without quantity structure

Work in progress

Module 4,2F. Integration:

Procurement cycle

Integration with MM

Sales process

Integration with SD

Integration with asset accounting

Integration with controlling

Integration with PP

Module 4,2G. Reports:

Financial statement version

GL reports accounts payable reports

Accounts receivable reports

Assets

Cash book reports

Copa reports

Module 4,2H.  Real Time Scenarios:

Resolving tickets

LSMW

Implementation overview

Support and maintenance process

 Module 4,2I. General Views

MTO (Make to order)

MTS (Make to stock)

Repetitive manufacturing

Module 4,2J. Retailing (Industry add-on):

Consumer based (apparel and foot where)

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

ADD ON BENEFITS
CV Revision in a professional approach.
Provided ISO Certified Certificate after complete the course.
Provided Practical oriented course material for all the topics

Fees & Batch Detail : 

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

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

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

MEGARA INFOTECH PVT. LTD.

M-46, Old DLF Colony, Sector-14,Gurgaon (HR)

Mob: +91-9999 858 239, +91-9999 792 773, Tel: 0124-4058233.

Follow us at : www.facebook.com/Megarainfotech