{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Q4"],"read":"whole","date_system":"1900"}

{"sheet":"Q4","index":0,"n_rows":41,"n_cols":8,"rows_kept":41,"merged":[[11,2,11,5],[22,2,22,5],[33,2,33,5]]}
[]
[null,"For simiplicity, assume that a company has the following initial values for net income, assets, equity, and liabillities: "]
[]
[null,"NI ",{"v":100,"d":"100.00"}]
[null,"Assets",{"v":1000,"d":"1,000.00"}]
[null,"Equity ",{"v":500,"d":"500.00"}]
[null,"Liabilities ",{"v":500,"d":"500.00"}]
[]
[]
[]
[null,"A. "]
[null,null,"ASSETS",{"$nulls":3},"LIABILITIES","EQUITY"]
[null,null,"Cash","Accounts Receivable ","Inventory","Accumulated Depreciation","Accounts Payable","Retained Earnings"]
[null,null,{"v":-10000,"d":"(10,000.00)"},{"$nulls":4},{"v":-10000,"d":"(10,000.00)"}]
[]
[null,null,"w/ error ",null,"w/o error"]
[null,"ROA ",{"$f":"C4/C5","v":{"v":0.1,"d":"10.0%"}},"higher than ",{"$f":"(C4-10)/(C5-10)","v":{"v":0.09090909090909091,"d":"9.1%"}}]
[null,"ROE ",{"$f":"C4/C6","v":{"v":0.2,"d":"20.0%"}},"higher than ",{"$f":"(C4-10)/(C6-10)","v":{"v":0.1836734693877551,"d":"18.4%"}}]
[null,"LR ",{"$f":"C7/C5","v":{"v":0.5,"d":"50.0%"}},"lower than ",{"$f":"C7/(C5-10)","v":{"v":0.5050505050505051,"d":"50.5%"}}]
[]
[]
[null,"B. "]
[null,null,"ASSETS",{"$nulls":3},"LIABILITIES","EQUITY"]
[null,null,"Cash","Accounts Receivable ","Inventory","Accumulated Depreciation","Loan","Retained Earnings"]
[null,null,{"v":20000,"d":"20,000.00"},{"$nulls":3},{"v":20000,"d":"20,000.00"}]
[]
[null,null,"w/ error ",null,"w/o error"]
[null,"ROA ",{"$f":"C4/(C5+20)","v":{"v":0.09803921568627451,"d":"9.8%"}},"same ",{"$f":"C4/(C5+20)","v":{"v":0.09803921568627451,"d":"9.8%"}}]
[null,"ROE ",{"$f":"C4/(C6+20)","v":{"v":0.19230769230769232,"d":"19.2%"}},"lower than ",{"$f":"C4/C6","v":{"v":0.2,"d":"20.0%"}}]
[null,"LR ",{"$f":"C7/C5","v":{"v":0.5,"d":"50.0%"}},"lower than ",{"$f":"(C7+20)/(C5+20)","v":{"v":0.5098039215686274,"d":"51.0%"}}]
[]
[]
[null,"C. "]
[null,null,"ASSETS",{"$nulls":3},"LIABILITIES","EQUITY"]
[null,null,"Cash","Accounts Receivable ","Inventory","Accumulated Depreciation","Loan","Retained Earnings"]
[{"$nulls":4},{"v":-20000,"d":"(20,000.00)"},null,null,{"v":-20000,"d":"(20,000.00)"}]
[]
[null,null,"w/ error ",null,"w/o error"]
[null,"ROA ",{"$f":"C4/C5","v":{"v":0.1,"d":"10.0%"}},"higher than ",{"$f":"(C4-20)/(C5-20)","v":{"v":0.08163265306122448,"d":"8.2%"}}]
[null,"ROE ",{"$f":"C4/C6","v":{"v":0.2,"d":"20.0%"}},"higher than ",{"$f":"(C4-20)/(C6-20)","v":{"v":0.16666666666666666,"d":"16.7%"}}]
[null,"LR ",{"$f":"C7/C5","v":{"v":0.5,"d":"50.0%"}},"lower than ",{"$f":"C7/(C5-20)","v":{"v":0.5102040816326531,"d":"51.0%"}}]