FINANCIAL MODELLING & VALUATION
- Home /
- FINANCIAL MODELLING & VALUATION
Complete Financial Modelling and Investment Banking Course?
Financial Modeling is the process to make Financial Projection of the company on the basis of assumptions and schedules. Financial Model includes the Projection of Income Statement, Balance Sheet and Cash Flow Statement. Financial Modelling and Valuation is the most required skill in Equity Research, Investment Banking, Project Financing, Credit Research, Hedge funds or any other mainstream Finance profile.
Following are the various modules included in the Online Course:
- Basic and Advance Excel 2013
- VBA (Macro) Programming
- Basic Charts and Dashboards Training
- Introduction and Financial Statements Analysis
- Financial Modelling for Telecom, Auto, Real Estate, FMCG, Oil & Gas etc
- Valuation of COmpany with DCF, Trading and Transaction Combs
- Merger and Acquisition Accretion and Dilution Analysis
Advanced Excel Online Training (Module 1)
In this module, you will learn excel from Basic to Advance. You will see videos covering all the functions and tools step by step. By the end of training, You would have covered more than 100 basic and advanced functions, important shortcuts of excel with practical examples. To list a few functions like Vlookup, Hlookup, Index, Offset, Indirect, Choose, Sumifs, Database, Filter, Adv Filter are all covered with multiple examples. After doing this online course, You hardly need anything more to learn in Excel.
Excel VBA Training Videos (Module 2)
Join this course and take control of Microsoft Excel and master the process of automating routine tasks through the use of Excel VBA Macros.
During this course, you will build a foundation of working with Excel VBA Macros. This foundation will be built as you engage in simple exercises. Each of the exercises will introduce a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks.
Financial Modelling Case Study of Colgate Palmolive (Module 5)
In this module, we have prepared step by step financial Model (using excel) of a US based company “Colgate Palmolive”. So you will learn financial Modelling using excel with real example.