Hubungi Kami 02742870237 info@bmgtraining.co.id



TRAINING FINANCIAL ANALYSIS USING EXCEL

INFO JADWAL TRAINING FINANCIAL ANALYSIS USING EXCEL

INTRODUCTION 

This course is suitable for users of excel or other spreadsheet software. The course aims at equipping participants with the analytical skills in the areas of finance, accounting, management, and procurement. The course is intended to enhance the Excel modeling and analytical skills of finance professionals for predicting, analysis, and presentation of business and financial data/information.

COURSE OBJECTIVES

  • Using Excel to create professional charts
  • Understand the principles of accounting and bookkeeping
  • Build the financial statements of an organization
  • Understand the importance of timing in relation to cost and revenue recognition
  • Analyze financial statements
  • Calculate liquid_pelatihanity, solvency, growth ratios, and profitability
  • Assess project feasibility
  • Calculate a loan schedule
  • Differentiate between variable and fixed interest rates
  • Carry out industry analysis
  • Understand company’s value drives
  • Business analysis

WHO SHOULD ATTEND

This course targets financial officers, analysts, and portfolio managers who want to learn about valuation and gain skills relevant in making financial decisions.

COURSE OUTLINE

Financial Modeling

  • Flexibility, accuracy, and User-friendliness
  • Structural standards
  • Circular errors, the #REF! problem and Iteration
  • Factual, rational and Structural checks
  • Proofreading and Model Stress Testing

Functions of Financial Modeling

  • Counting and summing functions- SUM; SUMIF; SUMPRODUCT; COUNT; COUNTA; COUNTBLANK; COUNTIF and IF functions- ROUND; ROUNDUP; ROUNDDOWN; CEILING; FLOOR; INT; TRUNC; MOD
  • HLOOKUP; VLOOKUP
  • Discounting on uneven periods: NPV; XNPV; IRP; XIRP
  • Valid_pelatihanation of data; Text to column
  • Pivot tables, what if analysis and data tables
  • Scenario and sensitivity analysis

Modeling for Financial and Operational Planning

  • Repayment of debt
  • Seniority of debt obligations modeling
  • Book and tax depreciation and modeling deferred tax
  • Liability/asset
  • Asset sales modeling

Credit Perspective

  • Capital structure
  • Leverage ratios
  • Interest coverage
  • Working capital
  • Operating results
  • Liquid_pelatihanity ratios

Capital Structures Analysis

  • Debt existing
  • Bank Revolver
  • Long-Term Debt
  • Preferred Stock
  • Book Capitalization
  • Total Debt
  • Book Equity
  • Base of Borrowing
  • Debt Revolver

Cost of Capital Modeling Valuation Models using Discounted Cash Flow Analysis

  • Firms’ free cash flow
  • Free cash flow to equity
  • Single stage and multi stage models
  • Financial analysis principles using VPN, IRP, PBP and other measures
  • Analysis of discounted cash flow
  • Relative valuation
  • Hybrid_pelatihan of relative evaluation and DCF
  • Reality check on results

Modeling for Corporate Finance Transaction Evaluation of Newly Built Financial Model

  • Objectives
  • Hypothesis
  • Logical flow
  • Key inputs
  • Inputs interrelationships
  • Outcome expected
  • Factual, rational, and structural checks

============================================================

FACILITIES

  • Certificate, Quality Training Kit (Pencil case: Erase, Bolpoint, Pencil, Tipe X, Stabillo, Flash Disk 8
  • Bag (Public Training)
  • Training Material (Hand Out & Soft Copy)
  • Convenient training facilities in stars hotel (Public Training)
  • Lunch 1 and Coffee Break 2 / Day (Public Training)
  • Souvenir
  • Gratis antar Jemput dari Bandara/Stasiun ( Khusus Yogyakarta )

 

VENUE 

Yogyakarta, Jakarta, Bandung, Bogor, Cirebon, Solo, Semarang, Surabaya, Malang, Bali, Lombok, Samarinda, Balikpapan, Banjarmasin, Pontianak, Makassar, Medan, Palembang, Lampung, Timor Leste, Thailand, Singapore , Kuala Lumpur.  (dengan harga dan minimal kuota yang berbeda)

TRAINING METHOD

  • Group Discussions
  • Group & Individ_pelatihanual Exercises
  • Presentations
  • Games
  • Case Studies
  • Role Plays
  • Self-Assessment
  • Action Plan

INSTRUCTOR TRAINING

 Tim Konsultan BMG Training & Development

Course Timings:

Daily Course Timings:

  •     08:00 - 08:20       Registerasi dan Pembukaan
  •     08:30 - 10:00       Sesi Pertama
  •     10:00 - 10:20       Coffee / Tea / Snacks
  •     10:20 - 12:00       Sesi Kedua
  •     12:00 - 13:00       Lunch Break & Prayer Break
  •     13:00 - 15:00       Sesi ketiga
  •     15:00 - 15:20       Coffee / Tea / Snacks & Prayer Break
  •     15:00 - 16:30       Sesi Terakhir

Permintaan Brosur penawaran Training ( Harga, Waktu dan Tempat) silahkan Menghubungi kami.

======================================================

Catatan :

Pelatihan ini dapat di-customized sesuai kebutuhan perusahaan Anda bila diselenggarakan dalam bentuk In-House Training. Untuk permintaan In-House Training dengan jenis topik lainya, silahkan mengirimkan ke alamat email yang tercantum di web kami.

—————————————————————————————-

Request Training. Jika anda membutuhkan informasi pelatihan yang belum tercantum pada website ini, atau anda ingin memberikan usulan materi yang sesuai dengan tingkat kebutuhan perusahaan anda, silahkan mengirimkan ke alamat emailyang tercantum.

—————————————————————————————-

Bila tid_pelatihanak ada tanggal dan waktu atau yang tercantum sudah kadaluarsa did_pelatihanalam artikel mohon tanyakan kepada kami untuk jadwal terbarunya.

—————————————————————————————-

Peserta bisa mengajukan Tanggal Pelatihan / Training selain yang tertera pada silabus penawaran.

—————————————————————————————-

Venue : di Yogyakarta, Jakarta, Bandung, Bogor, Cirebon, Solo, Semarang, Surabaya, Malang, Bali, Lombok, Samarinda, Balikpapan, Banjarmasin, Pontianak, Makassar, Medan, Palembang, Lampung, Timor Leste, Thailand, Singapore , Kuala Lumpur.  (dengan harga dan minimal kuota yang berbeda)

—————————————————————————————-

Info Jadwal training 2019 , Jadwal training 2019 , Informasi Jadwal training 2019 , Jadwal training 2020 , Jadwal training 2021 , Jadwal training 2022

Training Lainnya