latihan kelayakan proyek

94
no tahun investasi operasi 1 2016 360 0.360 2 2017 0.360 3 2018 0.360 4 2019 0.360 5 2020 0.360 6 2021 0.360 7 2022 0.360 8 2023 0.360 9 2024 0.360 10 2025 0.360 11 2026 0.360 12 2027 0.360 13 2028 0.360 14 2029 0.360 15 2030 0.360 16 2031 0.360 17 2032 0.360 18 2033 0.360 19 2034 0.360 20 2035 0.360 21 2036 0.360 22 2037 0.360

Upload: hanifan-ihsani

Post on 12-Jan-2016

89 views

Category:

Documents


8 download

DESCRIPTION

kelayakan

TRANSCRIPT

no tahun investasi operasi pemeliharaan

1 2016 360 0.360 2 2017 0.360 3.000 3 2018 0.360 3.000 4 2019 0.360 3.000 5 2020 0.360 3.000 6 2021 0.360 3.000 7 2022 0.360 4.000 8 2023 0.360 5.000 9 2024 0.360 6.000

10 2025 0.360 7.000 11 2026 0.360 8.000 12 2027 0.360 9.000 13 2028 0.360 10.000 14 2029 0.360 11.000 15 2030 0.360 12.000 16 2031 0.360 13.000 17 2032 0.360 14.040 18 2033 0.360 15.163 19 2034 0.360 16.376 20 2035 0.360 17.686 21 2036 0.360 19.101 22 2037 0.360 20.629

23 2038 0.360 22.280 24 2039 0.360 24.062 25 2040 0.360 25.987 26 2041 0.360 28.066 27 2042 0.360 30.311 28 2043 0.360 32.736 29 2044 0.360 35.355 30 2045 0.360 38.184 31 2046 41.238

discount factor

360.360 1.0000 3.360 0.4822 3.360 0.2325 3.360 0.1121 3.360 0.0541 3.360 0.0261 4.360 0.0126 5.360 0.0061 6.360 0.0029 7.360 0.0014 8.360 0.0007 9.360 0.0003 10.360 0.0002 11.360 0.0001 12.360 0.0000 13.360 0.0000 14.400 0.0000 15.523 0.0000 16.736 0.0000 18.046 0.0000 19.461 0.0000 20.989 0.0000

total pengeluaran

22.640 0.0000 24.422 0.0000 26.347 0.0000 28.426 0.0000 30.671 0.0000 33.096 0.0000 35.715 0.0000 38.544 0.0000 41.238 0.0000

untung

anuitas

NPV

no tahun

360.360000 1.620292 0.781353 1 2016 0.376792 2 2017 0.181700 3 2018 0.087621 4 2019 0.054829 5 2020 0.032504 6 2021 0.018599 7 2022 0.010379 8 2023 0.005685 9 2024 0.003070 10 2025 0.001638 11 2026 0.000866 12 2027 0.000455 13 2028 0.000237 14 2029 0.000123 15 2030 0.000064 16 2031 0.000033 17 2032 0.000017 18 2033 0.000009 19 2034 0.000005 20 2035

total pengeluaran diperhitungkan thn 2016

0.000002 21 2036 0.000001 22 2037 0.000001 23 2038 0.000000 24 2039 0.000000 25 2040 0.000000 26 2041 0.000000 27 2042 0.000000 28 2043 0.000000 29 2044

30 2045 363.53627805165 31 2046 36.353628 399.889906 42.420021

60.217086

gol 1 gol 2 pendapatan 1.000 1.300 0.015 0.020 20,000 5,000 600,000,000 20,300 5,100 610,000,000 20,604 5,202 620,170,000 20,914 5,306 630,512,950 21,227 5,412 641,031,852 21,546 5,520 651,729,762 21,869 5,631 662,609,789 22,197 5,743 673,675,099 22,530 5,858 684,928,911 22,868 5,975 696,374,504 23,211 6,095 708,015,214 23,559 6,217 719,854,437 23,912 6,341 731,895,627 24,271 6,468 744,142,304 24,635 6,597 756,598,045 25,005 6,729 769,266,494 25,380 6,864 782,151,360 25,760 7,001 795,256,416 26,147 7,141 808,585,504 26,539 7,284 822,142,533

26,937 7,430 835,931,482 27,341 7,578 849,956,401 27,751 7,730 864,221,414 28,168 7,884 878,730,715 28,590 8,042 893,488,575 29,019 8,203 908,499,341 29,454 8,367 923,767,437 29,896 8,534 939,297,366 30,344 8,705 955,093,713 30,800 8,879 971,161,143 31,262 9,057 987,504,405

600,000,000 294,160,197 144,217,811 70,705,993 34,665,375 16,995,655 8,332,634 4,085,347 2,002,987 982,041 481,486 236,069 115,744 56,749 27,824 13,642 6,689 3,280 1,608 788

total pendapatan diperhitungkan thn

2016

387 190 93 46 22 11 5 3 1 1 0

1,177,092,677 423,753,363,722

no tahun investasi operasi pemeliharaan

1 2016 360 0.360 2 2017 0.360 3.000 3 2018 0.360 3.000 4 2019 0.360 3.000 5 2020 0.360 3.000 6 2021 0.360 3.000 7 2022 0.360 4.000 8 2023 0.360 5.000 9 2024 0.360 6.000

