DAY ONE (1) 5. Database Management and Analysis Tools 5.1. What-If Analysis 5.1.1. Goal Seek & Solver add-in 5.1.2. Scenario Manager 5.1.3. Data Table (0ne & Two Way) 5.2. Lookup & Reference and Developer Function 5.3. Formula Auditing 5.3.1. Trace Precedents & Dependents 5.3.2. Show Formula 5.3.3. Error Checking & Trace Error 5.3.4. Evaluate Formula 5.4. Advance Pivot Tables & Chart Analysis 5.5. Conditional Formatting (Dashboard) 5.5.1. Value 5.5.2. Formula 5.6. Sort, Filter & Advance Filter 5.7. Data Analysis Tools 5.7.1. Descriptive Statistics 5.7.2. Correlation & Covariance 5.7.3. Histogram & Moving Average 5.7.4. Regression & Sampling 5.8. Developer, Consolidate & Data Validation 5.8.1. Combo and Check box 5.8.2. Scroll and dropdown list 5.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 Statement 6.2. Comprehensive Income Statement 6.3. Shareholders’ Equity Statement 6.4. Cash Flow Statement
DAY TWO (2) 1. Financial Performance Metrics 1.1. DuPont Ratio & Sustainable Growth Analysis 1.2. Common Size & Annual Report Analysis 1.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 Flow 4.4 Discounted Cash Flow (DCF) 4.5 Economic Value Added (EVA) 3. Investment Analysis 3.1. Estimating & Calculating the relevant Cash Flows 3.2. Optimal Capital Budgeting 3.2.1. Without Capital Rationing 3.2.2. Under Capital Rationing 3.3. Making the Decision 3.3.1. Payback Period & Net Present Value 3.3.2. Modified Internal Rate of Return & IRR 3.3.3. Profitability Index 4. CASE STUDY & GROUP DISCUSSION METHODOLOGY Lecturers, Case study and Exercises A participant to a computer (laptop by self) Practical Computer Hands on Applications Bring your own laptop and have all your financial modeling
THE MASTER CLASS “FINANCIAL MODELING” INVESTMENT, PERFORMANCE & VALUATION ANALYSIS MODELING DESCRIPTION This 2-day workshop brings together important areas of the corporate financial management, planning and control, corporate performance analysis, planning and controlling budgets. It will help the entrepreneurs for preparation and execution more effectively for the future, using the financial techniques of planning and control, developing performance from the use of the tools of financial analysis, link planning & budgeting with costing and performance measurement, and be a master the skills of budgetary and cost control. It must be for CEO competency and this is the right answer. OBJECTIVE After completing this course, the participants will: 1. Understanding Financial Analysis Using Financial Performance Metrics, Interpretation and problem solving in dashboard models. 2. Understanding the CEO/Entrepreneur 3. Parameter Analysis Model and Composition 4. 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 5. Why outsiders and insiders are concerned with a company’s ratios related to leverage, efficiency, productivity, liquidity and value 6. How to calculate, interpret, and evaluate the key ratios related to leverage, efficiency, productivity, liquidity, and value to value. 7. Why financial forecasts provide critical information for both management and external parties management. 8. How to prepare financial forecasts by using the percentage of sales approach 9. 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 INVESTMENT IN-HOUSE TRAINING IDR 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 RESERVATION MY CONSULTING ACADEMY at 5704791 and 70708439 info@myconsulting.co.id PROGRAM EVENT & VENUE THE PROGRAM ORGANIZED BY CLIENTS PLAN TIME, PLACE & PROGRAM TAILOR MADE
FACILITATOR MUSLIM, 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 Senior Partner of KAP Rama-Wendra (McMillan Woods), he is working as President Director for PT MY Consulting Indonesia and The Executive Director of INACD (Indonesian National Association of Commissaries and Directors). 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, QlikView and SAP-Xcelcius. His experience as a middle level and top-level manager 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