Financial Modeling & Analysis

1.1 Accounting Defined

1.2 Importance of Accounting.

1.2 Use of accounting information.

1.3 Types of accounting information.

1.4 Generally accepted accounting principles.

1.5 Conventions and Principles.

1.6 Accounting cycle and its step

2.1 Recording transaction.

2.2 Preparing General Journal.

2.3 Making Ledger

2.4 Preparing Trial Balance.

2.5 Making adjusting entries.

2.6 Adjusted Trial Balance

3.1 Balance sheet.

3.2 Income Statements

3.3 Statement of Cash flows

3.4 Preparing Final Accounts

4.1 Computerized Accounting Flow

4.2 Data and Information

4.3 Database and Types

4.4 Database Relationships

4.5 Importance and Characteristics of Database

5.1 Introduction to MS EXCEL

5.2 Main Parts of MS-Excel the Title Bar, The Menu Bar, Standard toolbar, Formatting Toolbar, Formula bar, the document Windows, Other types of Excel Documents.

5.3 Introduction to basic functions Sum, Count, Max, Min, Count A, ,Average and its applications.

5.4 Introduction to Relational Operators, (>,<,=,<>,>=<=)

6.1 Introduction to Logical Operators (OR, AND, NOT),

6.2 Concept of Simple Conditions and Critical Conditions

6.3 Functions, IF, Sumif, Sumifs, Countif, Countifs

6.4 Practical Preparation of Employee Salary Sheet

7.1 QuickBooks Overview & Company Creation

7.1 Understanding List

7.1 list Menu

7.1 Company Menu

7.1 Reports Menu

8.1 Charts of Accounts

8.2 What is an Account?

8.3 Types of Accounts

8.4 Customers and Vendor Modules

8.5 Customer centers

8.6 Cash/credit/partial Invoice

8.7 Receive Payments

8.8 Sale return

8.9 Vendors centers

8.10 Create purchase orders

8.11 Purchase Entry

8.12 Pay bills

8.13 Inventory Management

8.14 Payroll & banking Module

8.15 Payroll Employees

8.16 Banking

8.17 Write cheques

8.18 Use registers

8.19 Make Deposits

9.1 Report centre

9.2 Creation and Export of Different Reports

9.3 Trial Balance

9.4 General Ledger

9.5 General Journal

9.6 Balance Sheet

9.7 Cash Flow

9.8 Income Statement

10.1 Peachtree Overview & Company Creation

10.2 Understanding List

10.3 list Menu

10.4 Company Menu

10.5 Reports Menu

11.1 Charts of Accounts

11.2 What is an Account?

11.3 Types of Accounts

11.4 Customers and Vendor Modules

11.5 Customer centers

11.6 Cash/credit/partial Invoice

11.7 Receive Payments

11.8 Sale return

11.9 Vendors centers

11.10 Create purchase orders

11.11 Purchase Entry

11.12 Pay bills

11.13 Inventory Management

11.14 Payroll & banking Module

11.15 Payroll Employees

11.16 Setup Payroll Items

11.17 Banking

11.18 Write cheques

11.19 Use registers

11.20 Make Deposits

12.1 Report centre

12.2 Creation and Export of Different Reports

12.3 Trial Balance

12.4 General Ledger

12.5 General Journal

12.6 Balance Sheet

12.7 Cash Flow

12.8 Income Statement

13.1 Tally Overview & Company Creation

13.2 Understanding List

13.3 List Menu

13.4 Company Menu

13.5 Reports Menu

13.6 Company Creation

13.7 Charts of Accounts

13.8 What is an Account?

13.9 Types of Accounts

13.10 Accounts Creation

14.1 Customers and Vendor Modules

14.2 Customer options

14.3 Receive Payments

14.4 Sale return

14.5 Reports Menu

14.6 Create purchase orders

14.7 Purchase Entry

14.8 Pay bills

14.9 Inventory Management

14.10 Banking

15.1 ntroduction to Cost Centres

15.2 Cost Centre Creation and management

15.3 Report center

15.4 Trial Balance

15.5 General Ledger

15.6 General Journal

15.7 Balance Sheet

15.8 Cash Flow

15.9 Income Statement

15.10 Creation and Export of Different Reports