Three-Bucket-Strategy-sheet-2.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	Date	Liquid NAV	Hybrid NAV	SmallCap NAV	No.	Withdrawal	Bucket 1	Bucket 2	Bucket 3	Total Portfolio	Market State	Event
2							Nippon Liquid	Sbi Equity Hybrid	Nippon Smallcap
3	1-Oct-10	2303.3837	54.37	10.0175		0	1200000	3800000	5000000	10000000	Bull Market	Wait
4	1-Nov-10	2315.7574	54.48	10.3262		0	1206446	3807688	5154080	10168214	Bull Market	Wait
5	1-Dec-10	2327.8909	53.56	10.1534		0	1212767	3743387	5067831	10023986	Bull Market	Wait
6	1-Jan-11	2340.8847	53.7	10.2449		0	1219536	3753172	5113501	10086211	Bear Market	Wait
7	1-Feb-11	2356.9694	49.14	9.3811		0	1227916	3434467	4682355	9344740	Bear Market	Wait
8	1-Mar-11	2371.7937	49.1	9.2268		0	1235639	3431671	4605340	9272652	Bear Market	Wait
9	1-Apr-11	2388.5887	50.51	9.6237		0	1244389	3530218	4803443	9578052	Bear Market	Wait
10	1-May-11	2406.0238	50.7	9.984		0	1253472	3543498	4983279	9780250	Bear Market	Wait
11	1-Jun-11	2423.4289	49.5	9.8442		0	1262540	3459628	4913501	9635670	Bear Market	Wait
12	1-Jul-11	2439.9937	49.84	9.7283		0	1271170	3483391	4855652	9610214	Bear Market	Wait
13	1-Aug-11	2458.5391	49.28	9.9679		0	1280831	3444252	4975243	9700327	Bear Market	Wait
14	1-Sep-11	2476.7044	45.35	8.9526		0	1290295	3169578	4468480	8928354	Bear Market	Wait
15	1-Oct-11	2493.1292	44.85	8.9023		0	1298852	3134633	4443374	8876859	Bear Market	Wait
16	1-Nov-11	2512.835	46.39	9.0503	1	50000	1259118	3242265	4517244	9018629	Bear Market	SWP
17	1-Dec-11	2531.0403	44.04	8.3291	2	50000	1218240	3078020	4157274	8453536	Bear Market	SWP
18	1-Jan-12	2550.9361	41.76	7.6796	3	50000	1177816	2918668	3833092	7929577	Bear Market	SWP
19	1-Feb-12	2571.7022	45.55	8.6928	4	50000	1137404	3183557	4338807	8659769	Normal	SWP
20	1-Mar-12	2591.378	46.88	8.9567	5	50000	1096107	3276512	4470526	8843146	Normal	SWP
21	1-Apr-12	2612.094	47.14	9.1203	6	50000	1054869	3294684	4552183	8901737	Normal	SWP
22	1-May-12	2635.791	47.77	9.164	7	50000	1014439	3338716	4573995	8927151	Normal	SWP
23	1-Jun-12	2658.0875	45.53	8.795	8	50000	973020	3182159	4389817	8544997	Normal	SWP
24	1-Jul-12	2677.7532	47.61	9.2486	9	50000	930219	3327533	4616221	8873974	Normal	SWP
25	1-Aug-12	2700.3799	48.97	9.3828	10	50000	888079	3422585	4683204	8993870	Normal	SWP
26	1-Sep-12	2719.6892	49.32	9.5129	11	50000	844430	3447048	4748140	9039618	Bull Market	SWP
27	1-Oct-12	2739.7113	52.24	10.4548	12	50000	800646	3651131	5218268	9670045	Bull Market	SWP
28	1-Nov-12	2759.3613	53.05	10.6331	13	50000	756389	3707743	5307262	9771394	Bull Market	SWP
29	1-Dec-12	2777.6746	55.69	10.8379	14	50000	711409	3892256	5409483	10013149	Bull Market	SWP
30	1-Jan-13	2798.2648	56.72	10.9933	15	50000	666682	3964244	5487047	10117975	Normal	SWP
31	1-Feb-13	2818.3872	57.75	10.2847	16	50000	621476	4036233	5133366	9791076	Normal	SWP
32	1-Mar-13	2836.4294	55.4855	9.6368	17	50000	575455	3877963	4809982	9263401	Bear Market	SWP
33	1-Apr-13	2857.9793	54.661	9.4877	18	50000	529827	3820338	4735562	9085728	Bear Market	SWP
34	1-May-13	2878.8979	56.0426	9.5755	19	50000	483705	3916900	4779386	9179991	Bear Market	SWP
35	1-Jun-13	2898.8007	57.659	9.4295	20	50000	437049	4029873	4706513	9173436	Bear Market	SWP
36	1-Jul-13	2919.0069	56.5359	9.2745	21	50000	390095	3951377	4629148	8970622	Bear Market	SWP
37	1-Aug-13	2931.563	54.9599	8.7635	22	50000	341773	3841228	4374095	8557098	Bear Market	SWP
38	1-Sep-13	2958.7931	53.3293	8.6304	23	50000	294948	3727263	4307661	8329873	Bear Market	SWP
39	1-Oct-13	2985.232	55.6206	9.1082	24	50000	247583	3887406	4546144	8681134	Normal	SWP
40	1-Nov-13	3010.758	59.3484	10.3442	25	50000	199700	4147947	5163064	9510713	Bull Market	SWP
41	1-Dec-13	3033.8027	60.7755	11.117	26	50000	151229	4247689	5548789	9947709	Bull Market	SWP
42	1-Jan-14	3056.9902	63.124	12.2988	27	50000	1200000	3314215	6138657	10652872	Normal	Refill B1(from B2).
43	1-Feb-14	3079.0737	61.5026	11.7473	28	50000	1158668	3229086	5863389	10251144	Bull Market	SWP
44	1-Mar-14	3099.3725	62.3404	12.1237	29	50000	1116307	3273073	6051260	10440641	Bull Market	SWP
45	1-Apr-14	3125.7889	66.1699	13.5044	30	50000	1075821	3474135	6740404	11290361	Bull Market	SWP
46	1-May-14	3149.237	67.8241	13.7869	31	50000	1033891	3560985	6881407	11476285	Bull Market	SWP
47	1-Jun-14	3172.9823	71.7057	16.4398	32	50000	991687	3764782	8205540	12962010	Bull Market	SWP
48	1-Jul-14	3195.6135	76.8495	19.3111	33	50000	948760	4034848	9638682	14622291	Normal	SWP
49	1-Aug-14	3218.5978	77.7793	18.7846	34	50000	905584	4083666	9375892	14365143	Bull Market	SWP
50	1-Sep-14	3241.8498	81.9739	20.6494	35	50000	862126	4303896	10306663	15472686	Bull Market	SWP
51	1-Oct-14	3264.985	83.6237	21.971	36	50000	818279	4390516	10966308	16175104	Bull Market	SWP
52	1-Nov-14	3288.2291	85.8158	22.6852	37	50000	774104	4505608	11322785	16602498	Bull Market	SWP
53	1-Dec-14	3311.9497	88.7837	22.9909	38	50000	729689	4661433	11475368	16866490	Bull Market	SWP
54	1-Jan-15	3335.4436	91.0335	24.2852	39	50000	684865	4779554	12121387	17585807	Bull Market	SWP
55	1-Feb-15	3359.1994	96.099	25.1347	40	50000	639742	5045510	12545395	18230648	Bull Market	SWP
56	1-Mar-15	3380.683	95.1325	24.6008	41	50000	593834	4994765	12278911	17867512	Bull Market	SWP
57	1-Apr-15	3405.6152	95.9269	24.4723	42	50000	548213	5036474	12214774	17799462	Normal	SWP
58	1-May-15	3429.8872	94.1248	23.5257	43	50000	502121	4941858	11742300	17186280	Normal	SWP
59	1-Jun-15	3454.9563	94.8923	24.0346	44	50000	455791	4982154	11996306	17434252	Normal	SWP
60	1-Jul-15	3477.9986	95.4645	24.1032	45	50000	408830	5012196	12030546	17451574	Bull Market	SWP
61	1-Aug-15	3500.6628	97.4406	26.0611	46	50000	361495	5115948	13007786	18485229	Normal	SWP
62	1-Sep-15	3524.204	93.1879	24.0984	47	50000	313925	4892667	12028150	17234744	Normal	SWP
63	1-Oct-15	3546.3543	94.3483	25.1064	48	50000	265899	4953592	12531270	17750762	Bull Market	SWP
64	1-Nov-15	3569.2061	96.136	26.5612	49	50000	217612	5047452	13257399	18522464	Bull Market	SWP
65	1-Dec-15	3590.9625	96.4198	27.4473	50	50000	168938	5062353	13699675	18930967	Bull Market	SWP
66	1-Jan-16	3613.7088	97.4267	27.9889	51	50000	1200000	4035227	13970002	19205230	Normal	Refill B1(from B2).
67	1-Feb-16	3636.3814	93.3817	25.3504	52	50000	1157528	3867691	12653057	17678277	Bear Market	SWP
68	1-Mar-16	3658.2643	89.5996	22.6614	53	50000	1114494	3711044	11310905	16136444	Bear Market	SWP
69	1-Apr-16	3685.4971	94.7994	24.5506	54	50000	1072791	3926410	12253855	17253056	Normal	SWP
70	1-May-16	3711.0861	96.1671	25.4898	55	50000	1030239	3983057	12722635	17735932	Normal	SWP
71	1-Jun-16	3735.6847	97.8645	25.9389	56	50000	987068	4053360	12946793	17987222	Bull Market	SWP
72	1-Jul-16	3759.1807	100.5776	27.5414	57	50000	943276	4165732	13746643	18855652	Bull Market	SWP
73	1-Aug-16	3782.4758	104.1968	28.0998	58	50000	899122	4315632	14025355	19240110	Bull Market	SWP
74	1-Sep-16	3804.8973	104.9601	29.1162	59	50000	854451	4347246	14532667	19734366	Bull Market	SWP
75	1-Oct-16	3825.687	105.0945	29.7125	60	50000	809120	4352813	14830296	19992231	Bull Market	SWP
76	1-Nov-16	3848.5076	108.2526	32.2525	61	50000	763947	4483615	16098078	21345641	Normal	SWP
77	1-Dec-16	3870.2249	103.5369	29.5886	62	50000	718258	4288300	14768455	19775013	Normal	SWP
78	1-Jan-17	3890.8859	100.5786	29.2741	63	50000	672092	4165773	14611479	19449345	Bull Market	SWP
79	1-Feb-17	3912.3936	105.2985	31.7502	64	50000	625807	4361262	15847367	20834437	Bull Market	SWP
80	1-Mar-17	3932.1042	106.9739	32.6595	65	50000	578960	4430654	16301222	21310837	Bull Market	SWP
81	1-Apr-17	3953.977	109.1553	34.596	66	50000	532180	4521004	17267781	22320966	Bull Market	SWP
82	1-May-17	3975.9152	110.4476	37.2071	67	50000	485133	4574528	18571050	23630712	Bull Market	SWP
83	1-Jun-17	3997.6862	112.0774	36.8285	68	50000	437790	4642031	18382081	23461903	Bull Market	SWP
84	1-Jul-17	4019.0838	113.7237	37.0185	69	50000	390133	4710218	18476915	23577267	Bull Market	SWP
85	1-Aug-17	4041.5315	118.9542	39.0396	70	50000	342312	4926855	19485700	24754868	Bull Market	SWP
86	1-Sep-17	4063.4799	118.3163	39.2838	71	50000	294171	4900435	19607586	24802193	Bull Market	SWP
87	1-Oct-17	4084.6856	117.7844	39.0236	72	50000	245706	4878404	19477714	24601825	Bull Market	SWP
88	1-Nov-17	4106.6353	125.192	43.028	73	50000	197026	5185213	21476416	26858656	Bull Market	SWP
89	1-Dec-17	4127.8527	125.3455	44.7306	74	50000	1200000	4139616	22326229	27665845	Bull Market	Refill B1(from B2).
90	1-Jan-18	4150.2605	127.9226	47.7222	75	50000	1156514	4224726	23819416	29200656	Normal	SWP
91	1-Feb-18	4173.0421	128.481	46.7202	76	50000	1112862	4243167	23319291	28675321	Normal	SWP
92	1-Mar-18	4194.1805	124.7032	46.0324	77	50000	1068499	4118403	22975992	28162895	Normal	SWP
93	1-Apr-18	4223.0322	122.7933	43.348	78	50000	1025849	4055328	21636136	26717314	Normal	SWP
94	1-May-18	4246.6839	128.06	46.8818	79	50000	981595	4229264	23399950	28610809	Normal	SWP
95	1-Jun-18	4270.9065	126.6879	43.2543	80	50000	937194	4183949	21589368	26710512	Normal	SWP
96	1-Jul-18	4297.331	124.9361	41.277	81	50000	892992	4126095	20602445	25621533	Normal	SWP
97	1-Aug-18	4323.9854	129.2919	42.3422	82	50000	848531	4269948	21134115	26252595	Normal	SWP
98	1-Sep-18	4349.841	131.7538	44.9766	83	50000	803605	4351254	22449014	27603873	Bear Market	SWP
99	1-Oct-18	4375.309	124.481	39.4482	84	50000	758310	4111065	19689643	24559018	Bear Market	SWP
100	1-Nov-18	4403.0902	122.2673	39.3307	85	50000	713125	4037956	19630995	24382077	Bear Market	SWP