Day(s)
:
Hour(s)
:
Minute(s)
:
Second(s)

This advanced financial modeling course will teach you how to perform Excel SCENARIO & SENSITIVITY ANALYSIS with a focus on practical applications for professionals working in banking, leasing company, financial planning & analysis (FP&A), and finance functions. The tutorial goes step by step through all the formulas and functions required to perform the analysis in Excel from scratch. This course will also provides participants with the skills needed to perform detailed BUSINESS VALUATION MODELING using three main methods: Comps, Precedents and DCF Analysis. The valuation training provided in this series will be particularly valuable to those who are looking for a detailed and step-by-step explanation of how to value a company based on comparable companies, past M&A transactions and a Discounted Cash Flow Model (DCF). All Excel template in this course is given to participants and can be used as an example in our own work.
OUR FACILITATOR

Timotius Ikin Solihin, ST, MBA, CMA, FRM, CSCP, CTP, FP&A
A well-seasoned Executive with 20 years’ Experience in directing, managing and transforming business. Have a broad range of skill and expertise including 7 years of experience as CFO/COO, 8 years of experience with SEC compliance, 4 years of experience in internal auditing. He got his Master of Business Administration in Finance & Accounting (MBA) from Monash University, Australia. Awarded as one of the Best CFO from SWA magazine in 2013 & 2014.
COURSE DESCRIPTION

Scenario Analysis

Sensitivity Analysis

Business Valuation Modeling

Presentation of Result
Scenario analysis
- Model layout and overview
- Designing the structure for scenarios
- Creating switch for live case
- Testing and analysing the scenarios
Sensitivity Analysis
- Overview of integration methods
- Direct method
- Indirect method
- Setting up and lingking the data table
Business Valuation Modeling
- Valuation multiple
- Comparable company analysis (Comps)
- Precedent M&A Transaction (Precedents)
- Discounted Cash Flow (DCF) Model
Presentation of Results
- Analysis and presentation of results
- Gravity sort overview and linkup
- Tornado chart overview & linkup
- Foodball filed chart
Course Curriculum
Module A : Scenario & Sensitivity Analysis
Unit | Credit Units* |
1 | Introduction |
Scenario analysis vs sensitivity analysis | |
2 | Scenario Analysis |
Why perform scenario analysis | |
Model layout & overview | |
Designing the structure for scenarios | |
Creating switch for live case | |
Using CHOOSE function to build scenarios | |
Testing and analysing the scenarios | |
Preparing for sensitivity analysis | |
3 | Sensitivity Analysis – Model Integration |
Why perform scenario analysis | |
Overview of integration methods | |
Direct method | |
Setting up the data table | |
Linking the data table | |
Indirect method | |
Setting up the data table | |
Linking the data table | |
4 | Sensitivity Analysis – Analyzing & Presenting Result |
Analyzing results | |
Gravity sort overview & linkup | |
Tornado chart overview & linkup | |
Presenting Result | |
5 | Completed Model |
Sensitivity analysis wrap up |
Module B : Business Valuation Modeling
Unit | Credit Units* |
1 | Introduction |
Why perform business valuation | |
Art vs science | |
Overview of corporate valuation methods | |
2 | Equity Value vs Enterprise Value |
Terminology | |
Net debt defined | |
Enterprise value & equity value exercise template | |
Enterprise value and equity value calculations | |
3 | Valuation Multiples |
Introduction to valuation multiples | |
Allocating cash flow by investor type | |
EV/Revenue multiple | |
EV/EBITDA & EV/EBIT multiples | |
Linking the data table | |
EV/Capital Employed and ROCE | |
EV/Free Cash Flow multiple | |
Price-Earning (P/E) ratio | |
Price-Book (P/B) ratio | |
Price-Cash Flow (P/CF) ratio | |
When to use each type of multiple | |
Valuation multiples and ratios summary | |
4 | Comparable Company Analysis (Comps) |
Pros and cons of comparable company analysis | |
Step for performing comps analysis | |
Selecting a comps universe | |
Comparable company analysis exercise template | |
Comps table calculations | |
Valuing a company using comps table | |
5 | Precedent M&A Transaction (Precedents) |
Pros and cons of M&A precedents | |
Steps in performing precedent analysis | |
Selecting M&A transactions | |
Precedent M&A transaction exercise template | |
Precedent transactions calculations | |
Valuing a company using precedent transactions | |
6 | Discounted Cash Flow (DCF) Model |
DCF analysis overview | |
PEST & Porter’s 5 Forces | |
Competitive advantage and lifecycle analysis | |
Assessing management | |
SWOT Analysis | |
Free cash flow to the firm (FCFF) | |
Setting up the structure for DCF model | |
Dates and timeline for the model | |
Calculating free cash flow to the firm | |
Terminal value calculation | |
XNPV calculation | |
XIRR calculation | |
7 | Weighted Average Cost of Capital (WACC) |
Introduction to WACC | |
Factors affecting the cost of equity | |
Capital Asset Pricing Model (CAPM) | |
Beta | |
WACC formula | |
WACC calculation | |
8 | Presentation of Results |
Analysis and presentation of results | |
Valuation model template download | |
Overview of the Football Filed Chart | |
Calculating comps values for the chart | |
Calculating precedents values for the chart | |
Final data for the Football Field | |
Building and formatting the chart | |
9 | Conclusion |
Completed valuation analysis model | |
Recap of learning objectives |






Subcribe to download flyer
Corporate Valuation, Scenario & Sensitivity Analysis in Excel
I consent to receive emails from TRANVORMA about discounts, offers, and company updates
By submitting this form, you agree to our Privacy Policy
SCHEDULE
Venue
Falcon Lounge
Sopo Del Office, Tower B, 10th Fl
Kawasan Mega Kuningan, Jakarta
Date:
Tue & Wed, 26 – 27 November 2019
Time:
09.00-16.00 WIB
REGISTRATION
Registration Dateline : 24 November 2019
INVESTMENT FEE (for 2 days)
Rp. 4.000.000,-/person
Additional discount for Group of 5 persons
Day(s)
:
Hour(s)
:
Minute(s)
:
Second(s)
OUR GALLERY






COURSE VENUE


Falcon Lounge, Sopo Del Office, Tower B, 10th F Kawasan Mega Kuningan, Jakarta
Address:
Falcon Lounge
Sopo Del Office, Tower B, 10th Fl Kawasan Mega Kuningan, Jakarta – Indonesia
Call Us:
+62815-1330-9460