10 2025 0.360 7.000 11 2026 0.360 8.000 12 2027 0.360 9.000 13 2028 0.360 10.000 14 2029 0.360 11.000 15 2030 0.360 12.000 16 2031 0.360 13.000 17 2032 0.360 14.040 18 2033 0.360 15.163 19 2034 0.360 16.376 20 2035 0.360 17.686 21 2036 0.360 19.101 22 2037 0.360 20.629

23 2038 0.360 22.280 24 2039 0.360 24.062 25 2040 0.360 25.987 26 2041 0.360 28.066 27 2042 0.360 30.311 28 2043 0.360 32.736 29 2044 0.360 35.355 30 2045 0.360 38.184 31 2046 41.238

discount factor

360.360 1.0000 3.360 0.5714 3.360 0.3265 3.360 0.1866 3.360 0.1066 3.360 0.0609 4.360 0.0348 5.360 0.0199 6.360 0.0114 7.360 0.0065 8.360 0.0037 9.360 0.0021 10.360 0.0012 11.360 0.0007 12.360 0.0004 13.360 0.0002 14.400 0.0001 15.523 0.0001 16.736 0.0000 18.046 0.0000 19.461 0.0000 20.989 0.0000

total pengeluaran

22.640 0.0000 24.422 0.0000 26.347 0.0000 28.426 0.0000 30.671 0.0000 33.096 0.0000 35.715 0.0000 38.544 0.0000 41.238 0.0000

untung

anuitas

NPV

no tahun

360.360000 1.920000 1.097143 1 2016 0.626939 2 2017 0.358251 3 2018 0.204715 4 2019 0.151795 5 2020 0.106635 6 2021 0.072302 7 2022 0.047812 8 2023 0.031033 9 2024 0.019854 10 2025 0.012557 11 2026 0.007868 12 2027 0.004892 13 2028 0.003022 14 2029 0.001861 15 2030 0.001146 16 2031 0.000706 17 2032 0.000435 18 2033 0.000268 19 2034 0.000165 20 2035

total pengeluaran diperhitungkan thn 2016

0.000102 21 2036 0.000063 22 2037 0.000039 23 2038 0.000024 24 2039 0.000015 25 2040 0.000009 26 2041 0.000006 27 2042 0.000003 28 2043 0.000002 29 2044

30 2045 365.02966272846 31 2046 36.502966 401.532629 42.594279

150.430195

gol 1 gol 2 pendapatan 1.000 1.300 0.015 0.020 20,000 5,000 600,000,000 20,300 5,100 610,000,000 20,604 5,202 620,170,000 20,914 5,306 630,512,950 21,227 5,412 641,031,852 21,546 5,520 651,729,762 21,869 5,631 662,609,789 22,197 5,743 673,675,099 22,530 5,858 684,928,911 22,868 5,975 696,374,504 23,211 6,095 708,015,214 23,559 6,217 719,854,437 23,912 6,341 731,895,627 24,271 6,468 744,142,304 24,635 6,597 756,598,045 25,005 6,729 769,266,494 25,380 6,864 782,151,360 25,760 7,001 795,256,416 26,147 7,141 808,585,504 26,539 7,284 822,142,533

26,937 7,430 835,931,482 27,341 7,578 849,956,401 27,751 7,730 864,221,414 28,168 7,884 878,730,715 28,590 8,042 893,488,575 29,019 8,203 908,499,341 29,454 8,367 923,767,437 29,896 8,534 939,297,366 30,344 8,705 955,093,713 30,800 8,879 971,161,143 31,262 9,057 987,504,405

600,000,000 348,571,429 202,504,490 117,646,731 68,348,252 39,707,936 23,069,042 13,402,449 7,786,479 4,523,769 2,628,222 1,526,955 887,141 515,420 299,456 173,983 101,084 58,730 34,123 19,826

total pendapatan diperhitungkan thn

2016

11,519 6,693 3,889 2,259 1,313 763 443 257 150 87 51

1,431,832,937 515,459,857,363

no tahun investasi operasi pemeliharaan

1 2016 360 0.360 2 2017 0.360 3.000 3 2018 0.360 3.000 4 2019 0.360 3.000 5 2020 0.360 3.000 6 2021 0.360 3.000 7 2022 0.360 4.000 8 2023 0.360 5.000 9 2024 0.360 6.000

10 2025 0.360 7.000 11 2026 0.360 8.000 12 2027 0.360 9.000 13 2028 0.360 10.000 14 2029 0.360 11.000 15 2030 0.360 12.000 16 2031 0.360 13.000 17 2032 0.360 14.040 18 2033 0.360 15.163 19 2034 0.360 16.376 20 2035 0.360 17.686 21 2036 0.360 19.101 22 2037 0.360 20.629

23 2038 0.360 22.280 24 2039 0.360 24.062 25 2040 0.360 25.987 26 2041 0.360 28.066 27 2042 0.360 30.311 28 2043 0.360 32.736 29 2044 0.360 35.355 30 2045 0.360 38.184 31 2046 41.238

discount factor

