{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["EQUITY RECONCILIATION","TOTAL EQUITY"],"not_rendered":{"charts":2},"unopened":[{"sheet":"TOTAL EQUITY","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"EQUITY RECONCILIATION","index":0,"n_rows":28,"n_cols":9,"rows_kept":28,"merged":[[8,2,8,3],[8,4,8,5],[8,6,8,7]]}
[]
[null,"[Company Name]"]
[null,"Equity Reconciliation"]
[null,"[Date]"]
[]
[null,"Gray cells are calculated for you. You do not need to enter anything in them."]
[null,"EQUITY ANALYSIS"]
[null,"Consolidated Statement of Shareholder Equity"]
[null,null,"Common stock A",null,"Common stock B",null,"Preferred stock"]
[null,null,"Number of shares","Par value & capital in excess of par","Number of shares","Par value & capital in excess of par","Number of shares","Par value & capital in excess of par","Total stock"]
[null,"Stock balance: Beginning of period",{"v":2100000,"d":"2,100,000 "},{"v":4500000,"d":"$4,500,000"},{"v":0,"d":"0 "},{"v":0,"d":"$0"},{"v":200000,"d":"200,000 "},{"v":500000,"d":"$500,000"},{"$f":"D11+F11+H11+C19","v":{"v":7000000,"d":"$7,000,000"}}]
[null,"Shares issued",{"v":500000,"d":"500,000 "},{"v":1500000,"d":"1,500,000 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"D12+F12+H12","v":{"v":1500000,"d":"1,500,000 "}}]
[null,"Shares repurchased",{"v":-50000,"d":"(50,000)"},{"v":-90000,"d":"(90,000)"},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"D13+F13+H13","v":{"v":-90000,"d":"(90,000)"}}]
[null,"Balance: End of period",{"$f":"SUM(C11:C13)","v":{"v":2550000,"d":"2,550,000 "}},{"$f":"SUM(D11:D13)","v":{"v":5910000,"d":"5,910,000 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":200000,"d":"200,000 "},{"v":500000,"d":"500,000 "},{"v":8410000,"d":"8,410,000 "}]
[]
[null,"Average price of shares issued",{"$f":"IF(C12=0,\"N/A\",D12/C12)","v":{"v":3,"d":"$3.00"}},null,{"$f":"IF(E12=0,\"N/A\",F12/E12)","v":"N/A"},null,{"$f":"IF(G12=0,\"N/A\",H12/G12)","v":"N/A"}]
[null,"Average price of shares repurchased",{"$f":"IF(C13=0,\"N/A\",D13/C13)","v":{"v":1.8,"d":"$1.80"}},null,{"$f":"IF(E13=0,\"N/A\",F13/E13)","v":"N/A"},null,{"$f":"IF(G13=0,\"N/A\",H13/G13)","v":"N/A"}]
[]
[null,"Retained earnings balance: Beginning of period",{"v":2000000,"d":"$2,000,000"}]
[null,"Dividends paid",{"v":-400000,"d":"(400,000)"}]
[null,"Net earnings (loss)",{"v":800000,"d":"800,000 "}]
[null,"Balance: End of period",{"$f":"SUM(C19:C21)","v":{"v":2400000,"d":"$2,400,000"}}]
[]
[]
[null,null,"Beginning of period","End of period","Change"]
[null,"Stock",{"$f":"I11","v":{"v":7000000,"d":"$7,000,000"}},{"$f":"I14","v":{"v":8410000,"d":"$8,410,000"}},{"$f":"D26-C26","v":{"v":1410000,"d":"$1,410,000"}}]
[null,"Retained earnings",{"$f":"C19","v":{"v":2000000,"d":"$2,000,000"}},{"$f":"C22","v":{"v":2400000,"d":"$2,400,000"}},{"$f":"D27-C27","v":{"v":400000,"d":"$400,000"}}]
[null,"Total equity",{"$f":"SUM(C26:C27)","v":{"v":9000000,"d":"$9,000,000"}},{"$f":"SUM(D26:D27)","v":{"v":10810000,"d":"$10,810,000"}},{"$f":"D28-C28","v":{"v":1810000,"d":"$1,810,000"}}]