• Basics of Corporate Financial Modeling

Basics of Corporate Financial Modeling

Date: 27 June 2018
Hotel Ayana Midplaza
Jl. Jend. Sudirman Kav.10-11
Jakarta  
get directions

  • Summary

This is a hands-on training, meaning that there will be no presentation slides. The participant will actively work together with the trainer to build the corporate model using their own laptop.

Things you will bring to your job after attending this training class:

First session before lunch:

The participant will be worked through as to how to make models be more user-friendly and structured, by showing the original and the finished model, by adding and/or learning about:

  • Formats, number formats, lines and borders, colour and patterns, specific colour for inputs and results;
  • Data validation to control inputs;
  • Adding controls  from Developer using Combo boxes and buttons;
  • Conditional formatting to illustrate changes in data
  • Use of functions and types of functions;
  • Dynamic graphs to plot individual lines;
  • Data tables for sensitivity anlaysis;
  • Using index-scenario for sensitivity analysis;
  • Understanding Net Present Value (NPV and XNPV functions).

 

Second session after lunch:

The participant will be allowed to see the general structure and design of a corporate model. The essential element of corporate modelling is presentation of history alongside the forecast, smooth transition from history to forecast and development of alternative structures for the assumptions. This exercise will work the participant through and/or learning about:

  • How to build a basic integrated corporate model
  • Using cash flow waterfall analysis and cash flow plug to balance the balance sheet in a quick way
  • Corporate model with depreciation
  • Incorporating minimum cash balance
  • Modeling working capital
  • EBITDA and Cash Flow Available for Debt Service (CFADS)
  • Modeling target capital structure

Speaker: Sukarnaen Suwanto

Certified Valuation

Analyst of IACVA.org

Trainier in corporate finance & valuation topics

 

Investment:

2,900 K

discount 10% for 3 persons or more

Bank Permata

Branch Prudential Tower

Bank Account: 701642023

a.n PT BDO Insan Dinamis Indonesia