Financial Modelling by ACLM, Ghaziabad, is one of the most fundamental and widely sought after skills in the Finance Industry. ACLM makes the art of building a model to depict Financial Statements and Investment Analysis using MS Excel. This helps arrive at optimal business solutions by analysing various parameters. At the end of the course,You will be able to do the task of building a model depicting financial statements/business model, which helps in decision making. Our primary focus areas for corporate / professionals are from Indirapuram, Vaishali, Kaushambi, Vasundhara, Sahibabad, noida including delhi ncr region.
Call @ 72899 89188 or drop a mail to info@aclm.in to register.
Financial Modelling : Benefits
Minimize Business risk
Save Precious time of Employee
Easy Planning Done
Take Quick Decision
It can be share to use between different people at different location
Provide accurate result
Topics Covered
Financial Modelling Training: PART A
Setting Excel Proficiency
Name Manager, Setting Relative / Abs Addresses, Data Filter and Sort, Charts and Graphs, Table formula and Scenario building, lookups, pivot tables, Important Formulae with respect to finance and data handling, Advanced Modeling Techniques, Setting Level of Expertise on Customize Graphs and Charts, Multiple Data Consolidation and Sub- Pivoting an ordinary pivot, Introduction to macros, Macros, Recording of Macros, Understanding Visual Basic Environment (VBE)
Usage of Operators - Logical Operator, Arithmetic Operator, Assignment Operator and Unary Operators
Text Function Set - Upper, Lower, Proper, Left, Mid, Right, Concatenate, Char, Code, Find, Search, Replace, Substitute, trim, text value, Text set, T, BahtText. The array formulae including various other text functions
Date & Time Function Set - Date(), Day, month, Year, time(), Hour, minute, second, Datedif, Datevalue, Time Value, Weeknum, Weekday, Age Calculator, Usage of scientific and moderate calculator, Days360, General Date Diff, EDate, EOmonth, Workdays, Workdays.intl, Networkdays, Networkdays.intl, now, Today, Yearfrac
Lookup and References set - Address, Area, Choose, Vlookup, Hlookup, Lookup, Reverse Lookup, Index, Match, Row, Rows, Column, Columns, Get Pivot Data, Hyperlink, Indirect, offset, Transpose, RTD
Mathematical Function - General Use Function - Sum, sumif, Sumifs, Count, countif, Countifs, Average, Averageif, Averageifs, Product, Sumproduct, Sumproduct Array Formula, Round, Roundup, Rounddown, Floor, Ceiling, INT, Sqrt, Power, Subtotal, Fact, Even, Odd
Conditional Statement - If, If else, if else if (nested if), if with operator, if with the use of text functions, if with the use of numbers, if with date function, if with time functions
DATA FILTERING / DATA FORMATTING
Understanding Different Data Types, Using String / Text / Number / Long Data Types with examples, Managing Date Time Format, Handling Long Date time Format, Data Correction, Identifying bad data, Conversion of different data types, Importing and accessing different file types in excel
Refresher on Financial Markets, Financial Statements & Financial Management
Introduction of Basic Accounting Principles, International Accounting Standards, Time value of money, Long term financing, Cost of capital, Risk and return, Capital Structure, Dividend Policy, Working Capital Requirements, Equity and Industry Analysis Financial Markets & Intermediaries, Project evaluation, Different Stages of Projects, Funding during investment phase; costs during investment phase; life of project, Decision Making, Cash flow waterfall & resolve circular reference problem in interest during construction
VBA (Settings and Controlling)
Recording Macros and VBA, Understanding the basics of coding Understanding objects and control statements with VBA, Various Application of macros to Financial modeling, Developing sensitivity table, Developing scenario analysis, Developing simulation, Examples will be based on real project models,
Investment Banking
Merger and Acquisitions, Types of M&A: Merger, Acquisition,Consolidation ,Spin-off Drivers for M&A, Accounting for Mergers: Purchase Method & Pooling Method, Differentiate between financing and operating synergies, Developing sensitivity table, Developing scenario analysis, Developing simulation, Examples will be based on real project models, M&A Regulatory Environment, Developing M&A Models: Integration of Financial Statements between Target and Acquirer), Valuation - DCF, Relative and Transaction Comps, Developing Merger Model, Developing Synergies, Valuation – Assumptions for Valuation Model, Prepare Valuation Model, Prepare Presentation Sheet, Prepare Company Overview, Sector Overview - Report Writing - Overview
Financial Modelling Training: PART B
Financial Statement Analysis
Introduction to Financial Statement Analysis
Financial Reporting Mechanics,
Understanding Income Statement, Balance Sheet,
Cash Flow Statement,
Financial Analysis Techniques,
Inventories, Long Lived Assets,
Non Current Liabilities,
Financial Statement Application
Case Study
Financial Management & Corporate Finance
Time value of money
Long term financing
Cost of capital
Measure Of Leverage
Case Study
Project Finance
Project evaluation; stage of project; construction & development phase; funding during investment phase;
costs during investment phase;
life of project;
decision making,
cash flow waterfall & resolve circular reference problem in interest during construction.
Case Study
Who Should Attend
Students and Professionals related to Investment, Equity Research, Credit, Project, Mergers & Acquisition, Corporate Finance, Critical Thinking and analytical skills. CA, CFA Program candidates, FRM, MBA Finance, B TECH and Commerce Graduates
Pre-requisites
Students should have hands-on experience with Excel and a brief idea about Finance, Balance Sheets and Cash Flow Models.
What You Need To Bring
Notepad, Pen/Pencil, Laptop
Key Takeaways
Value and analyze Firms, IPOs and FPOs in Financial Modeling, Investments in nascent stages can be valued with accuracy with hands on Financial Modeling for eg. Private Equity/ Venture Capital Investing, Build your own financial models
About Trainer
Over 15+ years of experience in financial modelling as well as project planning, International Training exposure of more than 70 corporate trainings, Member of IFCA, AIMA, Contributed to several studies on Financial and Manpower Management, Certifications of PMP, Six-Sigma, MS Project Specialist.
Working as lead project - KPMG as financial consultant.