Docstoc

LPP-LKP SPP Desa SUKASLAMET

Document Sample
LPP-LKP SPP Desa SUKASLAMET Powered By Docstoc
					       UPK                                        KROYA
       Desa                                       SUKASLAMET


       PEMBAYARAN BUNGA DAN ANGSURAN POKOK           KREDIT SPP
No.          Kelompok SPP     Alokasi                Bunga                       Pokok
                               Kredit                Dibayar    Tunggakan        Dibayar
   1   Kel. Mawar          Rp     3,300,000 Rp          612,000 Rp      -   Rp     3,300,000
   2   Kel. Salak          Rp     6,000,000 Rp        1,200,000 Rp      -   Rp     6,000,000
   3   Kel. Sawo PPK II    Rp     5,300,000 Rp        1,060,000 Rp      -   Rp     5,300,000
   4   Kel. Dahlia PPK II  Rp     4,200,000 Rp          840,000 Rp      -   Rp     4,200,000
   5   Kel.Mawar(Perg)     Rp     5,100,000 Rp        1,020,000 Rp      -   Rp     5,100,000
   6   Kel. Salak(Perg)    Rp     6,400,000 Rp        1,280,000 Rp      -   Rp     6,400,000
   7   Kel. Pisang PPK III Rp     9,500,000 Rp        1,729,000 Rp      -   Rp     9,500,000
   8   Kel.Mawar(Perg)     Rp     8,100,000 Rp        1,458,000 Rp      -   Rp     8,100,000
   9   Kel. Salak(Perg)    Rp     7,100,000 Rp        1,278,000 Rp      -   Rp     7,100,000
  10   Kel. Sawo PPK II    Rp     6,800,000 Rp        1,224,000 Rp      -   Rp     6,800,000
  11   Kel. Pisang PPK III Rp    12,800,000 Rp        1,463,400 Rp      -   Rp    11,890,000
  12   Kel. Sawo PPK II    Rp     9,900,000 Rp        1,394,000 Rp      -   Rp     9,900,000
  13   Kel. Salak(Perg)    Rp    10,300,000 Rp        1,854,000 Rp      -   Rp    10,300,000
  14   Kel. Dahlia PPK II  Rp     6,400,000 Rp          460,800 Rp      -   Rp     3,220,000
  15   Kel.Mawar(Perg)     Rp    10,900,000 Rp          588,600 Rp      -   Rp     3,270,000
  16   AL-BAROKAH          Rp    12,500,000 Rp        1,350,000 Rp      -   Rp    12,500,000
  17   NURUL HIKMAH        Rp    11,250,000 Rp        2,025,000 Rp      -   Rp    11,250,000
  18   Kel. Sawo PPK II    Rp    13,000,000 Rp        2,340,000 Rp      -   Rp    13,000,000
  19   Kel. Salak(Perg)    Rp    15,800,000 Rp        2,844,000 Rp      -   Rp    15,800,000
  20   NURUL HIKMAH        Rp    16,300,000 Rp        2,934,000 Rp      -   Rp    16,300,000
  21   AINUN NISA          Rp    15,000,000 Rp        2,700,000 Rp      -   Rp    15,000,000
  22   Kel. Sawo PPK II    Rp    16,500,000 Rp        2,970,000 Rp      -   Rp    16,500,000
  23   Kel. Salak(Lunas)   Rp    22,800,000 Rp        4,560,000 Rp      -   Rp    22,800,000
  24   AL-HIKMAH           Rp    21,100,000 Rp        1,606,000 Rp      -   Rp    16,255,000
  25   AINUN NISA          Rp    23,500,000 Rp        3,070,000 Rp      -   Rp    17,515,000
  26   Kel. Sawo PPK II    Rp    24,500,000 Rp        4,410,000             Rp    22,050,000
  27   ASSYFA PNPM.MP      Rp    15,000,000 Rp          900,000             Rp     5,500,000
  28   NURUL IMAN PNPM.MP  Rp    15,000,000 Rp          900,000             Rp     5,500,000
  29   ALBAROKAH PNPM.MP   Rp    15,000,000 Rp        1,240,000             Rp     6,625,000
  30   ALIYAH PNPM.MP      Rp    15,000,000 Rp        1,400,000             Rp     7,550,000
  31   MANGGIS PNPM.MP     Rp    11,000,000 Rp        1,240,000             Rp     6,200,000
  32   SALAK (Perg)        Rp    18,000,000 Rp        2,060,000             Rp    10,300,000



       TOTAL                   Rp   393,350,000   Rp 56,010,800   Rp    -   Rp 321,025,000
       MCFS/Krdesa-a-spp.xls
                              Catatan **
Tunggakan         Sisa            I        II   III
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp     910,000
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp   3,180,000
Rp       -   Rp   7,630,000
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp           -
Rp       -   Rp   4,845,000
Rp       -   Rp   5,985,000
             Rp   2,450,000
             Rp   9,500,000
             Rp   9,500,000
             Rp   8,375,000
             Rp   7,450,000
             Rp   4,800,000
             Rp   7,700,000



Rp       -   Rp 72,325,000
                                                                                                                                             UNIT PENGELOLA KEGIATAN
       MENU UTAMA                                                                                                                      LAPORAN PERKEMBANGAN PINJAMAN SPP
                                                                                                                                TANGGAL : 31      BULAN : JANUARI    TAHUN : 2009

Desa             : SUKASLAMET
Kecamatan        : KROYA
Kabupaten        : INDRAMAYU
                                                                                                                                    Target Pengembalian Kumulatif      Realisasi Pengembalian      Realisasi Pengembalian           Realisasi Pengembalian                          %
                                                                                                                                                                                                                                                                                                  Tunggakan Pengembalian s/d bln ini
                                                                  Realisasi Pinjaman                                      Target             s/d Bulan ini                 s/d Bulan lalu                 Bulan ini                      s/d Bulan ini
 No                Kelompok                    Alokasi Pinjaman
                                                                    (Tgl/Bln/Thn)
                                                                                       Angsuran Pokok   Angsuran Bunga
                                                                                                                         angs. ke
                                                                                                                                                                                                                                                                 Saldo Pinjaman   Pengem
                                                                                                                                      Pokok               Bunga       Pokok              Bunga     Pokok            Bunga         Pokok               Bunga                        balian   Tungga         Pokok              Bunga
                                                                                                                                                                                                                                                                                             kan
  1                      2                            3                   4                                                              5                  6           7                  8         9                10            11                  12          13=3-11       14=11/5   Pokok         15=5-11            16=6-12
 1    Kelompok   Kel. Mawar                         3,300,000       12/17/2003              330,000          66,000        10         3,300,000           660,000     3,300,000          612,000                                  3,300,000            612,000           -        100%        0                 -              48,000
 2    Kelompok   Kel. Salak                       6,000,000         12/17/2003              600,000         120,000        10         6,000,000         1,200,000     6,000,000        1,200,000                                  6,000,000          1,200,000           -        100%        0                 -                 -
 3    Kelompok   Kel. Sawo PPK II                 5,300,000          11/1/2004              530,000         106,000        10         5,300,000         1,060,000     5,300,000        1,060,000                                  5,300,000          1,060,000           -        100%        0                 -                 -
 4    Kelompok   Kel. Dahlia PPK II               4,200,000          11/1/2004              420,000          84,000        10         4,200,000           840,000     4,200,000          840,000                                  4,200,000            840,000           -        100%        0                 -                 -
 5    Kelompok   Kel.Mawar(Perg)                  5,100,000          11/1/2004              510,000         102,000        10         5,100,000         1,020,000     5,100,000        1,020,000                                  5,100,000          1,020,000           -        100%        0                 -                 -
 6    Kelompok   Kel. Salak(Perg)                 6,400,000          11/1/2004              640,000         128,000        10         6,400,000         1,280,000     6,400,000        1,280,000                                  6,400,000          1,280,000           -        100%        0                 -                 -
 7    Kelompok   Kel. Pisang PPK III              9,500,000          9/8/2005               950,000         190,000        10         9,500,000         1,900,000     9,500,000        1,729,000                                  9,500,000          1,729,000           -        100%        0                 -             171,000
 8    Kelompok   Kel.Mawar(Perg)                  8,100,000          10/3/2005              810,000         145,800        10         8,100,000         1,458,000     8,100,000        1,458,000                                  8,100,000          1,458,000           -        100%        0                 -                 -
 9    Kelompok   Kel. Salak(Perg)                 7,100,000          10/3/2005              710,000         127,800        10         7,100,000         1,278,000     7,100,000        1,278,000                                  7,100,000          1,278,000           -        100%        0                 -                 -
 10   Kelompok   Kel. Sawo PPK II                 6,800,000          10/3/2005              680,000         122,400        10         6,800,000         1,224,000     6,800,000        1,224,000                                  6,800,000          1,224,000           -        100%        0                 -                 -
 11   Kelompok   Kel. Pisang PPK III             12,800,000          7/18/2006            1,280,000         230,400        10        12,800,000         2,304,000    11,890,000        1,463,400                                 11,890,000          1,463,400       910,000       93%        1             910,000           840,600
 12   Kelompok   Kel. Sawo PPK II                 9,900,000          10/3/2005              990,000         178,200        10         9,900,000         1,782,000     9,900,000        1,394,000                                  9,900,000          1,394,000           -        100%        0                 -             388,000
 13   Kelompok   Kel. Salak(Perg)                10,300,000          10/3/2005            1,030,000         185,400        10        10,300,000         1,854,000    10,300,000        1,854,000                                 10,300,000          1,854,000           -        100%        0                 -                 -
 14   Kelompok   Kel. Dahlia PPK II               6,400,000         10/17/2006              640,000         115,200        10         6,400,000         1,152,000     3,220,000          460,800                                  3,220,000            460,800     3,180,000       50%        5           3,180,000           691,200
 15   Kelompok   Kel.Mawar(Perg)                 10,900,000         10/17/2006            1,090,000         196,200        10        10,900,000         1,962,000     3,270,000          588,600                                  3,270,000            588,600     7,630,000       30%        7           7,630,000         1,373,400
 16   Kelompok   AL-BAROKAH                      12,500,000          11/6/2006            1,250,000         225,000        10        12,500,000         2,250,000    12,500,000        1,350,000                                 12,500,000          1,350,000           -        100%        0                 -             900,000
 17   Kelompok   NURUL HIKMAH                    11,250,000          11/6/2006            1,125,000         202,500        10        11,250,000         2,025,000    11,250,000        2,025,000                                 11,250,000          2,025,000           -        100%        0                 -                 -
 18   Kelompok   Kel. Sawo PPK II                13,000,000          6/11/2007            1,300,000         234,000        10        13,000,000         2,340,000    13,000,000        2,340,000                                 13,000,000          2,340,000           -        100%        0                 -                 -
 19   Kelompok   Kel. Salak(Perg)                15,800,000          8/21/2007            1,580,000         284,400        10        15,800,000         2,844,000    15,800,000        2,844,000                                 15,800,000          2,844,000           -        100%        0                 -                 -
 20   Kelompok   NURUL HIKMAH                    16,300,000          9/12/2007            1,630,000         293,400        10        16,300,000         2,934,000    16,300,000        2,934,000                                 16,300,000          2,934,000           -        100%        0                 -                 -
 21   Kelompok   AINUN NISA                      15,000,000         12/12/2007            1,500,000         270,000        10        15,000,000         2,700,000    15,000,000        2,700,000                                 15,000,000          2,700,000           -        100%        0                 -                 -
 22   Kelompok   Kel. Sawo PPK II                16,500,000          4/7/2008             1,650,000         297,000        10        16,500,000         2,970,000    16,500,000        2,970,000                                 16,500,000          2,970,000           -        100%        0                 -                 -
 23   Kelompok   Kel. Salak(Lunas)               22,800,000          7/18/2008            2,280,000         456,000        10        22,800,000         4,560,000    22,800,000        4,560,000                                 22,800,000          4,560,000           -        100%        0                 -                 -
 24   Kelompok   AL-HIKMAH                       21,100,000          8/22/2008            2,110,000         422,000        10        21,100,000         4,220,000    16,255,000        1,606,000                                 16,255,000          1,606,000     4,845,000       77%        2           4,845,000         2,614,000
 25   Kelompok   AINUN NISA                      23,500,000         12/15/2008            2,350,000         470,000        10        23,500,000         4,700,000    17,515,000        3,070,000                                 17,515,000          3,070,000     5,985,000       75%        3           5,985,000         1,630,000
 26   Kelompok   Kel. Sawo PPK II                24,500,000          3/17/2009            2,450,000         490,000         9        22,050,000         4,410,000    22,050,000        4,410,000                                 22,050,000          4,410,000     2,450,000      100%        0                 -                 -
 27   Kelompok   ASSYFA PNPM.MP                  15,000,000          6/5/2009             1,500,000         300,000         6         9,000,000         1,800,000     5,500,000          900,000                                  5,500,000            900,000     9,500,000       61%        2           3,500,000           900,000
 28   Kelompok   NURUL IMAN PNPM.MP              15,000,000          6/5/2009             1,500,000         300,000         6         9,000,000         1,800,000     5,500,000          900,000                                  5,500,000            900,000     9,500,000       61%        2           3,500,000           900,000
 29   Kelompok   ALBAROKAH PNPM.MP               15,000,000          6/5/2009             1,500,000         300,000         6         9,000,000         1,800,000     6,625,000        1,240,000                                  6,625,000          1,240,000     8,375,000       74%        2           2,375,000           560,000
 30   Kelompok   ALIYAH PNPM.MP                  15,000,000          6/5/2009             1,500,000         300,000         6         9,000,000         1,800,000     7,550,000        1,400,000                                  7,550,000          1,400,000     7,450,000       84%        1           1,450,000           400,000
 31   Kelompok   MANGGIS PNPM.MP                 11,000,000          6/5/2009             1,100,000         220,000         6         6,600,000         1,320,000     6,200,000        1,240,000                                  6,200,000          1,240,000     4,800,000       94%        0             400,000            80,000
 32   Kelompok   SALAK (Perg)                    18,000,000          6/5/2009             1,800,000         360,000         6        10,800,000         2,160,000    10,300,000        2,060,000                                 10,300,000          2,060,000     7,700,000       95%        0             500,000           100,000


             T o t a l                          393,350,000            1,251,537        39,335,000        7,521,700                 355,300,000       67,607,000    321,025,000       56,010,800           -                -   321,025,000         56,010,800    72,325,000      90.35%                 34,275,000       11,596,200

MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
                                                                                    UNIT PENGELOLA KEGIATAN
                                                                              LAPORAN KOLEKTIBILITAS PINJAMAN SPP
                                                                       TANGGAL : 31      BULAN : JANUARI    TAHUN : 2009

               Desa                 : SUKASLAMET
               Kecamatan            : KROYA
               Kabupaten            : INDRAMAYU
                                                           SALDO PINJAMAN            SISA PINJAMAN        SISA PINJAMAN           SISA PINJAMAN            SISA PINJAMAN             SISA PINJAMAN YG

                                                              BULAN INI           YG ANGSURAN LANCAR     YG MENUNGGAK            YG MENUNGGAK             YG MENUNGGAK            MENUNGGAK DIATAS 6 KALI
 Rumus         NO.     KELOMPOK/DESA                      (KOLOM 13 LAPORAN        (TANPA TUNGGAKAN)   1 S/D 2 KALI ANGSURAN   3 S/D 4 KALI ANGSURAN    5 S/D 6 KALI ANGSURAN           ANGSURAN
berapa bln
menunggak                                              PERKEMBANGAN PINJAMAN)      KOLEKTIBILITAS I     KOLEKTIBILITAS II      KOLEKTIBILITAS III       KOLEKTIBILITAS IV           KOLEKTIBILITAS V

                 1                  2                   3                                 4                     5                       6                         7                         8
       -         1      Kelompok    Kel. Mawar                   -                                 -                     -                       -                            -                         -
       -         2      Kelompok    Kel. Salak                   -                                 -                     -                       -                            -                         -
       -         3      Kelompok    Kel. Sawo PPK II             -                                 -                     -                       -                            -                         -
       -         4      Kelompok    Kel. Dahlia PPK II           -                                 -                     -                       -                            -                         -
       -         5      Kelompok    Kel.Mawar(Perg)              -                                 -                     -                       -                            -                         -
       -         6      Kelompok    Kel. Salak(Perg)             -                                 -                     -                       -                            -                         -
       -         7      Kelompok    Kel. Pisang PPK III          -                                 -                     -                       -                            -                         -
       -         8      Kelompok    Kel.Mawar(Perg)              -                                 -                     -                       -                            -                         -
       -         9      Kelompok    Kel. Salak(Perg)             -                                 -                     -                       -                            -                         -
       -        10      Kelompok    Kel. Sawo PPK II             -                                 -                     -                       -                            -                         -
           1    11      Kelompok    Kel. Pisang PPK III    910,000                                 -               910,000                       -                            -                         -
       -        12      Kelompok    Kel. Sawo PPK II             -                                 -                     -                       -                            -                         -
       -        13      Kelompok    Kel. Salak(Perg)             -                                 -                     -                       -                            -                         -
           5    14      Kelompok    Kel. Dahlia PPK II   3,180,000                                 -                     -                       -                    3,180,000                         -
           7    15      Kelompok    Kel.Mawar(Perg)      7,630,000                                 -                     -                       -                            -                 7,630,000
       -        16      Kelompok    AL-BAROKAH                   -                                 -                     -                       -                            -                         -
       -        17      Kelompok    NURUL HIKMAH                 -                                 -                     -                       -                            -                         -
       -        18      Kelompok    Kel. Sawo PPK II             -                                 -                     -                       -                            -                         -
       -        19      Kelompok    Kel. Salak(Perg)             -                                 -                     -                       -                            -                         -
       -        20      Kelompok    NURUL HIKMAH                 -                                 -                     -                       -                            -                         -
       -        21      Kelompok    AINUN NISA                   -                                 -                     -                       -                            -                         -
       -        22      Kelompok    Kel. Sawo PPK II             -                                 -                     -                       -                            -                         -
       -        23      Kelompok    Kel. Salak(Lunas)            -                                 -                     -                       -                            -                         -
           2    24      Kelompok    AL-HIKMAH            4,845,000                                 -             4,845,000                       -                            -                         -
           3    25      Kelompok    AINUN NISA           5,985,000                                 -                     -               5,985,000                            -                         -
       -        26      Kelompok    Kel. Sawo PPK II     2,450,000                         2,450,000                     -                       -                            -                         -
           2    27      Kelompok    ASSYFA PNPM.MP       9,500,000                                 -             9,500,000                       -                            -                         -
           2    28      Kelompok    NURUL IMAN PNPM.MP 9,500,000                                   -             9,500,000                       -                            -                         -
           2    29      Kelompok    ALBAROKAH PNPM.MP 8,375,000                                    -             8,375,000                       -                            -                         -
           1    30      Kelompok    ALIYAH PNPM.MP       7,450,000                                 -             7,450,000                       -                            -                         -
           0    31      Kelompok    MANGGIS PNPM.MP      4,800,000                         4,800,000                     -                       -                            -                         -
           0    32      Kelompok    SALAK (Perg)         7,700,000                         7,700,000                     -                       -                            -                         -
 #DIV/0!                                                         -                                 -                     -                       -                            -                         -

                             TOTAL                               72,325,000              14,950,000            40,580,000                5,985,000                    3,180,000                 7,630,000


                                                        CADANGAN RESIKO          JUMLAH PINJAMAN       JUMLAH CADANGAN
                          TINGKAT                                                                                                      Diketahui dan disetujui Oleh
                                                             PINJAMAN                                        RESIKO                                                                    Dibuat oleh
                       KOLEKTIBILITAS                            (1)                      (2)               "(3=1 X 2)
                     KOLEKTIBILITAS I                          1%                 14,950,000                      149,500
                     KOLEKTIBILITAS II                        10%                 40,580,000                    4,058,000
                     KOLEKTIBILITAS III                       25%                  5,985,000                    1,496,250
                     KOLEKTIBILITAS IV                        50%                  3,180,000                    1,590,000
                     KOLEKTIBILITAS V                        100%                  7,630,000                    7,630,000
                                                            TOTAL                 72,325,000                   14,923,750                   ( Rosdianah, Amd. )                     ( Inah Carsinah )
                                                         RASIO CADANGAN PINJAMAN (%)                                                            Ketua UPK                           Bendahara UPK
                                                                                                              21%
                                                              (TOTAL (3) / TOTAL (2) )
                     MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
                                                                                                                                   UN
      MENU UTAMA                                                                                                              LAPORA
                                                                                                                      TANGGAL : 28

Desa            : SUKASLAMET
Kecamatan       : KROYA
Kabupaten       : INDRAMAYU

                                                    Realisasi Pinjaman                                      Target
No          Kelompok             Alokasi Pinjaman
                                                      (Tgl/Bln/Thn)
                                                                         Angsuran Pokok   Angsuran Bunga
                                                                                                           angs. ke


 1                2                     3                   4
