DESIGN AND IMPLEMENTATION OF A COMPUTERIZED SYSTEM FOR AUTOMATED LOAN LENDING
ABSTRACT
Loan Lending is the principal business activity for most commercial banks. The loan portfolio is typically the largest asset and the predominate source of revenue. Many banks do not have an automated system specifically to manage loan lending information. This situation makes it difficult to instantly confirm loan information or get reports when needed. To solve this problem, a loan lending management system is needed to aid the easy capturing and updating of loan information of customers and verification of loan lending records. The aim of the study is to develop a loan lending record management system The following are the objectives of the study which is to develop a system that will; aid registration of loan records, serve a s a database of loan records, and facilitate easy retrieval of loan records. The methodology adopted in this study is the structure system analysis and design methodology (SSADM) which is a technical approach for analyzing and designing an application or system by applying object oriented programming as well as visual modeling throughout the software development. The programming language used is HTML, CSS, JAVASCRIPT, PHP, SQL and JQUERY. The reason why web programming languages was used is because, it is platform independent and it is a web based application. Based on the findings of this study, recommendations made are that constant monitoring of the activities with the designated automated loan lending management software application, it is necessary to determine their level of compliance while adequate training should be provided for the recruitment of staff to enhance their efficiency and productivity.
CHAPTER ONE
1.1 Introduction
Lending is the principal business activity for most commercial banks. The loan portfolio is typically the largest asset and the predominate source of revenue. As such, it is one of the greatest sources of risk to a bank’s safety and soundness. Whether due to lax credit standards, poor portfolio risk management, or weakness in the economy, loan portfolio problems have historically been the major cause of bank losses and failures. Effective management of the loan portfolio and the credit function is fundamental to a bank’s safety and soundness. Loan portfolio management (LPM) is the process by which risks that are inherent in the credit process are managed and controlled. Because review of the LPM process is so important, it is a primary supervisory activity. Assessing LPM involves evaluating the steps bank management takes to identify and control risk throughout the credit process. The assessment focuses on what management does to identify issues before they become problems. This booklet, written for the benefit of both examiners and bankers, discusses the elements of an effective LPM process. It emphasizes that the identification and management of risk among groups of loans may be at least as important as the risk inherent in individual loans. For decades, good loan portfolio managers have concentrated most of their effort on prudently approving loans and carefully monitoring loan performance. Although these activities continue to be mainstays of loan portfolio management, analysis of past credit problems, such as those associated with oil and gas lending, agricultural lending, and commercial real estate lending in the 1980s, has made it clear that portfolio managers should do more. Traditional practices rely too much on trailing indicators of credit quality such as delinquency, non-accrual, and risk rating trends. Banks have found that these indicators do not provide sufficient lead time for corrective action when there is a systemic increase in risk. credit risk profile and with more tools to analyze and control the risk
1.2 Background of Study
A loan is a type of debt. Like all debt instruments, a loan entails the redistribution of financial assets over time, between the lender and the borrower. In a loan, the borrower initially receives or borrows an amount of money, called the principal, from the lender, and is obligated to pay back or repay an equal amount of money to the lender at a later time. Typically, the money is paid back in regular installments, or partial repayments; in an annuity, each installment is the same amount. The loan is generally provided at a cost, referred to as interest on the debt, which provides an incentive for the lender to engage in the loan. In a legal loan, each of these obligations and restrictions is enforced by contract, which can also place the borrower under additional restrictions known as loan covenants. Although this article focuses on monetary loans, in practice any material object might be lent. Acting as a provider of loans is one of the principal tasks for financial institutions. For other institutions, issuing of debt contracts such as bonds is a typical source of funding.
1.3 Statement of Problem
Many banks do not have an automated system specifically to manage loan lending information. This situation makes it difficult to instantly confirm loan information or get reports when needed. To solve this problem, a loan lending management system is needed to aid the easy capturing and updating of loan information of customers and verification of loan lending records.
1.4 Aim and Objectives of the Study
The aim of the study is to develop a loan lending record management system The following are the objectives of the study;
- To develop a system that will aid registration of loan records
- To develop a system that will serve a s a database of loan records
- To develop a system that will facilitate easy retrieval of loan records
1.5 Scope of the Study
This study covers automated loan lending management system using Akwa Savings and loans, Ikot Ekpene as a case study.
1.6 Limitations of the Study
During the course of this study, many things militated against its completion, some of which are:
- Time Constraint: The time frame given to accomplish this project was very short due to school academic calendar and it was carried out under pressure which made the researcher not to implement some necessary features.
- Establishment Policies: Establishment policies posed a serious limitation as most staffs are not ready to release information needed for this project work. There were lots of information needed from the staffs of this institution to enhance the study which took them time to release or they did not release at all for security purposes, hence the scope was reduced.
- Research material: availability of research material is a major setback to the scope of the study.
- Frequent power failure: This made the researcher append more money on fuel to ensure sustainable power.
1.7 Significance of the study
The following are the relevance of the research work:
- It will provide an automated system that will aid the easy recording of loan lending information.
- It will serve as a management information system.
- The study will also serve as a useful reference material to other researchers seeking for information pertaining the study.
1.8 Organization of the Research
This research work is organized into five chapters.
Chapter one is concerned with the introduction of the research study and it presents the preliminaries, theoretical background, statement of the problem, aim and objectives of the study, significance of the study, scope of the study, organization of the research and definition of terms.
Chapter two focuses on the literature review, the contributions of other scholars on the subject matter is discussed.
Chapter three is concerned with the system analysis and design. It analyzes the present system to identify the problems and provides information on the advantages and disadvantages of the proposed system. The system design is also presented in this chapter.
Chapter four presents the system implementation and documentation. The choice of programming language, analysis of modules, choice of programming language and system requirements for implementation.
Chapter five focuses on the summary, conclusion and recommendations are provided in this chapter based on the study carried out.
1.9 Definition of Terms
Debt: An amount of money, a service, or an item of property that is owed to somebody
Loan: An amount of money given to somebody on the condition that it will be paid back later.
Lending: To allow a person or business to use a sum of money for a particular period of time, usually on condition that a charge interest is paid in return
Guarantor: Somebody who gives a guarantee, especially a formal promise to be responsible for somebody else’s debts or obligations.
CHAPTER TWO
2.0 Literature Review
2.1 Introduction
The review of relevant literature is the main topic of this chapter. A literature review covers theoretical and methodological contributions to a certain issue in addition to the state of knowledge at the time of writing. It provides information about the state of the art in relation to the subject you are writing about. It examines the body of work on the chosen subject. The literature evaluation in this study comprises the …
Procedure for Downloading the PDF (Docx) Material
Design and Implementation of a Computerized System for Automated Loan Lending can be downloaded by requesting the full set of materials at the project or seminar cost. The document will be sent via Microsoft Word (MS-Word) format via WhatsApp (e-mail) following payment confirmation.
| Seminar Material Cost ₦3,000 | Project Material Cost ₦5,000 |
Request Complete Material
 | Click here to request the Complete Material via WhatsApp including;
