Download - Rencana Keuangan
-
7/25/2019 Rencana Keuangan
1/6
1 Tabel 1
2 Asumsi yg diperhitungkan
No Tahun 0 1 2 3 4
4 Pengaruh Inflasi pertahun 10% 10% 10% 10%
5 Indek inflasi 1.00 1.10 1.21 1.33 1.46
6 Nilai sisa Kendaraan !!!
" Nilai sisa #esin !!!
$ Nilai eli rg &dl aru "'321
( Biaya Operasi/Variabel 113,960 12,36 13!,"92 11,6"1 166,"#9
10 )ahan aku $5'000 (3'500 102'$50 113'135 124'44(
11 Tenaga ker*a langsung 25'200 2"'"20 30'4(2 33'541 36'$(5
12 +istrik,-ir,Telp 2'"60 3'036 3'340 3'6"4 4'041
13 Transportasi pe&asaran 1'000 1'100 1'210 1'331 1'464
14 Biaya umum/Tetap 6,6"9 66,33 9,"01 #9,"!
15 -d&inistrasi u&u& 500 550 605 666 "32
16 /a*i 2'100 2'310 2'541 2'"(5 3'0"5
1" )iaa gedung kantor "00 ""0 $4" (32 1'025
1$ )iaa Peralatan kantor 500 550 605 666 "32
1( T$tal biaya umum 3,"00 #,1"0 #,9" ,0" ,6#
20 )unga 3$'1$4 3$'610 31'41$ 20'235
21 Penusutan 23'325 23'325 23'325 23'"$(
2223 Pa*ak pertahun 30% 30% 30% 30%
24 %ata&data pen'ualan
25 % Kenaikan pen*ualan pertahun 10% 10% 10%
26 Pen*ualan, nit atuan 400 440 4$4 532
2" arga,unit'satuanp. 600 660 "26 "((
2$ )iaa 7ariael per unit 313 313 313 313
2( (n)estasi Barang *$dal #!!,300 Tari+ beban penyusutan dari dir'en pa'ak
30 /edung 442'500 5.0% 5.0% 5.0% 5.0%
31 Kendaraan 12'(00 20.0% 20.0% 20.0% 20.0%
32 #esin 16'(00 10.0% 10.0% 10.0% 10.0%
33 Peralatan 5'000 20.0% 20.0% 20.0% 20.0%
34 Biaya enyusutan &ur Th 23,32 23,32 23,32 23,!"935 /edung 20 22'125 22'125 22'125 22'125
36 Kendaraan 5
3" #esin 10 200 200 200 200
3$ Peralatan 5 1'000 1'000 1'000 1'464
3( -kedul emb. in' Bunga
40 aldo a8al pin*a&an 1 $0% 3$1'$40 3$6'102 314'1"" 202'345
41 -rus Kas 2 33'(22 110'535 143'24( 1$4'0"0
42 )unga pin*a&an 9 1 : 3 10.0% 3$'1$4 3$'610 31'41$ 20'235
43 Pe&.pk pin*a&an 2 3 : 4 4'262 "1'(25 111'$32 163'$36
44 ,o akhir pin*a&an 1 4 : 5 3$6'102 314'1"" 202'345 3$'510
-
7/25/2019 Rencana Keuangan
2/6
Tabel 2P;KI--N +-)-,/I alue NP> 32'$24
23 Internal ate =f eturn I 12.2$%
24 )enefit ?ost ratio ),@ atio 1.0$
25 Paa?k periode 1.52
-rus dana 30%1 33'(22 0.""51( 26'2(6.36 0."6(23
2 110'534."$ 0.600(3 66'423.16 0.5(1"2
3 12.2$% 143'24(.31 0.465$3 66'"30.35 0.4551"
4 1"6'"4(."( 0.36111 63'$26.36 0.35013
5 262'302.0( 0.2"((3 "3'426.56 0.26(33
2(6'"02."(
4""'300
NP> 1$0'5(".21
I 4.$3%
-
7/25/2019 Rencana Keuangan
3/6
5
10%
1.61
12'(00
14'(00
1"3,3#
136'$(3
40'5$5
4'445
1'611
33,!60
$05
3'3$2
1'12"
$05
6,120
3'$51
23'"$(
30%
10%
5$6
$"$
313
5.0%
20.0%
10.0%
20.0%
23,!"922'125
200
1'464
3$'510
234'502
3'$51
3$'510
0
-
7/25/2019 Rencana Keuangan
4/6
5
514,461
360'123
154'33$
1#,#61
1$3'534
6'120
324'$0$
23'"$(
301'01(
3'$51
2("'16$
$('150
20$'01"
234'502
2"'$00
262'302
22$'("(52'4$3
5(."
P>26'0(4
65'405
65'202
61'$$5
"0'646
2$('232.10
4""'300
1$$'06".(0
-
7/25/2019 Rencana Keuangan
5/6
1 Tabel 1
2 Asumsi yg diperhitungkan
No Tahun 0 1 2 3 4 5
4 Pengaruh Inflasi pertahun 10% 10% 10% 10% 10%
5 Indek inflasi 1.00 1.10 1.21 1.33 1.46 1.61
6 Nilai sisa Kendaraan !!! !!! 20'000
" Nilai sisa #esin !!! !!! 40'000$ Nilai eli rg &dl aru 21('615
$ Biaya Operasi/Variabel
( )ahan aku 12'000
10 Tenaga ker*a langsung 6'000
11 +istrik,-ir,Telp 4'000
12 Transportasi pe&asaran 1'500
13 Biaya umum/Tetap
14 -d&inistrasi u&u& 3'000
15 /a*i 2'500
16 )iaa gedung kantor 1'500
1" )iaa Peralatan kantor 1'000
1$ T$tal biaya umum ",000
1( )unga
20 Penusutan
21
22 Pa*ak pertahun 25% 25% 25% 30% 25%
23 %ata&data pen'ualan
24 % Kenaikan pen*ualan pertahun 5% 5% 5% 5%
25 Pen*ualan, nit atuan 500
26 arga,unit'satuanp. 650
2" )iaa 7ariael per unit
2$ (n)estasi Barang *$dal 1,000,000 Tari+ beban penyusutan dari dir'en pa'ak
2( /edung 450'000 5.0% 5.0% 5.0% 5.0%
30 Kendaraan 150'000 20.0% 20.0% 20.0% 20.0%
31 #esin 250'000 20.0% 20.0% 20.0% 20.0%
32 Peralatan 150'000 33.3% 33.3% 33.3% 33.3%
33 Biaya enyusutan &ur Th34 /edung 20
35 Kendaraan 5
36 #esin 5
3" Peralatan 3
3$ -kedul emb. in' Bunga
3( aldo a8al pin*a&an 1 $0%
40 -rus Kas 2
41 )unga pin*a&an 9 1 : 3 10.0%
42 Pe&.pk pin*a&an 2 3 : 4
43 ,o akhir pin*a&an 1 4 : 5
-
7/25/2019 Rencana Keuangan
6/6
1
2-nggaran Ko&prehensif per 1 Banuari 31