Amortization Calculator Excel - Free Download | Page 4
4.5, 3575 votes
Please vote for this template if it helps you.
Amortization Calculator Excel Page 4
Amortization Calculator Excel
Page 3 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
Feb-2026 139 645,254.94 9,158.67 4,973.84 4,184.83 641,070.11 64.1% 9.25%
Mar-2026 140 641,070.11 9,158.67 4,941.58 4,217.09 636,853.03 63.7% 9.25%
Apr-2026 141 636,853.03 9,158.67 4,909.08 4,249.59 632,603.43 63.3% 9.25%
May-2026 142 632,603.43 9,158.67 4,876.32 4,282.35 628,321.08 62.8% 9.25%
Jun-2026 143 628,321.08 9,158.67 4,843.31 4,315.36 624,005.72 62.4% 9.25%
Jul-2026 144 624,005.72 9,158.67 4,810.04 4,348.62 619,657.10 62.0% 9.25%
Aug-2026 145 619,657.10 9,158.67 4,776.52 4,382.14 615,274.95 61.5% 9.25%
Sep-2026 146 615,274.95 9,158.67 4,742.74 4,415.92 610,859.03 61.1% 9.25%
Oct-2026 147 610,859.03 9,158.67 4,708.71 4,449.96 606,409.07 60.6% 9.25%
Nov-2026 148 606,409.07 9,158.67 4,674.40 4,484.27 601,924.80 60.2% 9.25%
Dec-2026 149 601,924.80 9,158.67 4,639.84 4,518.83 597,405.97 59.7% 9.25%
Jan-2027 150 597,405.97 9,158.67 4,605.00 4,553.66 592,852.31 59.3% 9.25%
Feb-2027 151 592,852.31 9,158.67 4,569.90 4,588.77 588,263.54 58.8% 9.25%
Mar-2027 152 588,263.54 9,158.67 4,534.53 4,624.14 583,639.40 58.4% 9.25%
Apr-2027 153 583,639.40 9,158.67 4,498.89 4,659.78 578,979.62 57.9% 9.25%
May-2027 154 578,979.62 9,158.67 4,462.97 4,695.70 574,283.92 57.4% 9.25%
Jun-2027 155 574,283.92 9,158.67 4,426.77 4,731.90 569,552.03 57.0% 9.25%
Jul-2027 156 569,552.03 9,158.67 4,390.30 4,768.37 564,783.65 56.5% 9.25%
Aug-2027 157 564,783.65 9,158.67 4,353.54 4,805.13 559,978.53 56.0% 9.25%
Sep-2027 158 559,978.53 9,158.67 4,316.50 4,842.17 555,136.36 55.5% 9.25%
Oct-2027 159 555,136.36 9,158.67 4,279.18 4,879.49 550,256.87 55.0% 9.25%
Nov-2027 160 550,256.87 9,158.67 4,241.56 4,917.10 545,339.76 54.5% 9.25%
Dec-2027 161 545,339.76 9,158.67 4,203.66 4,955.01 540,384.75 54.0% 9.25%
Jan-2028 162 540,384.75 9,158.67 4,165.47 4,993.20 535,391.55 53.5% 9.25%
Feb-2028 163 535,391.55 9,158.67 4,126.98 5,031.69 530,359.86 53.0% 9.25%
Mar-2028 164 530,359.86 9,158.67 4,088.19 5,070.48 525,289.38 52.5% 9.25%
Apr-2028 165 525,289.38 9,158.67 4,049.11 5,109.56 520,179.82 52.0% 9.25%
May-2028 166 520,179.82 9,158.67 4,009.72 5,148.95 515,030.87 51.5% 9.25%
Jun-2028 167 515,030.87 9,158.67 3,970.03 5,188.64 509,842.23 51.0% 9.25%
Jul-2028 168 509,842.23 9,158.67 3,930.03 5,228.63 504,613.60 50.5% 9.25%
Aug-2028 169 504,613.60 9,158.67 3,889.73 5,268.94 499,344.66 49.9% 9.25%
Sep-2028 170 499,344.66 9,158.67 3,849.12 5,309.55 494,035.11 49.4% 9.25%
Oct-2028 171 494,035.11 9,158.67 3,808.19 5,350.48 488,684.62 48.9% 9.25%
Nov-2028 172 488,684.62 9,158.67 3,766.94 5,391.72 483,292.90 48.3% 9.25%
Dec-2028 173 483,292.90 9,158.67 3,725.38 5,433.29 477,859.61 47.8% 9.25%
Jan-2029 174 477,859.61 9,158.67 3,683.50 5,475.17 472,384.45 47.2% 9.25%
Feb-2029 175 472,384.45 9,158.67 3,641.30 5,517.37 466,867.08 46.7% 9.25%
Mar-2029 176 466,867.08 9,158.67 3,598.77 5,559.90 461,307.17 46.1% 9.25%
Apr-2029 177 461,307.17 9,158.67 3,555.91 5,602.76 455,704.42 45.6% 9.25%
May-2029 178 455,704.42 9,158.67 3,512.72 5,645.95 450,058.47 45.0% 9.25%
Jun-2029 179 450,058.47 9,158.67 3,469.20 5,689.47 444,369.00 44.4% 9.25%
Jul-2029 180 444,369.00 9,158.67 3,425.34 5,733.32 438,635.68 43.9% 9.25%
Aug-2029 181 438,635.68 9,158.67 3,381.15 5,777.52 432,858.16 43.3% 9.25%
Sep-2029 182 432,858.16 9,158.67 3,336.61 5,822.05 427,036.11 42.7% 9.25%
Oct-2029 183 427,036.11 9,158.67 3,291.74 5,866.93 421,169.17 42.1% 9.25%
Nov-2029 184 421,169.17 9,158.67 3,246.51 5,912.16 415,257.02 41.5% 9.25%
Dec-2029 185 415,257.02 9,158.67 3,200.94 5,957.73 409,299.29 40.9% 9.25%
Jan-2030 186 409,299.29 9,158.67 3,155.02 6,003.65 403,295.64 40.3% 9.25%
Feb-2030 187 403,295.64 9,158.67 3,108.74 6,049.93 397,245.71 39.7% 9.25%
Mar-2030 188 397,245.71 9,158.67 3,062.10 6,096.57 391,149.14 39.1% 9.25%
Apr-2030 189 391,149.14 9,158.67 3,015.11 6,143.56 385,005.58 38.5% 9.25%
May-2030 190 385,005.58 9,158.67 2,967.75 6,190.92 378,814.66 37.9% 9.25%
Jun-2030 191 378,814.66 9,158.67 2,920.03 6,238.64 372,576.02 37.3% 9.25%
Jul-2030 192 372,576.02 9,158.67 2,871.94 6,286.73 366,289.30 36.6% 9.25%
Aug-2030 193 366,289.30 9,158.67 2,823.48 6,335.19 359,954.11 36.0% 9.25%
Sep-2030 194 359,954.11 9,158.67 2,774.65 6,384.02 353,570.08 35.4% 9.25%
Oct-2030 195 353,570.08 9,158.67 2,725.44 6,433.23 347,136.85 34.7% 9.25%
Nov-2030 196 347,136.85 9,158.67 2,675.85 6,482.82 340,654.03 34.1% 9.25%
Dec-2030 197 340,654.03 9,158.67 2,625.87 6,532.79 334,121.24 33.4% 9.25%
Jan-2031 198 334,121.24 9,158.67 2,575.52 6,583.15 327,538.09 32.8% 9.25%
Feb-2031 199 327,538.09 9,158.67 2,524.77 6,633.90 320,904.19 32.1% 9.25%
Mar-2031 200 320,904.19 9,158.67 2,473.64 6,685.03 314,219.16 31.4% 9.25%
Apr-2031 201 314,219.16 9,158.67 2,422.11 6,736.56 307,482.60 30.7% 9.25%
May-2031 202 307,482.60 9,158.67 2,370.18 6,788.49 300,694.11 30.1% 9.25%
Jun-2031 203 300,694.11 9,158.67 2,317.85 6,840.82 293,853.29 29.4% 9.25%
Jul-2031 204 293,853.29 9,158.67 2,265.12 6,893.55 286,959.74 28.7% 9.25%
Aug-2031 205 286,959.74 9,158.67 2,211.98 6,946.69 280,013.05 28.0% 9.25%
Sep-2031 206 280,013.05 9,158.67 2,158.43 7,000.23 273,012.82 27.3% 9.25%
Oct-2031 207 273,012.82 9,158.67 2,104.47 7,054.19 265,958.62 26.6% 9.25%
Amortization Calculator Excel Previous Page Amortization Calculator Excel Next Page
Amortization Calculator Excel