{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"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"}

{"sheet":"VBA","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["IS/BS Circularity Problem - VBA Solution"]
[]
[null,null,"Interest Rate",0.06,null,"Precision",1E-4]
[]
[null,null,"Income Statement",null,null,"Balance Sheet"]
[null,null,"EBIT",500,null,"Excess Cash",1]
[null,null,"Interest Expense",{"$f":"G10*D3","v":0},null,"Net Fixed Assets",200]
[null,null,"Interest Income",{"$f":"G6*D3","v":0.06},null,"Total Assets",{"$f":"SUM(G6:G7)","v":201}]
[null,null,"EBT",{"$f":"D6-D7+D8","v":500.06}]
[null,null,"Tax",{"$f":"D9*0.3","v":150.018},null,"ST Debt",0]
[null,null,"Net Income",{"$f":"D9-D10","v":350.04200000000003},null,"LT Liabilities",56]
[null,null,"Dividends",5,null,"Total Liabilities",{"$f":"SUM(G10:G11)","v":56}]
[null,null,"Retained Earnings",{"$f":"D11-D12","v":345.04200000000003},null,"Equity",{"$f":"D13","v":345.04200000000003}]
[null,null,null,null,null,"Total L + E",{"$f":"G12+G13","v":401.04200000000003}]
[]
[null,null,null,null,null,"A w/o Excess",{"$f":"G7","v":200}]
[null,null,null,null,null,"L + E w/o ST Debt",{"$f":"G11+G13","v":401.04200000000003}]
[]
[null,null,null,null,null,"Surplus",{"$f":"MAX(G17-G16,0)","v":201.04200000000003}]
[null,null,null,null,null,"ST Debt",{"$f":"MAX(G16-G17,0)","v":0}]
[]
[null,null,null,null,null,"A - (L+E)",{"$f":"G8-G14","v":-200.04200000000003}]