Financial Modeling is a key skill with application in several areas within banking and finance industry as well as in large corporations. Excel is today one of the most widely used spreadsheet in any organization. However Microsoft Excel Research has shown that the average user is familiar with less than 1% of Excel capabilities. Financial Modeling with Excel is such a workshop where knowledge of Finance meets with Technology for better understanding of Financial World.

MAJOR STEPS OF FINANCIAL MODELING

In Financial Modeling you learn to gather historical information on companies and analyze company / industry performance on various financial parameters

This Analysis is then used to build a companies financial model, which in turn is key to projecting a future financial performance

Based on this model companies / investors can arrive at a suitable valuation for  the companies.

Individuals with these skills can work in the areas of investment banking / equity research/trading, financial KPOs that are assisting investment bankers / equity research firms, financial advisory firms, project finance and in the area of performance tracking and MIS for companies themselves.

PROGRAMME OBJECTIVES

The objective is to develop spreadsheet and modelling skills for creating computer-based models for analyzing a variety of decision problems facing today’s financial managers and professionals. The program aims to impart the necessary skills required to perform the role of a Financial Research Analyst. The program equips students with the practical skill sets required to perform financial analysis, modeling and valuation through Excel.

PROGRAMME HIGHLIGHTS

• Accounting Fundamentals
• Fundamentals of Statistics and Quantitative Methods
• Economic Analysis
• Financial Management
• Financial Markets
• Introduction to Financial Modeling
• Valuation and Sector Overview
• Working with Charts & Table
• Using Financial and Logical Functions
• Analysis of Data
• Excel Proficiency
• Excel – Advanced Techniques and introduction to VBA
• Create MS Excel based financial models.
• Use the advanced tools of Excel.
• Write VBA programs for implementing advanced functionalities in Excel.
• Carry out financial analysis, forecasting, etc.
• Price Derivatives.
• Carry out Monte Carlo Simulations in Excel
• Portfolio optimization
• Report Writing

BENEFIT  OF PROGRAMME

• Build a financial model from scratch, or modify and improve an inherited model
• Reduce errors by building in error checks
• Prevent incorrect use of your model by protecting worksheets
• Validate data entry by setting data entry parameters
• Create a navigation page to help users find their way around your model
• Create drop-down boxes which enable a model to produce a series of results depending on scenario variable selected
• Mitigate liability by providing assumptions
• Present findings in a concise and meaningful way

Our Aim and Your Gain

Financial Modeling remains still less explored field in Indian Markets. We aim to impart practical knowledge in Financial Modeling. Financial Modeling is the need of the hour, and people possessing such skills are very much in demand. Our aim is to 'teach you to catch a fish everyday', rather than just 'give you a fish to eat'...

We hope that you not only convinced but also thinking not to take chances with your hard earned money. So, what are you waiting for! If the ‘Programme Highlights’ are appealing enough to make you think that this is WORTH JOINING then go ahead and visit us at www.iLearningMantra.com for detailed information on programme and other stock market related and trading courses and workshops.