FINANCIAL MODELLING

INTRODUCTION

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

Financial Modeling is one the most fundamental and widely sought after skills in the finance industry. It is the art of building a model to depict financial statements and investment analysis using MS Excel. This helps arrive at optimal business solutions by analyzing 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.

WHAT WILL I LEARN ?

At the end of the course you will learn how to construct an integrated financial model from scratch. You will soon be building models that are robust, and provide you with dynamic projections that can be used to thoroughly analyze a company from multiple standpoints: operations, investment, financing and valuation.

TARGET AUDIENCE

This program is suitable for people in Investment banking, Project management, Equity research, Business planning & strategy, Private equity funds or commercial banking. It is also ideal for CA, CFA Program, FRM, MBA Finance, B .TECH and Commerce Graduates who want a career in any of the above profiles.

BENEFITS

Financial Models constructed in Financial Modeling help in decision making and business modeling for firms and check the viability of projects. You learn techniques to 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.

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 edge over others.

 

PRE-REQUISITES

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

 

OUTLINES

1. Financial Modeling Principles : Excel as a tool for financial modeling

   Building financial models best practices

   Modeling growth drivers, depreciation, cost drivers, asset & debt schedules

2. Valuation Principles :  Projecting cash flow statement

   Circular references and handling them

   Financial ratio analysis

   Valuation using DCF & Comps

3. Financial Modeling Principles : Excel as a tool for financial modeling

   Building financial models best practices

   Modeling growth drivers, depreciation, cost drivers, asset & debt schedules

4. Valuation Principles : Projecting cash flow statement

   Circular references and handling them

   Financial ratio analysis

   Valuation using DCF & Comps

   Scenario analysis and Building valuation dashboards

   Q & A

5. Advanced Functions, Tools & Charting : Techniques

   Advanced Tools in Excel for Auditing Financial Models

   Mastering Financial Functions

   Advanced Charting Techniques in Excel

6. Using Macros & VBA for Financial Modeling : Understanding Macros & VBA for Financial Modeling

   Implementing Monte Carlo Simulation

   Advanced Charting Techniques in Excel

   Q & A

   Commodities

   Foreign Exchange & Corporate Bonds

INSTRUCTOR

Dr. Hanifah SE.,Ak.,Msi, CA & Team / Drs. Arif Budiarto , M.Si, Akuntan & Team

______________________________________________________________________________________________________________________

Kami memberikan alternatif Fasilitas atas Investasi anda dalam Program ini, diantaranya :

1. Sertifikat, Peralatan Training, USB, Souvenir, Lunch, Coffe Break, City Tour
2. Running minimal 2 Orang (Semarang, Jogja, Solo), Running minimal 3 Orang (Bandung, Jakarta), Running 4 Orang diperuntukan untuk daerah (Bali, Lombok, Manado, Balikpapan)
3. Kami menyediakan transportasi antar Jemput dari Stasiun/Bandara ke Tempat Pelatihan(Hotel) bagi perusahaan yang Running minim 2 Orang
4. Harga dilampirkan di Brosur Penawaran

______________________________________________________________________________________________________________________

Tambahan Informasi :

1. Silahkan tanyakan ketersediaan Tanggal dan Waktu dari jadwal training terbaru apabila anda tidak menemukan waktu yang sesuai dengan jadwal anda.

2. Training dapat disesuaikan dengan kebutuhan perusahaan jika dalam bentuk In-House Training. Silahkan baca ketentuan In-House Training diwebsite kami atau hubungi kami di Nomer Mobile untuk mendapatkan Fast Respon.

3. Silahkan mengisi Form Request Training di website kami untuk mendapatkan informasi tambahan yang belum ada, atau jika anda ingin menanyakan usulan materi sesuai kebutuhan perusahaan. Hubungi kami lewat email yang tertera atau Register disini!

4. Apabila telah menerima Silabus Training, Customer dapat Request Waktu Training yang diinginkan.

5. Informasi dan Data yang jelas akan memudahkan kami untuk segera merespon permintaan anda.

Customer Dapat Request Tempat, Waktu, serta Fasilitas Training. Silahkan Hubungi kami untuk Menerima Brosur Penawaran.