Telepon

+62-812-2483-2565, +62-21-889-68-569

Email

contact@arcartaconsultant.com; info.arcartaconsultant@gmail.com

IN HOUSE ONLINE TRAINING FINANCIAL MODELING, BUDGETING & CORPORATE FINANCE

In House Online Training Financial Modeling, Budgeting & Corporate Finance | Lembaga Penjamin Simpanan | Zoom Meeting | Tanggal 15-17 Juni 2021

 

INVESTASI IN HOUSE ONLINE TRAINING

1 Day 

Rp 12.500.000 – Rp 17.500.000

 

2 Days

Rp 17.500.000 – Rp 23.000.000

 

INVESTASI TERMASUK  : 

  1. Soft Copy Modul Training (Email)
  2. Modul Training (Tiki)
  3. Sertifikat Kehadiran (Tiki)
  4. Qualified Instructor

WAKTU PELAKSANAAN TRAINING

Depend on request

Register button

OVERVIEW

A financial model is simply a tool that’s built-in spreadsheet software such as MS Excel to forecast a business’ financial performance into the future.  The output of a financial model is used for decision making and performing financial analysis, whether inside or outside of the company. There are many different types of professionals in investment banking, equity research, corporate development, FP&A, and accounting (due diligence, transaction advisory, valuations, etc.) who build financial models.  The forecast is typically based on the company’s historical performance, assumptions about the future, and requires preparing an income statement, balance sheet, cash flow statement, and supporting schedules. It is more likely that you start with corporate operational, capital and project budgeting. A budget is an estimation of revenue and expenses over a specified future period of time and is usually compiled and re-evaluated on a periodic basis. Budgeting is the tactical implementation of a business plan. To achieve the goals in a business’s strategic plan, we need a detailed descriptive roadmap of the business plan that sets measures and indicators of performance. Valuation refers to the process of determining the present value of a company or an asset. It can be done using a number of techniques. Analysts that want to place value on a company normally look at the management of the business, the prospective future earnings, the market value of the company’s assets, and its capital structure composition.

 

TUJUAN TRAINING

Melalui kegiatan pelatihan, para peserta akan diperkenalkan konsep dan aplikasinya :

  1. Memahami berbagai financial modeling for Project terkini yang banyak digunakan oleh lembaga keuangan dan non lembaga keuangan.(Financial Modeling)
  2. Mengaplikasikan dalam beberapa kasus financial modeling.(Financial Modeling)
  3. Memberikan pemahaman secara menyeluruh mengenai budget cycle
  4. Memahami hubungan antara budget dan strategic planning
  5. Meningkatkan kemampuan peserta dalam membuat budget dengan beberapa pendekatan aplikatif
  6. Meningkatkan pemahaman tentang project budgeting
  7. Memahami cost control dengan pendekatan strategic dan transactional

 

OUTLINE

DAY 1 FINANCIAL MODELING

  1. Financial Modeling – Outlook
  • What is Financial Modeling
  • The use of Financial Modeling
  • Who builds Financial Modeling
  • Financial Modeling best practice (introduction)
  • How do you build a Financial Modeling

 

2. The Top 10 types of Financial Modeling

  • Three Statements Model
  • Layout and Structure
  • How to build a 3 Statements Model

3 Statements Model Template

 

4. Discounted Cash Flow (DCF) Model

  • Unlevered Free Cash Flow
  • Three Key Principals Role

5. Other Top Types of FMs

  • Merger Model (M&A)
  • Initial Public Offering (IPO) Model
  • Leveraged Buyout (LBO) Model
  • Sum of the Parts Model
  • Consolidation Model
  • Budget Model
  • Forecasting Model
  • Option Pricing Model

6. Case Study: Building a 3 Statements Model

 

DAY 2  CORPORATE BUDGETING

  1. Financial Planning & Analysis
  • Analyst Personality Traits
  • Entry and Exit Strategy
  • FP & A Jobs
  • Key Elements of Cost Control

2. The Budgeting Cycles

  • Environmental Analysis
  • Formulating Company Objective and Strategy
  • Tactical and Operating Plan
  • Operating Budget

3. Budgeting and Cost Estimates

  • Environmental Analysis
  • Formulating Company Objective and Strategy
  • Tactical and Operating Plan
  • Operating Budget

4. Project Budgeting, Capital Expenditure Budgeting and Analysis

  • Project Planning and Budgeting
  • Guidelines of Capital Budgeting and Its Calculations

5.  Case Study: Calculations on Project and Capital Budgeting

 

DAY 3  CORPORATE VALUATION

  1. Valuation through Financial Statement

a.From Activities to Financial Statement

b.From Financial Statement to Business Analysis

  1. Corporate Strategy Analysis

a.Industry Analysis

b.Competitive Strategy Analysis

c.Achieving and Maintaining the Position

d.Tools of Corporate Analysis

  • Competition Analysis
  • Financial/ Accounting Analysis
  • Business Valuation Analysis
  • Implementation and Utilization of Analytical Tools

 

3. Stock and Marketable Securities

a.Analysis, Credit Analysis and

b.Business Prospect/ Failure

c.Stock and Marketable Securities

d.Analysis

e.Credit Analysis

f.Business Prospect

g.Business Failure

 

4. Case Study: Implementation and

Utilization of Analytical Tools

 

TRAINER & FACILITATOR :

Tim Trainer Arcarta Consultant

 

INFORMASI

Registrasi, hubungi :
Arcarta Consultant  
TELEPON : +6221-889-68569
HP/ WA : 
+62-812-2483-2565 (Citra)
Email:
info_training@arcartaconsultant.com;
info.arcartaconsultant@gmail.com

15 Jun 2021Selesai09.00-15.00 WIB
16 Jun 2021Selesai09.00-15.00 WIB
17 Jun 2021Selesai09.00-15.00 WIB
Zoom/ Google Meet 1 Day
- Rp 12.500.000 - Rp 17.500.000
Zoom / Google Meet 2 Days
- Rp 17.500.000 - Rp 25.000.000
Zoom / Google Meet more 2 Days
- Contact Admin
REGISTER
error: Content is protected !!