Mortgage Calculator Excel Template - Free Download | Page 6
4.8,
2773
votes
Please vote for this template if it helps you.
Page 5 of 11
Annual Amortization Table
© www.excel-skills.co.uk
Years
Opening
Balance
Loan
Repayment
Interest
Charged
Capital Repaid
Closing Balance
% Capital
Outstanding
1 300,000.00 19,002.13 11,870.19 7,131.94 292,868.06 97.6%
2 292,868.06 19,002.13 11,579.62 7,422.50 285,445.56 95.1%
3 285,445.56 19,002.13 11,277.22 7,724.91 277,720.66 92.6%
4 277,720.66 19,002.13 10,962.50 8,039.63 269,681.03 89.9%
5 269,681.03 19,002.13 10,634.95 8,367.18 261,313.85 87.1%
6 261,313.85 19,002.13 10,294.06 8,708.07 252,605.78 84.2%
7 252,605.78 19,002.13 9,939.28 9,062.85 243,542.93 81.2%
8 243,542.93 19,002.13 9,570.04 9,432.08 234,110.85 78.0%
9 234,110.85 19,002.13 9,185.76 9,816.36 224,294.48 74.8%
10 224,294.48 19,002.13 8,785.83 10,216.30 214,078.19 71.4%
11 214,078.19 19,002.13 8,369.60 10,632.52 203,445.67 67.8%
12 203,445.67 19,002.13 7,936.42 11,065.71 192,379.96 64.1%
13 192,379.96 19,002.13 7,485.58 11,516.54 180,863.42 60.3%
14 180,863.42 19,002.13 7,016.38 11,985.74 168,877.67 56.3%
15 168,877.67 19,002.13 6,528.06 12,474.06 156,403.61 52.1%
16 156,403.61 19,002.13 6,019.85 12,982.27 143,421.34 47.8%
17 143,421.34 19,002.13 5,490.93 13,511.19 129,910.14 43.3%
18 129,910.14 19,002.13 4,940.47 14,061.66 115,848.49 38.6%
19 115,848.49 19,002.13 4,367.57 14,634.55 101,213.93 33.7%
20 101,213.93 19,002.13 3,771.34 15,230.79 85,983.15 28.7%
21 85,983.15 19,002.13 3,150.81 15,851.31 70,131.83 23.4%
22 70,131.83 19,002.13 2,505.01 16,497.12 53,634.71 17.9%
23 53,634.71 19,002.13 1,832.89 17,169.24 36,465.48 12.2%
24 36,465.48 19,002.13 1,133.39 17,868.74 18,596.74 6.2%
25 18,596.74 19,002.13 405.39 18,596.74 - 0.0%
26 - - - - - 0.0%
27 - - - - - 0.0%
28 - - - - - 0.0%
29 - - - - - 0.0%
30 - - - - - 0.0%
source: dataease.com
