BUDGETING, FORECASTING & MONTHLY CASH FLOW MODELING

Jakarta, 25 –  26 July 2019

 

Day(s)

:

Hour(s)

:

Minute(s)

:

Second(s)

 This 3 in 1 course will teach you about budgeting, forecasting and monthly cash flow modelling.

The budgeting course will teach you about the entire budgeting process from start to finish, including how to create a disciplined culture of budgeting in your organization, the various methods for building budgets, techniques to analyze results, and how to increase the chances of organizational performance improvements.  You will learn to forecast future performance by better analyzing revenue and cost drivers with quantitative and qualitative methods.  In Monthly cash flow modelling course, you will learn to build a rolling 12-month cash flow forecast model from scratch complete with assumptions, financials, supporting schedules and charts. The course will look at how to forecast revenues, operating expenses and changes in balance sheet items to arrive at monthly cash flow. From there we will assess the financial impact of the forecast on the business, decide if capital needs to be raised, evaluate credit metrics, and create elegant charts to inform management and make executive decisions.

All Excel template in this course is given to participants and can be used as an example in our own work.

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

Budgeting 

Forecasting 

Monthly Cash Flow Modeling

Tools & Enhancing Model

Budgeting

  • Budgeting within a strategic framewok
  • Building a robust budgeting process
  • A Practical guide to developing budgets
  • Tracking budget performance with variance analysis

Forecasting

  • Cost structure and earnings volatility
  • Breakeven, margin of safety & sensitivity analysis
  • Quantitative forecasting methods
  • Qualitative forecasting methods

Monthly Cash Flow Modeling

  • Financial modeling best practices
  • Modeling cash flows review
  • Building your financial model in excel
  • Enhancing your model

Tools & Enhancing Model

  • Budgeting tools templates
  • Techniques in excel: goal seek, solver tool, consolidate, pivot table
  • Conditional formatting, data validation & auditing the model
  • Charts & Graphs

Course Curriculum

Module A : Budgeting & Forecasting

No Description
1 Budgeting within a Strategic Framework
Barrier to strategy execution
Translating the strategy into a business plan
Balance scorecards
Top reasons to budget
What to watch out for
2 Building a Robust Budgeting Process
The master budget
Three categories of budgets
Manufacturing, retail & service company example
Where to start and steps in the budgeting process
Top down vs bottom up involvement
3 A Practical Guide to Developing Budgets
4 approaches to budgeting
Incremental budgeting
Activity based budgeting
Value proposition budgeting
Zero based budgeting
Beyond budgeting
4 Forecasting Techniques
Cost types & Modified cost types
Cost structure and earnings volatility
Cost Analysis
Break even analysis and margin of safety
Sensitivity analysis with data table
Cost control matrix
Quantitative forecasting methods
Moving average
Simple linear regression
Equation of a line regression
Multiple regression
Interpreting regression output
PEST analysis & Porter’s 5 forces
5 Tracking Budget Performance with Variance Analysis
What is variance analysis
Volume vs price variance
Cost variance
Variance impact and waterfall chart data
Root cause analysis
Presenting results of variance analysis
6 Applied Budgeting Tools and Techniques in Excel
Budgeting tools templates
Goal Seek tool in Excel
Solver tool in Excel
Consolidate function in Excel
Pivot table overview
Setting up a pivot table in Excel
Beyond Excel

 

Module B : Monthly Cash Flow Modeling

No Description
1 Financial Modeling Best Practices
Robust rolling forecast models
Inputs and assumptions
Processing and formulas
Output and graphs
Modeling best practises and tradeoffs
2 Modeling Cash Flows Review
Operating cash flow
Investing cash flow
3 Building Your Financial Model in Excel
Overview of the modelling process
Time periods
Historical assumptions and drivers
Forecast assumptions and drivers
Income statement: revenue to EBITDA
Balance sheet: AR, inventory & AP
Supporting schedules: PP&E
Supporting schedules: debt schedule
Cash flow statement and cash balance
4 Enhancing Your Model
Conditional formatting
Data validation
Protecting the worksheet
Auditing the model
Charts and graphs

 

Subcribe to download course synopsis

Budgeting, Forecasting, Monthly Cash Flow Modeling in Excel

I consent to receive emails from TRANVORMA about discounts, offers, and company updates

By submitting this form, you agree to our Privacy Policy

SCHEDULE

Venue

Falcon Lounge 

Sopo Del Office, Tower B, 10th Fl

Kawasan Mega Kuningan, Jakarta

Date:

Thu & Fri, 25th – 26th July 2019

Time:

09.00-16.00 WIB

REGISTRATION  

Registration Date : 1st July – 22nd July 2019

INVESTMENT FEE (for 2 days)

Normal fee: Rp. 4.000.000,-/person

Early Bird : Rp. 3.500.000,-/person (by 17th July 2019)

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

Sopo Del

For further info, please contact:
EMILIA / OSCAR / TIM
0815 1330 9460