投資信託シミュレーション


1		積立金	想定利回り	信託報酬率		お金の単位はすべて万円
2		39.6	4.00%	1.00%
3	年度	積立金＋前期末残高	運用益	信託報酬	今期末残高	累積利益	累積信託報酬
4	1	39.6	1.584	0.41184	40.77216	1.584	0.41184
5	2	80.37216	3.2148864	0.835870464	82.75117594	4.7988864	1.247710464
6	3	122.3511759	4.894047037	1.27245223	125.9727707	9.692933437	2.520162694
7	4	165.5727707	6.62291083	1.721956816	170.4737248	16.31584427	4.242119509
8	5	210.0737248	8.40294899	2.184766737	216.291907	24.71879326	6.426886247
9	6	255.891907	10.23567628	2.661275833	263.4663075	34.95446954	9.08816208
10	7	303.0663075	12.1226523	3.151889598	312.0370702	47.07712184	12.24005168
11	8	351.6370702	14.06548281	3.65702553	362.0455274	61.14260464	15.89707721
12	9	401.6455274	16.0658211	4.177113485	413.534235	77.20842574	20.07419069
13	10	453.134235	18.1253694	4.712596044	466.5470084	95.33379514	24.78678674
14	11	506.1470084	20.24588034	5.263928887	521.1289599	115.5796755	30.05071562
15	12	560.7289599	22.42915839	5.831581182	577.3265371	138.0088339	35.88229681
16	13	616.9265371	24.67706148	6.416035985	635.1875626	162.6858954	42.29833279
17	14	674.7875626	26.9915025	7.017790651	694.7612744	189.6773979	49.31612344
18	15	734.3612744	29.37445098	7.637357254	756.0983681	219.0518488	56.9534807
19	16	795.6983681	31.82793473	8.275263029	819.2510398	250.8797836	65.22874373
20	17	858.8510398	34.35404159	8.932050814	884.2730306	285.2338252	74.16079454
21	18	923.8730306	36.95492122	9.608279518	951.2196723	322.1887464	83.76907406
22	19	990.8196723	39.63278689	10.30452459	1020.147935	361.8215333	94.07359865
23	20	1059.747935	42.38991738	11.02137852	1091.116473	404.2114507	105.0949772
24	21	1130.716473	45.22865894	11.75945132	1164.185681	449.4401096	116.8544285
25	22	1203.785681	48.15142724	12.51937108	1239.417737	497.5915368	129.3737996
26	23	1279.017737	51.16070949	13.30178447	1316.876662	548.7522463	142.675584
27	24	1356.476662	54.25906649	14.10735729	1396.628371	603.0113128	156.7829413
28	25	1436.228371	57.44913486	14.93677506	1478.740731	660.4604477	171.7197164
29	26	1518.340731	60.73362925	15.79074361	1563.283617	721.1940769	187.51046
30	27	1602.883617	64.11534468	16.66998962	1650.328972	785.3094216	204.1804496
31	28	1689.928972	67.59715888	17.57526131	1739.95087	852.9065805	221.7557109
32	29	1779.55087	71.18203478	18.50732904	1832.225575	924.0886153	240.26304
33	30	1871.825575	74.87302301	19.46698598	1927.231612	998.9616383	259.730026
34	31	1966.831612	78.67326449	20.45504877	2025.049828	1077.634903	280.1850747
35	32	2064.649828	82.58599312	21.47235821	2125.763463	1160.220896	301.6574329
36	33	2165.363463	86.61453852	22.51978001	2229.458221	1246.835434	324.1772129
37	34	2269.058221	90.76232886	23.5982055	2336.222345	1337.597763	347.7754185
38	35	2375.822345	95.03289379	24.70855239	2446.146686	1432.630657	372.4839708
39	36	2485.746686	99.42986745	25.85176554	2559.324788	1532.060525	398.3357364
40	37	2598.924788	103.9569915	27.0288178	2675.852962	1636.017516	425.3645542
41	38	2715.452962	108.6181185	28.2407108	2795.83037	1744.635635	453.605265
42	39	2835.43037	113.4172148	29.48847584	2919.359108	1858.052849	483.0937408
43	40	2958.959108	118.3583643	30.77317473	3046.544298	1976.411214	513.8669155


