• About Course


    • Provide participants with the knowledge and skills needed to read and analyze budgets-financial and to make investment decisions
    • Provide the participants with the knowledge, skills and tools necessary to carry out financial analysis of the entity and assess its financial position
    • To increase the efficiency of the participants in terms of computer analysis and to take advantage of the advanced features in the worksheets program
    • Define participants with indicators and financial ratios and their importance in decision making
    • Define participants how to summarize and present the results of the analysis to senior management - using the electronic presentation program

  • Course Topics


    Contents:

    the first unit:

    Introduction to the electronic worksheet program - and its financial uses

    • Introduction to the Excel program (worksheets)
    • Characteristics of the Excel program
    • Specifications of the worksheet
    • Some of the most used functions and their meanings
    • Logical Functions
    • Financial Functions
    • Statistical functions


    Module 2:
    Assessment of the financial position of the entity

    • The concept of financial analysis and its importance
    • Types of financial analysis
    • Basic financial statements and their importance in decision making
    • Sources of funding and resource use -
    • Analysis and evaluation of final financial statements for previous years to identify weaknesses and strengths
    • Use and analyze ratios, indicators and trends for several financial periods and compare them with general indicators to draw conclusions and determine the financial position expected in the coming years
    • Horizontal Financial Analysis and Calculation Process Using Electronic Workflow Vertical financial analysis and calculation process using electronic worksheets


    Module 3:
    Modern methods of financial planning and budgeting using computer:

    • The concept of financial planning
    • The relationship between the behavior of cost elements - activity and profitability
    • The composition of cost components and their relationship - level of activity
    • Optimal mixture for cost activities
    • The concept and types of budgets and the bases of their preparation
    • Principles and Principles and Budgeting
    • Translation of plans in the form of programs
    • Preparation of operational budget estimates
    • Preparation of capital budget estimates
    • Cash balance
    • Overall Budget


    Module Four:
    Financial analysis in financial ratios and indicators using computer

    • The concept of ratios and financial indicators
    • Considerations to consider when using financial ratios and indicators
    • Financial Ratios and Ratios
    • Liquidity ratios
    • Debt ratios
    • Profitability Ratios
    • Operating ratios
    • Analysis and significance of cash flows
    • Practical applications for financial analysis
    • A practical case for using financial ratios - to assess financial performance
    • Contemporary models for predicting the success or financial failure of enterprises, applied case using the model Altman (Z) to predict financial failure
    • How to calculate the efficient rate of return on investment
    • Modern liquidity control tools
    • Defensive period model


    Fifth Unit:
    Modern and advanced methods in the analysis of budgets using computer

    • Analysis of current asset management
    • Long Term Financial Position Analysis
    • Methods and concepts of time value of money
    • Capital investment valuation
    • Important tables for the purposes of the financial analysis process - using the worksheet program
    • Practical application cases
    • Open discussion

  • Certificates And Accreditation


  • Targeted Users


  • Course Benefits


  • Course Values


    - Distributed non-intensive course and comfortably and schedules evening and Meret halls.

    - The cost of training we are the least in the Kingdom of Saudi Arabia.

    - Lecturers and professional trainers and experts in their specialization.

    - Accredited by the Saudi Council of Engineers and the General Organization for Technical and Vocational Training session.

    - Continuous contact with the lecturer after the course and during the course.

    - You can re-attend the course free of charge.

    - Present in all parts of the Kingdom.

  • Agenda and Course Duration


  • Upcoming Courses


    No upcoming courses are scheduled

    Back
    Fast Courses Registration