Spreadsheet Financial Modeling Training – EXCEL SERIES®
CEO Financial Modeling
BUSINESS AND MARKETING ANALYSIS
Jakarta, November 29-30, 2011
Exclusive Training (available for 5 seats only), don't delay, please reserve and secure your place today and book now at 021-5704791!
Description
The training you just opened is different from most others on Excel® that you may have seen because it focuses on a topic that is deeply important to all of us: money. The science of accounting has two main branches, one being addition, and the other being subtraction. We wanted to service a training that would show people how to maximize profit, the result of the two branches Stout cited. Profit, of course, is not revenue. We can’t teach you how to create revenue—that’s more a matter for the heart, not the head—nor would I want to offer you CFA or CPA materials. We did set out to provide the training that any person engaged in any level of business could use as a refresher, from basic financial documents such as general ledgers and income statements, to operational methods such as statistical process control, to procedures that underlie investment decisions such as business case analysis.
Objective
We also wanted to structure the training around the most popular and sophisticated spreadsheet program available, Microsoft Excel®. Therefore, each chapter in Business Analysis with Microsoft Excel®, This training provides information about a different business task or procedure, and discusses how best to apply Excel® in that situation. You will find reference to many Excel® functions and capabilities that you may already use in your business activities on a daily basis. But you may also find discussions of tools that you have never used, or that you might never have considered using in the context of business analysis. After all, no one can be completely familiar with every option in an application such as Excel®. So we all have gaps in our knowledge. The purpose here is to help fill in some of the gaps that may have appeared in your knowledge base since your last course in business, or since you first learned how to use a spreadsheet. Business and Marketing Analysis with Microsoft Excel®, this training makes liberal use of case studies: that is, situations that are typical of decisions or problems that you might face on any given workday. These case studies discuss, first, the problem itself: why it represents a problem and how a solution can contribute to a company’s profitability. Then the case studies demonstrate at least one possible solution that uses Excel® as a tool. The intent is for you to mentally put yourself in the situation described, work through it, and then apply the solution to an actual situation that you face.
Contents at a Glance
Day One
Part I: Financial Statements and Statement Analysis
This section discusses fundamental financial concepts and tools such as income statements, balance sheets, cash flows, and ratio analysis.
Financial Statements and Statement Analysis Outline
1. Working with Income Statements
2. Balance Sheet: Current Assets
3. Working Capital and Cash Flow Analysis
4. Statement Analysis
5. Ratio Analysis
Part II: Financial Planning and Control
This section covers budgeting methods such as pro formats, forecasting trends, and quality control procedures including process measurement and defect analysis.
Financial Planning and Control Outline
1. Budgeting and Planning Cycle
2. Forecasting and Projections
3. Measuring Quality
Day Two
Part III: Investment Decisions
You will find business case analysis and profit planning in the chapters in this section. Strategies for structuring and testing business cases are covered here, as well as ways to quantify the degree of risk involved in entering a new line of business. You will also find in this section a chapter on fixed assets, which normally account for the greatest portion of a company’s capital investment.
Investment Decisions Outline
1. Examining a Business Case: Investment
2. Examining Decision Criteria for Business Case Analysis
3. Creating a Sensitivity Analysis for a Business Case
4. Planning Profits
5. Fixed Assets
Day Three
Part IV: Sales and Marketing Outline
Sales and marketing analysis, costing and pricing, and margin analysis are covered here. Since the publication of the original edition of this book, many businesses have placed their financial and operational records in true relational databases. Therefore this edition includes a chapter that explains the most effective ways to import data into Excel directly from databases and from Web sites. There is also a glossary that briefly defines important terms.
Sales and Marketing Outline
1. Revenue Recognition and Income Determination
2. Importing Business Data into Excel
3. Analyzing Contributions and Margins
4. Pricing and Costing
5. Dashboard and reporting
Instructor
MUSLIM
· Financial Modeling Specialist
· Business Process Review Specialist
· PROPHIX and ACCPAC Consultants
· Chairman and CEO of PT. MY Consulting
· Senior partner of Rama Wendra (Parker Randall International)
He is a registered accountant 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 / Participant
Send 4 delegates and the 5th comes for FREE
Methodology
Lecturers
Case study and Exercises
1 Participant to a computer
1 Participant gets all material in flash-disk
Practical Computer Hands on Applications
Bring your own laptop and have all your financial modeling
BOOK MATERIAL and benefit
Business Analysis with Microsoft Excel
Marketing Analysis with Microsoft Excel
Excel Pivot Tables and Charts
Excel Dashboards and Reports
Excel Formulas and Functions
Excel Tips and Tricks
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)
Special Investment Package IDR 70.000.000 for 11 participants
Additional IDR 8.000.000 only per participant
Venue and schedule held by Client as Instructor’s confirmation
Thanks and regards,
Didie
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
didie@myconsulting.co.id
RECENT ATTENDEES INCLUDE ON OUR TRAINING
· 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 Inter Sarana
· Kraft Foods Indonesia
· Semen Gresik (Persero) Tbk
· 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
· Meratus Group
· Bio Farma (Persero)
· OCBC Bank
· Windsor University
· Inti College Indonesia
· Metrodata Electronics Tbk
· Kaltim Pasifik Amoniak
. Tripatra Enginers and Contractors
· Bank BRI Tbk
· Roche Indonesia
· FUCHS Indonesia
· Bank Permata Tbk
· Mega Life
· Tunas Inti Abadi
· Salim Group
OUR SERVICES
SPREADSHEET MODELING SERVICES
PT MY Consulting (MYC) is the first business to focus exclusively on the provision of best practice spreadsheet modeling standards, products and services to the market for Microsoft Excel®.
Excel® is a powerful business tool, utilized by organizations globally to make significant financial decisions. Until now, minimal emphasis has been placed on developing a "Best Practice Approach" to ensure the efficient use of this significant business tool. Our people have extensive experience at the forefront of the spreadsheet modeling sector, having worked closely with multi-billion dollar companies, banks, rating agencies, credit wrappers, equity investors and many other organizations across a wide range of industry sectors.
We have particular expertise and experience in relation to the following types of models:
Business Planning (Budget)
Business Planning (Forecasts)
Pricing (Services / Products)
Financial Statements
Operational Analysis
Sensitivity & Scenario Analysis
Calculators (Services / Products)
Investment Evaluation
Optimization Modeling
Link to existing reporting systems
Corporate Valuation
Acquisition / Divestment
Transaction (Public / Private)
Bank / Debt Analysis
Investor / Equity Analysis
Rating Agency Analysis
Cost of Capital Analysis
Hedging & Financial Instruments
Corporate Ratio Analysis
Capital Structure Analysis
PROPHIX® Performance Management Software
PT MY Consulting is the PROPHIX® Software Authorized Partner for Indonesia Region
PROPHIX® Software develops Performance Management Software that is used by companies for budgeting, financial reporting, financial consolidation and forecasting. Software and Installation Services is USD 140.000 (full enterprise package for 10 users)
Executives and management in mid-sized businesses are increasingly feeling pressure to access, review, analyze and act upon events and information in order to become more agile as they work to meet day-to-day operations and financial performance goals.
PROPHIX is pleased to offer you this FREE report from Aberdeen Group that reveals the strategies, tactics and technology investments that Best-in-Class mid-sized companies are taking, in comparison to small and large organizations, to improve performance management capabilities.
Three Compelling Facts from the Research, Providing Actionable Benefits for Readers:
Best-in-Class companies achieved a forecast-to-plan ratio of 89% in the most recent fiscal period
Best-in-Class companies display a current customer satisfaction rate of 93%
Best-in-Class companies improved revenue performance by 35% in the last year
This "Performance Management in the Midmarket" report by Aberdeen Group is brought to you by PROPHIX. Watch the 10-minute PROPHIX Autodemo to see a complete end-to-end Performance Management solution for budgeting, forecasting, reporting, consolidation and personnel planning in action.
Learn more at PROPHIX.com.
PROPHIX.com Solutions Online Demo Contact Sales
COSO Enterprise Risk Management (CERM)
INHOUSE PROGRAMMES (Special Packages)
The 2-day Workshop by investment IDR 45.000.000 only (exclude VAT) max for 25 attendances
____________________________________________________
Note:
You are currently subscribed to our listing as a valued contact or customer of our company you are receiving this email with information that we believe is relevant to you. If however, you do not wish to receive future messages please reply to this message with the word UNSUBSCRIBE in the subject line, and we will take you off of our list as quickly as possible.
Monday, November 14, 2011
CEO Financial Modeling "Corporate Finance and Forecasting Analysis" Jakarta, November 22-24, 2011 (5 seats only)
Spreadsheet Financial Modeling Training - Excel Series
CEO Financial Modeling
Corporate Finance and Forecasting Analysis
Jakarta, November 22-24, 2011
Exclusive Training (available for 5 seats only), don't delay, please reserve and secure your place today and book now at 021-5704791!
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.
Objective
After completing this course, the participants will:
1. Understanding Financial Analysis Using Financial Performance Metrics and Interpretation
2. Understanding the CEO 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 challenges
DETAIL OUTLINE
Day One
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. 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. Consolidate & Data Validation
1.9. Conditional Sum (SUMIF)
1.10. Financial & Database Functions
1.11. Macro-VBA 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
4.5. The Full Beneish’s Model (Earning manipulation Detection)
5. Tax Computation Analysis (New Regulations)
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. Economic Value Added (EVA) Analysis
6.3. Merger and Acquisition Valuation
6.3.1. Merger and Acquisition (M&A)
6.3.2. Business Appraisal (Share Valuation)
6.3.3. Leveraged Buyout (LBO)
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
Instructor
MUSLIM
· Financial Modeling Specialist
· Prophix & ACCPAC Consultants
· Business Process Review Specialist
· Chairman and CEO of PT. MY Consulting
· Senior Partner of KAP Rama Wendra (Parker Randall International)
He is a registered accountant 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/Participant
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)
Special Investment Package IDR 70.000.000 for 11 participants
Additional IDR 8.000.000 only per participant
Venue and schedule held by Client as Instructor’s confirmation
Thanks and regards,
Didie Sulistiawan
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
didie@myconsulting.co.id
RECENT ATTENDEES INCLUDE ON OUR TRAINING
· 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 Inter Sarana
· Kraft Foods Indonesia
· Semen Gresik (Persero) Tbk
· 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
· Meratus Group
· Bio Farma (Persero)
· OCBC Bank
· Windsor University
· Inti College Indonesia
· Metrodata Electronics Tbk
· Kaltim Pasifik Amoniak
. Tripatra Enginers and Contractors
· Bank BRI Tbk
· Roche Indonesia
· FUCHS Indonesia
· Bank Permata Tbk
· Mega Life
· Tunas Inti Abadi
· Salim Group
OUR SERVICES
SPREADSHEET MODELING SERVICES
PT MY Consulting (MYC) is the first business to focus exclusively on the provision of best practice spreadsheet modeling standards, products and services to the market for Microsoft Excel®.
Excel® is a powerful business tool, utilized by organizations globally to make significant financial decisions. Until now, minimal emphasis has been placed on developing a "Best Practice Approach" to ensure the efficient use of this significant business tool. Our people have extensive experience at the forefront of the spreadsheet modeling sector, having worked closely with multi-billion dollar companies, banks, rating agencies, credit wrappers, equity investors and many other organizations across a wide range of industry sectors.
We have particular expertise and experience in relation to the following types of models:
Business Planning (Budget)
Business Planning (Forecasts)
Pricing (Services / Products)
Financial Statements
Operational Analysis
Sensitivity & Scenario Analysis
Calculators (Services / Products)
Investment Evaluation
Optimization Modeling
Link to existing reporting systems
Corporate Valuation
Acquisition / Divestment
Transaction (Public / Private)
Bank / Debt Analysis
Investor / Equity Analysis
Rating Agency Analysis
Cost of Capital Analysis
Hedging & Financial Instruments
Corporate Ratio Analysis
Capital Structure Analysis
PROPHIX® Performance Management Software
PT MY Consulting is the PROPHIX® Software Authorized Partner for Indonesia Region
PROPHIX® Software develops Performance Management Software that is used by companies for budgeting, financial reporting, financial consolidation and forecasting. Software and Installation Services is USD 140.000 (full enterprise package for 10 users)
Executives and management in mid-sized businesses are increasingly feeling pressure to access, review, analyze and act upon events and information in order to become more agile as they work to meet day-to-day operations and financial performance goals.
PROPHIX is pleased to offer you this FREE report from Aberdeen Group that reveals the strategies, tactics and technology investments that Best-in-Class mid-sized companies are taking, in comparison to small and large organizations, to improve performance management capabilities.
Three Compelling Facts from the Research, Providing Actionable Benefits for Readers:
Best-in-Class companies achieved a forecast-to-plan ratio of 89% in the most recent fiscal period
Best-in-Class companies display a current customer satisfaction rate of 93%
Best-in-Class companies improved revenue performance by 35% in the last year
This "Performance Management in the Midmarket" report by Aberdeen Group is brought to you by PROPHIX. Watch the 10-minute PROPHIX Autodemo to see a complete end-to-end Performance Management solution for budgeting, forecasting, reporting, consolidation and personnel planning in action.
Learn more at PROPHIX.com.
PROPHIX.com Solutions Online Demo Contact Sales
COSO Enterprise Risk Management (CERM)
INHOUSE PROGRAMMES (Special Packages)
The 2-day Workshop by investment IDR 45.000.000 only (exclude VAT) max for 25 attendances
____________________________________________________
Note:
You are currently subscribed to our listing as a valued contact or customer of our company you are receiving this email with information that we believe is relevant to you. If however, you do not wish to receive future messages please reply to this message with the word UNSUBSCRIBE in the subject line, and we will take you off of our list as quickly as possible.
CEO Financial Modeling
Corporate Finance and Forecasting Analysis
Jakarta, November 22-24, 2011
Exclusive Training (available for 5 seats only), don't delay, please reserve and secure your place today and book now at 021-5704791!
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.
Objective
After completing this course, the participants will:
1. Understanding Financial Analysis Using Financial Performance Metrics and Interpretation
2. Understanding the CEO 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 challenges
DETAIL OUTLINE
Day One
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. 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. Consolidate & Data Validation
1.9. Conditional Sum (SUMIF)
1.10. Financial & Database Functions
1.11. Macro-VBA 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
4.5. The Full Beneish’s Model (Earning manipulation Detection)
5. Tax Computation Analysis (New Regulations)
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. Economic Value Added (EVA) Analysis
6.3. Merger and Acquisition Valuation
6.3.1. Merger and Acquisition (M&A)
6.3.2. Business Appraisal (Share Valuation)
6.3.3. Leveraged Buyout (LBO)
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
Instructor
MUSLIM
· Financial Modeling Specialist
· Prophix & ACCPAC Consultants
· Business Process Review Specialist
· Chairman and CEO of PT. MY Consulting
· Senior Partner of KAP Rama Wendra (Parker Randall International)
He is a registered accountant 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/Participant
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)
Special Investment Package IDR 70.000.000 for 11 participants
Additional IDR 8.000.000 only per participant
Venue and schedule held by Client as Instructor’s confirmation
Thanks and regards,
Didie Sulistiawan
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
didie@myconsulting.co.id
RECENT ATTENDEES INCLUDE ON OUR TRAINING
· 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 Inter Sarana
· Kraft Foods Indonesia
· Semen Gresik (Persero) Tbk
· 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
· Meratus Group
· Bio Farma (Persero)
· OCBC Bank
· Windsor University
· Inti College Indonesia
· Metrodata Electronics Tbk
· Kaltim Pasifik Amoniak
. Tripatra Enginers and Contractors
· Bank BRI Tbk
· Roche Indonesia
· FUCHS Indonesia
· Bank Permata Tbk
· Mega Life
· Tunas Inti Abadi
· Salim Group
OUR SERVICES
SPREADSHEET MODELING SERVICES
PT MY Consulting (MYC) is the first business to focus exclusively on the provision of best practice spreadsheet modeling standards, products and services to the market for Microsoft Excel®.
Excel® is a powerful business tool, utilized by organizations globally to make significant financial decisions. Until now, minimal emphasis has been placed on developing a "Best Practice Approach" to ensure the efficient use of this significant business tool. Our people have extensive experience at the forefront of the spreadsheet modeling sector, having worked closely with multi-billion dollar companies, banks, rating agencies, credit wrappers, equity investors and many other organizations across a wide range of industry sectors.
We have particular expertise and experience in relation to the following types of models:
Business Planning (Budget)
Business Planning (Forecasts)
Pricing (Services / Products)
Financial Statements
Operational Analysis
Sensitivity & Scenario Analysis
Calculators (Services / Products)
Investment Evaluation
Optimization Modeling
Link to existing reporting systems
Corporate Valuation
Acquisition / Divestment
Transaction (Public / Private)
Bank / Debt Analysis
Investor / Equity Analysis
Rating Agency Analysis
Cost of Capital Analysis
Hedging & Financial Instruments
Corporate Ratio Analysis
Capital Structure Analysis
PROPHIX® Performance Management Software
PT MY Consulting is the PROPHIX® Software Authorized Partner for Indonesia Region
PROPHIX® Software develops Performance Management Software that is used by companies for budgeting, financial reporting, financial consolidation and forecasting. Software and Installation Services is USD 140.000 (full enterprise package for 10 users)
Executives and management in mid-sized businesses are increasingly feeling pressure to access, review, analyze and act upon events and information in order to become more agile as they work to meet day-to-day operations and financial performance goals.
PROPHIX is pleased to offer you this FREE report from Aberdeen Group that reveals the strategies, tactics and technology investments that Best-in-Class mid-sized companies are taking, in comparison to small and large organizations, to improve performance management capabilities.
Three Compelling Facts from the Research, Providing Actionable Benefits for Readers:
Best-in-Class companies achieved a forecast-to-plan ratio of 89% in the most recent fiscal period
Best-in-Class companies display a current customer satisfaction rate of 93%
Best-in-Class companies improved revenue performance by 35% in the last year
This "Performance Management in the Midmarket" report by Aberdeen Group is brought to you by PROPHIX. Watch the 10-minute PROPHIX Autodemo to see a complete end-to-end Performance Management solution for budgeting, forecasting, reporting, consolidation and personnel planning in action.
Learn more at PROPHIX.com.
PROPHIX.com Solutions Online Demo Contact Sales
COSO Enterprise Risk Management (CERM)
INHOUSE PROGRAMMES (Special Packages)
The 2-day Workshop by investment IDR 45.000.000 only (exclude VAT) max for 25 attendances
____________________________________________________
Note:
You are currently subscribed to our listing as a valued contact or customer of our company you are receiving this email with information that we believe is relevant to you. If however, you do not wish to receive future messages please reply to this message with the word UNSUBSCRIBE in the subject line, and we will take you off of our list as quickly as possible.
Subscribe to:
Posts (Atom)