Financial Modeling

Dilihat 533

DESKRIPSI Financial Modeling telah digunakan secara luas di kalangan profesi keuangan. Ada banyak jenis financial model, namun yang paling umum digunakan adalah financial statements for project model. Pelatihan ini akan memfokuskan pada financial model jenis ini. Pelatihan ini baik diikuti oleh mereka yang bergerak dalam bidang bisnis development dan yang orang-orang berkaitan dengan keputusan keuangan. Selain itu, para manajer profesional dan pemimpin perusahaan juga penting untuk memahami financial modeling. TUJUAN Diharapkan setelah mengikuti pelatihan ini, peserta mampu:

Memahami berbagai financial modeling for project terkini yang banyak digunakan baik oleh lembaga keuangan maupun non keuangan
Mengaplikasikan dalam beberapa kasus financial modeling.

MATERI PELATIHAN 1. Setting up a Financial Model and Building Projections

Overview of the Best Industry Practice for Financial Modeling
Important of Historic Information
Step for Creating Financial Model
Analysis of Company and Industry Information
Proper Presentation of Various Sheet and Setting up the Model Input Dashboard

2. Preparation of Income Statement, Cash Flow and Balance Sheet

Analysis of Industry Assumptions and Their Rationale for Revenue And Cost, Asset and Liabilities’ Assumptions Operating Cost, Capex, Leverage, Modeling of Historical Ratios and Trends
Short Listing Assumption Applying Adjustment
Applying Various Forecasting Tool and etc

3. Importance of Key Schedule and Their Application

Working Capital Schedule (component Cash And Non Cash)
Working Capital Ratio and Their Interpretation
Forecasting Working Capital Requirement
Fixed Asset and Depreciation
Schedule of Amortization of Intangible Asset
Preparation of Debt and Interest
Taxation
Equity Fund Raising
Equity Gap and Funding

4. How to Create Capex and Funding Schedule Including Multiple Multiple Debts

Equity and Debt Fund Raising and Repayment Structure
Debt Waterfall Mechanism
Checking Debt Repayment Ratio
Leverage and Covenant

5. Integration of Income Statement, Balance Sheet and Cash Flow Statement

Industry Practices on Handling Exceptions
Integration of Cash Flow, Income Statement and Balance Sheet
How to Handle Circular Reference in Financial Model

6. Establish scenario and sensitivity analysis

Uses of Data for Sensitivity Analysis
Importance of Scenario Manager
Identifying Suitable Scenarios and Sensitivity and Their Impact on Financial Analysis
Managing key pitfalls in the analysis

7. How to Analysis the Data

Data Sort and Filtering
Creating Customizing Pivot Table, Advanced Pivot Tables and Analysis
V-lookup and H-lookup, Macros, Goal Seek and Other Analysis
Solver Function and It Use

8. How to Apply Different Financial Analysis Technique on the Model

Important of PV, NPV and IRR and Their Link with Company Valuation
How to Analysis Various Capital Budget Decisions
Calculation of Various Ratios
Calculation the Weighted Average Cost of Capital Using CAPM
Calculation of WACC
Investment and Exit Analysis – Equity IRR, Project IRR

9. Approaches to Apply Different Valuation Techniques in the Model

Different Method Valuation – DCF, Multiple, Comparable
Discounted Cash Flow Valuation and Different Multiples Based Methodologies
Importance of Terminal Valuation
Current Industry Practices Followed in Company Valuation Using Single or Multiple Methodologies
How to Factor Size and Illiquidity Discount in the Final Valuation
Incorporate Various Adjustment to The Publicly Available Versions of Company Valuation

TRAINING METHOD Presentation Discussion Case Study Evaluation FACILITIES Training Kit Handout Certificate Lunch + 2x Coffee Break Souvenir Pick Up Participant (Jogja only)