360.360 1.0000 360.360000 3.360 0.9091 3.054545 3.360 0.8264 2.776860 3.360 0.7513 2.524418 3.360 0.6830 2.294925 3.360 0.6209 2.086296 4.360 0.5645 2.461106 5.360 0.5132 2.750528 6.360 0.4665 2.966987 7.360 0.4241 3.121358 8.360 0.3855 3.223142 9.360 0.3505 3.280623 10.360 0.3186 3.301015 11.360 0.2897 3.290587 12.360 0.2633 3.254774 13.360 0.2394 3.198278 14.400 0.2176 3.133860 15.523 0.1978 3.071182 16.736 0.1799 3.010163 18.046 0.1635 2.950723 19.461 0.1486 2.892793 20.989 0.1351 2.836305

total pengeluaran

total pengeluaran diperhitungkan

thn 2016

22.640 0.1228 2.781198 24.422 0.1117 2.727414 26.347 0.1015 2.674901 28.426 0.0923 2.623608 30.671 0.0839 2.573490 33.096 0.0763 2.524502 35.715 0.0693 2.476605 38.544 0.0630 2.429761 41.238 0.0573 2.363301

445.015250 untung 44.501525

489.516775 anuitas 51.927571

no tahun gol 1 gol 2 1.000 1.300 0.015 0.020

1 2016 20,000 5,000 26,500 2 2017 20,300 5,100 26,930 3 2018 20,604 5,202 27,367 4 2019 20,914 5,306 27,811 5 2020 21,227 5,412 28,263 6 2021 21,546 5,520 28,722 7 2022 21,869 5,631 29,189 8 2023 22,197 5,743 29,663 9 2024 22,530 5,858 30,146

10 2025 22,868 5,975 30,636 11 2026 23,211 6,095 31,134 12 2027 23,559 6,217 31,641 13 2028 23,912 6,341 32,156 14 2029 24,271 6,468 32,679 15 2030 24,635 6,597 33,212 16 2031 25,005 6,729 33,753 17 2032 25,380 6,864 34,303 18 2033 25,760 7,001 34,862 19 2034 26,147 7,141 35,430 20 2035 26,539 7,284 36,008 21 2036 26,937 7,430 36,596 22 2037 27,341 7,578 37,193

smp total per hari

23 2038 27,751 7,730 37,800 24 2039 28,168 7,884 38,417 25 2040 28,590 8,042 39,045 26 2041 29,019 8,203 39,683 27 2042 29,454 8,367 40,331 28 2043 29,896 8,534 40,991 29 2044 30,344 8,705 41,661 30 2045 30,800 8,879 42,343 31 2046 31,262 9,057 43,035

pendapatan kumulatif

9,540,000 6.000000E+08 6.000000E+08 9,694,800 6.100000E+08 1.210000E+09 9,852,156 6.201700E+08 1.830170E+09 10,012,111 6.305129E+08 2.460683E+09 10,174,709 6.410319E+08 3.101715E+09 10,339,994 6.517298E+08 3.753445E+09 10,508,012 6.626098E+08 4.416054E+09 10,678,808 6.736751E+08 5.089729E+09 10,852,430 6.849289E+08 5.774658E+09 11,028,924 6.963745E+08 6.471033E+09 11,208,341 7.080152E+08 7.179048E+09 11,390,728 7.198544E+08 7.898903E+09 11,576,137 7.318956E+08 8.630798E+09 11,764,617 7.441423E+08 9.374940E+09 11,956,222 7.565980E+08 1.013154E+10 12,151,003 7.692665E+08 1.090080E+10 12,349,014 7.821514E+08 1.168296E+10 12,550,311 7.952564E+08 1.247821E+10 12,754,949 8.085855E+08 1.328680E+10 12,962,984 8.221425E+08 1.410894E+10 13,174,473 8.359315E+08 1.494487E+10 13,389,476 8.499564E+08 1.579483E+10

smp total per tahun

13,608,051 8.642214E+08 1.665905E+10 13,830,260 8.787307E+08 1.753778E+10 14,056,163 8.934886E+08 1.843127E+10 14,285,825 9.084993E+08 1.933977E+10 14,519,307 9.237674E+08 2.026354E+10 14,756,676 9.392974E+08 2.120283E+10 14,997,996 9.550937E+08 2.215793E+10 15,243,336 9.711611E+08 2.312909E+10 15,492,764 9.875044E+08 2.411659E+10 380,700,575

1.285831E-06

no tahun investasi operasi pemeliharaan

1 2016 360 0.360 2 2017 0.360 3.000 3 2018 0.360 3.000 4 2019 0.360 3.000 5 2020 0.360 3.000 6 2021 0.360 3.000 7 2022 0.360 4.000 8 2023 0.360 5.000 9 2024 0.360 6.000

10 2025 0.360 7.000 11 2026 0.360 8.000 12 2027 0.360 9.000 13 2028 0.360 10.000 14 2029 0.360 11.000 15 2030 0.360 12.000 16 2031 0.360 13.000 17 2032 0.360 14.040 18 2033 0.360 15.163 19 2034 0.360 16.376 20 2035 0.360 17.686 21 2036 0.360 19.101 22 2037 0.360 20.629 23 2038 0.360 22.280

24 2039 0.360 24.062 25 2040 0.360 25.987 26 2041 0.360 28.066 27 2042 0.360 30.311 28 2043 0.360 32.736 29 2044 0.360 35.355 30 2045 0.360 38.184 31 2046 41.238

