Docstoc

Excel Skills Loan Amortization Template

Document Sample
Excel Skills Loan Amortization Template Powered By Docstoc
					Loan Amortization Table                                                                                           www.excel-skills.com

Loan Principle Amount       1,000,000.00
Annual Interest Rate               10.00%
Loan Period (in months)            240.00
Original Repayment Amount        9,650.22
Loan Start Date                 8/15/2009
Repayment Type                  End


               Repayment     Opening            Loan          Interest      Capital       Closing         % Capital
   Month        Number       Balance         Repayment       Charged        Repaid        Balance        Outstanding     Interest Rate
   Aug-2009         1         1,000,000.00        9,983.80       8,750.00      1,233.80     998,766.20          99.9%           10.50%
   Sep-2009         2           998,766.20        9,983.80       8,739.20      1,244.59     997,521.61          99.8%           10.50%
   Oct-2009         3           997,521.61        9,983.80       8,728.31      1,255.48     996,266.12          99.6%           10.50%
   Nov-2009         4           996,266.12        9,983.80       8,717.33      1,266.47     994,999.65          99.5%           10.50%
   Dec-2009         5           994,999.65        9,983.80       8,706.25      1,277.55     993,722.10          99.4%           10.50%
   Jan-2010         6           993,722.10        9,983.80       8,695.07      1,288.73     992,433.37          99.2%           10.50%
   Feb-2010         7           992,433.37        9,983.80       8,683.79      1,300.01     991,133.36          99.1%           10.50%
   Mar-2010         8           991,133.36        9,655.92       8,259.44      1,396.47     989,736.89          99.0%           10.00%
   Apr-2010         9           989,736.89        9,655.92       8,247.81      1,408.11     988,328.78          98.8%           10.00%
   May-2010        10           988,328.78        9,655.92       8,236.07      1,419.84     986,908.93          98.7%           10.00%
   Jun-2010        11           986,908.93        9,655.92       8,224.24      1,431.68     985,477.26          98.5%           10.00%
    Jul-2010       12           985,477.26        9,655.92       8,212.31      1,443.61     984,033.65          98.4%           10.00%
   Aug-2010        13           984,033.65        9,655.92       8,200.28      1,455.64     982,578.01          98.3%           10.00%
   Sep-2010        14           982,578.01        9,655.92       8,188.15      1,467.77     981,110.24          98.1%           10.00%
   Oct-2010        15           981,110.24        9,655.92       8,175.92      1,480.00     979,630.24          98.0%           10.00%
   Nov-2010        16           979,630.24        9,655.92       8,163.59      1,492.33     978,137.91          97.8%           10.00%
   Dec-2010        17           978,137.91        9,655.92       8,151.15      1,504.77     976,633.14          97.7%           10.00%
   Jan-2011        18           976,633.14        9,655.92       8,138.61      1,517.31     975,115.84          97.5%           10.00%
   Feb-2011        19           975,115.84        9,655.92       8,125.97      1,529.95     973,585.88          97.4%           10.00%
   Mar-2011        20           973,585.88       10,294.85       8,924.54      1,370.31     972,215.57          97.2%           11.00%
   Apr-2011        21           972,215.57       10,294.85       8,911.98      1,382.87     970,832.70          97.1%           11.00%
   May-2011        22           970,832.70       10,294.85       8,899.30      1,395.55     969,437.15          96.9%           11.00%
   Jun-2011        23           969,437.15       10,294.85       8,886.51      1,408.34     968,028.80          96.8%           11.00%
    Jul-2011       24           968,028.80       10,294.85       8,873.60      1,421.25     966,607.55          96.7%           11.00%
   Aug-2011        25           966,607.55       10,294.85       8,860.57      1,434.28     965,173.27          96.5%           11.00%
   Sep-2011        26           965,173.27       10,294.85       8,847.42      1,447.43     963,725.84          96.4%           11.00%
   Oct-2011        27           963,725.84       10,294.85       8,834.15      1,460.70     962,265.14          96.2%           11.00%
   Nov-2011        28           962,265.14       10,294.85       8,820.76      1,474.09     960,791.06          96.1%           11.00%
   Dec-2011        29           960,791.06       10,294.85       8,807.25      1,487.60     959,303.46          95.9%           11.00%
   Jan-2012        30           959,303.46       10,294.85       8,793.62      1,501.24     957,802.22          95.8%           11.00%
   Feb-2012        31           957,802.22       10,294.85       8,779.85      1,515.00     956,287.23          95.6%           11.00%
   Mar-2012        32           956,287.23       10,294.85       8,765.97      1,528.88     954,758.34          95.5%           11.00%
   Apr-2012        33           954,758.34       10,294.85       8,751.95      1,542.90     953,215.44          95.3%           11.00%
   May-2012        34           953,215.44       10,294.85       8,737.81      1,557.04     951,658.40          95.2%           11.00%
   Jun-2012        35           951,658.40       10,294.85       8,723.54      1,571.31     950,087.09          95.0%           11.00%
    Jul-2012       36           950,087.09       10,294.85       8,709.13      1,585.72     948,501.37          94.9%           11.00%
   Aug-2012        37           948,501.37       10,294.85       8,694.60      1,600.25     946,901.11          94.7%           11.00%
   Sep-2012        38           946,901.11       10,294.85       8,679.93      1,614.92     945,286.19          94.5%           11.00%
   Oct-2012        39           945,286.19       10,294.85       8,665.12      1,629.73     943,656.46          94.4%           11.00%
   Nov-2012        40           943,656.46       10,294.85       8,650.18      1,644.67     942,011.80          94.2%           11.00%
   Dec-2012        41           942,011.80       10,294.85       8,635.11      1,659.74     940,352.05          94.0%           11.00%
   Jan-2013        42           940,352.05       10,294.85       8,619.89      1,674.96     938,677.10          93.9%           11.00%
   Feb-2013        43           938,677.10       10,294.85       8,604.54      1,690.31     936,986.79          93.7%           11.00%
   Mar-2013        44           936,986.79       10,294.85       8,589.05      1,705.80     935,280.98          93.5%           11.00%
   Apr-2013        45           935,280.98       10,294.85       8,573.41      1,721.44     933,559.54          93.4%           11.00%
   May-2013        46           933,559.54       10,294.85       8,557.63      1,737.22     931,822.32          93.2%           11.00%
   Jun-2013        47           931,822.32       10,294.85       8,541.70      1,753.15     930,069.18          93.0%           11.00%
    Jul-2013       48           930,069.18       10,294.85       8,525.63      1,769.22     928,299.96          92.8%           11.00%
   Aug-2013        49           928,299.96       10,294.85       8,509.42      1,785.43     926,514.53          92.7%           11.00%
   Sep-2013        50           926,514.53       10,294.85       8,493.05      1,801.80     924,712.72          92.5%           11.00%
   Oct-2013        51           924,712.72       10,294.85       8,476.53      1,818.32     922,894.41          92.3%           11.00%
   Nov-2013        52           922,894.41       10,294.85       8,459.87      1,834.98     921,059.42          92.1%           11.00%
   Dec-2013        53           921,059.42       10,294.85       8,443.04      1,851.81     919,207.62          91.9%           11.00%
   Jan-2014        54           919,207.62       10,294.85       8,426.07      1,868.78     917,338.84          91.7%           11.00%
   Feb-2014        55           917,338.84       10,294.85       8,408.94      1,885.91     915,452.93          91.5%           11.00%
   Mar-2014        56           915,452.93       10,294.85       8,391.65      1,903.20     913,549.73          91.4%           11.00%
   Apr-2014        57           913,549.73       10,294.85       8,374.21      1,920.64     911,629.08          91.2%           11.00%
   May-2014        58           911,629.08       10,294.85       8,356.60      1,938.25     909,690.83          91.0%           11.00%
   Jun-2014        59           909,690.83       10,294.85       8,338.83      1,956.02     907,734.82          90.8%           11.00%




                                                              Page 1 of 8
