TRAINING PROJECT FINANCE MODELLING

TRAINING PENGENALAN PROJECT FINANCE MODELLING

TRAINING FINANCIAL PROYEK

DESCRIPTION

This  course will learn about best practices in financial modelling as
well as advanced project finance modelling concepts.

Â

OBJECTIVE
* Introduce  about  Project Finance, including the reasons for using
it and the key characteristics of a Project  Finance transaction
* This  course  hopefully  can  increase  awareness of best practice
modelling  methodologies  and  consistency  of   approach  in the
context of a Project Finance transaction
* Improve the team’s Ms Excel efficiency

Â

MATERI Training Project Finance Modelling

1.  Master  Proven Techniques For Best Practice Modelling Resulting In
Better Models Built Faster
* Learn  to  work  with  the  powerful and easy to follow SMART best
practice modelling methodology
* Discuss  and  identify  good  vs  bad  modelling  techniques using
real-life examples
* Greatly  increase  consistency  amongst  your  team in calculation
technique and presentation

2.  Discuss  The Life-cycle of a Project Finance Model, From Screening
and Structuring to Financial Close
* Learn the various structural phases of project finance
* Understand when to use which phase
* Build  your  understanding  of  the building block components, key
details and challenges of a transaction model
* Understand the design flow of the model builder, learn how to know
where to go next

3.  Develop  a  Model  Structure  That is Robust and Scalable That Can
Evolve With a Typical Project or Transaction
* Establish  key  constants  in  the model using full scope of Excel
range name function
* Build a flexible timing structure using appropriate date functions
and binary flags

4.  Construct  Modularised  Units  That  Form the Building Blocks of a
Professional Model Including (but not limited to)
* Capital Expenditure breakdown with contingencies controls
* Production calculations with multi-path optionality on time-series
schedules
* Revenue build up with detailed pricing controls
* Operational  and maintenance expenses including fixed and variable
items
* Understand the structure of cashflow waterfalls and the importance
of ‘seniority’
* Focus on how to calculate Cash Flow Available for Debt Service
* Learn  how  to  layout  line  items  in  an  efficient and easy to
communicate way

5.  Understand  the  Different Types of Circular References and How to
Avoid Them
* Integrate project finance term (operational) debt
* Walk  through  of  term  debt  structuring  and  annuity repayment
through first principles
* Inclusion   of   target  Debt  Service  Coverage  Ratio  repayment
functionality
* Discussion  of  linear  and bullet repayment structures in project
finance

6.  Construct  and  Analyse  Debt  Facilities for Credit or Investment
Decisions
* Learn  the  importance  of  credit  ratios  and  their purposes in
analysis
* Build  commonly  used  ratios  in  banking  and finance from first
principles
* Extract  key  metrics  from ratios using a range of advanced Excel
functions

7.  Calculate Key Returns Results and Understand The Role of Dividends
Policy
* Discuss the reason and impact of dividends policy on valuations
* Integrate internal rate of returns and NPV, understand role of the
discount rate
* Learn differences between NPV and XNPV functions and common errors
in their application

8.  Take Control of Robust and Rapid Sensitivity and Scenario Analysis
Through Powerful Excel Techniques
* Save time and deliver rapid analysis with our approach to scenario
management
* Use the scenario manager to test the model in all scenarios
* Build   confidence   in   your   analysis  through  pre-programmed
combinations of model inputs

Â

TRAINING METHOD

Presentation

Discussion

Case Study

Evaluation

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

1. Tatap Muka/offline
2. Online via zoom

Kota Penyelenggaraan jika offline :

1. Bandung
2. Jogjakarta
3. Surabaya
4. Jakarta

fasilitas yang didapatkan

1. Training Kit Eksklusif
   • Tas
   • Name Tag
   • Modul
   • Flash disk
   • Ballpoint
   • Block Note
   • Souvenir
2. Harga yang Reliable
3. Trainer Kompeten di bidangnya
4. Pelayanan Maksimal untuk peserta
5. Penjemputan dari dan ke bandara

Investasi :

Public training : Rp. 4.500.000 (minimum 3 pax)

In House Training : on Call