﻿ Topics

## 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;
• 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.

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;
• Using formulae in tables;
• Working on diagrams;
• Logical functions;
• Lookup & Reference functions;
• Mathematical functions;
• Text functions;
• Financial functions;
• Massive 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;