This site uses cookies to provide you with a more responsive and personalised service. By using this site you agree to our use of cookies. Please read our PRIVACY POLICY for more information on the cookies we use and how to delete or block them.
  • Building Basic Financial Modelling and 5-year Financial Statements Forecast

Building Basic Financial Modelling and 5-year Financial Statements Forecast

Date: 16 April 2019
YELLO Hotel Manggarai
Jl. Minangkabau No.9, RT.6/RW.8, Ps. Manggis, Kecamatan Setiabudi, Jakarta Selatan
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

Trainier in corporate finance & valuation topics



2,900 K

discount 10% for 3 persons or more


Bank Permata

Branch Prudential Tower

Bank Account: 701642031

a.n PT BDO Insan Dinamis Indonesia


Contact Person


0812 – 8760 – 8686

[email protected]