discount factor

360.360 1.0000 3.360 0.9091 3.360 0.8264 3.360 0.7513 3.360 0.6830 3.360 0.6209 4.360 0.5645 5.360 0.5132 6.360 0.4665 7.360 0.4241 8.360 0.3855 9.360 0.3505 10.360 0.3186 11.360 0.2897 12.360 0.2633 13.360 0.2394 14.400 0.2176 15.523 0.1978 16.736 0.1799 18.046 0.1635 19.461 0.1486 20.989 0.1351 22.640 0.1228

total pengeluaran

24.422 0.1117 26.347 0.1015 28.426 0.0923 30.671 0.0839 33.096 0.0763 35.715 0.0693 38.544 0.0630 41.238 0.0573

untung

anuitas

NPV

no tahun 360.360000 3.054545 2.776860 1 2016 2.524418 2 2017 2.294925 3 2018 2.086296 4 2019 2.461106 5 2020 2.750528 6 2021 2.966987 7 2022 3.121358 8 2023 3.223142 9 2024 3.280623 10 2025 3.301015 11 2026 3.290587 12 2027 3.254774 13 2028 3.198278 14 2029 3.133860 15 2030 3.071182 16 2031 3.010163 17 2032 2.950723 18 2033 2.892793 19 2034 2.836305 20 2035 2.781198 21 2036

total pengeluaran diperhitungkan thn 2016

2.727414 22 2037 2.674901 23 2038 2.623608 24 2039 2.573490 25 2040 2.524502 26 2041 2.476605 27 2042 2.429761 28 2043 2.363301 29 2044

30 2045 445.01524969552 31 2046 44.501525 489.516775 51.927571

2,159.188009

gol 1 gol 2 pendapatan 1.000 1.300 0.015 0.020 20,000 5,000 600,000,000 20,300 5,100 610,000,000 20,604 5,202 620,170,000 20,914 5,306 630,512,950 21,227 5,412 641,031,852 21,546 5,520 651,729,762 21,869 5,631 662,609,789 22,197 5,743 673,675,099 22,530 5,858 684,928,911 22,868 5,975 696,374,504 23,211 6,095 708,015,214 23,559 6,217 719,854,437 23,912 6,341 731,895,627 24,271 6,468 744,142,304 24,635 6,597 756,598,045 25,005 6,729 769,266,494 25,380 6,864 782,151,360 25,760 7,001 795,256,416 26,147 7,141 808,585,504 26,539 7,284 822,142,533 26,937 7,430 835,931,482

27,341 7,578 849,956,401 27,751 7,730 864,221,414 28,168 7,884 878,730,715 28,590 8,042 893,488,575 29,019 8,203 908,499,341 29,454 8,367 923,767,437 29,896 8,534 939,297,366 30,344 8,705 955,093,713 30,800 8,879 971,161,143 31,262 9,057 987,504,405

pendapatan kumulatif

216,000,000,000 216,000,000,000 199,636,363,636 415,636,363,636 184,513,388,430 600,149,752,066 170,536,936,138 770,686,688,204 157,620,016,946 928,306,705,150 145,682,246,239 1,073,988,951,389 134,649,342,695 1,208,638,294,084 124,452,664,539 1,333,090,958,623 115,028,781,057 1,448,119,739,680 106,319,076,693 1,554,438,816,373 98,269,385,247 1,652,708,201,621 90,829,651,880 1,743,537,853,501 83,953,620,816 1,827,491,474,317 77,598,546,782 1,905,090,021,099 71,724,928,380 1,976,814,949,479 66,296,261,732 2,043,111,211,211 61,278,812,838 2,104,390,024,049 56,641,407,246 2,161,031,431,296 52,355,235,694 2,213,386,666,989 48,393,674,527 2,261,780,341,517 44,732,119,765 2,306,512,461,282

total pendapatan diperhitungkan thn

2016

41,347,833,765 2,347,860,295,047 38,219,803,546 2,386,080,098,594 35,328,609,869 2,421,408,708,462 32,656,306,264 2,454,065,014,726 30,186,307,252 2,484,251,321,978 27,903,285,048 2,512,154,607,027 25,793,074,118 2,537,947,681,145 23,842,582,977 2,561,790,264,122 22,039,712,695 2,583,829,976,817 20,373,281,579 2,604,203,258,396

2,604,203,258,396

tahun ke 3 layak

no tahun investasi operasi pemeliharaan

1 2016 360 0.360 2 2017 0.360 3.000 3 2018 0.360 3.000 4 2019 0.360 3.000 5 2020 0.360 3.000 6 2021 0.360 3.000 7 2022 0.360 4.000 8 2023 0.360 5.000 9 2024 0.360 6.000

10 2025 0.360 7.000 11 2026 0.360 8.000 12 2027 0.360 9.000 13 2028 0.360 10.000 14 2029 0.360 11.000 15 2030 0.360 12.000 16 2031 0.360 13.000 17 2032 0.360 14.040 18 2033 0.360 15.163 19 2034 0.360 16.376 20 2035 0.360 17.686 21 2036 0.360 19.101 22 2037 0.360 20.629

23 2038 0.360 22.280 24 2039 0.360 24.062 25 2040 0.360 25.987 26 2041 0.360 28.066 27 2042 0.360 30.311 28 2043 0.360 32.736 29 2044 0.360 35.355 30 2045 0.360 38.184 31 2046 41.238

