BandungFinance, Accounting, Tax, Treasury, Audit & Risk ManagementMaret 2015

Financial Modeling

Jadwal Training Financial Modeling:

     

    TUJUAN

    Pelatihan ini sangat sesuai bagi bankers/kreditur, professional dari perusahaan sekuritas, investor dan siapapun yang ingin menigkatkan kemampuan utnuk dapat :

    1. Membangun financial model untuk melakukan analisa keuangan dna kredit
    2. Membangun modul untuk menemukan batas-batas covenant sebagai persyaratan kredit/obligasi/MTN
    3. Melakukan stress test dengan menggunakan sensitivity & Scenario analysis tool
    4. Melakukan analisa menggunakan dana dengan dynamic charts of sources & User of cash analysis tool.
    5. Melakukan simulasi pinjaman/obligasi/MTN

     

    MATERI Training Financial Modeling

    1. Building financial model for analysis :

    • Identifying key drivers in the financial model
    • Modeling accounting relationships between the income statement and balanced sheet
    • Modeling multi currency short term and long term borrowing & estimating forex loss/gain
    • Modeling income statement , balance sheet & cash flow statement
    • Balancing the balance sheet-incorporating short term debt plug on balance sheet

    2.  Modeling financial covenant

    3.  Understanding of risk and multiple outcomers:

    • Sensitivity & stress test analysis
    • Scenario analysis

    4.  Using dynamic charts of sources & use of cash analysis

    5. Modeling scenario using button & macro recording

    6. Financial simulation

    • The impact on forecast financial statement
    • Modeling covenant compliance, forecasting credit ratios
    • Testing covenant sensitivity, developing the base for credit analysis
    • Using dynamic data tables for sensitivity & Scenario analysis to test company’s creditworthiness
    • Using dynamic chart to visualize the result of sensitivity and scenario analysis

     

    METODE PELATIHAN

    Presentation

    Discussion

    Case Study

    Evaluation

     

    FASILITAS

    Training Kit

    Flash disc

    Handout

    Certificate

    Lunch + 2 X Coffee Break

    Souvenir

     

    BIAYA PELATIHAN

    Rp. 8.000.000,- /Peserta /Non Recidential

    Form Pre-Registrasi

    Data Materi Training

    Topik Training : Financial Modeling
    Link
    *Jumlah Peserta Estimasi Jumlah Peserta yang di ajukan
    *Nama Peserta Yang Didaftarkan

    Personal Data

    *Nama
    *Jabatan Jabatan/Divisi/Departement
    *Nama Perusahaan
    *Alamat Perusahaan
    *Email Perusahaan
    *Email Alternatif eg: gmail, yahoo, hotmail
    *Telepon Kantor
    Ekstensi
    *Handphone
    * Harus di isi
    Tags
    , , , , , , , , , , ,

    Related Articles

    Check Also

    Close
    *Semua Silabus dan jadwal training yang ada di Training SDM adalah milik dari masing-masing vendor penyelenggara training.
    Close