{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Activity Ratios"],"not_rendered":{"defined_names":21,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Activity Ratios","index":0,"n_rows":32,"n_cols":7,"rows_kept":32}
[]
[]
[null,"Activity Ratios"]
[null,"XYZ Corporation"]
[null,"For Period Ending 12/31/2009"]
[]
[]
[null,"INVENTORY TURNOVER"]
[null,"Cost of Goods Sold",{"$nulls":4},{"v":2088000,"d":"$2,088,000"}]
[null,"Inventory",{"$nulls":4},{"v":289000,"d":"$289,000"}]
[]
[null,"The inventory turnover is:",{"$nulls":4},{"$f":"IF(G10,G9/G10,\"\")","v":{"v":7.224913494809688,"d":"7.22"}}]
[]
[null,"AVERAGE COLLECTION PERIOD"]
[null,"Accounts Receivable",{"$nulls":4},{"v":400000,"d":"$400,000"}]
[null,"Annual Sales",{"$nulls":4},{"v":3074000,"d":"$3,074,000"}]
[]
[null,"The average collection period is:",{"$nulls":4},{"$f":"IF(G16,G15/(G16/360),\"\")","v":{"v":46.84450227716331,"d":"46.84"}}]
[]
[null,"FIXED ASSET TURNOVER"]
[null,"Sales",{"$nulls":4},{"v":3074000,"d":"$3,074,000"}]
[null,"Net Fixed Assets",{"$nulls":4},{"v":2374000,"d":"$2,374,000"}]
[]
[null,"The fixed asset turnover is:",{"$nulls":4},{"$f":"IF(G22,G21/G22,\"\")","v":{"v":1.2948609941027802,"d":"1.29"}}]
[]
[null,"TOTAL ASSET TURNOVER"]
[null,"Sales",{"$nulls":4},{"v":3074000,"d":"$3,074,000"}]
[null,"Total Assets",{"$nulls":4},{"v":3597000,"d":"$3,597,000"}]
[]
[null,"The total asset turnover is:",{"$nulls":4},{"$f":"IF(G28,G27/G28,\"\")","v":{"v":0.8546010564359188,"d":"0.85"}}]
[]
[null,"Prepared by:",{"$nulls":3},"Prepared on:   ","2010-02-01"]