Financial Planning: Modern Financial Modeling

Modern financial modeling adalah pelatihan selama dua 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.

Tujuan Pelatihan

• Mamahami financial modeling
• Memahami dan mengoptimalkan fungsi Excel yang mempermudah financial modeling
• Mengaplikasin dalam beberapa kasus financial modeling

Metode Penyajian

• Para peserta akan difasilitasi dengan computer untuk dapat secara langsung mengaplikasikan excel dalam pembuatan financial model

Siapa yang Menjadi Peserta?

• Para Staff Professional, Manager, Controller, Director CFO dan CEO yang terlibat dalam proses pembuatan strategic planning

Pokok-Pokok Bahasan

1. Basic Principles of Financial Model Construction
   • Excel Tools for Modeling
   • Data Tables and Sensitivity Analysis, Goal Seek, Scenario Manager, Solver, Regression Analysis
   • Random Number Generator
   • Using Macros for Repetitive Tasks & Financial Functions
   • Communicating the forecast with data visualization techniques (graphics)
2. Present and Future Value Models
   • Examples and Case Studies
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
   • Comprehensive Problem Solving Case Study
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
   • Problem Solving Case Study
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)

Related Topics:
BP-218 Advanced Financial Modeling
BP-210 Developing Budget Using MS Excel
BP-106 Business Strategy & Plan: A Comprehensive Approach
BP-216 Budget Control for Operation Develop in Manufacturing Company

Informasi & Registrasi:

• Untuk keterangan selengkapnya (termasuk biaya dan jadwal pelaksanaan) silahkan dilihat di <Modern Financial Modeling> atau BePRO-seminar322.Pdf.
• Untuk pendaftaran silahkan download Registration Information dan kirim kembali setelah diisi dengan lengkap.
• Anda juga dapat menghubungi langsung penyelenggaranya melalui Tel: 021-5228081,021-3239-3959 Fax: 021-5207195 atau Email: beproseminarsgmail.com

Job Order Costing- 1 Job & Process

Training Programs 2011

Informasi Seminar/Training Program 2011 untuk masing-masing kategori (bidang) pelatihan dapat didownload melalui link-link di bawah ini:

• Training Internal Audit, Fraud Audit dan Fraud Examination
• Training Finance Accounting
• Training Leadership, Management Skill, Administrasi & Sekretaris serta Marketing Sales & Service
• Training Pajak | Taxes Professional Training
• Project Management Training Programs
• Operation and Strategic Management
• Training for Banking Operation

Silahkan klik judul pelatihan di atas untuk melihat uraian/daftar lengkapnya.

Be the Leader in Finance and Accounting Department!

Finance merupakan fungsi yang unik dan diharapkan menjadi Business Partner yang strategis bagi perusahaan. Finance, dalam skala apapun, harus terlibat dan ikut serta dalam pengambilan keputusan manajemen baik yang bersifat tactical maupun strategic.

Sehubungan dengan itu seorang leader dibidang finance dituntut untuk dapat membawa tim-nya menjadi bagian yang terintegrasi dengan strategic team members, membangun winning team, mempertahankan independent view serta internal control yang efektif. Selain itu, finance tim diharapkan berperan sebagai advisor dan mengakomodasi kebutuhan executive director dan departemen lain.

Oleh karenanya seorang leader di finance dan accounting tidak hanya harus memiliki kemampuan teknis best practices bidang finance & accounting semata, tetapi juga leadership. Kemampuan leadership finance ini akan berbeda dengan leadership di department lain, karena permasalahan dan karakter tim finance sangatlah berbeda.

Untuk menjadi leader di departemen finance, seorang praktisi finance harus memiliki kemampuan dalam:

• Mengurai dan memecahkan permasalahan laten di departemen finance dan accounting
• Memilah dan memilih serta mengelola arus informasi yang dibutuhkan dan mengelola sistem informasinya secara efektif
• Membangun tim finance dan accounting sebagai champion of change

Bagaimana mencapai kemampuan leadership di bidang finance?

