عربي
Providing Quality and
Professional Training Since 1984

Our Training Courses

Back
REGISTER_NOW Add to my calendar SEND_COURSE_TO_FRIEND Print this Course

Financial Modeling Using Excel

Date: 24 September 2017 - 28 September 2017
Course ID: ADDS002/2017
Duration: 5 Days
Fee US $: 3200 US$
Venue: Istanbul / Turkey
Category: Finance and Accounting

Introduction:

The goal of the program:

1. Enable participants to create financial reports to conduct financial analysis, and the use of modern tools such as mathematical and statistical methods.

2. Provide participants with modern tools to predict future financial performance and report on the success or failures of organizations.

3. To provide participants with the skills to perform financial analysis Applied to a number of companies, including participants can make a realistic assessment of financial performance, according to the practice of the process for a number of companies representing different sectors of the economy.

4. Activate the performance of the participants in the preparation and presentation reports the results of the financial analysis According to the methodology relies on mathematical and statistical tools to date.

Who should attend:

1. Financial Managers

2. Accountants

3. Financial analysts in the public sector organizations and private

4. Internal and external auditors for the various sectors

Daily Outlines:

Unit one: Introduction to Excel program and financial uses

1. The characteristics and features of Excel program

2. Basic functions and specialized functions in Excel

3. Analysis of financial data analysis using the properties of SORT-FILTER-SUPTOTALS-SCENARIOS

4. Models to query the financial statements using SUMIF-V-H –LOOKUP 5. Estimate the financial statements using the Forecast - Trend

6. Prepare graphs using CHARTS



Unit two: Designing Financial Reports using Excel

1. The financial statements i according to the latest amendments in the accounting standards.

2. Designing Balance Sheet using computer

3. Design of comprehensive income using computer

4. Design statement of cash flows using Computer



Unit three: assessing the financial position of an entity using Excel

1.The concept of financial analysis

2. Professional requirements profession of financial analysis

3. Principles of Financial Analysis

4. Financial analysis methods of traditional and modern

5. Remodeling financial reporting for a financial analytical



Unit four: financial analysis ratios and financial indicators using Excel

1. Analysis Horizontal and vertical analysis of financial statements

2. Benchmarking reference

3. Financial analysis using indicators for assessing performance

• the rate of return on investment ROI

• cash rate on investment COI

• internal rate of return IRR



Unit five: modern and advanced methods in analysis using Excel

1. Using regression in predicting the financial failure

• Form Altman Z-Score

• model Comport Z-Score

• model Kida

• model Sherrod



2. Using correlation to find financial fraud in the financial statements

Back
REGISTER_NOW Add to my calendar SEND_COURSE_TO_FRIEND Print this Course