Spreadsheet: 114374d1310119695-updating-indirect-with-closed-workbook-brianformulas
Sheet: Jan

CASH BALANCE Asia JAN
Jan
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
US Dollar cash balance: | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00 | 2011-01-17 00:00:00 | 2011-01-18 00:00:00 | 2011-01-19 00:00:00 | 2011-01-20 00:00:00 | 2011-01-21 00:00:00 | 2011-01-24 00:00:00 | 2011-01-25 00:00:00 | 2011-01-26 00:00:00 | 2011-01-27 00:00:00 | 2011-01-28 00:00:00 | 2011-01-31 00:00:00
Opening balance | 15877817.08099809 | 16040196.79773649 | 15798207.78758799 | 15675503.7391503 | 15738241.3013416 | 15767149.96859159 | 15895479.16849139 | 15708760.16317769 | 16085560.4088838 | 16073066.37031809 | 16218445.803661 | 16219515.29727449 | 16260956.90367359 | 16136838.77640549 | 16284207.71963479 | 16021694.74913639 | 15796890.43013289 | 15780649.95564969 | 16002493.37177289 | 15911706.99351019 | 16008902.90088109
Debtors | 126422.7188541 | 132284.00265 | 84599.70497400001 | 177777.657402 | 96796.94528100001 | 168495.6249632 | 36195.85376 | 575393.1112034 | 66059.9576432 | 108944.261554 | 126344.1803204 | 116824.200011 | 112900.602994 | 201399.612985 | 382073.0821535001 | 476309.5085304999 | 130409.137206 | 160472.023464 | 185939.032777 | 272510.1253374 | 790734.0260390001
Expenses | 33086.6235678 | 298541.019527 | 192986.797097 | 75752.45196399999 | 12371.001904 | 96025.7977764 | 196010.3715827 | 193432.9589985 | 85586.245528 | 12741.444309 | 143510.7582321 | 53082.97527299999 | 259766.7767725 | 88081.5026406 | 599618.1834780001 | 718188.8101560001 | 114152.7608905 | 70374.934464 | 293552.891666 | 155980.156111 | 640853.9584476
Sweeps | 418.9400000000023 | 1009 | 0 | 0 | 0 | 46581.410466 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 119867.472 | 0 | 0 | 0.01306800000000408
Cash balance due to operational activities | 15971572.11628439 | 15874948.78085949 | 15689820.69546499 | 15777528.9445883 | 15822667.2447186 | 15886201.20624439 | 15735664.65066869 | 16090720.31538259 | 16066034.120999 | 16169269.18756309 | 16201279.2257493 | 16283256.52201249 | 16114090.7298951 | 16250156.8867499 | 16066662.61831029 | 15779815.44751089 | 15813146.80644839 | 15990614.51664969 | 15894879.51288389 | 16028236.96273659 | 16158782.98154049
Cash increase / decrease due to exch. rate fluctuation | 68624.6814521011 | -76740.9932715036 | -14316.95631469414 | -39287.64324670099 | -55517.276127005 | 9277.962246999145 | -26904.48749099858 | -5159.906498799101 | 7032.249319097027 | 49176.61609790288 | 18236.07152519748 | -22299.61833889969 | 22748.04651039839 | 34050.83288489282 | -44967.86917389929 | 17074.98262200132 | -32496.85079869814 | 11878.85512320139 | 16827.48062629998 | -19334.06185550243 | 21779.12458410487
Ending balance | 16040196.79773649 | 15798207.78758799 | 15675503.7391503 | 15738241.3013416 | 15767149.96859159 | 15895479.16849139 | 15708760.16317769 | 16085560.4088838 | 16073066.37031809 | 16218445.803661 | 16219515.29727449 | 16260956.90367359 | 16136838.77640549 | 16284207.71963479 | 16021694.74913639 | 15796890.43013289 | 15780649.95564969 | 16002493.37177289 | 15911706.99351019 | 16008902.90088109 | 16180562.10612459
Casflow | 162379.716738401 | -241989.0101485029 | -122704.0484376941 | 62737.56219129823 | 28908.66724999622 | 128329.1998998001 | -186719.0053136982 | 376800.2457061019 | -12494.03856570274 | 145379.4333429039 | 1069.493613498285 | 41441.60639910027 | -124118.1272681002 | 147368.9432292935 | -262512.9704983979 | -224804.3190035 | -16240.47448319942 | 221843.4161232002 | -90786.37826270051 | 97195.90737089701 | 171659.2052435037
Cumulative cashflow | 162379.716738401 | -79609.2934101019 | -202313.341847796 | -139575.7796564978 | -110667.1124065015 | 17662.08749329858 | -169056.9178203996 | 207743.3278857023 | 195249.2893199995 | 340628.7226629034 | 341698.2162764017 | 383139.8226755019 | 259021.6954074018 | 406390.6386366952 | 143877.6681382973 | -80926.65086520277 | -97167.12534840219 | 124676.290774798 | 33889.91251209751 | 131085.8198829945 | 302745.0251264982