1    Kelompok   Kel. Mawar            3,300,000             37,972         275,000.00       55,000.00
2    Kelompok   Kel. Salak            6,000,000             37,972         500,000.00      100,000.00
3    Kelompok   Kel. Sawo PPK II      5,300,000             38,292         441,666.67       88,333.33
4    Kelompok   Kel. Dahlia PPK II    4,200,000             38,292         350,000.00       70,000.00
5    Kelompok   Kel.Mawar(Perg)       5,100,000             38,292         425,000.00       85,000.00
6    Kelompok   Kel. Salak(Perg)      6,400,000             38,292         533,333.33      106,666.67
7    Kelompok   Kel. Pisang PPK III   9,500,000             38,603         791,666.67      158,333.33
8    Kelompok   Kel.Mawar(Perg)       8,100,000             38,628         675,000.00      135,000.00
9    Kelompok   Kel. Salak(Perg)      7,100,000             38,628         591,666.67      118,333.33
10   Kelompok   Kel. Sawo PPK II      6,800,000             38,628         566,666.67      113,333.33
11   Kelompok   Kel. Pisang PPK III 12,800,000              38,916       1,066,666.67      213,333.33
12   Kelompok   Kel. Sawo PPK II      9,900,000             38,628         825,000.00      165,000.00
13   Kelompok   Kel. Salak(Perg)    10,300,000              38,628         858,333.33      171,666.67
14   Kelompok   Kel. Dahlia PPK II    6,400,000             39,007         533,333.33      106,666.67
15   Kelompok   Kel.Mawar(Perg)     10,900,000              39,007         908,333.33      181,666.67
16   Kelompok   AL-BAROKAH          12,500,000              39,027       1,041,666.67      208,333.33
17   Kelompok   NURUL HIKMAH        11,250,000              39,027         937,500.00      187,500.00
18   Kelompok   Kel. Sawo PPK II    13,000,000              39,244       1,083,333.33      216,666.67
19   Kelompok   Kel. Salak(Perg)    15,800,000              39,315       1,316,666.67      263,333.33
20   Kelompok   NURUL HIKMAH        16,300,000              39,337       1,358,333.33      271,666.67
21   Kelompok   AINUN NISA          15,000,000              39,428       1,250,000.00      250,000.00
22   Kelompok   Kel. Sawo PPK II    16,500,000              39,545       1,375,000.00      275,000.00
23   Kelompok   Kel. Salak(Lunas)   22,800,000              39,647       1,900,000.00      380,000.00
24   Kelompok   AL-HIKMAH           21,100,000              39,682       1,758,333.33      351,666.67
25   Kelompok   AINUN NISA          23,500,000              39,797       1,958,333.33      391,666.67
26   Kelompok   Kel. Sawo PPK II    24,500,000              39,889       2,041,666.67      408,333.33
27   Kelompok   ASSYFA PNPM.MP      15,000,000              39,969       1,250,000.00      250,000.00
28   Kelompok   NURUL IMAN PNPM.MP  15,000,000              39,969       1,250,000.00      250,000.00
29   Kelompok   ALBAROKAH PNPM.MP5,000,000
                                    1                       39,969       1,250,000.00      250,000.00
30   Kelompok   ALIYAH PNPM.MP      15,000,000              39,969       1,250,000.00      250,000.00
31   Kelompok   MANGGIS PNPM.MP 11,000,000                  39,969         916,666.67      183,333.33
32   Kelompok   SALAK (Perg)        18,000,000              39,969       1,500,000.00      300,000.00
33   Kelompok   0                             -                  -                -               -
34   Kelompok   #REF!               #REF!                #REF!              #REF!           #REF!
35   Kelompok   #REF!               #REF!                #REF!              #REF!           #REF!
36   Kelompok   #REF!               #REF!                #REF!              #REF!           #REF!
37   Kelompok   #REF!               #REF!                #REF!              #REF!           #REF!
38   Kelompok   #REF!               #REF!                #REF!              #REF!           #REF!
 39   Kelompok   #REF!                 #REF!           #REF!           #REF!   #REF!
 40   Kelompok   #REF!                 #REF!           #REF!           #REF!   #REF!
 41   Kelompok   #REF!                 #REF!           #REF!           #REF!   #REF!
 42   Kelompok   #REF!                 #REF!           #REF!           #REF!   #REF!
 43   Kelompok   #REF!                 #REF!           #REF!           #REF!   #REF!
 44   Kelompok   #REF!                 #REF!           #REF!           #REF!   #REF!
 45   Kelompok   #REF!                 #REF!           #REF!           #REF!   #REF!
 46   Kelompok   #REF!                 #REF!           #REF!           #REF!   #REF!
 47   Kelompok   #REF!                 #REF!           #REF!           #REF!   #REF!
 48   Kelompok   #REF!                 #REF!           #REF!           #REF!   #REF!
 49   Kelompok   #REF!                 #REF!           #REF!           #REF!   #REF!
 50   Kelompok   #REF!                 #REF!           #REF!           #REF!   #REF!

       T o t a l                       #REF!           #REF!           #REF!   #REF!   ######

MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
             UNIT PENGELOLA KEGIATAN
        LAPORAN PERKEMBANGAN PINJAMAN SPP
TANGGAL : 28     BULAN : FEBRUARI     TAHUN : 2009




Target Pengembalian Kumulatif     Realisasi Pengembalian       Realisasi Pengembalian     Realisasi Pengembalian
         s/d Bulan ini                 s/d Bulan lalu                 Bulan ini                s/d Bulan ini

  Pokok               Bunga      Pokok             Bunga       Pokok            Bunga    Pokok

     5                  6          7                  8          9                10      11
          -               -      3,300,000           612,000                             3,300,000
          -               -      6,000,000         1,200,000                             6,000,000
          -               -      5,300,000         1,060,000                             5,300,000
          -               -      4,200,000           840,000                             4,200,000
          -               -      5,100,000         1,020,000                             5,100,000
          -               -      6,400,000         1,280,000                             6,400,000
          -               -      9,500,000         1,729,000                             9,500,000
          -               -      8,100,000         1,458,000                             8,100,000
          -               -      7,100,000         1,278,000                             7,100,000
          -               -      6,800,000         1,224,000                             6,800,000
          -               -     11,890,000         1,463,400                            11,890,000
          -               -      9,900,000         1,394,000                             9,900,000
          -               -     10,300,000         1,854,000                            10,300,000
          -               -      3,220,000           460,800                             3,220,000
          -               -      3,270,000           588,600                             3,270,000
          -               -     12,500,000         1,350,000                            12,500,000
          -               -     11,250,000         2,025,000                            11,250,000
          -               -     13,000,000         2,340,000                            13,000,000
          -               -     15,800,000         2,844,000                            15,800,000
          -               -     16,300,000         2,934,000                            16,300,000
          -               -     15,000,000         2,700,000                            15,000,000
          -               -     16,500,000         2,970,000                            16,500,000
          -               -     22,800,000         4,560,000                            22,800,000
          -               -     16,255,000         1,606,000                            16,255,000
          -               -     17,515,000         3,070,000                            17,515,000
          -               -     22,050,000         4,410,000                            22,050,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      6,625,000         1,240,000                             6,625,000
          -               -      7,550,000         1,400,000                             7,550,000
          -               -      6,200,000         1,240,000                             6,200,000
          -               -     10,300,000         2,060,000                            10,300,000
          -               -            -                 -                                     -
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!

#REF!   #REF!   #REF!   #REF!   -   -   #REF!
                                                                                                                    Desa
                                                                                                                    Kecamatan
                                                                                                                    Kabupaten
Realisasi Pengembalian                           %
                                                             Tunggakan Pengembalian s/d bln ini
     s/d Bulan ini                                                                                   Rumus
                              Saldo Pinjaman
                                               Pengem                                                               NO.
                                                                                                    berapa bln
                  Bunga                         balian   Tungga       Pokok              Bunga      menunggak
                                                          kan
                   12            13=3-11       14=11/5   Pokok       15=5-11            16=6-12                       1
                    612,000            -       #DIV/0!              (3,300,000)         (612,000)          (12)       1
                  1,200,000            -       #DIV/0!              (6,000,000)       (1,200,000)          (12)       2
                  1,060,000            -       #DIV/0!              (5,300,000)       (1,060,000)          (12)       3
                    840,000            -       #DIV/0!              (4,200,000)         (840,000)      (12.000)       4
                  1,020,000            -       #DIV/0!              (5,100,000)       (1,020,000)          (12)       5
                  1,280,000            -       #DIV/0!              (6,400,000)       (1,280,000)          (12)       6
                  1,729,000            -       #DIV/0!              (9,500,000)       (1,729,000)          (12)       7
                  1,458,000            -       #DIV/0!              (8,100,000)       (1,458,000)          (12)       8
                  1,278,000            -       #DIV/0!              (7,100,000)       (1,278,000)          (12)       9
                  1,224,000            -       #DIV/0!              (6,800,000)       (1,224,000)          (12)      10
                  1,463,400        910,000     #DIV/0!             (11,890,000)       (1,463,400)          (11)      11
                  1,394,000            -       #DIV/0!              (9,900,000)       (1,394,000)          (12)      12
                  1,854,000            -       #DIV/0!             (10,300,000)       (1,854,000)          (12)      13
                    460,800      3,180,000     #DIV/0!              (3,220,000)         (460,800)             (6)    14
                    588,600      7,630,000     #DIV/0!              (3,270,000)         (588,600)             (4)    15
                  1,350,000            -       #DIV/0!             (12,500,000)       (1,350,000)          (12)      16
                  2,025,000            -       #DIV/0!             (11,250,000)       (2,025,000)          (12)      17
                  2,340,000            -       #DIV/0!             (13,000,000)       (2,340,000)          (12)      18
                  2,844,000            -       #DIV/0!             (15,800,000)       (2,844,000)          (12)      19
                  2,934,000            -       #DIV/0!             (16,300,000)       (2,934,000)          (12)      20
                  2,700,000            -       #DIV/0!             (15,000,000)       (2,700,000)          (12)      21
                  2,970,000            -       #DIV/0!             (16,500,000)       (2,970,000)          (12)      22
                  4,560,000            -       #DIV/0!             (22,800,000)       (4,560,000)          (12)      23
                  1,606,000      4,845,000     #DIV/0!             (16,255,000)       (1,606,000)             (9)    24
                  3,070,000      5,985,000     #DIV/0!             (17,515,000)       (3,070,000)             (9)    25
                  4,410,000      2,450,000     #DIV/0!             (22,050,000)       (4,410,000)          (11)      26
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    27
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    28
                  1,240,000      8,375,000     #DIV/0!              (6,625,000)       (1,240,000)             (5)    29
                  1,400,000      7,450,000     #DIV/0!              (7,550,000)       (1,400,000)             (6)    30
                  1,240,000      4,800,000     #DIV/0!              (6,200,000)       (1,240,000)             (7)    31
                  2,060,000      7,700,000     #DIV/0!             (10,300,000)       (2,060,000)             (7)    32
                        -              -       #DIV/0!                     -                 -       #DIV/0!         33
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          34
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          35
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          36
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          37
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          38
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   39
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   40
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   41
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   42
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   43
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   44
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   45
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   46
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   47
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   48
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   49
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   50

#REF!   #REF!   #REF!   #REF!   #REF!                TOTAL
                                                         UNIT PENGELOLA KEGIATAN
                                                   LAPORAN KOLEKTIBILITAS PINJAMAN SPP
                                            TANGGAL : 28     BULAN : FEBRUARI     TAHUN : 2009

                 : SUKASLAMET
Kecamatan        : KROYA
Kabupaten        : INDRAMAYU
                                    SALDO PINJAMAN         SISA PINJAMAN         SISA PINJAMAN               SISA PINJAMAN

                                      BULAN INI          YG ANGSURAN LANCAR     YG MENUNGGAK                YG MENUNGGAK
     KELOMPOK/DESA                (KOLOM 13 LAPORAN      (TANPA TUNGGAKAN)    1 S/D 2 KALI ANGSURAN       3 S/D 4 KALI ANGSURAN

                                PERKEMBANGAN PINJAMAN)   KOLEKTIBILITAS I     KOLEKTIBILITAS II           KOLEKTIBILITAS III

                 2                      3                        4                     5                           6
      Kelompok    Kel. Mawar                     -                      -                             -                           -
      Kelompok    Kel. Salak                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II             -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III            -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III      910,000                910,000                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II     3,180,000              3,180,000                             -                           -
      Kelompok    Kel.Mawar(Perg)        7,630,000              7,630,000                             -                           -
      Kelompok    AL-BAROKAH                     -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    AINUN NISA                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Lunas)              -                      -                             -                           -
      Kelompok    AL-HIKMAH              4,845,000              4,845,000                             -                           -
      Kelompok    AINUN NISA             5,985,000              5,985,000                             -                           -
      Kelompok    Kel. Sawo PPK II       2,450,000              2,450,000                             -                           -
      Kelompok    ASSYFA PNPM.MP         9,500,000              9,500,000                             -                           -
      Kelompok    NURUL IMAN PNPM.MP 9,500,000                  9,500,000                             -                           -
      Kelompok    ALBAROKAH PNPM.MP 8,375,000                   8,375,000                             -                           -
      Kelompok    ALIYAH PNPM.MP         7,450,000              7,450,000                             -                           -
      Kelompok    MANGGIS PNPM.MP        4,800,000              4,800,000                             -                           -
      Kelompok    SALAK (Perg)           7,700,000              7,700,000                             -                           -
      Kelompok               -                   -                      -                             -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -

        TOTAL                             #REF!                    #REF!                           -             -


                                   CADANGAN RESIKO          JUMLAH PINJAMAN       JUMLAH CADANGAN
     TINGKAT
                                        PINJAMAN                                      RESIKO           Diketahui dan disetujui Ole
  KOLEKTIBILITAS                            (1)                      (2)              "(3=1 X 2)
KOLEKTIBILITAS I                           1%              #REF!                       #REF!
KOLEKTIBILITAS II                         10%                                 -                    -
KOLEKTIBILITAS III                        25%                                 -                    -
KOLEKTIBILITAS IV                         50%                                 -                    -
KOLEKTIBILITAS V                         100%                                 -                    -
                                        TOTAL              #REF!                       #REF!               ( Rosdianah, Amd. )
                                     RASIO CADANGAN PINJAMAN (%)                                               Ketua UPK
                                                                                       #REF!
                                         (TOTAL (3) / TOTAL (2) )
MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
PP
AHUN : 2009




                 SISA PINJAMAN               SISA PINJAMAN YG

                YG MENUNGGAK              MENUNGGAK DIATAS 6 KALI

              5 S/D 6 KALI ANGSURAN             ANGSURAN

              KOLEKTIBILITAS IV             KOLEKTIBILITAS V

                       7                            8
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -

                               -                       -



Diketahui dan disetujui Oleh         Dibuat oleh




    ( Rosdianah, Amd. )            ( Inah Carsinah )
        Ketua UPK                  Bendahara UPK
                                                                                                                                     UN
      MENU UTAMA                                                                                                               LAPORA
                                                                                                                        TANGGAL : 31

Desa            : SUKASLAMET
Kecamatan       : KROYA
Kabupaten       : INDRAMAYU

                                                      Realisasi Pinjaman                                      Target
No          Kelompok               Alokasi Pinjaman
                                                        (Tgl/Bln/Thn)
                                                                           Angsuran Pokok   Angsuran Bunga
                                                                                                             angs. ke


 1                2                       3                   4
1    Kelompok   Kel. Mawar          3300000           37972                  275,000.00       55,000.00
2    Kelompok   Kel. Salak          6000000           37972                  500,000.00      100,000.00
3    Kelompok   Kel. Sawo PPK II 5300000              38292                  441,666.67       88,333.33
4    Kelompok   Kel. Dahlia PPK II 4200000            38292                  350,000.00       70,000.00
5    Kelompok   Kel.Mawar(Perg) 5100000               38292                  425,000.00       85,000.00
6    Kelompok   Kel. Salak(Perg)    6400000           38292                  533,333.33      106,666.67
7    Kelompok   Kel. Pisang PPK III 9500000           38603                  791,666.67      158,333.33
8    Kelompok   Kel.Mawar(Perg) 8100000               38628                  675,000.00      135,000.00
9    Kelompok   Kel. Salak(Perg)    7100000           38628                  591,666.67      118,333.33
10   Kelompok   Kel. Sawo PPK II 6800000              38628                  566,666.67      113,333.33
11   Kelompok   Kel. Pisang PPK III 12800000          38916                1,066,666.67      213,333.33
12   Kelompok   Kel. Sawo PPK II 9900000              38628                  825,000.00      165,000.00
13   Kelompok   Kel. Salak(Perg)    10300000          38628                  858,333.33      171,666.67
14   Kelompok   Kel. Dahlia PPK II 6400000            39007                  533,333.33      106,666.67
15   Kelompok   Kel.Mawar(Perg) 10900000              39007                  908,333.33      181,666.67
16   Kelompok   AL-BAROKAH          12500000          39027                1,041,666.67      208,333.33
17   Kelompok   NURUL HIKMAH 11250000                 39027                  937,500.00      187,500.00
18   Kelompok   Kel. Sawo PPK II 13000000             39244                1,083,333.33      216,666.67
19   Kelompok   Kel. Salak(Perg)    15800000          39315                1,316,666.67      263,333.33
20   Kelompok   NURUL HIKMAH 16300000                 39337                1,358,333.33      271,666.67
21   Kelompok   AINUN NISA          15000000          39428                1,250,000.00      250,000.00
22   Kelompok   Kel. Sawo PPK II 16500000             39545                1,375,000.00      275,000.00
23   Kelompok   Kel. Salak(Lunas) 22800000            39647                1,900,000.00      380,000.00
24   Kelompok   AL-HIKMAH           21100000          39682                1,758,333.33      351,666.67
25   Kelompok   AINUN NISA          23500000          39797                1,958,333.33      391,666.67
26   Kelompok   Kel. Sawo PPK II 24500000             39889                2,041,666.67      408,333.33
27   Kelompok   ASSYFA PNPM.MP15000000                39969                1,250,000.00      250,000.00
28   Kelompok   NURUL IMAN PNPM.MP  15000000          39969                1,250,000.00      250,000.00
29   Kelompok   ALBAROKAH PNPM.MP   15000000          39969                1,250,000.00      250,000.00
30   Kelompok   ALIYAH PNPM.MP15000000                39969                1,250,000.00      250,000.00
31   Kelompok   MANGGIS PNPM.MP     11000000          39969                  916,666.67      183,333.33
32   Kelompok   SALAK (Perg)        18000000          39969                1,500,000.00      300,000.00
33   Kelompok   0                   0                 0                             -               -
34   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
35   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
36   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
37   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
38   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
 39   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 40   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 41   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 42   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 43   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 44   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 45   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 46   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 47   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 48   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 49   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 50   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!

       T o t a l                       #REF!           #REF!           #REF!   #REF!   ######

MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
              UNIT PENGELOLA KEGIATAN
        LAPORAN PERKEMBANGAN PINJAMAN SPP
 TANGGAL : 31      BULAN : MARET      TAHUN : 2009




Target Pengembalian Kumulatif     Realisasi Pengembalian       Realisasi Pengembalian     Realisasi Pengembalian
         s/d Bulan ini                 s/d Bulan lalu                 Bulan ini                s/d Bulan ini

  Pokok               Bunga      Pokok             Bunga       Pokok            Bunga    Pokok

     5                  6          7                  8          9                10      11
          -               -      3,300,000           612,000                             3,300,000
          -               -      6,000,000         1,200,000                             6,000,000
          -               -      5,300,000         1,060,000                             5,300,000
          -               -      4,200,000           840,000                             4,200,000
          -               -      5,100,000         1,020,000                             5,100,000
          -               -      6,400,000         1,280,000                             6,400,000
          -               -      9,500,000         1,729,000                             9,500,000
          -               -      8,100,000         1,458,000                             8,100,000
          -               -      7,100,000         1,278,000                             7,100,000
          -               -      6,800,000         1,224,000                             6,800,000
          -               -     11,890,000         1,463,400                            11,890,000
          -               -      9,900,000         1,394,000                             9,900,000
          -               -     10,300,000         1,854,000                            10,300,000
          -               -      3,220,000           460,800                             3,220,000
          -               -      3,270,000           588,600                             3,270,000
          -               -     12,500,000         1,350,000                            12,500,000
          -               -     11,250,000         2,025,000                            11,250,000
          -               -     13,000,000         2,340,000                            13,000,000
          -               -     15,800,000         2,844,000                            15,800,000
          -               -     16,300,000         2,934,000                            16,300,000
          -               -     15,000,000         2,700,000                            15,000,000
          -               -     16,500,000         2,970,000                            16,500,000
          -               -     22,800,000         4,560,000                            22,800,000
          -               -     16,255,000         1,606,000                            16,255,000
          -               -     17,515,000         3,070,000                            17,515,000
          -               -     22,050,000         4,410,000                            22,050,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      6,625,000         1,240,000                             6,625,000
          -               -      7,550,000         1,400,000                             7,550,000
          -               -      6,200,000         1,240,000                             6,200,000
          -               -     10,300,000         2,060,000                            10,300,000
          -               -            -                 -                                     -
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!

#REF!   #REF!   #REF!   #REF!   -   -   #REF!
                                                                                                                    Desa
                                                                                                                    Kecamatan
                                                                                                                    Kabupaten
Realisasi Pengembalian                           %
                                                             Tunggakan Pengembalian s/d bln ini
     s/d Bulan ini                                                                                   Rumus
                              Saldo Pinjaman
                                               Pengem                                                               NO.
                                                                                                    berapa bln
                  Bunga                         balian   Tungga       Pokok              Bunga      menunggak
                                                          kan
                   12            13=3-11       14=11/5   Pokok       15=5-11            16=6-12                       1
                    612,000            -       #DIV/0!              (3,300,000)         (612,000)          (12)       1
                  1,200,000            -       #DIV/0!              (6,000,000)       (1,200,000)          (12)       2
                  1,060,000            -       #DIV/0!              (5,300,000)       (1,060,000)          (12)       3
                    840,000            -       #DIV/0!              (4,200,000)         (840,000)      (12.000)       4
                  1,020,000            -       #DIV/0!              (5,100,000)       (1,020,000)          (12)       5
                  1,280,000            -       #DIV/0!              (6,400,000)       (1,280,000)          (12)       6
                  1,729,000            -       #DIV/0!              (9,500,000)       (1,729,000)          (12)       7
                  1,458,000            -       #DIV/0!              (8,100,000)       (1,458,000)          (12)       8
                  1,278,000            -       #DIV/0!              (7,100,000)       (1,278,000)          (12)       9
                  1,224,000            -       #DIV/0!              (6,800,000)       (1,224,000)          (12)      10
                  1,463,400        910,000     #DIV/0!             (11,890,000)       (1,463,400)          (11)      11
                  1,394,000            -       #DIV/0!              (9,900,000)       (1,394,000)          (12)      12
                  1,854,000            -       #DIV/0!             (10,300,000)       (1,854,000)          (12)      13
                    460,800      3,180,000     #DIV/0!              (3,220,000)         (460,800)             (6)    14
                    588,600      7,630,000     #DIV/0!              (3,270,000)         (588,600)             (4)    15
                  1,350,000            -       #DIV/0!             (12,500,000)       (1,350,000)          (12)      16
                  2,025,000            -       #DIV/0!             (11,250,000)       (2,025,000)          (12)      17
                  2,340,000            -       #DIV/0!             (13,000,000)       (2,340,000)          (12)      18
                  2,844,000            -       #DIV/0!             (15,800,000)       (2,844,000)          (12)      19
                  2,934,000            -       #DIV/0!             (16,300,000)       (2,934,000)          (12)      20
                  2,700,000            -       #DIV/0!             (15,000,000)       (2,700,000)          (12)      21
                  2,970,000            -       #DIV/0!             (16,500,000)       (2,970,000)          (12)      22
                  4,560,000            -       #DIV/0!             (22,800,000)       (4,560,000)          (12)      23
                  1,606,000      4,845,000     #DIV/0!             (16,255,000)       (1,606,000)             (9)    24
                  3,070,000      5,985,000     #DIV/0!             (17,515,000)       (3,070,000)             (9)    25
                  4,410,000      2,450,000     #DIV/0!             (22,050,000)       (4,410,000)          (11)      26
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    27
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    28
                  1,240,000      8,375,000     #DIV/0!              (6,625,000)       (1,240,000)             (5)    29
                  1,400,000      7,450,000     #DIV/0!              (7,550,000)       (1,400,000)             (6)    30
                  1,240,000      4,800,000     #DIV/0!              (6,200,000)       (1,240,000)             (7)    31
                  2,060,000      7,700,000     #DIV/0!             (10,300,000)       (2,060,000)             (7)    32
                        -              -       #DIV/0!                     -                 -       #DIV/0!         33
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          34
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          35
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          36
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          37
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          38
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   39
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   40
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   41
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   42
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   43
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   44
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   45
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   46
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   47
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   48
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   49
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   50

