Current Month January 2022

Tab Name Current Payment # Current Balance Cumulative Interest End Date
ASSET 1 13 $ 184,448.31 $ 10,448.31 May 2026
ASSET 2 25 $ 201,409.27 $ 26,409.27 February 2024
ASSET 3 25 $ 402,818.54 $ 52,818.54 October 2025
ASSET 4
ASSET 5
ASSET 6
ASSET 7
ASSET 8
ASSET 9
ASSET 10
Payments Remaining
52
25
45
Starting Month Jan 2021
Loan Amount $ 200,000.00
Total Payments 65
Annual Interest Rate 5.00%
Payment Amount $ 2,000.00

Payment # Month Opening Balance Payment Principal Paid Interest Paid Ending Balance
1 Jan 2021 $ 200,000.00 $ 2,000.00 $ 1,166.67 $ 833.33 $ 198,833.33
2 Feb 2021 $ 198,833.33 $ 2,000.00 $ 1,171.53 $ 828.47 $ 197,661.81
3 Mar 2021 $ 197,661.81 $ 2,000.00 $ 1,176.41 $ 823.59 $ 196,485.40
4 Apr 2021 $ 196,485.40 $ 2,000.00 $ 1,181.31 $ 818.69 $ 195,304.09
5 May 2021 $ 195,304.09 $ 2,000.00 $ 1,186.23 $ 813.77 $ 194,117.85
6 Jun 2021 $ 194,117.85 $ 2,000.00 $ 1,191.18 $ 808.82 $ 192,926.68
7 Jul 2021 $ 192,926.68 $ 2,000.00 $ 1,196.14 $ 803.86 $ 191,730.54
8 Aug 2021 $ 191,730.54 $ 2,000.00 $ 1,201.12 $ 798.88 $ 190,529.42
9 Sep 2021 $ 190,529.42 $ 2,000.00 $ 1,206.13 $ 793.87 $ 189,323.29
10 Oct 2021 $ 189,323.29 $ 2,000.00 $ 1,211.15 $ 788.85 $ 188,112.13
11 Nov 2021 $ 188,112.13 $ 2,000.00 $ 1,216.20 $ 783.80 $ 186,895.94
12 Dec 2021 $ 186,895.94 $ 2,000.00 $ 1,221.27 $ 778.73 $ 185,674.67
13 Jan 2022 $ 185,674.67 $ 2,000.00 $ 1,226.36 $ 773.64 $ 184,448.31
14 Feb 2022 $ 184,448.31 $ 2,000.00 $ 1,231.47 $ 768.53 $ 183,216.85
15 Mar 2022 $ 183,216.85 $ 2,000.00 $ 1,236.60 $ 763.40 $ 181,980.25
16 Apr 2022 $ 181,980.25 $ 2,000.00 $ 1,241.75 $ 758.25 $ 180,738.50
17 May 2022 $ 180,738.50 $ 2,000.00 $ 1,246.92 $ 753.08 $ 179,491.58
18 Jun 2022 $ 179,491.58 $ 2,000.00 $ 1,252.12 $ 747.88 $ 178,239.46
19 Jul 2022 $ 178,239.46 $ 2,000.00 $ 1,257.34 $ 742.66 $ 176,982.13
20 Aug 2022 $ 176,982.13 $ 2,000.00 $ 1,262.57 $ 737.43 $ 175,719.55
21 Sep 2022 $ 175,719.55 $ 2,000.00 $ 1,267.84 $ 732.16 $ 174,451.72
22 Oct 2022 $ 174,451.72 $ 2,000.00 $ 1,273.12 $ 726.88 $ 173,178.60
23 Nov 2022 $ 173,178.60 $ 2,000.00 $ 1,278.42 $ 721.58 $ 171,900.18
24 Dec 2022 $ 171,900.18 $ 2,000.00 $ 1,283.75 $ 716.25 $ 170,616.43
25 Jan 2023 $ 170,616.43 $ 2,000.00 $ 1,289.10 $ 710.90 $ 169,327.33
26 Feb 2023 $ 169,327.33 $ 2,000.00 $ 1,294.47 $ 705.53 $ 168,032.86
27 Mar 2023 $ 168,032.86 $ 2,000.00 $ 1,299.86 $ 700.14 $ 166,733.00
28 Apr 2023 $ 166,733.00 $ 2,000.00 $ 1,305.28 $ 694.72 $ 165,427.72
29 May 2023 $ 165,427.72 $ 2,000.00 $ 1,310.72 $ 689.28 $ 164,117.00
30 Jun 2023 $ 164,117.00 $ 2,000.00 $ 1,316.18 $ 683.82 $ 162,800.82
31 Jul 2023 $ 162,800.82 $ 2,000.00 $ 1,321.66 $ 678.34 $ 161,479.16
32 Aug 2023 $ 161,479.16 $ 2,000.00 $ 1,327.17 $ 672.83 $ 160,151.99
33 Sep 2023 $ 160,151.99 $ 2,000.00 $ 1,332.70 $ 667.30 $ 158,819.29
34 Oct 2023 $ 158,819.29 $ 2,000.00 $ 1,338.25 $ 661.75 $ 157,481.03
35 Nov 2023 $ 157,481.03 $ 2,000.00 $ 1,343.83 $ 656.17 $ 156,137.20
36 Dec 2023 $ 156,137.20 $ 2,000.00 $ 1,349.43 $ 650.57 $ 154,787.78
37 Jan 2024 $ 154,787.78 $ 2,000.00 $ 1,355.05 $ 644.95 $ 153,432.72
38 Feb 2024 $ 153,432.72 $ 2,000.00 $ 1,360.70 $ 639.30 $ 152,072.03
39 Mar 2024 $ 152,072.03 $ 2,000.00 $ 1,366.37 $ 633.63 $ 150,705.66
40 Apr 2024 $ 150,705.66 $ 2,000.00 $ 1,372.06 $ 627.94 $ 149,333.60
41 May 2024 $ 149,333.60 $ 2,000.00 $ 1,377.78 $ 622.22 $ 147,955.82
42 Jun 2024 $ 147,955.82 $ 2,000.00 $ 1,383.52 $ 616.48 $ 146,572.31
43 Jul 2024 $ 146,572.31 $ 2,000.00 $ 1,389.28 $ 610.72 $ 145,183.02
44 Aug 2024 $ 145,183.02 $ 2,000.00 $ 1,395.07 $ 604.93 $ 143,787.95
45 Sep 2024 $ 143,787.95 $ 2,000.00 $ 1,400.88 $ 599.12 $ 142,387.07
46 Oct 2024 $ 142,387.07 $ 2,000.00 $ 1,406.72 $ 593.28 $ 140,980.35
47 Nov 2024 $ 140,980.35 $ 2,000.00 $ 1,412.58 $ 587.42 $ 139,567.77
48 Dec 2024 $ 139,567.77 $ 2,000.00 $ 1,418.47 $ 581.53 $ 138,149.30
49 Jan 2025 $ 138,149.30 $ 2,000.00 $ 1,424.38 $ 575.62 $ 136,724.92
50 Feb 2025 $ 136,724.92 $ 2,000.00 $ 1,430.31 $ 569.69 $ 135,294.61
51 Mar 2025 $ 135,294.61 $ 2,000.00 $ 1,436.27 $ 563.73 $ 133,858.34
52 Apr 2025 $ 133,858.34 $ 2,000.00 $ 1,442.26 $ 557.74 $ 132,416.08
53 May 2025 $ 132,416.08 $ 2,000.00 $ 1,448.27 $ 551.73 $ 130,967.81
54 Jun 2025 $ 130,967.81 $ 2,000.00 $ 1,454.30 $ 545.70 $ 129,513.51
55 Jul 2025 $ 129,513.51 $ 2,000.00 $ 1,460.36 $ 539.64 $ 128,053.15
56 Aug 2025 $ 128,053.15 $ 2,000.00 $ 1,466.45 $ 533.55 $ 126,586.71
57 Sep 2025 $ 126,586.71 $ 2,000.00 $ 1,472.56 $ 527.44 $ 125,114.15
58 Oct 2025 $ 125,114.15 $ 2,000.00 $ 1,478.69 $ 521.31 $ 123,635.46
59 Nov 2025 $ 123,635.46 $ 2,000.00 $ 1,484.85 $ 515.15 $ 122,150.61
60 Dec 2025 $ 122,150.61 $ 2,000.00 $ 1,491.04 $ 508.96 $ 120,659.57
61 Jan 2026 $ 120,659.57 $ 2,000.00 $ 1,497.25 $ 502.75 $ 119,162.32
62 Feb 2026 $ 119,162.32 $ 2,000.00 $ 1,503.49 $ 496.51 $ 117,658.83
63 Mar 2026 $ 117,658.83 $ 2,000.00 $ 1,509.75 $ 490.25 $ 116,149.07
64 Apr 2026 $ 116,149.07 $ 2,000.00 $ 1,516.05 $ 483.95 $ 114,633.03
65 May 2026 $ 114,633.03 $ 115,110.67 $ 114,633.03 $ 477.64 $ -
Starting Month Jan 2020
Loan Amount $ 300,000.00
Total Payments 50
Annual Interest Rate 5.00%
Payment Amount $ 5,000.00

