Compound interest inquiry - spreadsheet.xlsx

	B	C	D	E
1
2	a	b	[1*(1 + a/100)^b]-1	[1*(1 + b/100)^a]-1
3	2	1	0.0200	0.0201
4	3	2	0.0609	0.0612
5	4	3	0.1249	0.1255
6	5	4	0.2155	0.2167
7	6	5	0.3382	0.3401
8	7	6	0.5007	0.5036
9	8	7	0.7138	0.7182
10	9	8	0.9926	0.9990
11	10	9	1.3579	1.3674
12	11	10	1.8394	1.8531
13	12	11	2.4785	2.4985
14	13	12	3.3345	3.3635
15	14	13	4.4924	4.5348
16	15	14	6.0757	6.1379
17	16	15	8.2655	8.3576
18	17	16	11.3303	11.4677
19	18	17	15.6722	15.8790
20	19	18	21.9005	22.2144
21	20	19	30.9480	31.4294
22	21	20	44.2593	45.0051
23	22	21	64.0963	65.2641
24	23	22	94.0413	95.8894
25	24	23	139.8312	142.7880
26	25	24	210.7582	215.5420
27	26	25	322.0454	329.8722
28	27	26	498.9157	511.8670
29	28	27	783.6377	805.3140
30	29	28	1247.8546	1284.5504
31	30	29	2014.3813	2077.2190
32	31	30	3296.1512	3404.9943
33	32	31	5466.5387	5657.2413
34	33	32	9187.6670	9525.6395
35	34	33	15646.9823	16252.8330
36	35	34	26998.0280	28096.5170
37	36	35	47190.2839	49204.7285
38	37	36	83547.8387	87283.9987
39	38	37	149803.9613	156811.8153
40	39	38	271994.9326	285287.5684
41	40	39	500025.9261	525522.3413
42	41	40	930602.1242	980051.7752
43	42	41	1753161.2866	1850131.0713
44	43	42	3342823.4771	3535075.4348
45	44	43	6450406.6239	6835740.7732
46	45	44	12594822.8634	13375564.2489
47	46	45	24881610.8178	26480616.1729
48	47	46	49727587.4359	53037642.7508
49	48	47	100531142.7455	107456344.8511
50	49	48	205561075.6984	220203416.2602
51	50	49	425080999.1427	456366145.3782
52	51	50	888888656.8237	956432249.3211
53	52	51	1879416281.9181	2026755027.7038
54	53	52	4017486281.0686	4342203379.0540
55	54	53	8681568659.5625	9404533636.6944
56	55	54	18963203305.7826	20589208234.3899
57	56	55	41865174860.1221	45559095943.5452
58	57	56	93407238965.4655	101883089541.0270
59	58	57	210597861276.2210	230239503327.4410
60	59	58	479770135351.4800	525736500891.4550
61	60	59	1104279415485.4900	1212906879183.6000
62	61	60	2567748959521.1500	2826955303644.4200
63	62	61	6031368828061.8600	6655862077976.3700
64	63	62	14309731107045.8000	15828724352367.2000
65	64	63	34289600636000.0000	38019524578311.7000
66	65	64	82979808778289.2000	92225309870587.3000
67	66	65	202780281965054.0000	225912529398894.0000
68	67	66	500365198275405.0000	558781344982905.0000
69	68	67	1246584939309200.0000	1395468501470280.0000
70	69	68	3135421367873360.0000	3518361332706290.0000
71	70	69	7961145753492640.0000	8955076968783090.0000
72	71	70	20404583176045900.0000	23007711227593700.0000
73	72	71	52786118750253800.0000	59665041665076000.0000
74	73	72	137822278439470000.0000	156162453710751000.0000
75	74	73	363157589393941000.0000	412488297141488000.0000
76	75	74	965640790245869000.0000	1099495917649100000.0000
77	76	75	2590896629665060000.0000	2957274920127970000.0000
78	77	76	7014040084460050000.0000	8025561400050490000.0000
79	78	77	19157559266735200000.0000	21974286180604900000.0000
80	79	78	52788146880721800000.0000	60698810780723800000.0000
81	80	79	146733035897880000000.0000	169138501420521000000.0000
82	81	80	411420558627114000000.0000	475415036309131000000.0000
83	82	81	1163542970651730000000.0000	1347854892118290000000.0000
84	83	82	3318863247936970000000.0000	3854119735986780000000.0000
85	84	83	9547272309559640000000.0000	11114541131016100000000.0000
86	85	84	27696518813831400000000.0000	32323245131245100000000.0000
87	86	85	81021496127904600000000.0000	94791335640337900000000.0000
88	87	86	238989137628049000000000.0000	280301968004099000000000.0000
89	88	87	710776214248035000000000.0000	835721115371525000000000.0000
90	89	88	2131271449838510000000000.0000	2512167451638250000000000.0000
91	90	89	6442738209022830000000000.0000	7613114745968130000000000.0000
92	91	90	19633740757144800000000000.0000	23258284934572400000000000.0000
93	92	91	60313122347120800000000000.0000	71625849656140000000000000.0000
94	93	92	186755081998862000000000000.0000	222338294220426000000000000.0000
95	94	93	582855479266926000000000000.0000	695644004937561000000000000.0000
96	95	94	1833384131490860000000000000.0000	2193634881769000000000000000.0000
97	96	95	5812015701041480000000000000.0000	6971443159993980000000000000.0000
98	97	96	18567682938858200000000000000.0000	22327439517121000000000000000.0000
99	98	97	59775532737583100000000000000.0000	72059320717414700000000000000.0000
100	99	98	193910572313322000000000000000.0000	234343998544421000000000000000.0000