Loan Amortization Table                                                                                           www.excel-skills.com

Loan Principle Amount       1,000,000.00
Annual Interest Rate               10.00%
Loan Period (in months)            240.00
Original Repayment Amount        9,650.22
Loan Start Date                 8/15/2009
Repayment Type                  End


               Repayment     Opening            Loan          Interest      Capital       Closing         % Capital
   Month        Number       Balance         Repayment       Charged        Repaid        Balance        Outstanding     Interest Rate
    Jul-2014       60           907,734.82       10,294.85       8,320.90      1,973.95     905,760.87          90.6%           11.00%
   Aug-2014        61           905,760.87       10,294.85       8,302.81      1,992.04     903,768.83          90.4%           11.00%
   Sep-2014        62           903,768.83       10,294.85       8,284.55      2,010.30     901,758.52          90.2%           11.00%
   Oct-2014        63           901,758.52       10,294.85       8,266.12      2,028.73     899,729.79          90.0%           11.00%
   Nov-2014        64           899,729.79       10,294.85       8,247.52      2,047.33     897,682.46          89.8%           11.00%
   Dec-2014        65           897,682.46       10,294.85       8,228.76      2,066.09     895,616.37          89.6%           11.00%
   Jan-2015        66           895,616.37       10,294.85       8,209.82      2,085.03     893,531.34          89.4%           11.00%
   Feb-2015        67           893,531.34       10,294.85       8,190.70      2,104.15     891,427.19          89.1%           11.00%
   Mar-2015        68           891,427.19       10,294.85       8,171.42      2,123.43     889,303.76          88.9%           11.00%
   Apr-2015        69           889,303.76       10,294.85       8,151.95      2,142.90     887,160.86          88.7%           11.00%
   May-2015        70           887,160.86       10,294.85       8,132.31      2,162.54     884,998.31          88.5%           11.00%
   Jun-2015        71           884,998.31       10,294.85       8,112.48      2,182.37     882,815.95          88.3%           11.00%
    Jul-2015       72           882,815.95       10,294.85       8,092.48      2,202.37     880,613.58          88.1%           11.00%
   Aug-2015        73           880,613.58       10,294.85       8,072.29      2,222.56     878,391.02          87.8%           11.00%
   Sep-2015        74           878,391.02       10,294.85       8,051.92      2,242.93     876,148.09          87.6%           11.00%
   Oct-2015        75           876,148.09       10,294.85       8,031.36      2,263.49     873,884.59          87.4%           11.00%
   Nov-2015        76           873,884.59       10,294.85       8,010.61      2,284.24     871,600.35          87.2%           11.00%
   Dec-2015        77           871,600.35       10,294.85       7,989.67      2,305.18     869,295.17          86.9%           11.00%
   Jan-2016        78           869,295.17       10,294.85       7,968.54      2,326.31     866,968.86          86.7%           11.00%
   Feb-2016        79           866,968.86       10,294.85       7,947.21      2,347.64     864,621.23          86.5%           11.00%
   Mar-2016        80           864,621.23       10,294.85       7,925.69      2,369.16     862,252.07          86.2%           11.00%
   Apr-2016        81           862,252.07       10,294.85       7,903.98      2,390.87     859,861.20          86.0%           11.00%
   May-2016        82           859,861.20       10,294.85       7,882.06      2,412.79     857,448.41          85.7%           11.00%
   Jun-2016        83           857,448.41       10,294.85       7,859.94      2,434.91     855,013.50          85.5%           11.00%
    Jul-2016       84           855,013.50       10,294.85       7,837.62      2,457.23     852,556.27          85.3%           11.00%
   Aug-2016        85           852,556.27       10,294.85       7,815.10      2,479.75     850,076.52          85.0%           11.00%
   Sep-2016        86           850,076.52       10,294.85       7,792.37      2,502.48     847,574.04          84.8%           11.00%
   Oct-2016        87           847,574.04       10,294.85       7,769.43      2,525.42     845,048.62          84.5%           11.00%
   Nov-2016        88           845,048.62       10,294.85       7,746.28      2,548.57     842,500.05          84.3%           11.00%
   Dec-2016        89           842,500.05       10,294.85       7,722.92      2,571.93     839,928.11          84.0%           11.00%
   Jan-2017        90           839,928.11       10,294.85       7,699.34      2,595.51     837,332.61          83.7%           11.00%
   Feb-2017        91           837,332.61       10,294.85       7,675.55      2,619.30     834,713.30          83.5%           11.00%
   Mar-2017        92           834,713.30       10,294.85       7,651.54      2,643.31     832,069.99          83.2%           11.00%
   Apr-2017        93           832,069.99       10,294.85       7,627.31      2,667.54     829,402.45          82.9%           11.00%
   May-2017        94           829,402.45       10,294.85       7,602.86      2,691.99     826,710.46          82.7%           11.00%
   Jun-2017        95           826,710.46       10,294.85       7,578.18      2,716.67     823,993.79          82.4%           11.00%
    Jul-2017       96           823,993.79       10,294.85       7,553.28      2,741.57     821,252.21          82.1%           11.00%
   Aug-2017        97           821,252.21       10,294.85       7,528.15      2,766.70     818,485.51          81.8%           11.00%
   Sep-2017        98           818,485.51       10,294.85       7,502.78      2,792.07     815,693.44          81.6%           11.00%
   Oct-2017        99           815,693.44       10,294.85       7,477.19      2,817.66     812,875.78          81.3%           11.00%
   Nov-2017        100          812,875.78       10,294.85       7,451.36      2,843.49     810,032.29          81.0%           11.00%
   Dec-2017        101          810,032.29       10,294.85       7,425.30      2,869.55     807,162.74          80.7%           11.00%
   Jan-2018        102          807,162.74       10,294.85       7,398.99      2,895.86     804,266.88          80.4%           11.00%
   Feb-2018        103          804,266.88       10,294.85       7,372.45      2,922.40     801,344.47          80.1%           11.00%
   Mar-2018        104          801,344.47       10,294.85       7,345.66      2,949.19     798,395.28          79.8%           11.00%
   Apr-2018        105          798,395.28       10,294.85       7,318.62      2,976.23     795,419.05          79.5%           11.00%
   May-2018        106          795,419.05       10,294.85       7,291.34      3,003.51     792,415.55          79.2%           11.00%
   Jun-2018        107          792,415.55       10,294.85       7,263.81      3,031.04     789,384.50          78.9%           11.00%
    Jul-2018       108          789,384.50       10,294.85       7,236.02      3,058.83     786,325.68          78.6%           11.00%
   Aug-2018        109          786,325.68       10,294.85       7,207.99      3,086.86     783,238.81          78.3%           11.00%
   Sep-2018        110          783,238.81       10,294.85       7,179.69      3,115.16     780,123.65          78.0%           11.00%
   Oct-2018        111          780,123.65       10,294.85       7,151.13      3,143.72     776,979.94          77.7%           11.00%
   Nov-2018        112          776,979.94       10,294.85       7,122.32      3,172.53     773,807.40          77.4%           11.00%
   Dec-2018        113          773,807.40       10,294.85       7,093.23      3,201.62     770,605.79          77.1%           11.00%
   Jan-2019        114          770,605.79       10,294.85       7,063.89      3,230.96     767,374.82          76.7%           11.00%
   Feb-2019        115          767,374.82       10,294.85       7,034.27      3,260.58     764,114.24          76.4%           11.00%
   Mar-2019        116          764,114.24       10,294.85       7,004.38      3,290.47     760,823.77          76.1%           11.00%
   Apr-2019        117          760,823.77       10,294.85       6,974.22      3,320.63     757,503.14          75.8%           11.00%
   May-2019        118          757,503.14       10,294.85       6,943.78      3,351.07     754,152.07          75.4%           11.00%




                                                              Page 2 of 8
