Financial Modelling, MIS using MS-EXCEL Training

Course Duration : 3 Months, Course Fee : 35000

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)

Set of Important Formulae and related assignments

• Logical Function Sets - And, Or, Not, Nand, Nor, Xor, True, False, Iferror, Iserror, Iserr, Isna, Isblank, Istrue, IsFalse, IsNumber, IsText, IsEven, Isodd, IsLogical
• 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

• 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

• Time value of money
• Long term financing
• Cost of capital
• Measure Of Leverage
• Case Study

• 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.