2.2.Kiriditorlar bo’yicha tahlil.
Oy
|
Kredit balansi
|
Asosiy qarz to’lovi
|
%
|
Asosiy qarzni qaytarish
|
A
|
B
|
C
|
F
|
G
|
1
|
200000000.00
|
0.00
|
2833333,33
|
2833333,33
|
2
|
200000000.00
|
0.00
|
2833333,33
|
2833333,33
|
3
|
200000000.00
|
0.00
|
2833333,33
|
2833333,33
|
4
|
200000000.00
|
0.00
|
2833333,33
|
2833333,33
|
5
|
200000000.00
|
0.00
|
2833333,33
|
2833333,33
|
6
|
200000000.00
|
0.00
|
2833333,33
|
2833333,33
|
7
|
200000000.00
|
2490866.05
|
2833333,33
|
2833333,33
|
8
|
197509133.95
|
2526153.31
|
2798046,06
|
5324199,38
|
9
|
194982980.64
|
2561940.49
|
2762258,89
|
5324199,38
|
10
|
192421040.15
|
2598234,64
|
2725964,74
|
5324199,38
|
11
|
189822805.51
|
2635042,97
|
2689156,41
|
5324199,38
|
12
|
187187762.54
|
2672372,74
|
2651826,64
|
5324199,38
|
13
|
184515389.80
|
2710231,36
|
2613968,02
|
5324199,38
|
14
|
181805158.44
|
2748626,30
|
2575573,08
|
5324199,38
|
15
|
179056532.14
|
2787565,17
|
2536634,21
|
5324199,38
|
16
|
176268966.97
|
2827055,68
|
2497143,70
|
5324199,38
|
17
|
173441911.29
|
2867105,64
|
2457093,74
|
5324199,38
|
18
|
170574805.65
|
2907722,97
|
2416476,41
|
5324199,38
|
19
|
167667082.69
|
2948915,71
|
2375283,67
|
5324199,38
|
20
|
164718166.98
|
2990692,01
|
2333507,37
|
5324199,38
|
21
|
161727474.96
|
3033060,15
|
2291139,23
|
5324199,38
|
22
|
158694414.81
|
3076028,50
|
2248170,88
|
5324199,38
|
23
|
155618386.31
|
3119605,57
|
2204593,81
|
5324199,38
|
24
|
152498780.74
|
3163799,99
|
2160399,39
|
5324199,38
|
25
|
149334980.75
|
3208620,49
|
2115578,89
|
5324199,38
|
26
|
146126360.27
|
3254075,94
|
2070123,44
|
5324199,38
|
27
|
142872284.33
|
3300175,35
|
2024024,03
|
5324199,38
|
28
|
139572108.98
|
3346927,84
|
1977271,54
|
5324199,38
|
29
|
136225181.14
|
3394342,65
|
1929856,73
|
5324199,38
|
30
|
132830838.49
|
3442429,17
|
1881770,21
|
5324199,38
|
31
|
129388409.33
|
3491196,91
|
1833002,47
|
5324199,38
|
32
|
125897212.41
|
3540655,54
|
1783543,84
|
5324199,38
|
33
|
122356556.88
|
3590814,82
|
1733384,56
|
5324199,38
|
34
|
118765742.05
|
3641684,70
|
1682514,68
|
5324199,38
|
35
|
115124057.35
|
3693275,23
|
1630924,15
|
5324199,38
|
36
|
111430782.12
|
3745596,63
|
1578602,75
|
5324199,38
|
37
|
107685185.49
|
3798659,25
|
1525540,13
|
5324199,38
|
38
|
103886526.24
|
3852473,59
|
1471725,79
|
5324199,38
|
39
|
100034052.65
|
3907050,30
|
1417149,08
|
5324199,38
|
40
|
96127002.35
|
3962400,18
|
1361799,20
|
5324199,38
|
41
|
92164602.17
|
4018534,18
|
1305665,20
|
5324199,38
|
42
|
88146067.99
|
4075463,42
|
1248735,96
|
5324199,38
|
43
|
84070604.57
|
4133199,15
|
1191000,23
|
5324199,38
|
44
|
79937405.42
|
4191752,80
|
1132446,58
|
5324199,38
|
45
|
75745652.62
|
4251135,97
|
1073063,41
|
5324199,38
|
46
|
71494516.65
|
4311360,39
|
1012838,99
|
5324199,38
|
47
|
67183156.26
|
4372438,00
|
951761,38
|
5324199,38
|
48
|
62810718.26
|
4434380,87
|
889818,51
|
5324199,38
|
49
|
58376337.39
|
4497201,27
|
826998,11
|
5324199,38
|
50
|
53879136.13
|
4560911,62
|
763287,76
|
5324199,38
|
51
|
49318224.51
|
4625524,53
|
698674,85
|
5324199,38
|
52
|
44692699.98
|
4691052,80
|
633146,58
|
5324199,38
|
53
|
40001647.18
|
4757509,38
|
566690,00
|
5324199,38
|
54
|
35244137.80
|
4824907,43
|
499291,95
|
5324199,38
|
55
|
30419230.38
|
4893260,28
|
430939,10
|
5324199,38
|
56
|
25525970.09
|
4962581,47
|
361617,91
|
5324199,38
|
57
|
20563388.62
|
5032884,71
|
291314,67
|
5324199,38
|
58
|
15530503.92
|
5104183,91
|
220015,47
|
5324199,38
|
59
|
10426320.01
|
5176493,18
|
147706,20
|
5324199,38
|
60
|
5249826.83
|
5249826,83
|
74372,55
|
5324199,38
|
Jami:
|
|
200000000,00
|
104506766,47
|
304506766,47
|
2.3. Loyihaning muddati.
Loyihani bajarish uchun amalga oshirilishi zarur bo’lgan operatsiyalar quyidagi jadvalda keltirilgan.
2-jadval
Loyihaning operatsiyalari tarkibi va muddatlari
#
|
Operatsiyalar nomi
|
Muddati
(hafta)
|
Belgilanishi
|
Bog’liqligi
|
1
|
Marketing
|
3
|
A
|
-
|
2
|
Biznes reja
|
1
|
B
|
A
|
3
|
Kredit
|
1
|
C
|
B
|
4
|
Hujjatlar
|
1
|
D
|
C
|
5
|
Qurilish mollariga shartnoma
|
1
|
E
|
D
|
6
|
Qurilish mollarini yetkazish
|
1
|
F
|
E
|
7
|
Quruvchilar bilan shartnoma
|
1
|
G
|
F
|
8
|
Fundament quyish
|
4
|
H
|
G,F
|
9
|
G’isht terish
|
3
|
I
|
H
|
10
|
Tom yopish
|
2
|
J
|
I
|
11
|
Elektr ta’minoti
|
1
|
K
|
J
|
12
|
Devor suvash
|
2
|
L
|
K,N
|
13
|
Polni ta’mirlash
|
1
|
M
|
L
|
14
|
Romlarninqo’yish
|
1
|
N
|
J
|
15
|
Potolokni ta’mirlash
|
2
|
O
|
M
|
16
|
Suv ta’minoti
|
1
|
P
|
S,O
|
17
|
Gaz ta’minoti
|
1
|
Q
|
S,O
|
18
|
Shpaklyovka
|
2
|
R
|
M
|
19
|
Oboy
|
1
|
S
|
R
|
20
|
Mebel bilan shartnoma
|
1
|
T
|
I
|
21
|
Mebel olib kelish
|
2
|
U
|
T,P,Q
|
22
|
Oshxona jihozlari shartnoma
|
1
|
V
|
I
|
23
|
Oshxona jihozlarini olib kelish
|
1
|
W
|
V,R,S
|
24
|
Hodimlar yollash
|
2
|
X
|
Z,W,U
|
25
|
Mahsulot bilan shartnoma
|
1
|
Z
|
M
|
26
|
Mahsulot olib kelish
|
2
|
AA
|
Z,W,U
|
27
|
Foydalanishga topshirish
|
1
|
Y
|
X,AA
|
2.4.Loyihaning NPV, IRR, PBP
Ushbu bo’limda loyihadan keladigan foydaning qay darajada samarali ekanligi, uning qoplanish muddati kabi ko’rsatkichlar kp’rib chiqiladi.
NPV(Net present value) – loyihadan kelajakda keladigan foydaning bugungi kundagi qiymatini ifodalovchi ko’rsatkich. U quyidagi formula orqali aniqlanadi:
NPV=-I+ ;
№
|
Yillar
|
I1
|
CF
|
Ne+V
|
1
|
2020
|
604506766
|
120 000 000
|
102564103
|
2
|
2021
|
|
150 000 000
|
109577033
|
3
|
2022
|
|
160 000 000
|
99899289
|
4
|
2023
|
|
190 000 000
|
101393509
|
5
|
2024
|
|
215 000 000
|
98063898
|
6
|
2025
|
|
260 000 000
|
101358034
|
Ushbu formula va birlamchi ma’lumotlar orqali NPV aniqlaymiz.
3-jadval
NPV hisoblash uchun birlamchi ma’lumotlar
Izoh: I*= 300000000(o’z mablag’lari) + 200000000(kredit summasi) + 104506766(kredit foizi)
NPV = - 604506766 + + + + + + = - 604506766 + 612855866 =8349100.
IRR( Internal rate of return) – NPV 0 ga teng bo’lganda r miqdorini topish.
IRR = NPV = 0 = - I +
Formuladan foydalanib r ni topsak, r = 17.46%
PBP(Pay back period) – loyihaning qoplanish muddati. 2 xil usulda hisoblanadi. Oddiy va diskontli.
I
|
Kutilayotgan umumiy foyda
|
CF ning joriy qiymati
(NetV)
|
1
|
120 000 000
|
102564103
|
2
|
270 000 000
|
212141136
|
3
|
430 000 000
|
312040425
|
4
|
620 000 000
|
413433934
|
5
|
835 000 000
|
511497832
|
6
|
1095000000
|
612855866
|
Yuqoridagi jadvalda korxonaning har bir yil uchun umumiy foydani 2 xil usulda hisoblab oldik. Ushbu ma’lumotlar asosida 2 xil PBP hisoblaymiz.
PBPo = 3+
PBPd = 5+
Xulosa
Ko’rib chiqilgan loyihaning umumiy qiymati 500 mln so’m( kredit summasi bilan 604506766 so’mni tashkil qiladi). O’z mablag’lari 300 mlnni tashkil qiladi. Ushbu loyihani amalga oshirishda ta’sir ko’rsatadigan hamma faktorlarni e’tiborga olib chuqur tahlil etiladi.
Loyianing qoplash muddati oddiy usulda 4 yilga yaqin muddatda qoplash mumkin bo’lsa, diskont usulida esa 6 yilda qoplash mumkin bo’ladi.
Do'stlaringiz bilan baham: |