Payment # Month Opening Balance Payment Principal Paid Interest Paid

1 Jan 2020 $ 300,000.00 $ 5,000.00 $ 3,750.00 $ 1,250.00
2 Feb 2020 $ 296,250.00 $ 5,000.00 $ 3,765.63 $ 1,234.38
3 Mar 2020 $ 292,484.38 $ 5,000.00 $ 3,781.32 $ 1,218.68
4 Apr 2020 $ 288,703.06 $ 5,000.00 $ 3,797.07 $ 1,202.93
5 May 2020 $ 284,905.99 $ 5,000.00 $ 3,812.89 $ 1,187.11
6 Jun 2020 $ 281,093.10 $ 5,000.00 $ 3,828.78 $ 1,171.22
7 Jul 2020 $ 277,264.32 $ 5,000.00 $ 3,844.73 $ 1,155.27
8 Aug 2020 $ 273,419.59 $ 5,000.00 $ 3,860.75 $ 1,139.25
9 Sep 2020 $ 269,558.84 $ 5,000.00 $ 3,876.84 $ 1,123.16
10 Oct 2020 $ 265,682.00 $ 5,000.00 $ 3,892.99 $ 1,107.01
11 Nov 2020 $ 261,789.01 $ 5,000.00 $ 3,909.21 $ 1,090.79
12 Dec 2020 $ 257,879.79 $ 5,000.00 $ 3,925.50 $ 1,074.50
13 Jan 2021 $ 253,954.29 $ 5,000.00 $ 3,941.86 $ 1,058.14
14 Feb 2021 $ 250,012.43 $ 5,000.00 $ 3,958.28 $ 1,041.72
15 Mar 2021 $ 246,054.15 $ 5,000.00 $ 3,974.77 $ 1,025.23
16 Apr 2021 $ 242,079.38 $ 5,000.00 $ 3,991.34 $ 1,008.66
17 May 2021 $ 238,088.04 $ 5,000.00 $ 4,007.97 $ 992.03
18 Jun 2021 $ 234,080.08 $ 5,000.00 $ 4,024.67 $ 975.33
19 Jul 2021 $ 230,055.41 $ 5,000.00 $ 4,041.44 $ 958.56
20 Aug 2021 $ 226,013.97 $ 5,000.00 $ 4,058.28 $ 941.72
21 Sep 2021 $ 221,955.70 $ 5,000.00 $ 4,075.18 $ 924.82
22 Oct 2021 $ 217,880.51 $ 5,000.00 $ 4,092.16 $ 907.84
23 Nov 2021 $ 213,788.35 $ 5,000.00 $ 4,109.22 $ 890.78
24 Dec 2021 $ 209,679.13 $ 5,000.00 $ 4,126.34 $ 873.66
25 Jan 2022 $ 205,552.80 $ 5,000.00 $ 4,143.53 $ 856.47
26 Feb 2022 $ 201,409.27 $ 5,000.00 $ 4,160.79 $ 839.21
27 Mar 2022 $ 197,248.47 $ 5,000.00 $ 4,178.13 $ 821.87
28 Apr 2022 $ 193,070.34 $ 5,000.00 $ 4,195.54 $ 804.46
29 May 2022 $ 188,874.80 $ 5,000.00 $ 4,213.02 $ 786.98
30 Jun 2022 $ 184,661.78 $ 5,000.00 $ 4,230.58 $ 769.42
31 Jul 2022 $ 180,431.20 $ 5,000.00 $ 4,248.20 $ 751.80
32 Aug 2022 $ 176,183.00 $ 5,000.00 $ 4,265.90 $ 734.10
33 Sep 2022 $ 171,917.10 $ 5,000.00 $ 4,283.68 $ 716.32
34 Oct 2022 $ 167,633.42 $ 5,000.00 $ 4,301.53 $ 698.47
35 Nov 2022 $ 163,331.89 $ 5,000.00 $ 4,319.45 $ 680.55
36 Dec 2022 $ 159,012.44 $ 5,000.00 $ 4,337.45 $ 662.55
37 Jan 2023 $ 154,674.99 $ 5,000.00 $ 4,355.52 $ 644.48
38 Feb 2023 $ 150,319.47 $ 5,000.00 $ 4,373.67 $ 626.33
39 Mar 2023 $ 145,945.80 $ 5,000.00 $ 4,391.89 $ 608.11
40 Apr 2023 $ 141,553.91 $ 5,000.00 $ 4,410.19 $ 589.81
41 May 2023 $ 137,143.72 $ 5,000.00 $ 4,428.57 $ 571.43
42 Jun 2023 $ 132,715.15 $ 5,000.00 $ 4,447.02 $ 552.98
43 Jul 2023 $ 128,268.13 $ 5,000.00 $ 4,465.55 $ 534.45
44 Aug 2023 $ 123,802.58 $ 5,000.00 $ 4,484.16 $ 515.84
45 Sep 2023 $ 119,318.42 $ 5,000.00 $ 4,502.84 $ 497.16
46 Oct 2023 $ 114,815.58 $ 5,000.00 $ 4,521.60 $ 478.40
47 Nov 2023 $ 110,293.98 $ 5,000.00 $ 4,540.44 $ 459.56
48 Dec 2023 $ 105,753.54 $ 5,000.00 $ 4,559.36 $ 440.64
49 Jan 2024 $ 101,194.18 $ 5,000.00 $ 4,578.36 $ 421.64
50 Feb 2024 $ 96,615.82 $ 97,018.39 $ 96,615.82 $ 402.57
Ending Balance
$ 296,250.00
$ 292,484.38
$ 288,703.06
$ 284,905.99
$ 281,093.10
$ 277,264.32
$ 273,419.59
$ 269,558.84
$ 265,682.00
$ 261,789.01
$ 257,879.79
$ 253,954.29
$ 250,012.43
$ 246,054.15
$ 242,079.38
$ 238,088.04
$ 234,080.08
$ 230,055.41
$ 226,013.97
$ 221,955.70
$ 217,880.51
$ 213,788.35
$ 209,679.13
$ 205,552.80
$ 201,409.27
$ 197,248.47
$ 193,070.34
$ 188,874.80
$ 184,661.78
$ 180,431.20
$ 176,183.00
$ 171,917.10
$ 167,633.42
$ 163,331.89
$ 159,012.44
$ 154,674.99
$ 150,319.47
$ 145,945.80
$ 141,553.91
$ 137,143.72
$ 132,715.15
$ 128,268.13
$ 123,802.58
$ 119,318.42
$ 114,815.58
$ 110,293.98
$ 105,753.54
$ 101,194.18
$ 96,615.82
$ -
Starting Month Jan 2020
Loan Amount $ 600,000.00
Total Payments 70
Annual Interest Rate 5.00%
Payment Amount $ 10,000.00

