Topics

Module # 1 Financial Accounting and Analysis

 

Topics:

 

  • Subject of financial accounting;
  • Discussing financial statement
  • Elements of financial accounting; recognition and reflection;
  • Process of financial accounting;
  • Basics of financial Accounting;
  • Preparing a trial balance;
  • Review of accounting plan;
  • Pre-conditions of preparing a statement – corrections;
  • Accounting and analysis of receivables;
  • Accounting merchandize inventory;
  • Accounting of tangible and intangible assets;
  • Accounting liabilities;
  • Re-evaluation of investments
  • Accounting financial and operating rent;
  • Accounting in Joint Stock Companies;
  • Accounting in production;
  • Cash flow statement;
  • Analysis of financial statements

 

Module # 2 Managing Finances

Topics:

 

  • Time value of money, interest rate, loans;
  • Ways of valuating companies and assets;
  • Structure and analysis of Financial statmenetsl
  • Analysis of financial coefficients;
  • Risks and benefits;
  • Managing short-term assets;
  • Evaluation of capital projects with various financial instruments;

 

Trainer – Vato Berishvili

 

Module #3 Managerial Accounting

Topics:

 

  • Essence and goal of managerial accounting;
  • Types of costs;
  • Material costs;
  • Labor costs;
  • Overheads;
  • Costs-volume-profit (cvp) analysis;
  • Relevant costs;
  • Budgeting;
  • Deviation analysis.

 

Trainer: Giorgi Biganishvili

 

Module # 5 Taxes

Topics:

 

  • Essence of taxes, qualities, structure, classification, tax code;
  • Subjects of tax law, tax authorities, tax-payer, tax agent and other liable persons;
  • Common national taxes, income tax;
  • Common national taxes, tax on profits;
  • Common national taxes, indirect taxes;
  • Local taxes.

 

Trainer: Zviad Rogava

 

Module # 5 Excel

Topics:

 

  • Creating tables – Using command Table
  • Formulae and functions in Excel;
  • Operators for formulae, order;
  • Examples of functions, arguments for functions;
  • Creating formulae, using cells and dimension names in the formulae;
  • Types of cell addresses;
  • Using formulae in tables;
  • Working on diagrams;
  • Logical functions;
  • Lookup & Reference functions;
  • Mathematical functions;
  • Text functions;
  • Financial functions;
  • Massive functions;
  • Additional functions;
  • Dividing texts into columns;
  • Conditional formatting;
  • Types of protection;
  • Sorting data; sorting by applying different criteria;
  • Data filtering; filtering by applying different criteria.

 

 

Topics:

 

  • Review of financial modeling, examples. Principles of Excel functions and modeling;
  • Creating financial modeling, audit, design, documents and communication. Tables, diagrams and graphs;
  • Syntax, application principles and options for Excel’s financial, mathematical, logical, statistical, time, search, textual and other functions needed for modeling;
  • Instruments of optimization, sensitivity and analysis, solver, goal seek, data table, scenario manager and their application in financial models;
  • Ways of interpolation and extrapolation, forecasting (moving average, exponential smoothing, regressions);
  • Processing complex tables, data analysis, sub-totals, pivot-tables, descriptive statistics, histograms;
  • Developer instruments: Macros, Form Controls, ActiveX Controls. Excel Add-in instruments and programs;