Excel Series

Master Class CEO Financial Modeling   

 

4-day workshop

Financial Performance Analysis,

Business Modeling & Forecasting/Budgeting

 

·       IN-HOUSE PACKAGES IDR 45 Million/5 Participants-schedule and venue held by Client

·       Public class IDR 20 Million/participant will be held on Jakarta, October 2-5, 2012

 

Introduction

A wide-ranging comprehend of the principles of financial analysis is a key competency needed for effective C-level of a business. This 4 day interactive program goes far beyond the typical financial analysis program using spreadsheet financial techniques and financial applications. It uses both the principles of analysis and the power of Excel® to identify the strategic drivers that can dramatically enhance the shareholder value of your organization. Using Excel®, participants will learn how to master the tools and techniques it provides to apply the latest financial analysis techniques, identify with what the numbers are revealing, and be better able to make strategic and tactical decisions and predict the outcome of these decisions.

Using Excel®, participants will develop from the basics of strategic financial planning, to using the tools of finance such as the time value of money and determining key performance indicators in order to manage the drivers of business success.

The course proceeds from basic financial analysis to more advanced techniques for determining the cost of capital, methods of projecting the benefit of capital projects, Also, using Excel®, participants will learn how to evaluate organizations with which participants are planning to do business; determine if they are able to provide strategic strength to your company.

Participants will be provided Excel® templates for use during this session, and when they return to their organizations. The power of Excel enables learning to be taken to a considerably higher level than that which would be possible using only manual methods. They will thus be enriched with the ability to use spreadsheet techniques for both analysis and financial modeling.

 

Objectives

On completion of this module participants will be able to:

• Benchmark corporate performance against peer groups and industry statistics.
• Analyze a company’s annual report identifying key performance indicators in order to understand what the numbers are really saying and make projections of future performance.
• Understand the theory of interest and the time value of money and their applications.
• Use the powerful tools in Excel® such as the Financial and Statistical functions, the Data Analysis toolbox and sensitivity analysis tools such as the Goal Seek command.
• Develop an Economic Value-Added model to see the organization from the shareholders’ perspective.
• Project the benefit of capital investment.
• Analyze the risks and benefits of proposed acquisitions, valuation of target companies, and issues relating to post-acquisition integration.
• Measure management ability to convert the company’s investment in assets into shareholder return.
• Learn how to use Excel® tools such as Solver, Goal Seeker, Scenario, and Spreadsheet Auditor
• Use Pivot Tables to quickly develop reports.
• Analyze time series data and develop relationships using exponential smoothing and regression analysis techniques.
• Use Excel® with more confidence and flexibility, thus saving large amounts of time and enhancing productivity.

 

Training Methodology

Participants are requested to bring their own personal laptop computers to the course with a full installation of Excel® including the complete “Toolbox”. In cases where this is not possible, desktop computers will be provided. The training comprises teaching sessions covering each topic with demonstrations of the applications on each of the topics. Participants then use the templates prepared in order to apply the knowledge gained on each section to short case studies, using Excel®. Additional practice cases are available for participants who may develop the proficiencies more swiftly.

 

Organizational Force

The focus of the course is twofold. Participants will be confronted with the issues in financial management and analysis which are needed in order to be effective financial managers. They will emerge with a thorough understanding of the objectives of profitability and efficiency, essential for companies to succeed in a competitive environment. In addition, the use of Excel® as a tool to assist in resolving issues will greatly enhance their skills in using this powerful software package. Basic modeling techniques will be explored to enable participants to return to the work place and build models appropriate to their company and industry.

 

Personal Force

Each person on the course will develop an improved understanding of financial drivers and the necessity of return on investment as an imperative for the company by which they are employed. They will further enhance their knowledge of the many applications of Excel® and their confidence in using this package.

 

Competencies Emphasized

The course emphasizes dual competencies. It achieves the two objectives of financial analytical ability and competency using Excel®, the structure of the program contains 10 main themes of dual competency development:

• The International Business Environment
• The Financial Reporting Process and the Organizational Planning Cycle
• Analyzing The Annual Report
• Creating Shareholder Value
• The Time Value of Money
• Steps in Building Financial Models
• Evaluating Capital Project Proposals
• Effective Management of Historical Data
• Time Series Analysis
• Evaluating Investment Portfolio’s

 

Who Should Attend?

All financial professionals, financial management, department heads, internal auditors, project professionals, and those responsible for ensuring the effective use and management of corporate resources. Also, sales and marketing professionals, R&D professionals, and anyone who needs to understand the short and long-term financial Force of key decisions. Participants should have a basic understanding of financial statements and may bring their own laptop computer with a full install of Excel®, including the complete “Toolbox.” Access to a desktop PC will be made available to all participants.

Workshop Outline

 

DAY 1

Analyzing the Annual Report

• Ratio Analysis – The heart of Financial Analysis
• Use Excel® templates to calculate and interpret liquidity, leverage and profitability ratios
• Interpret the results of ratio analysis from an accrual accounting perspective
• The inter-relationship between the DuPont Formula and EVA®
• How to use the Altman Z-Score
• Use various investment surveys to benchmark the results of financial analysis

Creating Shareholder Value

