{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Question 1","Question 2","Sheet3"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Question 1","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"flags":["formulas_cached_only"]}
[]
[null,"Part Two:  Final Project Week 4: Issues and Interests of Investors and Other Stakeholders; Analysis of Company Performance"]
[]
[]
[null,"Question 1"]

{"sheet":"Question 2","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"flags":["formulas_cached_only"]}
[]
[]
[null,"Question 2"]
[]
[null,"Barclays Bank Plc"]
[null,"Ratio","Formula",2015,2014,2013]
[null,"Profitability","Net sales/Revenue",{"v":0.02272654221561912,"d":"0.0227"},{"v":0.018622791268320487,"d":"0.0186"},{"v":0.02079072481371332,"d":"0.0208"}]
[null,"Debt","Total Assets/ Total Liabilities",{"v":2.3273363505263465,"d":"2.3273"},{"v":3.174873276845669,"d":"3.1749"},{"v":3.110264399372219,"d":"3.110"}]
[null,"Asset turnover","Net sales/(Average Assets)",{"v":0.020544666934095478,"d":"0.0205"},{"v":0.018721215427975366,"d":"0.0187"},{"v":0.04158144962742664,"d":"0.0416"}]
[]
[null,"Lloyds Banking Group"]
[null,"Ratio","Formula",2015,2014,2013]
[null,"Profitability","Net sales/Revenue",{"v":0.12665496889456054,"d":"0.1267"},{"v":0.12586747454820868,"d":"0.1259"},{"v":0.050741063846571476,"d":"0.0507"}]
[null,"Debt","Total Assets/ Total Liabilities",{"v":1.4020426420158043,"d":"1.4020"},{"v":1.3812953140966375,"d":"1.3813"},{"v":1.9532801131175066,"d":"1.9533"}]
[null,"Assets-turnover","Net sales/(Average Assets)",{"v":0.409028667343964,"d":"0.4090"},{"v":0.06506903735178683,"d":"0.0651"},{"v":0.08813184161558416,"d":"0.0881"}]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}