
Wednesday, January 30, 2008
Menghitung Cicilan KPR

Pasti ada rumus gampangnya, soalnya mas yang di marketingnya developer bisa menghitung pake kalkulator biasa.Tapi aku lum bisa menemukan cara gampangnya juga.
Akhirnya pake excel dech, pake fungsi PMT yang ada di excel. Gini caranya:
masuk Excel, insert function, financial function
Masukkan nilai seperti gambar di atas.
Jadi untuk kredit sebesar 135000000, bunga 9.99%, periode cicilan 10 tahun, makan cicilannya sekitar 1784000/bulan.
Formula lengkapnya ada di http://www.kbapps.com/finance.html
PV * ( 1 + i )^N = PMT * [ ( 1 + i )^N - 1 ] / i
PMT= [PV * ( 1 + i )^N ]/{[ ( 1 + i )^N - 1 ] / i}
Tuesday, January 29, 2008
Wednesday, January 23, 2008
Permata Depok Regency
Daftar Harga per 23 Januari 08Type: Jade
LB/ LT: 30/ 72
Blok: E19-E23
Harga Jual: 150.000.000 IDR
Kredit KPR: 135.000.ooo IDR
Harga jual sudah termasuk : IMB, listrik, Pompa Air, AJB & Balik Nama, PPN
Harga Jual belum termasuk : Biaya realisasi KPR, Akte SKMHT, Biaya strategis 5.500.000 (hook, hdap taman, jalan utama), Harga kelebihan tanah, materai, BPHTB, biaya pindah kavling 2.000.000, biaya ready stock 3.300.000
Monday, November 5, 2007
Virtual Library New Concept
This Virtual Library concept is different from the virtual library that we used to know. Usually it is an online library with online book (e-book). But in here our concept is: a new way to share books (hardcopy books) with our community and improving reading habit without a physical common place to store the books. The word virtual come from the virtual book storage. All that we kept is only the book list. The books will be physically in the owner own places. The book traffic will be arranged by the book controller with the spesified rules. Detailed rules will be kept ini FAQ section.
This Virtual Library was build to improve the habit of reading in our closest society, our office. By sharing our book list with some review and recommendation on the book that we have already read, we wish it will encourage other to be interested in that book. Especially because of the easy access to the book (just a click away) and it’s free of charge anyway.
The Virtual Library was also built to accommodate the spirit of sharing between book lovers. To spread the spirit of sharing, start from sharing our book and knowledge with others, we wish the spirit will continue to spread to others part of our life..
“Every moment a book waits to tell you something…”
This Virtual Library was build to improve the habit of reading in our closest society, our office. By sharing our book list with some review and recommendation on the book that we have already read, we wish it will encourage other to be interested in that book. Especially because of the easy access to the book (just a click away) and it’s free of charge anyway.
The Virtual Library was also built to accommodate the spirit of sharing between book lovers. To spread the spirit of sharing, start from sharing our book and knowledge with others, we wish the spirit will continue to spread to others part of our life..
“Every moment a book waits to tell you something…”
Subscribe to:
Posts (Atom)


