Skip to content

Instantly share code, notes, and snippets.

@carpii

carpii/gist:6236117

Created August 14, 2013 22:03
Download ZIP

Revisions

  1. carpii created this gist Aug 14, 2013.
    116 changes: 116 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,116 @@
    id effectiveDate daysSinceLastPayment type amount totalPrincipal totalFees totalPayments totalInterest balance
    ----------- ------------------------------------------------------ -------------------- -------------------- -------------- -------------- -------------- -------------- -------------- --------------
    1 2012-11-07 22:58:15.000 NULL PRINCIPAL .00000 .00000 .00000 .00000 .00000 .00000
    2 2012-11-08 22:58:15.000 NULL PRINCIPAL 150.00000 150.00000 .00000 .00000 .00000 150.00000
    3 2012-11-09 22:58:15.000 NULL PRINCIPAL 100.00000 250.00000 .00000 .00000 .00000 250.00000
    4 2012-11-10 22:58:15.000 NULL FEE 35.00000 250.00000 35.00000 .00000 .00000 285.00000
    5 2012-11-11 22:58:15.000 0 PAYMENT 59.40000 225.60000 .00000 59.40000 .00000 225.60000
    6 2012-11-12 22:58:15.000 1 PRINCIPAL 200.00000 425.60000 .00000 59.40000 11.28000 436.88000
    7 2012-11-13 22:58:15.000 2 FEE 35.00000 425.60000 35.00000 59.40000 53.84000 514.44000
    8 2012-11-14 22:58:15.000 0 PAYMENT 78.57000 425.60000 .00000 137.97000 10.27000 435.87000
    9 2012-11-15 22:58:15.000 1 PRINCIPAL 250.00000 675.60000 .00000 137.97000 31.55000 707.15000
    10 2012-11-16 22:58:15.000 2 FEE 35.00000 675.60000 35.00000 137.97000 99.11000 809.71000
    11 2012-11-17 22:58:15.000 0 PAYMENT 92.54000 675.60000 .00000 230.51000 41.57000 717.17000
    12 2012-11-18 22:58:15.000 1 FEE 35.00000 675.60000 35.00000 230.51000 75.35000 785.95000
    13 2012-11-19 22:58:15.000 0 PAYMENT 90.42000 675.60000 .00000 320.93000 19.93000 695.53000
    14 2012-11-20 22:58:15.000 1 FEE 35.00000 675.60000 35.00000 320.93000 53.71000 764.31000
    15 2012-11-21 22:58:15.000 2 PRINCIPAL 50.00000 725.60000 35.00000 320.93000 121.27000 881.87000
    16 2012-11-22 22:58:15.000 3 PRINCIPAL 200.00000 925.60000 35.00000 320.93000 230.11000 1190.71000
    17 2012-11-23 22:58:15.000 0 PAYMENT 87.49000 925.60000 .00000 408.42000 177.62000 1103.22000
    18 2012-11-24 22:58:15.000 1 FEE 35.00000 925.60000 35.00000 408.42000 223.90000 1184.50000
    19 2012-11-25 22:58:15.000 0 PAYMENT 80.78000 925.60000 .00000 489.20000 178.12000 1103.72000
    20 2012-11-26 22:58:15.000 1 FEE 35.00000 925.60000 35.00000 489.20000 224.40000 1185.00000
    21 2012-11-27 22:58:15.000 2 PRINCIPAL 200.00000 1125.60000 35.00000 489.20000 316.96000 1477.56000
    22 2012-11-28 22:58:15.000 0 PAYMENT 80.26000 1125.60000 .00000 569.46000 271.70000 1397.30000
    23 2012-11-29 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 569.46000 327.98000 1488.58000
    24 2012-11-30 22:58:15.000 0 PAYMENT 88.11000 1125.60000 .00000 657.57000 274.87000 1400.47000
    25 2012-12-01 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 657.57000 331.15000 1491.75000
    26 2012-12-02 22:58:15.000 0 PAYMENT 89.80000 1125.60000 .00000 747.37000 276.35000 1401.95000
    27 2012-12-03 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 747.37000 332.63000 1493.23000
    28 2012-12-04 22:58:15.000 0 PAYMENT 80.14000 1125.60000 .00000 827.51000 287.49000 1413.09000
    29 2012-12-05 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 827.51000 343.77000 1504.37000
    30 2012-12-06 22:58:15.000 0 PAYMENT 88.11000 1125.60000 .00000 915.62000 290.66000 1416.26000
    31 2012-12-07 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 915.62000 346.94000 1507.54000
    32 2012-12-08 22:58:15.000 0 PAYMENT 87.23000 1125.60000 .00000 1002.85000 294.71000 1420.31000
    33 2012-12-09 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 1002.85000 350.99000 1511.59000
    34 2012-12-10 22:58:15.000 0 PAYMENT 86.16000 1125.60000 .00000 1089.01000 299.83000 1425.43000
    35 2012-12-11 22:58:15.000 0 PAYMENT 86.16000 1125.60000 .00000 1175.17000 213.67000 1339.27000
    36 2012-12-12 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 1175.17000 269.95000 1430.55000
    37 2012-12-13 22:58:15.000 0 PAYMENT 85.11000 1125.60000 .00000 1260.28000 219.84000 1345.44000
    38 2012-12-14 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 1260.28000 276.12000 1436.72000
    39 2012-12-15 22:58:15.000 0 PAYMENT 84.08000 1125.60000 .00000 1344.36000 227.04000 1352.64000
    40 2012-12-16 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 1344.36000 283.32000 1443.92000
    41 2012-12-17 22:58:15.000 0 PAYMENT 83.07000 1125.60000 .00000 1427.43000 235.25000 1360.85000
    42 2012-12-18 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 1427.43000 291.53000 1452.13000
    43 2012-12-19 22:58:15.000 0 PAYMENT 82.08000 1125.60000 .00000 1509.51000 244.45000 1370.05000
    44 2012-12-20 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 1509.51000 300.73000 1461.33000
    45 2012-12-21 22:58:15.000 0 PAYMENT 81.11000 1125.60000 .00000 1590.62000 254.62000 1380.22000
    46 2012-12-22 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 1590.62000 310.90000 1471.50000
    47 2012-12-23 22:58:15.000 0 PAYMENT 80.17000 1125.60000 .00000 1670.79000 265.73000 1391.33000
    48 2012-12-24 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 1670.79000 322.01000 1482.61000
    49 2012-12-25 22:58:15.000 0 PAYMENT 79.24000 1125.60000 .00000 1750.03000 277.77000 1403.37000
    50 2012-12-26 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 1750.03000 334.05000 1494.65000
    51 2012-12-27 22:58:15.000 0 PAYMENT 78.33000 1125.60000 .00000 1828.36000 290.72000 1416.32000
    52 2012-12-28 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 1828.36000 347.00000 1507.60000
    53 2012-12-29 22:58:15.000 0 PAYMENT 74.52000 1125.60000 .00000 1902.88000 307.48000 1433.08000
    54 2012-12-30 22:58:15.000 1 FEE 25.00000 1125.60000 25.00000 1902.88000 363.76000 1514.36000
    55 2012-12-31 22:58:15.000 0 PAYMENT 99.52000 1125.60000 .00000 2002.40000 289.24000 1414.84000
    56 2013-01-01 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 2002.40000 345.52000 1506.12000
    57 2013-01-02 22:58:15.000 0 PAYMENT 104.70000 1125.60000 .00000 2107.10000 275.82000 1401.42000
    58 2013-01-03 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 2107.10000 332.10000 1492.70000
    59 2013-01-04 22:58:15.000 0 PAYMENT 75.10000 1125.60000 .00000 2182.20000 292.00000 1417.60000
    60 2013-01-05 22:58:15.000 1 FEE 35.00000 1125.60000 35.00000 2182.20000 348.28000 1508.88000
    61 2013-01-06 22:58:15.000 2 PRINCIPAL 300.00000 1425.60000 35.00000 2182.20000 460.84000 1921.44000
    62 2013-01-07 22:58:15.000 0 PAYMENT 73.45000 1425.60000 .00000 2255.65000 422.39000 1847.99000
    63 2013-01-08 22:58:15.000 1 FEE 35.00000 1425.60000 35.00000 2255.65000 493.67000 1954.27000
    64 2013-01-09 22:58:15.000 0 PAYMENT 84.05000 1425.60000 .00000 2339.70000 444.62000 1870.22000
    65 2013-01-10 22:58:15.000 1 FEE 35.00000 1425.60000 35.00000 2339.70000 515.90000 1976.50000
    66 2013-01-11 22:58:15.000 2 FEE 35.00000 1425.60000 70.00000 2339.70000 658.46000 2154.06000
    67 2013-01-12 22:58:15.000 0 PAYMENT 86.22000 1425.60000 .00000 2425.92000 642.24000 2067.84000
    68 2013-01-13 22:58:15.000 1 FEE 35.00000 1425.60000 35.00000 2425.92000 713.52000 2174.12000
    69 2013-01-14 22:58:15.000 0 PAYMENT 81.85000 1425.60000 .00000 2507.77000 666.67000 2092.27000
    70 2013-01-15 22:58:15.000 1 FEE 35.00000 1425.60000 35.00000 2507.77000 737.95000 2198.55000
    71 2013-01-16 22:58:15.000 0 PAYMENT 87.39000 1425.60000 .00000 2595.16000 685.56000 2111.16000
    72 2013-01-17 22:58:15.000 1 FEE 35.00000 1425.60000 35.00000 2595.16000 756.84000 2217.44000
    73 2013-01-18 22:58:15.000 0 PAYMENT 83.05000 1425.60000 .00000 2678.21000 708.79000 2134.39000
    74 2013-01-19 22:58:15.000 1 FEE 35.00000 1425.60000 35.00000 2678.21000 780.07000 2240.67000
    75 2013-01-20 22:58:15.000 2 PRINCIPAL 100.00000 1525.60000 35.00000 2678.21000 922.63000 2483.23000
    76 2013-01-21 22:58:15.000 0 PAYMENT 82.00000 1525.60000 .00000 2760.21000 875.63000 2401.23000
    77 2013-01-22 22:58:15.000 1 FEE 35.00000 1525.60000 35.00000 2760.21000 951.91000 2512.51000
    78 2013-01-23 22:58:15.000 0 PAYMENT 84.99000 1525.60000 .00000 2845.20000 901.92000 2427.52000
    79 2013-01-24 22:58:15.000 1 FEE 35.00000 1525.60000 35.00000 2845.20000 978.20000 2538.80000
    80 2013-01-25 22:58:15.000 0 PAYMENT 84.77000 1525.60000 .00000 2929.97000 928.43000 2454.03000
    81 2013-01-26 22:58:15.000 1 FEE 35.00000 1525.60000 35.00000 2929.97000 1004.71000 2565.31000
    82 2013-01-27 22:58:15.000 0 PAYMENT 83.69000 1525.60000 .00000 3013.66000 956.02000 2481.62000
    83 2013-01-28 22:58:15.000 1 FEE 35.00000 1525.60000 35.00000 3013.66000 1032.30000 2592.90000
    84 2013-01-29 22:58:15.000 0 PAYMENT 79.49000 1525.60000 .00000 3093.15000 987.81000 2513.41000
    85 2013-01-30 22:58:15.000 1 FEE 25.00000 1525.60000 25.00000 3093.15000 1064.09000 2614.69000
    86 2013-01-31 22:58:15.000 2 FEE 35.00000 1525.60000 60.00000 3093.15000 1216.65000 2802.25000
    87 2013-02-01 22:58:15.000 3 FEE 30.00000 1525.60000 90.00000 3093.15000 1445.49000 3061.09000
    88 2013-02-02 22:58:15.000 0 PAYMENT 219.75000 1525.60000 .00000 3312.90000 1315.74000 2841.34000
    89 2013-02-03 22:58:15.000 1 FEE 35.00000 1525.60000 35.00000 3312.90000 1392.02000 2952.62000
    90 2013-02-04 22:58:15.000 2 FEE 35.00000 1525.60000 70.00000 3312.90000 1544.58000 3140.18000
    91 2013-02-05 22:58:15.000 0 PAYMENT 81.02000 1525.60000 .00000 3393.92000 1533.56000 3059.16000
    92 2013-02-06 22:58:15.000 1 FEE 35.00000 1525.60000 35.00000 3393.92000 1609.84000 3170.44000
    93 2013-02-07 22:58:15.000 0 PAYMENT 79.51000 1525.60000 .00000 3473.43000 1565.33000 3090.93000
    94 2013-02-08 22:58:15.000 1 FEE 35.00000 1525.60000 35.00000 3473.43000 1641.61000 3202.21000
    95 2013-02-09 22:58:15.000 2 PRINCIPAL 150.00000 1675.60000 35.00000 3473.43000 1794.17000 3504.77000
    96 2013-02-10 22:58:15.000 0 PAYMENT 75.66000 1675.60000 .00000 3549.09000 1753.51000 3429.11000
    97 2013-02-11 22:58:15.000 1 FEE 35.00000 1675.60000 35.00000 3549.09000 1837.29000 3547.89000
    98 2013-02-12 22:58:15.000 0 PAYMENT 86.63000 1675.60000 .00000 3635.72000 1785.66000 3461.26000
    99 2013-02-13 22:58:15.000 1 FEE 35.00000 1675.60000 35.00000 3635.72000 1869.44000 3580.04000
    100 2013-02-14 22:58:15.000 0 PAYMENT 80.61000 1675.60000 .00000 3716.33000 1823.83000 3499.43000
    101 2013-02-15 22:58:15.000 1 FEE 35.00000 1675.60000 35.00000 3716.33000 1907.61000 3618.21000
    102 2013-02-16 22:58:15.000 0 PAYMENT 85.80000 1675.60000 .00000 3802.13000 1856.81000 3532.41000
    103 2013-02-17 22:58:15.000 1 FEE 35.00000 1675.60000 35.00000 3802.13000 1940.59000 3651.19000
    104 2013-02-18 22:58:15.000 0 PAYMENT 81.62000 1675.60000 .00000 3883.75000 1893.97000 3569.57000
    105 2013-02-19 22:58:15.000 1 FEE 25.00000 1675.60000 25.00000 3883.75000 1977.75000 3678.35000
    106 2013-02-20 22:58:15.000 2 FEE 35.00000 1675.60000 60.00000 3883.75000 2145.31000 3880.91000
    107 2013-02-21 22:58:15.000 3 FEE 30.00000 1675.60000 90.00000 3883.75000 2396.65000 4162.25000
    108 2013-02-22 22:58:15.000 0 PAYMENT 217.75000 1675.60000 .00000 4101.50000 2268.90000 3944.50000
    109 2013-02-23 22:58:15.000 1 FEE 25.00000 1675.60000 25.00000 4101.50000 2352.68000 4053.28000
    110 2013-02-24 22:58:15.000 2 FEE 35.00000 1675.60000 60.00000 4101.50000 2520.24000 4255.84000
    111 2013-02-25 22:58:15.000 3 FEE 30.00000 1675.60000 90.00000 4101.50000 2771.58000 4537.18000
    112 2013-02-26 22:58:15.000 4 FEE 40.00000 1675.60000 130.00000 4101.50000 3106.70000 4912.30000
    113 2013-02-27 22:58:15.000 0 PAYMENT 93.87000 1675.60000 36.13000 4195.37000 3106.70000 4818.43000