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

CASH BALANCE Asia march
March
 | 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-03-01 00:00:00 | 2011-03-02 00:00:00 | 2011-03-03 00:00:00 | 2011-03-04 00:00:00 | 2011-03-07 00:00:00 | 2011-03-08 00:00:00 | 2011-03-09 00:00:00 | 2011-03-10 00:00:00 | 2011-03-11 00:00:00 | 2011-03-14 00:00:00 | 2011-03-15 00:00:00 | 2011-03-16 00:00:00 | 2011-03-17 00:00:00 | 2011-03-18 00:00:00 | 2011-03-21 00:00:00 | 2011-03-22 00:00:00 | 2011-03-23 00:00:00 | 2011-03-24 00:00:00 | 2011-03-25 00:00:00 | 2011-03-28 00:00:00 | 2011-03-29 00:00:00 | 2011-03-30 00:00:00 | 2011-03-31 00:00:00
Opening balance | 16935984.1288802 | 16733377.97188229 | 16302587.49052139 | 16349597.09206689 | 16453758.04451359 | 16686774.02167369 | 14548584.27978059 | 14491877.72743539 | 14534342.03829669 | 14759016.32111359 | 14961082.25306779 | 15272995.17160989 | 15492143.25553379 | 15573782.28286569 | 16377105.0864609 | 16340143.61963929 | 16043903.86947369 | 16137402.36494439 | 16065587.09045409 | 16617827.26187999 | 16671854.55945399 | 16830618.97437219 | 20593118.85317349
Debtors | 178961.3039965 | 55368.611225 | 255971.537065 | 126261.377286 | 316529.1452406 | 14854.60642 | 13384.94882 | 241234.029812 | 283376.8433587999 | 260979.376037 | 391846.1729519999 | 296158.2803262 | 138199.4699504 | 602636.3479126 | 107789.0709455 | 107933.26784 | 138631.874646 | 541159.918308 | 576504.7459205 | 226717.8499728 | 462897.8349980001 | 295326.272505 | 515840.023582
Expenses | 398464.341211 | 549451.0147982 | 197681.6145492 | 45872.590792 | 119735.4660108 | 37152.1209452 | 52645.385062 | 186986.2986895 | 39036.09469 | 112004.335248 | 52287.177757 | 61423.9308294 | 65364.08298899999 | 17739.98118 | 168781.8144175 | 405032.4096382 | 80335.56105810001 | 616608.5153659998 | 164600.3770775 | 223868.31169 | 269843.269819 | 118933.6670344 | 490487.2104108001
Sweeps | -50000 | 49754.5 | 0 | -293.0699999999997 | 0 | -2074379.605594 | 0 | 0 | 0 | 294.3775000000023 | 0 | 29927.66889180001 | 0 | 194016.561216 | 0 | 0 | 0 | -2321.49 | 119431.0405002 | 0 | 0 | 3601118.505398 | -2326984.0669904
Cash balance due to operational activities | 16666481.09166569 | 16289050.06830909 | 16360877.41303719 | 16429692.80856089 | 16650551.72374339 | 14590096.90155449 | 14509323.8435386 | 14546125.45855789 | 14778682.78696549 | 14908285.73940259 | 15300641.24826279 | 15537657.18999849 | 15564978.64249519 | 16352695.2108143 | 16316112.3429889 | 16043044.47784109 | 16102200.18306159 | 16059632.27788639 | 16596922.49979729 | 16620676.80016279 | 16864909.12463299 | 20608130.0852408 | 18291487.59935429
Cash increase / decrease due to exch. rate fluctuation | 66896.88021659665 | 13537.4222122971 | -11280.32097030059 | 24065.23595270328 | 36222.29793030024 | -41512.62177389674 | -17446.11610320397 | -11783.42026120238 | -19666.46585190296 | 52796.51366520673 | -27646.07665290497 | -45513.93446469866 | 8803.640370503068 | 24409.8756466005 | 24031.27665039897 | 859.3916325978935 | 35202.18188279867 | 5954.812567701563 | 20904.76208269782 | 51177.75929120183 | -34290.15026079863 | -15011.23206730932 | 12615.24625691026
Ending balance | 16733377.97188229 | 16302587.49052139 | 16349597.09206689 | 16453758.04451359 | 16686774.02167369 | 14548584.27978059 | 14491877.72743539 | 14534342.03829669 | 14759016.32111359 | 14961082.25306779 | 15272995.17160989 | 15492143.25553379 | 15573782.28286569 | 16377105.0864609 | 16340143.61963929 | 16043903.86947369 | 16137402.36494439 | 16065587.09045409 | 16617827.26187999 | 16671854.55945399 | 16830618.97437219 | 20593118.85317349 | 18304102.8456112
Casflow | -202606.1569979042 | -430790.4813609011 | 47009.60154549964 | 104160.9524467029 | 233015.9771600999 | -2138189.741893098 | -56706.55234520324 | 42464.31086129881 | 224674.2828168962 | 202065.9319542069 | 311912.9185420945 | 219148.0839239024 | 81639.02733190358 | 803322.803595202 | -36961.46682160161 | -296239.7501656022 | 93498.49547069892 | -71815.2744902987 | 552240.1714258976 | 54027.2975740023 | 158764.414918201 | 3762499.878801294 | -2289016.007562291
Cumulative cashflow | -202606.1569979042 | -633396.6383588053 | -586387.0368133057 | -482226.0843666028 | -249210.1072065029 | -2387399.849099601 | -2444106.401444804 | -2401642.090583505 | -2176967.807766609 | -1974901.875812402 | -1662988.957270307 | -1443840.873346405 | -1362201.846014502 | -558879.0424192995 | -595840.5092409011 | -892080.2594065033 | -798581.7639358044 | -870397.0384261031 | -318156.8670002054 | -264129.5694262031 | -105365.1545080021 | 3657134.724293292 | 1368118.716731001