Spreadsheet: 83148d1283197536-pivot-table-totals-monetary-template-2
Sheet: Sheet9

 |  |  | Data
Company Type | Currency | Cat Code | Sum of Prior Month Bal | Sum of Current Month Bal | Sum of Current to Prior Period Incr / Decr | Sum of Period FX in USD
Non USD Co's | AUD | Cash | 733796.97 | 448898.46 | -284898.51 | 6024.698378
 |  | Inter-Company | -31022853.55 | -38705268.50000001 | -7682414.950000003 | 0
 |  | Other Assets | 18780.27 | -35568.15 | -54348.42 | 0
 |  | Other Liabilities | -2913809.27 | -3312076.83 | -398267.56 | 0
 | AUD Sum |  | -33184085.58 | -41604015.02 | -8419929.440000003 | 6024.698378
 | BRL | Inter-Company | 28196251.56 | 16498893.92 | -11697357.64 | 0
 |  | Other Liabilities | -20315435.84 | -20823185.12 | -507749.2800000012 | 0
 | BRL Sum |  | 7880815.719999999 | -4324291.2 | -12205106.92 | 0
 | CAD | Inter-Company | 77707.18 | 77707.18 | 0 | 355.60456272
 |  | Other Liabilities | -28.25 | 0 | 28.25 | -0.15302
 | CAD Sum |  | 77678.93 | 77707.18 | 28.25 | 355.45154272
 | CHF | Cash | 693892 | 347440.21 | -346451.79 | -10718.03145
 |  | Inter-Company | 18410 | 18410 | 0 | 117.579566192
 |  | Other Liabilities | -26967.9 | -23006.92 | 3960.98 | 0
 | CHF Sum |  | 685334.1 | 342843.29 | -342490.81 | -10600.451883808
 | CNY | Other Liabilities | -54000 | -110400 | -56400 | 0
 | CNY Sum |  | -54000 | -110400 | -56400 | 0
 | DKK | Inter-Company | 5200 | 5200 | 0 | -12.346048
 | DKK Sum |  | 5200 | 5200 | 0 | -12.346048
 | EUR | Cash | 34211661.13 | 35551461.47 | 1339800.34 | 0
 |  | Inter-Company | 94255.78 | 94255.78 | 0 | 4365.965966735999
 |  | Other Assets | -152126.48 | -152831.7 | -705.2199999999802 | 33.977263
 |  | Other Liabilities | -1319583.37 | -1473867.24 | -154283.87 | 0
 | [NAME] |  | 32834207.06000001 | 34019018.30999999 | 1184811.25 | 4399.943229735999
 | GBP | Inter-Company | 44057.64 | 43820.01 | -237.63 | 1395.746114848
 |  | Other Liabilities | -3203680.31 | -3459974.88 | -256294.57 | 47.88322
 | GBP Sum |  | -3159622.67 | -3416154.87 | -256532.2 | 1443.629334848
 | NOK | Inter-Company | -148667.91 | -386692.78 | -238024.87 | 2858.508362744
 | NOK Sum |  | -148667.91 | -386692.78 | -238024.87 | 2858.508362744
 | NZD | Inter-Company | 120000 | 240000 | 120000 | -6806.19454
 |  | Other Liabilities | -19693.23 | -7627 | 12066.23 | 0
 | NZD Sum |  | 100306.77 | 232373 | 132066.23 | -6806.19454
 | SEK | Inter-Company | 871269.81 | 1391669.79 | 520399.98 | 968.0629059199999
 |  | Other Assets | -32738.14 | -32508.58 | 229.5599999999977 | 0
 | SEK Sum |  | 838531.67 | 1359161.21 | 520629.54 | 968.0629059199999
 | SGD | Inter-Company | -3173560.01 | -3456387.59 | -282827.58 | 0
 |  | Other Liabilities | -11833.88 | -14920.24 | -3086.36 | 0
 | SGD Sum |  | -3185393.89 | -3471307.83 | -285913.94 | 0
 | USD | Cash | 147536.41 | 354439.96 | 206903.55 | -28966.443764
 |  | Inter-Company | 8394025.17 | 9312826.99 | 918801.82 | -232320.162283272
 |  | Other Assets | 47435.38 | 50490.2 | 3054.82 | -3232.34898
 |  | Other Liabilities | -183203.98 | -159886.54 | 23317.44 | 2918.492725951999
 | USD Sum |  | 8405792.98 | 9557870.61 | 1152077.63 | -261600.46230132
