CORPORATE VALUATION, SCENARIO & SENSITIVITY ANALYSIS IN EXCEL

Jakarta, 27 –  28 June 2019

 

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, CTP, CSCP, 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:

Thu & Fri, 27th – 28th June 2019

Time:

09.00-16.00 WIB

REGISTRATION  

Registration Date : 21st May – 24th June 2019

INVESTMENT FEE (for 2 days)

Normal Fee: Rp. 4.000.000,-/person

Early Bird: Rp. 3.500.000,-/person (by 14th June 2019)  

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

Sopo Del

For further info, please contact:
EMILIA
0815 1330 9460