THE MASTER CLASS “FINANCIAL MODELING”

INVESTMENT, PERFORMANCE & VALUATION

ANALYSIS MODELING

DESCRIPTIONThis 2-day workshop brings together important areas of the corporatefinancial management, planning and control, corporate performance

analysis, planning and controlling budgets. It will help theentrepreneurs for preparation and execution more effectively for thefuture, using the financial techniques of planning and control,

developing performance from the use of the tools of financialanalysis, link planning & budgeting with costing and performance

measurement, and be a master the skills of budgetary and costcontrol. It must be for CEO competency and this is the right answer.

OBJECTIVEAfter completing this course, the participants will:

1.  Understanding Financial Analysis Using Financial PerformanceMetrics, Interpretation and problem solving in dashboard models.

2.  Understanding the CEO/Entrepreneur

3.  Parameter Analysis Model and Composition4.  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 provideinformation about three areas of a firm’s operations provideoperations

5.  Why outsiders and insiders are concerned with a company’s ratiosrelated to leverage, efficiency, productivity, liquidity and value

6.  How to calculate, interpret, and evaluate the key ratios related toleverage, efficiency, productivity, liquidity, and value to value.

7.  Why financial forecasts provide critical information for bothmanagement and external parties management.

8.  How to prepare financial forecasts by using the percentage ofsales approach

9.  How external financing requirements are related to sales growth, profitability, dividend payouts, and sustainable growth rates

BENEFITAfter completing this course, the participants will gain this practicaltraining:1.  Database management and analysis in financial modeling2.  Professional financial template model

3.  Get the best structure to get tips and tricks that could save youfrom working all night

4.  Solve and take it the best solution in the financial modeling case5.  Expect highly personalized, expert coaching to support you

answer your financial model

DAY ONE (1)

5.  Database Management and Analysis Tools5.1.  What-If Analysis

5.1.1.  Goal Seek & Solver add-in5.1.2.  Scenario Manager

5.1.3.  Data Table (0ne & Two Way)5.2.  Lookup & Reference and Developer Function5.3.  Formula Auditing

5.3.1.  Trace Precedents & Dependents

5.3.2.  Show Formula5.3.3.  Error Checking & Trace Error5.3.4.  Evaluate Formula

5.4.  Advance Pivot Tables & Chart Analysis5.5.  Conditional Formatting (Dashboard)

5.5.1.  Value5.5.2.  Formula

5.6.  Sort, Filter & Advance Filter

5.7.  Data Analysis Tools5.7.1.  Descriptive Statistics

5.7.2.  Correlation & Covariance5.7.3.  Histogram & Moving Average5.7.4.  Regression & Sampling

5.8.  Developer, Consolidate & Data Validation5.8.1.  Combo and Check box5.8.2.  Scroll and dropdown list5.8.3.  Consolidate, list and Validate

5.9.  Conditional Sum (SUMIF) and Macro/VBA

6.  The Financial Statement Concepts (IFRS/GAAP)6.1.  Financial Position Statement6.2.  Comprehensive Income Statement

6.3.  Shareholders’ Equity Statement6.4.  Cash Flow Statement

DAY TWO (2)

1.  Financial Performance Metrics

1.1.  DuPont Ratio & Sustainable Growth Analysis1.2.  Common Size & Annual Report Analysis1.3.  Altman Z-Score Analysis

2.  Capital Structure Evaluating

4.1  Weighted Average Cost of Capital (WACC)4.2  Capital Asset Pricing Model (CAPM)4.3  Working Capital & Free Cash Flow4.4  Discounted Cash Flow (DCF)

4.5  Economic Value Added (EVA)

3. 

Investment Analysis3.1.  Estimating & Calculating the relevant Cash Flows3.2.  Optimal Capital Budgeting

3.2.1.  Without Capital Rationing3.2.2.  Under Capital Rationing

3.3.  Making the Decision3.3.1.  Payback Period & Net Present Value

3.3.2.  Modified Internal Rate of Return & IRR3.3.3.  Profitability Index

4. 

CASE STUDY & GROUP DISCUSSION

FACILITATORMUSLIM, CA (11.D-21721), He is a Financial Modeling Specialist and a PROPHIX Consultants (performance management software

for forecasting budgeting and reporting-authorized dealer for Indonesia). He is also a registered accountant by profession as SeniorPartner of KAP Rama-Wendra (McMillan Woods), he is working as President Director for PT MY Consulting Indonesia and TheExecutive Director of INACD (Indonesian National Association of Commissaries and Directors). With a very rich and varied workexperience 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, QlikView and SAP-Xcelcius. His experience as a middle level and top-levelmanager and director 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

METHODOLOGY

Lecturers, Case study and Exercises

A participant to a computer (laptop by self)Practical Computer Hands on ApplicationsBring your own laptop and have all your financial modeling

INVESTMENT

IN-HOUSE TRAININGIDR 55.000.000 (fifty million rupiah)/batch (max 11pax)50% at a week before program & on the end of the program

CONTACT PERSON/NUMBER FOR RESERVATIONMY CONSULTING ACADEMY at 5704791 and 70708439info@myconsulting.co.id

PROGRAM EVENT & VENUE

THE PROGRAM ORGANIZED BY CLIENTS PLAN

TIME, PLACE & PROGRAM TAILOR MADE