Training Financial Modeling for Mompany Debt Re-Structuring Using Multiple Cashflow Calculation Method Tith Excel, vba & Xcelcius
Latar Belakang
- Kreditur sering melakukan analisa terhadap berbagai cara debitur untuk melakukan pembayaran kembali pinjaman yang diberikan (debt repayment methods) dalam kegiatan pembiayaan proyek (project finance transaction). Proses ini sangat penting dalam menentukan struktur kredit yang akan diberikan.
- Kreditur ingin agar dapat melakukan simulasi atas berbagai cara pembayaran kembali seperti :
- Annuity (Equal Principal Repayment+Interest)
- Equal Principal (Straight line equal Principal repayments)
- % Profile (User to enter % repayment profile)
- Dengan memiliki financial model dengan kedua fitur ini, maka para pengambil keputusan akan dapat mengambil keputusan dengan cepat.
- Mengetahui cara menggunakan SAP Dashboard Design (Xcelsius), menentukan komponen mana yang paling sesuai untuk me-representasikan bermacam-macam informasi yang berbeda, mem-finalisasi dashboard dan mengekspor menjadi file format yang berbeda.
Menimbang cukup kompleknya materi pelatihan Financial Modeling for Mompany Debt Re-Structuring Using Multiple Cashflow Calculation Method Tith Excel, vba & Xcelcius ini bagi peserta, dibutuhkan training provider yang berpengalaman di bidangnya agar tidak membuat peserta tidak menjadi cepat bosan dan jenuh dalam mendalami bidang teknik ini. Mitra Solusi Training dapat menjadi mitra terpercaya anda untuk solusi kebutuhan training di perusahaan anda.
Jika anda mengikuti training di PT Mitra Solusi Training, anda akan mendapatkan pembahasan mengenai :
Day 1 :
Day 1a – Financial Modeling Fundamental
08:30 – 09:00 Registration
09:00 – 09:30 Session 1 :
ª Introduction and Overview
- Overview of the Course
- Definition of Financial Model
- Scope of financial model
Objectives of financial model
ª Financial Modeling Design Principles
- Financial Statement Interrelationship
- Financial Modeling Design Principles
- Design Flow & Model Layout : Input, Working & Output
Financial Model Flow Chart
09:30 – 10:15 Session 2 :
ª Developing Excel Skills : Powerful Functions Used in Financial Models
- Statistical Functions: MAX, MIN
- Lookup and Reference Functions: OFFSET, INDEX, MATCH
- Date and Time Functions: DATE, DATEDIF
- Information Functions: IFERROR, ISNUMBER, ISTEXT
10:15 – 10:30 Coffee Break
10:30 – 12:00 Session 2 (Continued) :
ª Developing Excel Skills : Powerful Functions Used in Financial Models (Continued)
- Math Functions : ROUND, ROUNDUP, ROUNDDOWN, MOD
- Range Names : Naming one cell, Naming Row, Naming relative reference
- Conditional Formatting
- Data Validation
- Using Form Control : Combo Box, List Box, Spinner, Button
- What-if Analysis Techniques
- Using scenario manager & scenario buttons
12:00 – 13:00 Lunch Break
Day 1b – Modeling Mini Financial Model
13:00 – 15:15 Session 3 :
ª Modeling Mini Financial Model
- Pre-Development – Defining a financial model plan
- Knowing financial model objective
• Specification and planning, flowchart and information flow
• Design and structure – key steps
ü Development process
• Modeling mini balance sheet
• Balancing the balance sheet
• Modeling mini income statement
• Testing and debug
15:15 – 15:30 Coffee Break
15:30 – 17:00 Session 4 :
ª Using Datatable
- Working with one-variable datatable
- Working with two-variable datatable
ª Introduction to VBA (Visual Basic for Application)
- Recording Macro for Button
- Activating and using Visual Basic Editor
- Using VBA codes for automation What-if analysis techniques
- Number Fomating Using VBA codes
Day 2 :
Day 2a – Modeling Powerful and Easy to Use Financial Model
08:30 – 09:00 Registration
09:00 – 09:30 Session 5 :
ª Modeling Powerful and Easy to Use Financial Model
- Understanding and creating a financial model template
- Modeling historical sheet
- Modeling assumption sheet – identifying key growth drivers
- Modeling income statement
- Modeling balance sheet statement
- Modeling accounting relationships between the income statement and the balance sheet.
- Modeling cash flow statement
- Modeling ratios for analysis
10:15 – 10:30 Coffee Break
10:30 – 12:00 Session 6 :
ª Modeling Sensitivity & Scenario Analysis Tool
- Scenarios simulation using VBA
- Using Data Table & Scenarios for Sensitivity & Scenario Analysis
- Modeling Dynamic Data Table for versatile Sensitivity & Scenario Analysis
- Modeling Dynamic Chart to visualize the result of Sensitivity & Scenario Analysis
12:00 – 13:00 Lunch Break
Day 2b – Valuation Modeling
13:00 – 15:15 Session 7 :
ª Modeling Cash Sweep
ª Modeling Cashflow Waterfall
ª Modeling Average DSCR (Debt Service Coverage Ratio)
ª Modeling CFADS (Cashflow Available for Debt Service)
ª Modeling Dynamic Graph CFADS (Cashflow Available for Debt Service)
ª Modeling DSRA (Debt Service Reserve Account)
15:15 – 15:30 Coffee Break
15:30 – 17:00 Session 8 :
ª Introduction to Dynamic Business Dashboards
- What is a SAP Dashboard Design (Xcelsius)? How does it work?
- Sample Crystal Xcelsius – Different by application
- Relationship between Excel & Xcelsius
- Supported Excel Functions
- Principles of a good design – best practice
- Crystal Xcelsius elements
• The canvas
• The component list & categories
• The component properties (General, Behavior, Appearance)
ª Modeling Dynamic Business Dashboard
- Importing underlying spreadsheet
- Working with canvas, components and properties
- Creating dynamic what-if analysis dashboard (Creating dynamic dashboard for profitability analysis)
- Assessing the company profitability
- Setting Scenarios
- Export interactive business dashboard to Powerpoint, Word dan PDF, for easy distribution to other people
- Studi Kasus / Praktek pemecahan masalah Financial Modeling for Mompany Debt Re-Structuring Using Multiple Cashflow Calculation Method Tith Excel, vba & Xcelcius.
Menimbang cukup kompleknya materi pelatihan Financial Modeling for Mompany Debt Re-Structuring Using Multiple Cashflow Calculation Method Tith Excel ini bagi peserta, dibutuhkan training provider yang berpengalaman di bidangnya agar tidak membuat peserta tidak menjadi cepat bosan dan jenuh dalam mendalami bidang teknik ini.
Untuk itu pentingnya agar kita dapat dibimbing melaluli sebuah pelatihan Financial Modeling for Mompany Debt Re-Structuring Using Multiple Cashflow Calculation Method Tith Excel, vba & Xcelcius, namun sayangnya tidak banyak training provider yang spesialis di bidang Financial, untuk itu Perlunya bagi kita untuk dapat memilih provider training yang tepat agar pengetahuan kita mengenai Financial Modeling for Mompany Debt Re-Structuring Using Multiple Cashflow Calculation Method Tith Excel, vba & Xcelcius tepat guna dan tepat sasaran. Hubungi Mitra Solusi Training bisa zoom, online / tatap muka, offline | WA : 0812 9044 6707 untuk informasi lebih lanjut mengenai jadwal training Financial Modeling for Mompany Debt Re-Structuring Using Multiple Cashflow Calculation Method Tith Excel, vba & Xcelcius yang terdekat yang akan running.
Jika anda mengikuti pelatihan Financial Modeling for Mompany Debt Re-Structuring Using Multiple Cashflow Calculation Method Tith Excel, vba & Xcelcius secara offline / tatap muka di Mitra Solusi Training, anda juga akan mendapatkan fasilitas :
Free Penjemputan dari bandara ke hotel*.
Modul / Handout.
Flashdisk*.
Certificate of attendance.
FREE Bag or bagpacker.
Lokasi yang dapat anda pilih antara lain :
Yogyakarta
Jakarta
Bandung
Surabaya
Bali
Lombok