#REF!   #REF!   #REF!   #REF!   #REF!                TOTAL
                                                           UNIT PENGELOLA KEGIATAN
                                                    LAPORAN KOLEKTIBILITAS PINJAMAN SPP
                                              TANGGAL : 31      BULAN : MARET      TAHUN : 2009

                 : SUKASLAMET
Kecamatan        : KROYA
Kabupaten        : INDRAMAYU
                                    SALDO PINJAMAN         SISA PINJAMAN         SISA PINJAMAN               SISA PINJAMAN

                                      BULAN INI          YG ANGSURAN LANCAR     YG MENUNGGAK                YG MENUNGGAK
     KELOMPOK/DESA                (KOLOM 13 LAPORAN      (TANPA TUNGGAKAN)    1 S/D 2 KALI ANGSURAN       3 S/D 4 KALI ANGSURAN

                                PERKEMBANGAN PINJAMAN)   KOLEKTIBILITAS I     KOLEKTIBILITAS II           KOLEKTIBILITAS III

                 2                      3                        4                     5                           6
      Kelompok    Kel. Mawar                     -                      -                             -                           -
      Kelompok    Kel. Salak                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II             -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III            -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III      910,000                910,000                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II     3,180,000              3,180,000                             -                           -
      Kelompok    Kel.Mawar(Perg)        7,630,000              7,630,000                             -                           -
      Kelompok    AL-BAROKAH                     -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    AINUN NISA                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Lunas)              -                      -                             -                           -
      Kelompok    AL-HIKMAH              4,845,000              4,845,000                             -                           -
      Kelompok    AINUN NISA             5,985,000              5,985,000                             -                           -
      Kelompok    Kel. Sawo PPK II       2,450,000              2,450,000                             -                           -
      Kelompok    ASSYFA PNPM.MP         9,500,000              9,500,000                             -                           -
      Kelompok    NURUL IMAN PNPM.MP 9,500,000                  9,500,000                             -                           -
      Kelompok    ALBAROKAH PNPM.MP 8,375,000                   8,375,000                             -                           -
      Kelompok    ALIYAH PNPM.MP         7,450,000              7,450,000                             -                           -
      Kelompok    MANGGIS PNPM.MP        4,800,000              4,800,000                             -                           -
      Kelompok    SALAK (Perg)           7,700,000              7,700,000                             -                           -
      Kelompok               -                   -                      -                             -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -

        TOTAL                             #REF!                    #REF!                           -             -


                                   CADANGAN RESIKO          JUMLAH PINJAMAN       JUMLAH CADANGAN
     TINGKAT
                                        PINJAMAN                                      RESIKO           Diketahui dan disetujui Ole
  KOLEKTIBILITAS                            (1)                      (2)              "(3=1 X 2)
KOLEKTIBILITAS I                           1%              #REF!                       #REF!
KOLEKTIBILITAS II                         10%                                 -                    -
KOLEKTIBILITAS III                        25%                                 -                    -
KOLEKTIBILITAS IV                         50%                                 -                    -
KOLEKTIBILITAS V                         100%                                 -                    -
                                        TOTAL              #REF!                       #REF!               ( Rosdianah, Amd. )
                                     RASIO CADANGAN PINJAMAN (%)                                               Ketua UPK
                                                                                       #REF!
                                         (TOTAL (3) / TOTAL (2) )
MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
PP
HUN : 2009




                SISA PINJAMAN               SISA PINJAMAN YG

               YG MENUNGGAK              MENUNGGAK DIATAS 6 KALI

             5 S/D 6 KALI ANGSURAN             ANGSURAN

             KOLEKTIBILITAS IV             KOLEKTIBILITAS V

                      7                            8
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -

                               -                       -



Diketahui dan disetujui Oleh         Dibuat oleh




    ( Rosdianah, Amd. )            ( Inah Carsinah )
        Ketua UPK                  Bendahara UPK
                                                                                                                                    UN
      MENU UTAMA                                                                                                              LAPORA
                                                                                                                        TANGGAL : 30

Desa            : SUKASLAMET
Kecamatan       : KROYA
Kabupaten       : INDRAMAYU

                                                      Realisasi Pinjaman                                      Target
No          Kelompok               Alokasi Pinjaman
                                                        (Tgl/Bln/Thn)
                                                                           Angsuran Pokok   Angsuran Bunga
                                                                                                             angs. ke


 1                2                       3                   4
1    Kelompok   Kel. Mawar          3300000           37972                  275,000.00       55,000.00
2    Kelompok   Kel. Salak          6000000           37972                  500,000.00      100,000.00
3    Kelompok   Kel. Sawo PPK II 5300000              38292                  441,666.67       88,333.33
4    Kelompok   Kel. Dahlia PPK II 4200000            38292                  350,000.00       70,000.00
5    Kelompok   Kel.Mawar(Perg) 5100000               38292                  425,000.00       85,000.00
6    Kelompok   Kel. Salak(Perg)    6400000           38292                  533,333.33      106,666.67
7    Kelompok   Kel. Pisang PPK III 9500000           38603                  791,666.67      158,333.33
8    Kelompok   Kel.Mawar(Perg) 8100000               38628                  675,000.00      135,000.00
9    Kelompok   Kel. Salak(Perg)    7100000           38628                  591,666.67      118,333.33
10   Kelompok   Kel. Sawo PPK II 6800000              38628                  566,666.67      113,333.33
11   Kelompok   Kel. Pisang PPK III 12800000          38916                1,066,666.67      213,333.33
12   Kelompok   Kel. Sawo PPK II 9900000              38628                  825,000.00      165,000.00
13   Kelompok   Kel. Salak(Perg)    10300000          38628                  858,333.33      171,666.67
14   Kelompok   Kel. Dahlia PPK II 6400000            39007                  533,333.33      106,666.67
15   Kelompok   Kel.Mawar(Perg) 10900000              39007                  908,333.33      181,666.67
16   Kelompok   AL-BAROKAH          12500000          39027                1,041,666.67      208,333.33
17   Kelompok   NURUL HIKMAH 11250000                 39027                  937,500.00      187,500.00
18   Kelompok   Kel. Sawo PPK II 13000000             39244                1,083,333.33      216,666.67
19   Kelompok   Kel. Salak(Perg)    15800000          39315                1,316,666.67      263,333.33
20   Kelompok   NURUL HIKMAH 16300000                 39337                1,358,333.33      271,666.67
21   Kelompok   AINUN NISA          15000000          39428                1,250,000.00      250,000.00
22   Kelompok   Kel. Sawo PPK II 16500000             39545                1,375,000.00      275,000.00
23   Kelompok   Kel. Salak(Lunas) 22800000            39647                1,900,000.00      380,000.00
24   Kelompok   AL-HIKMAH           21100000          39682                1,758,333.33      351,666.67
25   Kelompok   AINUN NISA          23500000          39797                1,958,333.33      391,666.67
26   Kelompok   Kel. Sawo PPK II 24500000             39889                2,041,666.67      408,333.33
27   Kelompok   ASSYFA PNPM.MP15000000                39969                1,250,000.00      250,000.00
28   Kelompok   NURUL IMAN PNPM.MP  15000000          39969                1,250,000.00      250,000.00
29   Kelompok   ALBAROKAH PNPM.MP   15000000          39969                1,250,000.00      250,000.00
30   Kelompok   ALIYAH PNPM.MP15000000                39969                1,250,000.00      250,000.00
31   Kelompok   MANGGIS PNPM.MP     11000000          39969                  916,666.67      183,333.33
32   Kelompok   SALAK (Perg)        18000000          39969                1,500,000.00      300,000.00
33   Kelompok   0                   0                 0                             -               -
34   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
35   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
36   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
37   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
38   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
 39   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 40   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 41   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 42   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 43   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 44   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 45   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 46   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 47   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 48   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 49   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 50   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!

       T o t a l                       #REF!           #REF!           #REF!   #REF!   ######

MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
              UNIT PENGELOLA KEGIATAN
        LAPORAN PERKEMBANGAN PINJAMAN SPP
  TANGGAL : 30      BULAN : APRIL     TAHUN : 2009




Target Pengembalian Kumulatif     Realisasi Pengembalian       Realisasi Pengembalian     Realisasi Pengembalian
         s/d Bulan ini                 s/d Bulan lalu                 Bulan ini                s/d Bulan ini

  Pokok               Bunga      Pokok             Bunga       Pokok            Bunga    Pokok

     5                  6          7                  8          9                10      11
          -               -      3,300,000           612,000                             3,300,000
          -               -      6,000,000         1,200,000                             6,000,000
          -               -      5,300,000         1,060,000                             5,300,000
          -               -      4,200,000           840,000                             4,200,000
          -               -      5,100,000         1,020,000                             5,100,000
          -               -      6,400,000         1,280,000                             6,400,000
          -               -      9,500,000         1,729,000                             9,500,000
          -               -      8,100,000         1,458,000                             8,100,000
          -               -      7,100,000         1,278,000                             7,100,000
          -               -      6,800,000         1,224,000                             6,800,000
          -               -     11,890,000         1,463,400                            11,890,000
          -               -      9,900,000         1,394,000                             9,900,000
          -               -     10,300,000         1,854,000                            10,300,000
          -               -      3,220,000           460,800                             3,220,000
          -               -      3,270,000           588,600                             3,270,000
          -               -     12,500,000         1,350,000                            12,500,000
          -               -     11,250,000         2,025,000                            11,250,000
          -               -     13,000,000         2,340,000                            13,000,000
          -               -     15,800,000         2,844,000                            15,800,000
          -               -     16,300,000         2,934,000                            16,300,000
          -               -     15,000,000         2,700,000                            15,000,000
          -               -     16,500,000         2,970,000                            16,500,000
          -               -     22,800,000         4,560,000                            22,800,000
          -               -     16,255,000         1,606,000                            16,255,000
          -               -     17,515,000         3,070,000                            17,515,000
          -               -     22,050,000         4,410,000                            22,050,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      6,625,000         1,240,000                             6,625,000
          -               -      7,550,000         1,400,000                             7,550,000
          -               -      6,200,000         1,240,000                             6,200,000
          -               -     10,300,000         2,060,000                            10,300,000
          -               -            -                 -                                     -
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!

#REF!   #REF!   #REF!   #REF!   -   -   #REF!
                                                                                                                    Desa
                                                                                                                    Kecamatan
                                                                                                                    Kabupaten
Realisasi Pengembalian                           %
                                                             Tunggakan Pengembalian s/d bln ini
     s/d Bulan ini                                                                                   Rumus
                              Saldo Pinjaman
                                               Pengem                                                               NO.
                                                                                                    berapa bln
                  Bunga                         balian   Tungga       Pokok              Bunga      menunggak
                                                          kan
                   12            13=3-11       14=11/5   Pokok       15=5-11            16=6-12                       1
                    612,000            -       #DIV/0!              (3,300,000)         (612,000)          (12)       1
                  1,200,000            -       #DIV/0!              (6,000,000)       (1,200,000)          (12)       2
                  1,060,000            -       #DIV/0!              (5,300,000)       (1,060,000)          (12)       3
                    840,000            -       #DIV/0!              (4,200,000)         (840,000)      (12.000)       4
                  1,020,000            -       #DIV/0!              (5,100,000)       (1,020,000)          (12)       5
                  1,280,000            -       #DIV/0!              (6,400,000)       (1,280,000)          (12)       6
                  1,729,000            -       #DIV/0!              (9,500,000)       (1,729,000)          (12)       7
                  1,458,000            -       #DIV/0!              (8,100,000)       (1,458,000)          (12)       8
                  1,278,000            -       #DIV/0!              (7,100,000)       (1,278,000)          (12)       9
                  1,224,000            -       #DIV/0!              (6,800,000)       (1,224,000)          (12)      10
                  1,463,400        910,000     #DIV/0!             (11,890,000)       (1,463,400)          (11)      11
                  1,394,000            -       #DIV/0!              (9,900,000)       (1,394,000)          (12)      12
                  1,854,000            -       #DIV/0!             (10,300,000)       (1,854,000)          (12)      13
                    460,800      3,180,000     #DIV/0!              (3,220,000)         (460,800)             (6)    14
                    588,600      7,630,000     #DIV/0!              (3,270,000)         (588,600)             (4)    15
                  1,350,000            -       #DIV/0!             (12,500,000)       (1,350,000)          (12)      16
                  2,025,000            -       #DIV/0!             (11,250,000)       (2,025,000)          (12)      17
                  2,340,000            -       #DIV/0!             (13,000,000)       (2,340,000)          (12)      18
                  2,844,000            -       #DIV/0!             (15,800,000)       (2,844,000)          (12)      19
                  2,934,000            -       #DIV/0!             (16,300,000)       (2,934,000)          (12)      20
                  2,700,000            -       #DIV/0!             (15,000,000)       (2,700,000)          (12)      21
                  2,970,000            -       #DIV/0!             (16,500,000)       (2,970,000)          (12)      22
                  4,560,000            -       #DIV/0!             (22,800,000)       (4,560,000)          (12)      23
                  1,606,000      4,845,000     #DIV/0!             (16,255,000)       (1,606,000)             (9)    24
                  3,070,000      5,985,000     #DIV/0!             (17,515,000)       (3,070,000)             (9)    25
                  4,410,000      2,450,000     #DIV/0!             (22,050,000)       (4,410,000)          (11)      26
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    27
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    28
                  1,240,000      8,375,000     #DIV/0!              (6,625,000)       (1,240,000)             (5)    29
                  1,400,000      7,450,000     #DIV/0!              (7,550,000)       (1,400,000)             (6)    30
                  1,240,000      4,800,000     #DIV/0!              (6,200,000)       (1,240,000)             (7)    31
                  2,060,000      7,700,000     #DIV/0!             (10,300,000)       (2,060,000)             (7)    32
                        -              -       #DIV/0!                     -                 -       #DIV/0!         33
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          34
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          35
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          36
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          37
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          38
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   39
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   40
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   41
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   42
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   43
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   44
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   45
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   46
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   47
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   48
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   49
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   50

#REF!   #REF!   #REF!   #REF!   #REF!                TOTAL
                                                          UNIT PENGELOLA KEGIATAN
                                                    LAPORAN KOLEKTIBILITAS PINJAMAN SPP
                                              TANGGAL : 30      BULAN : APRIL     TAHUN : 2009

                 : SUKASLAMET
Kecamatan        : KROYA
Kabupaten        : INDRAMAYU
                                    SALDO PINJAMAN         SISA PINJAMAN         SISA PINJAMAN               SISA PINJAMAN

                                      BULAN INI          YG ANGSURAN LANCAR     YG MENUNGGAK                YG MENUNGGAK
     KELOMPOK/DESA                (KOLOM 13 LAPORAN      (TANPA TUNGGAKAN)    1 S/D 2 KALI ANGSURAN       3 S/D 4 KALI ANGSURAN

                                PERKEMBANGAN PINJAMAN)   KOLEKTIBILITAS I     KOLEKTIBILITAS II           KOLEKTIBILITAS III

                 2                      3                        4                     5                           6
      Kelompok    Kel. Mawar                     -                      -                             -                           -
      Kelompok    Kel. Salak                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II             -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III            -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III      910,000                910,000                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II     3,180,000              3,180,000                             -                           -
      Kelompok    Kel.Mawar(Perg)        7,630,000              7,630,000                             -                           -
      Kelompok    AL-BAROKAH                     -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    AINUN NISA                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Lunas)              -                      -                             -                           -
      Kelompok    AL-HIKMAH              4,845,000              4,845,000                             -                           -
      Kelompok    AINUN NISA             5,985,000              5,985,000                             -                           -
      Kelompok    Kel. Sawo PPK II       2,450,000              2,450,000                             -                           -
      Kelompok    ASSYFA PNPM.MP         9,500,000              9,500,000                             -                           -
      Kelompok    NURUL IMAN PNPM.MP 9,500,000                  9,500,000                             -                           -
      Kelompok    ALBAROKAH PNPM.MP 8,375,000                   8,375,000                             -                           -
      Kelompok    ALIYAH PNPM.MP         7,450,000              7,450,000                             -                           -
      Kelompok    MANGGIS PNPM.MP        4,800,000              4,800,000                             -                           -
      Kelompok    SALAK (Perg)           7,700,000              7,700,000                             -                           -
      Kelompok               -                   -                      -                             -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -

        TOTAL                             #REF!                    #REF!                           -             -


                                   CADANGAN RESIKO          JUMLAH PINJAMAN       JUMLAH CADANGAN
     TINGKAT
                                        PINJAMAN                                      RESIKO           Diketahui dan disetujui Ole
  KOLEKTIBILITAS                            (1)                      (2)              "(3=1 X 2)
KOLEKTIBILITAS I                           1%              #REF!                       #REF!
KOLEKTIBILITAS II                         10%                                 -                    -
KOLEKTIBILITAS III                        25%                                 -                    -
KOLEKTIBILITAS IV                         50%                                 -                    -
KOLEKTIBILITAS V                         100%                                 -                    -
                                        TOTAL              #REF!                       #REF!               ( Rosdianah, Amd. )
                                     RASIO CADANGAN PINJAMAN (%)                                               Ketua UPK
                                                                                       #REF!
                                         (TOTAL (3) / TOTAL (2) )
MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
PP
UN : 2009




               SISA PINJAMAN               SISA PINJAMAN YG

              YG MENUNGGAK              MENUNGGAK DIATAS 6 KALI

            5 S/D 6 KALI ANGSURAN             ANGSURAN

            KOLEKTIBILITAS IV             KOLEKTIBILITAS V

                     7                            8
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -

                               -                       -



Diketahui dan disetujui Oleh         Dibuat oleh




    ( Rosdianah, Amd. )            ( Inah Carsinah )
        Ketua UPK                  Bendahara UPK
                                                                                                                                   UN
      MENU UTAMA                                                                                                             LAPORA
                                                                                                                        TANGGAL : 31

Desa            : SUKASLAMET
Kecamatan       : KROYA
Kabupaten       : INDRAMAYU

                                                      Realisasi Pinjaman                                      Target
No          Kelompok               Alokasi Pinjaman
                                                        (Tgl/Bln/Thn)
                                                                           Angsuran Pokok   Angsuran Bunga
                                                                                                             angs. ke


 1                2                       3                   4
1    Kelompok   Kel. Mawar          3300000           37972                  275,000.00       55,000.00
2    Kelompok   Kel. Salak          6000000           37972                  500,000.00      100,000.00
3    Kelompok   Kel. Sawo PPK II 5300000              38292                  441,666.67       88,333.33
4    Kelompok   Kel. Dahlia PPK II 4200000            38292                  350,000.00       70,000.00
5    Kelompok   Kel.Mawar(Perg) 5100000               38292                  425,000.00       85,000.00
6    Kelompok   Kel. Salak(Perg)    6400000           38292                  533,333.33      106,666.67
7    Kelompok   Kel. Pisang PPK III 9500000           38603                  791,666.67      158,333.33
8    Kelompok   Kel.Mawar(Perg) 8100000               38628                  675,000.00      135,000.00
9    Kelompok   Kel. Salak(Perg)    7100000           38628                  591,666.67      118,333.33
10   Kelompok   Kel. Sawo PPK II 6800000              38628                  566,666.67      113,333.33
11   Kelompok   Kel. Pisang PPK III 12800000          38916                1,066,666.67      213,333.33
12   Kelompok   Kel. Sawo PPK II 9900000              38628                  825,000.00      165,000.00
13   Kelompok   Kel. Salak(Perg)    10300000          38628                  858,333.33      171,666.67
14   Kelompok   Kel. Dahlia PPK II 6400000            39007                  533,333.33      106,666.67
15   Kelompok   Kel.Mawar(Perg) 10900000              39007                  908,333.33      181,666.67
16   Kelompok   AL-BAROKAH          12500000          39027                1,041,666.67      208,333.33
17   Kelompok   NURUL HIKMAH 11250000                 39027                  937,500.00      187,500.00
18   Kelompok   Kel. Sawo PPK II 13000000             39244                1,083,333.33      216,666.67
19   Kelompok   Kel. Salak(Perg)    15800000          39315                1,316,666.67      263,333.33
20   Kelompok   NURUL HIKMAH 16300000                 39337                1,358,333.33      271,666.67
21   Kelompok   AINUN NISA          15000000          39428                1,250,000.00      250,000.00
22   Kelompok   Kel. Sawo PPK II 16500000             39545                1,375,000.00      275,000.00
23   Kelompok   Kel. Salak(Lunas) 22800000            39647                1,900,000.00      380,000.00
24   Kelompok   AL-HIKMAH           21100000          39682                1,758,333.33      351,666.67
25   Kelompok   AINUN NISA          23500000          39797                1,958,333.33      391,666.67
26   Kelompok   Kel. Sawo PPK II 24500000             39889                2,041,666.67      408,333.33
27   Kelompok   ASSYFA PNPM.MP15000000                39969                1,250,000.00      250,000.00
28   Kelompok   NURUL IMAN PNPM.MP  15000000          39969                1,250,000.00      250,000.00
29   Kelompok   ALBAROKAH PNPM.MP   15000000          39969                1,250,000.00      250,000.00
30   Kelompok   ALIYAH PNPM.MP15000000                39969                1,250,000.00      250,000.00
31   Kelompok   MANGGIS PNPM.MP     11000000          39969                  916,666.67      183,333.33
32   Kelompok   SALAK (Perg)        18000000          39969                1,500,000.00      300,000.00
33   Kelompok   0                   0                 0                             -               -
34   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
35   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
36   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
37   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
38   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
 39   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 40   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 41   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 42   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 43   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 44   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 45   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 46   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 47   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 48   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 49   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 50   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!

       T o t a l                       #REF!           #REF!           #REF!   #REF!   ######

MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
              UNIT PENGELOLA KEGIATAN
        LAPORAN PERKEMBANGAN PINJAMAN SPP
   TANGGAL : 31      BULAN : MEI     TAHUN : 2009




Target Pengembalian Kumulatif     Realisasi Pengembalian       Realisasi Pengembalian     Realisasi Pengembalian
         s/d Bulan ini                 s/d Bulan lalu                 Bulan ini                s/d Bulan ini

  Pokok               Bunga      Pokok             Bunga       Pokok            Bunga    Pokok

     5                  6          7                  8          9                10      11
          -               -      3,300,000           612,000                             3,300,000
          -               -      6,000,000         1,200,000                             6,000,000
          -               -      5,300,000         1,060,000                             5,300,000
          -               -      4,200,000           840,000                             4,200,000
          -               -      5,100,000         1,020,000                             5,100,000
          -               -      6,400,000         1,280,000                             6,400,000
          -               -      9,500,000         1,729,000                             9,500,000
          -               -      8,100,000         1,458,000                             8,100,000
          -               -      7,100,000         1,278,000                             7,100,000
          -               -      6,800,000         1,224,000                             6,800,000
          -               -     11,890,000         1,463,400                            11,890,000
          -               -      9,900,000         1,394,000                             9,900,000
          -               -     10,300,000         1,854,000                            10,300,000
          -               -      3,220,000           460,800                             3,220,000
          -               -      3,270,000           588,600                             3,270,000
          -               -     12,500,000         1,350,000                            12,500,000
          -               -     11,250,000         2,025,000                            11,250,000
          -               -     13,000,000         2,340,000                            13,000,000
          -               -     15,800,000         2,844,000                            15,800,000
          -               -     16,300,000         2,934,000                            16,300,000
          -               -     15,000,000         2,700,000                            15,000,000
          -               -     16,500,000         2,970,000                            16,500,000
          -               -     22,800,000         4,560,000                            22,800,000
          -               -     16,255,000         1,606,000                            16,255,000
          -               -     17,515,000         3,070,000                            17,515,000
          -               -     22,050,000         4,410,000                            22,050,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      6,625,000         1,240,000                             6,625,000
          -               -      7,550,000         1,400,000                             7,550,000
          -               -      6,200,000         1,240,000                             6,200,000
          -               -     10,300,000         2,060,000                            10,300,000
          -               -            -                 -                                     -
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!

#REF!   #REF!   #REF!   #REF!   -   -   #REF!
                                                                                                                    Desa
                                                                                                                    Kecamatan
                                                                                                                    Kabupaten
Realisasi Pengembalian                           %
                                                             Tunggakan Pengembalian s/d bln ini
     s/d Bulan ini                                                                                   Rumus
                              Saldo Pinjaman
                                               Pengem                                                               NO.
                                                                                                    berapa bln
                  Bunga                         balian   Tungga       Pokok              Bunga      menunggak
                                                          kan
                   12            13=3-11       14=11/5   Pokok       15=5-11            16=6-12                       1
                    612,000            -       #DIV/0!              (3,300,000)         (612,000)          (12)       1
                  1,200,000            -       #DIV/0!              (6,000,000)       (1,200,000)          (12)       2
                  1,060,000            -       #DIV/0!              (5,300,000)       (1,060,000)          (12)       3
                    840,000            -       #DIV/0!              (4,200,000)         (840,000)      (12.000)       4
                  1,020,000            -       #DIV/0!              (5,100,000)       (1,020,000)          (12)       5
                  1,280,000            -       #DIV/0!              (6,400,000)       (1,280,000)          (12)       6
                  1,729,000            -       #DIV/0!              (9,500,000)       (1,729,000)          (12)       7
                  1,458,000            -       #DIV/0!              (8,100,000)       (1,458,000)          (12)       8
                  1,278,000            -       #DIV/0!              (7,100,000)       (1,278,000)          (12)       9
                  1,224,000            -       #DIV/0!              (6,800,000)       (1,224,000)          (12)      10
                  1,463,400        910,000     #DIV/0!             (11,890,000)       (1,463,400)          (11)      11
                  1,394,000            -       #DIV/0!              (9,900,000)       (1,394,000)          (12)      12
                  1,854,000            -       #DIV/0!             (10,300,000)       (1,854,000)          (12)      13
                    460,800      3,180,000     #DIV/0!              (3,220,000)         (460,800)             (6)    14
                    588,600      7,630,000     #DIV/0!              (3,270,000)         (588,600)             (4)    15
                  1,350,000            -       #DIV/0!             (12,500,000)       (1,350,000)          (12)      16
                  2,025,000            -       #DIV/0!             (11,250,000)       (2,025,000)          (12)      17
                  2,340,000            -       #DIV/0!             (13,000,000)       (2,340,000)          (12)      18
                  2,844,000            -       #DIV/0!             (15,800,000)       (2,844,000)          (12)      19
                  2,934,000            -       #DIV/0!             (16,300,000)       (2,934,000)          (12)      20
                  2,700,000            -       #DIV/0!             (15,000,000)       (2,700,000)          (12)      21
                  2,970,000            -       #DIV/0!             (16,500,000)       (2,970,000)          (12)      22
                  4,560,000            -       #DIV/0!             (22,800,000)       (4,560,000)          (12)      23
                  1,606,000      4,845,000     #DIV/0!             (16,255,000)       (1,606,000)             (9)    24
                  3,070,000      5,985,000     #DIV/0!             (17,515,000)       (3,070,000)             (9)    25
                  4,410,000      2,450,000     #DIV/0!             (22,050,000)       (4,410,000)          (11)      26
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    27
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    28
                  1,240,000      8,375,000     #DIV/0!              (6,625,000)       (1,240,000)             (5)    29
                  1,400,000      7,450,000     #DIV/0!              (7,550,000)       (1,400,000)             (6)    30
                  1,240,000      4,800,000     #DIV/0!              (6,200,000)       (1,240,000)             (7)    31
                  2,060,000      7,700,000     #DIV/0!             (10,300,000)       (2,060,000)             (7)    32
                        -              -       #DIV/0!                     -                 -       #DIV/0!         33
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          34
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          35
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          36
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          37
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          38
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   39
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   40
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   41
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   42
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   43
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   44
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   45
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   46
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   47
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   48
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   49
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   50

#REF!   #REF!   #REF!   #REF!   #REF!                TOTAL
                                                             UNIT PENGELOLA KEGIATAN
                                                       LAPORAN KOLEKTIBILITAS PINJAMAN SPP
                                                  TANGGAL : 31      BULAN : MEI     TAHUN : 2009

                 : SUKASLAMET
Kecamatan        : KROYA
Kabupaten        : INDRAMAYU
                                    SALDO PINJAMAN         SISA PINJAMAN         SISA PINJAMAN               SISA PINJAMAN

                                      BULAN INI          YG ANGSURAN LANCAR     YG MENUNGGAK                YG MENUNGGAK
     KELOMPOK/DESA                (KOLOM 13 LAPORAN      (TANPA TUNGGAKAN)    1 S/D 2 KALI ANGSURAN       3 S/D 4 KALI ANGSURAN

                                PERKEMBANGAN PINJAMAN)   KOLEKTIBILITAS I     KOLEKTIBILITAS II           KOLEKTIBILITAS III

                 2                      3                        4                     5                           6
      Kelompok    Kel. Mawar                     -                      -                             -                           -
      Kelompok    Kel. Salak                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II             -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III            -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III      910,000                910,000                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II     3,180,000              3,180,000                             -                           -
      Kelompok    Kel.Mawar(Perg)        7,630,000              7,630,000                             -                           -
      Kelompok    AL-BAROKAH                     -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    AINUN NISA                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Lunas)              -                      -                             -                           -
      Kelompok    AL-HIKMAH              4,845,000              4,845,000                             -                           -
      Kelompok    AINUN NISA             5,985,000              5,985,000                             -                           -
      Kelompok    Kel. Sawo PPK II       2,450,000              2,450,000                             -                           -
      Kelompok    ASSYFA PNPM.MP         9,500,000              9,500,000                             -                           -
      Kelompok    NURUL IMAN PNPM.MP 9,500,000                  9,500,000                             -                           -
      Kelompok    ALBAROKAH PNPM.MP 8,375,000                   8,375,000                             -                           -
      Kelompok    ALIYAH PNPM.MP         7,450,000              7,450,000                             -                           -
      Kelompok    MANGGIS PNPM.MP        4,800,000              4,800,000                             -                           -
      Kelompok    SALAK (Perg)           7,700,000              7,700,000                             -                           -
      Kelompok               -                   -                      -                             -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -

        TOTAL                             #REF!                    #REF!                           -             -


                                   CADANGAN RESIKO          JUMLAH PINJAMAN       JUMLAH CADANGAN
     TINGKAT
                                        PINJAMAN                                      RESIKO           Diketahui dan disetujui Ole
  KOLEKTIBILITAS                            (1)                      (2)              "(3=1 X 2)
KOLEKTIBILITAS I                           1%              #REF!                       #REF!
KOLEKTIBILITAS II                         10%                                 -                    -
KOLEKTIBILITAS III                        25%                                 -                    -
KOLEKTIBILITAS IV                         50%                                 -                    -
KOLEKTIBILITAS V                         100%                                 -                    -
                                        TOTAL              #REF!                       #REF!               ( Rosdianah, Amd. )
                                     RASIO CADANGAN PINJAMAN (%)                                               Ketua UPK
                                                                                       #REF!
                                         (TOTAL (3) / TOTAL (2) )
MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
PP
UN : 2009




               SISA PINJAMAN               SISA PINJAMAN YG

              YG MENUNGGAK              MENUNGGAK DIATAS 6 KALI

            5 S/D 6 KALI ANGSURAN             ANGSURAN

            KOLEKTIBILITAS IV             KOLEKTIBILITAS V

                     7                            8
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -

                               -                       -



Diketahui dan disetujui Oleh         Dibuat oleh




    ( Rosdianah, Amd. )            ( Inah Carsinah )
        Ketua UPK                  Bendahara UPK
                                                                                                                                   UN
      MENU UTAMA                                                                                                              LAPORA
                                                                                                                        TANGGAL : 30

Desa            : SUKASLAMET
Kecamatan       : KROYA
Kabupaten       : INDRAMAYU

                                                      Realisasi Pinjaman                                      Target
No          Kelompok               Alokasi Pinjaman
                                                        (Tgl/Bln/Thn)
                                                                           Angsuran Pokok   Angsuran Bunga
                                                                                                             angs. ke


 1                2                       3                   4
1    Kelompok   Kel. Mawar          3300000           37972                  275,000.00       55,000.00
2    Kelompok   Kel. Salak          6000000           37972                  500,000.00      100,000.00
3    Kelompok   Kel. Sawo PPK II 5300000              38292                  441,666.67       88,333.33
4    Kelompok   Kel. Dahlia PPK II 4200000            38292                  350,000.00       70,000.00
5    Kelompok   Kel.Mawar(Perg) 5100000               38292                  425,000.00       85,000.00
6    Kelompok   Kel. Salak(Perg)    6400000           38292                  533,333.33      106,666.67
7    Kelompok   Kel. Pisang PPK III 9500000           38603                  791,666.67      158,333.33
8    Kelompok   Kel.Mawar(Perg) 8100000               38628                  675,000.00      135,000.00
9    Kelompok   Kel. Salak(Perg)    7100000           38628                  591,666.67      118,333.33
10   Kelompok   Kel. Sawo PPK II 6800000              38628                  566,666.67      113,333.33
11   Kelompok   Kel. Pisang PPK III 12800000          38916                1,066,666.67      213,333.33
12   Kelompok   Kel. Sawo PPK II 9900000              38628                  825,000.00      165,000.00
13   Kelompok   Kel. Salak(Perg)    10300000          38628                  858,333.33      171,666.67
14   Kelompok   Kel. Dahlia PPK II 6400000            39007                  533,333.33      106,666.67
15   Kelompok   Kel.Mawar(Perg) 10900000              39007                  908,333.33      181,666.67
16   Kelompok   AL-BAROKAH          12500000          39027                1,041,666.67      208,333.33
17   Kelompok   NURUL HIKMAH 11250000                 39027                  937,500.00      187,500.00
18   Kelompok   Kel. Sawo PPK II 13000000             39244                1,083,333.33      216,666.67
19   Kelompok   Kel. Salak(Perg)    15800000          39315                1,316,666.67      263,333.33
20   Kelompok   NURUL HIKMAH 16300000                 39337                1,358,333.33      271,666.67
21   Kelompok   AINUN NISA          15000000          39428                1,250,000.00      250,000.00
22   Kelompok   Kel. Sawo PPK II 16500000             39545                1,375,000.00      275,000.00
23   Kelompok   Kel. Salak(Lunas) 22800000            39647                1,900,000.00      380,000.00
24   Kelompok   AL-HIKMAH           21100000          39682                1,758,333.33      351,666.67
25   Kelompok   AINUN NISA          23500000          39797                1,958,333.33      391,666.67
26   Kelompok   Kel. Sawo PPK II 24500000             39889                2,041,666.67      408,333.33
27   Kelompok   ASSYFA PNPM.MP15000000                39969                1,250,000.00      250,000.00
28   Kelompok   NURUL IMAN PNPM.MP  15000000          39969                1,250,000.00      250,000.00
29   Kelompok   ALBAROKAH PNPM.MP   15000000          39969                1,250,000.00      250,000.00
30   Kelompok   ALIYAH PNPM.MP15000000                39969                1,250,000.00      250,000.00
31   Kelompok   MANGGIS PNPM.MP     11000000          39969                  916,666.67      183,333.33
32   Kelompok   SALAK (Perg)        18000000          39969                1,500,000.00      300,000.00
33   Kelompok   0                   0                 0                             -               -
34   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
35   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
36   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
37   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
38   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
 39   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 40   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 41   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 42   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 43   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 44   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 45   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 46   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 47   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 48   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 49   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 50   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!

       T o t a l                       #REF!           #REF!           #REF!   #REF!   ######

MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
              UNIT PENGELOLA KEGIATAN
         LAPORAN PERKEMBANGAN PINJAMAN SPP
   TANGGAL : 30     BULAN : JUNI     TAHUN : 2009




Target Pengembalian Kumulatif     Realisasi Pengembalian       Realisasi Pengembalian     Realisasi Pengembalian
         s/d Bulan ini                 s/d Bulan lalu                 Bulan ini                s/d Bulan ini

  Pokok               Bunga      Pokok             Bunga       Pokok            Bunga    Pokok

     5                  6          7                  8          9                10      11
          -               -      3,300,000           612,000                             3,300,000
          -               -      6,000,000         1,200,000                             6,000,000
          -               -      5,300,000         1,060,000                             5,300,000
          -               -      4,200,000           840,000                             4,200,000
          -               -      5,100,000         1,020,000                             5,100,000
          -               -      6,400,000         1,280,000                             6,400,000
          -               -      9,500,000         1,729,000                             9,500,000
          -               -      8,100,000         1,458,000                             8,100,000
          -               -      7,100,000         1,278,000                             7,100,000
          -               -      6,800,000         1,224,000                             6,800,000
          -               -     11,890,000         1,463,400                            11,890,000
          -               -      9,900,000         1,394,000                             9,900,000
          -               -     10,300,000         1,854,000                            10,300,000
          -               -      3,220,000           460,800                             3,220,000
          -               -      3,270,000           588,600                             3,270,000
          -               -     12,500,000         1,350,000                            12,500,000
          -               -     11,250,000         2,025,000                            11,250,000
          -               -     13,000,000         2,340,000                            13,000,000
          -               -     15,800,000         2,844,000                            15,800,000
          -               -     16,300,000         2,934,000                            16,300,000
          -               -     15,000,000         2,700,000                            15,000,000
          -               -     16,500,000         2,970,000                            16,500,000
          -               -     22,800,000         4,560,000                            22,800,000
          -               -     16,255,000         1,606,000                            16,255,000
          -               -     17,515,000         3,070,000                            17,515,000
          -               -     22,050,000         4,410,000                            22,050,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      6,625,000         1,240,000                             6,625,000
          -               -      7,550,000         1,400,000                             7,550,000
          -               -      6,200,000         1,240,000                             6,200,000
          -               -     10,300,000         2,060,000                            10,300,000
          -               -            -                 -                                     -
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!

#REF!   #REF!   #REF!   #REF!   -   -   #REF!
                                                                                                                    Desa
                                                                                                                    Kecamatan
                                                                                                                    Kabupaten
Realisasi Pengembalian                           %
                                                             Tunggakan Pengembalian s/d bln ini
     s/d Bulan ini                                                                                   Rumus
                              Saldo Pinjaman
                                               Pengem                                                               NO.
                                                                                                    berapa bln
                  Bunga                         balian   Tungga       Pokok              Bunga      menunggak
                                                          kan
                   12            13=3-11       14=11/5   Pokok       15=5-11            16=6-12                       1
                    612,000            -       #DIV/0!              (3,300,000)         (612,000)          (12)       1
                  1,200,000            -       #DIV/0!              (6,000,000)       (1,200,000)          (12)       2
                  1,060,000            -       #DIV/0!              (5,300,000)       (1,060,000)          (12)       3
                    840,000            -       #DIV/0!              (4,200,000)         (840,000)      (12.000)       4
                  1,020,000            -       #DIV/0!              (5,100,000)       (1,020,000)          (12)       5
                  1,280,000            -       #DIV/0!              (6,400,000)       (1,280,000)          (12)       6
                  1,729,000            -       #DIV/0!              (9,500,000)       (1,729,000)          (12)       7
                  1,458,000            -       #DIV/0!              (8,100,000)       (1,458,000)          (12)       8
                  1,278,000            -       #DIV/0!              (7,100,000)       (1,278,000)          (12)       9
                  1,224,000            -       #DIV/0!              (6,800,000)       (1,224,000)          (12)      10
                  1,463,400        910,000     #DIV/0!             (11,890,000)       (1,463,400)          (11)      11
                  1,394,000            -       #DIV/0!              (9,900,000)       (1,394,000)          (12)      12
                  1,854,000            -       #DIV/0!             (10,300,000)       (1,854,000)          (12)      13
                    460,800      3,180,000     #DIV/0!              (3,220,000)         (460,800)             (6)    14
                    588,600      7,630,000     #DIV/0!              (3,270,000)         (588,600)             (4)    15
                  1,350,000            -       #DIV/0!             (12,500,000)       (1,350,000)          (12)      16
                  2,025,000            -       #DIV/0!             (11,250,000)       (2,025,000)          (12)      17
                  2,340,000            -       #DIV/0!             (13,000,000)       (2,340,000)          (12)      18
                  2,844,000            -       #DIV/0!             (15,800,000)       (2,844,000)          (12)      19
                  2,934,000            -       #DIV/0!             (16,300,000)       (2,934,000)          (12)      20
                  2,700,000            -       #DIV/0!             (15,000,000)       (2,700,000)          (12)      21
                  2,970,000            -       #DIV/0!             (16,500,000)       (2,970,000)          (12)      22
                  4,560,000            -       #DIV/0!             (22,800,000)       (4,560,000)          (12)      23
                  1,606,000      4,845,000     #DIV/0!             (16,255,000)       (1,606,000)             (9)    24
                  3,070,000      5,985,000     #DIV/0!             (17,515,000)       (3,070,000)             (9)    25
                  4,410,000      2,450,000     #DIV/0!             (22,050,000)       (4,410,000)          (11)      26
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    27
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    28
                  1,240,000      8,375,000     #DIV/0!              (6,625,000)       (1,240,000)             (5)    29
                  1,400,000      7,450,000     #DIV/0!              (7,550,000)       (1,400,000)             (6)    30
                  1,240,000      4,800,000     #DIV/0!              (6,200,000)       (1,240,000)             (7)    31
                  2,060,000      7,700,000     #DIV/0!             (10,300,000)       (2,060,000)             (7)    32
                        -              -       #DIV/0!                     -                 -       #DIV/0!         33
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          34
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          35
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          36
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          37
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          38
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   39
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   40
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   41
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   42
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   43
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   44
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   45
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   46
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   47
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   48
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   49
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   50

#REF!   #REF!   #REF!   #REF!   #REF!                TOTAL
                                                             UNIT PENGELOLA KEGIATAN
                                                       LAPORAN KOLEKTIBILITAS PINJAMAN SPP
                                                  TANGGAL : 30     BULAN : JUNI     TAHUN : 2009

                 : SUKASLAMET
