Financial Modelling for Capital Investment Planning

Pemodelan Keuangan untuk Perencanaan Investasi Modal
Investment Evaluation Techniques
Understand how to evaluate investments

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 TMI Consultant 2025

Batch 1 : 15 – 16 Januari 2025

Batch 2 : 12 – 13 Februari 2025

Batch 3 : 19 – 20 Maret 2025

Batch 4 : 16 – 17 April 2025

Batch 5 : 14 – 15 Mei 2025

Batch 6 : 11 – 12 Juni 2025

Batch 7 : 9 – 10 Juli 2025

Batch 8 : 13 – 14 Agustus 2025

Batch 9 : 17 – 18 September 2025

Batch 10 : 15 – 16 Oktober 2025

Batch 11 : 12 – 13 November 2025

Batch 12 : 10 – 11 Desember 2025

Catatan : Jadwal dapat menyesuaikan dengan kebutuhan anda.

Biaya dan Lokasi Pelatihan :

• Jakarta: Hotel Amaris Kemang, Amaris Tendean,Trinity Hotel, Ibis Budget | Biaya Pelatihan : Rp. 7.500.000 / peserta(Minimal 2 Peserta).
• Bandung: Hotel Santika, Hay Hotel,Ibis Style, Novotel Hotel, Golden Flower Hotel, 1O1 Hotel, Grand Tjokro Hotel, Tune Hotel, Four Point by Sheraton Hotel | Biaya Pelatihan : Rp. Rp. 7.000.000 / peserta(Minimal 2 Peserta).
• Yogyakarta : Hotel NEO+ Awana, Cordela Hotel,Ibis Style, Boutique Hotel, Cavinton Hotel, Mutiara Hotel, Dafam Malioboro Hotel, Prima Inn Hotel | Biaya Pelatihan : Rp. 6.500.000 / peserta(Minimal 2 Peserta).
• Surabaya: Novotel Hotel, Ibis Center Hotel, HARRIS Hotel, Favehotel, Alana Hotel | Biaya Pelatihan : Rp. 6.800.000 / peserta (Minimal 2 Peserta).
• Malang : Amaris Hotel, The 1O1 Hotel, Ibis Style Hotel, El Hotel, Whiz Prime Hotel | Biaya Pelatihan : Rp. 6.800.000 / peserta (Minimal 2 Peserta).
• Bali: Ibis Kuta, Fontana Hotel, HARRIS Hotel & Conventions | Biaya Pelatihan : Rp. 6.500.000 / peserta (Minimal 3 Peserta).
• Lombok: Favehotel, Novotel Lombok, D Praya Hotel | Biaya Pelatihan : Rp. 7.000.000 / peserta (Minimal 3 Peserta).

Catatan : Biaya diatas belum termasuk akomodasi/penginapan. Apabila ada pertayaan mengenai materi, biaya, lokasi, jadwal dan penawaran lainnya, hubungi kami di nomor CS kami.

Fasilitas Pelatihan di TMI Consultant:

1. Penjemputan dari Hotel/Bandara/Stasiun/Terminal.
2. Training Kit (Dokumentasi photo, Blocknote, ATK, Flashdisk, dll).
3. Transportasi Peserta ke tempat pelatihan.
4. 2x Coffe Break & 1 Lunch (Makan Siang).
5. Training Room Full AC and Multimedia.
6. Free Bag or Bagpackers (Tas Training).
7. Softfile Foto Training
8. Sertifikat Pelatihan.
9. Souvenir Exclusive.