Payment # Month Opening Balance Payment Principal Paid Interest Paid

1 Jan 2020 $ 600,000.00 $ 10,000.00 $ 7,500.00 $ 2,500.00
2 Feb 2020 $ 592,500.00 $ 10,000.00 $ 7,531.25 $ 2,468.75
3 Mar 2020 $ 584,968.75 $ 10,000.00 $ 7,562.63 $ 2,437.37
4 Apr 2020 $ 577,406.12 $ 10,000.00 $ 7,594.14 $ 2,405.86
5 May 2020 $ 569,811.98 $ 10,000.00 $ 7,625.78 $ 2,374.22
6 Jun 2020 $ 562,186.20 $ 10,000.00 $ 7,657.56 $ 2,342.44
7 Jul 2020 $ 554,528.64 $ 10,000.00 $ 7,689.46 $ 2,310.54
8 Aug 2020 $ 546,839.17 $ 10,000.00 $ 7,721.50 $ 2,278.50
9 Sep 2020 $ 539,117.67 $ 10,000.00 $ 7,753.68 $ 2,246.32
10 Oct 2020 $ 531,363.99 $ 10,000.00 $ 7,785.98 $ 2,214.02
11 Nov 2020 $ 523,578.01 $ 10,000.00 $ 7,818.42 $ 2,181.58
12 Dec 2020 $ 515,759.59 $ 10,000.00 $ 7,851.00 $ 2,149.00
13 Jan 2021 $ 507,908.58 $ 10,000.00 $ 7,883.71 $ 2,116.29
14 Feb 2021 $ 500,024.87 $ 10,000.00 $ 7,916.56 $ 2,083.44
15 Mar 2021 $ 492,108.31 $ 10,000.00 $ 7,949.55 $ 2,050.45
16 Apr 2021 $ 484,158.76 $ 10,000.00 $ 7,982.67 $ 2,017.33
17 May 2021 $ 476,176.09 $ 10,000.00 $ 8,015.93 $ 1,984.07
18 Jun 2021 $ 468,160.15 $ 10,000.00 $ 8,049.33 $ 1,950.67
19 Jul 2021 $ 460,110.82 $ 10,000.00 $ 8,082.87 $ 1,917.13
20 Aug 2021 $ 452,027.95 $ 10,000.00 $ 8,116.55 $ 1,883.45
21 Sep 2021 $ 443,911.40 $ 10,000.00 $ 8,150.37 $ 1,849.63
22 Oct 2021 $ 435,761.03 $ 10,000.00 $ 8,184.33 $ 1,815.67
23 Nov 2021 $ 427,576.70 $ 10,000.00 $ 8,218.43 $ 1,781.57
24 Dec 2021 $ 419,358.27 $ 10,000.00 $ 8,252.67 $ 1,747.33
25 Jan 2022 $ 411,105.60 $ 10,000.00 $ 8,287.06 $ 1,712.94
26 Feb 2022 $ 402,818.54 $ 10,000.00 $ 8,321.59 $ 1,678.41
27 Mar 2022 $ 394,496.95 $ 10,000.00 $ 8,356.26 $ 1,643.74
28 Apr 2022 $ 386,140.68 $ 10,000.00 $ 8,391.08 $ 1,608.92
29 May 2022 $ 377,749.60 $ 10,000.00 $ 8,426.04 $ 1,573.96
30 Jun 2022 $ 369,323.56 $ 10,000.00 $ 8,461.15 $ 1,538.85
31 Jul 2022 $ 360,862.41 $ 10,000.00 $ 8,496.41 $ 1,503.59
32 Aug 2022 $ 352,366.00 $ 10,000.00 $ 8,531.81 $ 1,468.19
33 Sep 2022 $ 343,834.19 $ 10,000.00 $ 8,567.36 $ 1,432.64
34 Oct 2022 $ 335,266.84 $ 10,000.00 $ 8,603.05 $ 1,396.95
35 Nov 2022 $ 326,663.78 $ 10,000.00 $ 8,638.90 $ 1,361.10
36 Dec 2022 $ 318,024.88 $ 10,000.00 $ 8,674.90 $ 1,325.10
37 Jan 2023 $ 309,349.98 $ 10,000.00 $ 8,711.04 $ 1,288.96
38 Feb 2023 $ 300,638.94 $ 10,000.00 $ 8,747.34 $ 1,252.66
39 Mar 2023 $ 291,891.60 $ 10,000.00 $ 8,783.78 $ 1,216.22
40 Apr 2023 $ 283,107.82 $ 10,000.00 $ 8,820.38 $ 1,179.62
41 May 2023 $ 274,287.44 $ 10,000.00 $ 8,857.14 $ 1,142.86
42 Jun 2023 $ 265,430.30 $ 10,000.00 $ 8,894.04 $ 1,105.96
43 Jul 2023 $ 256,536.26 $ 10,000.00 $ 8,931.10 $ 1,068.90
44 Aug 2023 $ 247,605.16 $ 10,000.00 $ 8,968.31 $ 1,031.69
45 Sep 2023 $ 238,636.85 $ 10,000.00 $ 9,005.68 $ 994.32
46 Oct 2023 $ 229,631.17 $ 10,000.00 $ 9,043.20 $ 956.80
47 Nov 2023 $ 220,587.96 $ 10,000.00 $ 9,080.88 $ 919.12
48 Dec 2023 $ 211,507.08 $ 10,000.00 $ 9,118.72 $ 881.28
49 Jan 2024 $ 202,388.36 $ 10,000.00 $ 9,156.72 $ 843.28
50 Feb 2024 $ 193,231.65 $ 10,000.00 $ 9,194.87 $ 805.13
51 Mar 2024 $ 184,036.78 $ 10,000.00 $ 9,233.18 $ 766.82
52 Apr 2024 $ 174,803.60 $ 10,000.00 $ 9,271.65 $ 728.35
53 May 2024 $ 165,531.95 $ 10,000.00 $ 9,310.28 $ 689.72
54 Jun 2024 $ 156,221.66 $ 10,000.00 $ 9,349.08 $ 650.92
55 Jul 2024 $ 146,872.59 $ 10,000.00 $ 9,388.03 $ 611.97
56 Aug 2024 $ 137,484.56 $ 10,000.00 $ 9,427.15 $ 572.85
57 Sep 2024 $ 128,057.41 $ 10,000.00 $ 9,466.43 $ 533.57
58 Oct 2024 $ 118,590.98 $ 10,000.00 $ 9,505.87 $ 494.13
59 Nov 2024 $ 109,085.11 $ 10,000.00 $ 9,545.48 $ 454.52
60 Dec 2024 $ 99,539.63 $ 10,000.00 $ 9,585.25 $ 414.75
61 Jan 2025 $ 89,954.38 $ 10,000.00 $ 9,625.19 $ 374.81
62 Feb 2025 $ 80,329.19 $ 10,000.00 $ 9,665.30 $ 334.70
63 Mar 2025 $ 70,663.89 $ 10,000.00 $ 9,705.57 $ 294.43
64 Apr 2025 $ 60,958.33 $ 10,000.00 $ 9,746.01 $ 253.99
65 May 2025 $ 51,212.32 $ 10,000.00 $ 9,786.62 $ 213.38
66 Jun 2025 $ 41,425.70 $ 10,000.00 $ 9,827.39 $ 172.61
67 Jul 2025 $ 31,598.31 $ 10,000.00 $ 9,868.34 $ 131.66
68 Aug 2025 $ 21,729.97 $ 10,000.00 $ 9,909.46 $ 90.54
69 Sep 2025 $ 11,820.51 $ 10,000.00 $ 9,950.75 $ 49.25
70 Oct 2025 $ 1,869.76 $ 1,877.56 $ 1,869.76 $ 7.79
Ending Balance
$ 592,500.00
$ 584,968.75
$ 577,406.12
$ 569,811.98
$ 562,186.20
$ 554,528.64
$ 546,839.17
$ 539,117.67
$ 531,363.99
$ 523,578.01
$ 515,759.59
$ 507,908.58
$ 500,024.87
$ 492,108.31
$ 484,158.76
$ 476,176.09
$ 468,160.15
$ 460,110.82
$ 452,027.95
$ 443,911.40
$ 435,761.03
$ 427,576.70
$ 419,358.27
$ 411,105.60
$ 402,818.54
$ 394,496.95
$ 386,140.68
$ 377,749.60
$ 369,323.56
$ 360,862.41
$ 352,366.00
$ 343,834.19
$ 335,266.84
$ 326,663.78
$ 318,024.88
$ 309,349.98
$ 300,638.94
$ 291,891.60
$ 283,107.82
$ 274,287.44
$ 265,430.30
$ 256,536.26
$ 247,605.16
$ 238,636.85
$ 229,631.17
$ 220,587.96
$ 211,507.08
$ 202,388.36
$ 193,231.65
$ 184,036.78
$ 174,803.60
$ 165,531.95
$ 156,221.66
$ 146,872.59
$ 137,484.56
$ 128,057.41
$ 118,590.98
$ 109,085.11
$ 99,539.63
$ 89,954.38
$ 80,329.19
$ 70,663.89
$ 60,958.33
$ 51,212.32
$ 41,425.70
$ 31,598.31
$ 21,729.97
$ 11,820.51
$ 1,869.76
$ -