Tentunya selain faktor pengalaman, managerial skills, dan bakat kepemimpinan yang terasah, pengetahuan yang berkaitan dengan urusan pengelolaan finance accounting serta kaitannya dengan departemen lain haruslah dimiliki oleh setiap kandidat leader ini. Sebagai tolok ukur atau barometernya seorang leader atau kandidat leader finance accounting haruslah memiliki pandangan dan jawaban atas berbagai pertanya terkait posisi tersebut seperti:

1. Why Finance is unders pressure?
   Beberapa tipikal permasalahan yang selalu ada di finance dan accounting yang memerlukan pemecahan adalah:
   • Too much detail and complexity
   • Lack of understanding the business
   • Too many measures (too many reports)
   • Lack of risk management expertise
   • Lack of analytical skills


2. Freedom Fighter
   Bagaimana finance dan accounting dapat mengurangi tingkat kompleksitas dan pekerjaan detail sehingga dapat memiliki ruang untuk proses analisa. Hal tersebut dapat dicapai dengan:
   • Mengelola informasi dan mencegah overload
   • Menyederhanakan system dan report
   • Focus on truth & transparency
   • Mengelola perangkat dan sistim yang dibutuhkan


3. Meningkatkan peran sebagai Analyst dan Advisor
   Seorang leader finance harus memahami strategi finance dan accounting agar dapat meningkatkan kemampuannya sebagai analyst dan advisor yang selalu dibutuhkan. Untuk itu dia harus mampu:
   • Membangun tim yang kompeten
   • Membangun keahlian berkomunikasi di dalam tim kerja
   • Meningkatkan fungsi control yang efektif
   • Mendukung pengambilan keputusan secara efektif


4. Membangun finance dan accounting menjadi tim yang adaptive
   • Mengelola system yang adaptive yang berorientasi terhadap customer
   • Cycle planning
   • Focus accountability
   • Mengelola akses terhadap sumber yang dibutuhkan


5. Membangun tim finance dan acconting sebagai
   • Master of measurement
   • Regulatory of risk
   • Master Cost reduction


6. Membangun tim finance dan accounting sebagai Champion of change


7. Meningkatkan kemampuan komunikasi, delegasi, leadership, dsb.

Masih banyak hal tentunya yang belum dibahas disini. Namun uraian singkat ini diharapkan akan menginspirasi dan mengingatkan para praktisi finance akan hal-hal yang menjadi tolok ukur bagi seorang leader di finance and accounting departement sehingga mereka dapat mempersiapkan diri dengan lebih baik dan terarah..

Recommended Training: Leading Finance and Accounting Department

Recommended Reading: Management: Leading & Collaborating in the Competitive World

Agenda Public Training - May 2010

STRATEGIC MANAGEMENT

May 05-07 Financial Considerations for Business Decision Making*
May 11-12 Human Resources Strategy (BRPO-CTT)
May 11-12 Practical Strategic Management

FINANCIAL PLANNING, ANALYSIS, AND CONTROLING

May 03-04 Analisa Restrukturisasi Keuangan Perusahaan
May 05-07 Financial Control Management*
May 11-12 Fundamentals of Budgeting for Non Specialist
May 11-12 Making the Transition from Controller to CFO*
May 17-18 Effective Internal Controls: Concept & Impl'n
May 17-18 The Essentials of Corporate Budgeting*
May 19-20 Budgeting Planning and Profit Control
May 19-20 Essentials of the Controllership

FINANCIAL MANAGEMENT IN ACTION

May 03-04 Fundamentals of Finance & Acctg for Nonfinance*
May 03-04 Best Practice Payable Management
May 11-12 Asset Management
May 05-07 Fundamentals of Corporate Finance*
May 11-12 Managing Closing Effectively
May 17-18 Corporate Cash Management
May 17-18 Managerial Decision and Capital Budgeting*
May 17-18 Managing Liabilities, Liquidity & Cash
May 19-20 Credit Risk, Receivable & Corporate Collection Mgt*
May 19-20 Leading Finance and Accounting Department*
May 19-20 Modern Financial Modeling*
May 19-21 Optimizing Financial Analysis Using MS Excel*
May 19-21 Laboratorium Finance (CPFM)

