A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Asset/Liability | Cur | 2021 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 2022 | Expenses | AVG | Cast | |
2 | Net Worth | |||||||||||||||||||
3 | Stocks / ETF | |||||||||||||||||||
4 | VT | D | 182,886 | 174,267 | 169,439 | 172,193 | 163,373 | 164,180 | 149,772 | 160,232 | 160,372 | 160,372 | ||||||||
5 | VYM | D | 50,477 | 50,184 | 49,446 | 50,513 | 48,389 | 50,090 | 45,765 | 47,871 | 47,520 | 47,520 | ||||||||
6 | VYMI | D | 214,976 | 219,808 | 215,392 | 216,384 | 204,320 | 208,000 | 188,224 | 191,264 | 189,376 | 189,376 | ||||||||
7 | ERUS | D | 0 | 0 | 0 | 8,060 | 8,060 | 8,060 | 8,060 | 8,060 | 8,060 | 8,060 | ||||||||
8 | VTV | D | 143,610 | 142,765 | 142,925 | 144,890 | 140,700 | 144,090 | 131,880 | 138,550 | 137,500 | 137,500 | ||||||||
9 | VSS | D | 53,588 | 50,476 | 49,492 | 49,556 | 45,884 | 46,248 | 41,284 | 43,728 | 43,300 | 43,300 | ||||||||
10 | VBR | D | 71,616 | 68,384 | 69,496 | 70,376 | 65,916 | 67,144 | 59,928 | 65,816 | 65,380 | 65,380 | ||||||||
11 | KO | D | 57,500 | 57,500 | 57,500 | 60,000 | 60,000 | 60,000 | 61,000 | 0 | 0 | 0 | ||||||||
12 | SONY | D | 12,633 | 11,166 | 10,253 | 10,271 | 8,605 | 9,407 | 8,177 | 8,539 | 8,632 | 8,632 | ||||||||
13 | INTEL | D | 25,795 | 24,410 | 23,850 | 24,780 | 21,795 | 22,210 | 18,705 | 18,155 | 17,695 | 17,695 | ||||||||
14 | CHEK | D | 8,375 | 9,234 | 9,882 | 7,800 | 7,200 | 7,200 | 6,200 | 6,200 | 6,800 | 6,800 | ||||||||
15 | IMMR | D | 5,710 | 5,170 | 5,320 | 5,560 | 4,670 | 5,560 | 5,340 | 5,650 | 5,780 | 5,780 | ||||||||
16 | BABA | D | 0 | 0 | 0 | 0 | 0 | 18,000 | 0 | 0 | 0 | 0 | ||||||||
17 | 3A - 99% Stocks | |||||||||||||||||||
18 | 3A - Mr - FinPension - 1 | F | 50,497 | 47,258 | 46,875 | 48,830 | 46,957 | 45,662 | 42,382 | 44,182 | 44,182 | 44,182 | ||||||||
19 | 3A - Mr - FinPension - 2 | F | 41,883 | 39,196 | 38,879 | 40,500 | 38,946 | 37,873 | 35,152 | 43,556 | 43,556 | 43,556 | ||||||||
20 | 3A - Mrs - FinPension | F | 33,311 | 31,175 | 30,922 | 32,113 | 30,880 | 30,030 | 27,872 | 34,536 | 34,536 | 34,536 | ||||||||
21 | 2A - Mr - Viac global 100 | F | 0 | 0 | 0 | 0 | 0 | 0 | 226,456 | 235,690 | 235,690 | 235,690 | ||||||||
22 | Expected Taxes | F | -8,170 | -7,646 | -7,584 | -7,894 | -7,591 | -7,382 | -21,571 | -23,268 | -23,268 | -23,268 | ||||||||
23 | VBA - 80% Stocks | |||||||||||||||||||
24 | 2A - Mr - ValuePension | F | 0 | 0 | 150,719 | 157,000 | 151,949 | 147,296 | 136,584 | 142,607 | 142,607 | 142,607 | ||||||||
25 | 2A - Mrs - Viac Sust80 | F | 4,536 | 4,310 | 4,237 | 4,355 | 4,313 | 4,147 | 3,901 | 4,031 | 4,031 | 4,031 | ||||||||
26 | Expected Taxes | F | -295 | -280 | -10,072 | -10,488 | -10,157 | -9,844 | -9,132 | -9,531 | -9,531 | -9,531 | ||||||||
27 | VBA - 5% Stocks | |||||||||||||||||||
28 | 2A - Mr - Viac Global Plus | F | 0 | 0 | 226,031 | 226,659 | 226,362 | 226,027 | 0 | 0 | 0 | 0 | ||||||||
29 | Expected Taxes | F | 0 | 0 | -14,692 | -14,733 | -14,714 | -14,692 | 0 | 0 | 0 | 0 | ||||||||
30 | Bonds | |||||||||||||||||||
31 | 2A - Mr - Extra Mand | F | 302,953 | 321,140 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||
32 | 2A - Mr - Mand | F | 54,559 | 54,806 | 873 | 1,309 | 2,071 | 2,833 | 3,594 | 4,356 | 5,118 | 5,118 | ||||||||
33 | Exp Taxes on 2A | F | -23,238 | -24,436 | -57 | -85 | -135 | -184 | -234 | -283 | -333 | -333 | ||||||||
34 | Deposits | F | 5,002 | 5,002 | 5,002 | 5,002 | 5,002 | 5,002 | 5,002 | 5,002 | 5,002 | 5,002 | ||||||||
35 | Buoni Postali ITA | E | 15,786 | 15,914 | 15,914 | 16,042 | 16,042 | 16,170 | 16,170 | 16,298 | 16,298 | 16,298 | ||||||||
36 | BSV | D | 80,820 | 80,000 | 79,500 | 77,900 | 77,030 | 77,540 | 76,790 | 77,470 | 76,830 | 76,830 | ||||||||
37 | VEMT | E | 52,358 | 51,030 | 48,680 | 48,387 | 48,128 | 47,094 | 45,708 | 48,304 | 48,422 | 48,422 | ||||||||
38 | GHYC | F | 52,394 | 50,843 | 50,274 | 50,107 | 47,333 | 47,543 | 44,249 | 47,240 | 46,832 | 46,832 | ||||||||
39 | AGGS | F | 52,400 | 51,600 | 50,700 | 49,700 | 48,300 | 48,100 | 47,300 | 48,300 | 48,400 | 48,400 | ||||||||
40 | Crypto | |||||||||||||||||||
41 | PolkaDot Staking | D | 17124 | 15,191 | 14,249 | 17,375 | 13,092 | 10,551 | 9,408 | 12,790 | 12,077 | 12,077 | ||||||||
42 | Private Equity | |||||||||||||||||||
43 | Roam | D | 1500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | ||||||||
44 | NFT Chain | F | 0 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | ||||||||
45 | Business | |||||||||||||||||||
46 | RIP UBS - CHF | F | 20000 | 20,000 | 18,439 | 25,386 | 27,912 | 36,450 | 54,520 | 58,898 | 58,898 | 58,898 | ||||||||
47 | RIP PayPal - CHF | F | 0 | 0 | 3,892 | 0 | 2,326 | 1,618 | 1,618 | 4,766 | 4,766 | 4,766 | ||||||||
48 | RIP Credits | F | 0 | 0 | 0 | 3,030 | 2,250 | 2,713 | 0 | 0 | -9,454 | -9,454 | ||||||||
49 | RIP VAT debts | F | 0 | -400 | -1,100 | -1,800 | -2,669 | -4,069 | -5,293 | -6,119 | -6,119 | -6,119 | ||||||||
50 | RIP BVG debts | F | 0 | -500 | -1,000 | -1,500 | -2,348 | -1,694 | -2,542 | -3,456 | -4,371 | -4,371 | ||||||||
51 | RIP AHV debts | F | 0 | -700 | -1,400 | -2,100 | -975 | -1,950 | -821 | -2,121 | -3,421 | -3,421 | ||||||||
52 | RIP Familienzulage credits | F | 0 | 600 | 1,200 | 1,800 | 600 | 1,200 | 0 | 600 | 1,200 | 1,200 | ||||||||
53 | RIP PayPal - EUR | E | 0 | 0 | 9 | 3,179 | 3,179 | 3,172 | 3,172 | 3,177 | 3,177 | 3,177 | ||||||||
54 | RIP Wise - EUR | E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||
55 | RIP Wise - USD | D | 0 | 0 | 0 | 2,418 | 4,408 | 7,092 | 0 | 0 | 0 | 0 | ||||||||
56 | Expected Profit Tax | F | 0 | 0 | -8 | -2,028 | -2,886 | -4,795 | -6,039 | -7,024 | -4,848 | -4848 | ||||||||
57 | Cash - Liquidity | |||||||||||||||||||
58 | BancoPosta Click | E | 2,724 | 2,645 | 2,644 | 2,643 | 2,642 | 2,634 | 2,541 | 4,403 | 4,403 | 4,403 | ||||||||
59 | PostFinance - EUR | E | 1,393 | 256 | 1,587 | 2,445 | 2,508 | 54 | 5,105 | 5,220 | 5,220 | 5,220 | ||||||||
60 | InteractiveBrokers - EUR | E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11,012 | 11,012 | 11,012 | ||||||||
61 | Revolut - EUR | E | 258 | 258 | 258 | 258 | 258 | 1 | 1 | 1 | 1 | 1 | ||||||||
62 | PayPal - EUR | E | 4,914 | 4,885 | 4,836 | 1,608 | 1,608 | 1,545 | 1,545 | 1,545 | 1,545 | 1,545 | ||||||||
63 | Stripe - EUR | E | 0 | 388 | 824 | 0 | 0 | 19 | 19 | 0 | 0 | 0 | ||||||||
64 | Kraken EUR | E | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | ||||||||
65 | Cash Bills - EUR | E | 445 | 445 | 445 | 445 | 445 | 445 | 445 | 445 | 445 | 445 | ||||||||
66 | PostFinance - CHF | F | 54,382 | 38,218 | 39,887 | 38,011 | 40,420 | 39,396 | 42,242 | 37,126 | 37,126 | 37,126 | ||||||||
67 | InteractiveBrokers - CHF | F | 6,611 | 7,609 | 8,608 | 9,608 | 6,544 | 7,543 | 542 | 1,536 | 1,536 | 1,536 | ||||||||
68 | Revolut - CHF | F | 932 | 932 | 932 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||
69 | PayPal - CHF | F | 0 | 4,280 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | ||||||||
70 | Stripe - CHF | F | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||
71 | Kraken CHF | F | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||
72 | Cash Bills - CHF | F | 600 | 350 | 410 | 410 | 100 | 40 | 40 | 150 | 150 | 150 | ||||||||
73 | PostFinance - USD | D | 201 | 654 | 984 | 1,413 | 1,725 | 1,949 | 2,369 | 31 | 31 | 31 | ||||||||
74 | PayPal - USD | D | 37 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | ||||||||
75 | InteractiveBrokers - USD | D | 50,701 | 48,816 | 50,829 | 49,559 | 51,994 | 49,064 | 75,247 | 125,364 | 125,364 | 125,364 | ||||||||
76 | Taxes | |||||||||||||||||||
77 | Exp Tax 2020 | F | 15,220 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | x | |||||||
78 | Exp Tax 2021 | F | -26,268 | -10,866 | -10,866 | -3,625 | -3,625 | -3,625 | -3,625 | -3,625 | -3,625 | -3,625 | ||||||||
79 | US With. Tax Credit 2021 | D | 3,318 | 3,318 | 3,318 | 2,818 | 2,818 | 2,818 | 2,818 | 2,818 | 2,818 | 2,818 | ||||||||
80 | Exp Income Tax 2022 | F | 0 | -930 | -1,845 | -3,143 | -4,457 | -5,691 | -7,973 | -9,455 | -10,589 | -10,589 | ||||||||
81 | Exp Pillar 1 GaU 2022 | F | 0 | -334 | -622 | -944 | -1,207 | -1,574 | -2,196 | -1,397 | -339 | -339 | ||||||||
82 | Exp Wealth Tax 2022 | F | 0 | -177 | -348 | -535 | -714 | -905 | -1,029 | -1,227 | -1,410 | -1,410 | ||||||||
83 | Tax Paid 2022 | F | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||
84 | US With. Tax Credit 2022 | D | 0 | 0 | 11 | 465 | 543 | 554 | 1,539 | 1,619 | 1,698 | 1,698 | ||||||||
85 | Other | |||||||||||||||||||
86 | Cembra Cumulus Mastercard | F | -4,222 | -1,561 | -1,076 | -1,041 | -1,732 | -1,732 | -1,692 | 0 | 0 | |||||||||
87 | Cembra Certo Mastercard | F | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1,908 | -1,908 | -1,908 | ||||||||
88 | Finpension Referral Credits | F | 467 | 1,910 | 2,100 | 2,325 | 2,682 | 2,773 | 2,812 | 2,840 | 2,840 | 2,840 | ||||||||
89 | Red Credits | F | 3,268 | 1,364 | 1,869 | 1,796 | 1,525 | 2,291 | 1,106 | 766 | 766 | 766 | ||||||||
90 | Other - CHF | F | -1,073 | 1,058 | 1,058 | 1,098 | 70 | 1,058 | 1,058 | 0 | 9,454 | 9,454 | ||||||||
91 | Purple Credits | D | 551 | 410 | 521 | 373 | 283 | 473 | 623 | 361 | 361 | 361 | ||||||||
92 | Other - USD | D | 0 | 0 | 183 | 440 | 0 | 406 | 615 | 1,062 | 1,062 | 1,062 | ||||||||
93 | Amazon Credits | E | 168 | 202 | 126 | 138 | 99 | 144 | 184 | 109 | 109 | 109 | ||||||||
94 | Other - EUR | E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -6,600 | -6,600 | -6,600 | ||||||||
95 | Extras | |||||||||||||||||||
96 | Pillar 1 Pension | F | 94,537 | 105344 | 105611 | 105880 | 106149 | 106419 | 106689 | 106960 | 107232 | 107,232 | ||||||||
97 | ||||||||||||||||||||
98 | NW (EUR) | E | 1,645,160 | 1,647,773 | 1,648,172 | 1,699,831 | 1,684,363 | 1,689,150 | 1,654,128 | 1,760,939 | 1,757,968 | 1,757,968 | 1814372 | |||||||
99 | NW Change | - | 2,613 | 399 | 51,659 | -15,467 | 4,787 | -35,022 | 106,810 | -2,971 | 112,808 | 14101 | 169212 | |||||||
100 | Change % | - | 0.16% | 0.02% | 3.13% | -0.91% | 0.28% | -2.07% | 6.46% | -0.17% | 6.86% | 0.83% | 9.99% |