PELATIHAN FINANCIAL MODELLING FORBUDGETING AND FORECASTING IN EXCEL

Deskripsi Training financial modelling forbudgeting and forecasting in excel

Pelatihan “Financial Modeling for Budgeting and Forecasting in Excel” bertujuan untuk memberikan pemahaman dan keterampilan dalam membangun model keuangan yang digunakan untuk perencanaan anggaran dan peramalan dalam Excel.

TUJUAN TRAINING PEMODELAN KEUANGAN UNTUKMELUPAKAN DAN MERAMALKAN DI EXCEL

Dengan mengikuti  pemodelan keuangan untukmelupakan dan meramalkan di excel  mengenai training pemodelan keuangan untukmelupakan dan meramalkan di excel dengan peserta dari perusahaan lain yang bergerak di bidang perencanaan & pengendalian anggaran perusahaan.

OUTLINE MATERI

Materi training using budgets as performance management :

1. Cost Management Concepts
   * Overview of accounting theory critical for the budget manager
   * Financial Accounting vs. Management Accounting
   * General ledger accounting for budgeting
   * Budgeting for marginal, opportunity and sunk costs 
2. Budgets and Strategic Planning
   How budgeting fits into your organisation’s strategic planning process
   * Linking Budgets to business objectives
   * Budgeting to achieve organisational objectives
   * How to turn measurement into management
   * Budgeting vs forecasting 
3. Using Budgets as Performance Management
   What gets measured gets done!
   * The impact of budgets on organisational performance
   * Successfully integrating forecasting and budgeting as essential tools for measuring performance
   * Translating the organisation’s values into measures and targets 
4. Financial Statements
   Consolidating the detailed budget into financial statements
   * Linking financial statements to drivers
   * Measures such as NPAT, EBIT and EBITDA
   * Budgeting cashflow
   * Capital Expenditure and depreciation budgeting 
5. Reporting
   Using budget reporting for management and decision making
   * Using reporting to promote accountability
   * Variance analysis
   * Non-financial measures such as the balanced score-card
   * Budgeting and forecasting as a planning and management tool
   * Assessment and selection of appropriate systems 
6. Budgeting Techniques
   Discussion and overview of different budgeting systems and methods
   * Historical-based versus Zero-based budgeting
   * Top down vs bottom up
   * Activity Based Budgeting
   * Flexible budgets
   * Rolling forecasts
   * Differences between a static, flexible and rolling budget
   * Budgeting for capital expenditure vs. operational expenditure
   * Contingency planning 
7. Limitations of budgets
   What’s wrong with how we do budgets?
   * Critique of the traditional budget process
   * Estimations and rigidity
   * Staff perceptions and changing environments
   * Dysfunctional budgeting behavior 
8. Budgeting “Soft” Skills
   Non-financial skills required for the budget manager
   * Achieving buy-in from stakeholders
   * Involving non-financial management of the organisation
   * Techniques in getting your budget approved
   * Managing conflicting priorities and demands
   * Setting timelines

METODE

Metode pelatihan using budgets as performance management dapat menggunakan fasilitas training zoom atau training online, dan bisa juga training offline atau training tatap muka.

INSTRUKTUR

Instruktur yang mengajar pelatihan pemodelan keuangan untukmelupakan dan meramalkan di excel ini adalah instruktur yang berkompeten di bidang Perilaku individu dalam organisasi baik dari kalangan akademisi maupun praktisi.

PESERTA

Peserta yang dapat mengikuti training using budgets as performance management online adalah :

1. 1. Manajer Keuangan
   2. Manajer Operasional
   3. Analis Keuangan
   4. Profesional Keuangan Lainnya
   5. Mahasiswa dan Akademisi

Jadwal Pelita Training 2025

Januari : 16 – 17 Januari 2025
Februari : 13 – 14 Februari 2025
Maret : 5 – 6 Maret 2025
April : 24 – 25 April 2025
Mei : 21 – 22 Mei 2025
Juni : 11 – 12 Juni 2025
Juli : 16 – 17 Juli 2025
Agustus : 20 – 21 Agustus 2025
September : 17 – 18 September 2025
Oktober : 8 – 9 Oktober 2025
November : 12 – 13 November 2025
Desember : 17 – 18 Desember 2025

Investasi dan Lokasi pelatihan:

• Yogyakarta
• Jakarta
• Bandung
• Bali
• Surabaya
• Malang
• Lombok

Kisaran Investasi training cost management concepts online Rp 5.500.000,- an (**syarat dan ketentuan berlaku**)
Harga setiap kota akan berbeda serta semakin banyak peserta dalam 1 instansi yang sama pun, akan lebih murah. Untuk informasi lebih lanjut hubungi kami segera.

Catatan : Apabila perusahaan membutuhkan paket in house training, anggaran investasi pelatihan dapat menyesuaikan dengan anggaran perusahaan