{"text_format":"1","workbook":"xls","n_sheets":2,"sheets":["Equity Reconciliation","Total Equity Chart"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Total Equity Chart","index":1,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Equity Reconciliation","index":0,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"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",2100000,4500000,0,0,200000,500000,7000000]
[null,"Shares issued",500000,1500000,0,0,0,0,1500000]
[null,"Shares repurchased",-50000,-90000,0,0,0,0,-90000]
[null,"Balance: End of period",2550000,5910000,0,0,200000,500000,8410000]
[]
[null,"Average price of shares issued",3,null,"NA",null,"NA"]
[null,"Average price of shares repurchased",1.8,null,"NA",null,"NA"]
[]
[null,"Retained earnings balance: Beginning of period",2000000]
[null,"Dividends paid",-400000]
[null,"Net earnings (loss)",800000]
[null,"Balance: End of period",2400000]
[]
[]
[null,null,"Beginning of period","End of period","Change"]
[null,"Stock",7000000,8410000,1410000]
[null,"Retained earnings",2000000,2400000,400000]
[null,"Total equity",9000000,10810000,1810000]