Kecamatan        : KROYA
Kabupaten        : INDRAMAYU
                                    SALDO PINJAMAN         SISA PINJAMAN         SISA PINJAMAN               SISA PINJAMAN

                                      BULAN INI          YG ANGSURAN LANCAR     YG MENUNGGAK                YG MENUNGGAK
     KELOMPOK/DESA                (KOLOM 13 LAPORAN      (TANPA TUNGGAKAN)    1 S/D 2 KALI ANGSURAN       3 S/D 4 KALI ANGSURAN

                                PERKEMBANGAN PINJAMAN)   KOLEKTIBILITAS I     KOLEKTIBILITAS II           KOLEKTIBILITAS III

                 2                      3                        4                     5                           6
      Kelompok    Kel. Mawar                     -                      -                             -                           -
      Kelompok    Kel. Salak                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II             -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III            -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III      910,000                910,000                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II     3,180,000              3,180,000                             -                           -
      Kelompok    Kel.Mawar(Perg)        7,630,000              7,630,000                             -                           -
      Kelompok    AL-BAROKAH                     -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    AINUN NISA                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Lunas)              -                      -                             -                           -
      Kelompok    AL-HIKMAH              4,845,000              4,845,000                             -                           -
      Kelompok    AINUN NISA             5,985,000              5,985,000                             -                           -
      Kelompok    Kel. Sawo PPK II       2,450,000              2,450,000                             -                           -
      Kelompok    ASSYFA PNPM.MP         9,500,000              9,500,000                             -                           -
      Kelompok    NURUL IMAN PNPM.MP 9,500,000                  9,500,000                             -                           -
      Kelompok    ALBAROKAH PNPM.MP 8,375,000                   8,375,000                             -                           -
      Kelompok    ALIYAH PNPM.MP         7,450,000              7,450,000                             -                           -
      Kelompok    MANGGIS PNPM.MP        4,800,000              4,800,000                             -                           -
      Kelompok    SALAK (Perg)           7,700,000              7,700,000                             -                           -
      Kelompok               -                   -                      -                             -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -

        TOTAL                             #REF!                    #REF!                           -             -


                                   CADANGAN RESIKO          JUMLAH PINJAMAN       JUMLAH CADANGAN
     TINGKAT
                                        PINJAMAN                                      RESIKO           Diketahui dan disetujui Ole
  KOLEKTIBILITAS                            (1)                      (2)              "(3=1 X 2)
KOLEKTIBILITAS I                           1%              #REF!                       #REF!
KOLEKTIBILITAS II                         10%                                 -                    -
KOLEKTIBILITAS III                        25%                                 -                    -
KOLEKTIBILITAS IV                         50%                                 -                    -
KOLEKTIBILITAS V                         100%                                 -                    -
                                        TOTAL              #REF!                       #REF!               ( Rosdianah, Amd. )
                                     RASIO CADANGAN PINJAMAN (%)                                               Ketua UPK
                                                                                       #REF!
                                         (TOTAL (3) / TOTAL (2) )
MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
PP
UN : 2009




               SISA PINJAMAN               SISA PINJAMAN YG

              YG MENUNGGAK              MENUNGGAK DIATAS 6 KALI

            5 S/D 6 KALI ANGSURAN             ANGSURAN

            KOLEKTIBILITAS IV             KOLEKTIBILITAS V

                     7                            8
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -

                               -                       -



Diketahui dan disetujui Oleh         Dibuat oleh




    ( Rosdianah, Amd. )            ( Inah Carsinah )
        Ketua UPK                  Bendahara UPK
                                                                                                                                   UN
      MENU UTAMA                                                                                                              LAPORA
                                                                                                                        TANGGAL : 31

Desa            : SUKASLAMET
Kecamatan       : KROYA
Kabupaten       : INDRAMAYU

                                                      Realisasi Pinjaman                                      Target
No          Kelompok               Alokasi Pinjaman
                                                        (Tgl/Bln/Thn)
                                                                           Angsuran Pokok   Angsuran Bunga
                                                                                                             angs. ke


 1                2                       3                   4
1    Kelompok   Kel. Mawar          3300000           37972                  275,000.00       55,000.00
2    Kelompok   Kel. Salak          6000000           37972                  500,000.00      100,000.00
3    Kelompok   Kel. Sawo PPK II 5300000              38292                  441,666.67       88,333.33
4    Kelompok   Kel. Dahlia PPK II 4200000            38292                  350,000.00       70,000.00
5    Kelompok   Kel.Mawar(Perg) 5100000               38292                  425,000.00       85,000.00
6    Kelompok   Kel. Salak(Perg)    6400000           38292                  533,333.33      106,666.67
7    Kelompok   Kel. Pisang PPK III 9500000           38603                  791,666.67      158,333.33
8    Kelompok   Kel.Mawar(Perg) 8100000               38628                  675,000.00      135,000.00
9    Kelompok   Kel. Salak(Perg)    7100000           38628                  591,666.67      118,333.33
10   Kelompok   Kel. Sawo PPK II 6800000              38628                  566,666.67      113,333.33
11   Kelompok   Kel. Pisang PPK III 12800000          38916                1,066,666.67      213,333.33
12   Kelompok   Kel. Sawo PPK II 9900000              38628                  825,000.00      165,000.00
13   Kelompok   Kel. Salak(Perg)    10300000          38628                  858,333.33      171,666.67
14   Kelompok   Kel. Dahlia PPK II 6400000            39007                  533,333.33      106,666.67
15   Kelompok   Kel.Mawar(Perg) 10900000              39007                  908,333.33      181,666.67
16   Kelompok   AL-BAROKAH          12500000          39027                1,041,666.67      208,333.33
17   Kelompok   NURUL HIKMAH 11250000                 39027                  937,500.00      187,500.00
18   Kelompok   Kel. Sawo PPK II 13000000             39244                1,083,333.33      216,666.67
19   Kelompok   Kel. Salak(Perg)    15800000          39315                1,316,666.67      263,333.33
20   Kelompok   NURUL HIKMAH 16300000                 39337                1,358,333.33      271,666.67
21   Kelompok   AINUN NISA          15000000          39428                1,250,000.00      250,000.00
22   Kelompok   Kel. Sawo PPK II 16500000             39545                1,375,000.00      275,000.00
23   Kelompok   Kel. Salak(Lunas) 22800000            39647                1,900,000.00      380,000.00
24   Kelompok   AL-HIKMAH           21100000          39682                1,758,333.33      351,666.67
25   Kelompok   AINUN NISA          23500000          39797                1,958,333.33      391,666.67
26   Kelompok   Kel. Sawo PPK II 24500000             39889                2,041,666.67      408,333.33
27   Kelompok   ASSYFA PNPM.MP15000000                39969                1,250,000.00      250,000.00
28   Kelompok   NURUL IMAN PNPM.MP  15000000          39969                1,250,000.00      250,000.00
29   Kelompok   ALBAROKAH PNPM.MP   15000000          39969                1,250,000.00      250,000.00
30   Kelompok   ALIYAH PNPM.MP15000000                39969                1,250,000.00      250,000.00
31   Kelompok   MANGGIS PNPM.MP     11000000          39969                  916,666.67      183,333.33
32   Kelompok   SALAK (Perg)        18000000          39969                1,500,000.00      300,000.00
33   Kelompok   0                   0                 0                             -               -
34   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
35   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
36   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
37   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
38   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
 39   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 40   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 41   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 42   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 43   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 44   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 45   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 46   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 47   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 48   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 49   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 50   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!

       T o t a l                       #REF!           #REF!           #REF!   #REF!   ######

MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
              UNIT PENGELOLA KEGIATAN
         LAPORAN PERKEMBANGAN PINJAMAN SPP
   TANGGAL : 31      BULAN : JULI    TAHUN : 2009




Target Pengembalian Kumulatif     Realisasi Pengembalian       Realisasi Pengembalian     Realisasi Pengembalian
         s/d Bulan ini                 s/d Bulan lalu                 Bulan ini                s/d Bulan ini

  Pokok               Bunga      Pokok             Bunga       Pokok            Bunga    Pokok

     5                  6          7                  8          9                10      11
          -               -      3,300,000           612,000                             3,300,000
          -               -      6,000,000         1,200,000                             6,000,000
          -               -      5,300,000         1,060,000                             5,300,000
          -               -      4,200,000           840,000                             4,200,000
          -               -      5,100,000         1,020,000                             5,100,000
          -               -      6,400,000         1,280,000                             6,400,000
          -               -      9,500,000         1,729,000                             9,500,000
          -               -      8,100,000         1,458,000                             8,100,000
          -               -      7,100,000         1,278,000                             7,100,000
          -               -      6,800,000         1,224,000                             6,800,000
          -               -     11,890,000         1,463,400                            11,890,000
          -               -      9,900,000         1,394,000                             9,900,000
          -               -     10,300,000         1,854,000                            10,300,000
          -               -      3,220,000           460,800                             3,220,000
          -               -      3,270,000           588,600                             3,270,000
          -               -     12,500,000         1,350,000                            12,500,000
          -               -     11,250,000         2,025,000                            11,250,000
          -               -     13,000,000         2,340,000                            13,000,000
          -               -     15,800,000         2,844,000                            15,800,000
          -               -     16,300,000         2,934,000                            16,300,000
          -               -     15,000,000         2,700,000                            15,000,000
          -               -     16,500,000         2,970,000                            16,500,000
          -               -     22,800,000         4,560,000                            22,800,000
          -               -     16,255,000         1,606,000                            16,255,000
          -               -     17,515,000         3,070,000                            17,515,000
          -               -     22,050,000         4,410,000                            22,050,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      6,625,000         1,240,000                             6,625,000
          -               -      7,550,000         1,400,000                             7,550,000
          -               -      6,200,000         1,240,000                             6,200,000
          -               -     10,300,000         2,060,000                            10,300,000
          -               -            -                 -                                     -
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!

#REF!   #REF!   #REF!   #REF!   -   -   #REF!
                                                                                                                    Desa
                                                                                                                    Kecamatan
                                                                                                                    Kabupaten
Realisasi Pengembalian                           %
                                                             Tunggakan Pengembalian s/d bln ini
     s/d Bulan ini                                                                                   Rumus
                              Saldo Pinjaman
                                               Pengem                                                               NO.
                                                                                                    berapa bln
                  Bunga                         balian   Tungga       Pokok              Bunga      menunggak
                                                          kan
                   12            13=3-11       14=11/5   Pokok       15=5-11            16=6-12                       1
                    612,000            -       #DIV/0!              (3,300,000)         (612,000)          (12)       1
                  1,200,000            -       #DIV/0!              (6,000,000)       (1,200,000)          (12)       2
                  1,060,000            -       #DIV/0!              (5,300,000)       (1,060,000)          (12)       3
                    840,000            -       #DIV/0!              (4,200,000)         (840,000)      (12.000)       4
                  1,020,000            -       #DIV/0!              (5,100,000)       (1,020,000)          (12)       5
                  1,280,000            -       #DIV/0!              (6,400,000)       (1,280,000)          (12)       6
                  1,729,000            -       #DIV/0!              (9,500,000)       (1,729,000)          (12)       7
                  1,458,000            -       #DIV/0!              (8,100,000)       (1,458,000)          (12)       8
                  1,278,000            -       #DIV/0!              (7,100,000)       (1,278,000)          (12)       9
                  1,224,000            -       #DIV/0!              (6,800,000)       (1,224,000)          (12)      10
                  1,463,400        910,000     #DIV/0!             (11,890,000)       (1,463,400)          (11)      11
                  1,394,000            -       #DIV/0!              (9,900,000)       (1,394,000)          (12)      12
                  1,854,000            -       #DIV/0!             (10,300,000)       (1,854,000)          (12)      13
                    460,800      3,180,000     #DIV/0!              (3,220,000)         (460,800)             (6)    14
                    588,600      7,630,000     #DIV/0!              (3,270,000)         (588,600)             (4)    15
                  1,350,000            -       #DIV/0!             (12,500,000)       (1,350,000)          (12)      16
                  2,025,000            -       #DIV/0!             (11,250,000)       (2,025,000)          (12)      17
                  2,340,000            -       #DIV/0!             (13,000,000)       (2,340,000)          (12)      18
                  2,844,000            -       #DIV/0!             (15,800,000)       (2,844,000)          (12)      19
                  2,934,000            -       #DIV/0!             (16,300,000)       (2,934,000)          (12)      20
                  2,700,000            -       #DIV/0!             (15,000,000)       (2,700,000)          (12)      21
                  2,970,000            -       #DIV/0!             (16,500,000)       (2,970,000)          (12)      22
                  4,560,000            -       #DIV/0!             (22,800,000)       (4,560,000)          (12)      23
                  1,606,000      4,845,000     #DIV/0!             (16,255,000)       (1,606,000)             (9)    24
                  3,070,000      5,985,000     #DIV/0!             (17,515,000)       (3,070,000)             (9)    25
                  4,410,000      2,450,000     #DIV/0!             (22,050,000)       (4,410,000)          (11)      26
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    27
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    28
                  1,240,000      8,375,000     #DIV/0!              (6,625,000)       (1,240,000)             (5)    29
                  1,400,000      7,450,000     #DIV/0!              (7,550,000)       (1,400,000)             (6)    30
                  1,240,000      4,800,000     #DIV/0!              (6,200,000)       (1,240,000)             (7)    31
                  2,060,000      7,700,000     #DIV/0!             (10,300,000)       (2,060,000)             (7)    32
                        -              -       #DIV/0!                     -                 -       #DIV/0!         33
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          34
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          35
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          36
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          37
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          38
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   39
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   40
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   41
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   42
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   43
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   44
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   45
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   46
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   47
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   48
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   49
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   50

#REF!   #REF!   #REF!   #REF!   #REF!                TOTAL
                                                             UNIT PENGELOLA KEGIATAN
                                                       LAPORAN KOLEKTIBILITAS PINJAMAN SPP
                                                  TANGGAL : 31      BULAN : JULI    TAHUN : 2009

                 : SUKASLAMET
Kecamatan        : KROYA
Kabupaten        : INDRAMAYU
                                    SALDO PINJAMAN         SISA PINJAMAN         SISA PINJAMAN               SISA PINJAMAN

                                      BULAN INI          YG ANGSURAN LANCAR     YG MENUNGGAK                YG MENUNGGAK
     KELOMPOK/DESA                (KOLOM 13 LAPORAN      (TANPA TUNGGAKAN)    1 S/D 2 KALI ANGSURAN       3 S/D 4 KALI ANGSURAN

                                PERKEMBANGAN PINJAMAN)   KOLEKTIBILITAS I     KOLEKTIBILITAS II           KOLEKTIBILITAS III

                 2                      3                        4                     5                           6
      Kelompok    Kel. Mawar                     -                      -                             -                           -
      Kelompok    Kel. Salak                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II             -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III            -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III      910,000                910,000                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II     3,180,000              3,180,000                             -                           -
      Kelompok    Kel.Mawar(Perg)        7,630,000              7,630,000                             -                           -
      Kelompok    AL-BAROKAH                     -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    AINUN NISA                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Lunas)              -                      -                             -                           -
      Kelompok    AL-HIKMAH              4,845,000              4,845,000                             -                           -
      Kelompok    AINUN NISA             5,985,000              5,985,000                             -                           -
      Kelompok    Kel. Sawo PPK II       2,450,000              2,450,000                             -                           -
      Kelompok    ASSYFA PNPM.MP         9,500,000              9,500,000                             -                           -
      Kelompok    NURUL IMAN PNPM.MP 9,500,000                  9,500,000                             -                           -
      Kelompok    ALBAROKAH PNPM.MP 8,375,000                   8,375,000                             -                           -
      Kelompok    ALIYAH PNPM.MP         7,450,000              7,450,000                             -                           -
      Kelompok    MANGGIS PNPM.MP        4,800,000              4,800,000                             -                           -
      Kelompok    SALAK (Perg)           7,700,000              7,700,000                             -                           -
      Kelompok               -                   -                      -                             -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -

        TOTAL                             #REF!                    #REF!                           -             -


                                   CADANGAN RESIKO          JUMLAH PINJAMAN       JUMLAH CADANGAN
     TINGKAT
                                        PINJAMAN                                      RESIKO           Diketahui dan disetujui Ole
  KOLEKTIBILITAS                            (1)                      (2)              "(3=1 X 2)
KOLEKTIBILITAS I                           1%              #REF!                       #REF!
KOLEKTIBILITAS II                         10%                                 -                    -
KOLEKTIBILITAS III                        25%                                 -                    -
KOLEKTIBILITAS IV                         50%                                 -                    -
KOLEKTIBILITAS V                         100%                                 -                    -
                                        TOTAL              #REF!                       #REF!               ( Rosdianah, Amd. )
                                     RASIO CADANGAN PINJAMAN (%)                                               Ketua UPK
                                                                                       #REF!
                                         (TOTAL (3) / TOTAL (2) )
MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
PP
UN : 2009




               SISA PINJAMAN               SISA PINJAMAN YG

              YG MENUNGGAK              MENUNGGAK DIATAS 6 KALI

            5 S/D 6 KALI ANGSURAN             ANGSURAN

            KOLEKTIBILITAS IV             KOLEKTIBILITAS V

                     7                            8
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                                    -                             -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -

                               -                       -



Diketahui dan disetujui Oleh         Dibuat oleh




    ( Rosdianah, Amd. )            ( Inah Carsinah )
        Ketua UPK                  Bendahara UPK
                                                                                                                                     UN
      MENU UTAMA                                                                                                               LAPORA
                                                                                                                        TANGGAL : 31

Desa            : SUKASLAMET
Kecamatan       : KROYA
Kabupaten       : INDRAMAYU

                                                      Realisasi Pinjaman                                      Target
No          Kelompok               Alokasi Pinjaman
                                                        (Tgl/Bln/Thn)
                                                                           Angsuran Pokok   Angsuran Bunga
                                                                                                             angs. ke


 1                2                       3                   4
1    Kelompok   Kel. Mawar          3300000           37972                  275,000.00       55,000.00
2    Kelompok   Kel. Salak          6000000           37972                  500,000.00      100,000.00
3    Kelompok   Kel. Sawo PPK II 5300000              38292                  441,666.67       88,333.33
4    Kelompok   Kel. Dahlia PPK II 4200000            38292                  350,000.00       70,000.00
5    Kelompok   Kel.Mawar(Perg) 5100000               38292                  425,000.00       85,000.00
6    Kelompok   Kel. Salak(Perg)    6400000           38292                  533,333.33      106,666.67
7    Kelompok   Kel. Pisang PPK III 9500000           38603                  791,666.67      158,333.33
8    Kelompok   Kel.Mawar(Perg) 8100000               38628                  675,000.00      135,000.00
9    Kelompok   Kel. Salak(Perg)    7100000           38628                  591,666.67      118,333.33
10   Kelompok   Kel. Sawo PPK II 6800000              38628                  566,666.67      113,333.33
11   Kelompok   Kel. Pisang PPK III 12800000          38916                1,066,666.67      213,333.33
12   Kelompok   Kel. Sawo PPK II 9900000              38628                  825,000.00      165,000.00
13   Kelompok   Kel. Salak(Perg)    10300000          38628                  858,333.33      171,666.67
14   Kelompok   Kel. Dahlia PPK II 6400000            39007                  533,333.33      106,666.67
15   Kelompok   Kel.Mawar(Perg) 10900000              39007                  908,333.33      181,666.67
16   Kelompok   AL-BAROKAH          12500000          39027                1,041,666.67      208,333.33
17   Kelompok   NURUL HIKMAH 11250000                 39027                  937,500.00      187,500.00
18   Kelompok   Kel. Sawo PPK II 13000000             39244                1,083,333.33      216,666.67
19   Kelompok   Kel. Salak(Perg)    15800000          39315                1,316,666.67      263,333.33
20   Kelompok   NURUL HIKMAH 16300000                 39337                1,358,333.33      271,666.67
21   Kelompok   AINUN NISA          15000000          39428                1,250,000.00      250,000.00
22   Kelompok   Kel. Sawo PPK II 16500000             39545                1,375,000.00      275,000.00
23   Kelompok   Kel. Salak(Lunas) 22800000            39647                1,900,000.00      380,000.00
24   Kelompok   AL-HIKMAH           21100000          39682                1,758,333.33      351,666.67
25   Kelompok   AINUN NISA          23500000          39797                1,958,333.33      391,666.67
26   Kelompok   Kel. Sawo PPK II 24500000             39889                2,041,666.67      408,333.33
27   Kelompok   ASSYFA PNPM.MP15000000                39969                1,250,000.00      250,000.00
28   Kelompok   NURUL IMAN PNPM.MP  15000000          39969                1,250,000.00      250,000.00
29   Kelompok   ALBAROKAH PNPM.MP   15000000          39969                1,250,000.00      250,000.00
30   Kelompok   ALIYAH PNPM.MP15000000                39969                1,250,000.00      250,000.00
31   Kelompok   MANGGIS PNPM.MP     11000000          39969                  916,666.67      183,333.33
32   Kelompok   SALAK (Perg)        18000000          39969                1,500,000.00      300,000.00
33   Kelompok   0                   0                 0                             -               -
34   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
35   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
36   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
37   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
38   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
 39   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 40   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 41   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 42   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 43   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 44   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 45   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 46   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 47   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 48   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 49   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 50   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!

       T o t a l                       #REF!           #REF!           #REF!   #REF!   ######

MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
             UNIT PENGELOLA KEGIATAN
       LAPORAN PERKEMBANGAN PINJAMAN SPP
TANGGAL : 31      BULAN : AGUSTUS    TAHUN : 2009