1		積立金	想定利回り	信託報酬率		お金の単位はすべて万円
2		39.6	4.00%	0.10%
3	年度	積立金＋前期末残高	運用益	信託報酬	今期末残高	累積利益	累積信託報酬
4	1	39.6	1.584	0.041184	41.142816	1.584	0.041184
5	2	80.742816	3.22971264	0.08397252864	83.88855611	4.81371264	0.1251565286
6	3	123.4885561	4.939542244	0.1284280984	128.2996703	9.753254884	0.253584627
7	4	167.8996703	6.71598681	0.1746156571	174.4410414	16.46924169	0.4282002841
8	5	214.0410414	8.561641656	0.2226026831	222.3800804	25.03088335	0.6508029671
9	6	261.9800804	10.47920322	0.2724592836	272.1868243	35.51008657	0.9232622507
10	7	311.7868243	12.47147297	0.3242582973	323.934039	47.98155954	1.247520548
11	8	363.534039	14.54136156	0.3780754006	377.6973252	62.5229211	1.625595949
12	9	417.2973252	16.69189301	0.4339892182	433.5552289	79.2148141	2.059585167
13	10	473.1552289	18.92620916	0.4920814381	491.5893567	98.14102326	2.551666605
14	11	531.1893567	21.24757427	0.5524369309	551.884494	119.3885975	3.104103536
15	12	591.484494	23.65937976	0.6151438738	614.5287299	143.0479773	3.719247409
16	13	654.1287299	26.1651492	0.6802938791	679.6135852	169.2131265	4.399541289
17	14	719.2135852	28.76854341	0.7479821286	747.2341465	197.9816699	5.147523417
18	15	786.8341465	31.47336586	0.8183075123	817.4892048	229.4550358	5.96583093
19	16	857.0892048	34.28356819	0.891372773	890.4814002	263.7386039	6.857203703
20	17	930.0814002	37.20325601	0.9672846563	966.3173716	300.94186	7.824488359
21	18	1005.917372	40.23669486	1.046154066	1045.107912	341.1785548	8.870642425
22	19	1084.707912	43.3883165	1.128096229	1126.968133	384.5668713	9.998738654
23	20	1166.568133	46.66272531	1.213230858	1212.017627	431.2295966	11.21196951
24	21	1251.617627	50.06470508	1.301682332	1300.38065	481.2943017	12.51365184
25	22	1339.98065	53.59922599	1.393579876	1392.186296	534.8935277	13.90723172
26	23	1431.786296	57.27145184	1.489057748	1487.56869	592.1649795	15.39628947
27	24	1527.16869	61.0867476	1.588255438	1586.667182	653.2517271	16.98454491
28	25	1626.267182	65.05068729	1.69131787	1689.626552	718.3024144	18.67586278
29	26	1729.226552	69.16906207	1.798395614	1796.597218	787.4714765	20.47425839
30	27	1836.197218	73.44788872	1.909645107	1907.735462	860.9193652	22.3839035
31	28	1947.335462	77.89341847	2.02522888	2023.203651	938.8127837	24.40913238
32	29	2062.803651	82.51214605	2.145315797	2143.170482	1021.32493	26.55444817
33	30	2182.770482	87.31081926	2.270081301	2267.81122	1108.635749	28.82452947
34	31	2307.41122	92.29644878	2.399707668	2397.307961	1200.932198	31.22423714
35	32	2436.907961	97.47631843	2.534384279	2531.849895	1298.408516	33.75862142
36	33	2571.449895	102.8579958	2.674307891	2671.633583	1401.266512	36.43292931
37	34	2711.233583	108.4493433	2.819682926	2816.863243	1509.715855	39.25261224
38	35	2856.463243	114.2585297	2.970721773	2967.751051	1623.974385	42.22333401
39	36	3007.351051	120.294042	3.127645093	3124.517448	1744.268427	45.3509791
40	37	3164.117448	126.5646979	3.290682146	3287.391464	1870.833125	48.64166125
41	38	3326.991464	133.0796585	3.460071122	3456.611051	2003.912784	52.10173237
42	39	3496.211051	139.848442	3.636059493	3632.423434	2143.761226	55.73779187
43	40	3672.023434	146.8809373	3.818904371	3815.085467	2290.642163	59.55669624