Excel XLSX | Diposting 25 Jul 2022 | 3 thn lalu
Authentication
digital resources
234x Tipe XLSX Ukuran file 0.01 MB Source: mahasiswa.yai.ac.id
NAMA : NABILA AIZANA PUTRI
NIM : 1834290023
MATKUL : RENCANA ANGGARAN BIAYA
TUGAS CASH FLOW
Jumlah Biaya= Rp 6,000,000,000.00 Retensi=5%
Jasa/fee (10%)= Rp 600,000,000.00
Total= Rp 6,600,000,000.00
20% 40% 75% 100%
Bobot komulatif 3% 13% 24% 39% 58% 73% 84% 95% 100%
Bobot/bln 3% 9% 11% 16% 18% 16% 11% 11% 5%
Cost/ bulan 19980000000% 55020000000% 68340000000% 93360000000% 108360000000% 93360000000% 63360000000% 68340000000% 30000000000%
Termin (penerimaan) 0% 3% 13% 24% 39% 58% 73% 84% 100%
Pembayaran 8% 27% 41% 24%
Penerimaan 49500000000% 177804000000% 271326000000% 161370000000%
No Uraian Bulan Keterangan
1 2 3 4 5 6 7 8 9
1 Penerimaan Bersih Rp 495,000,000 Rp 1,778,040,000 Rp 2,713,260,000 Rp 1,613,700,000 Rp 6,600,000,000
2 Pengeluaran -Rp 199,800,000 -Rp 550,200,000 -Rp 683,400,000 -Rp 933,600,000 -Rp 1,083,600,000 -Rp 933,600,000 -Rp 633,600,000 -Rp 683,400,000 -Rp 300,000,000 -Rp 6,001,200,000
3 Sellisih Penerimaan Pengeluaran -Rp 199,800,000 -Rp 550,200,000 -Rp 188,400,000 -Rp 933,600,000 Rp 694,440,000 -Rp 933,600,000 Rp 2,079,660,000 -Rp 683,400,000 Rp 1,313,700,000 Rp 598,800,000
4 Kas Awal Rp 200,000,000 Rp 275,100,000 Rp 341,700,000 Rp 466,800,000 Rp 541,800,000 Rp 466,800,000 Rp 316,800,000 Rp 341,700,000 Rp 150,000,000
5 Kas Sebelum Finansial (3+4) Rp 200,000 -Rp 275,100,000 Rp 153,300,000 -Rp 466,800,000 Rp 1,236,240,000 -Rp 466,800,000 Rp 2,396,460,000 -Rp 341,700,000 Rp 1,463,700,000
6 Financial 6.1 Pinjaman Rp 274,900,000 Rp 619,549,000 Rp 322,444,490 Rp 1,020,768,935 Rp - Rp 798,505,990 Rp - Rp 494,272,361 Rp -
6.2. Pengembalian Rp - Rp - Rp - Rp - -Rp 747,063,376 Rp - -Rp 2,031,868,950 Rp - -Rp 751,508,451
6.3. Bunga Pinjaman (1%) Rp - -Rp 2,749,000 -Rp 8,944,490 -Rp 12,168,935 -Rp 22,376,624 -Rp 14,905,990 -Rp 22,891,050 -Rp 2,572,361 -Rp 7,515,085
Total Financial (6.1+6.2+6.2) Rp 274,900,000 Rp 616,800,000 Rp 313,500,000 Rp 1,008,600,000 -Rp 769,440,000 Rp 783,600,000 -Rp 2,054,760,000 Rp 491,700,000 -Rp 759,023,535
7 Kas Akhir (5+tot fin) Rp 275,100,000 Rp 341,700,000 Rp 466,800,000 Rp 541,800,000 Rp 466,800,000 Rp 316,800,000 Rp 341,700,000 Rp 150,000,000 Rp 704,676,465 Rp 504,676,465
8 Kimulatif Pinjaman Rp 274,900,000 Rp 894,449,000 Rp 1,216,893,490 Rp 2,237,662,425 Rp 1,490,599,049 Rp 2,289,105,040 Rp 257,236,090 Rp 751,508,451 Rp -
15 hari/30 hari = 1/2 Pengeluaran -Rp 99,900,000 -Rp 275,100,000 -Rp 341,700,000 -Rp 466,800,000 -Rp 541,800,000 -Rp 466,800,000 -Rp 316,800,000 -Rp 341,700,000 -Rp 150,000,000
no reviews yet
Please Login to review.