Target Pengembalian Kumulatif     Realisasi Pengembalian       Realisasi Pengembalian     Realisasi Pengembalian
         s/d Bulan ini                 s/d Bulan lalu                 Bulan ini                s/d Bulan ini

  Pokok               Bunga      Pokok             Bunga       Pokok            Bunga    Pokok

     5                  6          7                  8          9                10      11
          -               -      3,300,000           612,000                             3,300,000
          -               -      6,000,000         1,200,000                             6,000,000
          -               -      5,300,000         1,060,000                             5,300,000
          -               -      4,200,000           840,000                             4,200,000
          -               -      5,100,000         1,020,000                             5,100,000
          -               -      6,400,000         1,280,000                             6,400,000
          -               -      9,500,000         1,729,000                             9,500,000
          -               -      8,100,000         1,458,000                             8,100,000
          -               -      7,100,000         1,278,000                             7,100,000
          -               -      6,800,000         1,224,000                             6,800,000
          -               -     11,890,000         1,463,400                            11,890,000
          -               -      9,900,000         1,394,000                             9,900,000
          -               -     10,300,000         1,854,000                            10,300,000
          -               -      3,220,000           460,800                             3,220,000
          -               -      3,270,000           588,600                             3,270,000
          -               -     12,500,000         1,350,000                            12,500,000
          -               -     11,250,000         2,025,000                            11,250,000
          -               -     13,000,000         2,340,000                            13,000,000
          -               -     15,800,000         2,844,000                            15,800,000
          -               -     16,300,000         2,934,000                            16,300,000
          -               -     15,000,000         2,700,000                            15,000,000
          -               -     16,500,000         2,970,000                            16,500,000
          -               -     22,800,000         4,560,000                            22,800,000
          -               -     16,255,000         1,606,000                            16,255,000
          -               -     17,515,000         3,070,000                            17,515,000
          -               -     22,050,000         4,410,000                            22,050,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      6,625,000         1,240,000                             6,625,000
          -               -      7,550,000         1,400,000                             7,550,000
          -               -      6,200,000         1,240,000                             6,200,000
          -               -     10,300,000         2,060,000                            10,300,000
          -               -            -                 -                                     -
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!

#REF!   #REF!   #REF!   #REF!   -   -   #REF!
                                                                                                                    Desa
                                                                                                                    Kecamatan
                                                                                                                    Kabupaten
Realisasi Pengembalian                           %
                                                             Tunggakan Pengembalian s/d bln ini
     s/d Bulan ini                                                                                   Rumus
                              Saldo Pinjaman
                                               Pengem                                                               NO.
                                                                                                    berapa bln
                  Bunga                         balian   Tungga       Pokok              Bunga      menunggak
                                                          kan
                   12            13=3-11       14=11/5   Pokok       15=5-11            16=6-12                       1
                    612,000            -       #DIV/0!              (3,300,000)         (612,000)          (12)       1
                  1,200,000            -       #DIV/0!              (6,000,000)       (1,200,000)          (12)       2
                  1,060,000            -       #DIV/0!              (5,300,000)       (1,060,000)          (12)       3
                    840,000            -       #DIV/0!              (4,200,000)         (840,000)      (12.000)       4
                  1,020,000            -       #DIV/0!              (5,100,000)       (1,020,000)          (12)       5
                  1,280,000            -       #DIV/0!              (6,400,000)       (1,280,000)          (12)       6
                  1,729,000            -       #DIV/0!              (9,500,000)       (1,729,000)          (12)       7
                  1,458,000            -       #DIV/0!              (8,100,000)       (1,458,000)          (12)       8
                  1,278,000            -       #DIV/0!              (7,100,000)       (1,278,000)          (12)       9
                  1,224,000            -       #DIV/0!              (6,800,000)       (1,224,000)          (12)      10
                  1,463,400        910,000     #DIV/0!             (11,890,000)       (1,463,400)          (11)      11
                  1,394,000            -       #DIV/0!              (9,900,000)       (1,394,000)          (12)      12
                  1,854,000            -       #DIV/0!             (10,300,000)       (1,854,000)          (12)      13
                    460,800      3,180,000     #DIV/0!              (3,220,000)         (460,800)             (6)    14
                    588,600      7,630,000     #DIV/0!              (3,270,000)         (588,600)             (4)    15
                  1,350,000            -       #DIV/0!             (12,500,000)       (1,350,000)          (12)      16
                  2,025,000            -       #DIV/0!             (11,250,000)       (2,025,000)          (12)      17
                  2,340,000            -       #DIV/0!             (13,000,000)       (2,340,000)          (12)      18
                  2,844,000            -       #DIV/0!             (15,800,000)       (2,844,000)          (12)      19
                  2,934,000            -       #DIV/0!             (16,300,000)       (2,934,000)          (12)      20
                  2,700,000            -       #DIV/0!             (15,000,000)       (2,700,000)          (12)      21
                  2,970,000            -       #DIV/0!             (16,500,000)       (2,970,000)          (12)      22
                  4,560,000            -       #DIV/0!             (22,800,000)       (4,560,000)          (12)      23
                  1,606,000      4,845,000     #DIV/0!             (16,255,000)       (1,606,000)             (9)    24
                  3,070,000      5,985,000     #DIV/0!             (17,515,000)       (3,070,000)             (9)    25
                  4,410,000      2,450,000     #DIV/0!             (22,050,000)       (4,410,000)          (11)      26
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    27
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    28
                  1,240,000      8,375,000     #DIV/0!              (6,625,000)       (1,240,000)             (5)    29
                  1,400,000      7,450,000     #DIV/0!              (7,550,000)       (1,400,000)             (6)    30
                  1,240,000      4,800,000     #DIV/0!              (6,200,000)       (1,240,000)             (7)    31
                  2,060,000      7,700,000     #DIV/0!             (10,300,000)       (2,060,000)             (7)    32
                        -              -       #DIV/0!                     -                 -       #DIV/0!         33
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          34
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          35
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          36
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          37
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          38
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   39
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   40
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   41
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   42
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   43
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   44
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   45
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   46
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   47
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   48
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   49
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   50

#REF!   #REF!   #REF!   #REF!   #REF!                TOTAL
                                                          UNIT PENGELOLA KEGIATAN
                                                    LAPORAN KOLEKTIBILITAS PINJAMAN SPP
                                             TANGGAL : 31      BULAN : AGUSTUS    TAHUN : 2009

                 : SUKASLAMET
Kecamatan        : KROYA
Kabupaten        : INDRAMAYU
                                    SALDO PINJAMAN         SISA PINJAMAN         SISA PINJAMAN               SISA PINJAMAN

                                      BULAN INI          YG ANGSURAN LANCAR     YG MENUNGGAK                YG MENUNGGAK
     KELOMPOK/DESA                (KOLOM 13 LAPORAN      (TANPA TUNGGAKAN)    1 S/D 2 KALI ANGSURAN       3 S/D 4 KALI ANGSURAN

                                PERKEMBANGAN PINJAMAN)   KOLEKTIBILITAS I     KOLEKTIBILITAS II           KOLEKTIBILITAS III

                 2                      3                        4                     5                           6
      Kelompok    Kel. Mawar                     -                      -                             -                           -
      Kelompok    Kel. Salak                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II             -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III            -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III      910,000                910,000                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II     3,180,000              3,180,000                             -                           -
      Kelompok    Kel.Mawar(Perg)        7,630,000              7,630,000                             -                           -
      Kelompok    AL-BAROKAH                     -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    AINUN NISA                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Lunas)              -                      -                             -                           -
      Kelompok    AL-HIKMAH              4,845,000              4,845,000                             -                           -
      Kelompok    AINUN NISA             5,985,000              5,985,000                             -                           -
      Kelompok    Kel. Sawo PPK II       2,450,000              2,450,000                             -                           -
      Kelompok    ASSYFA PNPM.MP         9,500,000              9,500,000                             -                           -
      Kelompok    NURUL IMAN PNPM.MP 9,500,000                  9,500,000                             -                           -
      Kelompok    ALBAROKAH PNPM.MP 8,375,000                   8,375,000                             -                           -
      Kelompok    ALIYAH PNPM.MP         7,450,000              7,450,000                             -                           -
      Kelompok    MANGGIS PNPM.MP        4,800,000              4,800,000                             -                           -
      Kelompok    SALAK (Perg)           7,700,000              7,700,000                             -                           -
      Kelompok               -                   -                      -                             -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -

        TOTAL                             #REF!                    #REF!                           -             -


                                   CADANGAN RESIKO          JUMLAH PINJAMAN       JUMLAH CADANGAN
     TINGKAT
                                        PINJAMAN                                      RESIKO           Diketahui dan disetujui Ole
  KOLEKTIBILITAS                            (1)                      (2)              "(3=1 X 2)
KOLEKTIBILITAS I                           1%              #REF!                       #REF!
KOLEKTIBILITAS II                         10%                                 -                    -
KOLEKTIBILITAS III                        25%                                 -                    -
KOLEKTIBILITAS IV                         50%                                 -                    -
KOLEKTIBILITAS V                         100%                                 -                    -
                                        TOTAL              #REF!                       #REF!               ( Rosdianah, Amd. )
                                     RASIO CADANGAN PINJAMAN (%)                                               Ketua UPK
                                                                                       #REF!
                                         (TOTAL (3) / TOTAL (2) )
MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
PP
HUN : 2009




                SISA PINJAMAN               SISA PINJAMAN YG

               YG MENUNGGAK              MENUNGGAK DIATAS 6 KALI

             5 S/D 6 KALI ANGSURAN             ANGSURAN

             KOLEKTIBILITAS IV             KOLEKTIBILITAS V

                      7                            8
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                                     -                             -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -

                               -                       -



Diketahui dan disetujui Oleh         Dibuat oleh




    ( Rosdianah, Amd. )            ( Inah Carsinah )
        Ketua UPK                  Bendahara UPK
                                                                                                                                      UN
      MENU UTAMA                                                                                                                 LAPORA
                                                                                                                        TANGGAL : 30

Desa            : SUKASLAMET
Kecamatan       : KROYA
Kabupaten       : INDRAMAYU

                                                      Realisasi Pinjaman                                      Target
No          Kelompok               Alokasi Pinjaman
                                                        (Tgl/Bln/Thn)
                                                                           Angsuran Pokok   Angsuran Bunga
                                                                                                             angs. ke


 1                2                       3                   4
1    Kelompok   Kel. Mawar          3300000           37972                  275,000.00       55,000.00
2    Kelompok   Kel. Salak          6000000           37972                  500,000.00      100,000.00
3    Kelompok   Kel. Sawo PPK II 5300000              38292                  441,666.67       88,333.33
4    Kelompok   Kel. Dahlia PPK II 4200000            38292                  350,000.00       70,000.00
5    Kelompok   Kel.Mawar(Perg) 5100000               38292                  425,000.00       85,000.00
6    Kelompok   Kel. Salak(Perg)    6400000           38292                  533,333.33      106,666.67
7    Kelompok   Kel. Pisang PPK III 9500000           38603                  791,666.67      158,333.33
8    Kelompok   Kel.Mawar(Perg) 8100000               38628                  675,000.00      135,000.00
9    Kelompok   Kel. Salak(Perg)    7100000           38628                  591,666.67      118,333.33
10   Kelompok   Kel. Sawo PPK II 6800000              38628                  566,666.67      113,333.33
11   Kelompok   Kel. Pisang PPK III 12800000          38916                1,066,666.67      213,333.33
12   Kelompok   Kel. Sawo PPK II 9900000              38628                  825,000.00      165,000.00
13   Kelompok   Kel. Salak(Perg)    10300000          38628                  858,333.33      171,666.67
14   Kelompok   Kel. Dahlia PPK II 6400000            39007                  533,333.33      106,666.67
15   Kelompok   Kel.Mawar(Perg) 10900000              39007                  908,333.33      181,666.67
16   Kelompok   AL-BAROKAH          12500000          39027                1,041,666.67      208,333.33
17   Kelompok   NURUL HIKMAH 11250000                 39027                  937,500.00      187,500.00
18   Kelompok   Kel. Sawo PPK II 13000000             39244                1,083,333.33      216,666.67
19   Kelompok   Kel. Salak(Perg)    15800000          39315                1,316,666.67      263,333.33
20   Kelompok   NURUL HIKMAH 16300000                 39337                1,358,333.33      271,666.67
21   Kelompok   AINUN NISA          15000000          39428                1,250,000.00      250,000.00
22   Kelompok   Kel. Sawo PPK II 16500000             39545                1,375,000.00      275,000.00
23   Kelompok   Kel. Salak(Lunas) 22800000            39647                1,900,000.00      380,000.00
24   Kelompok   AL-HIKMAH           21100000          39682                1,758,333.33      351,666.67
25   Kelompok   AINUN NISA          23500000          39797                1,958,333.33      391,666.67
26   Kelompok   Kel. Sawo PPK II 24500000             39889                2,041,666.67      408,333.33
27   Kelompok   ASSYFA PNPM.MP15000000                39969                1,250,000.00      250,000.00
28   Kelompok   NURUL IMAN PNPM.MP  15000000          39969                1,250,000.00      250,000.00
29   Kelompok   ALBAROKAH PNPM.MP   15000000          39969                1,250,000.00      250,000.00
30   Kelompok   ALIYAH PNPM.MP15000000                39969                1,250,000.00      250,000.00
31   Kelompok   MANGGIS PNPM.MP     11000000          39969                  916,666.67      183,333.33
32   Kelompok   SALAK (Perg)        18000000          39969                1,500,000.00      300,000.00
33   Kelompok   0                   0                 0                             -               -
34   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
35   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
36   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
37   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
38   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
 39   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 40   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 41   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 42   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 43   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 44   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 45   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 46   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 47   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 48   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 49   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 50   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!

       T o t a l                       #REF!           #REF!           #REF!   #REF!   ######

MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
              UNIT PENGELOLA KEGIATAN
         LAPORAN PERKEMBANGAN PINJAMAN SPP
TANGGAL : 30     BULAN : SEPTEMBER      TAHUN : 2009




 Target Pengembalian Kumulatif     Realisasi Pengembalian       Realisasi Pengembalian     Realisasi Pengembalian
          s/d Bulan ini                 s/d Bulan lalu                 Bulan ini                s/d Bulan ini

   Pokok               Bunga      Pokok             Bunga       Pokok            Bunga    Pokok

      5                  6          7                  8          9                10      11
           -               -      3,300,000           612,000                             3,300,000
           -               -      6,000,000         1,200,000                             6,000,000
           -               -      5,300,000         1,060,000                             5,300,000
           -               -      4,200,000           840,000                             4,200,000
           -               -      5,100,000         1,020,000                             5,100,000
           -               -      6,400,000         1,280,000                             6,400,000
           -               -      9,500,000         1,729,000                             9,500,000
           -               -      8,100,000         1,458,000                             8,100,000
           -               -      7,100,000         1,278,000                             7,100,000
           -               -      6,800,000         1,224,000                             6,800,000
           -               -     11,890,000         1,463,400                            11,890,000
           -               -      9,900,000         1,394,000                             9,900,000
           -               -     10,300,000         1,854,000                            10,300,000
           -               -      3,220,000           460,800                             3,220,000
           -               -      3,270,000           588,600                             3,270,000
           -               -     12,500,000         1,350,000                            12,500,000
           -               -     11,250,000         2,025,000                            11,250,000
           -               -     13,000,000         2,340,000                            13,000,000
           -               -     15,800,000         2,844,000                            15,800,000
           -               -     16,300,000         2,934,000                            16,300,000
           -               -     15,000,000         2,700,000                            15,000,000
           -               -     16,500,000         2,970,000                            16,500,000
           -               -     22,800,000         4,560,000                            22,800,000
           -               -     16,255,000         1,606,000                            16,255,000
           -               -     17,515,000         3,070,000                            17,515,000
           -               -     22,050,000         4,410,000                            22,050,000
           -               -      5,500,000           900,000                             5,500,000
           -               -      5,500,000           900,000                             5,500,000
           -               -      6,625,000         1,240,000                             6,625,000
           -               -      7,550,000         1,400,000                             7,550,000
           -               -      6,200,000         1,240,000                             6,200,000
           -               -     10,300,000         2,060,000                            10,300,000
           -               -            -                 -                                     -
   #REF!              #REF!       #REF!             #REF!                                 #REF!
   #REF!              #REF!       #REF!             #REF!                                 #REF!
   #REF!              #REF!       #REF!             #REF!                                 #REF!
   #REF!              #REF!       #REF!             #REF!                                 #REF!
   #REF!              #REF!       #REF!             #REF!                                 #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!

#REF!   #REF!   #REF!   #REF!   -   -   #REF!
                                                                                                                    Desa
                                                                                                                    Kecamatan
                                                                                                                    Kabupaten
Realisasi Pengembalian                           %
                                                             Tunggakan Pengembalian s/d bln ini
     s/d Bulan ini                                                                                   Rumus
                              Saldo Pinjaman
                                               Pengem                                                               NO.
                                                                                                    berapa bln
                  Bunga                         balian   Tungga       Pokok              Bunga      menunggak
                                                          kan
                   12            13=3-11       14=11/5   Pokok       15=5-11            16=6-12                       1
                    612,000            -       #DIV/0!              (3,300,000)         (612,000)          (12)       1
                  1,200,000            -       #DIV/0!              (6,000,000)       (1,200,000)          (12)       2
                  1,060,000            -       #DIV/0!              (5,300,000)       (1,060,000)          (12)       3
                    840,000            -       #DIV/0!              (4,200,000)         (840,000)      (12.000)       4
                  1,020,000            -       #DIV/0!              (5,100,000)       (1,020,000)          (12)       5
                  1,280,000            -       #DIV/0!              (6,400,000)       (1,280,000)          (12)       6
                  1,729,000            -       #DIV/0!              (9,500,000)       (1,729,000)          (12)       7
                  1,458,000            -       #DIV/0!              (8,100,000)       (1,458,000)          (12)       8
                  1,278,000            -       #DIV/0!              (7,100,000)       (1,278,000)          (12)       9
                  1,224,000            -       #DIV/0!              (6,800,000)       (1,224,000)          (12)      10
                  1,463,400        910,000     #DIV/0!             (11,890,000)       (1,463,400)          (11)      11
                  1,394,000            -       #DIV/0!              (9,900,000)       (1,394,000)          (12)      12
                  1,854,000            -       #DIV/0!             (10,300,000)       (1,854,000)          (12)      13
                    460,800      3,180,000     #DIV/0!              (3,220,000)         (460,800)             (6)    14
                    588,600      7,630,000     #DIV/0!              (3,270,000)         (588,600)             (4)    15
                  1,350,000            -       #DIV/0!             (12,500,000)       (1,350,000)          (12)      16
                  2,025,000            -       #DIV/0!             (11,250,000)       (2,025,000)          (12)      17
                  2,340,000            -       #DIV/0!             (13,000,000)       (2,340,000)          (12)      18
                  2,844,000            -       #DIV/0!             (15,800,000)       (2,844,000)          (12)      19
                  2,934,000            -       #DIV/0!             (16,300,000)       (2,934,000)          (12)      20
                  2,700,000            -       #DIV/0!             (15,000,000)       (2,700,000)          (12)      21
                  2,970,000            -       #DIV/0!             (16,500,000)       (2,970,000)          (12)      22
                  4,560,000            -       #DIV/0!             (22,800,000)       (4,560,000)          (12)      23
                  1,606,000      4,845,000     #DIV/0!             (16,255,000)       (1,606,000)             (9)    24
                  3,070,000      5,985,000     #DIV/0!             (17,515,000)       (3,070,000)             (9)    25
                  4,410,000      2,450,000     #DIV/0!             (22,050,000)       (4,410,000)          (11)      26
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    27
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    28
                  1,240,000      8,375,000     #DIV/0!              (6,625,000)       (1,240,000)             (5)    29
                  1,400,000      7,450,000     #DIV/0!              (7,550,000)       (1,400,000)             (6)    30
                  1,240,000      4,800,000     #DIV/0!              (6,200,000)       (1,240,000)             (7)    31
                  2,060,000      7,700,000     #DIV/0!             (10,300,000)       (2,060,000)             (7)    32
                        -              -       #DIV/0!                     -                 -       #DIV/0!         33
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          34
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          35
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          36
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          37
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          38
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   39
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   40
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   41
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   42
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   43
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   44
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   45
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   46
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   47
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   48
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   49
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   50

#REF!   #REF!   #REF!   #REF!   #REF!                TOTAL
                                                       UNIT PENGELOLA KEGIATAN
                                                  LAPORAN KOLEKTIBILITAS PINJAMAN SPP
                                          TANGGAL : 30    BULAN : SEPTEMBER       TAHUN : 2009

                 : SUKASLAMET
Kecamatan        : KROYA
Kabupaten        : INDRAMAYU
                                    SALDO PINJAMAN         SISA PINJAMAN         SISA PINJAMAN               SISA PINJAMAN

                                      BULAN INI          YG ANGSURAN LANCAR     YG MENUNGGAK                YG MENUNGGAK
     KELOMPOK/DESA                (KOLOM 13 LAPORAN      (TANPA TUNGGAKAN)    1 S/D 2 KALI ANGSURAN       3 S/D 4 KALI ANGSURAN

                                PERKEMBANGAN PINJAMAN)   KOLEKTIBILITAS I     KOLEKTIBILITAS II           KOLEKTIBILITAS III

                 2                      3                        4                     5                           6
      Kelompok    Kel. Mawar                     -                      -                             -                           -
      Kelompok    Kel. Salak                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II             -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III            -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III      910,000                910,000                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II     3,180,000              3,180,000                             -                           -
      Kelompok    Kel.Mawar(Perg)        7,630,000              7,630,000                             -                           -
      Kelompok    AL-BAROKAH                     -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    AINUN NISA                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Lunas)              -                      -                             -                           -
      Kelompok    AL-HIKMAH              4,845,000              4,845,000                             -                           -
      Kelompok    AINUN NISA             5,985,000              5,985,000                             -                           -
      Kelompok    Kel. Sawo PPK II       2,450,000              2,450,000                             -                           -
      Kelompok    ASSYFA PNPM.MP         9,500,000              9,500,000                             -                           -
      Kelompok    NURUL IMAN PNPM.MP 9,500,000                  9,500,000                             -                           -
      Kelompok    ALBAROKAH PNPM.MP 8,375,000                   8,375,000                             -                           -
      Kelompok    ALIYAH PNPM.MP         7,450,000              7,450,000                             -                           -
      Kelompok    MANGGIS PNPM.MP        4,800,000              4,800,000                             -                           -
      Kelompok    SALAK (Perg)           7,700,000              7,700,000                             -                           -
      Kelompok               -                   -                      -                             -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -

        TOTAL                             #REF!                    #REF!                           -             -


                                   CADANGAN RESIKO          JUMLAH PINJAMAN       JUMLAH CADANGAN
     TINGKAT
                                        PINJAMAN                                      RESIKO           Diketahui dan disetujui Ole
  KOLEKTIBILITAS                            (1)                      (2)              "(3=1 X 2)
