CEO Financial Modeling
Corporate Dashboard Analysis
Jakarta, May 26-27, 2009
Description
In this course, participants will learn to create and design Financial Modeling for CEO in Corporate Finance Dashboard Analysis Model and Financial Statement Analysis Package. The participant will receive more than 30 model financial analysis.
Objectives
After completing this course, the participants will:
A. Understanding the Concept of the financial statement and their purpose
B. Understanding the purpose of the cash budget and how it differs from an income statement
C. Understanding the financial statement analysis tools and how to read and use them
D. Understanding the trend function for forecasting and the method is used to develop pro-forma
E. Understanding the Break-Even and Leverage Analysis
F. Understanding the concept of Time Value of Money and how to calculate them
G. Understanding the concept of The Valuation and rates of Return and how to read and use them
H. Understanding the Cost of Capital and the concept of Capital budgeting and how to calculate them
Detailed Outline
1. The spreadsheet concept and how to work with tools
2. The firm’s four basic financial statement Concepts
3. The Cash budget analysis model and template
4. The Corporate Financial Measurement and Valuation Model
5. Altman Z-Score Reporting Analysis (Bankruptcy Probability)
6. DuPont Reporting Analysis and SWOT Analysis
7. The Full Beneish Model (Earning manipulation Detection)
8. Belkaoui Take over analysis model
9. Bernstein and Maksy Cash prediction analysis model
10. Ratio and trend analysis and reporting
11. Investment Plan Analysis (IRR, PI, MIIR, XIRR, NPV and XNPV)
12. Tax Computation (Corporate and Personal) Analysis
13. Working Capital Works Analysis
14. Competitor and Competitive Analysis
15. Cost Volume Profit Relationships and BEP Analysis
16. MOS, DFL, DCL and DOL Analysis
17. Capital Asset Pricing Model (CAPM) and WACC
18. Risk Adjusted Discount rate (RADR)
19. Discount Factor Analysis (DCF)
20. Merger and LBO Valuation Analysis
21. Sensitivity Analysis
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 MS 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 10.000.000
Send 4 delegates and the 5th comes for FREE
Pay 5 for 7 participants (IDR 50.000.000)
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)
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
PT MY Consulting
Business Center MYC Academy
Wisma Nugra Santana
12 Floor Suite1216
Jl Jend Sudirman Kav 7-8
Jakarta 10220 INDONESIA
In-house package (special terms)
Pay 9 for 14 participants
Venue and schedule as client confirmation
Tailor-made for teams of between 7 and 14 executives
Thanks and regards,
Erwin Zulfikar
Program 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
erwin.zulfikar@myconsulting.co.id
PUBLIC TRAINING SCHEDULE ON MAY 2009
| DATE | GROUP TYPE | TOPICS | |
| 04-06 | Excel Series | CEO Financial Modeling (Comprehensive Financial Analysis and Forecasting) | |
| 07-08 11-13 12-13 | Excel Series Excel Series Excel Series | Database Management and Analysis CEO Financial Modeling (Market and Valuation Analysis) CEO Financial Modeling (Business Model and Statistics) | |
| 14-15 18 | Excel Series Taxation | Business Plan Analysis (Corporate Financing and Evaluation) Tax Audit & Planning (Analysis and Solution) | |
| 19-20 | Excel Series | Finance Analysis for Non Finance Manager | |
| 26-27 26-27 28-29 | Excel Series Excel Series Excel Series | CEO Financial Modeling (Corporate Dashboard Analysis) CEO Financial Modeling (Investing Analysis and Financing Decisions) Annual Report Analysis and Interpretation | |
PUBLIC TRAINING SCHEDULE ON JUNE 2009
| DATE | GROUP TYPE | TOPICS | |
| 02-03 | Excel Series | Business Plan Analysis (Corporate Financing and Evaluation) | |
| 04-05 08-10 09-10 | Excel Series Excel Series Excel Series | Database Management and Analysis CEO Financial Modeling (Market and Valuation Analysis) CEO Financial Modeling (Business Model and Statistics) | |
| 11-12 15 | Excel Series Taxation | Annual Report Analysis and Interpretation Tax e-SPT (Analysis and Solution) | |
| 16-17 | Excel Series | Finance Analysis for Non Finance Manager | |
| 18-19 18-19 22-24 25-26 29-30 | Excel Series Excel Series Excel Series Excel Series Excel Series | CEO Financial Modeling (Corporate dashboard Analysis) CEO Financial Modeling (Investing Analysis and Financing Decisions) CEO Financial Modeling (Comprehensive Financial Analysis and Forecasting) Business Plan Analysis (Corporate Financing and Evaluation) Audit Committee Modeling (Internal Audit Analysis) | |
RECENT ATTENDEES INCLUDE ON OUR TRAINING
2008
· Total Bangun Persada, Tbk
· Grendale Partners
· Charoen Pokphan Indonesia Tbk
· Boehringer Ingelheim Indonesia
· Meta Epsi
· Ernst & Young
· Medco Power Indonesia
· Widya Sapta Colas
· Medco Geothermal Sarulla
· Asuransi Adira Dinamika
· First Media Tbk
· Bekaert Indonesia
· Astellas Pharma Indonesia
· Intiland Development Tbk
· Sandoz Indonesia
· Aero Wisata
· Sefas Pelindotama
· Sorini Agro Asia Tbk
· CIC Indonesia
· Metrodata Electronics Tbk
· Adira Asuransi Dinamika
· Jakarta International Container Terminal
· Hutchison Port Indonesia
· Kaltim Prima Amoniak
· Bank BTPN Tbk
· Indosat Tbk
· Lembaga Penjamin Simpanan
· SUCOFINDO (PERSERO)
· Unican Surya Agung
· Timah (PERSERO) Tbk
· Sierad Produce Tbk
· Lippo Karawaci Tbk
· CNOOC SES Ltd
· PERTAMINA (PERSERO)
· BAHANA (PERSERO)
· Bredero Shaw Indonesia
· Bank of Tokyo Mitsubishi
· Danareksa (PERSERO)
· Janssen Pharmaceutica
· Excelcomindo Pratama Tbk
· Deutsche Verdhana Indonesia
· Rajawali Corpora
· Tripatra Enginers and Contractors
· Ekspres Transportasi Antarbenua
· NetToCyber Indonesia
· Ciputra Corpora
· Trimegah Securities Tbk
· Astratel
· Astra International Tbk
· Express Group
· Kawasan Industri Jababeka Tbk
· IMECO
· Kraft Foods Indonesia
· Semen Gresik (Persero) Tbk
2009
· Cipta Pratama Technocom
· StarEnergy (Kakap)
· Pertamina Energi Hulu (PERSERO)
· Panorama Convexion
· Cisadane Sawit Raya
· Mitra Rajasa Tbk
· Indosat Tbk
· Pakuwon Jati Tbk
· Tanjung RHU Plantation & Products
· IMECO Inter Sarana
· Tiga Pilar Sejahtera Food Tbk
· Arthabuana Margausaha Finance
· Bank BCA
No comments:
Post a Comment