{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Equity Reconciliation","Total Equity Chart"],"not_rendered":{"charts":1,"macros":1,"external_links":1,"defined_names":24},"unopened":[{"sheet":"Total Equity Chart","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Equity Reconciliation","index":0,"n_rows":27,"n_cols":9,"rows_kept":27,"merged":[[7,2,7,3],[7,4,7,5],[7,6,7,7]],"flags":["formulas_cached_only"]}
[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.00"},{"v":200000,"d":"200,000 "},{"v":500000,"d":"$500,000"},{"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 "},{"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 "},{"v":-90000,"d":"(90,000)"}]
[null,"Balance: End of period",{"v":2550000,"d":"2,550,000 "},{"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",{"v":3,"d":"$3.00"},null,"NA",null,"NA"]
[null,"Average price of shares repurchased",{"v":1.8,"d":"$1.80"},null,"NA",null,"NA"]
[]
[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",{"v":2400000,"d":"$2,400,000"}]
[]
[]
[null,null,"Beginning of period","End of period","Change"]
[null,"Stock",{"v":7000000,"d":"$7,000,000"},{"v":8410000,"d":"$8,410,000"},{"v":1410000,"d":"$1,410,000"}]
[null,"Retained earnings",{"v":2000000,"d":"2,000,000 "},{"v":2400000,"d":"2,400,000 "},{"v":400000,"d":"400,000 "}]
[null,"Total equity",{"v":9000000,"d":"$9,000,000"},{"v":10810000,"d":"$10,810,000"},{"v":1810000,"d":"$1,810,000"}]