• 2-DAY TRAINING: FINANCIAL MODELING IN EXCEL FOR FINANCIAL OR NON-FINANCIAL PEOPLE

2-DAY TRAINING: FINANCIAL MODELING IN EXCEL FOR FINANCIAL OR NON-FINANCIAL PEOPLE

From: 21 January 2020
To: 22 January 2020
BDO in Indonesia
Prudential Tower Fl. 17 Bougenville Room
Jakarta  
get directions

  • Summary

 

This training is your guide to learning how to create informative, enlightening financial models today. All the participants’ need is a basic understanding of Excel to start building simple models with practical hands-on exercises. Excel is powerful and user-friendly. This training shows:

  • the participants how to harness Excel's capabilities to determine profitability, develop budgetary projections, model depreciation, project costs, value assets and more.
  • the participants will learn the fundamental best practices and know-how of financial modeling, and how to put them to work for the business.
  • the participants will learn the tools and techniques that bring insight out of the numbers, and make better business decisions based on quantitative evidence.

The contents of the training:

Part 1: Getting Started with Financial Modeling

Introducing Financial Modeling

Getting Acquainted with Excel

Planning and Designing Your Financial Model

Building a Financial Model by the Rulebook

Using Someone Else’s Financial Model

 

Part 2: Diving Deep into Excel

Excel Tools and Techniques for Financial Modeling

Using Functions in Excel

Applying Scenarios to Your Financial Model

Charting and Presenting Model Output

 

Part 3: Building Your Financial Model

Building an Integrated Financial Statements Model

Building a Discounted Cash Flow Valuation

Budgeting for Capital Expenditure and Depreciation

 

Part 4: The Part of Tens

Ten Strategies for Reducing Error

Ten Common Pitfalls to Avoid


The requirements for the participants:

- A laptop with a relatively recent version of Excel installed: Microsoft Excel 2013

- A working knowledge of Excel and a use for it

- Some kind of financial background: the participants at least know what a set of financial

statements looks like, what revenue is, and know how interest calculations work.


Date: 21-2 Januari 2020
Venue:  Bougenville Room Lt. 17


Speaker:

Sukarnaen Suwanto

Certified Valuation Analyst from IACVA.org & Trainer in Corporate Finance & Valuation Topics


Investment:

Normal Price: Rp5.500.000

Early Bird: Rp5.250.000 (before 17 January)

Group: Rp5.000.000 (3 persons or more)


Bank Permata

Cabang Prudential Tower

Bank Account: 701642031

a.n PT BDO Insan Dinamis Indonesia


Contact:  

Reini

0857 – 7975 – 1339

[email protected]