|
TABLE OF CONTENTSPRELIMINARY PAGES
- Title page
- Approval page
- Dedication
- Acknowledgement
- Table of Contents
- Abstract
INTRODUCTION
- 1.1 Introduction
- 1.2 Background of Study
- 1.3 Statement of Problem
- 1.4 Aim and Objectives of the Study
- 1.5 Scope of the Study
- 1.6 Limitations of the study
- 1.7 Significance of the study
- 1.8 Organization of the Research
- 1.9 Definition of Terms
LITERATURE REVIEW
- 2.1 Introduction
- 2.2 Concept of Loan Management
- 2.2.1 Personal loan
- 2.2.2 Unsecured Loans
- 2.2.3 Loan Demand
- 2.2.4 Subsidized Loan
- 2.2.5 Concessional Loan
- 2.2.6 Target markets Loan
- 2.3 Advantages and Disadvantages of a Loan
- 2.4 Types of Loan
- 2.5 Concept of Loan Lending
- 2.5 Benefits of Borrowing a Loan
- 2.6 Brief History Of Lending
- 2.7 Theoretical Framework
- 2.8 Loan Application Process
- 2.8.1 Loan Application
- 2.9 Areas of Obtaining a Personal Loan
SYSTEM ANALYSIS AND DESIGN
- 3.1 Methodology Adopted
- 3.2 Process for Analysis for SSADM & SSADM Technique
- 3.3 Analysis of the Existing System
- 3.3.1 Diagram of the Existing System
- 3.3.2 Weakness of the existing System
- 3.4 Analysis of the Proposed System
- 3.4.1 Advantages of the Proposed System
- 3.5 Justification of the Proposed System
- 3.6 High Level Model of the Proposed System
SYSTEM DESIGN AND IMPLEMENTATION
- 4.1 Objectives of the Design
- 4.2 Control Center / Overall Dataflow Diagram
- 4.3 The Submenus / Subsystems
- 4.4 System Specification
- 4.4.1 Database Design Specification
- 4.4.2 Input and Output Format
- 4.4.2 Algorithm
- 4.4.3 Data Dictionary
- 4.5 System Flow
- 4.6 System Implementation
- 4.6.1 Proposed System Requirement
- 4.7.1.1 Hardware Requirements
- 4.7.1.2 Software Requirements
- 4.7.2 Program Development
- 4.7.2.1 Choice of programming environment
- 4.7.3 System Testing
- 4.7.3.1 Test Plan
- 4.7.3.2 Test Data
- 4.7.3.3 Actual test Result Versus Expected Test Result
- 4.7.3.4 Performance Evaluation
- 4.7.3.5 Limitation of the System
- 4.7.4 System Security
- 4.7.5 Training
- 4.7.6 Documentation
- 4.7.7 System Conversion
- 4.7.7.1 Changeover Procedure
- 4.7.7.2 Recommended Procedure
SUMMARY, CONCLUSION AND RECOMMENDATIONS
- 5.1 Summary
- 5.2 Conclusion
- 5.3 Recommendation
- 5.3.1 Application Areas
- 5.3.2 Suggestion for Further Research
REFERENCES
APPENDIX A - "SOURCE CODE"
APPENDIX B - "OBJECT PROGRAM"
Disclaimer for Complete Material Utilization
The displayed research work titled "Design and Implementation of a Computerized System for Automated Loan Lending" is stated as a research guideline towards accomplishing your assigned project / seminar research work. All the research materials on this website are ONLY for research purposes and should be used as a guideline in developing your research work. For no reason should you copy word for word as projectlist.com.ng will not be liable for any who copied the material. By ordering the complete research guideline, it signifies that you've accepted our terms of service.
PRELIMINARY PAGES
- Title page
- Approval page
- Dedication
- Acknowledgement
- Table of Contents
- Abstract
INTRODUCTION
- 1.1 Introduction
- 1.2 Background of Study
- 1.3 Statement of Problem
- 1.4 Aim and Objectives of the Study
- 1.5 Scope of the Study
- 1.6 Limitations of the study
- 1.7 Significance of the study
- 1.8 Organization of the Research
- 1.9 Definition of Terms
LITERATURE REVIEW
- 2.1 Introduction
- 2.2 Concept of Loan Management
- 2.2.1 Personal loan
- 2.2.2 Unsecured Loans
- 2.2.3 Loan Demand
- 2.2.4 Subsidized Loan
- 2.2.5 Concessional Loan
- 2.2.6 Target markets Loan
- 2.3 Advantages and Disadvantages of a Loan
- 2.4 Types of Loan
- 2.5 Concept of Loan Lending
- 2.5 Benefits of Borrowing a Loan
- 2.6 Brief History Of Lending
- 2.7 Theoretical Framework
- 2.8 Loan Application Process
- 2.8.1 Loan Application
- 2.9 Areas of Obtaining a Personal Loan
SYSTEM ANALYSIS AND DESIGN
- 3.1 Methodology Adopted
- 3.2 Process for Analysis for SSADM & SSADM Technique
- 3.3 Analysis of the Existing System
- 3.3.1 Diagram of the Existing System
- 3.3.2 Weakness of the existing System
- 3.4 Analysis of the Proposed System
- 3.4.1 Advantages of the Proposed System
- 3.5 Justification of the Proposed System
- 3.6 High Level Model of the Proposed System
SYSTEM DESIGN AND IMPLEMENTATION
- 4.1 Objectives of the Design
- 4.2 Control Center / Overall Dataflow Diagram
- 4.3 The Submenus / Subsystems
- 4.4 System Specification
- 4.4.1 Database Design Specification
- 4.4.2 Input and Output Format
- 4.4.2 Algorithm
- 4.4.3 Data Dictionary
- 4.5 System Flow
- 4.6 System Implementation
- 4.6.1 Proposed System Requirement
- 4.7.1.1 Hardware Requirements
- 4.7.1.2 Software Requirements
- 4.7.2 Program Development
- 4.7.2.1 Choice of programming environment
- 4.7.3 System Testing
- 4.7.3.1 Test Plan
- 4.7.3.2 Test Data
- 4.7.3.3 Actual test Result Versus Expected Test Result
- 4.7.3.4 Performance Evaluation
- 4.7.3.5 Limitation of the System
- 4.7.4 System Security
- 4.7.5 Training
- 4.7.6 Documentation
- 4.7.7 System Conversion
- 4.7.7.1 Changeover Procedure
- 4.7.7.2 Recommended Procedure
SUMMARY, CONCLUSION AND RECOMMENDATIONS
- 5.1 Summary
- 5.2 Conclusion
- 5.3 Recommendation
- 5.3.1 Application Areas
- 5.3.2 Suggestion for Further Research
REFERENCES
APPENDIX A - "SOURCE CODE"
APPENDIX B - "OBJECT PROGRAM"
Disclaimer for Complete Material Utilization
The displayed research work titled "Design and Implementation of a Computerized System for Automated Loan Lending" is stated as a research guideline towards accomplishing your assigned project / seminar research work. All the research materials on this website are ONLY for research purposes and should be used as a guideline in developing your research work. For no reason should you copy word for word as projectlist.com.ng will not be liable for any who copied the material. By ordering the complete research guideline, it signifies that you've accepted our terms of service.
Frequently Asked Questions (FAQ)
Can the material for “The Influence of School Records on the Academic Performance of Secondary School Students” be used as a guide for Education Project?
Yes it can be used — The study was carried out to investigate the Influence of School Records on the Academic Performance of Secondary School Students. In achieving this aim, the following specific objectives were laid out to examine the school records kept and maintenance processes of the records in Secondary Schools, examine the effect of school records on secondary school students’ academic performance and examine the challenges associated with the keeping of school records in Chikun LGA, Kaduna state. The research design used in this report is descriptive design, utilizing questionnaire method to obtain information from the respondents for this project. A total of 133 (one hundred and thirty three) respondents were selected for this study to represent the entire population of the study. For …
Can this topic “Implementation of Sorting Algorithms” be used for Computer Science (CS) Project?
Yes it can be utilized for research — This research work took theoretical and empirical studies that have been done over the past years on sorting algorithms and its variants. The study includes a comparative sorting algorithms (i.e. Bubble sort, shell sort, straight insertion sort quick sort, simple sort etc.) the same criteria such as coding memory space used meaning efficiency as in the time used by the computer argument on the number of comparison. Data flow diagrams and process to evaluate the performance of these sorting techniques. The programming language used to implement these sorting algorithms is BASIC. The various chapter in this research work is logically arranged to reflect in each stage in the research process, the adopting chapters ranges from introduction literature review, systems investigation/analysis, system …
Can the material for “Critical Analysis of the Performance of National Economic Empowerment and Development Strategy Needs on the Nigerian Economy” be used as a guide for Statistics Project?
Yes it can be used — This research work, “Critical analysis of the performance of the National Economics Empowerment and Development Strategy (NEEDS) on the Nigeria Economy, (A Case Study of Enugu State)” seeks to look at the major causes of Nigerians Economic Misfortunes and his is greatly attributable to the poor industrial capacity utilization, massive unemployment and underemployment, high late of inflation, high poverty rate, poor wealth distribution, Mono-cultural economy (oil) high rate of corruption, etc. The main objectives of this research are to find out if NEEDS has made any impact on the Enugu State and to analyses such impacts. To achieve the above stated objectives, a systematic research methodology was adopted. Good research questions were used on the sample such as the government, the …
Can this topic “Design and Implementation of Meteorological System” be used for Computer Science (CS) Project?
Yes it can be utilized for research — The benefit of being able to use managerial techniques and analytical methods coupled with the innovative nature of the computer cannot be overemphasized. The main purpose of this project is to highlight the need for design and implementation of a meteorological service. In the course of this work the author conducted personal interview, examined the organizations document and observed staff at work. This project focuses on the need for easy storage and retrieval of meteorological files so as to obtain particular information easily and to update the data at any given time. The problems and limitation of the manual system were identified in the course of this work. The computerized system was designed to help in minimizing some of the problems inherent …
Can the material for “The Impact of Company Income Tax Revenue on the Developing Economies; the Nigeria Experience” be used as a guide for Economics Project?
Yes it can be used — The aim of this study was to examine the impact of company income tax on the developing economies using a case study of the Nigerian experience, while looking at the specific objectives which include: assess the impact of companies’ income tax on economic growth of Nigeria; ascertain the influence of Petroleum Profit Tax on economic growth of Nigeria; examine the impact of custom and excise duties on economic growth of Nigeria and determine the impact of VAT on the economic growth of Nigeria. Ex -post facto and survey research designs was adopted in the work to investigate reasons for consistent low tax contributions to GDP in Nigeria over a period of 35 years. Secondary data were obtained from FIRS and Bureau …
Can the material for “Design and Implementation of a Web-Based Survey Management System” be used as a guide for Computer Science (CS) Project?
Yes it can be used — The paper aims at designing and implementing a web enabled survey system that can used by research institutions in gathering information from respondents used in a research study. The need to gather data in a secure, cost-effective and effective way remains a major challenge for most research and tertiary institutions in Nigeria. This web based survey system aims at aiding researchers in gathering data from a large number of respondents in a cost-effective way, eliminating errors and data redundancy. The administrator post a questionnaires on the web application and gives the links out to his/her respondents to fill the questionnaires at the comfort of their homes and offices. The system is designed with Asp.net, bootstrap, CSS and MYSQL technologies. …
Can the material for “Bacteriology in Ice Cream” be used as a guide for Science Laboratory Technology (SLT) Project?
Yes it can be used — This research paper examines the bacteriology in ice cream. In achieving this aim, the following specific objectives were set out to determine the Proximate Analysis of Ice-cream Determination of Moisture Content, examine the Ash, Protein, Crude Fat, Crude Fiber Content, and Carbohydrate Content, assess the microbiological examination of Ice Cream Isolation of Bacteria from Ice Cream, and examine of Total Bacteria, and Coliform Bacteria from Ice Cream. Ice cream is a frozen dairy product made by freezing the ice cream mix with agitation. It is composed of a mixture of food ingredients like milk products, sweetening materials, stabilizers, colours, flavours, and egg products. Investigation reveals the following problems of the existing bacteriology in ice cream research work; a lot of …
Can the material for “Evaluation of the Immunization Status of Children in a Rural Suburb of Anambra State” be used as a guide for Public Health Project?
Yes it can be used — Background Childhood immunization is a cost effective public health strategy. Expanded Programme on immunization (EPI) services have been provided in Anambra East local government area of Anambra State mainly through the health facilities in the LGA. Objective The objective of this survey was to assess vaccination coverage and its determinants in this rural suburb in Nigeria. Methods A cross-sectional survey was conducted in October 2010, which included the use of interviewer-administered questionnaire to assess knowledge of mothers of children aged 12-23 months on childhood immunization and vaccination coverage of the children. Survey participants were selected using a multistage sampling method. Vaccination coverage was assessed by vaccination card and material history. A child was said to be fully vaccinated if he or she had received all …
Is the topic “Importance of Utazi (Gongronema Latifolium) and Nchuanwu (Ocimum Gratissium) in Human Body” recommended for Food Science and Technology (FT) Project?
Yes it is highly recommended — The study determined the vitamin composition of Utazi and Nchuanwu leaf juice (vitamin A and C). In achieving this aim, the following specific objectives were laid out to determine the proximate, mineral composition, acid and fatty of Utazi and Nchuanwu. The research work was focused on the possible vitamin composition of Utazi (Gongronemalatifolium) and Nchuanwu (Ocimumgratissimum) leaf juice. Here, it was only the vitamin A and C that were scientifically tested for. Where upon, it was discovered that Utazi had 1.14mglml of vitamin A and 34:61mg1 100m1 of vitamin C, while Nchuanwu had 2.14mglm1 of vitamin A and 30.76mg1 100m1 of vitamin C. From the result gotten, it shows that Utazi and Nchanwu are good sources of vitamin A and …
Can the material for “The Impact of Bank Loans on SMEs in Nigeria” be used as a guide for Entrepreneurship Project?
Yes it can be used — Small and Medium enterprises are the catalyst for economic growth in most economies thus, the fundamental objective of this study is to investigate the impact of loans on Small and Medium Enterprises (SMEs) in Nigeria. So that the ability of SMEs to develop positively and drive economic growth in the Nigeria will become real. Simple random sampling technique was employed in selecting the 100 SMEs that constituted the sample size of the research. Structured questionnaire was designed to facilitate the acquisition of relevant data which was used for analysis. Descriptive statistics which involves simple percentage graphical charts and illustrations was tactically applied in data presentations and analysis. The findings of the study reveal that significant number of the SMEs benefitted …