I

Accounting Concepts and Conventions

Accounting definition- Objectives-Uses and Limitations - Principles Concepts and Conventions- Journal-Ledger-Trial balance

17

II

Subsidiary Books

Purchase Books- Sales Book- Purchase Returns Book- Sales Returns Book- Bills Payable Book-Bills Receivable Book- Cash Book-Double Column, Triple Column Cash Book- Petty Cash Book

17

III

Bank Reconciliation Statement and Rectification of Errors

Bank Reconciliation  Statement  –  Debit Balance  –  Overdraft Balance Rectification of Errors – Suspense Account 

18

IV

Depreciation and Bill of Exchange

Depreciation – Methods of Depreciation (Theory) – Straight Line Method – Diminishing Balance Method – Sinking Fund Method – Annuity Method – Insurance Policy Method – Change in Method of Depreciation Account – Provision for Depreciation Account –Bill  of Exchange

19

V

Final Accounts

Final Accounts of Sole Trading Concerns- Trading Account – Profit and Loss Account – Balance Sheet – Adjustment Entries

19


UNIT

Content

No. of

 Hours

I

Money and Banking

Introduction  to  Money  -  Kinds  of  Money  -  Functions  of  Money  - Significance of Money - Introduction to Banking - Origin, Growth and Development  of  Banking  -  Role  and  Functions  of  Banks  -  Banking Structure - Indigenous Bankers - Foreign Banks - Small and Payment Banks – Non Banking Finance Companies-RRB-Co-operative Banks.

17

II

Banker and Customer

Banker - Customer - Relationship Between Bank and Customer – Types of Deposits - Account Opening - Know Your Customer Guidelines – Pass Book - Special Types of Customers.

17

III

Loans and Advances

Secured  and  Unsecured  Advances  -  Principles  of  Sound  Lending  - Modes of Charging Security Lien - Pledge - Mortgage - Assignment - Hypothecation - Unsecured Advances - Advances against Goods, Titles and Stock Exchange Securities.

18

IV

Negotiable Instruments and Payment Systems

Characteristics  -  Types  -Cheque  -   Cheque  Truncation  System   - Material Alteration - Crossing of Cheque Endorsement - Paying Banker - Statutory Protection  to  a  Paying  Banker  -  Payment  in  Due  course  - Holder  in  Due  course  -  Collecting  Banker  -  Statutory  Protection  to Collecting Banker - Duties of Collecting Banker. Payment Systems- Overview of Global and Domestic payment System- NFS-RTGS-NEFT-IMPS-AEPS-NUUP-BHIM.

19

V

Reserve Bank of India (RBI) and Financial Inclusion

Reserve Bank of India - Functions - Regulatory Powers – Organizational set up - Credit Control Measures - Qualitative and Quantitative Control - CRR, SLR, Repo rate, Reverse Repo rate, Bank rate, Prime Lending rate. Financial Inclusion – Introduction- Objectives- Schemes-PMJDY-APY-SSY.

19

References

Text Books

1.     Gordon  E., and Natrajan  K.,  “Banking  Law  Theory  and  Practices”,25th  Ed., Himalaya Publishing House, Mumbai, 2016.

2.     Jain  P.C.  and  Verma.S.S.,  “Money & Financial System”, 1st Ed., Sahitya Publications, Agra, 2015.

Reference Books

1.     Kandasami  K.P,  Parameswaran.R  &  Natrajan.,  “Banking Law  and Practices”, 4th revised Ed., S.Chand Publishers, New Delhi, 2016.

2.     Sundharam K.P.M. and Varshney P.N., “Banking Theory Law and Practice”, 20th revised Ed., Sultan Chand Publishers, New Delhi, 2014.


Exercise No. 1

Opening of bank account

a)     As an individual you are going to open a Savings bank account in a bank by depositing Rs. 1,000. Fill up the savings bank account  Opening form of a Nationalized bank

b)     Fill up the KYC form

Exercise No. 2

Bank Account- operating procedure

Fill up the following forms

a)     Pay in slip for deposits of Rs. 15,000

b)     Withdrawal slip for Rs. 12,000 pay Rs.1,000 by cheque

c)     Challan for taking demand draft of Rs. 1,000

d)     Deposit of Rs. 50,000 by using FD form

Exercise No. 3

E- Banking Procedure

a)     Fill up the forms relating to opening of a current account in a bank.

b)     Fill up the ATM card application form

ExerciseNo.4

Educational Loan & Fund Transfer Forms

a)     Fill up the form to obtaining Educational loan of Rs. 5,00,000.

b)     Visit any nearest bank branch & collect sample document forms for different modes of transferring fund.

ExerciseNo.5

Preparation of Feasibility Report & obtaining Bank Loan

Prepare  a Feasibility Report to get a loan from a bank for  starting new business


Introduction to MS Excel

 

               Spread sheets - Introduction - Concepts - Excel features - Entering and editing data - Addressing techniques – Simple formulas & functions -Formatting cells - Aligning cells - Copying and linking cell and sheets - Working with fill methods - Data analysis - Charts - Types of charts - Converting data to chart - Macros - Forms - Pivot table

 

Exercises

 

1.            Prepare an Excel sheet and apply the following statistical functions to analyze the data

a) Mean, Median, Mode

b) Standard Deviation

c) Time Series 

 

2.            Using EXCEL prepare a table for

a) Employees payroll

b) Sales data

c) Students marks and perform the following functions

(Total, Average, Percentage, conditional sum and show the results in chart)

 

3.            Create Mail merge using an Excel spreadsheet

 

4.            Implement the concept of macros using Excel.

 

5.            Calculate incentive using IF condition from the following sales Representative data.

Standard output = 500 Units, Selling Price = INR.100 per unit

 

Name

Quantity

Range

Anu

300

< 60% = 0%

Ram

500

60% -75%=5%

John

600

76%-90%=7.5%

Harish

1000

91%-100%=10%

Yogesh

750

>100%=20%

 

6.            Calculate EMI from the following information

           Housing Loan Amount INR30,00,000 ,

           Down payment INR4,00,000

            Interest 7.5%            

Maturity Period 20 years.


 

7.            Calculate Depreciation using Straight Line and Written Down Value Method

           Cost of an Asset INR5,00,000

           Estimated life of an Asset 7 years

           Rate of Depreciation 10%

 

8.            Calculate Average Due date and Interest from the following information.

           A partner has withdrawn the following sums of money during the half year ending

           30-6-18

Jan 15

*             300

April 20

*             400

Feb 18

*             250

May 16

*             300

Mar 10

*             150

June 18

*             500

Mar 26

*             200

Interest Rate

8%

 

9.            Scenario Change  - Value Change

            The following is the Total cost for direct wages being INR 20,000.  Calculate the total       under the            following circumstances. If the direct wages is (1) INR 24,000 (2) INR 28,000   (3) INR 32,000. 

            Prepare the Scenario Summary:                                                                 

                                                                                                            INR

                                Direct Material                                                       1,00,000

                                Direct Wages                                                            20,000

                                Prime cost                                                               1,20,000

                                Add:  Factory Expenses- 20% of Direct wages          4,000

                                Factory cost                                                            1,24,000

                                Add:  Distribution expenses 5% of Direct wages       1,000

                                Total cost                                                                1,25,000

 

10.          Sales Forecasting

Year

2014

2015

2016

2017

2018

Sales in.INR

6,00,000

7,50,000

5,50,000

6,50,000

?