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

CASH BALANCE Asia june
June
 | 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-06-01 00:00:00 | 2011-06-02 00:00:00 | 2011-06-03 00:00:00 | 2011-06-06 00:00:00 | 2011-06-07 00:00:00 | 2011-06-08 00:00:00 | 2011-06-09 00:00:00 | 2011-06-10 00:00:00 | 2011-06-13 00:00:00 | 2011-06-14 00:00:00 | 2011-06-15 00:00:00 | 2011-06-16 00:00:00 | 2011-06-17 00:00:00 | 2011-06-20 00:00:00 | 2011-06-21 00:00:00 | 2011-06-22 00:00:00 | 2011-06-23 00:00:00 | 2011-06-24 00:00:00 | 2011-06-27 00:00:00 | 2011-06-28 00:00:00 | 2011-06-29 00:00:00 | 2011-06-30 00:00:00
Opening balance | 15344074.95529149 | 15272311.22306969 | 15489070.22903369 | 16200764.63752159 | 16326446.83494259 | 16457361.88785269 | 16594855.8093063 | 16438573.27695159 | 16973146.83192429 | 15679418.12936439 | 15642574.85473899 | 15781432.96402099 | 15712927.31747349 | 16167985.57718329 | 16897674.7916477 | 17302562.86620849 | 17149265.56165919 | 16801947.44705709 | 16208852.09551609 | 18405736.43614959 | 19080970.81309109 | 19321609.98351859
Debtors | 213970.961457 | 276641.818986 | 1162463.384724 | 188296.345958 | 236243.28427 | 232887.090225 | 121130.229536 | 634809.3250202 | 439109.0042066 | 43311.855478 | 155984.6117676 | 196079.058537 | 443815.1364049999 | 713382.7610959 | 476441.5120870001 | 305140.8150253 | 694698.6454042 | 274952.1798057 | 259900.969957 | 476533.8729589999 | 423580.079362 | 1221597.8368536
Expenses | 280620.839493 | 79881.7751288 | 427389.4705606 | 148286.797336 | 84149.40900079999 | 87671.73422 | 265432.958153 | 94374.5314406 | 128185.4215 | 44987.10998 | 31713.1597716 | 93295.505428 | 47716.36590799999 | 108673.5466315 | 15033.069505 | 479259.6563319999 | 213734.8012905 | 820879.70557 | 171084.706012 | 57920.2233381 | 199737.430631 | 1032565.331667
Sweeps | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13988.07 | -1606545.43 | 0 | 0 | -151999.895355 | 26805.71817750001 | 124980 | 0 | 0 | -847476.8500000001 | -1.040100000001985 | 2100609.313795 | 331015.6041988003 | 0 | 0
Cash balance due to operational activities | 15277425.07725549 | 15469071.26692689 | 16224144.14319709 | 16240774.1861436 | 16478540.71021179 | 16602577.24385769 | 16450553.0806893 | 16992996.14053119 | 15677524.98463089 | 15677742.87486239 | 15766846.30673499 | 15732216.62177499 | 16135831.80614799 | 16897674.79164769 | 17359083.2342297 | 17128444.02490179 | 16782752.55577289 | 16256018.88119279 | 18398277.67325609 | 19155365.68996929 | 19304813.46182209 | 19510642.4887052
Cash increase / decrease due to exch. rate fluctuation | -5113.854185802862 | 19998.96210680157 | -23379.5056754984 | 85672.64879899472 | -21178.82235910185 | -7721.434551393613 | -11979.80373770744 | -19849.30860690027 | 1893.144733503461 | -35168.02012339979 | 14586.65728599764 | -19289.30430150032 | 32153.77103530243 | 0 | -56520.36802120134 | 20821.5367573984 | 19194.89128420502 | -47166.78567670286 | 7458.762893501669 | -74394.87687820196 | 16796.52169650421 | 78131.00527459756
Ending balance | 15272311.22306969 | 15489070.22903369 | 16200764.63752159 | 16326446.83494259 | 16457361.88785269 | 16594855.8093063 | 16438573.27695159 | 16973146.83192429 | 15679418.12936439 | 15642574.85473899 | 15781432.96402099 | 15712927.31747349 | 16167985.57718329 | 16897674.7916477 | 17302562.86620849 | 17149265.56165919 | 16801947.44705709 | 16208852.09551609 | 18405736.43614959 | 19080970.81309109 | 19321609.98351859 | 19588773.49397979
Casflow | -71763.73222180456 | 216759.0059640016 | 711694.408487903 | 125682.1974209957 | 130915.0529100988 | 137493.9214536063 | -156282.5323547069 | 534573.5549727008 | -1293728.702559896 | -36843.27462540008 | 138858.1092819963 | -68505.64654749818 | 455058.2597098015 | 729689.2144644018 | 404888.0745607987 | -153297.3045493029 | -347318.1146020964 | -593095.3515410032 | 2196884.340633502 | 675234.3769414946 | 240639.1704275049 | 267163.5104612
Cumulative cashflow | -71763.73222180456 | 144995.2737421971 | 856689.6822301 | 982371.8796510957 | 1113286.932561195 | 1250780.854014801 | 1094498.321660094 | 1629071.876632795 | 335343.1740728989 | 298499.8994474988 | 437358.0087294951 | 368852.3621819969 | 823910.6218917985 | 1553599.8363562 | 1958487.910916999 | 1805190.606367696 | 1457872.4917656 | 864777.1402245965 | 3061661.480858099 | 3736895.857799593 | 3977535.028227098 | 4244698.538688298