2.
2016
EXCEL.
. , . . , .
1. , . 1, :
22 - $1,000,000, K , 1 .
2. , . 2, :
15 $1,000,000, L , 1 . $ M.
3. . 3, :
1 N $12, ( , ) $ R. $1,000,000. .
: , 2008 , .
, 2, , .
1
| No | K | L | M | N | R |
| 20.0% | 60.0% | $ 600,000 | 100,000 | $ 800,000 | |
| 20.5% | 59.5% | $ 610,000 | 99,900 | $ 850,000 | |
| 21.0% | 59.0% | $ 620,000 | 99,800 | $ 900,000 | |
| 21.5% | 58.5% | $ 630,000 | 99,700 | $ 950,000 | |
| 22.0% | 58.0% | $ 640,000 | 99,600 | $ 1,000,000 | |
| 22.5% | 57.5% | $ 650,000 | 99,500 | $ 800,000 | |
| 23.0% | 57.0% | $ 660,000 | 99,400 | $ 850,000 | |
| 23.5% | 56.5% | $ 670,000 | 99,300 | $ 900,000 | |
| 24.0% | 56.0% | $ 680,000 | 99,200 | $ 950,000 | |
| 24.5% | 55.5% | $ 690,000 | 99,100 | $ 1,000,000 | |
| 25.0% | 55.0% | $ 700,000 | 99,000 | $ 1,050,000 | |
| 25.5% | 54.5% | $ 710,000 | 98,900 | $ 1,100,000 | |
| 26.0% | 54.0% | $ 720,000 | 98,800 | $ 1,150,000 | |
| 26.5% | 53.5% | $ 730,000 | 98,700 | $ 1,200,000 | |
| 27.0% | 53.0% | $ 740,000 | 98,600 | $ 800,000 |
2.
| 01.01.2008 | 01.01.2009 | . 1 | . 2 | . 3 | ||
| (ASSETS) | ||||||
| $2,350 | $1,200 | |||||
| 4,000 | 6,000 | |||||
| 10,000 | 8,000 | |||||
| 16,470 | 15,500 | |||||
| , | 16,125 | 20,810 | ||||
| 7,625 | 8,810 | |||||
| , | 8,500 | 12,000 | ||||
| 1,400 | 1,100 | |||||
| , | ||||||
| 12,500 | 16,000 | |||||
| $28,970 | $31,500 |
|
|
|
| $4,000 | $5,800 | ||||
| 5,000 | 7,000 | ||||
| 8,000 | 7,500 | ||||
| 13,000 | 14,500 | ||||
| () | |||||
| , 6%* | 2,000 | 2,000 | |||
| , $12 | 6,000 | 6,000 | |||
| 1,000 | 1,000 | ||||
| () | 15,970 | 17,000 | |||
| () | $28,970 | $31,500 |
* - 6%
EXCEL.
. .
- , .
- , .
- ().
. , . 3 . , .
|
|
|
1. , .
2. , 2.
3. , 3.
4. , ( ) 1.
.
5. , . . 4,5,6 , , , [20% - 100%] 20% ( 2).
6. . . 4,5,6 , , [20% - 100%] 20% ( 3).
7 8 , , 2.
1
| 282,000 | ||
| 31.01 | 20% | |
| 19,740 | ||
| 600,000 | ||
| 31.01 | 45% | |
| : | ||
| 90,000 | 31.01 | |
| 78,000 | . | |
| 643.8 | ||
| 60,000 | 31.01 | |
| 30,000 | 31.01 | |
| 24% | ||
| . | ||
| . | ||
| , | ||
| . | ||
| . | ||
| . 1 | ||
| 01.01. | 31.01. | |
| 22,400 | ||
| 48,000 | ||
| - | 5,400 | |
| 12,000 | ||
| 32,762 | ||
| 1,862 | ||
| 30,900 | ||
| , | 118,700 | |
| 34,000 | ||
| 21,200 | ||
| - | ||
| 20,000 | ||
| 30,000 | ||
| 12,680 | ||
| , | 118,700 |
| . 2 | ||
| : | ||
| . 3 | ||
| . | ||
| . | ||
| . | ||
|
|
|
2
3
( 5 10)
| (. .) | ( . .) | ( .) | |||||||
| 50% | 45.0% | 25.0% | 10% | 15.0% | 6.0% | 14.0% | 6.0% | ||
| 50% | 45.5% | 40.0% | 15% | 14.5% | 5.5% | 9.5% | 7.0% | ||
| 45% | 46.0% | 35.0% | 15% | 14.0% | 5.0% | 10.0% | 8.0% | ||
| 55% | 46.5% | 40.0% | 15% | 13.5% | 4.5% | 10.5% | 9.0% | ||
| 55% | 47.0% | 20.0% | 15% | 13.0% | 4.0% | 11.0% | 7.0% | ||
| 55% | 47.5% | 25.0% | 15% | 12.5% | 3.5% | 11.5% | 6.0% | ||
| 55% | 48.0% | 60.0% | 15% | 12.0% | 3.0% | 12.0% | 5.0% | ||
| 55% | 48.5% | 35.0% | 15% | 12.5% | 3.5% | 10.5% | 4.0% | ||
| 55% | 49.0% | 40.0% | 15% | 13.0% | 4.0% | 9.0% | 3.0% | ||
| 60% | 49.5% | 20.0% | 15% | 13.5% | 4.5% | 7.5% | 5.0% | ||
| 70% | 49.0% | 25.0% | 15% | 14.0% | 5.0% | 7.0% | 6.0% | ||
| 80% | 48.5% | 39.0% | 15% | 14.5% | 5.5% | 6.5% | 7.0% | ||
| 90% | 48.0% | 35.0% | 15% | 15.0% | 6.0% | 6.0% | 8.0% | ||
| 80% | 47.5% | 40.0% | 15% | 15.5% | 12.0% | 0.0% | 10.0% | ||
| 90% | 47.0% | 20.0% | 15% | 16.0% | 11.5% | 0.5% | 9.0% |
