A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Asset/Liability | Cur | 2022 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 2023 | Expenses | AVG | Cast | |
2 | Net Worth | |||||||||||||||||||
3 | Stocks / ETF | Guide | ||||||||||||||||||
4 | VT | D | 211,166 | 227,311 | 220,084 | 234,830 | 247,510 | 244,516 | 256,997 | 266,564 | 263,871 | 186,360 | 180,920 | 197,220 | 196,900 | 196,900 | ||||
5 | VYM | D | 70,337 | 72,001 | 69,472 | 68,575 | 69,446 | 65,884 | 68,946 | 71,715 | 86,152 | 98,154 | 95,428 | 101,403 | 101,641 | 101,641 | ||||
6 | VYMI | D | 232,323 | 250,770 | 254,856 | 253,995 | 262,933 | 253,441 | 262,280 | 273,734 | 271,975 | 266,127 | 258,129 | 276,146 | 276,103 | 276,103 | ||||
7 | ERUS | D | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | ||||
8 | VTV | D | 154,407 | 158,708 | 153,571 | 151,921 | 154,616 | 148,247 | 156,310 | 161,711 | 157,861 | 151,723 | 147,719 | 157,586 | 157,586 | 157,586 | ||||
9 | VSS | D | 51,405 | 55,910 | 54,150 | 54,620 | 55,480 | 53,540 | 66,288 | 69,558 | 66,894 | 63,720 | 60,594 | 66,270 | 66,354 | 66,354 | ||||
10 | VBR | D | 63,520 | 69,284 | 67,720 | 63,504 | 62,896 | 60,744 | 66,160 | 69,756 | 67,380 | 63,796 | 60,708 | 65,964 | 67,244 | 67,244 | ||||
11 | SONY | D | 7,628 | 8,946 | 8,358 | 9,065 | 8,967 | 9,370 | 9,004 | 9,360 | 8,319 | 8,241 | 8,305 | 8,595 | 8,840 | 8,840 | ||||
12 | INTEL | D | 13,215 | 14,130 | 12,465 | 16,335 | 15,530 | 15,720 | 16,720 | 17,885 | 17,570 | 17,775 | 18,250 | 22,365 | 20,635 | 20,635 | ||||
13 | CHEK | D | 2,200 | 3,050 | 3,300 | 1,430 | 1,360 | 1,500 | 2,860 | 3,490 | 2,910 | 4,330 | 3,480 | 2,910 | 2,790 | 2,790 | ||||
14 | Call Options | D | 0 | 0 | 2,990 | 5,260 | 5,880 | 8,840 | 8,360 | 770 | 460 | 468 | 259 | 0 | 0 | 0 | ||||
15 | 2A-3A - 99% Stocks | |||||||||||||||||||
16 | 3A - Mr - FinPension - 1 - SC | F | 42,148 | 45,060 | 44,781 | 44,259 | 95,245 | 96,006 | 98,896 | 99,432 | 98,203 | 97,075 | 93,106 | 97,283 | 98,040 | 98,040 | 1.57% | |||
17 | 3A - Mr - FinPension - 2 - SC | F | 41,525 | 44,388 | 44,114 | 43,599 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
18 | 3A - Mr - FinPension - 3 - SC | F | 0 | 7,080 | 7,043 | 6,974 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
19 | 3A - Mrs - FinPension - SC | F | 27,507 | 29,233 | 29,052 | 28,713 | 28,800 | 29,030 | 29,904 | 30,066 | 29,694 | 29,353 | 28,153 | 29,416 | 29,645 | 29,645 | 1.41% | |||
20 | 2A - Mr Finpension 99% - SC | F | 133,367 | 142,049 | 141,029 | 139,272 | 139,402 | 140,851 | 144,227 | 145,849 | 144,149 | 142,870 | 136,888 | 142,936 | 144,104 | 144,104 | 1.45% | |||
21 | 2A - Mr Viac global 100 | F | 225,356 | 237,489 | 236,181 | 237,274 | 239,103 | 237,894 | 243,786 | 245,266 | 241,726 | 238,431 | 228,830 | 239,723 | 240,019 | 240,019 | 1.07% | |||
22 | Expected Taxes | F | -21,875 | -35,371 | -35,154 | -35,006 | -35,179 | -35,265 | -36,177 | -36,443 | -35,964 | -35,541 | -34,088 | -35,655 | -35,827 | -35,827 | ||||
23 | VBA - 80% Stocks | |||||||||||||||||||
24 | 2A - Mrs Viac Sust80 (80%) | F | 3,818 | 3,987 | 3,974 | 3,985 | 4,008 | 3,995 | 4,054 | 4,115 | 4,057 | 4,024 | 3,873 | 4,053 | 4,049 | 4,049 | 1.55% | |||
25 | Expected Taxes | F | -8,917 | -279 | -278 | -279 | -281 | -280 | -284 | -288 | -284 | -282 | -271 | -284 | -283 | -283 | ||||
26 | Bonds | |||||||||||||||||||
27 | 2A - Mr - Extra Mand | F | 3,876 | 5,815 | 7,753 | 9,691 | 11,629 | 13,567 | 15,410 | 15,549 | 15,687 | 15,825 | 15,963 | 16,101 | 16,240 | 16,240 | ||||
28 | 2A - Mr - Mand | F | 8,165 | 8,927 | 9,689 | 10,451 | 11,212 | 11,974 | 12,891 | 13,653 | 14,415 | 15,177 | 15,939 | 16,700 | 17,462 | 17,462 | ||||
29 | Exp Taxes on 2A | F | -783 | -1,032 | -1,221 | -1,410 | -1,599 | -1,788 | -1,981 | -2,044 | -2,107 | -2,170 | -2,233 | -2,296 | -2,359 | -2,359 | ||||
30 | Deposits | F | 5,002 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 4,700 | 4,700 | 4,700 | 4,700 | 4,700 | ||||
31 | Buoni Postali ITA | E | 16,554 | 16,689 | 16,689 | 16,824 | 16,824 | 16,959 | 16,959 | 17,094 | 17,094 | 17,228 | 17,228 | 0 | 0 | 0 | ||||
32 | BSV | D | 75,280 | 76,210 | 75,170 | 76,490 | 76,640 | 76,140 | 75,570 | 75,680 | 75,670 | 0 | 0 | 0 | 0 | 0 | ||||
33 | VEMT | E | 44,721 | 45,202 | 45,155 | 44,204 | 43,769 | 44,556 | 44,133 | 44,180 | 44,051 | 43,734 | 42,970 | 43,628 | 44,791 | 44,791 | ||||
34 | GHYC | F | 44,786 | 45,893 | 45,472 | 45,454 | 44,681 | 44,465 | 44,564 | 44,997 | 45,083 | 43,218 | 41,928 | 43,410 | 43,752 | 43,752 | ||||
35 | AGGS | F | 45,250 | 45,795 | 45,028 | 45,855 | 45,947 | 45,500 | 45,350 | 45,250 | 44,946 | 44,071 | 43,689 | 44,102 | 44,102 | 44,102 | ||||
36 | BNDW | D | 0 | 0 | 0 | 0 | 0 | 6,868 | 6,840 | 6,817 | 13,578 | 59,670 | 59,058 | 61,227 | 61,992 | 61,992 | ||||
37 | SEGA (EUNH) | E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 54,610 | 54,870 | 56,430 | 57,574 | 57,574 | ||||
38 | IEBB (ISO6) | E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 27,512 | 27,526 | 28,238 | 28,238 | 28,238 | ||||
39 | CEBE | E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10,020 | 10,060 | 10,180 | 10,240 | 10,240 | ||||
40 | Crypto | |||||||||||||||||||
41 | PolkaDot Staking | D | 6,262 | 9,189 | 9,377 | 9,382 | 8,826 | 7,944 | 7,748 | 7,806 | 6,615 | 6,305 | 6,941 | 8,553 | 9,528 | 9,528 | ||||
42 | BTC | D | 54 | 75 | 75 | 92 | 95 | 88 | 99 | 95 | 84 | 88 | 112 | 122 | 142 | 142 | ||||
43 | Private Equity | |||||||||||||||||||
44 | Roam Research | D | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | 1,500 | ||||
45 | NFT Chain | F | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 500 | 50 | 5 | 1 | 0 | 0 | 0 | ||||
46 | Business | |||||||||||||||||||
47 | RIP GmbH Book Value | F | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24604 | 25709 | 25775 | 27860 | 27860 | 27,860 | ||||
48 | RIP UBS - CHF | F | 36,996 | 51,706 | 26,264 | 46,964 | 48,955 | 41,042 | 32,383 | 40,822 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
49 | RIP PayPal - CHF | F | 656 | 5,235 | 5,197 | 5,197 | 5,811 | 5,739 | 5,739 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
50 | RIP Credits | F | 19,572 | 3,000 | 16,000 | 0 | 0 | 300 | 10,900 | -4,222 | 0 | 6,103 | 5,949 | 12,431 | 2,203 | 2,203 | ||||
51 | RIP VAT debts/credits | F | -4,731 | -2,000 | -3,000 | -4,300 | -5,500 | -6,500 | -6,826 | -6,866 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
52 | RIP AHV debts/credits | F | -10,520 | -12,545 | -3,223 | -5,248 | -377 | 1,525 | 0 | -675 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
53 | RIP BVG debts/credits | F | 0 | -2,910 | -5,819 | -8,729 | -11,639 | -5,819 | -8,728 | -970 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
54 | RIP UVG debts/credits | F | -605 | 310 | 154 | 1,065 | 908 | 752 | 595 | 438 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
55 | RIP Familienzulage credits | F | 0 | 600 | 1,200 | 1,800 | 600 | 1,200 | 0 | 600 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
56 | RIP PayPal - EUR | E | 3,019 | 3,019 | 3,019 | 2,878 | 2,878 | 2,808 | 2,808 | 2,808 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
57 | Corporate Tax 2022 | F | -1,019 | -1,019 | -1,019 | -1,019 | -1,019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
58 | Total Business | 43,369 | 45,397 | 38,772 | 38,607 | 40,618 | 41,047 | 36,870 | 31,935 | 24,604 | 31,812 | 31,724 | 40,291 | 30,063 | 30,063 | |||||
59 | Expected Corp Tax 2023 | F | 0 | -4,328 | -3,019 | -2,987 | -3,384 | -3,468 | -2,644 | -1,669 | -221 | -1,645 | -1,627 | -3,319 | -1,299 | -1,299 | ||||
60 | Expected Dividend Tax | F | -2,337 | -2,107 | -1,575 | -1,562 | -1,723 | -1,758 | -1,423 | -1,027 | -438 | -1,017 | -1,010 | -1,697 | -876 | -876 | ||||
61 | Cash - Liquidity | |||||||||||||||||||
62 | BancoPosta Click | E | 3,006 | 2,780 | 2,653 | 4,736 | 4,682 | 2,828 | 2,594 | 4,309 | 2,952 | 2,750 | 2,415 | 3,960 | 3,814 | 3,814 | ||||
63 | PostFinance - EUR | E | 5,399 | 5,400 | 4,840 | 4,217 | 3,438 | 2,525 | 2,098 | 2,581 | 1,620 | 1,703 | 1,788 | 1,832 | 1,832 | 1,832 | ||||
64 | InteractiveBrokers - EUR | E | 1,084 | 1,084 | 1,084 | 93 | 93 | 93 | 93 | 4,950 | 4,950 | 40 | 40 | 23,122 | 23,122 | 23,122 | ||||
65 | Revolut - EUR | E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300 | 287 | 287 | 287 | ||||
66 | PayPal - EUR | E | 1,279 | 1,193 | 1,193 | 1,193 | 1,193 | 1,193 | 1,193 | 1,182 | 1,182 | 1,182 | 1,182 | 1,182 | 1,182 | 1,182 | ||||
67 | Kraken EUR | E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
68 | Cash Bills - EUR | E | 320 | 320 | 320 | 295 | 95 | 550 | 550 | 155 | 100 | 100 | 200 | 200 | 200 | 200 | ||||
69 | PostFinance - CHF | F | 68,689 | 69,711 | 74,479 | 72,339 | 77,212 | 83,277 | 89,304 | 80,944 | 72,333 | 78,946 | 25,388 | 18,829 | 15,080 | 15,080 | ||||
70 | InteractiveBrokers - CHF | F | 3,499 | 4,499 | 7,499 | 3,003 | 1,050 | 4,050 | 7,050 | 49 | 3,049 | 4,348 | 55,421 | 55,422 | 55,422 | 55,422 | ||||
71 | Revolut - CHF | F | 366 | 239 | 60 | 59 | 659 | 571 | 713 | 713 | 1,313 | 2,301 | 0 | 981 | 981 | 981 | ||||
72 | YuH - CHF | F | 100 | 150 | 150 | 150 | 150 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
73 | PayPal - CHF | F | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
74 | Cash Bills - CHF | F | 100 | 35 | 540 | 520 | 730 | 620 | 100 | 20 | 310 | 230 | 630 | 430 | 430 | 430 | ||||
75 | PostFinance - USD | D | 9,139 | 921 | 1,567 | 7,084 | 78 | 7,820 | 8,483 | 720 | 44 | 44 | 44 | 44 | 44 | 44 | ||||
76 | InteractiveBrokers - USD | D | 7,464 | 18,165 | 4,038 | 3,411 | 16,105 | 6,249 | 3,925 | 39,003 | 16,141 | 8,159 | 8,509 | 1,931 | 1,984 | 1,984 | ||||
77 | Taxes | |||||||||||||||||||
78 | Exp Tax 2021 | F | 8,163 | 6,755 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
79 | Exp Tax 2022 | F | -5,619 | -5,619 | 1,234 | 10,285 | 10,285 | 10,285 | 7,297 | 5,446 | 5,446 | 5,446 | 5,446 | 5,446 | 5,446 | 5,446 | ||||
80 | US With. Tax Credit 2022 | D | 3,691 | 3,691 | 3,691 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
81 | Exp Pillar 1 GaU 2022 | F | -663 | -663 | -663 | -663 | -663 | -663 | -663 | -663 | -663 | -663 | 0 | 0 | 0 | 0 | ||||
82 | Exp Income Tax 2023 | F | 0 | -1,700 | -3,378 | -5,611 | -7,966 | -9,911 | -12,843 | -14,189 | -15,288 | -16,377 | -16,949 | -17,485 | -18,449 | -18,449 | ||||
83 | Exp Pillar 1 GaU 2023 | F | 0 | -285 | -527 | -904 | -1,068 | -1,528 | -2,078 | -2,200 | -2,640 | -2,645 | -2,103 | -2,122 | -2,123 | -2,123 | ||||
84 | Exp Wealth Tax 2023 | F | 0 | -197 | -393 | -586 | -785 | -985 | -1,213 | -1,424 | -1,604 | -1,817 | -1,968 | -2,220 | -2,419 | -2,419 | ||||
85 | Tax Paid 2023 | F | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
86 | US With. Tax Credit 2023 | D | 0 | 0 | 19 | 621 | 642 | 663 | 2,063 | 2,087 | 2,115 | 3,082 | 3,102 | 3,123 | 3,133 | 3,133 | ||||
87 | Other | |||||||||||||||||||
88 | Cembra Certo Mastercard | F | -2,408 | -2,832 | -4,004 | -3,299 | -2,504 | -1,643 | -2,538 | -1,099 | -3,146 | -2,843 | -1,879 | -1,768 | -501 | -501 | ||||
89 | Finpension Referral Credits | F | 3,195 | 85 | 1,185 | 1,202 | 1,272 | 1,332 | 1,357 | 2,576 | 2,599 | 2,618 | 2,688 | 2,714 | 2,719 | 2,719 | ||||
90 | Red Credits | F | 1,404 | 2,966 | 1,698 | 3,780 | 2,781 | 2,103 | 1,979 | 2,055 | 1,093 | 0 | 0 | 0 | 0 | 0 | ||||
91 | Other - CHF | F | -1,242 | -230 | 370 | 1,085 | 40 | 1,120 | 1,120 | 5,328 | 10,809 | 1,130 | 2,075 | 2,060 | 10,515 | 10,515 | ||||
92 | Purple Credits | D | 708 | 665 | 615 | 817 | 746 | 667 | 646 | 624 | 431 | 0 | 0 | 0 | 0 | 0 | ||||
93 | Other - USD | D | 0 | 232 | 2,333 | 0 | 0 | 324 | 7,084 | 6,632 | 333 | 0 | 0 | 63 | 0 | 0 | ||||
94 | Amazon Credits | E | 70 | 94 | 91 | 134 | 176 | 92 | 89 | 123 | 166 | 131 | 70 | 92 | 100 | 100 | ||||
95 | Fantasia Credits | E | 0 | 0 | 0 | 0 | 24 | 59 | 59 | 65 | 65 | 70 | 78 | 82 | 82 | 82 | ||||
96 | Other - EUR | E | 1,000 | 1,000 | 0 | -720 | 0 | 0 | 0 | -3,410 | -1,050 | 0 | 0 | 0 | 0 | 0 | ||||
97 | Extras | |||||||||||||||||||
98 | Pillar 1 Pension | F | 108,327 | 130248 | 130579 | 130911 | 131243 | 131577 | 131911 | 132246 | 132583 | 132919 | 133257 | 133596 | 133936 | 133,936 | ||||
99 | Boardgames | F | 5,544 | 5544 | 5544 | 5544 | 6544 | 6789 | 6789 | 6789 | 6789 | 6789 | 7034 | 7189 | 7189 | 7,189 | ||||
100 |