• What constitutes “Shareholder Value?”
• Finding the cost of equity
• Determine the Cost of Debt, Preferred Equity and Common Equity
• Calculate Weighted Average Cost of Capital (WACC)
• Develop the EVA© Model
• Force of Acquisitions on WACC

DAY 2

The Time Value of Money

• The Force time has on the value of money.
• Understand the various interest calculations
• Using WACC and ROIC as benchmarks
• Use Excel®, to determine Present Value, Future Value, Net Present Value, Internal Rate of Return, Modified Internal Rate of Return
• Using IRR as a basis for capital project evaluation

Steps in Building Financial Models

• Situations that require models
• Models and Shareholder Value (EVA®)
• Identification of Forecast Validation Criterion
• Determination of Model and Forecast Horizons
• The recognition of risk in forecasts
• The Role of Assumptions in Financial Forecasting

DAY 3

Evaluating Capital Project Proposals

• Identify the various types of capital projects
• Discuss the capital project evaluation process
• Determining the initial and subsequent capital project cash flows
• Development of the “Hurdle Rate” for capital projects
• Discuss the use of “Terminal Value” in evaluating capital projects
• Use Excel® to evaluate capital projects by applying NPV, IRR, and Discounted Payback models

Effective Management of Historical Data Using Excel®

• Understanding the Approaches Used to Build Financial Forecasting Models
• Recognizing the Basic Patterns Inherent in Historical Data
• Using the Exploratory Data Analysis Tools Available in Excel®
• Key Factors in Determining the Proper Time Horizon to Choose for Your Model
• Determining Degrees of Reliability in Model Projections
• Selecting the Degree of Robustness and Sensitivity of the Model
• Understanding and Applying Selected Modeling Techniques

DAY 4

Use of Time Series Analysis

• Development of Time Series Models using histograms, moving averages, exponential smoothing, and regression analysis
• Using Regression as a predictor and estimator
• Mastering the use of Exponential Smoothing as a Data Analysis tool
• Validation of Time Series Analysis
• Appreciate the Meaning and Importance of Sensitivity Analysis
• Developing “What-if” Scenarios in Your Financial or Operational Models
• Using the Excel tools “Scenario and Goal Seek”

Evaluating Investment Portfolio’s

• Principles of risk measurement in individual shares
• Graphing expected return and risk using variance analysis
• Modern portfolio theory using the capital asset pricing model
• Managing a balanced portfolio
• Use Excel® to determine the beta of listed share on a securities market

Instructor

MUSLIM

·      Financial Modeling Specialist

·      PROPHIX Consultants (Performance  Management Software)

·      Sage ACCPAC  (ERP Software)

·      Business Process Review Specialist

·      Chairman and CEO of PT. MY Consulting

·      Partner of Rama-Wendra Accounting Firm (Parker-Randall-International)

He is a registered accountant by profession as Partner of KAP Rama-Wendra and is working as President Director for PT 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.

 

Special in-house package

IDR 45 million / 5 participants

 

Public Class Investment

IDR 20.000.000 / participant

Send more than one getting discount IDR 2.500.000 / participant

 

TRAINING Materials

 

Brian Stanko, ”Understanding Corporate Annual Reports”, A User’s Guide, Wiley

Frank J. Travers, ‘Investment Manager Analysis”, A Comprehensive Guide to Portfolio Selection, Monitoring and Optimization, Wiley

Graham Mott, “Accounting for Non-Accountants”, A Manual for Managers and Students, Kogan page

Gene Siciliano, “Finance for Non-Financial Managers”, A Briefcase Book, McGraw-Hill

John Walkenbach, “Excel 2003 Bible”, A Excel Guidebook, Wiley

Timothy Zapawa, ‘Excel Advanced”,  Report Development, Wiley

V. Rory Jones, “The Executive Guide to Boosting Cash Flow and Shareholders Value”, The Profit Pool Approach, Wiley

Nancy C. Muir, “Teach Yourself”,  Visually Excel 2007, Wiley

Loren Abdulezer, “Excel for Business” , Best Practices, Wiley

Steven M. Bragg,’ Business Rations and Formulas”, A Comprehensive Guide, Wiley

McKinsey & Company, Inc, “Valuation”, Measuring and Managing the value of Companies, Wiley

James R. Hitchner, “Financial Valuation Workbook”, Step-by-step Exercises to Help You Master Financial Valuation, Wiley

Institute of Management and Administration, ”Cost Reduction and Control Best Practices”, The Best Ways for a Financial Manager to Save Money, Wiley

John S. Tjia, “Building Financial Models’, A Guide to Creating and Interpreting Financial Statements, McGraw-Hill

Michael Alexander, “Excel 2007”, Dashboard & Report for Dummies, Wiley

P.H.Collin, “Dictionary of Business”, 4^th Edition, A&C Black

S.M.H. Collin, ’Dictionary for Accounting’, 4^th Edition, A&C Black

 

 

training Facilities

 

Hot-Spot Training Room

Certificate and Consultation

Lunch and 2 Coffee breaks

                                                                                                                                    

TERMS AND CONDITIONS

 

In-House packages

We only provide materials and facilitators training

Schedule and Venue held by Client

 

Contact person

 

Didie/Rizky/Galuh

Events Coordinator Team

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

info@myconsulting.co.id