Tugas Mandiri Modul 4_sang Ayu Putu Juliani.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Tugas Mandiri Modul 4_sang Ayu Putu Juliani.xlsx as PDF for free.
More details
- Words: 358
- Pages: 4
PT GEMAH RIPAH LOHJINAWI ANALISIS UMUR PIUTANG Nomor
Debitur
TOP
Tanggal Faktur
A B C B A A C
30 60 20 60 30 30 20
24-Aug-00 05-Nov-00 01-Dec-00 05-Dec-00 07-Dec-00 14-Dec-00 24-Dec-00
INV/001/00 INV/002/00 INV/003/00 INV/004/00 INV/005/00 INV/006/00 INV/007/00 JUMLAH Cadangan :
ljt <= 30 30 < ljt < 60 ljt >= 60
= = =
DAFTAR PIUTANG DEBITUR Belum Jatuh Tempo Lewat Jatuh Tempo LJT <= 30 30 < LJT < 60 LJT >= 60 JUMLAH
Tanggal Laporan : Belum Jt. Lewat Jt. Nilai Faktur Tempo Tempo 6,000,000 3,000,000 2,000,000 1,000,000 1,500,000 500,000 2,000,000 16,000,000 2,000,000 6,000,000
C :
2,000,000
: : :
2,000,000 4,000,000
6,000,000 3,000,000 2,000,000 1,000,000 1,500,000 500,000 2,000,000 8,000,000 x x x
8,000,000 2% 3% 4%
31-Dec-00 LJT <= 30
Lewat Jatuh Tempo (hari) 30 <= LJT < 60
LJT >= 60 6,000,000
2,000,000
2,000,000 = = =
40,000 240,000
6,000,000
Debitur A (TOP = 30 hari) Tgl Faktur Nilai Faktur 24-Sep-00 3,000,000 7-Oct-00 2,000,000 8-Dec-00 1,000,000
Debitur B (TOP = 30 hari) Tgl Faktur Nilai Faktur 25-Sep-00 3,000,000 29-Sep-00 2,000,000 25-Nov-00 1,000,000
Cadangan Kerugian Piutang adalah 1%, 2%, 3% masing-masing untuk piutang lewat jatuh tempo <= 30 hari, 30 < LJT dan LJT >= 60 hari.
PT GEMAH RIPAH LOHJINAWI ANALISIS UMUR PIUTANG No
Debitur
1 2 3 4 5 6
Cadangan :
A B B A B A
Tanggal Faktur
24-Sep-00 25-Sep-00 29-Sep-00 07-Oct-00 25-Nov-00 08-Dec-00 Total Total Debitur A Total Debitur B
Syarat Bayar 30 30 30 30 30 30
LJT <= 30 30 <= LJT < 60 LJT >= 60
Nilai Faktur 3,000,000 3,000,000 2,000,000 2,000,000 1,000,000 1,000,000 12,000,000 6,000,000 6,000,000 Cadangan = = =
Tanggal Laporan : Nilai Faktur Belum Jt. Tempo
1,000,000 1,000,000 1,000,000 -
1,000,000 2,000,000 8,000,000
tang lewat jatuh tempo <= 30 hari, 30 < LJT < 60,
31-Dec-00 Nilai Faktur Sudah Jt. Tempo 3,000,000 3,000,000 2,000,000 2,000,000 1,000,000 11,000,000 5,000,000 6,000,000
x x x
LJT <= 30
Lewat Jatuh Tempo (hari) 30 <= LJT < 60
LJT >= 60 3,000,000 3,000,000 2,000,000
2,000,000 1,000,000 1,000,000 1,000,000 10,000 1% 2% 3%
2,000,000 2,000,000 40,000 = = =
8,000,000 3,000,000 5,000,000 240,000 10,000 40,000 240,000
Debitur
TOP
Tanggal Faktur
A B C B A A C
30 60 20 60 30 30 20
24-Aug-00 05-Nov-00 01-Dec-00 05-Dec-00 07-Dec-00 14-Dec-00 24-Dec-00
INV/001/00 INV/002/00 INV/003/00 INV/004/00 INV/005/00 INV/006/00 INV/007/00 JUMLAH Cadangan :
ljt <= 30 30 < ljt < 60 ljt >= 60
= = =
DAFTAR PIUTANG DEBITUR Belum Jatuh Tempo Lewat Jatuh Tempo LJT <= 30 30 < LJT < 60 LJT >= 60 JUMLAH
Tanggal Laporan : Belum Jt. Lewat Jt. Nilai Faktur Tempo Tempo 6,000,000 3,000,000 2,000,000 1,000,000 1,500,000 500,000 2,000,000 16,000,000 2,000,000 6,000,000
C :
2,000,000
: : :
2,000,000 4,000,000
6,000,000 3,000,000 2,000,000 1,000,000 1,500,000 500,000 2,000,000 8,000,000 x x x
8,000,000 2% 3% 4%
31-Dec-00 LJT <= 30
Lewat Jatuh Tempo (hari) 30 <= LJT < 60
LJT >= 60 6,000,000
2,000,000
2,000,000 = = =
40,000 240,000
6,000,000
Debitur A (TOP = 30 hari) Tgl Faktur Nilai Faktur 24-Sep-00 3,000,000 7-Oct-00 2,000,000 8-Dec-00 1,000,000
Debitur B (TOP = 30 hari) Tgl Faktur Nilai Faktur 25-Sep-00 3,000,000 29-Sep-00 2,000,000 25-Nov-00 1,000,000
Cadangan Kerugian Piutang adalah 1%, 2%, 3% masing-masing untuk piutang lewat jatuh tempo <= 30 hari, 30 < LJT dan LJT >= 60 hari.
PT GEMAH RIPAH LOHJINAWI ANALISIS UMUR PIUTANG No
Debitur
1 2 3 4 5 6
Cadangan :
A B B A B A
Tanggal Faktur
24-Sep-00 25-Sep-00 29-Sep-00 07-Oct-00 25-Nov-00 08-Dec-00 Total Total Debitur A Total Debitur B
Syarat Bayar 30 30 30 30 30 30
LJT <= 30 30 <= LJT < 60 LJT >= 60
Nilai Faktur 3,000,000 3,000,000 2,000,000 2,000,000 1,000,000 1,000,000 12,000,000 6,000,000 6,000,000 Cadangan = = =
Tanggal Laporan : Nilai Faktur Belum Jt. Tempo
1,000,000 1,000,000 1,000,000 -
1,000,000 2,000,000 8,000,000
tang lewat jatuh tempo <= 30 hari, 30 < LJT < 60,
31-Dec-00 Nilai Faktur Sudah Jt. Tempo 3,000,000 3,000,000 2,000,000 2,000,000 1,000,000 11,000,000 5,000,000 6,000,000
x x x
LJT <= 30
Lewat Jatuh Tempo (hari) 30 <= LJT < 60
LJT >= 60 3,000,000 3,000,000 2,000,000
2,000,000 1,000,000 1,000,000 1,000,000 10,000 1% 2% 3%
2,000,000 2,000,000 40,000 = = =
8,000,000 3,000,000 5,000,000 240,000 10,000 40,000 240,000
Related Documents
Tugas Mandiri Modul 4_sang Ayu Putu Juliani.xlsx
November 2019 10
Tugas Mandiri Modul 4 Aka.xlsx
November 2019 17
Tugas Mandiri
October 2019 51
Tugas Mandiri
November 2019 41
Tugas Mandiri
May 2020 47
Latihan Mandiri Modul A.docx
April 2020 10More Documents from "THE JACK"
Tugas Mandiri Modul 4_sang Ayu Putu Juliani.xlsx
November 2019 10
Vdfd.txt
June 2020 1
Rain Detector.docx
November 2019 42
Bab%20ii.pdf
June 2020 7
Bismillah Ok Copy.docx
October 2019 11