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
Monday, April 20, 2009
[Excel Series] CEO Financial Modeling "Capital Market and Valuation Analysis"
Excel Series
CEO Financial Modeling
Capital Market and Valuation Analysis
Jakarta, May 11-13, 2009
Introduction:
This program consists of the specific security selection criteria that is to be used for stock analysis
to meet the CEO's Investment Objectives and Understanding Capital Market.
Objective:
Understanding the characteristics of Capital Market industry
Understanding of Capital Market’s Instruments : stock, bond, warrant, rights, mutual fund, syariah instruments
Capital Market’s Participants and institutions
Going Public Procedures
Initial Public Offering
Listing Procedure in Stock Exchange
Trading Mechanism in secondary market
Detailed Outline
Day One
Characteristics of capital market industry
Development of capital market in Indonesia
Supporting institutions and professions
Financing from capital market
Going Public procedures
Initial Public Offering and Warrant
Case Study of IPO
Ownership Structure: Authorized Capital, Capitalized Stock, Portepel Stock
Public Offering of Bonds
Case Study of Bonds Offering
Syariah Bonds: Mudharabah and Ijarah
Listing Mechanism in Stock Exchange
Function of Stock Exchange : Listing, Membership, Trading & Surveillance
Trading Mechanism in Stock Exchange
Order Procedure
Settlement
Function of Clearing and Guaranty institution
Function of Central Custody and Settlement
Cost of transaction
Day Two
Market Capitalization and Jakarta Composite Index
Calculation of Composite Index
Stock Suspension and Delisting
Regulation of Stock Suspension and Delisting
General Shareholders Annual Meeting and Extra ordinary General Shareholders Meeting
Financial Report
Understanding Financial Report
Fundamental Analysis
Financial Ratios : Debt to Equtiy Ratio, Profit Margin Ratio, Return on Asset (ROA), Return on Equity (ROE)
Market Ratios : Earning per share (EPS), P/E Ratio, Book Value, Price to Book Value
Technical Analysis
Day Three
Cash and Stock Dividend
Bonus Stock
Stock Split and Reverse Split
Right Issue
Stock Buy Back
Stock Acquisition and Tender Offer
Mutual Fund Industry
Understanding Mutual Fund
Investment Manager and Custodian Bank
Mutual Fund Mechanism
Calculating Net Asset Value
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.
Hendy M. Fakhruddin
He is a Market Financial Consultant, He is more than 10 years working experience in capital market (IDX). His experience instructor for financial and capital market workshop and a writer for several books in capital market
Investment
IDR 10.000.000
Send 4 delegates and the 5th comes for FREE
Pay 5 for 7 participants
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
Fundamental of The Stock Market – Text book (softcopy)
Excel Guidelines – Text book (softcopy)
Understanding the Annual Report – Text book (softcopy)
Dictionary of Business – Text book (softcopy)
Financial Valuation Workbook – Text book (softcopy)
Guide to Investors – 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
Pay 9 for 14 participants
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
CEO Financial Modeling
Capital Market and Valuation Analysis
Jakarta, May 11-13, 2009
Introduction:
This program consists of the specific security selection criteria that is to be used for stock analysis
to meet the CEO's Investment Objectives and Understanding Capital Market.
Objective:
Understanding the characteristics of Capital Market industry
Understanding of Capital Market’s Instruments : stock, bond, warrant, rights, mutual fund, syariah instruments
Capital Market’s Participants and institutions
Going Public Procedures
Initial Public Offering
Listing Procedure in Stock Exchange
Trading Mechanism in secondary market
Detailed Outline
Day One
Characteristics of capital market industry
Development of capital market in Indonesia
Supporting institutions and professions
Financing from capital market
Going Public procedures
Initial Public Offering and Warrant
Case Study of IPO
Ownership Structure: Authorized Capital, Capitalized Stock, Portepel Stock
Public Offering of Bonds
Case Study of Bonds Offering
Syariah Bonds: Mudharabah and Ijarah
Listing Mechanism in Stock Exchange
Function of Stock Exchange : Listing, Membership, Trading & Surveillance
Trading Mechanism in Stock Exchange
Order Procedure
Settlement
Function of Clearing and Guaranty institution
Function of Central Custody and Settlement
Cost of transaction
Day Two
Market Capitalization and Jakarta Composite Index
Calculation of Composite Index
Stock Suspension and Delisting
Regulation of Stock Suspension and Delisting
General Shareholders Annual Meeting and Extra ordinary General Shareholders Meeting
Financial Report
Understanding Financial Report
Fundamental Analysis
Financial Ratios : Debt to Equtiy Ratio, Profit Margin Ratio, Return on Asset (ROA), Return on Equity (ROE)
Market Ratios : Earning per share (EPS), P/E Ratio, Book Value, Price to Book Value
Technical Analysis
Day Three
Cash and Stock Dividend
Bonus Stock
Stock Split and Reverse Split
Right Issue
Stock Buy Back
Stock Acquisition and Tender Offer
Mutual Fund Industry
Understanding Mutual Fund
Investment Manager and Custodian Bank
Mutual Fund Mechanism
Calculating Net Asset Value
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.
Hendy M. Fakhruddin
He is a Market Financial Consultant, He is more than 10 years working experience in capital market (IDX). His experience instructor for financial and capital market workshop and a writer for several books in capital market
Investment
IDR 10.000.000
Send 4 delegates and the 5th comes for FREE
Pay 5 for 7 participants
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
Fundamental of The Stock Market – Text book (softcopy)
Excel Guidelines – Text book (softcopy)
Understanding the Annual Report – Text book (softcopy)
Dictionary of Business – Text book (softcopy)
Financial Valuation Workbook – Text book (softcopy)
Guide to Investors – 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
Pay 9 for 14 participants
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
[Excel Series] Business Plan Analysis "Corporate Financing and Evaluation"
Excel Series
Corporate Financing and Evaluation
Business Plan Analysis
Jakarta, April 29-30, 2009
Description
In this course, participants will learn to create Financial Modeling for Business Plan Analysis
They will also forecast values with trend lines and create scenarios.
Objectives
After completing this course, the participants will:
A. Identify different decisions at project cycle from pre-feasibility level, investment stage and operational phase.
B. Determine the information required such as marketing, technical, financial, organization and manpower, and social environment.
C. Understand Procedures in estimating initial investment, pre-operational costs, and working capital requirements.
D. Understand the criteria in evaluating the viability of the projects
Detailed Outline
1. Basic Elements of a Project Financing
2. SWOT and PEST Analysis
3. Assumption Analysis and Model
4. Optional ways to act to prove profitability of plans
5. Cash-flow-statements per business unit and in total
6. Income statements and Balance sheets Analysis
7. Equity and Cash Flow Analysis
8. The Lambrown Analysis Model
9. Investment Plan Analysis (NPV, XNPV, IRR, MIRR, XIRR, PBP, ARR and PI)
10. Corporate Valuation Methodology
11. Personnel plan and Appraisal Model (salary structure analysis)
12. Tax Computation Analysis (Corporate and Individual Case)
13. Working Capital Works Analysis
14. CAPEX and OPEX Analysis
15. Marketing Plan Analysis
16. Profitability indicators/ratios
17. MOS, DOL, DFL and DCL Analysis
18. Cost Volume Profit Relationships and BEP Analysis
19. ROI-indicators (DuPont and Altman Z-Score Analysis etc.)
20. Discount Factor Valuation and Sensitivity Analysis
21. Competitor and Competitive 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 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 5.000.000 (Five Million)
Send 4 delegates and the 5th comes for FREE
Methodology
Lecturers
Case 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 Manual- McKinsey – Text book (softcopy)
Business Plan - Deloitte – Text book (softcopy)
Excel for Project Manager – Text book (softcopy)
Powerful Proposal – Text book (softcopy)
Excel Guidelines – Text book (softcopy)
Yahoo Investor Presentation (softcopy)
GE and Merrill Lynch Annual Report 2007 (softcopy)
Three Samples of Business Plan (softcopy)
ONGC Company Analysis 2007 (softcopy)
ITC Ltd Financial Analysis 1998-2007 (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 9 for 14 participants
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
Corporate Financing and Evaluation
Business Plan Analysis
Jakarta, April 29-30, 2009
Description
In this course, participants will learn to create Financial Modeling for Business Plan Analysis
They will also forecast values with trend lines and create scenarios.
Objectives
After completing this course, the participants will:
A. Identify different decisions at project cycle from pre-feasibility level, investment stage and operational phase.
B. Determine the information required such as marketing, technical, financial, organization and manpower, and social environment.
C. Understand Procedures in estimating initial investment, pre-operational costs, and working capital requirements.
D. Understand the criteria in evaluating the viability of the projects
Detailed Outline
1. Basic Elements of a Project Financing
2. SWOT and PEST Analysis
3. Assumption Analysis and Model
4. Optional ways to act to prove profitability of plans
5. Cash-flow-statements per business unit and in total
6. Income statements and Balance sheets Analysis
7. Equity and Cash Flow Analysis
8. The Lambrown Analysis Model
9. Investment Plan Analysis (NPV, XNPV, IRR, MIRR, XIRR, PBP, ARR and PI)
10. Corporate Valuation Methodology
11. Personnel plan and Appraisal Model (salary structure analysis)
12. Tax Computation Analysis (Corporate and Individual Case)
13. Working Capital Works Analysis
14. CAPEX and OPEX Analysis
15. Marketing Plan Analysis
16. Profitability indicators/ratios
17. MOS, DOL, DFL and DCL Analysis
18. Cost Volume Profit Relationships and BEP Analysis
19. ROI-indicators (DuPont and Altman Z-Score Analysis etc.)
20. Discount Factor Valuation and Sensitivity Analysis
21. Competitor and Competitive 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 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 5.000.000 (Five Million)
Send 4 delegates and the 5th comes for FREE
Methodology
Lecturers
Case 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 Manual- McKinsey – Text book (softcopy)
Business Plan - Deloitte – Text book (softcopy)
Excel for Project Manager – Text book (softcopy)
Powerful Proposal – Text book (softcopy)
Excel Guidelines – Text book (softcopy)
Yahoo Investor Presentation (softcopy)
GE and Merrill Lynch Annual Report 2007 (softcopy)
Three Samples of Business Plan (softcopy)
ONGC Company Analysis 2007 (softcopy)
ITC Ltd Financial Analysis 1998-2007 (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 9 for 14 participants
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
Subscribe to:
Posts (Atom)