KOLEKTIBILITAS I                           1%              #REF!                       #REF!
KOLEKTIBILITAS II                         10%                                 -                    -
KOLEKTIBILITAS III                        25%                                 -                    -
KOLEKTIBILITAS IV                         50%                                 -                    -
KOLEKTIBILITAS V                         100%                                 -                    -
                                        TOTAL              #REF!                       #REF!               ( Rosdianah, Amd. )
                                     RASIO CADANGAN PINJAMAN (%)                                               Ketua UPK
                                                                                       #REF!
                                         (TOTAL (3) / TOTAL (2) )
MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
PP
AHUN : 2009




                 SISA PINJAMAN               SISA PINJAMAN YG

                YG MENUNGGAK              MENUNGGAK DIATAS 6 KALI

              5 S/D 6 KALI ANGSURAN             ANGSURAN

              KOLEKTIBILITAS IV             KOLEKTIBILITAS V

                       7                            8
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -

                               -                       -



Diketahui dan disetujui Oleh         Dibuat oleh




    ( Rosdianah, Amd. )            ( Inah Carsinah )
        Ketua UPK                  Bendahara UPK
                                                                                                                                     UN
      MENU UTAMA                                                                                                                LAPORA
                                                                                                                        TANGGAL : 31

Desa            : SUKASLAMET
Kecamatan       : KROYA
Kabupaten       : INDRAMAYU

                                                      Realisasi Pinjaman                                      Target
No          Kelompok               Alokasi Pinjaman
                                                        (Tgl/Bln/Thn)
                                                                           Angsuran Pokok   Angsuran Bunga
                                                                                                             angs. ke


 1                2                       3                   4
1    Kelompok   Kel. Mawar          3300000           37972                  275,000.00       55,000.00
2    Kelompok   Kel. Salak          6000000           37972                  500,000.00      100,000.00
3    Kelompok   Kel. Sawo PPK II 5300000              38292                  441,666.67       88,333.33
4    Kelompok   Kel. Dahlia PPK II 4200000            38292                  350,000.00       70,000.00
5    Kelompok   Kel.Mawar(Perg) 5100000               38292                  425,000.00       85,000.00
6    Kelompok   Kel. Salak(Perg)    6400000           38292                  533,333.33      106,666.67
7    Kelompok   Kel. Pisang PPK III 9500000           38603                  791,666.67      158,333.33
8    Kelompok   Kel.Mawar(Perg) 8100000               38628                  675,000.00      135,000.00
9    Kelompok   Kel. Salak(Perg)    7100000           38628                  591,666.67      118,333.33
10   Kelompok   Kel. Sawo PPK II 6800000              38628                  566,666.67      113,333.33
11   Kelompok   Kel. Pisang PPK III 12800000          38916                1,066,666.67      213,333.33
12   Kelompok   Kel. Sawo PPK II 9900000              38628                  825,000.00      165,000.00
13   Kelompok   Kel. Salak(Perg)    10300000          38628                  858,333.33      171,666.67
14   Kelompok   Kel. Dahlia PPK II 6400000            39007                  533,333.33      106,666.67
15   Kelompok   Kel.Mawar(Perg) 10900000              39007                  908,333.33      181,666.67
16   Kelompok   AL-BAROKAH          12500000          39027                1,041,666.67      208,333.33
17   Kelompok   NURUL HIKMAH 11250000                 39027                  937,500.00      187,500.00
18   Kelompok   Kel. Sawo PPK II 13000000             39244                1,083,333.33      216,666.67
19   Kelompok   Kel. Salak(Perg)    15800000          39315                1,316,666.67      263,333.33
20   Kelompok   NURUL HIKMAH 16300000                 39337                1,358,333.33      271,666.67
21   Kelompok   AINUN NISA          15000000          39428                1,250,000.00      250,000.00
22   Kelompok   Kel. Sawo PPK II 16500000             39545                1,375,000.00      275,000.00
23   Kelompok   Kel. Salak(Lunas) 22800000            39647                1,900,000.00      380,000.00
24   Kelompok   AL-HIKMAH           21100000          39682                1,758,333.33      351,666.67
25   Kelompok   AINUN NISA          23500000          39797                1,958,333.33      391,666.67
26   Kelompok   Kel. Sawo PPK II 24500000             39889                2,041,666.67      408,333.33
27   Kelompok   ASSYFA PNPM.MP15000000                39969                1,250,000.00      250,000.00
28   Kelompok   NURUL IMAN PNPM.MP  15000000          39969                1,250,000.00      250,000.00
29   Kelompok   ALBAROKAH PNPM.MP   15000000          39969                1,250,000.00      250,000.00
30   Kelompok   ALIYAH PNPM.MP15000000                39969                1,250,000.00      250,000.00
31   Kelompok   MANGGIS PNPM.MP     11000000          39969                  916,666.67      183,333.33
32   Kelompok   SALAK (Perg)        18000000          39969                1,500,000.00      300,000.00
33   Kelompok   0                   0                 0                             -               -
34   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
35   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
36   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
37   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
38   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
 39   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 40   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 41   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 42   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 43   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 44   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 45   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 46   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 47   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 48   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 49   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 50   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!

       T o t a l                       #REF!           #REF!           #REF!   #REF!   ######

MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
             UNIT PENGELOLA KEGIATAN
        LAPORAN PERKEMBANGAN PINJAMAN SPP
TANGGAL : 31     BULAN : OKTOBER      TAHUN : 2009




Target Pengembalian Kumulatif     Realisasi Pengembalian       Realisasi Pengembalian     Realisasi Pengembalian
         s/d Bulan ini                 s/d Bulan lalu                 Bulan ini                s/d Bulan ini

  Pokok               Bunga      Pokok             Bunga       Pokok            Bunga    Pokok

     5                  6          7                  8          9                10      11
          -               -      3,300,000           612,000                             3,300,000
          -               -      6,000,000         1,200,000                             6,000,000
          -               -      5,300,000         1,060,000                             5,300,000
          -               -      4,200,000           840,000                             4,200,000
          -               -      5,100,000         1,020,000                             5,100,000
          -               -      6,400,000         1,280,000                             6,400,000
          -               -      9,500,000         1,729,000                             9,500,000
          -               -      8,100,000         1,458,000                             8,100,000
          -               -      7,100,000         1,278,000                             7,100,000
          -               -      6,800,000         1,224,000                             6,800,000
          -               -     11,890,000         1,463,400                            11,890,000
          -               -      9,900,000         1,394,000                             9,900,000
          -               -     10,300,000         1,854,000                            10,300,000
          -               -      3,220,000           460,800                             3,220,000
          -               -      3,270,000           588,600                             3,270,000
          -               -     12,500,000         1,350,000                            12,500,000
          -               -     11,250,000         2,025,000                            11,250,000
          -               -     13,000,000         2,340,000                            13,000,000
          -               -     15,800,000         2,844,000                            15,800,000
          -               -     16,300,000         2,934,000                            16,300,000
          -               -     15,000,000         2,700,000                            15,000,000
          -               -     16,500,000         2,970,000                            16,500,000
          -               -     22,800,000         4,560,000                            22,800,000
          -               -     16,255,000         1,606,000                            16,255,000
          -               -     17,515,000         3,070,000                            17,515,000
          -               -     22,050,000         4,410,000                            22,050,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      6,625,000         1,240,000                             6,625,000
          -               -      7,550,000         1,400,000                             7,550,000
          -               -      6,200,000         1,240,000                             6,200,000
          -               -     10,300,000         2,060,000                            10,300,000
          -               -            -                 -                                     -
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!

#REF!   #REF!   #REF!   #REF!   -   -   #REF!
                                                                                                                    Desa
                                                                                                                    Kecamatan
                                                                                                                    Kabupaten
Realisasi Pengembalian                           %
                                                             Tunggakan Pengembalian s/d bln ini
     s/d Bulan ini                                                                                   Rumus
                              Saldo Pinjaman
                                               Pengem                                                               NO.
                                                                                                    berapa bln
                  Bunga                         balian   Tungga       Pokok              Bunga      menunggak
                                                          kan
                   12            13=3-11       14=11/5   Pokok       15=5-11            16=6-12                       1
                    612,000            -       #DIV/0!              (3,300,000)         (612,000)          (12)       1
                  1,200,000            -       #DIV/0!              (6,000,000)       (1,200,000)          (12)       2
                  1,060,000            -       #DIV/0!              (5,300,000)       (1,060,000)          (12)       3
                    840,000            -       #DIV/0!              (4,200,000)         (840,000)      (12.000)       4
                  1,020,000            -       #DIV/0!              (5,100,000)       (1,020,000)          (12)       5
                  1,280,000            -       #DIV/0!              (6,400,000)       (1,280,000)          (12)       6
                  1,729,000            -       #DIV/0!              (9,500,000)       (1,729,000)          (12)       7
                  1,458,000            -       #DIV/0!              (8,100,000)       (1,458,000)          (12)       8
                  1,278,000            -       #DIV/0!              (7,100,000)       (1,278,000)          (12)       9
                  1,224,000            -       #DIV/0!              (6,800,000)       (1,224,000)          (12)      10
                  1,463,400        910,000     #DIV/0!             (11,890,000)       (1,463,400)          (11)      11
                  1,394,000            -       #DIV/0!              (9,900,000)       (1,394,000)          (12)      12
                  1,854,000            -       #DIV/0!             (10,300,000)       (1,854,000)          (12)      13
                    460,800      3,180,000     #DIV/0!              (3,220,000)         (460,800)             (6)    14
                    588,600      7,630,000     #DIV/0!              (3,270,000)         (588,600)             (4)    15
                  1,350,000            -       #DIV/0!             (12,500,000)       (1,350,000)          (12)      16
                  2,025,000            -       #DIV/0!             (11,250,000)       (2,025,000)          (12)      17
                  2,340,000            -       #DIV/0!             (13,000,000)       (2,340,000)          (12)      18
                  2,844,000            -       #DIV/0!             (15,800,000)       (2,844,000)          (12)      19
                  2,934,000            -       #DIV/0!             (16,300,000)       (2,934,000)          (12)      20
                  2,700,000            -       #DIV/0!             (15,000,000)       (2,700,000)          (12)      21
                  2,970,000            -       #DIV/0!             (16,500,000)       (2,970,000)          (12)      22
                  4,560,000            -       #DIV/0!             (22,800,000)       (4,560,000)          (12)      23
                  1,606,000      4,845,000     #DIV/0!             (16,255,000)       (1,606,000)             (9)    24
                  3,070,000      5,985,000     #DIV/0!             (17,515,000)       (3,070,000)             (9)    25
                  4,410,000      2,450,000     #DIV/0!             (22,050,000)       (4,410,000)          (11)      26
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    27
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    28
                  1,240,000      8,375,000     #DIV/0!              (6,625,000)       (1,240,000)             (5)    29
                  1,400,000      7,450,000     #DIV/0!              (7,550,000)       (1,400,000)             (6)    30
                  1,240,000      4,800,000     #DIV/0!              (6,200,000)       (1,240,000)             (7)    31
                  2,060,000      7,700,000     #DIV/0!             (10,300,000)       (2,060,000)             (7)    32
                        -              -       #DIV/0!                     -                 -       #DIV/0!         33
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          34
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          35
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          36
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          37
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          38
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   39
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   40
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   41
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   42
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   43
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   44
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   45
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   46
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   47
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   48
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   49
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   50

#REF!   #REF!   #REF!   #REF!   #REF!                TOTAL
                                                         UNIT PENGELOLA KEGIATAN
                                                   LAPORAN KOLEKTIBILITAS PINJAMAN SPP
                                            TANGGAL : 31     BULAN : OKTOBER      TAHUN : 2009

                 : SUKASLAMET
Kecamatan        : KROYA
Kabupaten        : INDRAMAYU
                                    SALDO PINJAMAN         SISA PINJAMAN         SISA PINJAMAN               SISA PINJAMAN

                                      BULAN INI          YG ANGSURAN LANCAR     YG MENUNGGAK                YG MENUNGGAK
     KELOMPOK/DESA                (KOLOM 13 LAPORAN      (TANPA TUNGGAKAN)    1 S/D 2 KALI ANGSURAN       3 S/D 4 KALI ANGSURAN

                                PERKEMBANGAN PINJAMAN)   KOLEKTIBILITAS I     KOLEKTIBILITAS II           KOLEKTIBILITAS III

                 2                      3                        4                     5                           6
      Kelompok    Kel. Mawar                     -                      -                             -                           -
      Kelompok    Kel. Salak                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II             -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III            -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III      910,000                910,000                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II     3,180,000              3,180,000                             -                           -
      Kelompok    Kel.Mawar(Perg)        7,630,000              7,630,000                             -                           -
      Kelompok    AL-BAROKAH                     -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    AINUN NISA                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Lunas)              -                      -                             -                           -
      Kelompok    AL-HIKMAH              4,845,000              4,845,000                             -                           -
      Kelompok    AINUN NISA             5,985,000              5,985,000                             -                           -
      Kelompok    Kel. Sawo PPK II       2,450,000              2,450,000                             -                           -
      Kelompok    ASSYFA PNPM.MP         9,500,000              9,500,000                             -                           -
      Kelompok    NURUL IMAN PNPM.MP 9,500,000                  9,500,000                             -                           -
      Kelompok    ALBAROKAH PNPM.MP 8,375,000                   8,375,000                             -                           -
      Kelompok    ALIYAH PNPM.MP         7,450,000              7,450,000                             -                           -
      Kelompok    MANGGIS PNPM.MP        4,800,000              4,800,000                             -                           -
      Kelompok    SALAK (Perg)           7,700,000              7,700,000                             -                           -
      Kelompok               -                   -                      -                             -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -

        TOTAL                             #REF!                    #REF!                           -             -


                                   CADANGAN RESIKO          JUMLAH PINJAMAN       JUMLAH CADANGAN
     TINGKAT
                                        PINJAMAN                                      RESIKO           Diketahui dan disetujui Ole
  KOLEKTIBILITAS                            (1)                      (2)              "(3=1 X 2)
KOLEKTIBILITAS I                           1%              #REF!                       #REF!
KOLEKTIBILITAS II                         10%                                 -                    -
KOLEKTIBILITAS III                        25%                                 -                    -
KOLEKTIBILITAS IV                         50%                                 -                    -
KOLEKTIBILITAS V                         100%                                 -                    -
                                        TOTAL              #REF!                       #REF!               ( Rosdianah, Amd. )
                                     RASIO CADANGAN PINJAMAN (%)                                               Ketua UPK
                                                                                       #REF!
                                         (TOTAL (3) / TOTAL (2) )
MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
 PP
AHUN : 2009




                 SISA PINJAMAN               SISA PINJAMAN YG

                YG MENUNGGAK              MENUNGGAK DIATAS 6 KALI

              5 S/D 6 KALI ANGSURAN             ANGSURAN

              KOLEKTIBILITAS IV             KOLEKTIBILITAS V

                       7                            8
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -

                               -                       -



Diketahui dan disetujui Oleh         Dibuat oleh




    ( Rosdianah, Amd. )            ( Inah Carsinah )
        Ketua UPK                  Bendahara UPK
                                                                                                                                      UN
      MENU UTAMA                                                                                                                 LAPORA
                                                                                                                        TANGGAL : 30

Desa            : SUKASLAMET
Kecamatan       : KROYA
Kabupaten       : INDRAMAYU

                                                      Realisasi Pinjaman                                      Target
No          Kelompok               Alokasi Pinjaman
                                                        (Tgl/Bln/Thn)
                                                                           Angsuran Pokok   Angsuran Bunga
                                                                                                             angs. ke


 1                2                       3                   4
1    Kelompok   Kel. Mawar          3300000           37972                  275,000.00       55,000.00
2    Kelompok   Kel. Salak          6000000           37972                  500,000.00      100,000.00
3    Kelompok   Kel. Sawo PPK II 5300000              38292                  441,666.67       88,333.33
4    Kelompok   Kel. Dahlia PPK II 4200000            38292                  350,000.00       70,000.00
5    Kelompok   Kel.Mawar(Perg) 5100000               38292                  425,000.00       85,000.00
6    Kelompok   Kel. Salak(Perg)    6400000           38292                  533,333.33      106,666.67
7    Kelompok   Kel. Pisang PPK III 9500000           38603                  791,666.67      158,333.33
8    Kelompok   Kel.Mawar(Perg) 8100000               38628                  675,000.00      135,000.00
9    Kelompok   Kel. Salak(Perg)    7100000           38628                  591,666.67      118,333.33
10   Kelompok   Kel. Sawo PPK II 6800000              38628                  566,666.67      113,333.33
11   Kelompok   Kel. Pisang PPK III 12800000          38916                1,066,666.67      213,333.33
12   Kelompok   Kel. Sawo PPK II 9900000              38628                  825,000.00      165,000.00
13   Kelompok   Kel. Salak(Perg)    10300000          38628                  858,333.33      171,666.67
14   Kelompok   Kel. Dahlia PPK II 6400000            39007                  533,333.33      106,666.67
15   Kelompok   Kel.Mawar(Perg) 10900000              39007                  908,333.33      181,666.67
16   Kelompok   AL-BAROKAH          12500000          39027                1,041,666.67      208,333.33
17   Kelompok   NURUL HIKMAH 11250000                 39027                  937,500.00      187,500.00
18   Kelompok   Kel. Sawo PPK II 13000000             39244                1,083,333.33      216,666.67
19   Kelompok   Kel. Salak(Perg)    15800000          39315                1,316,666.67      263,333.33
20   Kelompok   NURUL HIKMAH 16300000                 39337                1,358,333.33      271,666.67
21   Kelompok   AINUN NISA          15000000          39428                1,250,000.00      250,000.00
22   Kelompok   Kel. Sawo PPK II 16500000             39545                1,375,000.00      275,000.00
23   Kelompok   Kel. Salak(Lunas) 22800000            39647                1,900,000.00      380,000.00
24   Kelompok   AL-HIKMAH           21100000          39682                1,758,333.33      351,666.67
25   Kelompok   AINUN NISA          23500000          39797                1,958,333.33      391,666.67
26   Kelompok   Kel. Sawo PPK II 24500000             39889                2,041,666.67      408,333.33
27   Kelompok   ASSYFA PNPM.MP15000000                39969                1,250,000.00      250,000.00
28   Kelompok   NURUL IMAN PNPM.MP  15000000          39969                1,250,000.00      250,000.00
29   Kelompok   ALBAROKAH PNPM.MP   15000000          39969                1,250,000.00      250,000.00
30   Kelompok   ALIYAH PNPM.MP15000000                39969                1,250,000.00      250,000.00
31   Kelompok   MANGGIS PNPM.MP     11000000          39969                  916,666.67      183,333.33
32   Kelompok   SALAK (Perg)        18000000          39969                1,500,000.00      300,000.00
33   Kelompok   0                   0                 0                             -               -
34   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
35   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
36   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
37   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
38   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
 39   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 40   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 41   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 42   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 43   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 44   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 45   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 46   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 47   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 48   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 49   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 50   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!

       T o t a l                       #REF!           #REF!           #REF!   #REF!   ######

MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
              UNIT PENGELOLA KEGIATAN
         LAPORAN PERKEMBANGAN PINJAMAN SPP
TANGGAL : 30      BULAN : NOPEMBER     TAHUN : 2009




Target Pengembalian Kumulatif     Realisasi Pengembalian       Realisasi Pengembalian     Realisasi Pengembalian
         s/d Bulan ini                 s/d Bulan lalu                 Bulan ini                s/d Bulan ini

  Pokok               Bunga      Pokok             Bunga       Pokok            Bunga    Pokok

     5                  6          7                  8          9                10      11
          -               -      3,300,000           612,000                             3,300,000
          -               -      6,000,000         1,200,000                             6,000,000
          -               -      5,300,000         1,060,000                             5,300,000
          -               -      4,200,000           840,000                             4,200,000
          -               -      5,100,000         1,020,000                             5,100,000
          -               -      6,400,000         1,280,000                             6,400,000
          -               -      9,500,000         1,729,000                             9,500,000
          -               -      8,100,000         1,458,000                             8,100,000
          -               -      7,100,000         1,278,000                             7,100,000
          -               -      6,800,000         1,224,000                             6,800,000
          -               -     11,890,000         1,463,400                            11,890,000
          -               -      9,900,000         1,394,000                             9,900,000
          -               -     10,300,000         1,854,000                            10,300,000
          -               -      3,220,000           460,800                             3,220,000
          -               -      3,270,000           588,600                             3,270,000
          -               -     12,500,000         1,350,000                            12,500,000
          -               -     11,250,000         2,025,000                            11,250,000
          -               -     13,000,000         2,340,000                            13,000,000
          -               -     15,800,000         2,844,000                            15,800,000
          -               -     16,300,000         2,934,000                            16,300,000
          -               -     15,000,000         2,700,000                            15,000,000
          -               -     16,500,000         2,970,000                            16,500,000
          -               -     22,800,000         4,560,000                            22,800,000
          -               -     16,255,000         1,606,000                            16,255,000
          -               -     17,515,000         3,070,000                            17,515,000
          -               -     22,050,000         4,410,000                            22,050,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      6,625,000         1,240,000                             6,625,000
          -               -      7,550,000         1,400,000                             7,550,000
          -               -      6,200,000         1,240,000                             6,200,000
          -               -     10,300,000         2,060,000                            10,300,000
          -               -            -                 -                                     -
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!

#REF!   #REF!   #REF!   #REF!   -   -   #REF!
                                                                                                                    Desa
                                                                                                                    Kecamatan
                                                                                                                    Kabupaten
