Financial Modeling in Excel

Training Financial Modeling in Excel

The objective of this program is to provide knowledge and practical experience about the creation of comprehensive and flexible financial models that can be used in financial planning and fund raising purposes.

Overview

The participants will gain insights into the step-by-step process of creating financial models using Microsoft Excel, putting checks and audits and finally analyzing the same.

This course will equip all participants with various tools to aid in complex business decision making by incorporating multiple factors operating in the dynamic business environment. At the end of the course, each participant will be able to create a financial model independently and carry out analysis to take best decision for their company.

Who should attend

All individuals who want to improve their financial modeling skills should attend this course

  • Analysts/ Finance professionals like CPA, CFA, MBA, other graduates etc
  • Middle to senior managers from different industries
  • All professionals who want to deal or currently deal with financial modeling in their company
  • Consultants, advisors and other professionals who wish to improve their modeling skills

Methodology & Trainer

Non-theoretical methodology which includes interactive discussions, case studies, and assignments to understand the concepts and their applicability. As a policy, we limit the class size to 15 participants so that we can provide attention to each participant and ensure their individual objective is achieved.

We request you to please bring your laptop with Microsoft Excel 2007 installed to the class.

All our trainers are carefully chosen by us and possess a rich and vast experience in the financial sector. This course will be conducted by an experienced training consultant having more than 15 years of industry experience with some of the world’s leading financial institutions, specializing in corporate finance, investment banking and private equity.

Course Content

Module – 1

Setting up a financial model and building projections

  • Overview of best industry practices for Financial Modeling
  • Importance of historic information
  • Analysis of company and industry information
  • Steps for creating financial models
  • Proper presentation of various sheets and setting up the model input dashboard

Module – 2

Preparation of Income statement, cash flow statements and balance sheet

  • Analysis of industry assumptions and their rationale for revenues & costs, assets and liabilities’ assumptions – operating cost, capex, leverage, modelling of historical ratios and trends
  • Short listing assumptions and applying adjustments
  • Applying various forecasting tools, etc

Module – 3

Importance of key schedules and their application

  • Working capital schedule
  • Fixed assets and depreciation
  • Schedule of amortization of intangible assets
  • Preparation of debt and interest
  • Taxation
  • Equity fund raising
  • Equity gap and funding

Module – 4

How to create working capital schedule

  • Components of cash and non-cash working capital
  • Working capital ratios and their interpretation
  • Forecasting working capital requirements

Module – 5

How to create Capex and funding schedules including multiple debts

  • Equity and debt fund raising and repayment structure
  • Debt waterfall mechanism
  • Checking debt repayment ratios, leverage and covenants

Module – 6

Integration of income statement, balance sheet and cash flow statement

  • Industry practices on handling exceptions
  • Integration of Cash Flows, Income Statement and Balance Sheet
  • How to handle Circular References in financial modeling

Module – 7

Establish scenario and sensitivity analysis

  • Use of data for sensitivity analysis
  • Importance of scenario manager
  • Identifying suitable scenarios and sensitivities and their impact on financial analysis
  • Managing key pitfalls in the analysis

Module – 8

How to analyse the data

  • Data sorting and Data filtering
  • Creating, customizing Pivots Tables, advanced pivot tables and analysis
  • V-LOOK UP and H-LOOK UP, Macros, Goal Seek and other analysis
  • Solver function and its uses

Module – 9

How to apply different financial analysis techniques on the model

  • Importance of PV, NPV and IRR and their link with company valuation
  • How to analysis various capital budgeting decisions
  • Calculation of various ratios
  • Calculate the weighted average cost of capital using capital asset pricing model (CAPM)
  • Calculation of WACC
  • Investment and exit analysis – equity IRR, project IRR etc

Module – 10

Approaches to apply different valuation techniques in the model

  • Different methods of valuation – DCF, Multiples, comparables etc
  • Discounted Cash Flow valuation and different multiples based methodologies
  • Importance of terminal valuation
  • Current industry practices followed in company valuation using single or multiple methodologies
  • How to factor size and illiquidity discount in the final valuation
  • Incorporate various adjustments to the publicly available versions of Company valuation

 

 

Investasi dan Fasilitas Training

  • Harga : (dilampirkan dalam Brosur penawaran)
  • Fasilitas : Certificate, Training kits, USB 8 GB, Lunch, Coffe Break, Souvenir, City Tour
  • Untuk peserta luar kota disediakan transportasi antar-jemput dari Bandara/Stasiun ke Hotel (berlaku bagi perusahaan yang mengirimkan minimal 2 peserta)
  • Quota minimum Running 2 peserta (jogja, Solo, Semarang) Quota minimum Running 3 peserta (Jakarta , Bandung dan Surabaya ) –  ( Untuk Manado, Bali , Batam, Pontianak, Balikpapan dan Lombok Quota minimal 4 peserta)

 

Permintaan Brosur penawaran Training ( Waktu dan Tempat) silahkan Menghubungi kami via :

Mobile : 0823 2326 5005 – 0857 2459 5005

Email : trainingcenterindo@gmail.com / info@jadwaltraining.co.id

Blog : https://informasitrainingdanseminar.wordpress.com

Web: www.informasitraining-indonesia.com

Web www.jadwaltraining.co.id

Jadwal training 2015 | Jadwal training 2016 | Jadwal training 2017 | Jadwal training 2018 | Jadwal training 2019 | Jadwal training 2020

Lokasi Training Pilihan : di Yogyakarta, Jakarta, Bandung, Bogor, Surabaya, Malang, Bali, Lombok, Balikpapan, Makassar, Medan, Batam, Riau, Pontianak, Semarang, Solo, Manado. (dengan harga dan minimal kuota yang berbeda)