Case Study 3 - TDR
Case Study 3 - PV
Accretion
Compound Period:
Monthly
Compound Period:
Monthly
Nominal Annual Rate:
5.000%
Nominal Annual Rate:
6.000%
CASH FLOW DATA Event 1 Loan 2 Payment 3 Payment
Page 1
CASH FLOW DATA
Date 1/1/2011 2/1/2011 1/1/2021
Amount 200,000.00 1,073.64 162,684.63
Number 1 120 1
Period Monthly
AMORTIZATION SCHEDULE - Normal Amortization Date Loan 1/1/2011 1 2/1/2011 2 3/1/2011 3 4/1/2011 4 5/1/2011 5 6/1/2011 6 7/1/2011 7 8/1/2011 8 9/1/2011 9 10/1/2011 10 11/1/2011 11 12/1/2011 2011 Totals
Payment
Interest
Principal
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 11,810.04
833.33 832.33 831.33 830.32 829.30 828.29 827.26 826.24 825.21 824.17 823.13 9,110.91
240.31 241.31 242.31 243.32 244.34 245.35 246.38 247.40 248.43 249.47 250.51 2,699.13
12 1/1/2012 13 2/1/2012 14 3/1/2012 15 4/1/2012 16 5/1/2012 17 6/1/2012 18 7/1/2012 19 8/1/2012 20 9/1/2012 21 10/1/2012 22 11/1/2012 23 12/1/2012 2012 Totals
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 12,883.68
822.09 821.04 819.99 818.93 817.87 816.80 815.73 814.66 813.58 812.50 811.41 810.31 9,794.91
251.55 252.60 253.65 254.71 255.77 256.84 257.91 258.98 260.06 261.14 262.23 263.33 3,088.77
24 1/1/2013
1,073.64
809.22
Event 1 Loan 2 Payment 3 Payment
Date 1/1/2011 2/1/2011 1/1/2021
Amount 186,123.26 1,073.64 162,684.63
Number 1 120 1
Period
Interest Diff 13,876.74
S/L 13,876.74
Monthly
AMORTIZATION SCHEDULE - Normal Amortization Balance 200,000.00 199,759.69 199,518.38 199,276.07 199,032.75 198,788.41 198,543.06 198,296.68 198,049.28 197,800.85 197,551.38 197,300.87
Date Loan 1/1/2011 1 2/1/2011 2 3/1/2011 3 4/1/2011 4 5/1/2011 5 6/1/2011 6 7/1/2011 7 8/1/2011 8 9/1/2011 9 10/1/2011 10 11/1/2011 11 12/1/2011 2011 Totals
Payment
Interest
Principal
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 11,810.04
930.62 929.90 929.18 928.46 927.73 927.00 926.27 925.53 924.79 924.05 923.30 10,196.83
143.02 143.74 144.46 145.18 145.91 146.64 147.37 148.11 148.85 149.59 150.34 1,613.21
197,049.32 196,796.72 196,543.07 196,288.36 196,032.59 195,775.75 195,517.84 195,258.86 194,998.80 194,737.66 194,475.43 194,212.10
12 1/1/2012 13 2/1/2012 14 3/1/2012 15 4/1/2012 16 5/1/2012 17 6/1/2012 18 7/1/2012 19 8/1/2012 20 9/1/2012 21 10/1/2012 22 11/1/2012 23 12/1/2012 2012 Totals
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 12,883.68
922.55 921.79 921.04 920.27 919.51 918.74 917.96 917.18 916.40 915.61 914.82 914.03 11,019.90
151.09 151.85 152.60 153.37 154.13 154.90 155.68 156.46 157.24 158.03 158.82 159.61 1,863.78
264.42 193,947.68
24 1/1/2013
1,073.64
913.23
Balance 186,123.26 185,980.24 185,836.50 185,692.04 185,546.86 185,400.95 185,254.31 185,106.94 184,958.83 184,809.98 184,660.39 184,510.05
97.29 97.57 97.85 98.14 98.43 98.71 99.01 99.29 99.58 99.88 100.17 1,085.92
115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 1,272.03
184,358.96 184,207.11 184,054.51 183,901.14 183,747.01 183,592.11 183,436.43 183,279.97 183,122.73 182,964.70 182,805.88 182,646.27
100.46 100.75 101.05 101.34 101.64 101.94 102.23 102.52 102.82 103.11 103.41 103.72 1,224.99
115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 1,387.67
160.41 182,485.86
104.01
115.64
25 2/1/2013 26 3/1/2013 27 4/1/2013 28 5/1/2013 29 6/1/2013 30 7/1/2013 31 8/1/2013 32 9/1/2013 33 10/1/2013 34 11/1/2013 35 12/1/2013 2013 Totals
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 12,883.68
808.12 807.01 805.90 804.78 803.66 802.54 801.41 800.27 799.13 797.99 796.84 9,636.87
265.52 266.63 267.74 268.86 269.98 271.10 272.23 273.37 274.51 275.65 276.80 3,246.81
193,682.16 193,415.53 193,147.79 192,878.93 192,608.95 192,337.85 192,065.62 191,792.25 191,517.74 191,242.09 190,965.29
25 2/1/2013 26 3/1/2013 27 4/1/2013 28 5/1/2013 29 6/1/2013 30 7/1/2013 31 8/1/2013 32 9/1/2013 33 10/1/2013 34 11/1/2013 35 12/1/2013 2013 Totals
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 12,883.68
912.43 911.62 910.81 910.00 909.18 908.36 907.53 906.70 905.87 905.03 904.18 10,904.94
161.21 162.02 162.83 163.64 164.46 165.28 166.11 166.94 167.77 168.61 169.46 1,978.74
182,324.65 182,162.63 181,999.80 181,836.16 181,671.70 181,506.42 181,340.31 181,173.37 181,005.60 180,836.99 180,667.53
104.31 104.61 104.91 105.22 105.52 105.82 106.12 106.43 106.74 107.04 107.34 1,268.07
115.64Page 2 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 1,387.67
36 1/1/2014 37 2/1/2014 38 3/1/2014 39 4/1/2014 40 5/1/2014 41 6/1/2014 42 7/1/2014 43 8/1/2014 44 9/1/2014 45 10/1/2014 46 11/1/2014 47 12/1/2014 2014 Totals
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 12,883.68
795.69 794.53 793.37 792.20 791.03 789.85 788.67 787.48 786.29 785.09 783.89 782.68 9,470.77
277.95 279.11 280.27 281.44 282.61 283.79 284.97 286.16 287.35 288.55 289.75 290.96 3,412.91
190,687.34 190,408.23 190,127.96 189,846.52 189,563.91 189,280.12 188,995.15 188,708.99 188,421.64 188,133.09 187,843.34 187,552.38
36 1/1/2014 37 2/1/2014 38 3/1/2014 39 4/1/2014 40 5/1/2014 41 6/1/2014 42 7/1/2014 43 8/1/2014 44 9/1/2014 45 10/1/2014 46 11/1/2014 47 12/1/2014 2014 Totals
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 12,883.68
903.34 902.49 901.63 900.77 899.91 899.04 898.16 897.29 896.41 895.52 894.63 893.73 10,782.92
170.30 171.15 172.01 172.87 173.73 174.60 175.48 176.35 177.23 178.12 179.01 179.91 2,100.76
180,497.23 180,326.08 180,154.07 179,981.20 179,807.47 179,632.87 179,457.39 179,281.04 179,103.81 178,925.69 178,746.68 178,566.77
107.65 107.96 108.26 108.57 108.88 109.19 109.49 109.81 110.12 110.43 110.74 111.05 1,312.15
115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 1,387.67
48 1/1/2015 49 2/1/2015 50 3/1/2015 51 4/1/2015 52 5/1/2015 53 6/1/2015 54 7/1/2015 55 8/1/2015 56 9/1/2015 57 10/1/2015 58 11/1/2015 59 12/1/2015 2015 Totals
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 12,883.68
781.47 780.25 779.03 777.80 776.57 775.33 774.09 772.84 771.59 770.33 769.06 767.79 9,296.15
292.17 293.39 294.61 295.84 297.07 298.31 299.55 300.80 302.05 303.31 304.58 305.85 3,587.53
187,260.21 186,966.82 186,672.21 186,376.37 186,079.30 185,780.99 185,481.44 185,180.64 184,878.59 184,575.28 184,270.70 183,964.85
48 1/1/2015 49 2/1/2015 50 3/1/2015 51 4/1/2015 52 5/1/2015 53 6/1/2015 54 7/1/2015 55 8/1/2015 56 9/1/2015 57 10/1/2015 58 11/1/2015 59 12/1/2015 2015 Totals
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 12,883.68
892.83 891.93 891.02 890.11 889.19 888.27 887.34 886.41 885.47 884.53 883.59 882.64 10,653.33
180.81 181.71 182.62 183.53 184.45 185.37 186.30 187.23 188.17 189.11 190.05 191.00 2,230.35
178,385.96 178,204.25 178,021.63 177,838.10 177,653.65 177,468.28 177,281.98 177,094.75 176,906.58 176,717.47 176,527.42 176,336.42
111.36 111.68 111.99 112.31 112.62 112.94 113.25 113.57 113.88 114.20 114.53 114.85 1,357.18
115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 1,387.67
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64
766.52 765.24 763.96 762.67 761.37 760.07
307.12 308.40 309.68 310.97 312.27 313.57
183,657.73 183,349.33 183,039.65 182,728.68 182,416.41 182,102.84
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64
881.68 880.72 879.76 878.79 877.81 876.83
191.96 192.92 193.88 194.85 195.83 196.81
176,144.46 175,951.54 175,757.66 175,562.81 175,366.98 175,170.17
115.16 115.48 115.80 116.12 116.44 116.76
115.64 115.64 115.64 115.64 115.64 115.64
60 61 62 63 64 65
1/1/2016 2/1/2016 3/1/2016 4/1/2016 5/1/2016 6/1/2016
60 61 62 63 64 65
1/1/2016 2/1/2016 3/1/2016 4/1/2016 5/1/2016 6/1/2016
66 7/1/2016 67 8/1/2016 68 9/1/2016 69 10/1/2016 70 11/1/2016 71 12/1/2016 2016 Totals
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 12,883.68
758.76 757.45 756.13 754.81 753.48 752.15 9,112.61
314.88 316.19 317.51 318.83 320.16 321.49 3,771.07
181,787.96 181,471.77 181,154.26 180,835.43 180,515.27 180,193.78
66 7/1/2016 67 8/1/2016 68 9/1/2016 69 10/1/2016 70 11/1/2016 71 12/1/2016 2016 Totals
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 12,883.68
875.85 874.86 873.87 872.87 871.87 870.86 10,515.77
197.79 198.78 199.77 200.77 201.77 202.78 2,367.91
174,972.38 174,773.60 174,573.83 174,373.06 174,171.29 173,968.51
117.09 117.41 117.74 118.06 118.39 118.71 1,403.16
115.64Page 3 115.64 115.64 115.64 115.64 115.64 1,387.67
72 1/1/2017 73 2/1/2017 74 3/1/2017 75 4/1/2017 76 5/1/2017 77 6/1/2017 78 7/1/2017 79 8/1/2017 80 9/1/2017 81 10/1/2017 82 11/1/2017 83 12/1/2017 2017 Totals
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 12,883.68
750.81 749.46 748.11 746.76 745.39 744.03 742.65 741.27 739.89 738.50 737.10 735.70 8,919.67
322.83 324.18 325.53 326.88 328.25 329.61 330.99 332.37 333.75 335.14 336.54 337.94 3,964.01
179,870.95 179,546.77 179,221.24 178,894.36 178,566.11 178,236.50 177,905.51 177,573.14 177,239.39 176,904.25 176,567.71 176,229.77
72 1/1/2017 73 2/1/2017 74 3/1/2017 75 4/1/2017 76 5/1/2017 77 6/1/2017 78 7/1/2017 79 8/1/2017 80 9/1/2017 81 10/1/2017 82 11/1/2017 83 12/1/2017 2017 Totals
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 12,883.68
869.84 868.82 867.80 866.77 865.74 864.70 863.65 862.60 861.55 860.49 859.42 858.35 10,369.73
203.80 204.82 205.84 206.87 207.90 208.94 209.99 211.04 212.09 213.15 214.22 215.29 2,513.95
173,764.71 173,559.89 173,354.05 173,147.18 172,939.28 172,730.34 172,520.35 172,309.31 172,097.22 171,884.07 171,669.85 171,454.56
119.03 119.36 119.69 120.01 120.35 120.67 121.00 121.33 121.66 121.99 122.32 122.65 1,450.06
115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 1,387.67
84 1/1/2018 85 2/1/2018 86 3/1/2018 87 4/1/2018 88 5/1/2018 89 6/1/2018 90 7/1/2018 91 8/1/2018 92 9/1/2018 93 10/1/2018 94 11/1/2018 95 12/1/2018 2018 Totals
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 12,883.68
734.29 732.88 731.46 730.03 728.60 727.16 725.72 724.27 722.81 721.35 719.88 718.41 8,716.86
339.35 340.76 342.18 343.61 345.04 346.48 347.92 349.37 350.83 352.29 353.76 355.23 4,166.82
175,890.42 175,549.66 175,207.48 174,863.87 174,518.83 174,172.35 173,824.43 173,475.06 173,124.23 172,771.94 172,418.18 172,062.95
84 1/1/2018 85 2/1/2018 86 3/1/2018 87 4/1/2018 88 5/1/2018 89 6/1/2018 90 7/1/2018 91 8/1/2018 92 9/1/2018 93 10/1/2018 94 11/1/2018 95 12/1/2018 2018 Totals
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 12,883.68
857.27 856.19 855.10 854.01 852.91 851.81 850.70 849.59 848.47 847.34 846.21 845.07 10,214.67
216.37 217.45 218.54 219.63 220.73 221.83 222.94 224.05 225.17 226.30 227.43 228.57 2,669.01
171,238.19 171,020.74 170,802.20 170,582.57 170,361.84 170,140.01 169,917.07 169,693.02 169,467.85 169,241.55 169,014.12 168,785.55
122.98 123.31 123.64 123.98 124.31 124.65 124.98 125.32 125.66 125.99 126.33 126.66 1,497.81
115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 1,387.67
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64
716.93 715.44 713.95 712.45 710.95 709.44 707.92 706.39 704.86 703.33 701.78
356.71 358.20 359.69 361.19 362.69 364.20 365.72 367.25 368.78 370.31 371.86
171,706.24 171,348.04 170,988.35 170,627.16 170,264.47 169,900.27 169,534.55 169,167.30 168,798.52 168,428.21 168,056.35
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64
843.93 842.78 841.62 840.46 839.30 838.13 836.95 835.77 834.58 833.38 832.18
229.71 230.86 232.02 233.18 234.34 235.51 236.69 237.87 239.06 240.26 241.46
168,555.84 168,324.98 168,092.96 167,859.78 167,625.44 167,389.93 167,153.24 166,915.37 166,676.31 166,436.05 166,194.59
127.00 127.34 127.67 128.01 128.35 128.69 129.03 129.38 129.72 130.05 130.40
115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64
96 97 98 99 100 101 102 103 104 105 106
1/1/2019 2/1/2019 3/1/2019 4/1/2019 5/1/2019 6/1/2019 7/1/2019 8/1/2019 9/1/2019 10/1/2019 11/1/2019
96 97 98 99 100 101 102 103 104 105 106
1/1/2019 2/1/2019 3/1/2019 4/1/2019 5/1/2019 6/1/2019 7/1/2019 8/1/2019 9/1/2019 10/1/2019 11/1/2019
107 12/1/2019 2019 Totals
1,073.64 12,883.68
700.23 8,503.67
373.41 167,682.94 4,380.01
107 12/1/2019 2019 Totals
1,073.64 12,883.68
830.97 10,050.05
108 1/1/2020 109 2/1/2020 110 3/1/2020 111 4/1/2020 112 5/1/2020 113 6/1/2020 114 7/1/2020 115 8/1/2020 116 9/1/2020 117 10/1/2020 118 11/1/2020 119 12/1/2020 2020 Totals
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 12,883.68
698.68 697.12 695.55 693.97 692.39 690.80 689.21 687.60 686.00 684.38 682.76 681.13 8,279.59
374.96 376.52 378.09 379.67 381.25 382.84 384.43 386.04 387.64 389.26 390.88 392.51 4,604.09
108 1/1/2020 109 2/1/2020 110 3/1/2020 111 4/1/2020 112 5/1/2020 113 6/1/2020 114 7/1/2020 115 8/1/2020 116 9/1/2020 117 10/1/2020 118 11/1/2020 119 12/1/2020 2020 Totals
1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 1,073.64 12,883.68
829.76 828.54 827.31 826.08 824.85 823.60 822.35 821.09 819.83 818.56 817.29 816.01 9,875.27
120 1/1/2021 1,073.64 121 1/1/2021 162,684.63 2021 Totals 163,758.27 Grand Totals
291,521.43
167,307.98 166,931.46 166,553.37 166,173.70 165,792.45 165,409.61 165,025.18 164,639.14 164,251.50 163,862.24 163,471.36 163,078.85
679.50 394.14 162,684.71 0.08- 162,684.71 0.00 679.42 163,078.85 91,521.43 200,000.00
Last interest amount decreased by 0.08 due to rounding.
120 1/1/2021 1,073.64 121 1/1/2021 162,684.63 2021 Totals 163,758.27 Grand Totals
242.67 165,951.92 2,833.63
130.74 1,546.38
115.64Page 4 1,387.67
243.88 245.10 246.33 247.56 248.79 250.04 251.29 252.55 253.81 255.08 256.35 257.63 3,008.41
165,708.04 165,462.94 165,216.61 164,969.05 164,720.26 164,470.22 164,218.93 163,966.38 163,712.57 163,457.49 163,201.14 162,943.51
131.08 131.42 131.76 132.11 132.46 132.80 133.14 133.49 133.83 134.18 134.53 134.88 1,595.68
115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 115.64 1,387.67
814.72 258.92 162,684.59 0.04 162,684.59 0.00 814.76 162,943.51
135.22
115.64
291,521.43 105,398.17 186,123.26
Last interest amount increased by 0.04 due to rounding.
13,876.74 13,876.74