Non USD Co's Sum |  |  | 11096097.18 | -7718688.099999996 | -18814785.28 | -262969.1610191601
USD Co's | AUD | Deferred Revenue | -1492665.04 | -1428107.68 | 64557.3600000001 | -96391.36
 |  | Inter-Company | 8849260.08 | 10381866.67 | 1532606.59 | 617628.06
 |  | Other Liabilities | -694.89 | -806.29 | -111.4 | -59.4
 | AUD Sum |  | 7355900.15 | 8952952.700000001 | 1597052.55 | 521177.3
 | BRL | Deferred Revenue | -364600.13 | -267919.64 | 96680.49 | -5352.47
 |  | Inter-Company | 2118430.8 | 2688899.04 | 570468.24 | 35070.98
 |  | Other Liabilities | 0 | 0 | 0 | 0
 | BRL Sum |  | 1753830.67 | 2420979.4 | 667148.73 | 29718.51
 | CAD | Deferred Revenue | -2685431.29 | -2698655.21 | -13223.91999999993 | -90355.98
 |  | Other Liabilities | -158817.5 | -25757.1 | 133060.4 | -1616.38
 | CAD Sum |  | -2844248.79 | -2724412.31 | 119836.48 | -91972.36
 | CHF | Deferred Revenue | -291247 | -249505.84 | 41741.16 | -27926.32
 |  | Inter-Company | 1656067.66 | 1947101.69 | 291034.03 | 59383.09
 |  | Other Liabilities | 0 | 0 | 0 | 0
 | CHF Sum |  | 1364820.66 | 1697595.85 | 332775.19 | 31456.77
 | DEM | Deferred Revenue | 0 | 0 | 0 | 0
 | DEM Sum |  | 0 | 0 | 0 | 0
 | DKK | Deferred Revenue | -8219307.899999999 | -14473328.66 | -6254020.760000001 | -242660.13
 |  | Inter-Company | 232 | 232 | 0 | 2.5
 |  | Other Liabilities | 0 | -558 | -558 | -2.63
 | DKK Sum |  | -8219075.899999999 | -14473654.66 | -6254578.760000001 | -242660.26
 | EUR | Cash | 76.08000000000175 | 55.65999999999985 | -20.42000000000189 | 2389.24
 |  | Deferred Revenue | -24819435.07999999 | -29994448.88 | -5175013.8 | -2464952.97
 |  | EUR Debt Strategy | -1621547831.5 | -1625273377.01 | -3725545.510000105 | -132075803.99
 |  | Inter-Company | 7343709.52 | 9245300.950000001 | 1901591.43 | 679157.48
 |  | Other | 13626.74 | 24820.96 | 11194.22 | 1176.24
 |  | Other Assets | 50691.03 | 37374.14 | -13316.89 | 3352.51
 |  | Other Liabilities | -199529.7 | -333665.71 | -134136.01 | 7935.66
 | [NAME] |  | -1639158692.91 | -1646293939.89 | -7135246.980000105 | -133846745.83
 | GBP | Cash | 40361.96 | 67845.85 | 27483.89 | 98428.8
 |  | Deferred Revenue | -51450036.34 | -51292362.58000001 | 157673.7599999987 | -6041915.85
 |  | Inter-Company | 35547100.90000001 | 45358532.2 | 9811431.299999997 | 3026223.88
 |  | Other | 24156.49 | -26549.6 | -50706.09 | 591.04
 |  | Other Assets | -123.36 | -123.36 | 0 | -9.18
 |  | Other Liabilities | -5115434.4 | -2438824.76 | 2676609.64 | -150419.93
 | GBP Sum |  | -20953974.75 | -8331482.250000001 | 12622492.5 | -3067101.24
 | HTG | Cash | 107759.88 | 1352669.68 | 1244909.8 | 0
 | HTG Sum |  | 107759.88 | 1352669.68 | 1244909.8 | 0
 | ITL | Deferred Revenue | 0 | 0 | 0 | 0
 | ITL Sum |  | 0 | 0 | 0 | 0
 | JMD | Cash | -744724.04 | 1187391.81 | 1932115.85 | 215.12
 | [NAME] |  | -744724.04 | 1187391.81 | 1932115.85 | 215.12
 | [NAME] | Inter-Company | -4159500 | -4159500 | 0 | -7487.1
 |  | Other | 102429.79 | 102429.79 | 0 | 184.38
 | [NAME] |  | -4057070.21 | -4057070.21 | 0 | -7302.72
 | NOK | Deferred Revenue | -64206258.96999999 | -32511888.9 | 31694370.07 | -553528.78
 |  | Inter-Company | 1158 | 1158 | 0 | 12.39
 |  | Other Assets | 12829 | 12829 | 0 | 137.27
 |  | Other Liabilities | -702 | -1062 | -360 | -8.61
 | NOK Sum |  | -64192973.96999999 | -32498963.9 | 31694010.07 | -553387.73
 | NZD | Other Liabilities | 0 | 0 | 0 | 0
 | NZD Sum |  | 0 | 0 | 0 | 0
 | SEK | Deferred Revenue | -10739801.93 | 734929.41 | 11474731.34 | -385835.58
 |  | Inter-Company | 310615.73 | 377208.53 | 66592.8 | 3781.82
 |  | Other Liabilities | -254 | -254 | 0 | -2.64
 | SEK Sum |  | -10429440.2 | 1111883.94 | 11541324.14 | -382056.4
 | SGD | Deferred Revenue | 369970.79 | 227501.71 | -142469.08 | -30802.98
 |  | Inter-Company | 1317703.8 | 1515759.54 | 198055.74 | 29234.23
 | SGD Sum |  | 1687674.59 | 1743261.25 | 55586.65999999989 | -1568.75
 | USD | Deferred Revenue | -270274788.53 | -300538595.51 | -30263806.97999999 | 0
 |  | Inter-Company | 388350.92 | 509905.84 | 121554.92 | 0
 |  | Other | -809394.24 | -870043.15 | -60648.91 | 0
 |  | Other Assets | -1896904.6 | -1872148.09 | 24756.51000000013 | 0
 |  | Other Liabilities | -5384650.98 | -5506091.399999999 | -121440.42 | 0
 | USD Sum |  | -277977387.4300001 | -308276972.3099999 | -30299584.87999999 | 0
USD Co's Sum |  |  | -2016307602.249999 | -1998189760.9 | 18117841.3499999 | -137610227.59
(blank) | (blank) | (blank) |  |  |  | -137873196.7510191
 | (blank) Sum |  |  |  |  | -137873196.7510191
(blank) Sum |  |  |  |  |  | -137873196.7510191
Grand Total |  |  | -2005211505.069999 | -2005908449 | -696943.9300001166 | -275746393.5020382