Loan Amortization Table                                                                                           www.excel-skills.com

Loan Principle Amount       1,000,000.00
Annual Interest Rate               10.00%
Loan Period (in months)            240.00
Original Repayment Amount        9,650.22
Loan Start Date                 8/15/2009
Repayment Type                  End


               Repayment     Opening            Loan          Interest      Capital       Closing         % Capital
   Month        Number       Balance         Repayment       Charged        Repaid        Balance        Outstanding     Interest Rate
   Jun-2019        119          754,152.07       10,294.85       6,913.06      3,381.79     750,770.28          75.1%           11.00%
    Jul-2019       120          750,770.28       10,294.85       6,882.06      3,412.79     747,357.49          74.7%           11.00%
   Aug-2019        121          747,357.49       10,294.85       6,850.78      3,444.07     743,913.42          74.4%           11.00%
   Sep-2019        122          743,913.42       10,294.85       6,819.21      3,475.64     740,437.77          74.0%           11.00%
   Oct-2019        123          740,437.77       10,294.85       6,787.35      3,507.50     736,930.27          73.7%           11.00%
   Nov-2019        124          736,930.27       10,294.85       6,755.19      3,539.66     733,390.61          73.3%           11.00%
   Dec-2019        125          733,390.61       10,294.85       6,722.75      3,572.10     729,818.51          73.0%           11.00%
   Jan-2020        126          729,818.51       10,294.85       6,690.00      3,604.85     726,213.66          72.6%           11.00%
   Feb-2020        127          726,213.66       10,294.85       6,656.96      3,637.89     722,575.77          72.3%           11.00%
   Mar-2020        128          722,575.77       10,294.85       6,623.61      3,671.24     718,904.53          71.9%           11.00%
   Apr-2020        129          718,904.53       10,294.85       6,589.96      3,704.89     715,199.64          71.5%           11.00%
   May-2020        130          715,199.64       10,294.85       6,556.00      3,738.85     711,460.78          71.1%           11.00%
   Jun-2020        131          711,460.78       10,294.85       6,521.72      3,773.13     707,687.66          70.8%           11.00%
    Jul-2020       132          707,687.66       10,294.85       6,487.14      3,807.71     703,879.95          70.4%           11.00%
   Aug-2020        133          703,879.95       10,294.85       6,452.23      3,842.62     700,037.33          70.0%           11.00%
   Sep-2020        134          700,037.33       10,294.85       6,417.01      3,877.84     696,159.49          69.6%           11.00%
   Oct-2020        135          696,159.49       10,294.85       6,381.46      3,913.39     692,246.10          69.2%           11.00%
   Nov-2020        136          692,246.10       10,294.85       6,345.59      3,949.26     688,296.84          68.8%           11.00%
   Dec-2020        137          688,296.84       10,294.85       6,309.39      3,985.46     684,311.37          68.4%           11.00%
   Jan-2021        138          684,311.37       10,294.85       6,272.85      4,022.00     680,289.38          68.0%           11.00%
   Feb-2021        139          680,289.38       10,294.85       6,235.99      4,058.86     676,230.51          67.6%           11.00%
   Mar-2021        140          676,230.51       10,294.85       6,198.78      4,096.07     672,134.44          67.2%           11.00%
   Apr-2021        141          672,134.44       10,294.85       6,161.23      4,133.62     668,000.83          66.8%           11.00%
   May-2021        142          668,000.83       10,294.85       6,123.34      4,171.51     663,829.32          66.4%           11.00%
   Jun-2021        143          663,829.32       10,294.85       6,085.10      4,209.75     659,619.57          66.0%           11.00%
    Jul-2021       144          659,619.57       10,294.85       6,046.51      4,248.34     655,371.23          65.5%           11.00%
   Aug-2021        145          655,371.23       10,294.85       6,007.57      4,287.28     651,083.95          65.1%           11.00%
   Sep-2021        146          651,083.95       10,294.85       5,968.27      4,326.58     646,757.37          64.7%           11.00%
   Oct-2021        147          646,757.37       10,294.85       5,928.61      4,366.24     642,391.13          64.2%           11.00%
   Nov-2021        148          642,391.13       10,294.85       5,888.59      4,406.26     637,984.86          63.8%           11.00%
   Dec-2021        149          637,984.86       10,294.85       5,848.19      4,446.66     633,538.21          63.4%           11.00%
   Jan-2022        150          633,538.21       10,294.85       5,807.43      4,487.42     629,050.79          62.9%           11.00%
   Feb-2022        151          629,050.79       10,294.85       5,766.30      4,528.55     624,522.24          62.5%           11.00%
   Mar-2022        152          624,522.24       10,294.85       5,724.79      4,570.06     619,952.18          62.0%           11.00%
   Apr-2022        153          619,952.18       10,294.85       5,682.89      4,611.96     615,340.22          61.5%           11.00%
   May-2022        154          615,340.22       10,294.85       5,640.62      4,654.23     610,685.99          61.1%           11.00%
   Jun-2022        155          610,685.99       10,294.85       5,597.95      4,696.90     605,989.09          60.6%           11.00%
    Jul-2022       156          605,989.09       10,294.85       5,554.90      4,739.95     601,249.14          60.1%           11.00%
   Aug-2022        157          601,249.14       10,294.85       5,511.45      4,783.40     596,465.74          59.6%           11.00%
   Sep-2022        158          596,465.74       10,294.85       5,467.60      4,827.25     591,638.50          59.2%           11.00%
   Oct-2022        159          591,638.50       10,294.85       5,423.35      4,871.50     586,767.00          58.7%           11.00%
   Nov-2022        160          586,767.00       10,294.85       5,378.70      4,916.15     581,850.85          58.2%           11.00%
   Dec-2022        161          581,850.85       10,294.85       5,333.63      4,961.22     576,889.63          57.7%           11.00%
   Jan-2023        162          576,889.63       10,294.85       5,288.15      5,006.70     571,882.93          57.2%           11.00%
   Feb-2023        163          571,882.93       10,294.85       5,242.26      5,052.59     566,830.34          56.7%           11.00%
   Mar-2023        164          566,830.34       10,294.85       5,195.94      5,098.91     561,731.44          56.2%           11.00%
   Apr-2023        165          561,731.44       10,294.85       5,149.20      5,145.65     556,585.79          55.7%           11.00%
   May-2023        166          556,585.79       10,294.85       5,102.04      5,192.81     551,392.98          55.1%           11.00%
   Jun-2023        167          551,392.98       10,294.85       5,054.44      5,240.41     546,152.56          54.6%           11.00%
    Jul-2023       168          546,152.56       10,294.85       5,006.40      5,288.45     540,864.11          54.1%           11.00%
   Aug-2023        169          540,864.11       10,294.85       4,957.92      5,336.93     535,527.18          53.6%           11.00%
   Sep-2023        170          535,527.18       10,294.85       4,909.00      5,385.85     530,141.33          53.0%           11.00%
   Oct-2023        171          530,141.33       10,294.85       4,859.63      5,435.22     524,706.11          52.5%           11.00%
   Nov-2023        172          524,706.11       10,294.85       4,809.81      5,485.04     519,221.07          51.9%           11.00%
   Dec-2023        173          519,221.07       10,294.85       4,759.53      5,535.32     513,685.74          51.4%           11.00%
   Jan-2024        174          513,685.74       10,294.85       4,708.79      5,586.06     508,099.68          50.8%           11.00%
   Feb-2024        175          508,099.68       10,294.85       4,657.58      5,637.27     502,462.41          50.2%           11.00%
   Mar-2024        176          502,462.41       10,294.85       4,605.91      5,688.94     496,773.46          49.7%           11.00%
   Apr-2024        177          496,773.46       10,294.85       4,553.76      5,741.09     491,032.37          49.1%           11.00%




                                                              Page 3 of 8
