CEO Financial Modeling
The 3-day workshop (BATCH #39)
Corporate Finance &
Budgeting/Forecasting Analysis (interactive
training)
“How to understand your
past, current and future company performance by one click in one sheets”
Exclusive class IDR 20
Million/participant
LIMITED SEAT just for 5
participants
Jakarta,
June 14-16, 2016 (conducted
in Bahasa or English)
Exclusive
Training, please reserve and secure your seat and book now at 021-5704791
Description
This 3-day seminar brings together
important areas of corporate financial management, planning and control,
corporate performance analysis, planning and controlling budgets. It will help
business professionals for preparation more effectively for the future, using
the financial techniques of planning and control, developing performance from
the use of the tools of financial analysis, link planning & budgeting with
costing and performance measurement, and be a master the skills of budgetary
and cost control.
When
explore and exam any financial opportunity the ability to perform accurate and
realistic financial analysis is imperative. In today's ever-changing business
environment the capability to write simple spreadsheets is not enough. You have
to be able to apply financial theory and produce accurate tools for analysis. A
well structured financial model can improve the reliability and quality of
decision-making. Designed for professionals involved in financial and credit
analysis who would like to effectively utilize the powerful features of Excel
2016, this course will explore the use of Excel as an advanced analysis tool,
as well as selected features that help prepare accurate reports and work
papers.
OBJECTIVE
After
completing this course, the participants will:
1.
Understanding
Financial Analysis Using Financial Performance Metrics and Interpretation
2.
Understanding
the CEO/C-Level Parameter Analysis Model and Composition
3.
Why
return on equity is one of the key financial ratios used for assessing a firm’s
performance, and how it can be used to provide information about three areas of
a firm’s operations provide operations
4.
Why
outsiders and insiders are concerned with a company’s ratios related to
leverage, efficiency, productivity, liquidity and value
5.
How
to calculate, interpret, and evaluate the key ratios related to leverage,
efficiency, productivity, liquidity, and value to value.
6.
Why
financial forecasts provide critical information for both management and
external parties management.
7.
How
to prepare financial forecasts by using the percentage of sales approach
8.
How
external financing requirements are related to sales growth, profitability,
dividend payouts, and sustainable growth rates.
BENEFIT
After
completing this course, the participants will gain this practical training:
1.
Database
management and analysis in financial modeling in EXCEL 2016
2.
Professional
financial template model
3.
Get
the best structure to get tips and tricks that could save you from working all
night
4.
Solve
and take it the best solution in the financial modeling case
5.
Expect
highly personalized, expert coaching to support you answer your financial model
DETAIL
SCOPE OF TRAINING
DAY ONE
(1)
1.
Management
and Analysis Tools
1.1. What-If Analysis
1.1.1.
Goal
Seek & Solver add-in
1.1.2.
Scenario
Manager
1.1.3.
Data
Table (0ne & Two Way)
1.2. Lookup & Reference
1.3. Formula Auditing
1.3.1.
Trace
Precedents & Dependents
1.3.2.
Show
Formula
1.3.3.
Error
Checking & Trace Error
1.3.4.
Evaluate
Formula
1.4. Pivot Tables & Chart Analysis
1.5. Conditional Formatting (Dashboard)
1.6. Sort, Filter & Advance Filter
1.7. Consolidate & Data Validation
DAY TWO
(2)
2.
The
Financial Statement Concepts
2.1. Balance Sheet
2.2. Income Statement
2.3. Shareholders’ Equity Statement
2.4. Cash Flow Statement
3.
Financial
Performance Metrics
3.1. Liquidity
3.2. Activity
3.3. Leverage
3.4. Profitability
3.5. Market
3.6. Growth
3.7. DuPont Ratio Analysis
3.8. Common Size Analysis
3.9. Competitor & Benchmarking Analysis
4.
Financial
Distress (Bankruptcy Predictions)
4.1. Altman Z-Score Analysis
4.2. Springate Analysis
5.
Tax
Computation Analysis (New Regulations)
5.1. Corporate Withholding Tax
5.2. Personal Income Tax
DAY THREE
(3)
6.
Capital
Structure Evaluating
6.1. Models of Capital Costing
6.1.1.
Weighted
Average Cost of Capital (WACC)
6.1.2.
Capital
Asset Pricing Model (CAPM)
6.1.3.
Risk
Adjusted Discount Rate (RADR)
6.2. Merger & Acquisition Corporate
Valuation
6.2.1.
Working
Capital
6.2.2.
Free
Cash Flow to Firm
6.2.3.
Capital
Cash Flow Valuation
6.2.4.
Equity
Cash Flow Valuation
6.2.5.
Discounted
Cash Flow Analysis
6.2.6. EVA Analysis
7.
Evaluation
of Capital Projects
7.1. Payback Period Net Present Value
7.2. Modified Internal Rate of Return
7.3. Profitability Index
8.
Budget
Analysis and Evaluation
8.1. Break Even Point Analysis
8.2. Cost Volume Profit Analysis
8.3. Margin of Safety Analysis
8.4. Degree Operating Leverage (DOL)
8.5. Degree Financial Leverage (DFL)
8.6. Degree Combined Leverage (DCL)
METHODOLOGY
Lecturers,
Case study and Exercises
1
Participant to a computer (laptop by self)
Practical
Computer Hands on Applications
Bring
your own laptop and have all your financial modeling
FACILITATOR
MUSLIM, CA
(11.D-21721)
He is a Financial Modeling Specialist
and a PROPHIX Consultants (Performance Management Software for Forecasting
Budgeting and Reporting-Authorized Dealer for Indonesia). He is also a
registered accountant by profession as Senior Partner of KAP Rama-Wendra (Mc
Millan Woods) and is working as President Director for PT MY Consulting
Indonesia, Managing Partner of Tax Consultants AR Muslim (Brevet-C License) and
Executive Director of Indonesia Association Commissioner and Director (INACD)
for Good Corporate Governance. With a very rich and varied work experience
acquired by his employment in several different experiences, He commands the
best knowledge of the theory and use of various computer applications,
especially Microsoft Excel. His experience as a middle level and top-level
manager and director and also as a business owner has provided the perfect
angle of top management thoughts and an easy-learning solution model with which
he has tailored the learning approach.
INVESTMENT
EXCLUSIVE
Class IDR
20.000.000/participant
IN-HOUSE
TRAINING
IDR 75.000.000 (exclude VAT 10% and
OPE)/9 participants
Payment method:
50% at a week before program
50% on the end of the program
CONTACT
PERSON/NUMBER
FOR
RESERVATION/BOOKING
Mr. Tio /
Aswin/ Adhys
Events
Coordinator
PT MY
Consulting
Wisma Nugra
Santana
12 Floor
Suite1216
Jl Jend
Sudirman Kav 7-8
Jakarta 10220
INDONESIA
Ph +6221
5704791
Fax +6221
5704918
info@myconsulting.co.id
