Financial Data Analysis using Mathematical and Statistical Methods

Start Date: 24 Mar 2019
End Date: 28 Mar 2019
Duration: 5
Country: Istanboul / Turkey
Category: Finance, Accounting & Investment

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:

Day 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 

Day Tow: Designing Financial Reports using computer 

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 

Day Three: assessing the financial position of an entity using computer

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 

Day Four: financial analysis ratios and financial indicators using computer

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 

Day Five: modern and advanced methods in analysis using computer

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 

3. Use of Mango Evaluation to verify the integrity of the financial management 

4. Properties of statistical analysis using the Analysis Toolpak 


Correlation & Covariance Descriptive Statistics 

Regression & Simple Regression Multiple

** In the event of uncontrollable circumstances, we may have to change main lecturer(s) for reasons out of control but replacement will always meet global standards of PROJACS International.

Mailing List
Send To Friend
Training Plan