Day(s)
:
Hour(s)
:
Minute(s)
:
Second(s)
A sound financial model is essential to understand the drivers and implications of business decision. This two day Building Financial Modelling workshop covers the fundamental skills needed to build a financial model from scratch in Excel sheet.
This workshop is aimed at both intermediate and experienced staff and includes the construction of an integrated set of simplified financial statements.
You will learn key tools of Excel which are useful for business analysis and how to construct a reliable financial model encompassing three financial statements (balance sheet, profit and loss statement and cash flow). This workshop also covers how to build the debt and financing sections including interest calculations and the capital structure of the business and has a pre-populated DCF built model.
OUR FACILITATOR
Timotius Ikin Solihin, ST, MBA, CMA, FRM, CTP, CSCP, FP&A
A well-seasoned Executive with 20 years’ Experience in directing, managing and transforming business. Have a broad range of skill and expertise including 7 years of experience as CFO/COO, 8 years of experience with SEC compliance, 4 years of experience in internal auditing. He got his Master of Business Administration in Finance & Accounting (MBA) from Monash University, Australia. Awarded as one of the Best CFO from SWA magazine in 2013 & 2014.
COURSE DESCRIPTION
A Structured approach to Financial Modeling
Forecasting the Income Statement and Balance Sheet
Build Debt and Financing Schedules
Constuct a Free Cash Flow Statement
A structured approach to financial modelling
- Apply a structured approach to financial modelling in Excel.
- Outline the hallmarks of good financial models.
- Explain the importance of planning and prep your model structure.
- Building form iperating revenues down to operating profit.
Forecasting the income statement and balance sheet
- Forecast property, plant and equipment and operating assets.
- Forecast the various components of working capital
- Accounts receivable
- Inventories
- Accounts payable
Debt and financing schedules
- Forecast debt financing and related interest costs
- Forecast equity financing and dividends
- Use an iterative analytic approach to managing circular references
Building a free cash flow statement
- Understand the importance of error checking
- Derive a forecast cash flow statement based on a forecast income statement and balance sheet
- Derive a free cash flow statement that can be used for equity valuation
Course Curriculum
| Unit | Credit Units* |
| 1 | Introduction |
| Instructor biography | |
| Key Learning Objective | |
| Keyboard over the mouse | |
| 2 | A structured approach to financial modelling |
| Key structure for model building | |
| Modeling best practice | |
| Inherent tensions in model building | |
| Model inputs | |
| Model processing | |
| Model outputs | |
| The four step approach | |
| 3 | Forecasting Income Statement |
| Forecasting operating revenues and profits | |
| Forecasting revenues | |
| Forecasting gross margin and SG&A expenses | |
| Income forecast demonstration | |
| 4 | Forecasting Balance Sheet items |
| Our financial forecast modelling framework | |
| Forecasting financeial statements | |
| Forecasing PPE | |
| Capital asset (PP&E) turnover ratio | |
| Forecasing PP&E acquisions and disposals | |
| Forecasting working capital | |
| 5 | Debt and Financing Schedules |
| A financial forecast modelling framework | |
| Forecasting financial statements | |
| Forecasing the financing structure | |
| The practicalities of forecasting finance | |
| 6 | Building a free cash flow forecast |
| Forecasting financial statements | |
| Cash flow from operating activities | |
| Cash flow from investing activitites | |
| Cash flow from financing activities | |
| Forecasting free cash flow to the firm | |
| Forecasting free cash flow to equity | |
| Reconciling free cash flow | |
| 7 | Case Study |
| Step for building a financial model | |
| Raw data | |
| Format and link historical subtotals | |
| Build supporting schedules | |
| Calculate historical ratios and metrics | |
| Fill in the assumptions | |
| Build the income statement | |
| Build the balance sheet | |
| Complete supporting schedules | |
| Complete the cash flow statements | |
| Complete the I/S and B/S | |
| Build charts and graphs |
SCHEDULE
Venue
Falcon Lounge
Sopo Del Office, Tower B, 10th Fl
Kawasan Mega Kuningan, Jakarta
Date:
Thu & Fri, 10th – 11th Maret 2020
Time:
08.30-16.00 WIB
REGISTRATION
Registration Date : 10st Februari – 6nd Maret 2020
INVESTMENT FEE (for 2 days)
Rp. 4.000.000,-/person
Day(s)
:
Hour(s)
:
Minute(s)
:
Second(s)
OUR GALLERY
COURSE VENUE
Falcon Lounge, Sopo Del Office, Tower B, 10th F Kawasan Mega Kuningan, Jakarta
Address:
Falcon Lounge
Sopo Del Office, Tower B, 10th Fl Kawasan Mega Kuningan, Jakarta – Indonesia
Call Us:
+62815-1330-9460