Amortization Calculator Excel - Free Download | Page 3
4.5, 3575 votes
Please vote for this template if it helps you.
Amortization Calculator Excel Page 3
Amortization Calculator Excel
Page 2 of 7
Loan Amortization Table
© www.excel-skills.com
1,000,000.00
9.25%
240.00
9,158.67
8/15/14
End
Month
Repayment
Number
Opening
Balance
Loan
Repayment
Interest
Charged
Capital Repaid
Closing
Balance
% Capital
Outstanding
Interest Rate
Loan Start Date
Repayment Type
Loan Principle Amount
Annual Interest Rate
Loan Period (in months)
Original Repayment Amount
May-2020 70 868,547.36 9,158.67 6,695.05 2,463.62 866,083.74 86.6% 9.25%
Jun-2020 71 866,083.74 9,158.67 6,676.06 2,482.61 863,601.13 86.4% 9.25%
Jul-2020 72 863,601.13 9,158.67 6,656.93 2,501.74 861,099.39 86.1% 9.25%
Aug-2020 73 861,099.39 9,158.67 6,637.64 2,521.03 858,578.36 85.9% 9.25%
Sep-2020 74 858,578.36 9,158.67 6,618.21 2,540.46 856,037.90 85.6% 9.25%
Oct-2020 75 856,037.90 9,158.67 6,598.63 2,560.04 853,477.86 85.3% 9.25%
Nov-2020 76 853,477.86 9,158.67 6,578.89 2,579.78 850,898.09 85.1% 9.25%
Dec-2020 77 850,898.09 9,158.67 6,559.01 2,599.66 848,298.42 84.8% 9.25%
Jan-2021 78 848,298.42 9,158.67 6,538.97 2,619.70 845,678.72 84.6% 9.25%
Feb-2021 79 845,678.72 9,158.67 6,518.77 2,639.89 843,038.83 84.3% 9.25%
Mar-2021 80 843,038.83 9,158.67 6,498.42 2,660.24 840,378.58 84.0% 9.25%
Apr-2021 81 840,378.58 9,158.67 6,477.92 2,680.75 837,697.83 83.8% 9.25%
May-2021 82 837,697.83 9,158.67 6,457.25 2,701.41 834,996.42 83.5% 9.25%
Jun-2021 83 834,996.42 9,158.67 6,436.43 2,722.24 832,274.18 83.2% 9.25%
Jul-2021 84 832,274.18 9,158.67 6,415.45 2,743.22 829,530.96 83.0% 9.25%
Aug-2021 85 829,530.96 9,158.67 6,394.30 2,764.37 826,766.59 82.7% 9.25%
Sep-2021 86 826,766.59 9,158.67 6,372.99 2,785.68 823,980.92 82.4% 9.25%
Oct-2021 87 823,980.92 9,158.67 6,351.52 2,807.15 821,173.77 82.1% 9.25%
Nov-2021 88 821,173.77 9,158.67 6,329.88 2,828.79 818,344.98 81.8% 9.25%
Dec-2021 89 818,344.98 9,158.67 6,308.08 2,850.59 815,494.39 81.5% 9.25%
Jan-2022 90 815,494.39 9,158.67 6,286.10 2,872.57 812,621.82 81.3% 9.25%
Feb-2022 91 812,621.82 9,158.67 6,263.96 2,894.71 809,727.11 81.0% 9.25%
Mar-2022 92 809,727.11 9,158.67 6,241.65 2,917.02 806,810.09 80.7% 9.25%
Apr-2022 93 806,810.09 9,158.67 6,219.16 2,939.51 803,870.58 80.4% 9.25%
May-2022 94 803,870.58 9,158.67 6,196.50 2,962.17 800,908.42 80.1% 9.25%
Jun-2022 95 800,908.42 9,158.67 6,173.67 2,985.00 797,923.42 79.8% 9.25%
Jul-2022 96 797,923.42 9,158.67 6,150.66 3,008.01 794,915.41 79.5% 9.25%
Aug-2022 97 794,915.41 9,158.67 6,127.47 3,031.20 791,884.22 79.2% 9.25%
Sep-2022 98 791,884.22 9,158.67 6,104.11 3,054.56 788,829.65 78.9% 9.25%
Oct-2022 99 788,829.65 9,158.67 6,080.56 3,078.11 785,751.55 78.6% 9.25%
Nov-2022 100 785,751.55 9,158.67 6,056.83 3,101.83 782,649.71 78.3% 9.25%
Dec-2022 101 782,649.71 9,158.67 6,032.92 3,125.74 779,523.97 78.0% 9.25%
Jan-2023 102 779,523.97 9,158.67 6,008.83 3,149.84 776,374.13 77.6% 9.25%
Feb-2023 103 776,374.13 9,158.67 5,984.55 3,174.12 773,200.02 77.3% 9.25%
Mar-2023 104 773,200.02 9,158.67 5,960.08 3,198.58 770,001.43 77.0% 9.25%
Apr-2023 105 770,001.43 9,158.67 5,935.43 3,223.24 766,778.19 76.7% 9.25%
May-2023 106 766,778.19 9,158.67 5,910.58 3,248.09 763,530.10 76.4% 9.25%
Jun-2023 107 763,530.10 9,158.67 5,885.54 3,273.12 760,256.98 76.0% 9.25%
Jul-2023 108 760,256.98 9,158.67 5,860.31 3,298.35 756,958.63 75.7% 9.25%
Aug-2023 109 756,958.63 9,158.67 5,834.89 3,323.78 753,634.85 75.4% 9.25%
Sep-2023 110 753,634.85 9,158.67 5,809.27 3,349.40 750,285.45 75.0% 9.25%
Oct-2023 111 750,285.45 9,158.67 5,783.45 3,375.22 746,910.23 74.7% 9.25%
Nov-2023 112 746,910.23 9,158.67 5,757.43 3,401.24 743,508.99 74.4% 9.25%
Dec-2023 113 743,508.99 9,158.67 5,731.22 3,427.45 740,081.54 74.0% 9.25%
Jan-2024 114 740,081.54 9,158.67 5,704.80 3,453.87 736,627.67 73.7% 9.25%
Feb-2024 115 736,627.67 9,158.67 5,678.17 3,480.50 733,147.17 73.3% 9.25%
Mar-2024 116 733,147.17 9,158.67 5,651.34 3,507.33 729,639.85 73.0% 9.25%
Apr-2024 117 729,639.85 9,158.67 5,624.31 3,534.36 726,105.48 72.6% 9.25%
May-2024 118 726,105.48 9,158.67 5,597.06 3,561.61 722,543.88 72.3% 9.25%
Jun-2024 119 722,543.88 9,158.67 5,569.61 3,589.06 718,954.82 71.9% 9.25%
Jul-2024 120 718,954.82 9,158.67 5,541.94 3,616.72 715,338.09 71.5% 9.25%
Aug-2024 121 715,338.09 9,158.67 5,514.06 3,644.60 711,693.49 71.2% 9.25%
Sep-2024 122 711,693.49 9,158.67 5,485.97 3,672.70 708,020.79 70.8% 9.25%
Oct-2024 123 708,020.79 9,158.67 5,457.66 3,701.01 704,319.78 70.4% 9.25%
Nov-2024 124 704,319.78 9,158.67 5,429.13 3,729.54 700,590.25 70.1% 9.25%
Dec-2024 125 700,590.25 9,158.67 5,400.38 3,758.29 696,831.96 69.7% 9.25%
Jan-2025 126 696,831.96 9,158.67 5,371.41 3,787.26 693,044.71 69.3% 9.25%
Feb-2025 127 693,044.71 9,158.67 5,342.22 3,816.45 689,228.26 68.9% 9.25%
Mar-2025 128 689,228.26 9,158.67 5,312.80 3,845.87 685,382.39 68.5% 9.25%
Apr-2025 129 685,382.39 9,158.67 5,283.16 3,875.51 681,506.88 68.2% 9.25%
May-2025 130 681,506.88 9,158.67 5,253.28 3,905.39 677,601.49 67.8% 9.25%
Jun-2025 131 677,601.49 9,158.67 5,223.18 3,935.49 673,666.00 67.4% 9.25%
Jul-2025 132 673,666.00 9,158.67 5,192.84 3,965.83 669,700.18 67.0% 9.25%
Aug-2025 133 669,700.18 9,158.67 5,162.27 3,996.40 665,703.78 66.6% 9.25%
Sep-2025 134 665,703.78 9,158.67 5,131.47 4,027.20 661,676.58 66.2% 9.25%
Oct-2025 135 661,676.58 9,158.67 5,100.42 4,058.24 657,618.33 65.8% 9.25%
Nov-2025 136 657,618.33 9,158.67 5,069.14 4,089.53 653,528.81 65.4% 9.25%
Dec-2025 137 653,528.81 9,158.67 5,037.62 4,121.05 649,407.76 64.9% 9.25%
Jan-2026 138 649,407.76 9,158.67 5,005.85 4,152.82 645,254.94 64.5% 9.25%
Amortization Calculator Excel Previous Page Amortization Calculator Excel Next Page
Amortization Calculator Excel