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

	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	-1%	0%	1%	2%	2%	3%	4%	5%	6%	7%		$100,0	$110,6	889
6			2	8,16%	199,29%	2	0%	2%	3%	5%	7%	8%	10%	12%	14%	16%		FX (Buy)	FX (Sell)
7			3	12,49%	417,77%	3	1%	3%	6%	9%	11%	14%	17%	20%	22%	25%		грн.42,00	грн.46,00
8			4	16,99%	795,75%	4	2%	5%	9%	12%	16%	20%	24%	28%	32%	36%
9			5	21,67%	1449,64%	5	3%	7%	11%	16%	21%	26%	31%	37%	42%	48%		Tax Rate	YTM	Years
10			6	26,53%	2580,88%	6	3%	9%	14%	20%	26%	33%	39%	46%	54%	61%		18,50%	5,18%	2
11			7	31,59%	4537,91%	7	4%	11%	17%	24%	32%	39%	48%	57%	66%	76%
12			8	36,86%	7923,59%	8	5%	12%	20%	28%	37%	47%	57%	68%	79%	92%		Net Profit %	Devaluation
13			9	42,33%	13780,81%	9	6%	14%	23%	33%	43%	55%	67%	80%	94%	109%	грн.164,45	$7,05	Усього (рази)	В рік %
14			10	48,02%	23913,81%	10	7%	16%	26%	38%	50%	63%	77%	93%	110%	128%	$3,57	7,05%	1,10	5%
15	👆 УСІЛЯКІ ФІНАНСОВІ ШТУКИ-ДРЮКИ НА КАНАЛІ																		110%
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					-$1	-0,7%		$112	$7	7034	грн.1 301	$13,01
21			грн.60	25%	9,58%	12%	IBHE	3					$20	20,2%		$132	$13	3695	грн.684	$11,39
22			грн.70	25%	9,58%	17%	IBHF	4					$29	28,6%		$144	$14	5893	грн.1 090	$15,57
23			грн.90	25%	9,58%	22%	IBHG	5					$37	37,4%		$158	$15	10020	грн.1 854	$20,60
24				100%
25							$ОВДП > на		15%	iBond > на		21%
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