MODERN FINANCIAL MODELLING

Public Training Modern Financial Modelling

(3 Days Training )

Description

Modern financial modeling training adalah pelatihan selama tiga hari yang secara khusus didesain bagi para staff professional, manager dan leader di perusahaan yang secara langsung maupun tidak terlibat dalam proses pembuatan strategic planning. Para peserta akan diperkenalkan konsep dan aplikasinya terutama dengan menggunakan program Excel serta beberapa critical financial modeling. Para peserta juga akan diperkenalkan dengan beberapa fungsi excel yang sangat berguna dalam pembuatan planning.

Objectives

Mamahami financial modeling

Memahami dan mengoptimalkan fungsi Excel yang mempermudah financial modeling

Mengaplikasikan dalam beberapa kasus financial modeling

Course Content

1.Basic Principles of Financial Model Construction

2. Present and Future Value Models

3. Capital Budgeting Models

Discounted vs. Non-discounted Capital Budgeting Models

Payback and Rate of Return & Discounted Payback

Net Present Value and Profitability Index

Internal Rate of Return & Modified Internal Rate of Return

Comprehensive Problem Solving Case Study

4. Leasing Models

Modeling the Capital vs. Operating Lease

Synthetic and Leveraged Leases

Lease vs. Purchase Model

5. Integrated Sales Driven Monthly Financial Statement Projections

Forecast vs. Projection; AICPA/SAARS Definitions and Requirements

Identifying Key Business Drivers & Documenting Assumptions and Uncertainties

Income Statement Projections & Projecting Revenues based on Key Drivers

ƒ Regression Analysis for Fixed and Variable Cost Projections–how to determine expense drivers

Flexible Budgeting with Data Tables and Goal Seek

Projecting Profits with Simulation Tools

Integrated Balance Sheet — Interactive Modeling Applications

Borrowing and Contributed Capital

Fixed Assets and Working Capital

Interactive Statement of Cash Flows from the Balance Sheet and Income Statement

Operating Cash Flow, Cash from (for) Investments, Cash from (for) Financing

Financial Ratios: Modeling to Meet Objectives

Projecting Cash Flows and Borrowing Requirements

Projecting Breakeven with Data Tables and Problem Solver

Optimal Pricing Projections with Data Tables and Problem Solver

6. Model to Determine the Weighted-Average

After-Tax Cost of Capital After-tax Cost of Debt

Cost of Equity

Beta and Capital Asset Pricing Model

Modeling Your Firm’s Optimal Debt to Equity Ratio: Leveraged vs. De-Leveraged Beta

Modeling Your Firm’s Economic Value Added (EVA)

Arbitrage Pricing Theory Model

7. Valuation Models

Capitalization of Earnings

Discounted Cash Flow: Sensitivity Analysis for Growth and Discount Rates

Option Pricing Models

Price-Earnings Multiple (Example: Public Company Roll-ups)

Instructor

Dr. Nurofik, Akt

Who Should Attend

Pelatihan ini diselenggarakan untuk praktisi manajemen keuangan yang ingin mendapatkan pengetahuan yang lengkap mengenai financial control management dan finance manager atau financial controller yang ingin menyegarkan pengetahuannya.

Methods

1.    Presentation
2.    Discuss
3.    Case Study
4.    Evaluation

Time and Venue

Training will be held on : 22 th – 24 st November 2013 New Saphir Hotel, Yogyakarta (****)

Course Fee

IDR 6.000.000,- / participant (non residential)

Special rate IDR 5.500.000,- / participant (non residential) for minimum 3 participants from the same company.

Facilities

Convinience meeting room at New Saphir Hotel, Yogyakarta (****)

Airport pick up services

Transportation for participants from hotel of participants to/from hotel of training – VV (if minimal participants is 3 persons from the same company)

Hard & Soft copy course material ( USB Flashdisk )

Training Kit ( Stationeries: NoteBook and Ballpoint, Bacpack)

Coffee Break & Lunch

Exclusive Souvenir

Qualified Instructor