ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
분석기준년도 :2020
=L5/(1+$S$2)^($F5-$H$2)
할인율4.5%
3
구분비용편익
4
공사비용지보상비부대비유지
관리비		예비비총비용할인
비용		차량운행통행시간교통사고환경오염총편익할인편익총편익-총비용
5
2020 100 100 100 0 0 -100
6
2021 100 100 96 0 0 -100
7
2022 100 100 92 0 0 -100
8
2023 100 100 88 0 0 -100
9
2024 100 100 84 0 0 -100
10
2025 1,000 10,000 30 100 11,130 8,931 0 0 -11130
11
2026 2,000 20,000 40 200 22,240 17,078 0 0 -22240
12
2027 3,000 50 300 3,350 2,462 0 0 -3350
13
2028 3,000 50 300 3,350 2,356 0 0 -3350
14
2029 1,000 50 100 1,150 774 0 0 -1150
15
2030 50 50 32 500 300 10 -5 805 518 755
16
2031 50 50 31 520 320 12 -6 846 521 796
17
2032 50 50 29 540 340 14 -7 887 523 837
18
2033 50 50 28 560 360 16 -8 928 524 878
19
2034 50 50 27 580 380 18 -9 969 523 919
20
2035 50 50 26 600 400 20 -10 1,010 522 960
21
2036 50 50 25 620 420 22 -11 1,051 520 1001
22
2037 50 50 24 640 440 24 -12 1,092 517 1042
23
2038 50 50 23 660 460 26 -13 1,133 513 1083
24
2039 50 50 22 680 480 28 -14 1,174 509 1124
25
2040 50 50 21 700 500 30 -15 1,215 504 1165
26
2041 50 50 20 720 520 32 -16 1,256 498 1206
27
2042 50 50 19 740 540 34 -17 1,297 492 1247
28
2043 50 50 18 760 560 36 -18 1,338 486 1288
29
2044 50 50 17 780 580 38 -19 1,379 479 1329
30
2045 50 50 17 800 600 40 -20 1,420 472 1370
31
2046 50 50 16 800 600 40 -20 1,420 452 1370
32
2047 50 50 15 800 600 40 -20 1,420 433 1370
33
2048 50 50 15 800 600 40 -20 1,420 414 1370
34
2049 50 50 14 800 600 40 -20 1,420 396 1370
35
2050 50 50 13 800 600 40 -20 1,420 379 1370
36
2051 50 50 13 800 600 40 -20 1,420 363 1370
37
2052 50 50 12 800 600 40 -20 1,420 347 1370
38
2053 50 50 12 800 600 40 -20 1,420 332 1370
39
2054 50 50 11 800 600 40 -20 1,420 318 1370
40
2055 50 50 11 800 600 40 -20 1,420 304 1370
41
2056 50 50 10 800 600 40 -20 1,420 291 1370
42
2057 50 50 10 800 600 40 -20 1,420 279 1370
43
2058 50 50 9 800 600 40 -20 1,420 267 1370
44
2059 -27,000 50 -26,950 -4,842 800 600 40 -20 1,420 255 28370
45
계10,500 3,000 220 1,500 1,000 16,220 27,759 21,600 15,600 960 -480 37,680 12,951
46
43,220 27,756 12,952
47
=NPV($S$2,L6:L44)+L5
48
B/C0.47 =S45/M45
49
NPV(백만원)-14,808 =S45-M45
50
IRR1.69%
=IRR(T5:T44)
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100