discount factor

360.360 1.0000 3.360 0.9524 3.360 0.9070 3.360 0.8638 3.360 0.8227 3.360 0.7835 4.360 0.7462 5.360 0.7107 6.360 0.6768 7.360 0.6446 8.360 0.6139 9.360 0.5847 10.360 0.5568 11.360 0.5303 12.360 0.5051 13.360 0.4810 14.400 0.4581 15.523 0.4363 16.736 0.4155 18.046 0.3957 19.461 0.3769 20.989 0.3589

total pengeluaran

22.640 0.3418 24.422 0.3256 26.347 0.3101 28.426 0.2953 30.671 0.2812 33.096 0.2678 35.715 0.2551 38.544 0.2429 41.238 0.2314

untung

anuitas

NPV

no tahun

360.360000 3.200000 3.047619 1 2016 2.902494 2 2017 2.764280 3 2018 2.632648 4 2019 3.253499 5 2020 3.809252 6 2021 4.304698 7 2022 4.744322 8 2023 5.132315 9 2024 5.472598 10 2025 5.768836 11 2026 6.024451 12 2027 6.242640 13 2028 6.426388 14 2029 6.596806 15 2030 6.772721 16 2031 6.954260 17 2032 7.141556 18 2033 7.334746 19 2034 7.533973 20 2035

total pengeluaran diperhitungkan thn 2016

7.739384 21 2036 7.951133 22 2037 8.169378 23 2038 8.394284 24 2039 8.626021 25 2040 8.864765 26 2041 9.110697 27 2042 9.364006 28 2043 9.541589 29 2044

30 2045 546.18135728740 31 2046 54.618136 600.799493 63.732359

3,757.543235

gol 1 gol 2 pendapatan 1.000 1.300 0.015 0.020 20,000 5,000 600,000,000 20,300 5,100 610,000,000 20,604 5,202 620,170,000 20,914 5,306 630,512,950 21,227 5,412 641,031,852 21,546 5,520 651,729,762 21,869 5,631 662,609,789 22,197 5,743 673,675,099 22,530 5,858 684,928,911 22,868 5,975 696,374,504 23,211 6,095 708,015,214 23,559 6,217 719,854,437 23,912 6,341 731,895,627 24,271 6,468 744,142,304 24,635 6,597 756,598,045 25,005 6,729 769,266,494 25,380 6,864 782,151,360 25,760 7,001 795,256,416 26,147 7,141 808,585,504 26,539 7,284 822,142,533

26,937 7,430 835,931,482 27,341 7,578 849,956,401 27,751 7,730 864,221,414 28,168 7,884 878,730,715 28,590 8,042 893,488,575 29,019 8,203 908,499,341 29,454 8,367 923,767,437 29,896 8,534 939,297,366 30,344 8,705 955,093,713 30,800 8,879 971,161,143 31,262 9,057 987,504,405

600,000,000 580,952,381 562,512,472 544,660,793 527,378,491 510,647,322 494,449,627 478,768,315 463,586,847 448,889,214 434,659,924 420,883,980 407,546,872 394,634,552 382,133,426 370,030,337 358,312,550 346,967,740 335,983,978 325,349,718

total pendapatan diperhitungkan thn

2016

315,053,784 305,085,361 295,433,979 286,089,506 277,042,135 268,282,373 259,801,033 251,589,221 243,638,329 235,940,027 228,486,250

11,954,790,535 4,303,724,592,517

no tahun investasi operasi pemeliharaan

1 2016 360 0.360 2 2017 0.360 3.000 3 2018 0.360 3.000 4 2019 0.360 3.000 5 2020 0.360 3.000 6 2021 0.360 3.000 7 2022 0.360 4.000 8 2023 0.360 5.000 9 2024 0.360 6.000

10 2025 0.360 7.000 11 2026 0.360 8.000 12 2027 0.360 9.000 13 2028 0.360 10.000 14 2029 0.360 11.000 15 2030 0.360 12.000 16 2031 0.360 13.000 17 2032 0.360 14.040 18 2033 0.360 15.163 19 2034 0.360 16.376 20 2035 0.360 17.686 21 2036 0.360 19.101 22 2037 0.360 20.629

23 2038 0.360 22.280 24 2039 0.360 24.062 25 2040 0.360 25.987 26 2041 0.360 28.066 27 2042 0.360 30.311 28 2043 0.360 32.736 29 2044 0.360 35.355 30 2045 0.360 38.184 31 2046 41.238

discount factor

360.360 1.0000 3.360 0.8696 3.360 0.7561 3.360 0.6575 3.360 0.5718 3.360 0.4972 4.360 0.4323 5.360 0.3759 6.360 0.3269 7.360 0.2843 8.360 0.2472 9.360 0.2149 10.360 0.1869 11.360 0.1625 12.360 0.1413 13.360 0.1229 14.400 0.1069 15.523 0.0929 16.736 0.0808 18.046 0.0703 19.461 0.0611 20.989 0.0531

total pengeluaran

22.640 0.0462 24.422 0.0402 26.347 0.0349 28.426 0.0304 30.671 0.0264 33.096 0.0230 35.715 0.0200 38.544 0.0174 41.238 0.0151

