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

CASH BALANCE Asia april
April
 | 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-04-01 00:00:00 | 2011-04-04 00:00:00 | 2011-04-05 00:00:00 | 2011-04-06 00:00:00 | 2011-04-07 00:00:00 | 2011-04-08 00:00:00 | 2011-04-11 00:00:00 | 2011-04-12 00:00:00 | 2011-04-13 00:00:00 | 2011-04-14 00:00:00 | 2011-04-15 00:00:00 | 2011-04-18 00:00:00 | 2011-04-19 00:00:00 | 2011-04-20 00:00:00 | 2011-04-21 00:00:00 | 2011-04-22 00:00:00 | 2011-04-25 00:00:00 | 2011-04-26 00:00:00 | 2011-04-27 00:00:00 | 2011-04-28 00:00:00 | 2011-04-29 00:00:00
Opening balance | 18304102.8456112 | 18442195.28441919 | 18519170.15038749 | 18612917.39670469 | 18651931.99801249 | 18369531.01808 | 18592045.44776919 | 18963040.59796209 | 18917850.21737619 | 18928379.85429379 | 18887436.4649747 | 19016012.73217939 | 19298241.56699519 | 19324484.36341179 | 20703277.43868879 | 20277852.867119 | 19978092.23770229 | 19837198.7837807 | 19771260.8281653 | 19593232.914655 | 21311836.3130357
Debtors | 424493.1122130001 | 340509.0509556 | 147632.621024 | 152301.304355 | 153688.609511 | 245672.574681 | 416237.077762 | 210212.558248 | 272111.657176 | 103868.660684 | 169148.5798862 | 322439.644185 | 156102.998476 | 1314939.570272 | 259864.11977 | 158787.0177368 | 51276.87664 | 150529.702546 | 67365.777486 | 1900533.5439783 | 378573.9787482
Expenses | 312738.0076065 | 276250.6171289999 | 56684.71358700001 | 91826.38707750004 | 439803.824812 | 63136.3438899 | 186927.535223 | 198422.364634 | 234997.2128 | 149274.645349 | 73426.79433199999 | 746847.3915540001 | 90846.4208332 | 59830.275212 | 778175.7172684 | 544850.7011865999 | 199983.8881775 | 216465.7276614 | 248143.6774761001 | 211496.866952 | 391761.452437
Sweeps | 0 | 0 | 0 | 0 | 0 | 0 | 34871.5675 | 0 | 0 | 0 | 0 | 633401.6 | 0 | 139120.8 | 36666.2497754 | 0 | 0 | -1.930499999999938 | 0 | 0 | 0
Cash balance due to operational activities | 18415857.9502177 | 18506453.7182458 | 18610118.05782449 | 18673392.31398219 | 18365816.78271149 | 18552067.2488711 | 18856226.55780819 | 18974830.79157609 | 18954964.66175219 | 18882973.86962879 | 18983158.2505289 | 19225006.58481039 | 19363498.14463799 | 20718714.45847179 | 20221632.09096579 | 19891789.18366919 | 19829385.22616479 | 19771260.8281653 | 19590482.9281752 | 21282269.5916813 | 21298648.8393469
Cash increase / decrease due to exch. rate fluctuation | 26337.33420149609 | 12716.43214169517 | 2799.338880199939 | -21460.31596970558 | 3714.235368508846 | 39978.19889809564 | 106814.0401538983 | -56980.57419990003 | -26584.807458397 | 4462.595345906913 | 32854.48165049404 | 73234.98218480125 | -39013.78122619912 | -15437.01978299767 | 56220.7761532031 | 86303.05403309315 | 7813.557615909725 | 0 | 2749.986479800195 | 29566.72135439888 | 59240.27862909809
Ending balance | 18442195.28441919 | 18519170.15038749 | 18612917.39670469 | 18651931.99801249 | 18369531.01808 | 18592045.44776919 | 18963040.59796209 | 18917850.21737619 | 18928379.85429379 | 18887436.4649747 | 19016012.73217939 | 19298241.56699519 | 19324484.36341179 | 20703277.43868879 | 20277852.867119 | 19978092.23770229 | 19837198.7837807 | 19771260.8281653 | 19593232.914655 | 21311836.3130357 | 21357889.11797599
Casflow | 138092.4388079979 | 76974.86596829817 | 93747.24631720036 | 39014.60130779445 | -282400.9799324907 | 222514.429689195 | 370995.1501928978 | -45190.38058590144 | 10529.63691760227 | -40943.38931909204 | 128576.2672046944 | 282228.8348158002 | 26242.7964165993 | 1378793.075277001 | -425424.5715697967 | -299760.6294167079 | -140893.45392159 | -65937.95561540127 | -178027.9135103002 | 1718603.3983807 | 46052.8049402982
Cumulative cashflow | 138092.4388079979 | 215067.304776296 | 308814.5510934964 | 347829.1524012908 | 65428.1724688001 | 287942.6021579951 | 658937.7523508929 | 613747.3717649914 | 624277.0086825937 | 583333.6193635017 | 711909.8865681961 | 994138.7213839963 | 1020381.517800596 | 2399174.593077596 | 1973750.0215078 | 1673989.392091092 | 1533095.938169502 | 1467157.9825541 | 1289130.0690438 | 3007733.467424501 | 3053786.272364799