Loan Amortization Table                                                                                           www.excel-skills.com

Loan Principle Amount       1,000,000.00
Annual Interest Rate               10.00%
Loan Period (in months)            240.00
Original Repayment Amount        9,650.22
Loan Start Date                 8/15/2009
Repayment Type                  End


               Repayment     Opening            Loan          Interest      Capital       Closing         % Capital
   Month        Number       Balance         Repayment       Charged        Repaid        Balance        Outstanding     Interest Rate
   May-2024        178          491,032.37       10,294.85       4,501.13      5,793.72     485,238.65          48.5%           11.00%
   Jun-2024        179          485,238.65       10,294.85       4,448.02      5,846.83     479,391.82          47.9%           11.00%
    Jul-2024       180          479,391.82       10,294.85       4,394.43      5,900.43     473,491.40          47.3%           11.00%
   Aug-2024        181          473,491.40       10,294.85       4,340.34      5,954.51     467,536.88          46.8%           11.00%
   Sep-2024        182          467,536.88       10,294.85       4,285.75      6,009.10     461,527.79          46.2%           11.00%
   Oct-2024        183          461,527.79       10,294.85       4,230.67      6,064.18     455,463.61          45.5%           11.00%
   Nov-2024        184          455,463.61       10,294.85       4,175.08      6,119.77     449,343.84          44.9%           11.00%
   Dec-2024        185          449,343.84       10,294.85       4,118.99      6,175.87     443,167.98          44.3%           11.00%
   Jan-2025        186          443,167.98       10,294.85       4,062.37      6,232.48     436,935.50          43.7%           11.00%
   Feb-2025        187          436,935.50       10,294.85       4,005.24      6,289.61     430,645.89          43.1%           11.00%
   Mar-2025        188          430,645.89       10,294.85       3,947.59      6,347.26     424,298.63          42.4%           11.00%
   Apr-2025        189          424,298.63       10,294.85       3,889.40      6,405.45     417,893.18          41.8%           11.00%
   May-2025        190          417,893.18       10,294.85       3,830.69      6,464.16     411,429.02          41.1%           11.00%
   Jun-2025        191          411,429.02       10,294.85       3,771.43      6,523.42     404,905.60          40.5%           11.00%
    Jul-2025       192          404,905.60       10,294.85       3,711.63      6,583.22     398,322.39          39.8%           11.00%
   Aug-2025        193          398,322.39       10,294.85       3,651.29      6,643.56     391,678.83          39.2%           11.00%
   Sep-2025        194          391,678.83       10,294.85       3,590.39      6,704.46     384,974.36          38.5%           11.00%
   Oct-2025        195          384,974.36       10,294.85       3,528.93      6,765.92     378,208.45          37.8%           11.00%
   Nov-2025        196          378,208.45       10,294.85       3,466.91      6,827.94     371,380.51          37.1%           11.00%
   Dec-2025        197          371,380.51       10,294.85       3,404.32      6,890.53     364,489.98          36.4%           11.00%
   Jan-2026        198          364,489.98       10,294.85       3,341.16      6,953.69     357,536.28          35.8%           11.00%
   Feb-2026        199          357,536.28       10,294.85       3,277.42      7,017.43     350,518.85          35.1%           11.00%
   Mar-2026        200          350,518.85       10,294.85       3,213.09      7,081.76     343,437.09          34.3%           11.00%
   Apr-2026        201          343,437.09       10,294.85       3,148.17      7,146.68     336,290.41          33.6%           11.00%
   May-2026        202          336,290.41       10,294.85       3,082.66      7,212.19     329,078.22          32.9%           11.00%
   Jun-2026        203          329,078.22       10,294.85       3,016.55      7,278.30     321,799.92          32.2%           11.00%
    Jul-2026       204          321,799.92       10,294.85       2,949.83      7,345.02     314,454.91          31.4%           11.00%
   Aug-2026        205          314,454.91       10,294.85       2,882.50      7,412.35     307,042.56          30.7%           11.00%
   Sep-2026        206          307,042.56       10,294.85       2,814.56      7,480.29     299,562.27          30.0%           11.00%
   Oct-2026        207          299,562.27       10,294.85       2,745.99      7,548.86     292,013.40          29.2%           11.00%
   Nov-2026        208          292,013.40       10,294.85       2,676.79      7,618.06     284,395.34          28.4%           11.00%
   Dec-2026        209          284,395.34       10,294.85       2,606.96      7,687.89     276,707.45          27.7%           11.00%
   Jan-2027        210          276,707.45       10,294.85       2,536.48      7,758.37     268,949.09          26.9%           11.00%
   Feb-2027        211          268,949.09       10,294.85       2,465.37      7,829.48     261,119.60          26.1%           11.00%
   Mar-2027        212          261,119.60       10,294.85       2,393.60      7,901.25     253,218.35          25.3%           11.00%
   Apr-2027        213          253,218.35       10,294.85       2,321.17      7,973.68     245,244.67          24.5%           11.00%
   May-2027        214          245,244.67       10,294.85       2,248.08      8,046.77     237,197.89          23.7%           11.00%
   Jun-2027        215          237,197.89       10,294.85       2,174.31      8,120.54     229,077.36          22.9%           11.00%
    Jul-2027       216          229,077.36       10,294.85       2,099.88      8,194.97     220,882.38          22.1%           11.00%
   Aug-2027        217          220,882.38       10,294.85       2,024.76      8,270.10     212,612.29          21.3%           11.00%
   Sep-2027        218          212,612.29       10,294.85       1,948.95      8,345.90     204,266.38          20.4%           11.00%
   Oct-2027        219          204,266.38       10,294.85       1,872.44      8,422.41     195,843.97          19.6%           11.00%
   Nov-2027        220          195,843.97       10,294.85       1,795.24      8,499.61     187,344.36          18.7%           11.00%
   Dec-2027        221          187,344.36       10,294.85       1,717.32      8,577.53     178,766.83          17.9%           11.00%
   Jan-2028        222          178,766.83       10,294.85       1,638.70      8,656.15     170,110.68          17.0%           11.00%
   Feb-2028        223          170,110.68       10,294.85       1,559.35      8,735.50     161,375.18          16.1%           11.00%
   Mar-2028        224          161,375.18       10,294.85       1,479.27      8,815.58     152,559.60          15.3%           11.00%
   Apr-2028        225          152,559.60       10,294.85       1,398.46      8,896.39     143,663.21          14.4%           11.00%
   May-2028        226          143,663.21       10,294.85       1,316.91      8,977.94     134,685.27          13.5%           11.00%
   Jun-2028        227          134,685.27       10,294.85       1,234.61      9,060.24     125,625.04          12.6%           11.00%
    Jul-2028       228          125,625.04       10,294.85       1,151.56      9,143.29     116,481.75          11.6%           11.00%
   Aug-2028        229          116,481.75       10,294.85       1,067.75      9,227.10     107,254.65          10.7%           11.00%
   Sep-2028        230          107,254.65       10,294.85         983.17      9,311.68      97,942.97           9.8%           11.00%
   Oct-2028        231           97,942.97       10,294.85         897.81      9,397.04      88,545.93           8.9%           11.00%
   Nov-2028        232           88,545.93       10,294.85         811.67      9,483.18      79,062.75           7.9%           11.00%
   Dec-2028        233           79,062.75       10,294.85         724.74      9,570.11      69,492.64           6.9%           11.00%
   Jan-2029        234           69,492.64       10,294.85         637.02      9,657.83      59,834.80           6.0%           11.00%
   Feb-2029        235           59,834.80       10,294.85         548.49      9,746.36      50,088.44           5.0%           11.00%
   Mar-2029        236           50,088.44       10,294.85         459.14      9,835.71      40,252.73           4.0%           11.00%




                                                              Page 4 of 8