COST & ACCOUNTING MANAGEMENT

May 05-06 Managerial Accounting: Concept for Planning & Ctrl
May 10-12 Fixed Assets Accounting
May 11-12 Derivatives Accounting & Tax*
May 11-12 Fundamentals of Indirect Cost Rates*
May 11-12 Strategic Cost Management
May 17-18 Best Practices of Cost Reduction & Cost Control
May 17-18 PSAK Standard for Financial Statements*
May 17-18 Tax Accounting & Fiscal Reconciliation*
May 19-20 Activity Based Costing (ABC): Concept & Application*
May 19-20 Essential for Accounting Payroll
May 19-21 Accounting Best Practices*
May 25-26 Accounting Policies Procedures Manual
May 25-27 Fundamentals of Cost Accounting*

FRAUD AND RISK MANAGEMENT

May 05-06 Foreign Exchange Risk Management
May 10-12 Essentials of Finance & Operation Risk Mgt*
May 11-12 Fraud Prevention & Detection for Non Auditor
May 25-27 Financial Risk Management

STANDARD OPERATING POLICIES & PROCEDURES

May 11-12 Human Resources Policies and Procedures
May 25-26 Accounting Policies and Procedures Manual*
May 25-26 Business Fraud Prevention Manual (BPRO-LPAI)

Public Traininig Agenda April 2010

STRATEGIC MANAGEMENT

April 05-06 > Business Plan: A Comprehensive Approach
April 07-08 > Fundamentals of Strategic Planning
April 15-16 > Moving from an Operat'l Mgr to a Strategic Thinker*

ACCOUNTING & FINANCIAL MANAGEMENT

April 05-06 > Strategic Skills for Financial Controllers

April 05-06 > Advanced Corporate Cash Management
April 05-06 > Advanced Cost Control: A Strategic Guide*
April 07-08 > Short-Term Financial Management
April 07-09 > Developing Budget Control for Operation in Mfg Coy
April 07-09 > Planning and Controlling Operations
April 13-14 > Strategic Business & Financial Analysis*
April 13-14 > The Controllers in Action*
April 13-14 > Collection Strategy & Negotiation for Non Fin'l Coy*
April 13-14 > Organizing and Managing Accounts Payable
April 13-14 > Inventory Accounting*
April 15-16 > Financial Accounting Analysis and Reporting
April 15-16 > Fast Closing Workshop*
April 15-16 > Accounting Information Analysis for Business Decision*
April 15-16 > Best Practices of Accounting Control*
April 15-16 > International Financial Reporting Standard (IFRS)*
April 15-16 > Asset and Liability Management
April 19-20 > Developing Budget Using MS Excel*
April 19-20 > Financial Statement Analysis*
April 19-20 > Activity-Based Cost Mgt: Managing Cost & Performance
April 19-20 > Business Combination Accounting*
April 19-20 > Cost-Benefit Analysis (CBA)
April 19-20 > Treasury Management for Non Specialist*
April 21-22 > Effective Budgeting and Cost Control*
April 21-22 > Managers Guide to Improving Internal Control
April 21-22 > Overhead Cost Management
April 21-22 > The Statement Of Cash Flow (SCF)
April 21-23 > A New Paradigm of Management Accounting
April 21-23 > Creative Accounting
April 27-28 > Creative Cash Flow Reporting (BPRO&LPAI)
April 27-29 > Advanced Cost Accounting*
April 29-30 > Intermediate Finance & Accounting for Nonfinance*

FRAUD AND RISK MANAGEMENT

April 13-15 > Operational Risk Management
April 21-22 > Enterprise Risk Management Application*
April 27-28 > Managing Risk in Asset Management*

STANDARD OPERATING POLICIES & PROCEDURES

April 07-08 > Sales & Marketing Policies and Procedures*
April 13-14 > Finance Policies and Procedures (SOP Finance)*

SPECIALIST PROGRAMS

April 13-16 > Certificate of Professional Cost Controller

________

*direncanakan di Bandung

Organizational Behavior