TRAINING FINANCIAL MODELLING FOR CAPITAL INVESTMENT PLANNING
TRAINING PEMODELAN KEUANGAN UNTUK PERENCANAAN INVESTASI MODAL
TRAINING INVESTMENT EVALUATION TECHNIQUES
Objective:
1. Understand the concept in investment evaluation techniques
2. Understand how to evaluate investments
3. Knowing the techniques by making modeling capital budget
Syllabus:
1. Making Investment Decision
+ The Investment Problem and Capital Budgeting
+ Cash Flow Estimation
2. Investment Evaluation Techniques
+ Payback period
+ Net Present Value (NPV)
+ Internal Rate of Return (IRR)
+ Profitability Index (PI)
+ Comparing Evaluation Techniques
3. Incorporating Risk in the Capital Budgeting Decision
4. Ranking
+ Capital Rationing
+ Mutually Exclusive Investments
5. Analyzing the Lease versus Borrow to Buy
6. Case Studies
7. Modelling Capital Budget using Ms. Excel
+ Capital Budgeting model layout design
+ Combo box for avoiding error in inputting assumptions
+ Utilizing combo box’s ‘cell link’ by another formulas
+ DATE function
+ OFFSET function
+ Combining numbers and text
+ NPV Function
+ XNPV Function
+ Conditional Formatting for results identification
+ Data Table tool for project sensitivity analysis
+ Dynamic chart
+ Management summary
8. Using Capital Budgeting Model
+ Project appraisal Model
+ Capital rationing model (selecting some projects within the
limited budget)
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 TRAINING TAHUN 2026
03 – 04 Januari 2026 | 16 – 17 Januari 2026
06 – 07 Februari 2026 | 20 – 21 Februari 2026
05 – 06 Maret 2026 | 19 – 20 Maret 2026
03 – 04 April 2026 | 23 – 24 April 2026
07 – 08 Mei 2026 | 21 – 22 Mei 2026
05 – 06 Juni 2026 | 25 – 26 Juni 2026
09 – 10 Juli 2026 | 23 – 24 Juli 2026
06 – 07 Agustus 2026 | 20 – 21 Agustus 2026
04 – 05 September 2026 | 18 – 19 September 2026
08 – 09 Oktober 2026 | 22 – 23 Oktober 2026
06 – 07 November 2026 | 26 – 27 November 2026
04 – 05 Desember 2026 | 18 – 19 Desember 2026
Metode Training
- Tatap Muka/offline
- Online via zoom
Kota Penyelenggaraan jika offline :
- Bandung
- Jogjakarta
- Surabaya
- Jakarta
fasilitas yang didapatkan
- Training Kit Eksklusif
- Tas
- Name Tag
- Modul
- Flash disk
- Ballpoint
- Block Note
- Souvenir
- Harga yang Reliable
- Trainer Kompeten di bidangnya
- Pelayanan Maksimal untuk peserta
- Penjemputan dari dan ke bandara
Investasi :
Public training : Rp. 4.500.000 (minimum 3 pax)
In House Training : on Call