untung

anuitas

NPV

no tahun

360.360000 2.921739 2.540643 1 2016 2.209255 2 2017 1.921091 3 2018 1.670514 4 2019 1.884948 5 2020 2.015023 6 2021 2.079095 7 2022 2.092171 8 2023 2.066464 9 2024 2.011869 10 2025 1.936358 11 2026 1.846318 12 2027 1.746822 13 2028 1.641870 14 2029 1.538853 15 2030 1.442507 16 2031 1.352375 17 2032 1.268033 18 2033 1.189089 19 2034 1.115179 20 2035

total pengeluaran diperhitungkan thn 2016

1.045968 21 2036 0.981144 22 2037 0.920416 23 2038 0.863515 24 2039 0.810193 25 2040 0.760215 26 2041 0.713366 27 2042 0.669444 28 2043 0.622823 29 2044

30 2045 406.23729889406 31 2046 40.623730 446.861029 47.402682

1,416.338970

gol 1 gol 2 pendapatan 1.000 1.300 0.015 0.020 20,000 5,000 600,000,000 20,300 5,100 610,000,000 20,604 5,202 620,170,000 20,914 5,306 630,512,950 21,227 5,412 641,031,852 21,546 5,520 651,729,762 21,869 5,631 662,609,789 22,197 5,743 673,675,099 22,530 5,858 684,928,911 22,868 5,975 696,374,504 23,211 6,095 708,015,214 23,559 6,217 719,854,437 23,912 6,341 731,895,627 24,271 6,468 744,142,304 24,635 6,597 756,598,045 25,005 6,729 769,266,494 25,380 6,864 782,151,360 25,760 7,001 795,256,416 26,147 7,141 808,585,504 26,539 7,284 822,142,533

26,937 7,430 835,931,482 27,341 7,578 849,956,401 27,751 7,730 864,221,414 28,168 7,884 878,730,715 28,590 8,042 893,488,575 29,019 8,203 908,499,341 29,454 8,367 923,767,437 29,896 8,534 939,297,366 30,344 8,705 955,093,713 30,800 8,879 971,161,143 31,262 9,057 987,504,405

600,000,000 530,434,783 468,937,618 414,572,499 366,512,042 324,024,875 286,464,497 253,259,422 223,904,476 197,953,096 175,010,533 154,727,832 136,796,526 120,943,928 106,928,986 94,538,610 83,584,425 73,899,908 65,337,848 57,768,109

total pendapatan diperhitungkan thn

2016

51,075,647 45,158,759 39,927,538 35,302,501 31,213,383 27,598,063 24,401,628 21,575,527 19,076,841 16,867,625 14,914,333

5,062,711,859 1,822,576,269,228

no tahun investasi operasi pemeliharaan

1 2016 360 0.360 2 2017 0.360 3.000 3 2018 0.360 3.000 4 2019 0.360 3.000 5 2020 0.360 3.000 6 2021 0.360 3.000 7 2022 0.360 4.000 8 2023 0.360 5.000 9 2024 0.360 6.000

10 2025 0.360 7.000 11 2026 0.360 8.000 12 2027 0.360 9.000 13 2028 0.360 10.000 14 2029 0.360 11.000 15 2030 0.360 12.000 16 2031 0.360 13.000 17 2032 0.360 14.040 18 2033 0.360 15.163 19 2034 0.360 16.376 20 2035 0.360 17.686 21 2036 0.360 19.101 22 2037 0.360 20.629

23 2038 0.360 22.280 24 2039 0.360 24.062 25 2040 0.360 25.987 26 2041 0.360 28.066 27 2042 0.360 30.311 28 2043 0.360 32.736 29 2044 0.360 35.355 30 2045 0.360 38.184 31 2046 41.238

discount factor

360.360 1.0000 3.360 0.7692 3.360 0.5917 3.360 0.4552 3.360 0.3501 3.360 0.2693 4.360 0.2072 5.360 0.1594 6.360 0.1226 7.360 0.0943 8.360 0.0725 9.360 0.0558 10.360 0.0429 11.360 0.0330 12.360 0.0254 13.360 0.0195 14.400 0.0150 15.523 0.0116 16.736 0.0089 18.046 0.0068 19.461 0.0053 20.989 0.0040

total pengeluaran

22.640 0.0031 24.422 0.0024 26.347 0.0018 28.426 0.0014 30.671 0.0011 33.096 0.0008 35.715 0.0006 38.544 0.0005 41.238 0.0004

untung

anuitas

NPV

no tahun

360.360000 2.584615 1.988166 1 2016 1.529358 2 2017 1.176429 3 2018 0.904946 4 2019 0.903288 5 2020 0.854203 6 2021 0.779669 7 2022 0.694045 8 2023 0.606419 9 2024 0.522275 10 2025 0.444672 11 2026 0.375072 12 2027 0.313915 13 2028 0.261009 14 2029 0.216406 15 2030 0.179450 16 2031 0.148826 17 2032 0.123443 18 2033 0.102401 19 2034 0.084955 20 2035

total pengeluaran diperhitungkan thn 2016

0.070488 21 2036 0.058491 22 2037 0.048539 23 2038 0.040284 24 2039 0.033435 25 2040 0.027753 26 2041 0.023038 27 2042 0.019125 28 2043 0.015740 29 2044

