Get documents about "Excel Skills Australia | Loan Amortization Template
Document Sample
Loan Amortization Table www.excel-skills.com.au
Loan Principle Amount 300,000.00
Annual Interest Rate 7.40%
Loan Period (in months) 300.00
Original Repayment Amount 2,197.50
Loan Start Date 8/15/2011
Repayment Type End
Repayment Opening Loan Interest Capital Closing % Capital
Month Number Balance Repayment Charged Repaid Balance Outstanding Interest Rate
Aug-2011 1 300,000.00 2,197.50 1,850.00 347.50 299,652.50 99.9% 7.40%
Sep-2011 2 299,652.50 2,197.50 1,847.86 349.64 299,302.86 99.8% 7.40%
Oct-2011 3 299,302.86 2,197.50 1,845.70 351.80 298,951.07 99.7% 7.40%
Nov-2011 4 298,951.07 2,275.35 1,943.18 332.17 298,618.90 99.5% 7.80%
Dec-2011 5 298,618.90 2,275.35 1,941.02 334.33 298,284.58 99.4% 7.80%
Jan-2012 6 298,284.58 2,275.35 1,938.85 336.50 297,948.08 99.3% 7.80%
Feb-2012 7 297,948.08 2,275.35 1,936.66 338.69 297,609.39 99.2% 7.80%
Mar-2012 8 297,609.39 2,275.35 1,934.46 340.89 297,268.51 99.1% 7.80%
Apr-2012 9 297,268.51 2,275.35 1,932.25 343.10 296,925.40 99.0% 7.80%
May-2012 10 296,925.40 2,275.35 1,930.02 345.33 296,580.07 98.9% 7.80%
Jun-2012 11 296,580.07 2,275.35 1,927.77 347.58 296,232.49 98.7% 7.80%
Jul-2012 12 296,232.49 2,275.35 1,925.51 349.84 295,882.66 98.6% 7.80%
Aug-2012 13 295,882.66 2,275.35 1,923.24 352.11 295,530.54 98.5% 7.80%
Sep-2012 14 295,530.54 2,275.35 1,920.95 354.40 295,176.14 98.4% 7.80%
Oct-2012 15 295,176.14 2,275.35 1,918.64 356.70 294,819.44 98.3% 7.80%
Nov-2012 16 294,819.44 2,275.35 1,916.33 359.02 294,460.42 98.2% 7.80%
Dec-2012 17 294,460.42 2,275.35 1,913.99 361.36 294,099.06 98.0% 7.80%
Jan-2013 18 294,099.06 2,275.35 1,911.64 363.70 293,735.36 97.9% 7.80%
Feb-2013 19 293,735.36 2,275.35 1,909.28 366.07 293,369.29 97.8% 7.80%
Mar-2013 20 293,369.29 2,275.35 1,906.90 368.45 293,000.84 97.7% 7.80%
Apr-2013 21 293,000.84 2,275.35 1,904.51 370.84 292,630.00 97.5% 7.80%
May-2013 22 292,630.00 2,275.35 1,902.10 373.25 292,256.75 97.4% 7.80%
Jun-2013 23 292,256.75 2,275.35 1,899.67 375.68 291,881.07 97.3% 7.80%
Jul-2013 24 291,881.07 2,275.35 1,897.23 378.12 291,502.95 97.2% 7.80%
Aug-2013 25 291,502.95 2,275.35 1,894.77 380.58 291,122.37 97.0% 7.80%
Sep-2013 26 291,122.37 2,275.35 1,892.30 383.05 290,739.32 96.9% 7.80%
Oct-2013 27 290,739.32 2,275.35 1,889.81 385.54 290,353.77 96.8% 7.80%
Nov-2013 28 290,353.77 2,275.35 1,887.30 388.05 289,965.73 96.7% 7.80%
Dec-2013 29 289,965.73 2,275.35 1,884.78 390.57 289,575.15 96.5% 7.80%
Jan-2014 30 289,575.15 2,275.35 1,882.24 393.11 289,182.04 96.4% 7.80%
Feb-2014 31 289,182.04 2,275.35 1,879.68 395.66 288,786.38 96.3% 7.80%
Mar-2014 32 288,786.38 2,275.35 1,877.11 398.24 288,388.14 96.1% 7.80%
Apr-2014 33 288,388.14 2,275.35 1,874.52 400.83 287,987.32 96.0% 7.80%
May-2014 34 287,987.32 2,275.35 1,871.92 403.43 287,583.89 95.9% 7.80%
Jun-2014 35 287,583.89 2,275.35 1,869.30 406.05 287,177.83 95.7% 7.80%
Jul-2014 36 287,177.83 2,275.35 1,866.66 408.69 286,769.14 95.6% 7.80%
Aug-2014 37 286,769.14 2,275.35 1,864.00 411.35 286,357.79 95.5% 7.80%
Sep-2014 38 286,357.79 2,275.35 1,861.33 414.02 285,943.77 95.3% 7.80%
Oct-2014 39 285,943.77 2,275.35 1,858.63 416.71 285,527.06 95.2% 7.80%
Nov-2014 40 285,527.06 2,275.35 1,855.93 419.42 285,107.64 95.0% 7.80%
Dec-2014 41 285,107.64 2,275.35 1,853.20 422.15 284,685.49 94.9% 7.80%
Jan-2015 42 284,685.49 2,275.35 1,850.46 424.89 284,260.59 94.8% 7.80%
Feb-2015 43 284,260.59 2,275.35 1,847.69 427.65 283,832.94 94.6% 7.80%
Mar-2015 44 283,832.94 2,275.35 1,844.91 430.43 283,402.51 94.5% 7.80%
Apr-2015 45 283,402.51 2,275.35 1,842.12 433.23 282,969.27 94.3% 7.80%
May-2015 46 282,969.27 2,275.35 1,839.30 436.05 282,533.23 94.2% 7.80%
Jun-2015 47 282,533.23 2,275.35 1,836.47 438.88 282,094.34 94.0% 7.80%
Jul-2015 48 282,094.34 2,275.35 1,833.61 441.73 281,652.61 93.9% 7.80%
Aug-2015 49 281,652.61 2,275.35 1,830.74 444.61 281,208.00 93.7% 7.80%
Sep-2015 50 281,208.00 2,275.35 1,827.85 447.50 280,760.51 93.6% 7.80%
Oct-2015 51 280,760.51 2,275.35 1,824.94 450.40 280,310.10 93.4% 7.80%
Nov-2015 52 280,310.10 2,275.35 1,822.02 453.33 279,856.77 93.3% 7.80%
Dec-2015 53 279,856.77 2,275.35 1,819.07 456.28 279,400.49 93.1% 7.80%
Jan-2016 54 279,400.49 2,275.35 1,816.10 459.24 278,941.25 93.0% 7.80%
Feb-2016 55 278,941.25 2,275.35 1,813.12 462.23 278,479.02 92.8% 7.80%
Mar-2016 56 278,479.02 2,275.35 1,810.11 465.23 278,013.78 92.7% 7.80%
Apr-2016 57 278,013.78 2,275.35 1,807.09 468.26 277,545.52 92.5% 7.80%
May-2016 58 277,545.52 2,275.35 1,804.05 471.30 277,074.22 92.4% 7.80%
Jun-2016 59 277,074.22 2,275.35 1,800.98 474.37 276,599.85 92.2% 7.80%
Page 1 of 8
Loan Amortization Table www.excel-skills.com.au
Loan Principle Amount 300,000.00
Annual Interest Rate 7.40%
Loan Period (in months) 300.00
Original Repayment Amount 2,197.50
Loan Start Date 8/15/2011
Repayment Type End
Repayment Opening Loan Interest Capital Closing % Capital
Month Number Balance Repayment Charged Repaid Balance Outstanding Interest Rate
Jul-2016 60 276,599.85 2,275.35 1,797.90 477.45 276,122.41 92.0% 7.80%
Aug-2016 61 276,122.41 2,275.35 1,794.80 480.55 275,641.85 91.9% 7.80%
Sep-2016 62 275,641.85 2,275.35 1,791.67 483.68 275,158.18 91.7% 7.80%
Oct-2016 63 275,158.18 2,275.35 1,788.53 486.82 274,671.36 91.6% 7.80%
Nov-2016 64 274,671.36 2,275.35 1,785.36 489.98 274,181.37 91.4% 7.80%
Dec-2016 65 274,181.37 2,275.35 1,782.18 493.17 273,688.20 91.2% 7.80%
Jan-2017 66 273,688.20 2,275.35 1,778.97 496.37 273,191.83 91.1% 7.80%
Feb-2017 67 273,191.83 2,275.35 1,775.75 499.60 272,692.23 90.9% 7.80%
Mar-2017 68 272,692.23 2,275.35 1,772.50 502.85 272,189.38 90.7% 7.80%
Apr-2017 69 272,189.38 2,275.35 1,769.23 506.12 271,683.26 90.6% 7.80%
May-2017 70 271,683.26 2,275.35 1,765.94 509.41 271,173.85 90.4% 7.80%
Jun-2017 71 271,173.85 2,275.35 1,762.63 512.72 270,661.14 90.2% 7.80%
Jul-2017 72 270,661.14 2,275.35 1,759.30 516.05 270,145.09 90.0% 7.80%
Aug-2017 73 270,145.09 2,275.35 1,755.94 519.41 269,625.68 89.9% 7.80%
Sep-2017 74 269,625.68 2,275.35 1,752.57 522.78 269,102.90 89.7% 7.80%
Oct-2017 75 269,102.90 2,275.35 1,749.17 526.18 268,576.72 89.5% 7.80%
Nov-2017 76 268,576.72 2,275.35 1,745.75 529.60 268,047.12 89.3% 7.80%
Dec-2017 77 268,047.12 2,275.35 1,742.31 533.04 267,514.08 89.2% 7.80%
Jan-2018 78 267,514.08 2,275.35 1,738.84 536.51 266,977.57 89.0% 7.80%
Feb-2018 79 266,977.57 2,275.35 1,735.35 539.99 266,437.58 88.8% 7.80%
Mar-2018 80 266,437.58 2,275.35 1,731.84 543.50 265,894.07 88.6% 7.80%
Apr-2018 81 265,894.07 2,275.35 1,728.31 547.04 265,347.04 88.4% 7.80%
May-2018 82 265,347.04 2,275.35 1,724.76 550.59 264,796.45 88.3% 7.80%
Jun-2018 83 264,796.45 2,275.35 1,721.18 554.17 264,242.27 88.1% 7.80%
Jul-2018 84 264,242.27 2,275.35 1,717.57 557.77 263,684.50 87.9% 7.80%
Aug-2018 85 263,684.50 2,275.35 1,713.95 561.40 263,123.10 87.7% 7.80%
Sep-2018 86 263,123.10 2,275.35 1,710.30 565.05 262,558.05 87.5% 7.80%
Oct-2018 87 262,558.05 2,275.35 1,706.63 568.72 261,989.33 87.3% 7.80%
Nov-2018 88 261,989.33 2,275.35 1,702.93 572.42 261,416.92 87.1% 7.80%
Dec-2018 89 261,416.92 2,275.35 1,699.21 576.14 260,840.78 86.9% 7.80%
Jan-2019 90 260,840.78 2,275.35 1,695.47 579.88 260,260.89 86.8% 7.80%
Feb-2019 91 260,260.89 2,275.35 1,691.70 583.65 259,677.24 86.6% 7.80%
Mar-2019 92 259,677.24 2,275.35 1,687.90 587.45 259,089.80 86.4% 7.80%
Apr-2019 93 259,089.80 2,275.35 1,684.08 591.26 258,498.53 86.2% 7.80%
May-2019 94 258,498.53 2,275.35 1,680.24 595.11 257,903.42 86.0% 7.80%
Jun-2019 95 257,903.42 2,275.35 1,676.37 598.98 257,304.45 85.8% 7.80%
Jul-2019 96 257,304.45 2,275.35 1,672.48 602.87 256,701.58 85.6% 7.80%
Aug-2019 97 256,701.58 2,275.35 1,668.56 606.79 256,094.79 85.4% 7.80%
Sep-2019 98 256,094.79 2,275.35 1,664.62 610.73 255,484.06 85.2% 7.80%
Oct-2019 99 255,484.06 2,275.35 1,660.65 614.70 254,869.36 85.0% 7.80%
Nov-2019 100 254,869.36 2,275.35 1,656.65 618.70 254,250.66 84.8% 7.80%
Dec-2019 101 254,250.66 2,275.35 1,652.63 622.72 253,627.94 84.5% 7.80%
Jan-2020 102 253,627.94 2,275.35 1,648.58 626.77 253,001.17 84.3% 7.80%
Feb-2020 103 253,001.17 2,275.35 1,644.51 630.84 252,370.33 84.1% 7.80%
Mar-2020 104 252,370.33 2,275.35 1,640.41 634.94 251,735.39 83.9% 7.80%
Apr-2020 105 251,735.39 2,275.35 1,636.28 639.07 251,096.32 83.7% 7.80%
May-2020 106 251,096.32 2,275.35 1,632.13 643.22 250,453.10 83.5% 7.80%
Jun-2020 107 250,453.10 2,275.35 1,627.95 647.40 249,805.70 83.3% 7.80%
Jul-2020 108 249,805.70 2,275.35 1,623.74 651.61 249,154.09 83.1% 7.80%
Aug-2020 109 249,154.09 2,275.35 1,619.50 655.85 248,498.24 82.8% 7.80%
Sep-2020 110 248,498.24 2,275.35 1,615.24 660.11 247,838.13 82.6% 7.80%
Oct-2020 111 247,838.13 2,275.35 1,610.95 664.40 247,173.73 82.4% 7.80%
Nov-2020 112 247,173.73 2,275.35 1,606.63 668.72 246,505.01 82.2% 7.80%
Dec-2020 113 246,505.01 2,275.35 1,602.28 673.07 245,831.95 81.9% 7.80%
Jan-2021 114 245,831.95 2,275.35 1,597.91 677.44 245,154.51 81.7% 7.80%
Feb-2021 115 245,154.51 2,275.35 1,593.50 681.84 244,472.66 81.5% 7.80%
Mar-2021 116 244,472.66 2,275.35 1,589.07 686.28 243,786.39 81.3% 7.80%
Apr-2021 117 243,786.39 2,275.35 1,584.61 690.74 243,095.65 81.0% 7.80%
May-2021 118 243,095.65 2,275.35 1,580.12 695.23 242,400.42 80.8% 7.80%
Page 2 of 8
Loan Amortization Table www.excel-skills.com.au
Loan Principle Amount 300,000.00
Annual Interest Rate 7.40%
Loan Period (in months) 300.00
Original Repayment Amount 2,197.50
Loan Start Date 8/15/2011
Repayment Type End
Repayment Opening Loan Interest Capital Closing % Capital
Month Number Balance Repayment Charged Repaid Balance Outstanding Interest Rate
Jun-2021 119 242,400.42 2,275.35 1,575.60 699.75 241,700.68 80.6% 7.80%
Jul-2021 120 241,700.68 2,275.35 1,571.05 704.29 240,996.39 80.3% 7.80%
Aug-2021 121 240,996.39 2,275.35 1,566.48 708.87 240,287.51 80.1% 7.80%
Sep-2021 122 240,287.51 2,275.35 1,561.87 713.48 239,574.03 79.9% 7.80%
Oct-2021 123 239,574.03 2,275.35 1,557.23 718.12 238,855.92 79.6% 7.80%
Nov-2021 124 238,855.92 2,275.35 1,552.56 722.78 238,133.13 79.4% 7.80%
Dec-2021 125 238,133.13 2,275.35 1,547.87 727.48 237,405.65 79.1% 7.80%
Jan-2022 126 237,405.65 2,275.35 1,543.14 732.21 236,673.44 78.9% 7.80%
Feb-2022 127 236,673.44 2,275.35 1,538.38 736.97 235,936.47 78.6% 7.80%
Mar-2022 128 235,936.47 2,275.35 1,533.59 741.76 235,194.71 78.4% 7.80%
Apr-2022 129 235,194.71 2,275.35 1,528.77 746.58 234,448.12 78.1% 7.80%
May-2022 130 234,448.12 2,275.35 1,523.91 751.44 233,696.69 77.9% 7.80%
Jun-2022 131 233,696.69 2,275.35 1,519.03 756.32 232,940.37 77.6% 7.80%
Jul-2022 132 232,940.37 2,275.35 1,514.11 761.24 232,179.13 77.4% 7.80%
Aug-2022 133 232,179.13 2,275.35 1,509.16 766.18 231,412.95 77.1% 7.80%
Sep-2022 134 231,412.95 2,275.35 1,504.18 771.16 230,641.79 76.9% 7.80%
Oct-2022 135 230,641.79 2,275.35 1,499.17 776.18 229,865.61 76.6% 7.80%
Nov-2022 136 229,865.61 2,275.35 1,494.13 781.22 229,084.39 76.4% 7.80%
Dec-2022 137 229,084.39 2,275.35 1,489.05 786.30 228,298.09 76.1% 7.80%
Jan-2023 138 228,298.09 2,275.35 1,483.94 791.41 227,506.68 75.8% 7.80%
Feb-2023 139 227,506.68 2,275.35 1,478.79 796.55 226,710.12 75.6% 7.80%
Mar-2023 140 226,710.12 2,275.35 1,473.62 801.73 225,908.39 75.3% 7.80%
Apr-2023 141 225,908.39 2,275.35 1,468.40 806.94 225,101.45 75.0% 7.80%
May-2023 142 225,101.45 2,275.35 1,463.16 812.19 224,289.26 74.8% 7.80%
Jun-2023 143 224,289.26 2,275.35 1,457.88 817.47 223,471.79 74.5% 7.80%
Jul-2023 144 223,471.79 2,275.35 1,452.57 822.78 222,649.01 74.2% 7.80%
Aug-2023 145 222,649.01 2,275.35 1,447.22 828.13 221,820.88 73.9% 7.80%
Sep-2023 146 221,820.88 2,275.35 1,441.84 833.51 220,987.37 73.7% 7.80%
Oct-2023 147 220,987.37 2,275.35 1,436.42 838.93 220,148.44 73.4% 7.80%
Nov-2023 148 220,148.44 2,275.35 1,430.96 844.38 219,304.05 73.1% 7.80%
Dec-2023 149 219,304.05 2,275.35 1,425.48 849.87 218,454.18 72.8% 7.80%
Jan-2024 150 218,454.18 2,275.35 1,419.95 855.40 217,598.79 72.5% 7.80%
Feb-2024 151 217,598.79 2,275.35 1,414.39 860.96 216,737.83 72.2% 7.80%
Mar-2024 152 216,737.83 2,275.35 1,408.80 866.55 215,871.28 72.0% 7.80%
Apr-2024 153 215,871.28 2,275.35 1,403.16 872.18 214,999.09 71.7% 7.80%
May-2024 154 214,999.09 2,275.35 1,397.49 877.85 214,121.24 71.4% 7.80%
Jun-2024 155 214,121.24 2,275.35 1,391.79 883.56 213,237.68 71.1% 7.80%
Jul-2024 156 213,237.68 2,275.35 1,386.04 889.30 212,348.38 70.8% 7.80%
Aug-2024 157 212,348.38 2,275.35 1,380.26 895.08 211,453.29 70.5% 7.80%
Sep-2024 158 211,453.29 2,275.35 1,374.45 900.90 210,552.39 70.2% 7.80%
Oct-2024 159 210,552.39 2,275.35 1,368.59 906.76 209,645.63 69.9% 7.80%
Nov-2024 160 209,645.63 2,275.35 1,362.70 912.65 208,732.98 69.6% 7.80%
Dec-2024 161 208,732.98 2,275.35 1,356.76 918.58 207,814.40 69.3% 7.80%
Jan-2025 162 207,814.40 2,275.35 1,350.79 924.55 206,889.84 69.0% 7.80%
Feb-2025 163 206,889.84 2,275.35 1,344.78 930.56 205,959.28 68.7% 7.80%
Mar-2025 164 205,959.28 2,275.35 1,338.74 936.61 205,022.67 68.3% 7.80%
Apr-2025 165 205,022.67 2,275.35 1,332.65 942.70 204,079.96 68.0% 7.80%
May-2025 166 204,079.96 2,275.35 1,326.52 948.83 203,131.14 67.7% 7.80%
Jun-2025 167 203,131.14 2,275.35 1,320.35 955.00 202,176.14 67.4% 7.80%
Jul-2025 168 202,176.14 2,275.35 1,314.14 961.20 201,214.94 67.1% 7.80%
Aug-2025 169 201,214.94 2,275.35 1,307.90 967.45 200,247.49 66.7% 7.80%
Sep-2025 170 200,247.49 2,275.35 1,301.61 973.74 199,273.75 66.4% 7.80%
Oct-2025 171 199,273.75 2,275.35 1,295.28 980.07 198,293.68 66.1% 7.80%
Nov-2025 172 198,293.68 2,275.35 1,288.91 986.44 197,307.24 65.8% 7.80%
Dec-2025 173 197,307.24 2,275.35 1,282.50 992.85 196,314.39 65.4% 7.80%
Jan-2026 174 196,314.39 2,275.35 1,276.04 999.30 195,315.08 65.1% 7.80%
Feb-2026 175 195,315.08 2,275.35 1,269.55 1,005.80 194,309.28 64.8% 7.80%
Mar-2026 176 194,309.28 2,275.35 1,263.01 1,012.34 193,296.95 64.4% 7.80%
Apr-2026 177 193,296.95 2,275.35 1,256.43 1,018.92 192,278.03 64.1% 7.80%
Page 3 of 8
Loan Amortization Table www.excel-skills.com.au
Loan Principle Amount 300,000.00
Annual Interest Rate 7.40%
Loan Period (in months) 300.00
Original Repayment Amount 2,197.50
Loan Start Date 8/15/2011
Repayment Type End
Repayment Opening Loan Interest Capital Closing % Capital
Month Number Balance Repayment Charged Repaid Balance Outstanding Interest Rate
May-2026 178 192,278.03 2,275.35 1,249.81 1,025.54 191,252.49 63.8% 7.80%
Jun-2026 179 191,252.49 2,275.35 1,243.14 1,032.21 190,220.28 63.4% 7.80%
Jul-2026 180 190,220.28 2,275.35 1,236.43 1,038.92 189,181.36 63.1% 7.80%
Aug-2026 181 189,181.36 2,275.35 1,229.68 1,045.67 188,135.69 62.7% 7.80%
Sep-2026 182 188,135.69 2,275.35 1,222.88 1,052.47 187,083.23 62.4% 7.80%
Oct-2026 183 187,083.23 2,275.35 1,216.04 1,059.31 186,023.92 62.0% 7.80%
Nov-2026 184 186,023.92 2,275.35 1,209.16 1,066.19 184,957.73 61.7% 7.80%
Dec-2026 185 184,957.73 2,275.35 1,202.23 1,073.12 183,884.60 61.3% 7.80%
Jan-2027 186 183,884.60 2,275.35 1,195.25 1,080.10 182,804.51 60.9% 7.80%
Feb-2027 187 182,804.51 2,275.35 1,188.23 1,087.12 181,717.39 60.6% 7.80%
Mar-2027 188 181,717.39 2,275.35 1,181.16 1,094.19 180,623.20 60.2% 7.80%
Apr-2027 189 180,623.20 2,275.35 1,174.05 1,101.30 179,521.91 59.8% 7.80%
May-2027 190 179,521.91 2,275.35 1,166.89 1,108.46 178,413.45 59.5% 7.80%
Jun-2027 191 178,413.45 2,275.35 1,159.69 1,115.66 177,297.79 59.1% 7.80%
Jul-2027 192 177,297.79 2,275.35 1,152.44 1,122.91 176,174.88 58.7% 7.80%
Aug-2027 193 176,174.88 2,275.35 1,145.14 1,130.21 175,044.66 58.3% 7.80%
Sep-2027 194 175,044.66 2,275.35 1,137.79 1,137.56 173,907.11 58.0% 7.80%
Oct-2027 195 173,907.11 2,275.35 1,130.40 1,144.95 172,762.16 57.6% 7.80%
Nov-2027 196 172,762.16 2,275.35 1,122.95 1,152.39 171,609.76 57.2% 7.80%
Dec-2027 197 171,609.76 2,275.35 1,115.46 1,159.88 170,449.88 56.8% 7.80%
Jan-2028 198 170,449.88 2,275.35 1,107.92 1,167.42 169,282.45 56.4% 7.80%
Feb-2028 199 169,282.45 2,275.35 1,100.34 1,175.01 168,107.44 56.0% 7.80%
Mar-2028 200 168,107.44 2,275.35 1,092.70 1,182.65 166,924.79 55.6% 7.80%
Apr-2028 201 166,924.79 2,275.35 1,085.01 1,190.34 165,734.45 55.2% 7.80%
May-2028 202 165,734.45 2,275.35 1,077.27 1,198.07 164,536.38 54.8% 7.80%
Jun-2028 203 164,536.38 2,275.35 1,069.49 1,205.86 163,330.52 54.4% 7.80%
Jul-2028 204 163,330.52 2,275.35 1,061.65 1,213.70 162,116.82 54.0% 7.80%
Aug-2028 205 162,116.82 2,275.35 1,053.76 1,221.59 160,895.23 53.6% 7.80%
Sep-2028 206 160,895.23 2,275.35 1,045.82 1,229.53 159,665.70 53.2% 7.80%
Oct-2028 207 159,665.70 2,275.35 1,037.83 1,237.52 158,428.18 52.8% 7.80%
Nov-2028 208 158,428.18 2,275.35 1,029.78 1,245.56 157,182.61 52.4% 7.80%
Dec-2028 209 157,182.61 2,275.35 1,021.69 1,253.66 155,928.95 52.0% 7.80%
Jan-2029 210 155,928.95 2,275.35 1,013.54 1,261.81 154,667.14 51.6% 7.80%
Feb-2029 211 154,667.14 2,275.35 1,005.34 1,270.01 153,397.13 51.1% 7.80%
Mar-2029 212 153,397.13 2,275.35 997.08 1,278.27 152,118.86 50.7% 7.80%
Apr-2029 213 152,118.86 2,275.35 988.77 1,286.58 150,832.29 50.3% 7.80%
May-2029 214 150,832.29 2,275.35 980.41 1,294.94 149,537.35 49.8% 7.80%
Jun-2029 215 149,537.35 2,275.35 971.99 1,303.36 148,234.00 49.4% 7.80%
Jul-2029 216 148,234.00 2,275.35 963.52 1,311.83 146,922.17 49.0% 7.80%
Aug-2029 217 146,922.17 2,275.35 954.99 1,320.35 145,601.81 48.5% 7.80%
Sep-2029 218 145,601.81 2,275.35 946.41 1,328.94 144,272.88 48.1% 7.80%
Oct-2029 219 144,272.88 2,275.35 937.77 1,337.57 142,935.30 47.6% 7.80%
Nov-2029 220 142,935.30 2,275.35 929.08 1,346.27 141,589.03 47.2% 7.80%
Dec-2029 221 141,589.03 2,275.35 920.33 1,355.02 140,234.02 46.7% 7.80%
Jan-2030 222 140,234.02 2,275.35 911.52 1,363.83 138,870.19 46.3% 7.80%
Feb-2030 223 138,870.19 2,275.35 902.66 1,372.69 137,497.50 45.8% 7.80%
Mar-2030 224 137,497.50 2,275.35 893.73 1,381.61 136,115.88 45.4% 7.80%
Apr-2030 225 136,115.88 2,275.35 884.75 1,390.59 134,725.29 44.9% 7.80%
May-2030 226 134,725.29 2,275.35 875.71 1,399.63 133,325.65 44.4% 7.80%
Jun-2030 227 133,325.65 2,275.35 866.62 1,408.73 131,916.92 44.0% 7.80%
Jul-2030 228 131,916.92 2,275.35 857.46 1,417.89 130,499.03 43.5% 7.80%
Aug-2030 229 130,499.03 2,275.35 848.24 1,427.10 129,071.93 43.0% 7.80%
Sep-2030 230 129,071.93 2,275.35 838.97 1,436.38 127,635.55 42.5% 7.80%
Oct-2030 231 127,635.55 2,275.35 829.63 1,445.72 126,189.83 42.1% 7.80%
Nov-2030 232 126,189.83 2,275.35 820.23 1,455.11 124,734.72 41.6% 7.80%
Dec-2030 233 124,734.72 2,275.35 810.78 1,464.57 123,270.14 41.1% 7.80%
Jan-2031 234 123,270.14 2,275.35 801.26 1,474.09 121,796.05 40.6% 7.80%
Feb-2031 235 121,796.05 2,275.35 791.67 1,483.67 120,312.38 40.1% 7.80%
Mar-2031 236 120,312.38 2,275.35 782.03 1,493.32 118,819.06 39.6% 7.80%
Page 4 of 8
Loan Amortization Table www.excel-skills.com.au
Loan Principle Amount 300,000.00
Annual Interest Rate 7.40%
Loan Period (in months) 300.00
Original Repayment Amount 2,197.50
Loan Start Date 8/15/2011
Repayment Type End
Repayment Opening Loan Interest Capital Closing % Capital
Month Number Balance Repayment Charged Repaid Balance Outstanding Interest Rate
Apr-2031 237 118,819.06 2,275.35 772.32 1,503.02 117,316.04 39.1% 7.80%
May-2031 238 117,316.04 2,275.35 762.55 1,512.79 115,803.24 38.6% 7.80%
Jun-2031 239 115,803.24 2,275.35 752.72 1,522.63 114,280.62 38.1% 7.80%
Jul-2031 240 114,280.62 2,275.35 742.82 1,532.52 112,748.09 37.6% 7.80%
Aug-2031 241 112,748.09 2,275.35 732.86 1,542.49 111,205.61 37.1% 7.80%
Sep-2031 242 111,205.61 2,275.35 722.84 1,552.51 109,653.09 36.6% 7.80%
Oct-2031 243 109,653.09 2,275.35 712.75 1,562.60 108,090.49 36.0% 7.80%
Nov-2031 244 108,090.49 2,275.35 702.59 1,572.76 106,517.73 35.5% 7.80%
Dec-2031 245 106,517.73 2,275.35 692.37 1,582.98 104,934.75 35.0% 7.80%
Jan-2032 246 104,934.75 2,275.35 682.08 1,593.27 103,341.48 34.4% 7.80%
Feb-2032 247 103,341.48 2,275.35 671.72 1,603.63 101,737.85 33.9% 7.80%
Mar-2032 248 101,737.85 2,275.35 661.30 1,614.05 100,123.80 33.4% 7.80%
Apr-2032 249 100,123.80 2,275.35 650.80 1,624.54 98,499.25 32.8% 7.80%
May-2032 250 98,499.25 2,275.35 640.25 1,635.10 96,864.15 32.3% 7.80%
Jun-2032 251 96,864.15 2,275.35 629.62 1,645.73 95,218.42 31.7% 7.80%
Jul-2032 252 95,218.42 2,275.35 618.92 1,656.43 93,561.99 31.2% 7.80%
Aug-2032 253 93,561.99 2,275.35 608.15 1,667.20 91,894.79 30.6% 7.80%
Sep-2032 254 91,894.79 2,275.35 597.32 1,678.03 90,216.76 30.1% 7.80%
Oct-2032 255 90,216.76 2,275.35 586.41 1,688.94 88,527.82 29.5% 7.80%
Nov-2032 256 88,527.82 2,275.35 575.43 1,699.92 86,827.91 28.9% 7.80%
Dec-2032 257 86,827.91 2,275.35 564.38 1,710.97 85,116.94 28.4% 7.80%
Jan-2033 258 85,116.94 2,275.35 553.26 1,722.09 83,394.85 27.8% 7.80%
Feb-2033 259 83,394.85 2,275.35 542.07 1,733.28 81,661.57 27.2% 7.80%
Mar-2033 260 81,661.57 2,275.35 530.80 1,744.55 79,917.02 26.6% 7.80%
Apr-2033 261 79,917.02 2,275.35 519.46 1,755.89 78,161.13 26.1% 7.80%
May-2033 262 78,161.13 2,275.35 508.05 1,767.30 76,393.83 25.5% 7.80%
Jun-2033 263 76,393.83 2,275.35 496.56 1,778.79 74,615.05 24.9% 7.80%
Jul-2033 264 74,615.05 2,275.35 485.00 1,790.35 72,824.69 24.3% 7.80%
Aug-2033 265 72,824.69 2,275.35 473.36 1,801.99 71,022.71 23.7% 7.80%
Sep-2033 266 71,022.71 2,275.35 461.65 1,813.70 69,209.01 23.1% 7.80%
Oct-2033 267 69,209.01 2,275.35 449.86 1,825.49 67,383.52 22.5% 7.80%
Nov-2033 268 67,383.52 2,275.35 437.99 1,837.36 65,546.16 21.8% 7.80%
Dec-2033 269 65,546.16 2,275.35 426.05 1,849.30 63,696.86 21.2% 7.80%
Jan-2034 270 63,696.86 2,275.35 414.03 1,861.32 61,835.55 20.6% 7.80%
Feb-2034 271 61,835.55 2,275.35 401.93 1,873.42 59,962.13 20.0% 7.80%
Mar-2034 272 59,962.13 2,275.35 389.75 1,885.59 58,076.53 19.4% 7.80%
Apr-2034 273 58,076.53 2,275.35 377.50 1,897.85 56,178.68 18.7% 7.80%
May-2034 274 56,178.68 2,275.35 365.16 1,910.19 54,268.50 18.1% 7.80%
Jun-2034 275 54,268.50 2,275.35 352.75 1,922.60 52,345.89 17.4% 7.80%
Jul-2034 276 52,345.89 2,275.35 340.25 1,935.10 50,410.79 16.8% 7.80%
Aug-2034 277 50,410.79 2,275.35 327.67 1,947.68 48,463.12 16.2% 7.80%
Sep-2034 278 48,463.12 2,275.35 315.01 1,960.34 46,502.78 15.5% 7.80%
Oct-2034 279 46,502.78 2,275.35 302.27 1,973.08 44,529.70 14.8% 7.80%
Nov-2034 280 44,529.70 2,275.35 289.44 1,985.91 42,543.79 14.2% 7.80%
Dec-2034 281 42,543.79 2,275.35 276.53 1,998.81 40,544.98 13.5% 7.80%
Jan-2035 282 40,544.98 2,275.35 263.54 2,011.81 38,533.17 12.8% 7.80%
Feb-2035 283 38,533.17 2,275.35 250.47 2,024.88 36,508.29 12.2% 7.80%
Mar-2035 284 36,508.29 2,275.35 237.30 2,038.04 34,470.25 11.5% 7.80%
Apr-2035 285 34,470.25 2,275.35 224.06 2,051.29 32,418.96 10.8% 7.80%
May-2035 286 32,418.96 2,275.35 210.72 2,064.62 30,354.33 10.1% 7.80%
Jun-2035 287 30,354.33 2,275.35 197.30 2,078.04 28,276.29 9.4% 7.80%
Jul-2035 288 28,276.29 2,275.35 183.80 2,091.55 26,184.73 8.7% 7.80%
Aug-2035 289 26,184.73 2,275.35 170.20 2,105.15 24,079.59 8.0% 7.80%
Sep-2035 290 24,079.59 2,275.35 156.52 2,118.83 21,960.75 7.3% 7.80%
Oct-2035 291 21,960.75 2,275.35 142.74 2,132.60 19,828.15 6.6% 7.80%
Nov-2035 292 19,828.15 2,275.35 128.88 2,146.47 17,681.69 5.9% 7.80%
Dec-2035 293 17,681.69 2,275.35 114.93 2,160.42 15,521.27 5.2% 7.80%
Jan-2036 294 15,521.27 2,275.35 100.89 2,174.46 13,346.81 4.4% 7.80%
Feb-2036 295 13,346.81 2,275.35 86.75 2,188.59 11,158.22 3.7% 7.80%
Page 5 of 8
Loan Amortization Table www.excel-skills.com.au
Loan Principle Amount 300,000.00
Annual Interest Rate 7.40%
Loan Period (in months) 300.00
Original Repayment Amount 2,197.50
Loan Start Date 8/15/2011
Repayment Type End
Repayment Opening Loan Interest Capital Closing % Capital
Month Number Balance Repayment Charged Repaid Balance Outstanding Interest Rate
Mar-2036 296 11,158.22 2,275.35 72.53 2,202.82 8,955.40 3.0% 7.80%
Apr-2036 297 8,955.40 2,275.35 58.21 2,217.14 6,738.26 2.2% 7.80%
May-2036 298 6,738.26 2,275.35 43.80 2,231.55 4,506.71 1.5% 7.80%
Jun-2036 299 4,506.71 2,275.35 29.29 2,246.05 2,260.65 0.8% 7.80%
Jul-2036 300 2,260.65 2,275.35 14.69 2,260.65 - 0.0% 7.80%
Aug-2036 301 - - - - - 0.0% 7.80%
Sep-2036 302 - - - - - 0.0% 7.80%
Oct-2036 303 - - - - - 0.0% 7.80%
Nov-2036 304 - - - - - 0.0% 7.80%
Dec-2036 305 - - - - - 0.0% 7.80%
Jan-2037 306 - - - - - 0.0% 7.80%
Feb-2037 307 - - - - - 0.0% 7.80%
Mar-2037 308 - - - - - 0.0% 7.80%
Apr-2037 309 - - - - - 0.0% 7.80%
May-2037 310 - - - - - 0.0% 7.80%
Jun-2037 311 - - - - - 0.0% 7.80%
Jul-2037 312 - - - - - 0.0% 7.80%
Aug-2037 313 - - - - - 0.0% 7.80%
Sep-2037 314 - - - - - 0.0% 7.80%
Oct-2037 315 - - - - - 0.0% 7.80%
Nov-2037 316 - - - - - 0.0% 7.80%
Dec-2037 317 - - - - - 0.0% 7.80%
Jan-2038 318 - - - - - 0.0% 7.80%
Feb-2038 319 - - - - - 0.0% 7.80%
Mar-2038 320 - - - - - 0.0% 7.80%
Apr-2038 321 - - - - - 0.0% 7.80%
May-2038 322 - - - - - 0.0% 7.80%
Jun-2038 323 - - - - - 0.0% 7.80%
Jul-2038 324 - - - - - 0.0% 7.80%
Aug-2038 325 - - - - - 0.0% 7.80%
Sep-2038 326 - - - - - 0.0% 7.80%
Oct-2038 327 - - - - - 0.0% 7.80%
Nov-2038 328 - - - - - 0.0% 7.80%
Dec-2038 329 - - - - - 0.0% 7.80%
Jan-2039 330 - - - - - 0.0% 7.80%
Feb-2039 331 - - - - - 0.0% 7.80%
Mar-2039 332 - - - - - 0.0% 7.80%
Apr-2039 333 - - - - - 0.0% 7.80%
May-2039 334 - - - - - 0.0% 7.80%
Jun-2039 335 - - - - - 0.0% 7.80%
Jul-2039 336 - - - - - 0.0% 7.80%
Aug-2039 337 - - - - - 0.0% 7.80%
Sep-2039 338 - - - - - 0.0% 7.80%
Oct-2039 339 - - - - - 0.0% 7.80%
Nov-2039 340 - - - - - 0.0% 7.80%
Dec-2039 341 - - - - - 0.0% 7.80%
Jan-2040 342 - - - - - 0.0% 7.80%
Feb-2040 343 - - - - - 0.0% 7.80%
Mar-2040 344 - - - - - 0.0% 7.80%
Apr-2040 345 - - - - - 0.0% 7.80%
May-2040 346 - - - - - 0.0% 7.80%
Jun-2040 347 - - - - - 0.0% 7.80%
Jul-2040 348 - - - - - 0.0% 7.80%
Aug-2040 349 - - - - - 0.0% 7.80%
Sep-2040 350 - - - - - 0.0% 7.80%
Oct-2040 351 - - - - - 0.0% 7.80%
Nov-2040 352 - - - - - 0.0% 7.80%
Dec-2040 353 - - - - - 0.0% 7.80%
Jan-2041 354 - - - - - 0.0% 7.80%
Page 6 of 8
Loan Amortization Table www.excel-skills.com.au
Loan Principle Amount 300,000.00
Annual Interest Rate 7.40%
Loan Period (in months) 300.00
Original Repayment Amount 2,197.50
Loan Start Date 8/15/2011
Repayment Type End
Repayment Opening Loan Interest Capital Closing % Capital
Month Number Balance Repayment Charged Repaid Balance Outstanding Interest Rate
Feb-2041 355 - - - - - 0.0% 7.80%
Mar-2041 356 - - - - - 0.0% 7.80%
Apr-2041 357 - - - - - 0.0% 7.80%
May-2041 358 - - - - - 0.0% 7.80%
Jun-2041 359 - - - - - 0.0% 7.80%
Jul-2041 360 - - - - - 0.0% 7.80%
682,370.89 382,370.89 300,000.00
Page 7 of 8
Loan Summary www.excel-skills.com.au
Review Date 12/31/2012
Amortization!A28
Month End Date 12/31/2012
Loan Start Date 8/15/2011
To Date
Total Loan Repayments 38,447.36
Total Interest Paid 32,546.43
Total Capital Repayment 5,900.94
Outstanding Capital Balance 294,099.06
Outstanding Capital % 98.0%
Previous 12 Months
Total Loan Repayments 27,304.18
Total Interest Paid 23,118.67
Total Capital Repayment 4,185.51
Next 12 Months
Total Loan Repayments 27,304.18
Total Interest Paid 22,780.27
Total Capital Repayment 4,523.91
Loan Period
Total Loan Repayments 682,370.89
Total Interest Paid 382,370.89
Total Capital Repayment 300,000.00
Page 7 of 7
