A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | S | T | U | V | W | X | Y | Z | AA | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 金融所得課税シミュレーションシート | |||||||||||||||||||||||
2 | ||||||||||||||||||||||||
3 | 毎月の積立額 | 50,000 | 円 | |||||||||||||||||||||
4 | リターン(年率) | 5 | % | |||||||||||||||||||||
5 | 現在の年齢 | 37 | 歳 | |||||||||||||||||||||
6 | 手取り目標額 | 20,000,000 | 円 | |||||||||||||||||||||
7 | 現在(20.315%) | 5%増税された場合(25%) | 10%増税された場合(30%) | |||||||||||||||||||||
8 | 年齢 | 投資 期間 | 投資元本 | 特定口座 評価額 | 株式等譲渡所得 | 所得税:15% 住民税:5% 復興特別所得税:0.315% 【A】 | 手取り額 | 5%増税 ※25% 【B】 | 【B-A】 増えた税負担 =減る手取り額 | 【5%増税】 手取り額 | 10%増税 ※30% 【C】 | 【C-A】 増えた税負担 =減る手取り額 | 【10%増税】 手取り額 | |||||||||||
9 | 38歳 | 1年後 | ¥600,000 | ¥613,943 | ¥13,943 | ¥2,832 | ¥611,110 | ¥3,486 | ¥653 | ¥610,457 | ¥4,183 | ¥1,350 | ¥609,760 | |||||||||||
10 | 39歳 | 2年後 | ¥1,200,000 | ¥1,259,296 | ¥59,296 | ¥12,046 | ¥1,247,250 | ¥14,824 | ¥2,778 | ¥1,244,472 | ¥17,789 | ¥5,743 | ¥1,241,507 | |||||||||||
11 | 40歳 | 3年後 | ¥1,800,000 | ¥1,937,667 | ¥137,667 | ¥27,967 | ¥1,909,700 | ¥34,417 | ¥6,450 | ¥1,903,250 | ¥41,300 | ¥13,333 | ¥1,896,367 | |||||||||||
12 | 41歳 | 4年後 | ¥2,400,000 | ¥2,650,744 | ¥250,744 | ¥50,939 | ¥2,599,806 | ¥62,686 | ¥11,747 | ¥2,588,058 | ¥75,223 | ¥24,285 | ¥2,575,521 | |||||||||||
13 | 42歳 | 5年後 | ¥3,000,000 | ¥3,400,304 | ¥400,304 | ¥81,322 | ¥3,318,982 | ¥100,076 | ¥18,754 | ¥3,300,228 | ¥120,091 | ¥38,769 | ¥3,280,213 | |||||||||||
14 | 43歳 | 6年後 | ¥3,600,000 | ¥4,188,213 | ¥588,213 | ¥119,495 | ¥4,068,717 | ¥147,053 | ¥27,558 | ¥4,041,160 | ¥176,464 | ¥56,968 | ¥4,011,749 | |||||||||||
15 | 44歳 | 7年後 | ¥4,200,000 | ¥5,016,433 | ¥816,433 | ¥165,858 | ¥4,850,574 | ¥204,108 | ¥38,250 | ¥4,812,324 | ¥244,930 | ¥79,071 | ¥4,771,503 | |||||||||||
16 | 45歳 | 8年後 | ¥4,800,000 | ¥5,887,026 | ¥1,087,026 | ¥220,829 | ¥5,666,196 | ¥271,756 | ¥50,927 | ¥5,615,269 | ¥326,108 | ¥105,278 | ¥5,560,918 | |||||||||||
17 | 46歳 | 9年後 | ¥5,400,000 | ¥6,802,160 | ¥1,402,160 | ¥284,849 | ¥6,517,311 | ¥350,540 | ¥65,691 | ¥6,451,620 | ¥420,648 | ¥135,799 | ¥6,381,512 | |||||||||||
18 | 47歳 | 10年後 | ¥6,000,000 | ¥7,764,114 | ¥1,764,114 | ¥358,380 | ¥7,405,734 | ¥441,028 | ¥82,649 | ¥7,323,085 | ¥529,234 | ¥170,854 | ¥7,234,880 | |||||||||||
19 | 48歳 | 11年後 | ¥6,600,000 | ¥8,775,284 | ¥2,175,284 | ¥441,909 | ¥8,333,375 | ¥543,821 | ¥101,912 | ¥8,231,463 | ¥652,585 | ¥210,676 | ¥8,122,698 | |||||||||||
20 | 49歳 | 12年後 | ¥7,200,000 | ¥9,838,186 | ¥2,638,186 | ¥535,948 | ¥9,302,239 | ¥659,547 | ¥123,599 | ¥9,178,640 | ¥791,456 | ¥255,508 | ¥9,046,731 | |||||||||||
21 | 50歳 | 13年後 | ¥7,800,000 | ¥10,955,470 | ¥3,155,470 | ¥641,034 | ¥10,314,436 | ¥788,867 | ¥147,834 | ¥10,166,602 | ¥946,641 | ¥305,607 | ¥10,008,829 | |||||||||||
22 | 51歳 | 14年後 | ¥8,400,000 | ¥12,129,915 | ¥3,729,915 | ¥757,732 | ¥11,372,183 | ¥932,479 | ¥174,747 | ¥11,197,436 | ¥1,118,974 | ¥361,242 | ¥11,010,940 | |||||||||||
23 | 52歳 | 15年後 | ¥9,000,000 | ¥13,364,447 | ¥4,364,447 | ¥886,637 | ¥12,477,810 | ¥1,091,112 | ¥204,474 | ¥12,273,335 | ¥1,309,334 | ¥422,697 | ¥12,055,113 | |||||||||||
24 | 53歳 | 16年後 | ¥9,600,000 | ¥14,662,140 | ¥5,062,140 | ¥1,028,374 | ¥13,633,767 | ¥1,265,535 | ¥237,161 | ¥13,396,605 | ¥1,518,642 | ¥490,268 | ¥13,143,498 | |||||||||||
25 | 54歳 | 17年後 | ¥10,200,000 | ¥16,026,226 | ¥5,826,226 | ¥1,183,598 | ¥14,842,628 | ¥1,456,557 | ¥272,959 | ¥14,569,670 | ¥1,747,868 | ¥564,270 | ¥14,278,358 | |||||||||||
26 | 55歳 | 18年後 | ¥10,800,000 | ¥17,460,101 | ¥6,660,101 | ¥1,353,000 | ¥16,107,102 | ¥1,665,025 | ¥312,026 | ¥15,795,076 | ¥1,998,030 | ¥645,031 | ¥15,462,071 | |||||||||||
27 | 56歳 | 19年後 | ¥11,400,000 | ¥18,967,336 | ¥7,567,336 | ¥1,537,304 | ¥17,430,031 | ¥1,891,834 | ¥354,530 | ¥17,075,502 | ¥2,270,201 | ¥732,896 | ¥16,697,135 | |||||||||||
28 | 57歳 | 20年後 | ¥12,000,000 | ¥20,551,683 | ¥8,551,683 | ¥1,737,274 | ¥18,814,409 | ¥2,137,921 | ¥400,646 | ¥18,413,763 | ¥2,565,505 | ¥828,231 | ¥17,986,178 | |||||||||||
29 | 58歳 | 21年後 | ¥12,600,000 | ¥22,217,089 | ¥9,617,089 | ¥1,953,712 | ¥20,263,378 | ¥2,404,272 | ¥450,561 | ¥19,812,817 | ¥2,885,127 | ¥931,415 | ¥19,331,963 | |||||||||||
30 | 59歳 | 22年後 | ¥13,200,000 | ¥23,967,701 | ¥10,767,701 | ¥2,187,458 | ¥21,780,242 | ¥2,691,925 | ¥504,467 | ¥21,275,775 | ¥3,230,310 | ¥1,042,852 | ¥20,737,390 | |||||||||||
31 | 60歳 | 23年後 | ¥13,800,000 | ¥25,807,876 | ¥12,007,876 | ¥2,439,400 | ¥23,368,476 | ¥3,001,969 | ¥562,569 | ¥22,805,907 | ¥3,602,363 | ¥1,162,963 | ¥22,205,513 | |||||||||||
32 | 61歳 | 24年後 | ¥14,400,000 | ¥27,742,199 | ¥13,342,199 | ¥2,710,468 | ¥25,031,731 | ¥3,335,550 | ¥625,082 | ¥24,406,649 | ¥4,002,660 | ¥1,292,192 | ¥23,739,539 | |||||||||||
33 | 62歳 | 25年後 | ¥15,000,000 | ¥29,775,485 | ¥14,775,485 | ¥3,001,640 | ¥26,773,846 | ¥3,693,871 | ¥692,231 | ¥26,081,614 | ¥4,432,646 | ¥1,431,006 | ¥25,342,840 | |||||||||||
34 | 63歳 | 26年後 | ¥15,600,000 | ¥31,912,799 | ¥16,312,799 | ¥3,313,945 | ¥28,598,854 | ¥4,078,200 | ¥764,255 | ¥27,834,599 | ¥4,893,840 | ¥1,579,895 | ¥27,018,959 | |||||||||||
35 | 64歳 | 27年後 | ¥16,200,000 | ¥34,159,461 | ¥17,959,461 | ¥3,648,464 | ¥30,510,996 | ¥4,489,865 | ¥841,401 | ¥29,669,595 | ¥5,387,838 | ¥1,739,374 | ¥28,771,622 | |||||||||||
36 | 65歳 | 28年後 | ¥16,800,000 | ¥36,521,066 | ¥19,721,066 | ¥4,006,335 | ¥32,514,732 | ¥4,930,267 | ¥923,932 | ¥31,590,800 | ¥5,916,320 | ¥1,909,985 | ¥30,604,746 | |||||||||||
37 | 66歳 | 29年後 | ¥17,400,000 | ¥39,003,496 | ¥21,603,496 | ¥4,388,750 | ¥34,614,746 | ¥5,400,874 | ¥1,012,124 | ¥33,602,622 | ¥6,481,049 | ¥2,092,299 | ¥32,522,447 | |||||||||||
38 | 67歳 | 30年後 | ¥18,000,000 | ¥41,612,932 | ¥23,612,932 | ¥4,796,967 | ¥36,815,965 | ¥5,903,233 | ¥1,106,266 | ¥35,709,699 | ¥7,083,880 | ¥2,286,912 | ¥34,529,052 | |||||||||||
39 | 68歳 | 31年後 | ¥18,600,000 | ¥44,355,871 | ¥25,755,871 | ¥5,232,305 | ¥39,123,566 | ¥6,438,968 | ¥1,206,663 | ¥37,916,903 | ¥7,726,761 | ¥2,494,456 | ¥36,629,110 | |||||||||||
40 | 69歳 | 32年後 | ¥19,200,000 | ¥47,239,144 | ¥28,039,144 | ¥5,696,152 | ¥41,542,992 | ¥7,009,786 | ¥1,313,634 | ¥40,229,358 | ¥8,411,743 | ¥2,715,591 | ¥38,827,401 | |||||||||||
41 | 70歳 | 33年後 | ¥19,800,000 | ¥50,269,931 | ¥30,469,931 | ¥6,189,967 | ¥44,079,965 | ¥7,617,483 | ¥1,427,516 | ¥42,652,449 | ¥9,140,979 | ¥2,951,013 | ¥41,128,952 | |||||||||||
42 | 71歳 | 34年後 | ¥20,400,000 | ¥53,455,779 | ¥33,055,779 | ¥6,715,282 | ¥46,740,498 | ¥8,263,945 | ¥1,548,663 | ¥45,191,835 | ¥9,916,734 | ¥3,201,452 | ¥43,539,046 | |||||||||||
43 | 72歳 | 35年後 | ¥21,000,000 | ¥56,804,621 | ¥35,804,621 | ¥7,273,709 | ¥49,530,912 | ¥8,951,155 | ¥1,677,447 | ¥47,853,466 | ¥10,741,386 | ¥3,467,678 | ¥46,063,235 | |||||||||||
44 | 73歳 | 36年後 | ¥21,600,000 | ¥60,324,796 | ¥38,724,796 | ¥7,866,942 | ¥52,457,854 | ¥9,681,199 | ¥1,814,257 | ¥50,643,597 | ¥11,617,439 | ¥3,750,497 | ¥48,707,357 | |||||||||||
45 | 74歳 | 37年後 | ¥22,200,000 | ¥64,025,070 | ¥41,825,070 | ¥8,496,763 | ¥55,528,307 | ¥10,456,268 | ¥1,959,505 | ¥53,568,803 | ¥12,547,521 | ¥4,050,758 | ¥51,477,549 | |||||||||||
46 | 75歳 | 38年後 | ¥22,800,000 | ¥67,914,657 | ¥45,114,657 | ¥9,165,043 | ¥58,749,614 | ¥11,278,664 | ¥2,113,622 | ¥56,635,993 | ¥13,534,397 | ¥4,369,355 | ¥54,380,260 | |||||||||||
47 | 76歳 | 39年後 | ¥23,400,000 | ¥72,003,243 | ¥48,603,243 | ¥9,873,749 | ¥62,129,494 | ¥12,150,811 | ¥2,277,062 | ¥59,852,432 | ¥14,580,973 | ¥4,707,224 | ¥57,422,270 | |||||||||||
48 | 77歳 | 40年後 | ¥24,000,000 | ¥76,301,008 | ¥52,301,008 | ¥10,624,950 | ¥65,676,058 | ¥13,075,252 | ¥2,450,302 | ¥63,225,756 | ¥15,690,302 | ¥5,065,353 | ¥60,610,705 | |||||||||||
49 | 78歳 | 41年後 | ¥24,600,000 | ¥80,818,655 | ¥56,218,655 | ¥11,420,820 | ¥69,397,835 | ¥14,054,664 | ¥2,633,844 | ¥66,763,991 | ¥16,865,596 | ¥5,444,777 | ¥63,953,058 | |||||||||||
50 | 79歳 | 42年後 | ¥25,200,000 | ¥85,567,434 | ¥60,367,434 | ¥12,263,644 | ¥73,303,789 | ¥15,091,858 | ¥2,828,214 | ¥70,475,575 | ¥18,110,230 | ¥5,846,586 | ¥67,457,203 | |||||||||||
51 | 80歳 | 43年後 | ¥25,800,000 | ¥90,559,169 | ¥64,759,169 | ¥13,155,825 | ¥77,403,343 | ¥16,189,792 | ¥3,033,967 | ¥74,369,376 | ¥19,427,751 | ¥6,271,925 | ¥71,131,418 | |||||||||||
52 | 81歳 | 44年後 | ¥26,400,000 | ¥95,806,290 | ¥69,406,290 | ¥14,099,888 | ¥81,706,402 | ¥17,351,573 | ¥3,251,685 | ¥78,454,718 | ¥20,821,887 | ¥6,721,999 | ¥74,984,403 | |||||||||||
53 | 82歳 | 45年後 | ¥27,000,000 | ¥101,321,865 | ¥74,321,865 | ¥15,098,487 | ¥86,223,378 | ¥18,580,466 | ¥3,481,979 | ¥82,741,399 | ¥22,296,559 | ¥7,198,073 | ¥79,025,305 | |||||||||||
54 | 83歳 | 46年後 | ¥27,600,000 | ¥107,119,626 | ¥79,519,626 | ¥16,154,412 | ¥90,965,214 | ¥19,879,907 | ¥3,725,494 | ¥87,239,720 | ¥23,855,888 | ¥7,701,476 | ¥83,263,738 | |||||||||||
55 | 84歳 | 47年後 | ¥28,200,000 | ¥113,214,013 | ¥85,014,013 | ¥17,270,597 | ¥95,943,416 | ¥21,253,503 | ¥3,982,906 | ¥91,960,509 | ¥25,504,204 | ¥8,233,607 | ¥87,709,809 | |||||||||||
56 | 85歳 | 48年後 | ¥28,800,000 | ¥119,620,199 | ¥90,820,199 | ¥18,450,123 | ¥101,170,076 | ¥22,705,050 | ¥4,254,926 | ¥96,915,149 | ¥27,246,060 | ¥8,795,936 | ¥92,374,139 | |||||||||||
57 | 86歳 | 49年後 | ¥29,400,000 | ¥126,354,138 | ¥96,954,138 | ¥19,696,233 | ¥106,657,905 | ¥24,238,535 | ¥4,542,301 | ¥102,115,604 | ¥29,086,241 | ¥9,390,008 | ¥97,267,897 | |||||||||||
58 | 87歳 | 50年後 | ¥30,000,000 | ¥133,432,599 | ¥103,432,599 | ¥21,012,332 | ¥112,420,266 | ¥25,858,150 | ¥4,845,817 | ¥107,574,449 | ¥31,029,780 | ¥10,017,447 | ¥102,402,819 | |||||||||||
59 | 88歳 | 51年後 | ¥30,600,000 | ¥140,873,206 | ¥110,273,206 | ¥22,402,002 | ¥118,471,204 | ¥27,568,302 | ¥5,166,300 | ¥113,304,905 | ¥33,081,962 | ¥10,679,960 | ¥107,791,244 | |||||||||||
60 | 89歳 | 52年後 | ¥31,200,000 | ¥148,694,490 | ¥117,494,490 | ¥23,869,006 | ¥124,825,484 | ¥29,373,622 | ¥5,504,617 | ¥119,320,867 | ¥35,248,347 | ¥11,379,341 | ¥113,446,143 | |||||||||||
61 | 90歳 | 53年後 | ¥31,800,000 | ¥156,915,925 | ¥125,115,925 | ¥25,417,300 | ¥131,498,625 | ¥31,278,981 | ¥5,861,681 | ¥125,636,944 | ¥37,534,777 | ¥12,117,477 | ¥119,381,147 | |||||||||||
62 | 91歳 | 54年後 | ¥32,400,000 | ¥165,557,984 | ¥133,157,984 | ¥27,051,044 | ¥138,506,940 | ¥33,289,496 | ¥6,238,452 | ¥132,268,488 | ¥39,947,395 | ¥12,896,351 | ¥125,610,589 | |||||||||||
63 | 92歳 | 55年後 | ¥33,000,000 | ¥174,642,187 | ¥141,642,187 | ¥28,774,610 | ¥145,867,577 | ¥35,410,547 | ¥6,635,936 | ¥139,231,641 | ¥42,492,656 | ¥13,718,046 | ¥132,149,531 | |||||||||||
64 | 93歳 | 56年後 | ¥33,600,000 | ¥184,191,156 | ¥150,591,156 | ¥30,592,593 | ¥153,598,563 | ¥37,647,789 | ¥7,055,196 | ¥146,543,367 | ¥45,177,347 | ¥14,584,753 | ¥139,013,809 | |||||||||||
65 | 94歳 | 57年後 | ¥34,200,000 | ¥194,228,668 | ¥160,028,668 | ¥32,509,824 | ¥161,718,844 | ¥40,007,167 | ¥7,497,343 | ¥154,221,501 | ¥48,008,600 | ¥15,498,776 | ¥146,220,068 | |||||||||||
66 | 95歳 | 58年後 | ¥34,800,000 | ¥204,779,718 | ¥169,979,718 | ¥34,531,380 | ¥170,248,338 | ¥42,494,929 | ¥7,963,550 | ¥162,284,788 | ¥50,993,915 | ¥16,462,536 | ¥153,785,803 | |||||||||||
67 | 96歳 | 59年後 | ¥35,400,000 | ¥215,870,580 | ¥180,470,580 | ¥36,662,598 | ¥179,207,981 | ¥45,117,645 | ¥8,455,047 | ¥170,752,935 | ¥54,141,174 | ¥17,478,576 | ¥161,729,406 | |||||||||||
68 | 97歳 | 60年後 | ¥36,000,000 | ¥227,528,871 | ¥191,528,871 | ¥38,909,090 | ¥188,619,781 | ¥47,882,218 | ¥8,973,128 | ¥179,646,653 | ¥57,458,661 | ¥18,549,571 | ¥170,070,210 | |||||||||||
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 |