{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["LOCKBOX.XLT"],"read":"whole","date_system":"1904","formulas":"cached_only"}

{"sheet":"LOCKBOX.XLT","index":0,"n_rows":33,"n_cols":5,"rows_kept":33,"flags":["formulas_cached_only"]}
["Lockbox Analysis"]
[]
["Current Collection Policy"]
["Annual Credit Sales in Region",{"$nulls":3},{"v":0,"d":"$0"}]
["Number of Checks Processed per Year",{"$nulls":3},{"v":0,"d":"0 "}]
["Pre-Tax Rate of Return",{"$nulls":3},{"v":0,"d":"0.00%"}]
["Average Mailing Time (Days)",{"$nulls":3},0]
["Average Processing Time (Days)",{"$nulls":3},0]
["Average Clearing Time (Days)",{"$nulls":3},0]
[]
["Forecast of Lockbox Collections"]
["Average Mailing Time (Days)",{"$nulls":3},0]
["Average Processing Time (Days)",{"$nulls":3},0]
["Average Clearing Time (Days)",{"$nulls":3},0]
[]
["Forecasted Reduction in Collection Time (Days)",{"$nulls":3},0]
[]
["Terms of Lockbox Agreement"]
["Compensating Balance Requirement",{"$nulls":3},{"v":0,"d":"$0"}]
["Unit Processing Cost ($ per Check)",{"$nulls":3},{"v":0,"d":"$0.00"}]
["Fixed Fee",{"$nulls":3},{"v":0,"d":"$0.00"}]
[]
["Impact of Lockbox Agreement on Current Operations"]
["Reduction in Compensating Balance",{"$nulls":3},{"v":0,"d":"$0.00"}]
["Annual Savings in Home Office Costs",{"$nulls":3},{"v":0,"d":"$0.00"}]
[]
["Net Impact on Pretax Profits"]
["Funds Released",{"$nulls":3},{"v":0,"d":"$0.00"}]
["Pretax Earnings on Funds Released",{"$nulls":3},{"v":0,"d":"$0.00"}]
["Annual Cost of Lockbox Agreement",{"$nulls":3},{"v":0,"d":"$0.00"}]
["Annual Savings in Home Office Costs",{"$nulls":3},{"v":0,"d":"$0.00"}]
[]
["Net Impact on Pretax Profits",{"$nulls":3},{"v":0,"d":"$0.00"}]