Corporate finance seminar 2016

Excel Series-Spreadsheet

CEO Financial Modeling

The 3-day workshop (BATCH #37)

Corporate Finance &

Budgeting/Forecasting Analysis

“How to understand your past, current and future company performance by one click”

Public class IDR 20 Million/participant

LIMITED SEAT only for 4 participants

Jakarta, FEBRUARY 16-18, 2016

Exclusive Training, please reserve and secure your seat and book now at 021-5704791

                                                                                                  

Description

This 3-day seminar brings together important areas of corporate financial management, planning and control, corporate performance analysis, planning and controlling budgets. It will help business professionals for preparation 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.

When explore and exam any financial opportunity the ability to perform accurate and realistic financial analysis is imperative. In today's ever-changing business environment the capability to write simple spreadsheets is not enough. You have to be able to apply financial theory and produce accurate tools for analysis. A well structured financial model can improve the reliability and quality of decision-making. Designed for professionals involved in financial and credit analysis who would like to effectively utilize the powerful features of Excel, this course will explore the use of Excel as an advanced analysis tool, as well as selected features that help prepare accurate reports and work papers.

OBJECTIVE

After completing this course, the participants will:

1.    Understanding Financial Analysis Using Financial Performance Metrics and Interpretation

2.    Understanding the CEO/C-Level 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

               

DETAIL SCOPE OF TRAINING

DAY ONE (1)

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. Consolidate & Data Validation

1.8. Conditional Sum (SUMIF)

DAY TWO (2)

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.9. Competitor & Benchmarking Analysis

4.    Financial Distress (Bankruptcy Predictions)

4.1. Altman Z-Score Analysis

4.2. Springate Analysis

5.    Tax Computation Analysis (New Regulations)

5.1. Corporate Withholding Tax

5.2. Personal Income Tax

DAY THREE (3)

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. Merger & Acquisition Corporate Valuation

6.2.1.   Working Capital

6.2.2.   Free Cash Flow to Firm

6.2.3.   Capital Cash Flow Valuation

6.2.4.   Equity Cash Flow Valuation

6.2.5.   Discounted Cash Flow Analysis

6.2.6.   EVA Analysis

7.    Evaluation of Capital Projects

7.1. Payback Period Net Present Value

7.2. Modified Internal Rate of Return

7.3. Profitability Index

8.    Budget Analysis and 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)

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

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 (Mc Millan Woods) and is working as President Director for PT MY Consulting Indonesia and Executive Director of Indonesia Association Commissioner and Director (INACD) for Good Corporate Governance. 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 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.

INVESTMENT

PUBLIC Class IDR 20.000.000/participant

IN-HOUSE TRAINING

IDR 75.000.000 (exclude VAT 10% and OPE)/9 participants

Payment method:

50% at a week before program

50% on the end of the program

CONTACT PERSON/NUMBER

FOR RESERVATION/BOOKING

Mr. Tio / Aswin/ Adhys

Events Coordinator

PT MY Consulting

Wisma Nugra Santana

12 Floor Suite1216

Jl Jend Sudirman Kav 7-8

Jakarta 10220 INDONESIA

Ph +6221 5704791

Fax +6221 5704918

info@myconsulting.co.id