Pemodelan Keuangan untuk Penganggaran Perusahaan, Analisis Sensitivitas & Skenario dan Konsolidasi
Financial Modelling for Consolidation
Financial Modelling for Corporate Budgeting
Objective:
In this training you will be guided step by step to create a budget
model as a module by module and create variance analysis, dynamic
charts, sensitivity and scenario analysis tools, and also learning
techniques that facilitate the financial company consolidation.
Syllabus:
1. Introduction to Financial Modeling
+ Financial Modelling Best Practice
+ Using Mini Financial Statements for Easier Comprehension
+ Incorporating Sensitivity & Scenario Analysis Modules into
the Mini Financial Statements
2. Financial Modelling for Corporate Budgeting
+ Modelling Operating Budget – Sales & Collections – COGS,
Inventory, Purchases – Operating Expenses
+ Modeling Financial Budget – Capital Budget – Borrowings and
Cash Budget
+ Modeling Financial Statements and Statement of Cash Flows
+ Modeling Financial Ratios, Contribution Margin and Variance
Analysis
+ Building a Dynamic Chart
+ Building a Sensitivity & Scenario Analysis Tools
3. Financial Modelling for Consolidation
+ Modeling Techniques for Consolidation
+ Modeling Cost Method, Equity Method and Consolidation in a
mini financial model
+ Modeling Cost Method, Equity Method and Consolidation using
fully developed financial models
Who should attend?
Finance & Accounting Staff and Manager, Strategic & Corporate Planner,
Financial Controller, Financial & Business Analysts, Risk Manager,
Credit Analyst & Reviewer, Investment Analysis, Equity Analyst,
Investment Banker, Corporate Finance Officer, Corporate Planner,
Project Analyst, Treasury Manager, General Manager, Corporate &
Government Officer, Business Owner, Business Advisor or anyone who has
strong passion for Financial Modeling.
Trainer:
Mariawati Lim
Maria has over 16 year’s experiences in the field of financial
advisory services in one of the big four. As a financial model
trainer, Maria has been providing training, both public and in- house
to more than 1,500 professionals from various companies.
Noted:
* Please bring your own laptop with Microsoft Excel 2007 or 2010
installed
* This training is paperless so you will receive full course notes
in a USB full of practical templates, exercises & solutions,
reference guides, add-ins and other useful tools.
* Training will be delivered in Bahasa Indonesia
* You will receive a Certificate of Completion, a recognition of
your accomplishment, skills & knowledge learned after completion
of this course
* It is assumed that participants know how to navigate confidently
in Excel, create and use simple formulas.
Jadwal Pelatihan Galeri Training Tahun 2025 :
- Batch 1 : 7 – 8 Januari 2026
- Batch 2 : 11 – 12 Februari 2026
- Batch 3 : 4 – 5 Maret 2026
- Batch 4 : 8 – 9 April 2026
- Batch 5 : 6 – 7 Mei 2026
- Batch 6 : 10 – 11 Juni 2026
- Batch 7 : 8 – 9 Juli 2026
- Batch 8 : 5 – 6 Agustus 2026
- Batch 9 : 9 – 10 September 2026
- Batch 10 : 14 – 15 Oktober 2026
- Batch 11 : 4 – 5 November 2026
- Batch 12 : 2 – 3 Desember 2026
peserta minimum 2 (dua) peserta terpenuhi.
Biaya dan Lokasi training pengenalan coaching, counseling & mentoring terbaru :
Lokasi :
Jakarta : Hotel Amaris Kemang, Amaris Tendean,Trinity Hotel, Ibis Budget.
Bandung : Hotel Santika, Hay Hotel,Ibis Style, Novotel Hotel, Golden Flower Hotel, 1O1 Hotel, Grand Tjokro Hotel, Tune Hotel, Four Point by Sheraton Hotel .
Yogyakarta : Hotel NEO+ Awana, Cordela Hotel,Ibis Style, Boutique Hotel, Cavinton Hotel, Mutiara Hotel, Dafam Malioboro Hotel, Prima Inn Hotel .
Surabaya : Novotel Hotel, Ibis Center Hotel, HARRIS Hotel, Favehotel, Alana Hotel .
Malang : Amaris Hotel, The 1O1 Hotel, Ibis Style Hotel, El Hotel, Whiz Prime Hotel .
Bali : Ibis Kuta, Fontana Hotel, HARRIS Hotel & Conventions .
Lombok : Favehotel, Novotel Lombok, D Praya Hotel .
Catatan : Biaya diatas belum termasuk akomodasi/penginapan.
Investasi training konsep counseling murah :
Investasi pelatihan selama tiga 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 prinsip mentoring murah :
1. FREE Airport pickup service (Gratis Antar jemput Hotel/Bandara)
2. FREE Akomodasi Peserta ke tempat pelatihan .
3. Module / Handout training pengenalan coaching, counseling & mentoring terupdate .
4. FREE Flashdisk .
5. Sertifikat training coaching, counseling & mentoring terupdate .
6. FREE Bag or bagpackers (Tas Training) .
7. Training Kit (Dokumentasi photo, Blocknote, ATK, etc) training konsep counseling terbaru .
8. 2xCoffe Break & 1 Lunch, Dinner.
9. Souvenir .
