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