TRAINING ONLINE FINANCIAL MODELLING FORBUDGETING AND FORECASTING IN EXCEL
TRAINING ONLINE FINANCIAL MODELLING FORBUDGETING AND FORECASTING IN EXCEL
Kursus ini mencakup penggunaan praktis Pemodelan Excel dalam konteks penganggaran dan peramalan. Ini dirancang untuk pengguna yang menggunakan Excel secara teratur, dan merasa nyaman dengan alat dan teknik Excel yang umum digunakan. Sementara gambaran singkat tentang alat yang digunakan dalam kursus ini disediakan, diasumsikan bahwa delegasi adalah pengguna Excel yang percaya diri. Kursus ini dibangun di atas pengetahuan tingkat lanjut siswa tentang alat dan fungsi Excel dan menggabungkannya ke dalam model keuangan yang kompleks dan dinamis.
Menimbang cukup kompleknya materi pelatihan Financial Modelling forBudgeting and Forecasting in Excel ini bagi peserta, dibutuhkan training provider yang berpengalaman di bidangnya agar tidak membuat peserta tidak menjadi cepat bosan dan jenuh dalam mendalami bidang teknik ini.
TUJUAN TRAINING USING BUDGETS AS PERFORMANCE MANAGEMENT UNTUK PRAKERJA
Dengan mengikuti pelatihan Financial Modelling forBudgeting and Forecasting in Excel Peserta dapat berbagi pengetahuan / sharing knowledge mengenai Financial Modelling forBudgeting and Forecasting in Excel dengan peserta dari perusahaan lain yang bergerak di bidang Financial Modelling forBudgeting and Forecasting in Excel
MATERI pelatihan Pemodelan Keuangan untukMelupakan dan Meramalkan di Excel online Zoom
Day One: Budgeting and Forecasting Theory
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
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
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
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
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
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
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
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
Day Two: Budget and Forecast Modelling
Developing the Budget Model
Turn your budget theory into a practical and dynamic financial model
* Types of budget model (short and long-term models)
* Fixed vs. variable costs
* Drivers in budget modeling; e.g. industry forecasts, growth rates,
market share
* Key factors and considerations for a reliable forecasting
* Modelling for “Stepped” costs
* Using goal-seek to perform break even analysis
Practical exercise: create a model in Excel which will calculate
volume-dependent “step” costs. Calculate break-even point using
goal-seek.
Determination of business trends, cycles & seasonality
Utilisation of trends, cycles of the current market situation in the
forecasting process
* Understanding the inter-relationship among trends, cycles and
seasonality
* Recognizing patterns in financial data
* Using Regression Analysis as a predictor and estimator
* Identifying and calculating business trends, business cycles and
seasonality in historical data
* Using the seasonality factor in interpreting the forecast
variances
Practical exercise: Forecast a sales cycle in Excel based on
historical data by calculating the seasonality index and adjustingthe
forecast accordingly.
Scenarios, Sensitivities and Stress-testing
How sensitive is your business to changes in budget drivers?
* The difference between scenarios and sensitivities
* Multi-currency budgeting
* Stress-testing and validating your budget model integrity
* Performing a “what-if” and sensitivity analysis
* Optimize results and achieve maximum efficiency within constraints
* Creating and displaying budget scenarios
Studi Kasus / Praktek pemecahan masalah Financial Modelling forBudgeting and Forecasting in Excel
METODE pelatihan Using Budgets as Performance Management online Zoom
Metode Training Financial Modelling forBudgeting and Forecasting in Excel dapat menggunakan fasilitas training zoom atau training online, dan bisa juga training offline atau training tatap muka.
INSTRUKTUR pelatihan Cost Management Concepts online Zoom
Instruktur yang mengajar pelatihan Financial Modelling forBudgeting and Forecasting in Excel ini adalah instruktur yang berkompeten di bidang Financial Modelling forBudgeting and Forecasting in Excel baik dari kalangan akademisi maupun praktisi.
PESERTA
Peserta yang dapat mengikuti training Financial Modelling forBudgeting and Forecasting in Excel ini adalah staff sdm atau karyawan yang ingin mendalami bidang Financial Modelling forBudgeting and Forecasting in Excel .
Karena kompleksnya pelatihan ini, maka dibutuhkan pendalaman yang lebih komprehensif melalui sebuah training. Dan menjadi sebuah kebutuhan akan training provider yang berpengalaman di bidangnya agar tidak membuat peserta menjadi cepat bosan dan jenuh dalam mendalami bidang teknik ini. TRAINING WEBINAR PEMODELAN KEUANGAN UNTUKMELUPAKAN DAN MERAMALKAN DI EXCEL
Jadwal Pelatihan tahun 2026
Batch 1 : 17 – 18 Januari 2023 | 26 – 27 Januari 2023
Batch 2 : 9 – 10 Februari 2023 | 21 – 22 Februari 2023
Batch 3 : 8 – 9 Maret 2023 | 16 – 17 Maret 2023
Batch 4 : 12 – 13 April 2023 | 20 – 21 April 2023
Batch 5 : 10 – 11 Mei 2023 | 25 – 26 Mei 2023
Batch 6 : 7 – 8 Juni 2023 | 22 – 23 Juni 2023
Batch 7 : 11 – 12 Juli 2023 | 27 – 28 Juli 2023
Batch 8 : 10 – 11 Agustus 2023 | 23 – 24 Agustus 2023
Batch 9 : 6 – 7 September 2023 | 21 – 22 September 2023
Batch 10 : 11 – 12 Oktober 2023 | 26 – 27 Oktober 2023
Batch 11 : 9 – 10 November 2023 | 21 – 22 November 2023
Batch 12 : 6 – 7 Desember 2023 | 21 – 22 Desember 2023
Jadwal tersebut dapat disesuaikan dengan kebutuhan calon peserta
Lokasi Pelatihan
Yogyakarta, Hotel Dafam Seturan.
Jakarta, Hotel Amaris Kemang.
Bandung, Hotel Amaris Setiabudhi.
Bali, Hotel Quest Kuta.
Lombok, Hotel Jayakarta.
Catatan
Waktu pelatihan Dua+1* hari dengan Biaya tersedia untuk Perorangan, Group, dan Inhouse Training, belum termasuk akomodasi/penginapan.
Untuk biaya dan jadwal training harap menghubungi marketing kembali
Investasi training
Investasi pelatihan selama dua hari tersebut menyesuaikan dengan jumlah peserta (on call). *Please feel free to contact us.
Apabila perusahaan membutuhkan paket in house training, anggaran investasi pelatihan dapat menyesuaikan dengan anggaran perusahaan.
Fasilitas training:
Free Penjemputan dari bandara ke hotel*.
Modul / Handout.
Flashdisk*.
Certificate of attendance.
FREE Bag or bagpacker.
