Spreadsheet: 72145d1272873266-age-analysis-match-allocate-to-oldest-debt-balance-age-arrears-matching
Sheet: Sim

Prepared by X
[NAME]
as at April 2010 |  |  |  | ORIGINAL |  |  |  |  |  |  |  | MATCHED TO OLDEST
X
Premises | Name | Combined | Name | Closing Balance | 2010-04-01 00:00:00 | 2010-03-01 00:00:00 | 2010-02-01 00:00:00 | 2010-01-01 00:00:00 | 2009-12-01 00:00:00 | Opening Balance |  | Closing Balance | 2010-04-01 00:00:00 | 2010-03-01 00:00:00 | 2010-02-01 00:00:00 | 2010-01-01 00:00:00 | 2009-12-01 00:00:00 | Opening Balance
1 |  |  | B | 187050.32 | 21683.74 | 33900.99 | -414.6600000000035 | 4959.16 | 34520.12 | 92400.97 |  | 187050.32 | 21683.74 | 33900.99 | 0 | 4959.16 | 34520.12 | 91986.31
2 |  |  | I | 146591.56 | 6532.27 | 10481.14 | 6559.25 | 9092.42 | 8263.54 | 105662.94 |  | 146591.56 | 6532.27 | 10481.14 | 6559.25 | 9092.42 | 8263.54 | 105662.94
3 |  |  | V | 139946.44 | 1611.35 | 1651.78 | 1634.76 | 1617.9 | 23428.43 | 110002.22 |  | 139946.44 | 1611.35 | 1651.78 | 1634.76 | 1617.9 | 23428.43 | 110002.22
4 |  |  | G | 12809.02 | 3533.72 | 3389 | 156.58 | 2823.81 | 3163.22 | -257.3100000000018 |  | 12809.02 | 3533.72 | 3389 | 156.58 | 2823.81 | 2905.909999999998 | 0
5 |  |  | T | 4933.1 | 274.59 | 273.68 | 4384.83 | 191.42 | 643.28 | -834.7 |  | 4933.1 | 274.59 | 273.68 | 4384.83 | 0 | 0 | 0
6 |  |  | X | 405.7000000000046 | -4155.07 | -4015.43 | 8576.2 |  |  |  |  | 405.7000000000007 | 0 | 0 | 405.7000000000007 | 0 | 0 | 0
7 |  |  | Y | 352.0300000000025 | 352.0300000000007 | -1038.69 | 1038.69 |  |  |  |  | 352.0300000000007 | 352.0300000000007 | 0 | 0 | 0 | 0 | 0
8 |  |  | O | 56.34000000000102 | 15.25 | 41.09000000000015 |  | -670.2699999999993 | 1497.56 | -827.2899999999973 |  | 56.34000000000344 | 15.25 | 41.09000000000015 | 0 | 0 | 0 | 3.296918293926865e-12
 |  |  | Sub - Total | 492144.5100000001 | 29847.88 | 44683.56 | 21935.65 | 18014.44 | 71516.15 | 306146.83 |  | 492144.5100000001 | 34002.95 | 49737.67999999999 | 13141.12 | 18493.29 | 69118 | 307651.47
 |  |  |  | 1 | 0.06064860908435206 | 0.09079357605756892 | 0.04457156293382201 | 0.03660396414866031 | 0.1453153465025953 | 0.6220669412730012 |  | 1 | 0.06909139350147377 | 0.1010631613060156 | 0.02670175067075319 | 0.03757695072124242 | 0.1404424891379973 | 0.6251242546625175
9 |  |  | D | -1.479999999994761 | -1.299999999999272 | -0.180000000000291 | 1.392663762089796e-12 | -500 | 711.25 | -334.0499999999963 |  | -124.2799999999945 | -1.299999999999272 | -0.180000000000291 | 1.392663762089796e-12 | -122.7999999999963 | 0 | 0
10 |  |  | X | -173.7399999999946 | -4.259999999998399 | -2.049999999999272 | -125.48 | -5.919999999998254 | 74.51 | -110.5399999999991 |  | -173.739999999995 | -4.259999999998399 | -2.049999999999272 | -125.48 | -5.919999999998254 | 0 | -36.02999999999905
11 |  |  | K | -176.3900000000044 | 240.26 | 2083.35 | -2500 | -968.5400000000026 | 1380.85 | -412.31 |  | -176.390000000003 | 0 | 0 | -176.3900000000003 | 0 | 0 | -2.671640686457977e-12
12 |  |  | X | -249.5200000000046 | -1.818989403545856e-12 | -1.818989403545856e-12 |  | -673.8400000000006 | 875.3899999999991 | -451.07 |  | -249.5200000000015 | 0 | 0 | 0 | -249.5200000000015 | 0 | 0
13 |  |  | N | -260.0800000000046 | -260.0799999999981 | -25454.28 | -7433.38 | 32887.66 |  |  |  | -260.0799999999981 | -260.0799999999981 | 0 | 0 | 0 | 0 | 0
14 |  |  | E | -660.1199999999801 |  |  |  |  |  | -660.1199999999799 |  | -660.1199999999799 | 0 | 0 | 0 | 0 | 0 | -660.1199999999799
15 |  |  | G | -2255.42 | -1127.71 | -1127.71 |  | -234.06 | 154.72 | 79.33999999999764 |  | -2255.420000000002 | -1127.71 | -1127.71 | 0 | 0 | 0 | -2.359001882723533e-12
16 |  |  | H | -2357.49 | -2567.5 | -2568.91 | 294.6500000000005 | -1172.8 | 752.29 | 2904.78 |  | -2357.489999999999 | -2357.489999999999 | 0 | 0 | 0 | 0 | 0
17 |  |  | U | -6152.54 | 6237.52 | -12229.68 | -15024.3 | 14863.92 |  |  |  | -6152.539999999999 | 6237.52 | -12229.68 | -160.3799999999992 | 0 | 0 | 0
 |  |  | Sub - Total | -12286.77999999998 | 2516.930000000003 | -39299.46 | -24788.51 | 44196.42 | 3949.009999999998 | 1016.030000000023 |  | -12409.57999999997 | 2486.680000000005 | -13359.62 | -462.2499999999981 | -378.2399999999961 | 0 | -696.149999999984
 |  |  |  | 1 | -0.2048486259215194 | 3.198515803164055 | 2.017494412693971 | -3.597070998259923 | -0.3214031666555439 | -0.08269294314702665 |  | 1.009994481874013 | -0.2023866301830104 | 1.087316611838091 | 0.03762173653308667 | 0.03078430638458543 | 0 | 0.05665845730126078
 |  |  | TOTAL ARREARS | 479857.7300000001 | 32364.81 | 5384.099999999999 | -2852.860000000001 | 62210.86 | 75465.15999999999 | 307162.86 |  | 479734.9300000001 | 36489.63 | 36378.06 | 12678.87 | 18115.05000000001 | 69118 | 306955.32
 |  |  | TOTAL ARREARS AS A PERCENTAGE | 1 | 0.0674466784144542 | 0.01122020062071314 | -0.005945220471909455 | 0.1296443843886812 | 0.1572656962304222 | 0.6401123516338895 |  | 0.9997440908162509 | 0.0760426012101545 | 0.07581009479622218 | 0.02642214391336365 | 0.03775087670255933 | 0.1440385257522057 | 0.6396798484417453