Advanced Financial Modeling in Excel

2 DAYS CLASSROOM TRAINING

Swissotel The Bosphorus İstanbul

September 05-06, 2019

Unlike most of the other businesses, all finance professionals have to continuously work with large amount of numbers. Almost everyone uses MS Excel to create financial models to analyse and project financial statements. A mastery over financial modeling will give all the professionals an edge over others as they can do their work faster and with more accuracy.

ABOUT FINANCIAL MODELING

Number crunching is one of the most important aspects of any job in the world of finance. Unlike other businesses, professionals in the finance industry have to work with large amounts of numbers. Thus, there is a need for people who are  good MS Excel to create financial projections, analyze competition & markets and make financial models. A mastery over Excel is actually a way to excel in the finance world, as it ensures accuracy, speed and can give you that edge over your peers. 

The IFE Istanbul Institute of Finance Financial Modeling course will teach you from  basics of MS Excel all the way to creating successful Financial Models. By the end of this course, you will be able to independently build models that are robust and provide dynamic projections that can be used to thoroughly analyze a company from multiple standpoints: operations, investment, financing and valuation.

Learn Financial Modeling with us in the classroom environment with hands on experience. Our two-day curse  is all you need to start building your own financial models.

EXCEL IN THE FINANCIAL WORLD

The course will enable you to 

· Value and analyze Firms, IPOs and FPOs in Financial Modeling.

· Value investments in nascent stages  with accuracy and with hands on Financial Modeling for eg. Private Equity/ Venture Capital Investing

· Build your own financial models

THE IDEAL CANDIDATE FOR FINANCIAL MODELING

This program is suitable for students and professionals related to Investment, Equity Research, Credit, Project Manegement, Mergers & Acquisition, Corporate Finance, Critical Thinking. It is also ideal for CA, CFA Program candidates, FRM, MBA Finance, B TECH and Commerce Graduates who want a career in any of the above profiles. 
Financial Modeling is also a suitable choice for those in non-finance related careers such as in the preparation of Business Plan, working on Excel, decision making and mapping theory to practical.

CAREER BENEFITS

Commercial Banks use Financial Modeling for disbursing loans for the projects; Project Management uses it for performance tracking of on-going projects. 
Financial Modeling concepts can be applied to any industry. Individuals who hold an MBA and also possess knowledge of Financial Modeling have an advantageous edge over others.

PRE-REQUISITES

Student should have hands on experience on Excel and brief idea about Finance, Balance Sheets and Cash Flow Models.

COURSE HIGHLIGHTS

Exclusive 2 Day MasterClass

Day 1: Financial Modeling Principles

* Introduction and Context 
* Efficiently using excel – preparation for modeling 
* Excel – Summarization Using Pivot Tables 
* Creating a template for integrated model
* Understanding an integrated financial Model 
* Decision Making based on Financial Analysis 
* Business reflected in the Statements
* Creating a template for integrated model 
* Summarizing financial statements 
* Building Integrated Model – Financial Statements & Projections 
* Integrated Model –  Inputting the Historical numbers 
* Integrated Model –  Calculating drivers 
* Integrated Model –  Forecasting P&L and Balance Sheet 
* Integrated Model – Creating Asset and Depreciation Schedule 
* Integrated Model – Creating Debt Repayment Schedule 
* Integrated Model – Creating Cash Flow Schedule

Day 2: Valuation Principles

* Understanding recursion and iterative calculation 
* Using Iteration to update Debt schedule 
* Integrated Model – Updating debt schedule 
* Integrated Model – Ratio analysis 
* Integrated Model – Ratio analysis 
* Integrated Model – Valuation by DCF 
* Integrated Model – Valuation by Comps 
* Integrated Model – Scenario Analysis 
* Building Integrated Model – Valuation






 

 

Certificate of Excellence
A reference to get ahead in your career. At the end of the course, you will receive a Certificate of Participation.


Venue Details

Swissotel The Bosphorus, Visnezade Mah. Acisu Sok. NO. 19 Macka Besiktas Istanbul Turkey

PROGRAM PRICE

Final Price : 4.900 TL+VAT(18%)

Group booking Discounts

2-3 delegates - 10% discount

4-6 delegates - 15% discount

Lunch and coffee breaks are included in the prices.

Certificate of Participation will be given to the participants by IFE İstanbul Institute of Finance

Contact

T:+90 212 322 0444  M :+90 532 238 1730

This e-mail address is being protected from spambots. You need JavaScript enabled to view it

 

 

Site Mahallesi, Kerim Sokak No: 27/14 Ümraniye 34760 - İSTANBUL- TÜRKİYE

+90 212 322 0444 - +90 850 302 0433

e mail: customer [@] istanbulinstituteoffinance.com