Spreadsheet: 114354d1310106284-using-indirect-across-workbooks-brianformulas
Sheet: May

CASH BALANCE Asia MAY
May
 | 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-05-02 00:00:00 | 2011-05-03 00:00:00 | 2011-05-04 00:00:00 | 2011-05-05 00:00:00 | 2011-05-06 00:00:00 | 2011-05-09 00:00:00 | 2011-05-10 00:00:00 | 2011-05-11 00:00:00 | 2011-05-12 00:00:00 | 2011-05-13 00:00:00 | 2011-05-16 00:00:00 | 2011-05-17 00:00:00 | 2011-05-18 00:00:00 | 2011-05-19 00:00:00 | 2011-05-20 00:00:00 | 2011-05-23 00:00:00 | 2011-05-24 00:00:00 | 2011-05-25 00:00:00 | 2011-05-26 00:00:00 | 2011-05-27 00:00:00 | 2011-05-30 00:00:00 | 2011-05-31 00:00:00
Opening balance | 21357889.11797599 | 21302268.1382772 | 20876077.83875679 | 21107366.159957 | 21413067.45601909 | 21088830.65482828 | 17992432.43000509 | 17957373.17489839 | 18551246.76208809 | 18976407.07219069 | 16563537.80830499 | 16629596.31032349 | 16700062.62050819 | 16547017.09849109 | 16779150.80317809 | 16916005.54114189 | 16464448.8717088 | 15820438.09711099 | 16083550.17382639 | 14124004.19985819 | 14202518.0110268 | 14225441.43151369
Debtors | 140086.4215732 | 59250.033558 | 279765.9953344 | 367454.207476 | 71911.533406 | 241888.008484 | 110557.931922 | 588185.9093261999 | 663720.0887324 | 299912.4311400001 | 267029.3606083 | 122556.067209 | 428815.8685308 | 262488.2865163999 | 311560.630232 | 260340.47142 | 249754.1562583 | 474826.9380445 | 236197.9035583 | 252470.4226947 | 223039.042272 | 1925390.845713
Expenses | 292589.1344892 | 453948.2674363001 | 27516.1095376 | 32400.9304996 | 124542.58437324 | 176947.0484366 | 156133.30728 | 12381.7646636 | 231117.393514 | 245922.6453 | 246233.746427 | 10510.771628 | 10108.748505 | 70215.509737 | 423347.1898238 | 755838.9534645 | 795481.4394049997 | 198167.836968 | 130670.368754 | 362938.8111978 | 307373.9186796001 | 783722.4288910001
Sweeps | 0 | 0 | 0 | 0 | -249180 | -3146190 | 0 | 0 | 0 | -2395504.09 | 59228.053031 | 0 | -545857.999616 | 0 | 252928 | 0 | 0 | 0 | -2041962 | 149261.7129 | 0 | 0
Cash balance due to operational activities | 21205386.40505999 | 20907569.9043989 | 21128327.72455359 | 21442419.4369334 | 21111256.40505185 | 18007581.61487567 | 17946857.05464709 | 18533177.31956099 | 18983849.45730649 | 16634892.76803069 | 16643561.47551729 | 16741641.60590449 | 16572911.74091799 | 16739289.87527049 | 16920292.24358629 | 16420507.05909739 | 15918721.5885621 | 16097097.19818749 | 14147115.7086307 | 14162797.52425509 | 14118183.1346192 | 15367109.84833569
Cash increase / decrease due to exch. rate fluctuation | 96881.73321720213 | -31492.06564210355 | -20961.56459659711 | -29351.98091430962 | -22425.7502235733 | -15149.18487058207 | 10516.12025130168 | 18069.44252709299 | -7442.385115794837 | -71354.95972569846 | -13965.16519379988 | -41578.98539630324 | -25894.64242689498 | 39860.927907601 | -4286.702444400638 | 43941.81261140108 | -98283.4914511051 | -13547.02436109632 | -23111.50877250358 | 39720.48677170463 | 107258.2968944982 | -23034.89304419979
Ending balance | 21302268.1382772 | 20876077.83875679 | 21107366.159957 | 21413067.45601909 | 21088830.65482828 | 17992432.43000509 | 17957373.17489839 | 18551246.76208809 | 18976407.07219069 | 16563537.80830499 | 16629596.31032349 | 16700062.62050819 | 16547017.09849109 | 16779150.80317809 | 16916005.54114189 | 16464448.8717088 | 15820438.09711099 | 16083550.17382639 | 14124004.19985819 | 14202518.0110268 | 14225441.43151369 | 15344074.95529149
Casflow | -55620.97969879955 | -426190.2995204031 | 231288.3212002032 | 305701.2960620932 | -324236.8011908121 | -3096398.224823184 | -35059.25510669872 | 593873.587189693 | 425160.3101026043 | -2412869.263885697 | 66058.50201850012 | 70466.31018469669 | -153045.5220170971 | 232133.7046870012 | 136854.7379637994 | -451556.6694330983 | -644010.774597805 | 263112.0767154042 | -1959545.973968202 | 78513.8111686036 | 22923.42048689723 | 1118633.523777802
Cumulative cashflow | -55620.97969879955 | -481811.2792192027 | -250522.9580189995 | 55178.33804309368 | -269058.4631477185 | -3365456.687970903 | -3400515.943077601 | -2806642.355887908 | -2381482.045785304 | -4794351.309671002 | -4728292.807652501 | -4657826.497467805 | -4810872.019484902 | -4578738.314797901 | -4441883.576834101 | -4893440.2462672 | -5537451.020865005 | -5274338.9441496 | -7233884.918117803 | -7155371.106949199 | -7132447.686462302 | -6013814.1626845