Class 4 Story 1.xlsx

	A	B	C	D	E	F	G	H	I
1	Investment	after 6 % profit value	Profit amount	Brokerage plus charges Both Side	Remain Profit	Income Tax	Profit after tax	Dividend	Growth Amount after Tax and Dividend
2	3000.00	3180.00	180.00	23.42	156.58	24.43	132.16	66.08	66.08
3	3066.08	3250.04	183.96	23.58	160.39	25.02	135.37	67.68	67.68
4	3133.76	3321.79	188.03	23.75	164.28	25.63	138.65	69.33	69.33
5	3203.09	3395.27	192.19	23.92	168.27	26.25	142.02	71.01	71.01
6	3274.10	3470.54	196.45	24.09	172.35	26.89	145.47	72.73	72.73
7	3346.83	3547.64	200.81	24.27	176.54	27.54	149.00	74.50	74.50
8	3421.33	3626.61	205.28	24.46	180.82	28.21	152.61	76.31	76.31
9	3497.63	3707.49	209.86	24.65	185.21	28.89	156.32	78.16	78.16
10	3575.79	3790.34	214.55	24.84	189.71	29.59	160.11	80.06	80.06
11	3655.85	3875.20	219.35	25.04	194.31	30.31	164.00	82.00	82.00
12	3737.85	3962.12	224.27	25.24	199.03	31.05	167.98	83.99	83.99
13	3821.84	4051.15	229.31	25.45	203.86	31.80	172.06	86.03	86.03
14	3907.87	4142.34	234.47	25.66	208.81	32.57	176.24	88.12	88.12
15	3995.99	4235.75	239.76	25.88	213.88	33.37	180.52	90.26	90.26
16	4086.25	4331.42	245.17	26.10	219.07	34.18	184.90	92.45	92.45
17	4178.70	4429.42	250.72	26.33	224.39	35.01	189.39	94.69	94.69
18	4273.39	4529.79	256.40	26.56	229.84	35.85	193.98	96.99	96.99
19	4370.38	4632.61	262.22	26.80	235.42	36.73	198.69	99.35	99.35
20	4469.73	4737.91	268.18	27.05	241.13	37.62	203.52	101.76	101.76
21	4571.49	4845.78	274.29	27.30	246.99	38.53	208.46	104.23	104.23
22	4675.72	4956.26	280.54	27.56	252.98	39.47	213.52	106.76	106.76
23	4782.48	5069.43	286.95	27.82	259.13	40.42	218.70	109.35	109.35
24	4891.83	5185.34	293.51	28.09	265.42	41.41	224.01	112.01	112.01
25	5003.83	5304.06	300.23	28.37	271.86	42.41	229.45	114.73	114.73
26	5118.56	5425.67	307.11	28.65	278.46	43.44	235.02	117.51	117.51
27	5236.07	5550.23	314.16	28.94	285.22	44.49	240.73	120.36	120.36
28	5356.43	5677.82	321.39	29.24	292.14	45.57	246.57	123.29	123.29
29	5479.72	5808.50	328.78	29.55	299.24	46.68	252.56	126.28	126.28
30	5606.00	5942.36	336.36	29.86	306.50	47.81	258.69	129.34	129.34
31	5735.34	6079.46	344.12	30.18	313.94	48.98	264.97	132.48	132.48
32	5867.82	6219.89	352.07	30.51	321.56	50.16	271.40	135.70	135.70
33	6003.52	6363.74	360.21	30.84	329.37	51.38	277.99	138.99	138.99
34	6142.52	6511.07	368.55	31.18	337.37	52.63	284.74	142.37	142.37
35	6284.89	6661.98	377.09	31.54	345.56	53.91	291.65	145.83	145.83
36	6430.71	6816.56	385.84	31.90	353.95	55.22	298.73	149.37	149.37
37	6580.08	6974.88	394.80	32.27	362.54	56.56	305.98	152.99	152.99
38	6733.07	7137.05	403.98	32.64	371.34	57.93	313.41	156.71	156.71
39	6889.77	7303.16	413.39	33.03	380.35	59.34	321.02	160.51	160.51
40	7050.28	7473.30	423.02	33.43	389.59	60.78	328.81	164.41	164.41
41	7214.69	7647.57	432.88	33.83	399.05	62.25	336.80	168.40	168.40
42	7383.09	7826.07	442.99	34.25	408.73	63.76	344.97	172.49	172.49
43	7555.57	8008.91	453.33	34.68	418.66	65.31	353.35	176.67	176.67
44	7732.25	8196.18	463.93	35.11	428.82	66.90	361.92	180.96	180.96
45	7913.21	8388.00	474.79	35.56	439.23	68.52	370.71	185.36	185.36
46	8098.57	8584.48	485.91	36.02	449.89	70.18	379.71	189.86	189.86
47	8288.42	8785.73	497.31	36.49	460.82	71.89	388.93	194.46	194.46
48	8482.89	8991.86	508.97	36.97	472.00	73.63	398.37	199.19	199.19
49	8682.07	9203.00	520.92	37.46	483.46	75.42	408.04	204.02	204.02
50	8886.09	9419.26	533.17	37.97	495.20	77.25	417.95	208.97	208.97
51	9095.07	9640.77	545.70	38.48	507.22	79.13	428.09	214.05	214.05
52	9309.11	9867.66	558.55	39.01	519.53	81.05	438.49	219.24	219.24
53	9528.36	10100.06	571.70	39.55	532.15	83.01	449.13	224.57	224.57
54	9752.92	10338.10	585.18	40.11	545.07	85.03	460.04	230.02	230.02
55	9982.94	10581.92	598.98	40.68	558.30	87.09	471.20	235.60	235.60
56	10218.54	10831.66	613.11	41.26	571.85	89.21	482.64	241.32	241.32
57	10459.86	11087.46	627.59	41.86	585.74	91.37	494.36	247.18	247.18
58	10707.04	11349.47	642.42	42.47	599.95	93.59	506.36	253.18	253.18
59	10960.23	11617.84	657.61	43.09	614.52	95.87	518.65	259.33	259.33
60	11219.55	11892.73	673.17	43.73	629.44	98.19	531.25	265.62	265.62
61	11485.18	12174.29	689.11	44.39	644.72	100.58	544.14	272.07	272.07
62	11757.25	12462.68	705.43	45.06	660.37	103.02	557.35	278.68	278.68
63	12035.92	12758.08	722.16	45.75	676.40	105.52	570.88	285.44	285.44
64	12321.37	13060.65	739.28	46.46	692.82	108.08	584.74	292.37	292.37
65	12613.74	13370.56	756.82	47.18	709.64	110.70	598.94	299.47	299.47
66	12913.21	13688.00	774.79	47.92	726.87	113.39	613.48	306.74	306.74
67	13219.95	14013.14	793.20	48.68	744.52	116.14	628.37	314.19	314.19
68	13534.13	14346.18	812.05	49.46	762.59	118.96	643.63	321.81	321.81
69	13855.95	14687.30	831.36	50.25	781.10	121.85	659.25	329.63	329.63
70	14185.57	15036.71	851.13	51.07	800.07	124.81	675.26	337.63	337.63
71	14523.20	15394.59	871.39	51.90	819.49	127.84	691.65	345.83	345.83
72	14869.03	15761.17	892.14	52.76	839.39	130.94	708.44	354.22	354.22
73	15223.25	16136.64	913.39	53.63	859.76	134.12	725.64	362.82	362.82
74	15586.07	16521.23	935.16	54.53	880.64	137.38	743.26	371.63	371.63
75	15957.69	16915.16	957.46	55.45	902.01	140.71	761.30	380.65	380.65
76	16338.34	17318.65	980.30	56.39	923.91	144.13	779.78	389.89	389.89
77	16728.24	17731.93	1003.69	57.35	946.34	147.63	798.71	399.36	399.36
78	17127.59	18155.25	1027.66	58.34	969.32	151.21	818.10	409.05	409.05
79	17536.64	18588.84	1052.20	59.35	992.85	154.88	837.96	418.98	418.98
80	17955.63	19032.96	1077.34	60.39	1016.95	158.64	858.31	429.15	429.15
81	18384.78	19487.87	1103.09	61.45	1041.64	162.50	879.14	439.57	439.57
82	18824.35	19953.81	1129.46	62.53	1066.93	166.44	900.49	450.24	450.24
83	19274.59	20431.07	1156.48	63.65	1092.83	170.48	922.35	461.17	461.17
84	19735.77	20919.91	1184.15	64.79	1119.36	174.62	944.74	472.37	472.37
85	20208.14	21420.63	1212.49	65.95	1146.53	178.86	967.67	483.84	483.84
86	20691.97	21933.49	1241.52	67.15	1174.37	183.20	991.17	495.58	495.58
87	21187.56	22458.81	1271.25	68.38	1202.88	187.65	1015.23	507.61	507.61
88	21695.17	22996.88	1301.71	69.63	1232.08	192.20	1039.88	519.94	519.94
89	22215.11	23548.02	1332.91	70.92	1261.99	196.87	1065.12	532.56	532.56
90	22747.67	24112.53	1364.86	72.23	1292.63	201.65	1090.98	545.49	545.49
91	23293.16	24690.75	1397.59	73.58	1324.01	206.55	1117.46	558.73	558.73
92	23851.89	25283.00	1431.11	74.96	1356.15	211.56	1144.59	572.30	572.30
93	24424.19	25889.64	1465.45	76.38	1389.07	216.70	1172.38	586.19	586.19
94	25010.38	26511.00	1500.62	77.83	1422.80	221.96	1200.84	600.42	600.42
95	25610.80	27147.44	1536.65	79.31	1457.34	227.34	1229.99	615.00	615.00
96	26225.79	27799.34	1573.55	80.83	1492.72	232.86	1259.85	629.93	629.93
97	26855.72	28467.06	1611.34	82.39	1528.96	238.52	1290.44	645.22	645.22
98	27500.94	29151.00	1650.06	83.98	1566.07	244.31	1321.77	660.88	660.88
99	28161.82	29851.53	1689.71	85.62	1604.09	250.24	1353.85	676.93	676.93
100	28838.75	30569.08	1730.33	87.29	1643.04	256.31	1386.72	693.36	693.36