Cash Flow.docx
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 Cash Flow.docx as PDF for free.
More details
- Words: 476
- Pages: 2
Cash Flow Inflasi TIC Investasi Land Pinjaman Working Capital Total VC dan SVC Variable cost SVC Fixed Cost Sales Depresiasi
= 10% = Rp = Rp = = = = = = = = =
M. Cost
Bagian Investasi
Tahun (n)
Profit After Tax
Salvage
% Kapasitas % Investasi
Rp Rp Rp Rp Rp Rp Rp Rp Rp
Pokok Pinjaman 139.157.860.282,51 622.117.493.027,70 9.277.190.685,50 248.846.997.211,08 93.317.623.954,16 265.007.877.151,48 60.283.185.074,38 204.724.692.077,09 60.283.185.074,38 1.130.113.620.000,00 52.879.986.907,35 0 0
Subtotal Investasi Investasi
-Rp -Rp
139.157.860.282,51 622.117.493.027,70
Land Pinjaman
Rp
248.846.997.211,08
Angsuran per bulan
= = =
Rp 248.846.997.211,08 120 Bulan 0,15
=
Rp Rp Rp
4.014.771.961,31 48.177.263.535,75 481.772.635.357,46
1
2
3
4
5
60
80
100
100
100
Working Capital
-Rp
93.317.623.954,16
Variable Cost
-Rp
265.007.877.151,48
-Rp
265.007.877.151,48
-Rp
265.007.877.151,48
-Rp
265.007.877.151,48
-Rp
265.007.877.151,48
Pembayaran utang ke Bank Fixed Cost
-Rp -Rp
48.177.263.535,75 60.283.185.074,38
-Rp -Rp
48.177.263.535,75 60.283.185.074,38
-Rp -Rp
48.177.263.535,75 60.283.185.074,38
-Rp -Rp
48.177.263.535,75 60.283.185.074,38
-Rp -Rp
48.177.263.535,75 60.283.185.074,38
Manufacturing Cost Salvage Value
-Rp
219.287.911.365,27
-Rp
272.289.486.795,57
-Rp
325.291.062.225,86
-Rp
325.291.062.225,86
-Rp
325.291.062.225,86
Sales Depresiasi
Rp -Rp
678.068.172.000,00 52.879.986.907,35
Rp -Rp
904.090.896.000,00 52.879.986.907,35
Rp -Rp
1.130.113.620.000,00 52.879.986.907,35
Rp 1.130.113.620.000,00 -Rp 52.879.986.907,35
Rp -Rp
1.130.113.620.000,00 52.879.986.907,35
Rp
458.780.260.634,73 15
Rp
631.801.409.204,43 15
Rp
804.822.557.774,14 15
Rp
804.822.557.774,14 15
Rp
804.822.557.774,14 15
-Rp
Pretax profit % Tax
52.879.986.907,35 15
Taxable Profit (Keuntungan) Income Tax (Pajak)
-Rp Rp
52.879.986.907,35 7.931.998.036,10
Rp -Rp
405.900.273.727,38 60.885.041.059,11
Rp -Rp
578.921.422.297,08 86.838.213.344,56
Rp -Rp
751.942.570.866,78 112.791.385.630,02
Rp -Rp
751.942.570.866,78 112.791.385.630,02
Rp -Rp
751.942.570.866,78 112.791.385.630,02
Profit after Tax (Laba bersih)
-Rp
44.947.988.871,25
Rp
345.015.232.668,27
Rp
492.083.208.952,52
Rp
639.151.185.236,77
Rp
639.151.185.236,77
Rp
639.151.185.236,77
Cash Flow Discount factor (Nilai inflasi)
-Rp
449.378.931.049,17 1
-Rp
107.592.973.045,40 0,909090909
Rp
Rp
186.542.979.523,10 0,751314801
Rp
186.542.979.523,10 0,683013455
Rp
186.542.979.523,10 0,620921323
Net Present Value Cumulative Net Present Value
-Rp -Rp
449.378.931.049,17 449.378.931.049,17
-Rp -Rp
97.811.793.677,63 547.190.724.726,81
Rp -Rp
Rp -Rp
140.152.501.519,98 374.414.253.587,94
Rp -Rp
127.411.365.018,17 247.002.888.569,77
Rp -Rp
115.828.513.652,88 131.174.374.916,89
39.475.003.238,85 0,826446281 32.623.969.618,88 514.566.755.107,92
6
7
8
9
10
11
100
100
100
100
100
Tutup
-Rp -Rp
265.007.877.151,48 48.177.263.535,75
-Rp -Rp
265.007.877.151,48 48.177.263.535,75
-Rp -Rp
265.007.877.151,48 48.177.263.535,75
-Rp -Rp
265.007.877.151,48 48.177.263.535,75
-Rp -Rp
265.007.877.151,48 48.177.263.535,75
-Rp -Rp
60.283.185.074,38 325.291.062.225,86
-Rp -Rp
60.283.185.074,38 325.291.062.225,86
-Rp -Rp
60.283.185.074,38 325.291.062.225,86
-Rp -Rp
60.283.185.074,38 325.291.062.225,86
-Rp -Rp
60.283.185.074,38 325.291.062.225,86
Rp
1.130.113.620.000,00
Rp
1.130.113.620.000,00
Rp
1.130.113.620.000,00
Rp
1.130.113.620.000,00
Rp
1.130.113.620.000,00
-Rp Rp
52.879.986.907,35 804.822.557.774,14
-Rp Rp
52.879.986.907,35 804.822.557.774,14
-Rp Rp
52.879.986.907,35 804.822.557.774,14
-Rp Rp
52.879.986.907,35 804.822.557.774,14
-Rp Rp
52.879.986.907,35 804.822.557.774,14
Rp
15 751.942.570.866,78
Rp
751.942.570.866,78
Rp
15 751.942.570.866,78
Rp
15 751.942.570.866,78
Rp
15 751.942.570.866,78
-Rp Rp
112.791.385.630,02 639.151.185.236,77
-Rp Rp
112.791.385.630,02 639.151.185.236,77
-Rp Rp
112.791.385.630,02 639.151.185.236,77
-Rp Rp
112.791.385.630,02 639.151.185.236,77
-Rp Rp
112.791.385.630,02 639.151.185.236,77
Rp
186.542.979.523,10
Rp
186.542.979.523,10
Rp
186.542.979.523,10
Rp
186.542.979.523,10
Rp
186.542.979.523,10
Rp
0,56447393 105.298.648.775,35
-Rp
25.875.726.141,55
15
Rp
0,513158118 95.726.044.341,22
Rp
Rp
69.850.318.199,68
Rp
0,46650738 87.023.676.673,84 156.873.994.873,52
Rp Rp
0,424097618 79.112.433.339,85 235.986.428.213,37
Rp Rp
0,385543289 71.920.393.945,32 307.906.822.158,69
Rp
9.277.190.685,50
-Rp
457.310.929.085,28
-Rp
0,350493899 160.284.690.810,56
Rp
147.622.131.348,13
N-18
= 10% = Rp = Rp = = = = = = = = =
M. Cost
Bagian Investasi
Tahun (n)
Profit After Tax
Salvage
% Kapasitas % Investasi
Rp Rp Rp Rp Rp Rp Rp Rp Rp
Pokok Pinjaman 139.157.860.282,51 622.117.493.027,70 9.277.190.685,50 248.846.997.211,08 93.317.623.954,16 265.007.877.151,48 60.283.185.074,38 204.724.692.077,09 60.283.185.074,38 1.130.113.620.000,00 52.879.986.907,35 0 0
Subtotal Investasi Investasi
-Rp -Rp
139.157.860.282,51 622.117.493.027,70
Land Pinjaman
Rp
248.846.997.211,08
Angsuran per bulan
= = =
Rp 248.846.997.211,08 120 Bulan 0,15
=
Rp Rp Rp
4.014.771.961,31 48.177.263.535,75 481.772.635.357,46
1
2
3
4
5
60
80
100
100
100
Working Capital
-Rp
93.317.623.954,16
Variable Cost
-Rp
265.007.877.151,48
-Rp
265.007.877.151,48
-Rp
265.007.877.151,48
-Rp
265.007.877.151,48
-Rp
265.007.877.151,48
Pembayaran utang ke Bank Fixed Cost
-Rp -Rp
48.177.263.535,75 60.283.185.074,38
-Rp -Rp
48.177.263.535,75 60.283.185.074,38
-Rp -Rp
48.177.263.535,75 60.283.185.074,38
-Rp -Rp
48.177.263.535,75 60.283.185.074,38
-Rp -Rp
48.177.263.535,75 60.283.185.074,38
Manufacturing Cost Salvage Value
-Rp
219.287.911.365,27
-Rp
272.289.486.795,57
-Rp
325.291.062.225,86
-Rp
325.291.062.225,86
-Rp
325.291.062.225,86
Sales Depresiasi
Rp -Rp
678.068.172.000,00 52.879.986.907,35
Rp -Rp
904.090.896.000,00 52.879.986.907,35
Rp -Rp
1.130.113.620.000,00 52.879.986.907,35
Rp 1.130.113.620.000,00 -Rp 52.879.986.907,35
Rp -Rp
1.130.113.620.000,00 52.879.986.907,35
Rp
458.780.260.634,73 15
Rp
631.801.409.204,43 15
Rp
804.822.557.774,14 15
Rp
804.822.557.774,14 15
Rp
804.822.557.774,14 15
-Rp
Pretax profit % Tax
52.879.986.907,35 15
Taxable Profit (Keuntungan) Income Tax (Pajak)
-Rp Rp
52.879.986.907,35 7.931.998.036,10
Rp -Rp
405.900.273.727,38 60.885.041.059,11
Rp -Rp
578.921.422.297,08 86.838.213.344,56
Rp -Rp
751.942.570.866,78 112.791.385.630,02
Rp -Rp
751.942.570.866,78 112.791.385.630,02
Rp -Rp
751.942.570.866,78 112.791.385.630,02
Profit after Tax (Laba bersih)
-Rp
44.947.988.871,25
Rp
345.015.232.668,27
Rp
492.083.208.952,52
Rp
639.151.185.236,77
Rp
639.151.185.236,77
Rp
639.151.185.236,77
Cash Flow Discount factor (Nilai inflasi)
-Rp
449.378.931.049,17 1
-Rp
107.592.973.045,40 0,909090909
Rp
Rp
186.542.979.523,10 0,751314801
Rp
186.542.979.523,10 0,683013455
Rp
186.542.979.523,10 0,620921323
Net Present Value Cumulative Net Present Value
-Rp -Rp
449.378.931.049,17 449.378.931.049,17
-Rp -Rp
97.811.793.677,63 547.190.724.726,81
Rp -Rp
Rp -Rp
140.152.501.519,98 374.414.253.587,94
Rp -Rp
127.411.365.018,17 247.002.888.569,77
Rp -Rp
115.828.513.652,88 131.174.374.916,89
39.475.003.238,85 0,826446281 32.623.969.618,88 514.566.755.107,92
6
7
8
9
10
11
100
100
100
100
100
Tutup
-Rp -Rp
265.007.877.151,48 48.177.263.535,75
-Rp -Rp
265.007.877.151,48 48.177.263.535,75
-Rp -Rp
265.007.877.151,48 48.177.263.535,75
-Rp -Rp
265.007.877.151,48 48.177.263.535,75
-Rp -Rp
265.007.877.151,48 48.177.263.535,75
-Rp -Rp
60.283.185.074,38 325.291.062.225,86
-Rp -Rp
60.283.185.074,38 325.291.062.225,86
-Rp -Rp
60.283.185.074,38 325.291.062.225,86
-Rp -Rp
60.283.185.074,38 325.291.062.225,86
-Rp -Rp
60.283.185.074,38 325.291.062.225,86
Rp
1.130.113.620.000,00
Rp
1.130.113.620.000,00
Rp
1.130.113.620.000,00
Rp
1.130.113.620.000,00
Rp
1.130.113.620.000,00
-Rp Rp
52.879.986.907,35 804.822.557.774,14
-Rp Rp
52.879.986.907,35 804.822.557.774,14
-Rp Rp
52.879.986.907,35 804.822.557.774,14
-Rp Rp
52.879.986.907,35 804.822.557.774,14
-Rp Rp
52.879.986.907,35 804.822.557.774,14
Rp
15 751.942.570.866,78
Rp
751.942.570.866,78
Rp
15 751.942.570.866,78
Rp
15 751.942.570.866,78
Rp
15 751.942.570.866,78
-Rp Rp
112.791.385.630,02 639.151.185.236,77
-Rp Rp
112.791.385.630,02 639.151.185.236,77
-Rp Rp
112.791.385.630,02 639.151.185.236,77
-Rp Rp
112.791.385.630,02 639.151.185.236,77
-Rp Rp
112.791.385.630,02 639.151.185.236,77
Rp
186.542.979.523,10
Rp
186.542.979.523,10
Rp
186.542.979.523,10
Rp
186.542.979.523,10
Rp
186.542.979.523,10
Rp
0,56447393 105.298.648.775,35
-Rp
25.875.726.141,55
15
Rp
0,513158118 95.726.044.341,22
Rp
Rp
69.850.318.199,68
Rp
0,46650738 87.023.676.673,84 156.873.994.873,52
Rp Rp
0,424097618 79.112.433.339,85 235.986.428.213,37
Rp Rp
0,385543289 71.920.393.945,32 307.906.822.158,69
Rp
9.277.190.685,50
-Rp
457.310.929.085,28
-Rp
0,350493899 160.284.690.810,56
Rp
147.622.131.348,13
N-18
Related Documents
Cash
November 2019 38
Cash
November 2019 44
Cash
October 2019 50
Cash Disbursements & Cash Receipts Journals
April 2020 23
Cash Receipts
November 2019 21
Cash Flow1
June 2020 3More Documents from "Atits"
Laporan Tahan Api
August 2019 37
3880-9885-1-sm.pdf
December 2019 46
Kak I-challenge.docx
May 2020 24
Cash Flow.docx
May 2020 16
30593.pdf
May 2020 19