Corporate Valuation | Institute of Professionals

CORPORATE VALUATION MODELING

CORPORATE VALUATION, FINANCIAL MODELING,

SCENARIO & SENSITIVITY ANALYSIS IN EXCEL

Jakarta, 26 – 27 Nov 2019

Day(s)

:

Hour(s)

:

Minute(s)

:

Second(s)

SIGN UP NOW

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