Задание_4 (1001741), страница 4
Текст из файла (страница 4)
[(1+E)t-1]/[E(1+E)t]={коэффициент суммы дисконтирования}
t – срок выплаты кредита
Результаты смотреть ниже в Таблице № 8
Значение коэффициента (1+E)t
Расчёт искомого значения IRR ведут методом последовательных приближений. Подставляя в расчётную формулу расчётные ставки дисконта (E) определяют такое её значение, при котором выполняется равенство (1).
Если расчётные значения IRR больше процентной ставки по заёмным инвестициям предлагаемые финансовыми институтами в проект, то проект считается приемлемыми и наоборот.
7,07* Kсд = 99,3
[(1+E)t-1]/[E(1+E)t =99,3/7,07 = 14,045
(1+E)t = 2,563
Е = 4%, t = 24.
годы | Годовая ставка | ||||||||||||||
1% | 2% | 3% | 4% | 5% | 6% | 7% | 8% | 9% | 10% | 11% | 12% | 13% | 14% | 15% | |
1 | 1,010 | 1,020 | 1,030 | 1,040 | 1,050 | 1,060 | 1,070 | 1,080 | 1,090 | 1,100 | 1,110 | 1,120 | 1,130 | 1,140 | 1,150 |
2 | 1,020 | 1,040 | 1,061 | 1,082 | 1,102 | 1,124 | 1,143 | 1,166 | 1,188 | 1,210 | 1,232 | 1,234 | 1,277 | 1,300 | 1,323 |
3 | 1,030 | 1,061 | 1,093 | 1,123 | 1,190 | 1,191 | 1,225 | 1,260 | 1,293 | 1,331 | 1,368 | 1,405 | 1,443 | 1,82 | 1,321 |
4 | 1,041 | 1,082 | 1,126 | 1,170 | 1,216 | 1,262 | 1,311 | 1,360 | 1,412 | 1,464 | 1,518 | 1,574 | 1,630 | 1,689 | 1,249 |
5 | 1,031 | 1,104 | 1,139 | 1,217 | 1,216 | 1,338 | 1,403 | 1,469 | 1,339 | 1,611 | 1,685 | 1,762 | 1,842 | 1,925 | 1,011 |
6 | 1,062 | 1,126 | 1,194 | 1,265 | 1,340 | 1,419 | 1,501 | 1,587 | 1,677 | 1,772 | 1,870 | 1,974 | 2,082 | 2,195 | 2,313 |
7 | 1,072 | 1,149 | 1,230 | 1,316 | 1,407 | 1,504 | 1,606 | 1,714 | 1,828 | 1,949 | 2,076 | 2,211 | 2,353 | 2,502 | 2,660 |
8 | 1,083 | 1,172 | 1,267 | 1,369 | 1,477 | 1,594 | 1,718 | 1,851 | 1,993 | 2,144 | 2,305 | 2,476 | 2,650 | 2,853 | 3,039 |
9 | 1,094 | 1,193 | 1,303 | 1,423 | 1,551 | 1,689 | 1,838 | 1,999 | 2,172 | 2,358 | 2,550 | 2,773 | 3,004 | 3,252 | 3,318 |
10 | 1,103 | 1,219 | 1,344 | 1,480 | 1,629 | 1,791 | 1,967 | 2,139 | 2,367 | 2,594 | 2,839 | 3,106 | 3,395 | 3,707 | 4,096 |
11 | 1,116 | 1,243 | 1,384 | 1,539 | 1,710 | 1,898 | 2,105 | 2,232 | 2,380 | 2,853 | 3,352 | 3,479 | 3,836 | 4,226 | 4,632 |
12 | 1,127 | 1,268 | 1,426 | 1,601 | 1,796 | 2,012 | 2,252 | 2,318 | 2,813 | 3,138 | 3,498 | 3,896 | 4,335 | 4,818 | 5,350 |
13 | 1,138 | 1,294 | 1,469 | 1,663 | 1,886 | 2,133 | 2,410 | 2,720 | 3,066 | 3,452 | 3,883 | 4,363 | 4,898 | 5,492 | 6,133 |
14 | 1,149 | 1,319 | 1,513 | 1,732 | 1,980 | 2,261 | 2,579 | 2,937 | 3,342 | 3,797 | 4,310 | 4,887 | 5,535 | 6,261 | 7,076 |
15 | 1,161 | 1,346 | 1,558 | 1,801 | 2,079 | 2,397 | 2,739 | 3,172 | 3,642 | 4,177 | 4,785 | 5,474 | 6,254 | 7,138 | 8,137 |
16 | 1,173 | 1,373 | 1,605 | 1,873 | 2,183 | 2,540 | 2,952 | 3,426 | 3,970 | 4,595 | 5,311 | 6,130 | 7,067 | 8,137 | 9,358 |
17 | 1,184 | 1,400 | 1,653 | 1,948 | 2,292 | 2,693 | 3,159 | 3,700 | 4,328 | 5,054 | 5,895 | 6,066 | 7,896 | 9,276 | 10,76 |
18 | 1,194 | 1,428 | 1,702 | 2,026 | 2,407 | 2,854 | 3,380 | 3,996 | 4,717 | 5,560 | 6,544 | 7,690 | 9,024 | 10,38 | 12,38 |
19 | 1,208 | 1,457 | 1,754 | 2,107 | 2,527 | 3,026 | 3,617 | 4,316 | 5,142 | 6,116 | 7,263 | 8,613 | 10,20 | 12,06 | 14,23 |
20 | 1,220 | 1,486 | 1,806 | 2,191 | 2,653 | 3,207 | 3,870 | 4,661 | 5,604 | 6,727 | 8,062 | 9,646 | 11,52 | 13,74 | 16,37 |
21 | 1,232 | 1,516 | 1,86 | 2,279 | 2,786 | 3,399 | 4,140 | 5,034 | 6,109 | 7,400 | 8,949 | 10,804 | 13,021 | 15,667 | 18,821 |
22 | 1,245 | 1,516 | 1,96 | 2,370 | 2,925 | 3,603 | 4,430 | 5,436 | 6,658 | 8,140 | 9,933 | 12,100 | 14,713 | 17,861 | 21,644 |
23 | 1,257 | 1,577 | 1,974 | 2,467 | 3,071 | 3,820 | 4,740 | 5,871 | 7,258 | 8,954 | 11,026 | 13,552 | 16,626 | 20,361 | 24,891 |
24 | 1,270 | 1,608 | 2,033 | 2,563 | 3,225 | 4,049 | 5,072 | 6,341 | 7,911 | 9,850 | 12,239 | 15,178 | 18,788 | 23,212 | 28,625 |
25 | 1,282 | 1,641 | 2,094 | 2,666 | 3,386 | 4,292 | 5,427 | 6,848 | 8,623 | 10,83 | 13,59 | 17,00 | 21,23 | 26,46 | 32,92 |
26 | 1,348 | 1,811 | 2,427 | 3,243 | 4,322 | 5,743 | 7,612 | 10,86 | 13,27 | 17,45 | 22,89 | 29,96 | 39,12 | 50,95 | 66,21 |