30 2045 375.49045449459 31 2046 37.549045 413.039500 43.814920

615.150071

gol 1 gol 2 pendapatan 1.000 1.300 0.015 0.020 20,000 5,000 600,000,000 20,300 5,100 610,000,000 20,604 5,202 620,170,000 20,914 5,306 630,512,950 21,227 5,412 641,031,852 21,546 5,520 651,729,762 21,869 5,631 662,609,789 22,197 5,743 673,675,099 22,530 5,858 684,928,911 22,868 5,975 696,374,504 23,211 6,095 708,015,214 23,559 6,217 719,854,437 23,912 6,341 731,895,627 24,271 6,468 744,142,304 24,635 6,597 756,598,045 25,005 6,729 769,266,494 25,380 6,864 782,151,360 25,760 7,001 795,256,416 26,147 7,141 808,585,504 26,539 7,284 822,142,533

26,937 7,430 835,931,482 27,341 7,578 849,956,401 27,751 7,730 864,221,414 28,168 7,884 878,730,715 28,590 8,042 893,488,575 29,019 8,203 908,499,341 29,454 8,367 923,767,437 29,896 8,534 939,297,366 30,344 8,705 955,093,713 30,800 8,879 971,161,143 31,262 9,057 987,504,405

600,000,000 469,230,769 366,964,497 286,988,143 224,443,070 175,529,774 137,276,986 107,361,119 83,965,075 65,667,834 51,358,114 40,166,853 31,414,411 24,569,279 19,215,792 15,028,877 11,754,311 9,193,274 7,190,277 5,623,717

total pendapatan diperhitungkan thn

2016

4,398,490 3,440,220 2,690,737 2,104,547 1,646,071 1,287,481 1,007,014 787,649 616,073 481,875 376,911

2,751,779,238 990,640,525,755

no tahun investasi operasi pemeliharaan

1 2016 360 0.360 2 2017 0.360 3.000 3 2018 0.360 3.000 4 2019 0.360 3.000 5 2020 0.360 3.000 6 2021 0.360 3.000 7 2022 0.360 4.000 8 2023 0.360 5.000 9 2024 0.360 6.000

10 2025 0.360 7.000 11 2026 0.360 8.000 12 2027 0.360 9.000 13 2028 0.360 10.000 14 2029 0.360 11.000 15 2030 0.360 12.000 16 2031 0.360 13.000 17 2032 0.360 14.040 18 2033 0.360 15.163 19 2034 0.360 16.376 20 2035 0.360 17.686 21 2036 0.360 19.101 22 2037 0.360 20.629

23 2038 0.360 22.280 24 2039 0.360 24.062 25 2040 0.360 25.987 26 2041 0.360 28.066 27 2042 0.360 30.311 28 2043 0.360 32.736 29 2044 0.360 35.355 30 2045 0.360 38.184 31 2046 41.238

discount factor

360.360 1.0000 3.360 0.6667 3.360 0.4444 3.360 0.2963 3.360 0.1975 3.360 0.1317 4.360 0.0878 5.360 0.0585 6.360 0.0390 7.360 0.0260 8.360 0.0173 9.360 0.0116 10.360 0.0077 11.360 0.0051 12.360 0.0034 13.360 0.0023 14.400 0.0015 15.523 0.0010 16.736 0.0007 18.046 0.0005 19.461 0.0003 20.989 0.0002

total pengeluaran

22.640 0.0001 24.422 0.0001 26.347 0.0001 28.426 0.0000 30.671 0.0000 33.096 0.0000 35.715 0.0000 38.544 0.0000 41.238 0.0000

untung

anuitas

NPV

no tahun

360.360000 2.240000 1.493333 1 2016 0.995556 2 2017 0.663704 3 2018 0.442469 4 2019 0.382771 5 2020 0.313708 6 2021 0.248157 7 2022 0.191450 8 2023 0.144975 9 2024 0.108211 10 2025 0.079848 11 2026 0.058370 12 2027 0.042339 13 2028 0.030510 14 2029 0.021923 15 2030 0.015755 16 2031 0.011324 17 2032 0.008141 18 2033 0.005853 19 2034 0.004208 20 2035

total pengeluaran diperhitungkan thn 2016

0.003026 21 2036 0.002176 22 2037 0.001565 23 2038 0.001126 24 2039 0.000810 25 2040 0.000583 26 2041 0.000419 27 2042 0.000302 28 2043 0.000215 29 2044

30 2045 367.87282717911 31 2046 36.787283 404.660110 42.926040

302.484096

gol 1 gol 2 pendapatan 1.000 1.300 0.015 0.020 20,000 5,000 600,000,000 20,300 5,100 610,000,000 20,604 5,202 620,170,000 20,914 5,306 630,512,950 21,227 5,412 641,031,852 21,546 5,520 651,729,762 21,869 5,631 662,609,789 22,197 5,743 673,675,099 22,530 5,858 684,928,911 22,868 5,975 696,374,504 23,211 6,095 708,015,214 23,559 6,217 719,854,437 23,912 6,341 731,895,627 24,271 6,468 744,142,304 24,635 6,597 756,598,045 25,005 6,729 769,266,494 25,380 6,864 782,151,360 25,760 7,001 795,256,416 26,147 7,141 808,585,504 26,539 7,284 822,142,533

