[Excel Series] CEO Financial Modeling "Comprehensive Financial Analysis and Forecasting"

Excel Series
CEO Financial Modeling
Comprehensive Financial Analysis and Forecasting
Jakarta, May 4-6, 2009

Description
In this course, participants will illustrate concepts related to financial analysis and forecasting.
The financial analysis uses a combination of ratios and industry averages to evaluate the financial performance of the company.
Trend line graphs are also generated, comparing the company's performance with the industry averages.
Finally, the historical information is used to prepare a set of pro forma financial statements using both linear and non-linear functions.

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

Day One
1. Management and Analysis Tools
1.1. What-If Analysis
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. Goal Seek & Solver
1.5. Scenario Manager
1.6. Pivot Tables & Chart Analysis
1.7. Conditional Formatting (Dashboard)
1.8. Sort, Filter & Advance Filter
1.9. Data Analysis Tools
1.9.1. Descriptive Statistics
1.9.2. Correlation & Covariance
1.9.3. Histogram & Moving Average
1.9.4. Regression & Sampling
1.10. Consolidate & Data Validation
1.11. Conditional Sum (SUMIF)
1.12. Financial & Database Functions
1.13. Macro-Building skill
Day Two
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.8.1. Horizontal Analysis
3.8.2. Vertical Analysis
3.9. Competitor & Benchmarking Analysis
4. Financial Distress (Bankruptcy Predictions)
4.1. Altman Z-Score Analysis
4.2. Springate Analysis
4.3. Logit Analysis
4.4. Fulmer H-Factor Analysis
5. Tax Computation Analysis (New Regulation)
5.1. Corporate Withholding Tax
5.2. Personal Income Tax
5.3. Tax Saving
Day Three
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. Corporate Valuation
6.2.1. Working Capital
6.2.2. Free Cash Flow to Firm
6.2.3. Free Cash Flow Valuation
6.2.4. Capital Cash Flow Valuation
6.2.5. Equity Cash Flow Valuation
6.2.6. Discounted Cash Flow Analysis
6.2.7. EBIT, NOPAT & EVA Analysis
7. Evaluation of Capital Projects
7.1. Payback Period (Discounted and Undiscounted)
7.2. Net Present Value (NPV and XNPV)
7.3. Internal Rate of Return (IRR, ARR and XIRR)
7.4. Modified Internal Rate of Return (MIRR)
7.5. Profitability Index (PI)
8. Budget 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)
9. Financial Forecasting
9.1. Pro Forma Sampling
9.2. Pro Forma Linier
9.3. Scenario & Sensitivity Analysis
9.4. Comprehensive Budget Analysis
9.4.1. Logarithmic Trend
9.4.2. Power Trend
9.4.3. Exponential Trend
9.4.4. Polynomial Trend

Instructor
MUSLIM
Financial Modeling Specialist
Business Process Review Specialist
Chairman and CEO of PT. MY Consulting
Partner of Adi Jimmy Arthawan Accounting Firm
He is a registered accountant by profession as Partner of KAP Adi Jimmy Arthawan and is working as President Director for MY Consulting Indonesia.
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 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
IDR 15.000.000
Send 4 delegates and the 5th comes for FREE

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

Facilities
Hot-Spot Training Room
Start up Business Planning – Text book (softcopy)
Excel Guidelines – Text book (softcopy)
Understanding the Annual Report – Text book (softcopy)
Financial Statement Analysis – Text book (softcopy)
Understanding the Financial Report – Text book (softcopy)
The Effective Executive – Text book (softcopy)
Building Financial Model – Text book (softcopy)
Training Handout and Exercise (softcopy)
Certificate and Consultation
Lunch and Coffee break

Venue
Training Center MYC Academy
Wisma Nugra Santana
12 Floor Suite1216
Jl Jend Sudirman Kav 7-8
Jakarta 10220 INDONESIA

In-house package (special terms)
Pay 5 for 7 participants (minimal)
Pay 9 for 14 participants (maximum)
Venue and schedule as client confirmation
Tailor-made for teams of between 7 and 14 executives

Thanks and regards,

Yuniarti
Events Coordinator
PT MY Consulting
Wisma Nugra Santana
12 Floor Suite1216
Jl Jend Sudirman Kav 7-8
Jakarta 10220 INDONESIA
Ph 62 21 5704791
Fax 62 21 5704918
yunie@myconsulting.us