• BUILDING A BASIC PROJECT FINANCE MODELING (Two-Day Workshop)

BUILDING A BASIC PROJECT FINANCE MODELING (Two-Day Workshop)

From: 17 January 2019
To: 18 January 2019
Hotel Ayana, MidPlaza
Jl. Jend. Sudirman Kav 10-11, Jakarta
Jakarta  
get directions

  • Summary

 

BUILDING A BASIC PROJECT FINANCE MODELING

TWO-DAY TRAINING

In this two-day training, the participant will learn in a quick way about the project finance modeling, which differs from a standard corporate financial model because the investment is characterized by alternative time phases that have different risks, and by the fact that no history on cash flows exists for the investment analyses.

 

First Day

The participants will be introduced first with a case study, which together with the trainer, to build a cash flow model only, that is, no income statement account and no balance sheet is required. Thus, little knowledge of accounting and finance is required.

The following finance and modeling concepts are covered in this case study:

  • Debt vs. equity
  • Interest rate (compounded)
  • Rolled-up interest
  • Debt Service Coverage Ratio (DSCR)
  • Cash flows
  • Pre-tax and Post-Tax Internal Rate of Return (IRR and XIRR functions)
  • Cash waterfalls
  • Flags and setting timeline
  • Conditional formatting
  • Goal Seek function
  • Grouping data
  • Sources and Uses of Fund
  • Inputs, Calculation, and Output Sheets

Second Day

In the second day, the participants will be introduced to the following concepts that are generally used:

  • Timing in Project Finance
  • Building CFADS (Cash Flows Available for Debt Service)
  • Modeling debt principal repayment and debt sizing
  • Modeling DSRA (Debt Service Reserve Account)
  • Modeling a Major Maintenance Reserve Account (MMRA)
  • Calculating Project Life Coverage Ratio (PLCR)
  • Calculating Loan Life Coverage Ratio (LLCR)

*Participant must bring laptop with minimum Microsoft 2017 installed 

 

Speaker:

Sukarnaen Suwanto

Certified Valuation Analyst from IACVA.org & trainer in Corporate Finance & Valuation Topics

 

Thursday - Friday

January 17-18, 2019

09.00 - 17.00 (Registrasi 08.30)

 

Ayana MidPlaza Hotel*

*If the number of participant is less than 10, the training will be held at BDO Meeting Room (Prudential Tower fl. 16/17)

 

Investment:

Rp5.500.000/Pax (Normal Price)

Rp5.000.000/Pax (Early Bird before January10, 2019)

Rp4.500.000/Pax (Company Group - for 3 persons or more )

 

Contact Persons:

Natalie

0857 – 1002 – 0682

[email protected]

Reini

0812 – 8760 – 8686

[email protected]

 

Bank Permata

Branch: Prudential Tower

Bank Account: 701642023

a.n PT BDO Insan Dinamis Indonesia