Курс розвороту. Калькулятор

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1		@dropdown
2			BUILD LADDERS WITH iBONDS
3				$ОВДП	$ОЗДП
4			$ОВДП	4,0%	73%	Рік / %	1%	2%	3%	4%	5%	6%	7%	8%	9%	10%		Buy	Sell	Profit
5			1	4,00%	73,00%	1	-5%	-4%	-3%	-3%	-2%	-1%	0%	1%	1%	2%		$100,0	$110,6	2340
6			2	8,16%	199,29%	2	-4%	-3%	-1%	1%	2%	4%	6%	8%	9%	11%		FX (Buy)	FX (Sell)
7			3	12,49%	417,77%	3	-3%	-1%	2%	4%	7%	10%	12%	15%	18%	21%		грн.37,45	грн.55,00
8			4	16,99%	795,75%	4	-3%	1%	4%	8%	12%	15%	19%	23%	28%	32%
9			5	21,67%	1449,64%	5	-2%	3%	7%	12%	17%	22%	27%	32%	38%	44%		Tax Rate	YTM	Years
10			6	26,53%	2580,88%	6	-1%	4%	10%	16%	22%	28%	35%	42%	49%	57%		18,50%	5,18%	2
11			7	31,59%	4537,91%	7	0%	6%	13%	20%	27%	35%	43%	52%	62%	71%
12			8	36,86%	7923,59%	8	1%	8%	16%	24%	33%	42%	53%	63%	75%	87%		Net Profit %	Devaluation
13			9	42,33%	13780,81%	9	2%	10%	19%	29%	39%	50%	62%	76%	90%	105%	грн.432,82	$2,76	Усього (рази)	В рік %
14			10	48,02%	23913,81%	10	3%	12%	22%	33%	45%	59%	73%	89%	106%	124%	$7,87	2,76%	1,47	21%
15	👆 УСІЛЯКІ ФІНАНСОВІ ШТУКИ-ДРЮКИ НА КАНАЛІ																		147%
16
17
18			Input parameters				iBonds Ladder
19			Курс	Allo	YTM			2023	2024	2025	2026	2027		Net Profit		Вируч	Аллок	Profit	Tax	Tax usd
20			грн.100	25%	5,99%	8%	IBHD	2					-$2	-1,5%		$112	$7	7489	грн.1 385	$13,85
21			грн.60	25%	9,58%	12%	IBHE	3					$19	18,8%		$132	$13	4150	грн.768	$12,80
22			грн.70	25%	9,58%	17%	IBHF	4					$27	27,4%		$144	$14	6348	грн.1 174	$16,78
23			грн.90	25%	9,58%	22%	IBHG	5					$36	36,5%		$158	$15	10475	грн.1 938	$21,53
24				100%
25							$ОВДП > на		15%	iBond > на		20%
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
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