Loan Amortization Table                                                                                           www.excel-skills.com

Loan Principle Amount       1,000,000.00
Annual Interest Rate               10.00%
Loan Period (in months)            240.00
Original Repayment Amount        9,650.22
Loan Start Date                 8/15/2009
Repayment Type                  End


               Repayment     Opening            Loan          Interest       Capital       Closing        % Capital
   Month        Number       Balance         Repayment       Charged         Repaid        Balance       Outstanding     Interest Rate
   Apr-2029        237           40,252.73       10,294.85         368.98       9,925.87     30,326.87           3.0%           11.00%
   May-2029        238           30,326.87       10,294.85         278.00      10,016.85     20,310.01           2.0%           11.00%
   Jun-2029        239           20,310.01       10,294.85         186.18      10,108.68     10,201.34           1.0%           11.00%
    Jul-2029       240           10,201.34       10,294.85          93.51      10,201.34          0.00           0.0%           11.00%
   Aug-2029        241                 -               -                 -             -             -           0.0%           11.00%
   Sep-2029        242                 -               -                 -             -             -           0.0%           11.00%
   Oct-2029        243                 -               -                 -             -             -           0.0%           11.00%
   Nov-2029        244                 -               -                 -             -             -           0.0%           11.00%
   Dec-2029        245                 -               -                 -             -             -           0.0%           11.00%
   Jan-2030        246                 -               -                 -             -             -           0.0%           11.00%
   Feb-2030        247                 -               -                 -             -             -           0.0%           11.00%
   Mar-2030        248                 -               -                 -             -             -           0.0%           11.00%
   Apr-2030        249                 -               -                 -             -             -           0.0%           11.00%
   May-2030        250                 -               -                 -             -             -           0.0%           11.00%
   Jun-2030        251                 -               -                 -             -             -           0.0%           11.00%
    Jul-2030       252                 -               -                 -             -             -           0.0%           11.00%
   Aug-2030        253                 -               -                 -             -             -           0.0%           11.00%
   Sep-2030        254                 -               -                 -             -             -           0.0%           11.00%
   Oct-2030        255                 -               -                 -             -             -           0.0%           11.00%
   Nov-2030        256                 -               -                 -             -             -           0.0%           11.00%
   Dec-2030        257                 -               -                 -             -             -           0.0%           11.00%
   Jan-2031        258                 -               -                 -             -             -           0.0%           11.00%
   Feb-2031        259                 -               -                 -             -             -           0.0%           11.00%
   Mar-2031        260                 -               -                 -             -             -           0.0%           11.00%
   Apr-2031        261                 -               -                 -             -             -           0.0%           11.00%
   May-2031        262                 -               -                 -             -             -           0.0%           11.00%
   Jun-2031        263                 -               -                 -             -             -           0.0%           11.00%
    Jul-2031       264                 -               -                 -             -             -           0.0%           11.00%
   Aug-2031        265                 -               -                 -             -             -           0.0%           11.00%
   Sep-2031        266                 -               -                 -             -             -           0.0%           11.00%
   Oct-2031        267                 -               -                 -             -             -           0.0%           11.00%
   Nov-2031        268                 -               -                 -             -             -           0.0%           11.00%
   Dec-2031        269                 -               -                 -             -             -           0.0%           11.00%
   Jan-2032        270                 -               -                 -             -             -           0.0%           11.00%
   Feb-2032        271                 -               -                 -             -             -           0.0%           11.00%
   Mar-2032        272                 -               -                 -             -             -           0.0%           11.00%
   Apr-2032        273                 -               -                 -             -             -           0.0%           11.00%
   May-2032        274                 -               -                 -             -             -           0.0%           11.00%
   Jun-2032        275                 -               -                 -             -             -           0.0%           11.00%
    Jul-2032       276                 -               -                 -             -             -           0.0%           11.00%
   Aug-2032        277                 -               -                 -             -             -           0.0%           11.00%
   Sep-2032        278                 -               -                 -             -             -           0.0%           11.00%
   Oct-2032        279                 -               -                 -             -             -           0.0%           11.00%
   Nov-2032        280                 -               -                 -             -             -           0.0%           11.00%
   Dec-2032        281                 -               -                 -             -             -           0.0%           11.00%
   Jan-2033        282                 -               -                 -             -             -           0.0%           11.00%
   Feb-2033        283                 -               -                 -             -             -           0.0%           11.00%
   Mar-2033        284                 -               -                 -             -             -           0.0%           11.00%
   Apr-2033        285                 -               -                 -             -             -           0.0%           11.00%
   May-2033        286                 -               -                 -             -             -           0.0%           11.00%
   Jun-2033        287                 -               -                 -             -             -           0.0%           11.00%
    Jul-2033       288                 -               -                 -             -             -           0.0%           11.00%
   Aug-2033        289                 -               -                 -             -             -           0.0%           11.00%
   Sep-2033        290                 -               -                 -             -             -           0.0%           11.00%
   Oct-2033        291                 -               -                 -             -             -           0.0%           11.00%
   Nov-2033        292                 -               -                 -             -             -           0.0%           11.00%
   Dec-2033        293                 -               -                 -             -             -           0.0%           11.00%
   Jan-2034        294                 -               -                 -             -             -           0.0%           11.00%
   Feb-2034        295                 -               -                 -             -             -           0.0%           11.00%




                                                              Page 5 of 8
