Margin call calculator

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Table 1
2	Pre-decline equity proportion	Pre-decline equity	Margin equity maintenance requirement	Market decline	Leverage	Pre-decline stock	Pre-decline maintenance margin	Pre-decline excess liquidity	Post-decline stock	Stock loss	Post-decline equity (net liquidation value)	Post-decline maintenance margin	Post-decline excess liquidity	Post-decline equity proportion	Cash required to achieve pre-decline equity proportion

3	1.00	100,000	0.4	0.5	1.00	100,000	40,000	60,000	50,000	50,000	50,000	20,000	30,000	1.00	0
4	0.90	100,000	0.4	0.5	1.11	111,111	44,444	55,556	55,556	55,556	44,444	22,222	22,222	0.80	5,556
5	0.80	100,000	0.4	0.5	1.25	125,000	50,000	50,000	62,500	62,500	37,500	25,000	12,500	0.60	12,500
6	0.70	100,000	0.4	0.5	1.43	142,857	57,143	42,857	71,429	71,429	28,571	28,571	0	0.40	21,429
7	0.60	100,000	0.4	0.5	1.67	166,667	66,667	33,333	83,333	83,333	16,667	33,333	-16,667	0.20	33,333
8	0.50	100,000	0.4	0.5	2.00	200,000	80,000	20,000	100,000	100,000	0	40,000	-40,000	0.00	50,000
9	0.40	100,000	0.4	0.5	2.50	250,000	100,000	0	125,000	125,000	-25,000	50,000	-75,000	-0.20	75,000
10	0.30	100,000	0.4	0.5	3.33	333,333	133,333	-33,333	166,667	166,667	-66,667	66,667	-133,333	-0.40	116,667
11	0.20	100,000	0.4	0.5	5.00	500,000	200,000	-100,000	250,000	250,000	-150,000	100,000	-250,000	-0.60	200,000
12	0.10	100,000	0.4	0.5	10.00	1,000,000	400,000	-300,000	500,000	500,000	-400,000	200,000	-600,000	-0.80	450,000
13	1.00	100,000	0.4	0.2	1.00	100,000	40,000	60,000	80,000	20,000	80,000	32,000	48,000	1.00	0
14	0.90	100,000	0.4	0.2	1.11	111,111	44,444	55,556	88,889	22,222	77,778	35,556	42,222	0.88	2,222
15	0.80	100,000	0.4	0.2	1.25	125,000	50,000	50,000	100,000	25,000	75,000	40,000	35,000	0.75	5,000
16	0.70	100,000	0.4	0.2	1.43	142,857	57,143	42,857	114,286	28,571	71,429	45,714	25,714	0.63	8,571
17	0.60	100,000	0.4	0.2	1.67	166,667	66,667	33,333	133,333	33,333	66,667	53,333	13,333	0.50	13,333
18	0.50	100,000	0.4	0.2	2.00	200,000	80,000	20,000	160,000	40,000	60,000	64,000	-4,000	0.38	20,000
19	0.40	100,000	0.4	0.2	2.50	250,000	100,000	0	200,000	50,000	50,000	80,000	-30,000	0.25	30,000
20	0.30	100,000	0.4	0.2	3.33	333,333	133,333	-33,333	266,667	66,667	33,333	106,667	-73,333	0.13	46,667
21	0.20	100,000	0.4	0.2	5.00	500,000	200,000	-100,000	400,000	100,000	0	160,000	-160,000	0.00	80,000
22	0.10	100,000	0.4	0.2	10.00	1,000,000	400,000	-300,000	800,000	200,000	-100,000	320,000	-420,000	-0.13	180,000
23	0.70	100,000	0.4	0.1	1.43	142,857	57,143	42,857	128,571	14,286	85,714	51,429	34,286	0.67	4,286
24	0.70	100,000	0.4	0.2	1.43	142,857	57,143	42,857	114,286	28,571	71,429	45,714	25,714	0.63	8,571
25	0.70	100,000	0.4	0.3	1.43	142,857	57,143	42,857	100,000	42,857	57,143	40,000	17,143	0.57	12,857
26	0.70	100,000	0.4	0.4	1.43	142,857	57,143	42,857	85,714	57,143	42,857	34,286	8,571	0.50	17,143
27	0.70	100,000	0.4	0.5	1.43	142,857	57,143	42,857	71,429	71,429	28,571	28,571	0	0.40	21,429
28	0.70	100,000	0.4	0.6	1.43	142,857	57,143	42,857	57,143	85,714	14,286	22,857	-8,571	0.25	25,714
29	0.70	100,000	0.4	0.7	1.43	142,857	57,143	42,857	42,857	100,000	0	17,143	-17,143	0.00	30,000
30	0.70	100,000	0.4	0.8	1.43	142,857	57,143	42,857	28,571	114,286	-14,286	11,429	-25,714	-0.50	34,286
31	0.70	100,000	0.4	0.9	1.43	142,857	57,143	42,857	14,286	128,571	-28,571	5,714	-34,286	-2.00	38,571
32	0.70	100,000	0.4	1	1.43	142,857	57,143	42,857	0	142,857	-42,857	0	-42,857	#DIV/0!	#DIV/0!
33	0.70	100,000	0.4	0.5	1.43	142,857	57,143	42,857	71,429	71,429	28,571	28,571	0	0.40	21,429
34	0.70	200,000	0.4	0.5	1.43	285,714	114,286	85,714	142,857	142,857	57,143	57,143	0	0.40	42,857
35	0.70	300,000	0.4	0.5	1.43	428,571	171,429	128,571	214,286	214,286	85,714	85,714	0	0.40	64,286
36	0.70	400,000	0.4	0.5	1.43	571,429	228,571	171,429	285,714	285,714	114,286	114,286	0	0.40	85,714
37	0.70	500,000	0.4	0.5	1.43	714,286	285,714	214,286	357,143	357,143	142,857	142,857	0	0.40	107,143
38	0.70	600,000	0.4	0.5	1.43	857,143	342,857	257,143	428,571	428,571	171,429	171,429	0	0.40	128,571
39	0.70	700,000	0.4	0.5	1.43	1,000,000	400,000	300,000	500,000	500,000	200,000	200,000	0	0.40	150,000
40	0.70	800,000	0.4	0.5	1.43	1,142,857	457,143	342,857	571,429	571,429	228,571	228,571	0	0.40	171,429
41	0.70	900,000	0.4	0.5	1.43	1,285,714	514,286	385,714	642,857	642,857	257,143	257,143	0	0.40	192,857
42	0.70	1,000,000	0.4	0.5	1.43	1,428,571	571,429	428,571	714,286	714,286	285,714	285,714	0	0.40	214,286
43	0.80	1,100,000	0.4	0.5	1.25	1,375,000	550,000	550,000	687,500	687,500	412,500	275,000	137,500	0.60	137,500
44	0.80	1,200,000	0.4	0.5	1.25	1,500,000	600,000	600,000	750,000	750,000	450,000	300,000	150,000	0.60	150,000
45	0.80	1,300,000	0.4	0.5	1.25	1,625,000	650,000	650,000	812,500	812,500	487,500	325,000	162,500	0.60	162,500
46	0.80	1,400,000	0.4	0.5	1.25	1,750,000	700,000	700,000	875,000	875,000	525,000	350,000	175,000	0.60	175,000
47	0.80	1,500,000	0.4	0.5	1.25	1,875,000	750,000	750,000	937,500	937,500	562,500	375,000	187,500	0.60	187,500
48	0.80	1,600,000	0.4	0.5	1.25	2,000,000	800,000	800,000	1,000,000	1,000,000	600,000	400,000	200,000	0.60	200,000
49	0.80	1,700,000	0.4	0.5	1.25	2,125,000	850,000	850,000	1,062,500	1,062,500	637,500	425,000	212,500	0.60	212,500
50	0.80	1,800,000	0.4	0.5	1.25	2,250,000	900,000	900,000	1,125,000	1,125,000	675,000	450,000	225,000	0.60	225,000
51	0.80	1,900,000	0.4	0.5	1.25	2,375,000	950,000	950,000	1,187,500	1,187,500	712,500	475,000	237,500	0.60	237,500
52	0.80	2,000,000	0.4	0.5	1.25	2,500,000	1,000,000	1,000,000	1,250,000	1,250,000	750,000	500,000	250,000	0.60	250,000
53	0.90	2,100,000	0.4	0.5	1.11	2,333,333	933,333	1,166,667	1,166,667	1,166,667	933,333	466,667	466,667	0.80	116,667
54	0.90	2,200,000	0.4	0.5	1.11	2,444,444	977,778	1,222,222	1,222,222	1,222,222	977,778	488,889	488,889	0.80	122,222
55	0.90	2,300,000	0.4	0.5	1.11	2,555,556	1,022,222	1,277,778	1,277,778	1,277,778	1,022,222	511,111	511,111	0.80	127,778
56	0.90	2,400,000	0.4	0.5	1.11	2,666,667	1,066,667	1,333,333	1,333,333	1,333,333	1,066,667	533,333	533,333	0.80	133,333
57	0.90	2,500,000	0.4	0.5	1.11	2,777,778	1,111,111	1,388,889	1,388,889	1,388,889	1,111,111	555,556	555,556	0.80	138,889
58	0.90	2,600,000	0.4	0.5	1.11	2,888,889	1,155,556	1,444,444	1,444,444	1,444,444	1,155,556	577,778	577,778	0.80	144,444
59	0.90	2,700,000	0.4	0.5	1.11	3,000,000	1,200,000	1,500,000	1,500,000	1,500,000	1,200,000	600,000	600,000	0.80	150,000
60	0.90	2,800,000	0.4	0.5	1.11	3,111,111	1,244,444	1,555,556	1,555,556	1,555,556	1,244,444	622,222	622,222	0.80	155,556
61	0.90	2,900,000	0.4	0.5	1.11	3,222,222	1,288,889	1,611,111	1,611,111	1,611,111	1,288,889	644,444	644,444	0.80	161,111
62	0.90	3,000,000	0.4	0.5	1.11	3,333,333	1,333,333	1,666,667	1,666,667	1,666,667	1,333,333	666,667	666,667	0.80	166,667
63					#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
64					#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
65					#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
66					#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
67					#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
68
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