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

CASH BALANCE Asia feb
Feb
 | 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-02-01 00:00:00 | 2011-02-02 00:00:00 | 2011-02-03 00:00:00 | 2011-02-04 00:00:00 | 2011-02-07 00:00:00 | 2011-02-08 00:00:00 | 2011-02-09 00:00:00 | 2011-02-10 00:00:00 | 2011-02-11 00:00:00 | 2011-02-14 00:00:00 | 2011-02-15 00:00:00 | 2011-02-16 00:00:00 | 2011-02-17 00:00:00 | 2011-02-18 00:00:00 | 2011-02-21 00:00:00 | 2011-02-22 00:00:00 | 2011-02-23 00:00:00 | 2011-02-24 00:00:00 | 2011-02-25 00:00:00 | 2011-02-28 00:00:00
Opening balance | 16180562.10612459 | 16536695.84991129 | 16643581.2758758 | 16735232.34338569 | 16777363.58129659 | 16783043.64149899 | 16560971.64713469 | 16426897.88998909 | 16546887.00607229 | 16002420.38325039 | 16961957.29752799 | 17186858.74451889 | 17157325.32386799 | 17287090.28356639 | 17023863.25930829 | 17052140.68876249 | 15789991.20999519 | 15729380.71347879 | 17327489.18754939 | 17233832.5180998
Debtors | 639365.5704535 | 112671.4058356 | 54615.979976 | 136800.97058 | 58361.63502 | 22838.320612 | 194885.05327 | 254135.9260418 | 179699.500304 | 696925.7671930001 | 251212.253511 | 16791.481962 | 276095.30206 | 70183.09996 | 327516.3341410001 | 54076.681547 | 158048.4990804 | 170338.441982 | 173973.6198542 | 691438.0141631999
Expenses | 260961.16364 | 57787.73115700001 | 13075.9502573 | 89701.35470970001 | 61638.764115 | 232252.056526 | 354396.6291069999 | 105414.4586096 | 679710.5529100001 | 121932.004453 | 19188.42255 | 3351.693388 | 139209.0494757 | 60359.3107392 | 381889.3301889999 | 1284370.879336 | 163187.1554064 | 829971.721391 | 400405.795721 | 989286.4033828
Sweeps | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 429481.570869 | 0 | -27590.19000000018 | 0 | -309467.4873 | 0 | 0 | 0 | 2254783.8075525 | 132542.388 | 0
Cash balance due to operational activities | 16558966.51293809 | 16591579.52458989 | 16685121.3055945 | 16782331.95925599 | 16774086.45220159 | 16573629.90558499 | 16401460.07129769 | 16575619.3574213 | 16046875.95346629 | 17006895.71685939 | 17193981.12848899 | 17172708.34309289 | 17294211.57645229 | 16987446.58548719 | 16969490.26326029 | 15821846.49097349 | 15784852.55366919 | 17324531.24162229 | 17233599.3996826 | 16935984.1288802
Cash increase / decrease due to exch. rate fluctuation | -22270.66302679852 | 52001.75128590502 | 50111.03779119067 | -4968.377959400415 | 8957.189297402278 | -12658.25845029578 | 25437.81869140267 | -28732.35134900361 | -44455.57021590509 | -44938.41933139786 | -7122.383970100433 | -15383.01922489703 | -7121.292885903269 | 36416.67382110655 | 82650.42550219595 | -31855.28097829781 | -55471.8401904013 | 2957.945927102119 | 233.1184171997011 | 0
Ending balance | 16536695.84991129 | 16643581.2758758 | 16735232.34338569 | 16777363.58129659 | 16783043.64149899 | 16560971.64713469 | 16426897.88998909 | 16546887.00607229 | 16002420.38325039 | 16961957.29752799 | 17186858.74451889 | 17157325.32386799 | 17287090.28356639 | 17023863.25930829 | 17052140.68876249 | 15789991.20999519 | 15729380.71347879 | 17327489.18754939 | 17233832.5180998 | 16935984.1288802
Casflow | 356133.7437867001 | 106885.4259645063 | 91651.06750989147 | 42131.23791090026 | 5680.060202401131 | -222071.994364297 | -134073.7571455985 | 119989.1160831973 | -544466.6228219047 | 959536.9142776038 | 224901.4469908997 | -29533.42065089941 | 129764.9596983977 | -263227.0242580958 | 28277.42945419624 | -1262149.478767296 | -60610.49651640095 | 1598108.474070601 | -93656.6694495976 | -297848.3892196007
Cumulative cashflow | 356133.7437867001 | 463019.1697512064 | 554670.2372610979 | 596801.4751719981 | 602481.5353743993 | 380409.5410101023 | 246335.7838645037 | 366324.899947701 | -178141.7228742037 | 781395.1914034002 | 1006296.6383943 | 976763.2177434005 | 1106528.177441798 | 843301.1531837024 | 871578.5826378986 | -390570.8961293977 | -451181.3926457986 | 1146927.081424803 | 1053270.411975205 | 755422.0227556042