KREDIT excel fungtion

DAFTAR HARGA BARANG (KREDIT) ^_^
No.	Nama	Tipe barang	Harga	Jangka waktu	Suku bunga	Angsuran/	Total bayar	Laba
	Merek/Barang			(bulan)	(%)	bulan
1	Nokia	3110c	Rp900,000	3	2%	Rp312,079	Rp936,238	Rp36,238
2	Nokia	Aeon	Rp1,200,000	3	2%	Rp416,106	Rp1,248,317	Rp48,317
3	Nokia	E72	Rp4,000,000	4	2%	Rp1,050,495	Rp4,201,980	Rp201,980
4	Nokia	N98	Rp5,000,000	5	3%	Rp1,091,773	Rp5,458,864	Rp458,864
5	Nokia	C3	Rp800,000	2	1%	Rp406,010	Rp812,020	Rp12,020
6	Samsung	GalaxyMini	Rp1,500,000	3	2%	Rp520,132	Rp1,560,396	Rp60,396
7	Samsung	Qorby	Rp800,000	2	1%	Rp406,010	Rp812,020	Rp12,020
8	Samsung	GalaxyAce	Rp4,000,000	4	2%	Rp1,050,495	Rp4,201,980	Rp201,980
9	Samsung	GalaxySII	Rp8,000,000	8	3%	Rp1,139,651	Rp9,117,209	Rp1,117,209
10	Samsung	GalaxyWhite	Rp3,600,000	4	2%	Rp945,446	Rp3,781,782	Rp181,782
Ana	90	90
Vina	80	85
Flupy	65	70
Kenji	50	60
Yura	80	80
Ailey	75	80
Aflee	55	60
Toni	60	70
Ana	Vina	Flupy	Kenji	Yura	Ailey	Aflee	Toni
90	80	65	50	80	75	55	60
90	85	70	60	80	80	60	70