Loan Amortization Table                                                                                      www.excel-skills.com

Loan Principle Amount       1,000,000.00
Annual Interest Rate               10.00%
Loan Period (in months)            240.00
Original Repayment Amount        9,650.22
Loan Start Date                 8/15/2009
Repayment Type                  End


               Repayment     Opening           Loan      Interest       Capital       Closing        % Capital
   Month        Number       Balance        Repayment   Charged         Repaid        Balance       Outstanding     Interest Rate
   Mar-2034        296                -            -                -             -             -           0.0%           11.00%
   Apr-2034        297                -            -                -             -             -           0.0%           11.00%
   May-2034        298                -            -                -             -             -           0.0%           11.00%
   Jun-2034        299                -            -                -             -             -           0.0%           11.00%
    Jul-2034       300                -            -                -             -             -           0.0%           11.00%
   Aug-2034        301                -            -                -             -             -           0.0%           11.00%
   Sep-2034        302                -            -                -             -             -           0.0%           11.00%
   Oct-2034        303                -            -                -             -             -           0.0%           11.00%
   Nov-2034        304                -            -                -             -             -           0.0%           11.00%
   Dec-2034        305                -            -                -             -             -           0.0%           11.00%
   Jan-2035        306                -            -                -             -             -           0.0%           11.00%
   Feb-2035        307                -            -                -             -             -           0.0%           11.00%
   Mar-2035        308                -            -                -             -             -           0.0%           11.00%
   Apr-2035        309                -            -                -             -             -           0.0%           11.00%
   May-2035        310                -            -                -             -             -           0.0%           11.00%
   Jun-2035        311                -            -                -             -             -           0.0%           11.00%
    Jul-2035       312                -            -                -             -             -           0.0%           11.00%
   Aug-2035        313                -            -                -             -             -           0.0%           11.00%
   Sep-2035        314                -            -                -             -             -           0.0%           11.00%
   Oct-2035        315                -            -                -             -             -           0.0%           11.00%
   Nov-2035        316                -            -                -             -             -           0.0%           11.00%
   Dec-2035        317                -            -                -             -             -           0.0%           11.00%
   Jan-2036        318                -            -                -             -             -           0.0%           11.00%
   Feb-2036        319                -            -                -             -             -           0.0%           11.00%
   Mar-2036        320                -            -                -             -             -           0.0%           11.00%
   Apr-2036        321                -            -                -             -             -           0.0%           11.00%
   May-2036        322                -            -                -             -             -           0.0%           11.00%
   Jun-2036        323                -            -                -             -             -           0.0%           11.00%
    Jul-2036       324                -            -                -             -             -           0.0%           11.00%
   Aug-2036        325                -            -                -             -             -           0.0%           11.00%
   Sep-2036        326                -            -                -             -             -           0.0%           11.00%
   Oct-2036        327                -            -                -             -             -           0.0%           11.00%
   Nov-2036        328                -            -                -             -             -           0.0%           11.00%
   Dec-2036        329                -            -                -             -             -           0.0%           11.00%
   Jan-2037        330                -            -                -             -             -           0.0%           11.00%
   Feb-2037        331                -            -                -             -             -           0.0%           11.00%
   Mar-2037        332                -            -                -             -             -           0.0%           11.00%
   Apr-2037        333                -            -                -             -             -           0.0%           11.00%
   May-2037        334                -            -                -             -             -           0.0%           11.00%
   Jun-2037        335                -            -                -             -             -           0.0%           11.00%
    Jul-2037       336                -            -                -             -             -           0.0%           11.00%
   Aug-2037        337                -            -                -             -             -           0.0%           11.00%
   Sep-2037        338                -            -                -             -             -           0.0%           11.00%
   Oct-2037        339                -            -                -             -             -           0.0%           11.00%
   Nov-2037        340                -            -                -             -             -           0.0%           11.00%
   Dec-2037        341                -            -                -             -             -           0.0%           11.00%
   Jan-2038        342                -            -                -             -             -           0.0%           11.00%
   Feb-2038        343                -            -                -             -             -           0.0%           11.00%
   Mar-2038        344                -            -                -             -             -           0.0%           11.00%
   Apr-2038        345                -            -                -             -             -           0.0%           11.00%
   May-2038        346                -            -                -             -             -           0.0%           11.00%
   Jun-2038        347                -            -                -             -             -           0.0%           11.00%
    Jul-2038       348                -            -                -             -             -           0.0%           11.00%
   Aug-2038        349                -            -                -             -             -           0.0%           11.00%
   Sep-2038        350                -            -                -             -             -           0.0%           11.00%
   Oct-2038        351                -            -                -             -             -           0.0%           11.00%
   Nov-2038        352                -            -                -             -             -           0.0%           11.00%
   Dec-2038        353                -            -                -             -             -           0.0%           11.00%
   Jan-2039        354                -            -                -             -             -           0.0%           11.00%




                                                         Page 6 of 8
