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
- 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) - Present and Future Value Models
• Examples and Case Studies - 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 - Leasing Models
• Modeling the Capital vs. Operating Lease
• Synthetic and Leveraged Leases
• Lease vs. Purchase Model
• Comprehensive Problem Solving Case Study - 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 - 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 - 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: beproseminars
gmail.com
