Amortization Calculator Excel - Free Download | Page 5
4.5, 3575 votes
Please vote for this template if it helps you.
Amortization Calculator Excel Page 5
Amortization Calculator Excel
Page 4 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
Nov-2031 208 265,958.62 9,158.67 2,050.10 7,108.57 258,850.05 25.9% 9.25%
Dec-2031 209 258,850.05 9,158.67 1,995.30 7,163.37 251,686.69 25.2% 9.25%
Jan-2032 210 251,686.69 9,158.67 1,940.08 7,218.58 244,468.10 24.4% 9.25%
Feb-2032 211 244,468.10 9,158.67 1,884.44 7,274.23 237,193.88 23.7% 9.25%
Mar-2032 212 237,193.88 9,158.67 1,828.37 7,330.30 229,863.58 23.0% 9.25%
Apr-2032 213 229,863.58 9,158.67 1,771.87 7,386.80 222,476.78 22.2% 9.25%
May-2032 214 222,476.78 9,158.67 1,714.93 7,443.74 215,033.03 21.5% 9.25%
Jun-2032 215 215,033.03 9,158.67 1,657.55 7,501.12 207,531.91 20.8% 9.25%
Jul-2032 216 207,531.91 9,158.67 1,599.73 7,558.94 199,972.97 20.0% 9.25%
Aug-2032 217 199,972.97 9,158.67 1,541.46 7,617.21 192,355.76 19.2% 9.25%
Sep-2032 218 192,355.76 9,158.67 1,482.74 7,675.93 184,679.83 18.5% 9.25%
Oct-2032 219 184,679.83 9,158.67 1,423.57 7,735.09 176,944.74 17.7% 9.25%
Nov-2032 220 176,944.74 9,158.67 1,363.95 7,794.72 169,150.02 16.9% 9.25%
Dec-2032 221 169,150.02 9,158.67 1,303.86 7,854.80 161,295.21 16.1% 9.25%
Jan-2033 222 161,295.21 9,158.67 1,243.32 7,915.35 153,379.86 15.3% 9.25%
Feb-2033 223 153,379.86 9,158.67 1,182.30 7,976.37 145,403.50 14.5% 9.25%
Mar-2033 224 145,403.50 9,158.67 1,120.82 8,037.85 137,365.65 13.7% 9.25%
Apr-2033 225 137,365.65 9,158.67 1,058.86 8,099.81 129,265.84 12.9% 9.25%
May-2033 226 129,265.84 9,158.67 996.42 8,162.24 121,103.59 12.1% 9.25%
Jun-2033 227 121,103.59 9,158.67 933.51 8,225.16 112, 878.43 11.3% 9.25%
Jul-2033 228 11 2,878.43 9,158.67 870.10 8,288.56 104,589.87 10.5% 9.25%
Aug-2033 229 104,589.87 9,158.67 806.21 8,352.45 96,237.41 9.6% 9.25%
Sep-2033 230 96,237.41 9,158.67 741.83 8,416.84 87,820.58 8.8% 9.25%
Oct-2033 231 87,820.58 9,158.67 676.95 8,481.72 79,338.86 7.9% 9.25%
Nov-2033 232 79,338.86 9,158.67 611.57 8,547.10 70,791.76 7.1% 9.25%
Dec-2033 233 70,791.76 9,158.67 545.69 8,612.98 62,178.78 6.2% 9.25%
Jan-2034 234 62,178.78 9,158.67 479.29 8,679.37 53,499.40 5.3% 9.25%
Feb-2034 235 53,499.40 9,158.67 412.39 8,746.28 44,753.13 4.5% 9.25%
Mar-2034 236 44,753.13 9,158.67 344.97 8,813.70 35,939.43 3.6% 9.25%
Apr-2034 237 35,939.43 9,158.67 277.03 8,881.64 27,057.80 2.7% 9.25%
May-2034 238 27,057.80 9,158.67 208.57 8,950.10 18,107.70 1.8% 9.25%
Jun-2034 239 18,107.70 9,158.67 139.58 9,019.09 9,088.61 0.9% 9.25%
Jul-2034 240 9,088.61 9,158.67 70.06 9,088.61 - 0.0% 9.25%
Aug-2034 241 - - - - - 0.0% 9.25%
Sep-2034 242 - - - - - 0.0% 9.25%
Oct-2034 243 - - - - - 0.0% 9.25%
Nov-2034 244 - - - - - 0.0% 9.25%
Dec-2034 245 - - - - - 0.0% 9.25%
Jan-2035 246 - - - - - 0.0% 9.25%
Feb-2035 247 - - - - - 0.0% 9.25%
Mar-2035 248 - - - - - 0.0% 9.25%
Apr-2035 249 - - - - - 0.0% 9.25%
May-2035 250 - - - - - 0.0% 9.25%
Jun-2035 251 - - - - - 0.0% 9.25%
Jul-2035 252 - - - - - 0.0% 9.25%
Aug-2035 253 - - - - - 0.0% 9.25%
Sep-2035 254 - - - - - 0.0% 9.25%
Oct-2035 255 - - - - - 0.0% 9.25%
Nov-2035 256 - - - - - 0.0% 9.25%
Dec-2035 257 - - - - - 0.0% 9.25%
Jan-2036 258 - - - - - 0.0% 9.25%
Feb-2036 259 - - - - - 0.0% 9.25%
Mar-2036 260 - - - - - 0.0% 9.25%
Apr-2036 261 - - - - - 0.0% 9.25%
May-2036 262 - - - - - 0.0% 9.25%
Jun-2036 263 - - - - - 0.0% 9.25%
Jul-2036 264 - - - - - 0.0% 9.25%
Aug-2036 265 - - - - - 0.0% 9.25%
Sep-2036 266 - - - - - 0.0% 9.25%
Oct-2036 267 - - - - - 0.0% 9.25%
Nov-2036 268 - - - - - 0.0% 9.25%
Dec-2036 269 - - - - - 0.0% 9.25%
Jan-2037 270 - - - - - 0.0% 9.25%
Feb-2037 271 - - - - - 0.0% 9.25%
Mar-2037 272 - - - - - 0.0% 9.25%
Apr-2037 273 - - - - - 0.0% 9.25%
May-2037 274 - - - - - 0.0% 9.25%
Jun-2037 275 - - - - - 0.0% 9.25%
Jul-2037 276 - - - - - 0.0% 9.25%
Amortization Calculator Excel Previous Page Amortization Calculator Excel Next Page
Amortization Calculator Excel