Financial & Predictive Modeling with Excel

Are you meeting your boss’s needs by providing quick, useful and up-to-date information for better decision making? Are you frustrated with the high demand from your boss for information and yet you were not able to get data from other functional teams to allow your financial tabulation? Are you able to immediately provide What-If Analysis during a Management Meeting?

With globalization and rapid changes top management requires information quickly to make better business decisions. However, the general consensus are most Accountant or Finance Managers are too micro and not able to support such business needs and hence frustrating many top management.

This training will equip you with the necessary tools, skills and also provide some insights of business sense you must possessed in order to support the Top Management more effectively.

Objectives:

• Learn how to build effective Financial Model quickly and effectively to meet Business Needs
• Preparing What-if analysis to allow better Management Decision Making
• Understand the dos and don’ts in Building a Financial Model using Excel
• Prepare Financial Models using Excel systematically
• Leverage on some Excel Functions to enhance the Financial Models

Outcomes:

• Understand the dos and don’ts in building a financial model using excel
• Prepare financial models using excel systematically
• Leverage on some excel functions to enhance the financial models
• Prepare financial forecast by years with detail supporting worksheets for future changes

Target Audience:

• Finance Managers & Supervisors, Accountants, Participants who need to prepare & understand financials or investment