26,937 7,430 835,931,482 27,341 7,578 849,956,401 27,751 7,730 864,221,414 28,168 7,884 878,730,715 28,590 8,042 893,488,575 29,019 8,203 908,499,341 29,454 8,367 923,767,437 29,896 8,534 939,297,366 30,344 8,705 955,093,713 30,800 8,879 971,161,143 31,262 9,057 987,504,405

600,000,000 406,666,667 275,631,111 186,818,652 126,623,576 85,824,495 58,171,504 39,428,629 26,724,859 18,114,299 12,278,067 8,322,251 5,640,973 3,823,575 2,591,717 1,756,742 1,190,778 807,153 547,121 370,863

total pendapatan diperhitungkan thn

2016

251,389 170,404 115,509 78,299 53,076 35,979 24,389 16,533 11,207 7,597 5,150

1,862,102,564 670,356,922,863

no tahun investasi operasi pemeliharaan

1 2016 360 0.360 2 2017 0.360 3.000 3 2018 0.360 3.000 4 2019 0.360 3.000 5 2020 0.360 3.000 6 2021 0.360 3.000 7 2022 0.360 4.000 8 2023 0.360 5.000 9 2024 0.360 6.000

10 2025 0.360 7.000 11 2026 0.360 8.000 12 2027 0.360 9.000 13 2028 0.360 10.000 14 2029 0.360 11.000 15 2030 0.360 12.000 16 2031 0.360 13.000 17 2032 0.360 14.040 18 2033 0.360 15.163 19 2034 0.360 16.376 20 2035 0.360 17.686 21 2036 0.360 19.101 22 2037 0.360 20.629

23 2038 0.360 22.280 24 2039 0.360 24.062 25 2040 0.360 25.987 26 2041 0.360 28.066 27 2042 0.360 30.311 28 2043 0.360 32.736 29 2044 0.360 35.355 30 2045 0.360 38.184 31 2046 41.238

discount factor

360.360 1.0000 3.360 0.6061 3.360 0.3673 3.360 0.2226 3.360 0.1349 3.360 0.0818 4.360 0.0496 5.360 0.0300 6.360 0.0182 7.360 0.0110 8.360 0.0067 9.360 0.0041 10.360 0.0025 11.360 0.0015 12.360 0.0009 13.360 0.0005 14.400 0.0003 15.523 0.0002 16.736 0.0001 18.046 0.0001 19.461 0.0000 20.989 0.0000

total pengeluaran

22.640 0.0000 24.422 0.0000 26.347 0.0000 28.426 0.0000 30.671 0.0000 33.096 0.0000 35.715 0.0000 38.544 0.0000 41.238 0.0000

untung

anuitas

NPV

no tahun

360.360000 2.036364 1.234160 1 2016 0.747976 2 2017 0.453319 3 2018 0.274739 4 2019 0.216064 5 2020 0.160982 6 2021 0.115767 7 2022 0.081194 8 2023 0.055894 9 2024 0.037927 10 2025 0.025442 11 2026 0.016908 12 2027 0.011149 13 2028 0.007304 14 2029 0.004771 15 2030 0.003117 16 2031 0.002037 17 2032 0.001331 18 2033 0.000870 19 2034 0.000569 20 2035

total pengeluaran diperhitungkan thn 2016

0.000372 21 2036 0.000243 22 2037 0.000159 23 2038 0.000104 24 2039 0.000068 25 2040 0.000044 26 2041 0.000029 27 2042 0.000019 28 2043 0.000012 29 2044

30 2045 365.84893255323 31 2046 36.584893 402.433826 42.689878

196.895554

gol 1 gol 2 pendapatan 1.000 1.300 0.015 0.020 20,000 5,000 600,000,000 20,300 5,100 610,000,000 20,604 5,202 620,170,000 20,914 5,306 630,512,950 21,227 5,412 641,031,852 21,546 5,520 651,729,762 21,869 5,631 662,609,789 22,197 5,743 673,675,099 22,530 5,858 684,928,911 22,868 5,975 696,374,504 23,211 6,095 708,015,214 23,559 6,217 719,854,437 23,912 6,341 731,895,627 24,271 6,468 744,142,304 24,635 6,597 756,598,045 25,005 6,729 769,266,494 25,380 6,864 782,151,360 25,760 7,001 795,256,416 26,147 7,141 808,585,504 26,539 7,284 822,142,533

26,937 7,430 835,931,482 27,341 7,578 849,956,401 27,751 7,730 864,221,414 28,168 7,884 878,730,715 28,590 8,042 893,488,575 29,019 8,203 908,499,341 29,454 8,367 923,767,437 29,896 8,534 939,297,366 30,344 8,705 955,093,713 30,800 8,879 971,161,143 31,262 9,057 987,504,405

600,000,000 369,696,970 227,794,307 140,359,618 86,485,606 53,290,259 32,836,298 20,233,121 12,467,344 7,682,231 4,733,726 2,916,898 1,797,388 1,107,554 682,480 420,550 259,148 159,691 98,404 60,639

total pendapatan diperhitungkan thn

2016

37,367 23,027 14,190 8,744 5,389 3,321 2,046 1,261 777 479 295

1,563,179,129 562,744,486,284