EMPIRICAL STUDY ON LOAN’S COLLECTABILITY ON MULTIPURPOSE CONSUMER CREDIT : BANK JABAR CASE
FINAL PROJECT
By KUSUMADITA AMALIA 19004020
Undergraduate of Management Study Program School of Business and Management Institut Teknologi Bandung 2007
VALIDATION PAGE
EMPIRICAL STUDY ON LOAN’S COLLECTABILITY ON MULTIPURPOSE CONSUMER CREDIT : BANK JABAR CASE
By: KUSUMADITA AMALIA ID No: 19004020
Undergraduate of Management Study Program School of Business and Management Institut Teknologi Bandung
Validated By
( Deddy P. Koesrindartoto Ph.D ) NIP: 999 059 102
EMPIRICAL STUDY ON LOAN’S COLLECTABILITY ON MULTIPURPOSE CONSUMER CREDIT : BANK JABAR CASE KUSUMADITA AMALIA 19004020 Examination Date 8 August 2007 Graduation Date 27 October 2007 Undergraduate of Management Study Program Institut Teknologi Bandung, 2007 ABSTRACT Bank Jabar is the Local Government Bank in the West Java that has to help the development of citizen in West Java. Bank Jabar does the general bank do in their operational activities. Bank Jabar held the credit activity to increase the development of the citizen and to role the function as the Bank. The credit offered are generally divided into three that are working capital credit, investment credit and consumer credit. For working capital credit and investment credit usually proposed by company, because of that Bank can analyze the annual report of the company and the Bank has full information about its financial performance. Meanwhile, consumer credit usually proposed by individual, It result bank did not get appropriate data to analyze the financial condition of the individual and it may cause the high rate of non performing loan. This final project held to give the characteristic on the multipurpose consumer credit for Bank Jabar that is empirical analysis approach.Empirical study done by using the regression analysis of each variable with the dependent variable is the collectability of the bank. Data that will be used is consumer credit in multipurpose consumer credit primary data from the Main Branch of Bank Jabar in Bandung. Data that will be taken will be customer’s data and its performance of credit. The data include customer’s age, customer’s marital status, customer’s occupation, customer’s gender, interest loan, payment period, and principal. The final project is done by the two attempts after the process of trial and error by eliminating the variable that did not have the significant result. In the first attempt, all of the variables are inputted to the model to see the relationship to the dependent variable (collectability). The result arise when there is two variables that did not significant, those are interest and status. The second attempts done by eliminate the variable that did not significant in the model. The result shows all of the variables inputted in the second attempt are significant. Because of that, the attempt is done in the second attempt. The equation after the entire variable shows the variable indicates the significant result is: Collectability = 1.098– 0.593 Gender + 0.071 Age– 0.188 Payment period + 0.047 Principal – 2.693 z1 job – 1.052 z2 job.
Keywords: multipurpose consumer credit, collectability, Bank Jabar, empirical analysis approach, and regression linear.
i
EMPIRICAL STUDY ON LOAN’S COLLECTABILITY ON MULTIPURPOSE CONSUMER CREDIT : BANK JABAR CASE KUSUMADITA AMALIA 19004020 Tanggal Ujian Akhir 8 Agustus 2007 Tanggal Wisuda 27 Oktober 2007 Program Studi Sarjana Manajemen Institut Teknologi Bandung, 2007
ABSTRAK Bank Jabar merupakan Bank pemerintah daerah yang membantu perkembangan masyarakat di Jawa Barat. Bank Jabar melaksanakan kegiatan yang biasa dilaksanakan Bank umum dalam kegiatan sehari-harinya.Bank Janar membuka fasilitas kredit untuk meningkatkan perkembangan masyarakat serta melaksanakan fungsi dari bank Jabar itu sendiri. Kredit yang ditawarkan secara umum dapat dibagi menjadi 3 (tiga) jenis yaitu kredit modal kerja, kredit investasi dan kredit konsumsi. Kredit modal kerja dan kredit investasi biasanya diajukan oleh sebuah perusahaan, oleh karena itu bank dapat menganalisa perusahaan itu dari laporan keuangan perusahaan dan bank memiliki informasi yang lengkap tentang kinerja keuangan perusahaan itu. Tetapi, kredit konsumsi biasanya diajukan perseorangan sehingga menimbulkan bank tidak memiliki data yang cukup untuk menganalisa kondisi keuangan dari nasabah tersebut dan ini dapat menimbulkan tingginya kredit macet. Tugas akhir ini dilaksanakan untuk melihat karakteristik dari kredit konsumsi multi guna Bank Jabar dengan menggunakan pendekatan empiris. Empirical analisis akan menggunakan pendekatan regresi terhadap tiap variabel dengan variabel tidak bebas yaitu kolektibilitas bank. Data yang akan digunakan yaitu kredit konsumsi multi guna dari Cabang Utama Bank Jabar di Bandung. Data yang akan diambil berupa data nasabah dan performansi dari kredit tersebut. Tugas akhir ini selesai dalam dua percobaan setelah proses trial& error dengan mengeliminasi variabel yang tidak memiliki hasil yang signifikan terhadap model. Di percobaan pertama, semua variabel dimasukkan ke dalam model untuk melihat hubungan terhadap variabel tak bebas (kolektibilitas). Hasil menunjukkan bahwa ada dua variabel yang tidak memiliki signifikan terhadap model, yaitu bunga dan status. Percobaan kedua dilaksanakan dengan tidak memasukkan variabel yang tidak signifikan di dalam model. Hasil menunjukkan bahwa semua variabel yang dimasukkan ke dalam percobaan kedua signifikan. Karena itu, percobaan berhenti pada percobaan kedua. Persamaan setelah semua variabel menunjukan hasil yang signifikan adalah : Koletibilitas = 1.098– 0.593 Jenis Kelamin + 0.071 Usia– 0.188 Jangka waktu kredit + 0.047 Plafon – 2.693 job1 – 1.052 job2.
Kata kunci : Kredit konsumsi multiguna, kolektibilitas, Bank Jabar, studi empiris, dan linier regresi. ii
PREFACE
First, I would like to thank Allah SWT for the blessings and answering my prayers. I truly believe that what had happened to me were your way to keep me stronger. I can finish this final project is because of your blessing, permission and guidance. I would also like to thank the followings, for helping me a lot in finishing the final project: •
My supervisor, Mr. Deddy Priatmojo Koesrindartoto for the guidance, advices and support. From your suggestion about the topic, weekly consultations to maintain my progress until teach me how to be a better one. Because of him, I can finish my project on time.
•
Mr. Bangbang Purnama, the head of consumer and retail credit Bank Jabar. Thank you very much for the data given to me. Hope this final project can be useful for Bank Jabar.
•
Mrs. Sofi, Bank Jabar, without your information this final project cannot be done.
•
Mr. Iwan, Mrs. Titin and Mr. Herman from Bank Jabar that help me to get the data from Bank Jabar. Thank you for the support, info and knowledge given from you.
•
All unmentioned staff in Retail and Consumer Credit division. That help me to collect the data.
•
Mr. Deddy Kurniawan for the SPSS. Without him, I do not know how to finish this project.
•
My parents, Bambang Hartanto and Dewi Rahayu. Your pray, supports, reminders and love that result this final project can finished on time. My lovely sisters, Astarina Maulida and Amirah Deandra Diba, for their never ending support.
•
Dean Putra Irena,for the support and encourage for me. Thank you for your time in supporting the process of final project.
iii
•
My best friends, Putri, Gagay, Intan, Aulia, Winna, Benny, Alfin and Rani that every we met always ask the progress of TA that encourage me to finish it.
•
All of the 2007 students, thanks for the fantastic 3 years that we have been trough. I have learned lot of things from you all guys.
•
SBM ITB, which give me a lot of facilities to explore with. Thanks for the free internet, Wi fi that give me a lot of help to finish the final project.
•
Last but not least, the readers, thank you for reading my final project and hope my final project give more knowledge to you. As a human being, the author realized that this project is still far away from the perfect ness. The limitation of author’s capability makes this final project need more revisions and suggestions from the readers.
There maybe a lot of friends and lecturers that I can’t explain it all. Thanks for all the support given to me that this final project can be finish.
Bandung, August 2007
Kusumadita Amalia
iv
LIST OF CONTENTS
ABSTRACT………………………………………………………..
i
PREFACE...…………………………………………....………….
iii
LIST OF CONTENTS …………………………………………….
v
LIST OF FIGURES ……………….….........................................
vii
LIST OF TABLES ……….……………………………………….
viii
CHAPTER I INTRODUCTION………...………………………..
1
1.1 Background……………….. …………………….……
1
1.2 Problem Identification…………..…………………….
3
1.3 Problem Resolving Importance……………………….
3
1.4 Problem Boundaries…………………………………..
4
CHAPTER 2 THEORETICAL FOUNDATIONS………………
5
2.1 Definition of Risk……………………………………..
5
2.2 Credit………………………………………………….
5
2.2.1 Definition of Credit…………………………..
5
2.2.2 Differences of Credit………………………....
6
2.3 Credit Risk………………………………………........
6
2.4 Customer Loan Requst Process ………………...........
7
2.5 Quality of Credit.......................…………………........
7
2.6 Type on Credit Analysis………………………............
9
2.7 Personal Credit Risk..................................................
11
2.8 Özlem Özdemir’s Paper............................................
12
2.8.1. The Model....................................................
12
2.8.2. The Result...................................................
12
CHAPTER 3 METHODOLOGY………………………….……..
13
3.1 Hypotheses…………………………………………….
14
3.2 Literature Study………………………………………..
14 v
3.3 Data Collection………………………………………...
14
3.4. Data Analysis………………………………………….
15
3.5 Test Hypotheses………………………………………..
16
CHAPTER 4 DATA ANALYSIS………………….……………
17
4.1 Data Hypotheses……………………………………...
17
4.2 Data Collection……………………………………….
18
4.2.1 Descritive Statistic: Collectability………….....
19
4.2.2 Descritive Statistic: Gender……………..……
20
4.2.3 Descritive Statistic: Marital Status……...…….
20
4.2.4 Descritive Statistic: Age……………………….
21
4.2.5 Descritive Statistic: Interest…………...………
21
4.2.6 Descritive Statistic: Principal…………………..
22
4.2.7 Descritive Statistic: Payment Period…………..
22
4.2.8 Descritive Statistic: Job Type………………….
23
4.3 Dummy Variable……………………………….……...
24
4.4 Data Analysis...……………………………….…….
25
4.4.1 The First Attempt…………………….….…….
25
4.4.2 The Second Attempt……………………….….
28
4.5 Test Hypotheses……………………………………….
31
CHAPTER 5 CLOSURE......……………………...............……..
33
5.1 Conclusion…………………………………………….
33
5.2 Suggestion…………………………………………….
34
REFERENCES ……………………………………………………
37
A SE No.5/21/DPNP..........................................................
38
B Lampiran SE No.5/21/DPNP...........................................
44
vi
LIST OF FIGURES
Figure 2.1 Collectability Term....................………………………..
7
Figure 2.2 Customer Loan Request Process………………………..
7
Figure 3.1 Methodology……………………………………………
13
Figure 4.1 Collectability……………………………………………
20
Figure 4.2 Gender………………………………………………….
20
Figure 4.3 Marital Status…………….……………………………..
21
Figure 4.4 Age……………………………………………………..
21
Figure 4.5 Interest………………………………………………….
22
Figure 4.6 Principal………………………………………………..
22
Figure 4.7 Payment Period…………………………………………
23
Figure 4.8 Job Type……………………………………………….
24
Figure 5.1 Model Result Compared To Collectability......................
33
vii
LIST OF TABLES
Table 2.1 Collectability Description………….…………………….
8
Table 4.1 the Hypotheses Table…………………………………….
18
Table 4.2 Dummy Variable Input for Gender and Status…………..
24
Table 4.3 Dummy Variable Input for Job Type……………………..
25
Table 4.4 Model Summary for the First Attempt……………………. 26 Table 4.5 ANOVA for the First Attempt…………………………….. 27 Table 4.6 Coefficients for the First Attempt…………………………
27
Table 4.7 Model Summary for the Second Attempt…………………
29
Table 4.8 ANOVA for the Second Attempt…………………………
29
Table 4.9 Coefficients Result For the Second Attempt……………...
30
Table 5.1 T Value of the Model…………………………………….
34
viii