Realisasi Pengembalian                           %
                                                             Tunggakan Pengembalian s/d bln ini
     s/d Bulan ini                                                                                   Rumus
                              Saldo Pinjaman
                                               Pengem                                                               NO.
                                                                                                    berapa bln
                  Bunga                         balian   Tungga       Pokok              Bunga      menunggak
                                                          kan
                   12            13=3-11       14=11/5   Pokok       15=5-11            16=6-12                       1
                    612,000            -       #DIV/0!              (3,300,000)         (612,000)          (12)       1
                  1,200,000            -       #DIV/0!              (6,000,000)       (1,200,000)          (12)       2
                  1,060,000            -       #DIV/0!              (5,300,000)       (1,060,000)          (12)       3
                    840,000            -       #DIV/0!              (4,200,000)         (840,000)      (12.000)       4
                  1,020,000            -       #DIV/0!              (5,100,000)       (1,020,000)          (12)       5
                  1,280,000            -       #DIV/0!              (6,400,000)       (1,280,000)          (12)       6
                  1,729,000            -       #DIV/0!              (9,500,000)       (1,729,000)          (12)       7
                  1,458,000            -       #DIV/0!              (8,100,000)       (1,458,000)          (12)       8
                  1,278,000            -       #DIV/0!              (7,100,000)       (1,278,000)          (12)       9
                  1,224,000            -       #DIV/0!              (6,800,000)       (1,224,000)          (12)      10
                  1,463,400        910,000     #DIV/0!             (11,890,000)       (1,463,400)          (11)      11
                  1,394,000            -       #DIV/0!              (9,900,000)       (1,394,000)          (12)      12
                  1,854,000            -       #DIV/0!             (10,300,000)       (1,854,000)          (12)      13
                    460,800      3,180,000     #DIV/0!              (3,220,000)         (460,800)             (6)    14
                    588,600      7,630,000     #DIV/0!              (3,270,000)         (588,600)             (4)    15
                  1,350,000            -       #DIV/0!             (12,500,000)       (1,350,000)          (12)      16
                  2,025,000            -       #DIV/0!             (11,250,000)       (2,025,000)          (12)      17
                  2,340,000            -       #DIV/0!             (13,000,000)       (2,340,000)          (12)      18
                  2,844,000            -       #DIV/0!             (15,800,000)       (2,844,000)          (12)      19
                  2,934,000            -       #DIV/0!             (16,300,000)       (2,934,000)          (12)      20
                  2,700,000            -       #DIV/0!             (15,000,000)       (2,700,000)          (12)      21
                  2,970,000            -       #DIV/0!             (16,500,000)       (2,970,000)          (12)      22
                  4,560,000            -       #DIV/0!             (22,800,000)       (4,560,000)          (12)      23
                  1,606,000      4,845,000     #DIV/0!             (16,255,000)       (1,606,000)             (9)    24
                  3,070,000      5,985,000     #DIV/0!             (17,515,000)       (3,070,000)             (9)    25
                  4,410,000      2,450,000     #DIV/0!             (22,050,000)       (4,410,000)          (11)      26
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    27
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    28
                  1,240,000      8,375,000     #DIV/0!              (6,625,000)       (1,240,000)             (5)    29
                  1,400,000      7,450,000     #DIV/0!              (7,550,000)       (1,400,000)             (6)    30
                  1,240,000      4,800,000     #DIV/0!              (6,200,000)       (1,240,000)             (7)    31
                  2,060,000      7,700,000     #DIV/0!             (10,300,000)       (2,060,000)             (7)    32
                        -              -       #DIV/0!                     -                 -       #DIV/0!         33
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          34
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          35
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          36
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          37
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          38
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   39
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   40
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   41
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   42
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   43
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   44
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   45
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   46
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   47
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   48
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   49
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   50

#REF!   #REF!   #REF!   #REF!   #REF!                TOTAL
                                                        UNIT PENGELOLA KEGIATAN
                                                   LAPORAN KOLEKTIBILITAS PINJAMAN SPP
                                           TANGGAL : 30     BULAN : NOPEMBER       TAHUN : 2009

                 : SUKASLAMET
Kecamatan        : KROYA
Kabupaten        : INDRAMAYU
                                    SALDO PINJAMAN         SISA PINJAMAN         SISA PINJAMAN               SISA PINJAMAN

                                      BULAN INI          YG ANGSURAN LANCAR     YG MENUNGGAK                YG MENUNGGAK
     KELOMPOK/DESA                (KOLOM 13 LAPORAN      (TANPA TUNGGAKAN)    1 S/D 2 KALI ANGSURAN       3 S/D 4 KALI ANGSURAN

                                PERKEMBANGAN PINJAMAN)   KOLEKTIBILITAS I     KOLEKTIBILITAS II           KOLEKTIBILITAS III

                 2                      3                        4                     5                           6
      Kelompok    Kel. Mawar                     -                      -                             -                           -
      Kelompok    Kel. Salak                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II             -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III            -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III      910,000                910,000                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II     3,180,000              3,180,000                             -                           -
      Kelompok    Kel.Mawar(Perg)        7,630,000              7,630,000                             -                           -
      Kelompok    AL-BAROKAH                     -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    AINUN NISA                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Lunas)              -                      -                             -                           -
      Kelompok    AL-HIKMAH              4,845,000              4,845,000                             -                           -
      Kelompok    AINUN NISA             5,985,000              5,985,000                             -                           -
      Kelompok    Kel. Sawo PPK II       2,450,000              2,450,000                             -                           -
      Kelompok    ASSYFA PNPM.MP         9,500,000              9,500,000                             -                           -
      Kelompok    NURUL IMAN PNPM.MP 9,500,000                  9,500,000                             -                           -
      Kelompok    ALBAROKAH PNPM.MP 8,375,000                   8,375,000                             -                           -
      Kelompok    ALIYAH PNPM.MP         7,450,000              7,450,000                             -                           -
      Kelompok    MANGGIS PNPM.MP        4,800,000              4,800,000                             -                           -
      Kelompok    SALAK (Perg)           7,700,000              7,700,000                             -                           -
      Kelompok               -                   -                      -                             -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -

        TOTAL                             #REF!                    #REF!                           -             -


                                   CADANGAN RESIKO          JUMLAH PINJAMAN       JUMLAH CADANGAN
     TINGKAT
                                        PINJAMAN                                      RESIKO           Diketahui dan disetujui Ole
  KOLEKTIBILITAS                            (1)                      (2)              "(3=1 X 2)
KOLEKTIBILITAS I                           1%              #REF!                       #REF!
KOLEKTIBILITAS II                         10%                                 -                    -
KOLEKTIBILITAS III                        25%                                 -                    -
KOLEKTIBILITAS IV                         50%                                 -                    -
KOLEKTIBILITAS V                         100%                                 -                    -
                                        TOTAL              #REF!                       #REF!               ( Rosdianah, Amd. )
                                     RASIO CADANGAN PINJAMAN (%)                                               Ketua UPK
                                                                                       #REF!
                                         (TOTAL (3) / TOTAL (2) )
MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
PP
AHUN : 2009




                 SISA PINJAMAN               SISA PINJAMAN YG

                YG MENUNGGAK              MENUNGGAK DIATAS 6 KALI

              5 S/D 6 KALI ANGSURAN             ANGSURAN

              KOLEKTIBILITAS IV             KOLEKTIBILITAS V

                       7                            8
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -

                               -                       -



Diketahui dan disetujui Oleh         Dibuat oleh




    ( Rosdianah, Amd. )            ( Inah Carsinah )
        Ketua UPK                  Bendahara UPK
                                                                                                                                     UN
      MENU UTAMA                                                                                                                LAPORA
                                                                                                                        TANGGAL : 31

Desa            : SUKASLAMET
Kecamatan       : KROYA
Kabupaten       : INDRAMAYU

                                                      Realisasi Pinjaman                                      Target
No          Kelompok               Alokasi Pinjaman
                                                        (Tgl/Bln/Thn)
                                                                           Angsuran Pokok   Angsuran Bunga
                                                                                                             angs. ke


 1                2                       3                   4
1    Kelompok   Kel. Mawar          3300000           37972                  275,000.00       55,000.00
2    Kelompok   Kel. Salak          6000000           37972                  500,000.00      100,000.00
3    Kelompok   Kel. Sawo PPK II 5300000              38292                  441,666.67       88,333.33
4    Kelompok   Kel. Dahlia PPK II 4200000            38292                  350,000.00       70,000.00
5    Kelompok   Kel.Mawar(Perg) 5100000               38292                  425,000.00       85,000.00
6    Kelompok   Kel. Salak(Perg)    6400000           38292                  533,333.33      106,666.67
7    Kelompok   Kel. Pisang PPK III 9500000           38603                  791,666.67      158,333.33
8    Kelompok   Kel.Mawar(Perg) 8100000               38628                  675,000.00      135,000.00
9    Kelompok   Kel. Salak(Perg)    7100000           38628                  591,666.67      118,333.33
10   Kelompok   Kel. Sawo PPK II 6800000              38628                  566,666.67      113,333.33
11   Kelompok   Kel. Pisang PPK III 12800000          38916                1,066,666.67      213,333.33
12   Kelompok   Kel. Sawo PPK II 9900000              38628                  825,000.00      165,000.00
13   Kelompok   Kel. Salak(Perg)    10300000          38628                  858,333.33      171,666.67
14   Kelompok   Kel. Dahlia PPK II 6400000            39007                  533,333.33      106,666.67
15   Kelompok   Kel.Mawar(Perg) 10900000              39007                  908,333.33      181,666.67
16   Kelompok   AL-BAROKAH          12500000          39027                1,041,666.67      208,333.33
17   Kelompok   NURUL HIKMAH 11250000                 39027                  937,500.00      187,500.00
18   Kelompok   Kel. Sawo PPK II 13000000             39244                1,083,333.33      216,666.67
19   Kelompok   Kel. Salak(Perg)    15800000          39315                1,316,666.67      263,333.33
20   Kelompok   NURUL HIKMAH 16300000                 39337                1,358,333.33      271,666.67
21   Kelompok   AINUN NISA          15000000          39428                1,250,000.00      250,000.00
22   Kelompok   Kel. Sawo PPK II 16500000             39545                1,375,000.00      275,000.00
23   Kelompok   Kel. Salak(Lunas) 22800000            39647                1,900,000.00      380,000.00
24   Kelompok   AL-HIKMAH           21100000          39682                1,758,333.33      351,666.67
25   Kelompok   AINUN NISA          23500000          39797                1,958,333.33      391,666.67
26   Kelompok   Kel. Sawo PPK II 24500000             39889                2,041,666.67      408,333.33
27   Kelompok   ASSYFA PNPM.MP15000000                39969                1,250,000.00      250,000.00
28   Kelompok   NURUL IMAN PNPM.MP  15000000          39969                1,250,000.00      250,000.00
29   Kelompok   ALBAROKAH PNPM.MP   15000000          39969                1,250,000.00      250,000.00
30   Kelompok   ALIYAH PNPM.MP15000000                39969                1,250,000.00      250,000.00
31   Kelompok   MANGGIS PNPM.MP     11000000          39969                  916,666.67      183,333.33
32   Kelompok   SALAK (Perg)        18000000          39969                1,500,000.00      300,000.00
33   Kelompok   0                   0                 0                             -               -
34   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
35   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
36   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
37   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
38   Kelompok   #REF!               #REF!             #REF!                   #REF!           #REF!
 39   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 40   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 41   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 42   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 43   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 44   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 45   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 46   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 47   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 48   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 49   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!
 50   Kelompok   #REF!             #REF!          #REF!                #REF!   #REF!

       T o t a l                       #REF!           #REF!           #REF!   #REF!   ######

MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
             UNIT PENGELOLA KEGIATAN
        LAPORAN PERKEMBANGAN PINJAMAN SPP
TANGGAL : 31     BULAN : DESEMBER     TAHUN : 2009




Target Pengembalian Kumulatif     Realisasi Pengembalian       Realisasi Pengembalian     Realisasi Pengembalian
         s/d Bulan ini                 s/d Bulan lalu                 Bulan ini                s/d Bulan ini

  Pokok               Bunga      Pokok             Bunga       Pokok            Bunga    Pokok

     5                  6          7                  8          9                10      11
          -               -      3,300,000           612,000                             3,300,000
          -               -      6,000,000         1,200,000                             6,000,000
          -               -      5,300,000         1,060,000                             5,300,000
          -               -      4,200,000           840,000                             4,200,000
          -               -      5,100,000         1,020,000                             5,100,000
          -               -      6,400,000         1,280,000                             6,400,000
          -               -      9,500,000         1,729,000                             9,500,000
          -               -      8,100,000         1,458,000                             8,100,000
          -               -      7,100,000         1,278,000                             7,100,000
          -               -      6,800,000         1,224,000                             6,800,000
          -               -     11,890,000         1,463,400                            11,890,000
          -               -      9,900,000         1,394,000                             9,900,000
          -               -     10,300,000         1,854,000                            10,300,000
          -               -      3,220,000           460,800                             3,220,000
          -               -      3,270,000           588,600                             3,270,000
          -               -     12,500,000         1,350,000                            12,500,000
          -               -     11,250,000         2,025,000                            11,250,000
          -               -     13,000,000         2,340,000                            13,000,000
          -               -     15,800,000         2,844,000                            15,800,000
          -               -     16,300,000         2,934,000                            16,300,000
          -               -     15,000,000         2,700,000                            15,000,000
          -               -     16,500,000         2,970,000                            16,500,000
          -               -     22,800,000         4,560,000                            22,800,000
          -               -     16,255,000         1,606,000                            16,255,000
          -               -     17,515,000         3,070,000                            17,515,000
          -               -     22,050,000         4,410,000                            22,050,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      5,500,000           900,000                             5,500,000
          -               -      6,625,000         1,240,000                             6,625,000
          -               -      7,550,000         1,400,000                             7,550,000
          -               -      6,200,000         1,240,000                             6,200,000
          -               -     10,300,000         2,060,000                            10,300,000
          -               -            -                 -                                     -
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
  #REF!              #REF!       #REF!             #REF!                                 #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!
#REF!   #REF!   #REF!   #REF!           #REF!

#REF!   #REF!   #REF!   #REF!   -   -   #REF!
                                                                                                                    Desa
                                                                                                                    Kecamatan
                                                                                                                    Kabupaten
Realisasi Pengembalian                           %
                                                             Tunggakan Pengembalian s/d bln ini
     s/d Bulan ini                                                                                   Rumus
                              Saldo Pinjaman
                                               Pengem                                                               NO.
                                                                                                    berapa bln
                  Bunga                         balian   Tungga       Pokok              Bunga      menunggak
                                                          kan
                   12            13=3-11       14=11/5   Pokok       15=5-11            16=6-12                       1
                    612,000            -       #DIV/0!              (3,300,000)         (612,000)          (12)       1
                  1,200,000            -       #DIV/0!              (6,000,000)       (1,200,000)          (12)       2
                  1,060,000            -       #DIV/0!              (5,300,000)       (1,060,000)          (12)       3
                    840,000            -       #DIV/0!              (4,200,000)         (840,000)      (12.000)       4
                  1,020,000            -       #DIV/0!              (5,100,000)       (1,020,000)          (12)       5
                  1,280,000            -       #DIV/0!              (6,400,000)       (1,280,000)          (12)       6
                  1,729,000            -       #DIV/0!              (9,500,000)       (1,729,000)          (12)       7
                  1,458,000            -       #DIV/0!              (8,100,000)       (1,458,000)          (12)       8
                  1,278,000            -       #DIV/0!              (7,100,000)       (1,278,000)          (12)       9
                  1,224,000            -       #DIV/0!              (6,800,000)       (1,224,000)          (12)      10
                  1,463,400        910,000     #DIV/0!             (11,890,000)       (1,463,400)          (11)      11
                  1,394,000            -       #DIV/0!              (9,900,000)       (1,394,000)          (12)      12
                  1,854,000            -       #DIV/0!             (10,300,000)       (1,854,000)          (12)      13
                    460,800      3,180,000     #DIV/0!              (3,220,000)         (460,800)             (6)    14
                    588,600      7,630,000     #DIV/0!              (3,270,000)         (588,600)             (4)    15
                  1,350,000            -       #DIV/0!             (12,500,000)       (1,350,000)          (12)      16
                  2,025,000            -       #DIV/0!             (11,250,000)       (2,025,000)          (12)      17
                  2,340,000            -       #DIV/0!             (13,000,000)       (2,340,000)          (12)      18
                  2,844,000            -       #DIV/0!             (15,800,000)       (2,844,000)          (12)      19
                  2,934,000            -       #DIV/0!             (16,300,000)       (2,934,000)          (12)      20
                  2,700,000            -       #DIV/0!             (15,000,000)       (2,700,000)          (12)      21
                  2,970,000            -       #DIV/0!             (16,500,000)       (2,970,000)          (12)      22
                  4,560,000            -       #DIV/0!             (22,800,000)       (4,560,000)          (12)      23
                  1,606,000      4,845,000     #DIV/0!             (16,255,000)       (1,606,000)             (9)    24
                  3,070,000      5,985,000     #DIV/0!             (17,515,000)       (3,070,000)             (9)    25
                  4,410,000      2,450,000     #DIV/0!             (22,050,000)       (4,410,000)          (11)      26
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    27
                    900,000      9,500,000     #DIV/0!              (5,500,000)         (900,000)             (4)    28
                  1,240,000      8,375,000     #DIV/0!              (6,625,000)       (1,240,000)             (5)    29
                  1,400,000      7,450,000     #DIV/0!              (7,550,000)       (1,400,000)             (6)    30
                  1,240,000      4,800,000     #DIV/0!              (6,200,000)       (1,240,000)             (7)    31
                  2,060,000      7,700,000     #DIV/0!             (10,300,000)       (2,060,000)             (7)    32
                        -              -       #DIV/0!                     -                 -       #DIV/0!         33
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          34
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          35
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          36
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          37
                 #REF!           #REF!          #REF!                #REF!              #REF!         #REF!          38
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   39
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   40
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   41
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   42
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   43
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   44
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   45
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   46
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   47
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   48
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   49
#REF!   #REF!   #REF!   #REF!   #REF!   #REF!   50

#REF!   #REF!   #REF!   #REF!   #REF!                TOTAL
                                                        UNIT PENGELOLA KEGIATAN
                                                   LAPORAN KOLEKTIBILITAS PINJAMAN SPP
                                           TANGGAL : 31     BULAN : DESEMBER      TAHUN : 2009

                 : SUKASLAMET
Kecamatan        : KROYA
Kabupaten        : INDRAMAYU
                                    SALDO PINJAMAN         SISA PINJAMAN         SISA PINJAMAN               SISA PINJAMAN

                                      BULAN INI          YG ANGSURAN LANCAR     YG MENUNGGAK                YG MENUNGGAK
     KELOMPOK/DESA                (KOLOM 13 LAPORAN      (TANPA TUNGGAKAN)    1 S/D 2 KALI ANGSURAN       3 S/D 4 KALI ANGSURAN

                                PERKEMBANGAN PINJAMAN)   KOLEKTIBILITAS I     KOLEKTIBILITAS II           KOLEKTIBILITAS III

                 2                      3                        4                     5                           6
      Kelompok    Kel. Mawar                     -                      -                             -                           -
      Kelompok    Kel. Salak                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II             -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III            -                      -                             -                           -
      Kelompok    Kel.Mawar(Perg)                -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Pisang PPK III      910,000                910,000                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    Kel. Dahlia PPK II     3,180,000              3,180,000                             -                           -
      Kelompok    Kel.Mawar(Perg)        7,630,000              7,630,000                             -                           -
      Kelompok    AL-BAROKAH                     -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Perg)               -                      -                             -                           -
      Kelompok    NURUL HIKMAH                   -                      -                             -                           -
      Kelompok    AINUN NISA                     -                      -                             -                           -
      Kelompok    Kel. Sawo PPK II               -                      -                             -                           -
      Kelompok    Kel. Salak(Lunas)              -                      -                             -                           -
      Kelompok    AL-HIKMAH              4,845,000              4,845,000                             -                           -
      Kelompok    AINUN NISA             5,985,000              5,985,000                             -                           -
      Kelompok    Kel. Sawo PPK II       2,450,000              2,450,000                             -                           -
      Kelompok    ASSYFA PNPM.MP         9,500,000              9,500,000                             -                           -
      Kelompok    NURUL IMAN PNPM.MP 9,500,000                  9,500,000                             -                           -
      Kelompok    ALBAROKAH PNPM.MP 8,375,000                   8,375,000                             -                           -
      Kelompok    ALIYAH PNPM.MP         7,450,000              7,450,000                             -                           -
      Kelompok    MANGGIS PNPM.MP        4,800,000              4,800,000                             -                           -
      Kelompok    SALAK (Perg)           7,700,000              7,700,000                             -                           -
      Kelompok               -                   -                      -                             -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
      Kelompok   #REF!                #REF!                   #REF!                                   -                           -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -
   Kelompok    #REF!                      #REF!                    #REF!                           -             -

        TOTAL                             #REF!                    #REF!                           -             -


                                   CADANGAN RESIKO          JUMLAH PINJAMAN       JUMLAH CADANGAN
     TINGKAT
                                        PINJAMAN                                      RESIKO           Diketahui dan disetujui Ole
  KOLEKTIBILITAS                            (1)                      (2)              "(3=1 X 2)
KOLEKTIBILITAS I                           1%              #REF!                       #REF!
KOLEKTIBILITAS II                         10%                                 -                    -
KOLEKTIBILITAS III                        25%                                 -                    -
KOLEKTIBILITAS IV                         50%                                 -                    -
KOLEKTIBILITAS V                         100%                                 -                    -
                                        TOTAL              #REF!                       #REF!               ( Rosdianah, Amd. )
                                     RASIO CADANGAN PINJAMAN (%)                                               Ketua UPK
                                                                                       #REF!
                                         (TOTAL (3) / TOTAL (2) )
MCFS/LAPORAN.xls/Perkembengan-pinjaman ( Dimodifikasi Dono-FK Cby - Krwg)
PP
AHUN : 2009




                 SISA PINJAMAN               SISA PINJAMAN YG

                YG MENUNGGAK              MENUNGGAK DIATAS 6 KALI

              5 S/D 6 KALI ANGSURAN             ANGSURAN

              KOLEKTIBILITAS IV             KOLEKTIBILITAS V

                       7                            8
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                                      -                             -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -
                               -                       -

                               -                       -



Diketahui dan disetujui Oleh         Dibuat oleh




    ( Rosdianah, Amd. )            ( Inah Carsinah )
        Ketua UPK                  Bendahara UPK

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:12
posted:11/19/2010
language:Indonesian
pages:114
ferry mulyanto ferry mulyanto CEO http://wpcreativedesign.com
About