Financial Analysis, Modeling and Forecasting - CapGrow Ptd Ltd

All managers need thorough grasp of the principles of financial analysis to help them to manage their businesses. This three day intensive and interactive workshop uses the principles of financial analysis and the power of Excel® to identify the strategic drivers that can dramatically enhance the value of your organization. Using Excel®, delegates will learn how to master many of the tools and functions it provides to apply the latest financial analysis techniques, understand what the numbers are revealing and be better able to make strategic and tactical decisions.

The workshop proceeds from fundamental financial analysis to more advanced techniques for determining the cost of capital, methods of projecting the benefit of capital projects. In addition, delegates will learn how to evaluate organizations with which delegates are planning to do business; determine if they are able to provide strategic strength to your company.Participants will be given Excel® templates for use during this session, which will be theirs to keep. The power of Excel® enriches the learning experience and enhances the seminar experience found when using only manual learning methods.

By attending this course, you will be able to:

• ANALYZE a company’s annual report, identifying key performance indicators in order to understand what the numbers are really saying and make projections of future performance
• BENCHMARK corporate performance against peer groups and industry statistics
• APPLY the powerful tools in Excel® such as the Financial and Statistical functions, aspects of the Data Analysis ToolPak and array functions
• MASTER how to use Excel® tools such as SOLVER®, Goal Seek,  Scenario Manager
• ANALYZE time series data and develop relationships using such techniques as exponential smoothing, simple and multiple regression analysis and other techniques
• UNDERSTAND the time value of money and its application
• UTILIZE Excel® with more confidence and flexibility, thus saving large amounts of time and enhancing productivity

This hands-on designed workshop is for financial professionals seeking to enhance their analytical, modelling, spreadsheet and forecasting skills, which include:

• Finance Managers and Controllers
• Strategy Directors and Managers
• Budget, Corporate, Business and Financial Analysts
• Project Managers and Risk Analysts
• Investment and Management Accountants
• Heads of Business Units and Business Planners
• Financial Advisors and Corporate Analysts
• Personnel from departments other than finance who have the need to get to grips with financial analysis, modelling and forecasting