Advanced Financial Analysis using Excel

Advanced Financial Analysis using Excel 


General Objectives:


This course is designed to

  • Provide the participants with the knowledge, skills and tools necessary to analyze an entity's financial information and evaluate its financial position
  • Enhance the participants' efficiency in terms of analysis using computer and making use of Excel advanced features
  • Introduce the participants to financial indicators and ratios and their importance in decision making and the manner of summarizing analysis results and presenting them to the senior management using Excel



Targeted Group:

• Financial managers
• Financial analysts and consultants
• External auditors
• Internal auditors
• Managers and officials who take decisions regarding costs, investment, purchase and funding
• General managers who wish to deeply understand methods of financial analysis application 


Contents: 

• Concept of financial analysis and its importance
• Types of financial analysis
• Basic financial statements and their importance in decision making
• Sources of funding and utilization of resources
• Financial analysis of financial statements

             - Liquidity ratios
             - Indebtedness ratios
             - Profitability ratios
             - Operating ratios

• Analysis of cash flows and its importance
• Other methods in financial analysis

             - Financial horizontal analysis and the process of its calculation using Excel spreadsheets
             - Financial vertical analysis and the process of its calculation using Excel spreadsheets
             - Financial ratios, their types and importance and the process of their electronic calculation

• Analysis of current assets management
• Analysis of long term financial position
• Methods and concepts of money time value
• Capital investments valuation
• Significant spreadsheets for the purposes of financial analysis using Excel
• Practical examples and cases
• Open discussion


Course Duration: 

20 training hours 



For more details don’t hesitate to contact the training officer:

on telephone number 17383001
or e-mail at:  gizrmrmt.yzsizrm@gztrgizrmrmt.xln

Calendar

Previous MonthJuly 2019Next Month
SuMoTuWeThFrSa
123456
78910111213
14151617181920
21222324252627
28293031

Mailing list

Enter your email to subscribe to TAG-Org Newsletter.