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 = .100 per unit
|
|
6. Calculate EMI from the following information
Housing Loan Amount 30,00,000 ,
Down payment 4,00,000
Interest 7.5%
Maturity Period 20 years.
7. Calculate Depreciation using Straight Line and Written Down Value Method
Cost of an Asset 5,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 20,000. Calculate the total under the following circumstances. If the direct wages is (1) 24,000 (2) 28,000 (3) 32,000.
Prepare the Scenario Summary:
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. |
6,00,000 |
7,50,000 |
5,50,000 |
6,50,000 |
? |