MY Consulting
The
Center of CEO CompetencyExcel Series-Financial Modeling
The 2-day workshop (limited seat)
The Entrepreneurial Finance
“Finance & Business
Strategies for the Entrepreneur”
Jakarta,
9-10 Sept 2014 & 16-17 Sept 2014
Course
investment
IDR
10.000.000 per delegate
IDR
20.000.000 Special for Group of 3IDR 30.000.000 Special for Group of 5
Description
This 2-day workshop
brings together important areas of the corporate financial management, planning
and control, corporate performance analysis, planning and controlling budgets.
It will help the entrepreneurs for preparation and execution 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. It must be for CEO competency
and this is the right answer.
OBJECTIVE
After completing this course, the
participants will:
1. Understanding
Financial Analysis Using Financial Performance Metrics, Interpretation and
problem solving in dashboard models.
2. Understanding the CEO
(Entrepreneur) 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
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. Database Management
and Analysis Tools
1.1. What-If Analysis1.1.1. Goal Seek & Solver add-in
1.1.2. Scenario Manager
1.1.3. Data Table (0ne & Two Way)
1.2. Lookup & Reference and Developer Function
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. Advance Pivot Tables & Chart Analysis
1.5. Conditional Formatting (Dashboard)
1.5.1. Value
1.5.2. Formula
1.6. Sort, Filter & Advance Filter
1.7. Data Analysis Tools
1.7.1. Descriptive Statistics
1.7.2. Correlation & Covariance
1.7.3. Histogram & Moving Average
1.7.4. Regression & Sampling
1.8. Developer, Consolidate & Data Validation
1.8.1. Combo and Check box
1.8.2. Scroll and dropdown list
1.8.3. Consolidate, list and Validate
1.9. Conditional Sum (SUMIF) and Macro/VBA
2. The Financial
Statement Concepts (IFRS/ETAP)
2.1. Financial Position
Statement 2.2. Comprehensive Income Statement
2.3. Shareholders’ Equity Statement
2.4.Cash Flow Statement
DAY
TWO (2)
3. Financial Performance
Metrics
3.1. DuPont Ratio &
Sustainable Growth Analysis3.2. Common Size & Annual Report Analysis
3.3. Altman Z-Score Analysis
4. Capital Structure
Evaluating
4.1 Weighted Average Cost
of Capital (WACC) 4.2 Capital Asset Pricing Model (CAPM)
4.3 Working Capital & Free Cash Flow
4.4 Discounted Cash Flow (DCF)
4.5 Economic Value Added (EVA)
5. Investment Analysis
5.1. Estimating and
Calculating the relevant Cash Flows5.2. Optimal Capital Budgeting
5.2.1. Without Capital Rationing
5.2.2. Under Capital Rationing
5.3. Making the Decision
5.3.1. Payback Period & Net Present Value
5.3.2. Modified Internal Rate of Return & IRR
5.3.3. Profitability Index
METHODOLOGY
Lecturers, Case study and Exercises1 Participant to a computer (laptop by self)
Practical Computer Hands on Applications
Bring your own laptop and have all your financial modeling
FACILITATOR
MUSLIM
SE AK (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 (McMillan Woods), he is working as President Director for PT MY Consulting Indonesia and The Executive Director of INACD (Indonesian National Association of Commissaries and Directors). 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, QlikView and SAP-Xcelcius. 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
IN-HOUSE TRAINING
IDR
50.000.000 (fifty million rupiah)/batch (max 9 pax)
Payment
method:
50% at
a week before program
50% on
the end of the program
CONTACT
PERSON/NUMBER
FOR
RESERVATION/BOOKING
Mr. Nanda/Aswin -
Ms. Deintie
Events
Coordinator
VENUE
Financial
Club Jakarta
Training
Center Room (attendance less than 6 pax)
PT MY
Consulting
Wisma Nugra
Santana
12 Floor
Suite1216
Jl Jend
Sudirman Kav 7-8
Jakarta 10220
INDONESIA
Ph +6221
5704791
Flx +6221
70708439
Fax +6221
5704918