Loan Amortization Table                                                                                            www.excel-skills.com

Loan Principle Amount       1,000,000.00
Annual Interest Rate               10.00%
Loan Period (in months)            240.00
Original Repayment Amount        9,650.22
Loan Start Date                 8/15/2009
Repayment Type                  End


               Repayment     Opening           Loan          Interest         Capital       Closing        % Capital
   Month        Number       Balance        Repayment       Charged           Repaid        Balance       Outstanding     Interest Rate
   Feb-2039        355                -              -                  -               -             -           0.0%           11.00%
   Mar-2039        356                -              -                  -               -             -           0.0%           11.00%
   Apr-2039        357                -              -                  -               -             -           0.0%           11.00%
   May-2039        358                -              -                  -               -             -           0.0%           11.00%
   Jun-2039        359                -              -                  -               -             -           0.0%           11.00%
    Jul-2039       360                -              -                  -               -             -           0.0%           11.00%
                                            2,460,919.51   1,460,919.51     1,000,000.00




                                                             Page 7 of 8
Loan Summary                                        www.excel-skills.com

Review Date                       8/25/2010

Month End Date                     8/31/2010
Loan Start Date                    8/15/2009


To Date
Total Loan Repayments                127,822.10
Total Interest Paid                  110,400.11
Total Capital Repayment               17,421.99
Outstanding Capital Balance          982,578.01
Outstanding Capital %                       98.3%


Previous 12 Months
Total Loan Repayments                117,838.30
Total Interest Paid                  101,650.11
Total Capital Repayment               16,188.19


Next 12 Months
Total Loan Repayments                119,704.61
Total Interest Paid                  102,299.87
Total Capital Repayment               17,404.74


Loan Period
Total Loan Repayments              2,460,919.51
Total Interest Paid                1,460,919.51
Total Capital Repayment            1,000,000.00




                              Page 7 of 7

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:13
posted:1/29/2011
language:English
pages:8