amortization of a loan

Amortization Schedule Loan Amount To be Amortized 120,000.00 Initial Insurance Amt 552 Interest Rate 7.00% Insurance Inflation Rate 5.00% Monthly Payments 798.36 Number of Years 30 Initial Tax Rate 2.016 Year of Loan 2002 (expressed as $ per $1000 of assessed valuation) Month of Loan 10 Tax Inflation Rate 3.00% Day of Loan 01 Property Value 130,000.00 # of Years in Payment Monthly Interest Principal Additional Carrying Insurance Tax Total Payments Payments Dates Payments Payments Payments Payments Value Payments Payments Payments 0 0 11/01/2002 120,000.00 1 1 12/01/2002 798.36 700.00 98.36 119,901.64 46.00 218.40 1,062.76 2 1 01/01/2003 798.36 699.43 98.94 119,802.70 46.00 218.40 1,062.76 3 1 02/01/2003 798.36 698.85 99.51 119,703.19 46.00 218.40 1,062.76 4 1 03/01/2003 798.36 698.27 100.09 119,603.09 46.00 218.40 1,062.76 5 1 04/01/2003 798.36 697.68 100.68 119,502.41 46.00 218.40 1,062.76 6 1 05/01/2003 798.36 697.10 101.27 119,401.15 46.00 218.40 1,062.76 7 1 06/01/2003 798.36 696.51 101.86 119,299.29 46.00 218.40 1,062.76 8 1 07/01/2003 798.36 695.91 102.45 119,196.84 46.00 218.40 1,062.76 9 1 08/01/2003 798.36 695.31 103.05 119,093.79 46.00 218.40 1,062.76 10 1 09/01/2003 798.36 694.71 103.65 118,990.14 46.00 218.40 1,062.76 11 1 10/01/2003 798.36 694.11 104.25 118,885.89 46.00 218.40 1,062.76 12 1 11/01/2003 798.36 693.50 104.86 118,781.03 46.00 218.40 1,062.76 13 2 12/01/2003 798.36 692.89 105.47 118,675.55 48.30 231.70 1,078.36 14 2 01/01/2004 798.36 692.27 106.09 118,569.47 48.30 231.70 1,078.36 15 2 02/01/2004 798.36 691.66 106.71 118,462.76 48.30 231.70 1,078.36 16 2 03/01/2004 798.36 691.03 107.33 118,355.43 48.30 231.70 1,078.36 17 2 04/01/2004 798.36 690.41 107.96 118,247.47 48.30 231.70 1,078.36 18 2 05/01/2004 798.36 689.78 108.59 118,138.89 48.30 231.70 1,078.36 19 2 06/01/2004 798.36 689.14 109.22 118,029.67 48.30 231.70 1,078.36 20 2 07/01/2004 798.36 688.51 109.86 117,919.81 48.30 231.70 1,078.36 21 2 08/01/2004 798.36 687.87 110.50 117,809.31 48.30 231.70 1,078.36 22 2 09/01/2004 798.36 687.22 111.14 117,698.17 48.30 231.70 1,078.36 23 2 10/01/2004 798.36 686.57 111.79 117,586.38 48.30 231.70 1,078.36 24 2 11/01/2004 798.36 685.92 112.44 117,473.94 48.30 231.70 1,078.36 25 3 12/01/2004 798.36 685.26 113.10 117,360.84 50.72 245.81 1,094.89 26 3 01/01/2005 798.36 684.60 113.76 117,247.08 50.72 245.81 1,094.89 27 3 02/01/2005 798.36 683.94 114.42 117,132.66 50.72 245.81 1,094.89 28 3 03/01/2005 798.36 683.27 115.09 117,017.57 50.72 245.81 1,094.89 29 3 04/01/2005 798.36 682.60 115.76 116,901.81 50.72 245.81 1,094.89 30 3 05/01/2005 798.36 681.93 116.44 116,785.37 50.72 245.81 1,094.89 31 3 06/01/2005 798.36 681.25 117.11 116,668.26 50.72 245.81 1,094.89 32 3 07/01/2005 798.36 680.56 117.80 116,550.46 50.72 245.81 1,094.89 33 3 08/01/2005 798.36 679.88 118.49 116,431.97 50.72 245.81 1,094.89 34 3 09/01/2005 798.36 679.19 119.18 116,312.80 50.72 245.81 1,094.89 35 3 10/01/2005 798.36 678.49 119.87 116,192.93 50.72 245.81 1,094.89 36 3 11/01/2005 798.36 677.79 120.57 116,072.36 50.72 245.81 1,094.89 37 4 12/01/2005 798.36 677.09 121.27 115,951.08 53.25 260.78 1,112.39 38 4 01/01/2006 798.36 676.38 121.98 115,829.10 53.25 260.78 1,112.39 39 4 02/01/2006 798.36 675.67 122.69 115,706.41 53.25 260.78 1,112.39 40 4 03/01/2006 798.36 674.95 123.41 115,583.00 53.25 260.78 1,112.39 41 4 04/01/2006 798.36 674.23 124.13 115,458.87 53.25 260.78 1,112.39 42 4 05/01/2006 798.36 673.51 124.85 115,334.02 53.25 260.78 1,112.39 43 4 06/01/2006 798.36 672.78 125.58 115,208.43 53.25 260.78 1,112.39 44 4 07/01/2006 798.36 672.05 126.31 115,082.12 53.25 260.78 1,112.39 45 4 08/01/2006 798.36 671.31 127.05 114,955.07 53.25 260.78 1,112.39 46 4 09/01/2006 798.36 670.57 127.79 114,827.28 53.25 260.78 1,112.39 47 4 10/01/2006 798.36 669.83 128.54 114,698.74 53.25 260.78 1,112.39 48 4 11/01/2006 798.36 669.08 129.29 114,569.45 53.25 260.78 1,112.39 49 5 12/01/2006 798.36 668.32 130.04 114,439.41 55.91 276.66 1,130.94 50 5 01/01/2007 798.36 667.56 130.80 114,308.61 55.91 276.66 1,130.94 51 5 02/01/2007 798.36 666.80 131.56 114,177.05 55.91 276.66 1,130.94 52 5 03/01/2007 798.36 666.03 132.33 114,044.72 55.91 276.66 1,130.94 53 5 04/01/2007 798.36 665.26 133.10 113,911.62 55.91 276.66 1,130.94 54 5 05/01/2007 798.36 664.48 133.88 113,777.74 55.91 276.66 1,130.94 55 5 06/01/2007 798.36 663.70 134.66 113,643.08 55.91 276.66 1,130.94 56 5 07/01/2007 798.36 662.92 135.45 113,507.64 55.91 276.66 1,130.94 57 5 08/01/2007 798.36 662.13 136.24 113,371.40 55.91 276.66 1,130.94 58 5 09/01/2007 798.36 661.33 137.03 113,234.37 55.91 276.66 1,130.94 59 5 10/01/2007 798.36 660.53 137.83 113,096.54 55.91 276.66 1,130.94 60 5 11/01/2007 798.36 659.73 138.63 112,957.91 55.91 276.66 1,130.94 61 6 12/01/2007 798.36 658.92 139.44 112,818.47 58.71 293.51 1,150.58 62 6 01/01/2008 798.36 658.11 140.26 112,678.21 58.71 293.51 1,150.58 63 6 02/01/2008 798.36 657.29 141.07 112,537.14 58.71 293.51 1,150.58 64 6 03/01/2008 798.36 656.47 141.90 112,395.24 58.71 293.51 1,150.58 65 6 04/01/2008 798.36 655.64 142.72 112,252.52 58.71 293.51 1,150.58 66 6 05/01/2008 798.36 654.81 143.56 112,108.96 58.71 293.51 1,150.58 2/27/2008 5:55 PM Page 1 of 6 $ASQamortization of a loan.xls.xls Without tax ratesAmortization Schedule Loan Amount To be Amortized 120,000.00 Initial Insurance Amt 552 Interest Rate 7.00% Insurance Inflation Rate 5.00% Monthly Payments 798.36 Number of Years 30 Initial Tax Rate 2.016 Year of Loan 2002 (expressed as $ per $1000 of assessed valuation) Month of Loan 10 Tax Inflation Rate 3.00% Day of Loan 01 Property Value 130,000.00 # of Years in Payment Monthly Interest Principal Additional Carrying Insurance Tax Total Payments Payments Dates Payments Payments Payments Payments Value Payments Payments Payments 67 6 06/01/2008 798.36 653.97 144.39 111,964.57 58.71 293.51 1,150.58 68 6 07/01/2008 798.36 653.13 145.24 111,819.33 58.71 293.51 1,150.58 69 6 08/01/2008 798.36 652.28 146.08 111,673.25 58.71 293.51 1,150.58 70 6 09/01/2008 798.36 651.43 146.94 111,526.31 58.71 293.51 1,150.58 71 6 10/01/2008 798.36 650.57 147.79 111,378.52 58.71 293.51 1,150.58 72 6 11/01/2008 798.36 649.71 148.65 111,229.86 58.71 293.51 1,150.58 73 7 12/01/2008 798.36 648.84 149.52 111,080.34 61.64 311.39 1,171.39 74 7 01/01/2009 798.36 647.97 150.39 110,929.95 61.64 311.39 1,171.39 75 7 02/01/2009 798.36 647.09 151.27 110,778.67 61.64 311.39 1,171.39 76 7 03/01/2009 798.36 646.21 152.15 110,626.52 61.64 311.39 1,171.39 77 7 04/01/2009 798.36 645.32 153.04 110,473.48 61.64 311.39 1,171.39 78 7 05/01/2009 798.36 644.43 153.93 110,319.54 61.64 311.39 1,171.39 79 7 06/01/2009 798.36 643.53 154.83 110,164.71 61.64 311.39 1,171.39 80 7 07/01/2009 798.36 642.63 155.74 110,008.98 61.64 311.39 1,171.39 81 7 08/01/2009 798.36 641.72 156.64 109,852.33 61.64 311.39 1,171.39 82 7 09/01/2009 798.36 640.81 157.56 109,694.77 61.64 311.39 1,171.39 83 7 10/01/2009 798.36 639.89 158.48 109,536.30 61.64 311.39 1,171.39 84 7 11/01/2009 798.36 638.96 159.40 109,376.90 61.64 311.39 1,171.39 85 8 12/01/2009 798.36 638.03 160.33 109,216.57 64.73 330.35 1,193.44 86 8 01/01/2010 798.36 637.10 161.27 109,055.30 64.73 330.35 1,193.44 87 8 02/01/2010 798.36 636.16 162.21 108,893.09 64.73 330.35 1,193.44 88 8 03/01/2010 798.36 635.21 163.15 108,729.94 64.73 330.35 1,193.44 89 8 04/01/2010 798.36 634.26 164.11 108,565.83 64.73 330.35 1,193.44 90 8 05/01/2010 798.36 633.30 165.06 108,400.77 64.73 330.35 1,193.44 91 8 06/01/2010 798.36 632.34 166.03 108,234.75 64.73 330.35 1,193.44 92 8 07/01/2010 798.36 631.37 166.99 108,067.75 64.73 330.35 1,193.44 93 8 08/01/2010 798.36 630.40 167.97 107,899.79 64.73 330.35 1,193.44 94 8 09/01/2010 798.36 629.42 168.95 107,730.84 64.73 330.35 1,193.44 95 8 10/01/2010 798.36 628.43 169.93 107,560.90 64.73 330.35 1,193.44 96 8 11/01/2010 798.36 627.44 170.92 107,389.98 64.73 330.35 1,193.44 97 9 12/01/2010 798.36 626.44 171.92 107,218.06 67.96 350.47 1,216.79 98 9 01/01/2011 798.36 625.44 172.92 107,045.13 67.96 350.47 1,216.79 99 9 02/01/2011 798.36 624.43 173.93 106,871.20 67.96 350.47 1,216.79 100 9 03/01/2011 798.36 623.42 174.95 106,696.25 67.96 350.47 1,216.79 101 9 04/01/2011 798.36 622.39 175.97 106,520.29 67.96 350.47 1,216.79 102 9 05/01/2011 798.36 621.37 176.99 106,343.29 67.96 350.47 1,216.79 103 9 06/01/2011 798.36 620.34 178.03 106,165.26 67.96 350.47 1,216.79 104 9 07/01/2011 798.36 619.30 179.07 105,986.20 67.96 350.47 1,216.79 105 9 08/01/2011 798.36 618.25 180.11 105,806.09 67.96 350.47 1,216.79 106 9 09/01/2011 798.36 617.20 181.16 105,624.93 67.96 350.47 1,216.79 107 9 10/01/2011 798.36 616.15 182.22 105,442.71 67.96 350.47 1,216.79 108 9 11/01/2011 798.36 615.08 183.28 105,259.43 67.96 350.47 1,216.79 109 10 12/01/2011 798.36 614.01 184.35 105,075.08 71.36 371.81 1,241.54 110 10 01/01/2012 798.36 612.94 185.43 104,889.65 71.36 371.81 1,241.54 111 10 02/01/2012 798.36 611.86 186.51 104,703.15 71.36 371.81 1,241.54 112 10 03/01/2012 798.36 610.77 187.59 104,515.55 71.36 371.81 1,241.54 113 10 04/01/2012 798.36 609.67 188.69 104,326.86 71.36 371.81 1,241.54 114 10 05/01/2012 798.36 608.57 189.79 104,137.07 71.36 371.81 1,241.54 115 10 06/01/2012 798.36 607.47 190.90 103,946.18 71.36 371.81 1,241.54 116 10 07/01/2012 798.36 606.35 192.01 103,754.17 71.36 371.81 1,241.54 117 10 08/01/2012 798.36 605.23 193.13 103,561.04 71.36 371.81 1,241.54 118 10 09/01/2012 798.36 604.11 194.26 103,366.78 71.36 371.81 1,241.54 119 10 10/01/2012 798.36 602.97 195.39 103,171.39 71.36 371.81 1,241.54 120 10 11/01/2012 798.36 601.83 196.53 102,974.86 71.36 371.81 1,241.54 121 11 12/01/2012 798.36 600.69 197.68 102,777.18 74.93 394.45 1,267.75 122 11 01/01/2013 798.36 599.53 198.83 102,578.35 74.93 394.45 1,267.75 123 11 02/01/2013 798.36 598.37 199.99 102,378.37 74.93 394.45 1,267.75 124 11 03/01/2013 798.36 597.21 201.16 102,177.21 74.93 394.45 1,267.75 125 11 04/01/2013 798.36 596.03 202.33 101,974.88 74.93 394.45 1,267.75 126 11 05/01/2013 798.36 594.85 203.51 101,771.37 74.93 394.45 1,267.75 127 11 06/01/2013 798.36 593.67 204.70 101,566.67 74.93 394.45 1,267.75 128 11 07/01/2013 798.36 592.47 205.89 101,360.78 74.93 394.45 1,267.75 129 11 08/01/2013 798.36 591.27 207.09 101,153.69 74.93 394.45 1,267.75 130 11 09/01/2013 798.36 590.06 208.30 100,945.39 74.93 394.45 1,267.75 131 11 10/01/2013 798.36 588.85 209.51 100,735.88 74.93 394.45 1,267.75 132 11 11/01/2013 798.36 587.63 210.74 100,525.14 74.93 394.45 1,267.75 133 12 12/01/2013 798.36 586.40 211.97 100,313.17 78.68 418.48 1,295.52 2/27/2008 5:55 PM Page 2 of 6 $ASQamortization of a loan.xls.xls Without tax ratesAmortization Schedule Loan Amount To be Amortized 120,000.00 Initial Insurance Amt 552 Interest Rate 7.00% Insurance Inflation Rate 5.00% Monthly Payments 798.36 Number of Years 30 Initial Tax Rate 2.016 Year of Loan 2002 (expressed as $ per $1000 of assessed valuation) Month of Loan 10 Tax Inflation Rate 3.00% Day of Loan 01 Property Value 130,000.00 # of Years in Payment Monthly Interest Principal Additional Carrying Insurance Tax Total Payments Payments Dates Payments Payments Payments Payments Value Payments Payments Payments 134 12 01/01/2014 798.36 585.16 213.20 100,099.97 78.68 418.48 1,295.52 135 12 02/01/2014 798.36 583.92 214.45 99,885.52 78.68 418.48 1,295.52 136 12 03/01/2014 798.36 582.67 215.70 99,669.83 78.68 418.48 1,295.52 137 12 04/01/2014 798.36 581.41 216.96 99,452.87 78.68 418.48 1,295.52 138 12 05/01/2014 798.36 580.14 218.22 99,234.65 78.68 418.48 1,295.52 139 12 06/01/2014 798.36 578.87 219.49 99,015.16 78.68 418.48 1,295.52 140 12 07/01/2014 798.36 577.59 220.77 98,794.38 78.68 418.48 1,295.52 141 12 08/01/2014 798.36 576.30 222.06 98,572.32 78.68 418.48 1,295.52 142 12 09/01/2014 798.36 575.01 223.36 98,348.96 78.68 418.48 1,295.52 143 12 10/01/2014 798.36 573.70 224.66 98,124.30 78.68 418.48 1,295.52 144 12 11/01/2014 798.36 572.39 225.97 97,898.33 78.68 418.48 1,295.52 145 13 12/01/2014 798.36 571.07 227.29 97,671.04 82.61 443.96 1,324.93 146 13 01/01/2015 798.36 569.75 228.62 97,442.42 82.61 443.96 1,324.93 147 13 02/01/2015 798.36 568.41 229.95 97,212.47 82.61 443.96 1,324.93 148 13 03/01/2015 798.36 567.07 231.29 96,981.18 82.61 443.96 1,324.93 149 13 04/01/2015 798.36 565.72 232.64 96,748.55 82.61 443.96 1,324.93 150 13 05/01/2015 798.36 564.37 234.00 96,514.55 82.61 443.96 1,324.93 151 13 06/01/2015 798.36 563.00 235.36 96,279.19 82.61 443.96 1,324.93 152 13 07/01/2015 798.36 561.63 236.73 96,042.45 82.61 443.96 1,324.93 153 13 08/01/2015 798.36 560.25 238.12 95,804.34 82.61 443.96 1,324.93 154 13 09/01/2015 798.36 558.86 239.50 95,564.83 82.61 443.96 1,324.93 155 13 10/01/2015 798.36 557.46 240.90 95,323.93 82.61 443.96 1,324.93 156 13 11/01/2015 798.36 556.06 242.31 95,081.63 82.61 443.96 1,324.93 157 14 12/01/2015 798.36 554.64 243.72 94,837.90 86.74 471.00 1,356.10 158 14 01/01/2016 798.36 553.22 245.14 94,592.76 86.74 471.00 1,356.10 159 14 02/01/2016 798.36 551.79 246.57 94,346.19 86.74 471.00 1,356.10 160 14 03/01/2016 798.36 550.35 248.01 94,098.18 86.74 471.00 1,356.10 161 14 04/01/2016 798.36 548.91 249.46 93,848.72 86.74 471.00 1,356.10 162 14 05/01/2016 798.36 547.45 250.91 93,597.81 86.74 471.00 1,356.10 163 14 06/01/2016 798.36 545.99 252.38 93,345.44 86.74 471.00 1,356.10 164 14 07/01/2016 798.36 544.52 253.85 93,091.59 86.74 471.00 1,356.10 165 14 08/01/2016 798.36 543.03 255.33 92,836.26 86.74 471.00 1,356.10 166 14 09/01/2016 798.36 541.54 256.82 92,579.44 86.74 471.00 1,356.10 167 14 10/01/2016 798.36 540.05 258.32 92,321.13 86.74 471.00 1,356.10 168 14 11/01/2016 798.36 538.54 259.82 92,061.30 86.74 471.00 1,356.10 169 15 12/01/2016 798.36 537.02 261.34 91,799.96 91.08 499.68 1,389.12 170 15 01/01/2017 798.36 535.50 262.86 91,537.10 91.08 499.68 1,389.12 171 15 02/01/2017 798.36 533.97 264.40 91,272.70 91.08 499.68 1,389.12 172 15 03/01/2017 798.36 532.42 265.94 91,006.76 91.08 499.68 1,389.12 173 15 04/01/2017 798.36 530.87 267.49 90,739.27 91.08 499.68 1,389.12 174 15 05/01/2017 798.36 529.31 269.05 90,470.22 91.08 499.68 1,389.12 175 15 06/01/2017 798.36 527.74 270.62 90,199.60 91.08 499.68 1,389.12 176 15 07/01/2017 798.36 526.16 272.20 89,927.41 91.08 499.68 1,389.12 177 15 08/01/2017 798.36 524.58 273.79 89,653.62 91.08 499.68 1,389.12 178 15 09/01/2017 798.36 522.98 275.38 89,378.24 91.08 499.68 1,389.12 179 15 10/01/2017 798.36 521.37 276.99 89,101.25 91.08 499.68 1,389.12 180 15 11/01/2017 798.36 519.76 278.61 88,822.64 91.08 499.68 1,389.12 181 16 12/01/2017 798.36 518.13 280.23 88,542.41 95.63 530.11 1,424.11 182 16 01/01/2018 798.36 516.50 281.87 88,260.54 95.63 530.11 1,424.11 183 16 02/01/2018 798.36 514.85 283.51 87,977.03 95.63 530.11 1,424.11 184 16 03/01/2018 798.36 513.20 285.16 87,691.87 95.63 530.11 1,424.11 185 16 04/01/2018 798.36 511.54 286.83 87,405.04 95.63 530.11 1,424.11 186 16 05/01/2018 798.36 509.86 288.50 87,116.54 95.63 530.11 1,424.11 187 16 06/01/2018 798.36 508.18 290.18 86,826.36 95.63 530.11 1,424.11 188 16 07/01/2018 798.36 506.49 291.88 86,534.48 95.63 530.11 1,424.11 189 16 08/01/2018 798.36 504.78 293.58 86,240.90 95.63 530.11 1,424.11 190 16 09/01/2018 798.36 503.07 295.29 85,945.61 95.63 530.11 1,424.11 191 16 10/01/2018 798.36 501.35 297.01 85,648.60 95.63 530.11 1,424.11 192 16 11/01/2018 798.36 499.62 298.75 85,349.85 95.63 530.11 1,424.11 193 17 12/01/2018 798.36 497.87 300.49 85,049.36 100.41 562.40 1,461.17 194 17 01/01/2019 798.36 496.12 302.24 84,747.12 100.41 562.40 1,461.17 195 17 02/01/2019 798.36 494.36 304.00 84,443.12 100.41 562.40 1,461.17 196 17 03/01/2019 798.36 492.58 305.78 84,137.34 100.41 562.40 1,461.17 197 17 04/01/2019 798.36 490.80 307.56 83,829.78 100.41 562.40 1,461.17 198 17 05/01/2019 798.36 489.01 309.36 83,520.42 100.41 562.40 1,461.17 199 17 06/01/2019 798.36 487.20 311.16 83,209.26 100.41 562.40 1,461.17 200 17 07/01/2019 798.36 485.39 312.98 82,896.29 100.41 562.40 1,461.17 2/27/2008 5:55 PM Page 3 of 6 $ASQamortization of a loan.xls.xls Without tax ratesAmortization Schedule Loan Amount To be Amortized 120,000.00 Initial Insurance Amt 552 Interest Rate 7.00% Insurance Inflation Rate 5.00% Monthly Payments 798.36 Number of Years 30 Initial Tax Rate 2.016 Year of Loan 2002 (expressed as $ per $1000 of assessed valuation) Month of Loan 10 Tax Inflation Rate 3.00% Day of Loan 01 Property Value 130,000.00 # of Years in Payment Monthly Interest Principal Additional Carrying Insurance Tax Total Payments Payments Dates Payments Payments Payments Payments Value Payments Payments Payments 201 17 08/01/2019 798.36 483.56 314.80 82,581.48 100.41 562.40 1,461.17 202 17 09/01/2019 798.36 481.73 316.64 82,264.85 100.41 562.40 1,461.17 203 17 10/01/2019 798.36 479.88 318.48 81,946.36 100.41 562.40 1,461.17 204 17 11/01/2019 798.36 478.02 320.34 81,626.02 100.41 562.40 1,461.17 205 18 12/01/2019 798.36 476.15 322.21 81,303.81 105.43 596.65 1,500.44 206 18 01/01/2020 798.36 474.27 324.09 80,979.72 105.43 596.65 1,500.44 207 18 02/01/2020 798.36 472.38 325.98 80,653.74 105.43 596.65 1,500.44 208 18 03/01/2020 798.36 470.48 327.88 80,325.85 105.43 596.65 1,500.44 209 18 04/01/2020 798.36 468.57 329.80 79,996.06 105.43 596.65 1,500.44 210 18 05/01/2020 798.36 466.64 331.72 79,664.34 105.43 596.65 1,500.44 211 18 06/01/2020 798.36 464.71 333.65 79,330.68 105.43 596.65 1,500.44 212 18 07/01/2020 798.36 462.76 335.60 78,995.08 105.43 596.65 1,500.44 213 18 08/01/2020 798.36 460.80 337.56 78,657.53 105.43 596.65 1,500.44 214 18 09/01/2020 798.36 458.84 339.53 78,318.00 105.43 596.65 1,500.44 215 18 10/01/2020 798.36 456.85 341.51 77,976.49 105.43 596.65 1,500.44 216 18 11/01/2020 798.36 454.86 343.50 77,632.99 105.43 596.65 1,500.44 217 19 12/01/2020 798.36 452.86 345.50 77,287.49 110.70 632.98 1,542.05 218 19 01/01/2021 798.36 450.84 347.52 76,939.97 110.70 632.98 1,542.05 219 19 02/01/2021 798.36 448.82 349.55 76,590.42 110.70 632.98 1,542.05 220 19 03/01/2021 798.36 446.78 351.59 76,238.83 110.70 632.98 1,542.05 221 19 04/01/2021 798.36 444.73 353.64 75,885.20 110.70 632.98 1,542.05 222 19 05/01/2021 798.36 442.66 355.70 75,529.50 110.70 632.98 1,542.05 223 19 06/01/2021 798.36 440.59 357.77 75,171.72 110.70 632.98 1,542.05 224 19 07/01/2021 798.36 438.50 359.86 74,811.86 110.70 632.98 1,542.05 225 19 08/01/2021 798.36 436.40 361.96 74,449.90 110.70 632.98 1,542.05 226 19 09/01/2021 798.36 434.29 364.07 74,085.83 110.70 632.98 1,542.05 227 19 10/01/2021 798.36 432.17 366.20 73,719.64 110.70 632.98 1,542.05 228 19 11/01/2021 798.36 430.03 368.33 73,351.30 110.70 632.98 1,542.05 229 20 12/01/2021 798.36 427.88 370.48 72,980.82 116.24 671.53 1,586.14 230 20 01/01/2022 798.36 425.72 372.64 72,608.18 116.24 671.53 1,586.14 231 20 02/01/2022 798.36 423.55 374.82 72,233.37 116.24 671.53 1,586.14 232 20 03/01/2022 798.36 421.36 377.00 71,856.36 116.24 671.53 1,586.14 233 20 04/01/2022 798.36 419.16 379.20 71,477.16 116.24 671.53 1,586.14 234 20 05/01/2022 798.36 416.95 381.41 71,095.75 116.24 671.53 1,586.14 235 20 06/01/2022 798.36 414.73 383.64 70,712.11 116.24 671.53 1,586.14 236 20 07/01/2022 798.36 412.49 385.88 70,326.24 116.24 671.53 1,586.14 237 20 08/01/2022 798.36 410.24 388.13 69,938.11 116.24 671.53 1,586.14 238 20 09/01/2022 798.36 407.97 390.39 69,547.72 116.24 671.53 1,586.14 239 20 10/01/2022 798.36 405.70 392.67 69,155.05 116.24 671.53 1,586.14 240 20 11/01/2022 798.36 403.40 394.96 68,760.09 116.24 671.53 1,586.14 241 21 12/01/2022 798.36 401.10 397.26 68,362.83 122.05 712.43 1,632.84 242 21 01/01/2023 798.36 398.78 399.58 67,963.25 122.05 712.43 1,632.84 243 21 02/01/2023 798.36 396.45 401.91 67,561.34 122.05 712.43 1,632.84 244 21 03/01/2023 798.36 394.11 404.26 67,157.09 122.05 712.43 1,632.84 245 21 04/01/2023 798.36 391.75 406.61 66,750.47 122.05 712.43 1,632.84 246 21 05/01/2023 798.36 389.38 408.99 66,341.49 122.05 712.43 1,632.84 247 21 06/01/2023 798.36 386.99 411.37 65,930.12 122.05 712.43 1,632.84 248 21 07/01/2023 798.36 384.59 413.77 65,516.35 122.05 712.43 1,632.84 249 21 08/01/2023 798.36 382.18 416.18 65,100.16 122.05 712.43 1,632.84 250 21 09/01/2023 798.36 379.75 418.61 64,681.55 122.05 712.43 1,632.84 251 21 10/01/2023 798.36 377.31 421.05 64,260.50 122.05 712.43 1,632.84 252 21 11/01/2023 798.36 374.85 423.51 63,836.99 122.05 712.43 1,632.84 253 22 12/01/2023 798.36 372.38 425.98 63,411.00 128.15 755.82 1,682.33 254 22 01/01/2024 798.36 369.90 428.47 62,982.54 128.15 755.82 1,682.33 255 22 02/01/2024 798.36 367.40 430.96 62,551.57 128.15 755.82 1,682.33 256 22 03/01/2024 798.36 364.88 433.48 62,118.10 128.15 755.82 1,682.33 257 22 04/01/2024 798.36 362.36 436.01 61,682.09 128.15 755.82 1,682.33 258 22 05/01/2024 798.36 359.81 438.55 61,243.54 128.15 755.82 1,682.33 259 22 06/01/2024 798.36 357.25 441.11 60,802.43 128.15 755.82 1,682.33 260 22 07/01/2024 798.36 354.68 443.68 60,358.75 128.15 755.82 1,682.33 261 22 08/01/2024 798.36 352.09 446.27 59,912.48 128.15 755.82 1,682.33 262 22 09/01/2024 798.36 349.49 448.87 59,463.60 128.15 755.82 1,682.33 263 22 10/01/2024 798.36 346.87 451.49 59,012.11 128.15 755.82 1,682.33 264 22 11/01/2024 798.36 344.24 454.13 58,557.98 128.15 755.82 1,682.33 265 23 12/01/2024 798.36 341.59 456.77 58,101.21 134.56 801.85 1,734.77 266 23 01/01/2025 798.36 338.92 459.44 57,641.77 134.56 801.85 1,734.77 267 23 02/01/2025 798.36 336.24 462.12 57,179.65 134.56 801.85 1,734.77 2/27/2008 5:55 PM Page 4 of 6 $ASQamortization of a loan.xls.xls Without tax ratesAmortization Schedule Loan Amount To be Amortized 120,000.00 Initial Insurance Amt 552 Interest Rate 7.00% Insurance Inflation Rate 5.00% Monthly Payments 798.36 Number of Years 30 Initial Tax Rate 2.016 Year of Loan 2002 (expressed as $ per $1000 of assessed valuation) Month of Loan 10 Tax Inflation Rate 3.00% Day of Loan 01 Property Value 130,000.00 # of Years in Payment Monthly Interest Principal Additional Carrying Insurance Tax Total Payments Payments Dates Payments Payments Payments Payments Value Payments Payments Payments 268 23 03/01/2025 798.36 333.55 464.82 56,714.84 134.56 801.85 1,734.77 269 23 04/01/2025 798.36 330.84 467.53 56,247.31 134.56 801.85 1,734.77 270 23 05/01/2025 798.36 328.11 470.25 55,777.06 134.56 801.85 1,734.77 271 23 06/01/2025 798.36 325.37 473.00 55,304.06 134.56 801.85 1,734.77 272 23 07/01/2025 798.36 322.61 475.76 54,828.30 134.56 801.85 1,734.77 273 23 08/01/2025 798.36 319.83 478.53 54,349.77 134.56 801.85 1,734.77 274 23 09/01/2025 798.36 317.04 481.32 53,868.45 134.56 801.85 1,734.77 275 23 10/01/2025 798.36 314.23 484.13 53,384.32 134.56 801.85 1,734.77 276 23 11/01/2025 798.36 311.41 486.95 52,897.36 134.56 801.85 1,734.77 277 24 12/01/2025 798.36 308.57 489.80 52,407.57 141.29 850.68 1,790.33 278 24 01/01/2026 798.36 305.71 492.65 51,914.92 141.29 850.68 1,790.33 279 24 02/01/2026 798.36 302.84 495.53 51,419.39 141.29 850.68 1,790.33 280 24 03/01/2026 798.36 299.95 498.42 50,920.97 141.29 850.68 1,790.33 281 24 04/01/2026 798.36 297.04 501.32 50,419.65 141.29 850.68 1,790.33 282 24 05/01/2026 798.36 294.11 504.25 49,915.40 141.29 850.68 1,790.33 283 24 06/01/2026 798.36 291.17 507.19 49,408.21 141.29 850.68 1,790.33 284 24 07/01/2026 798.36 288.21 510.15 48,898.06 141.29 850.68 1,790.33 285 24 08/01/2026 798.36 285.24 513.12 48,384.94 141.29 850.68 1,790.33 286 24 09/01/2026 798.36 282.25 516.12 47,868.82 141.29 850.68 1,790.33 287 24 10/01/2026 798.36 279.23 519.13 47,349.69 141.29 850.68 1,790.33 288 24 11/01/2026 798.36 276.21 522.16 46,827.54 141.29 850.68 1,790.33 289 25 12/01/2026 798.36 273.16 525.20 46,302.34 148.35 902.48 1,849.20 290 25 01/01/2027 798.36 270.10 528.27 45,774.07 148.35 902.48 1,849.20 291 25 02/01/2027 798.36 267.02 531.35 45,242.72 148.35 902.48 1,849.20 292 25 03/01/2027 798.36 263.92 534.45 44,708.27 148.35 902.48 1,849.20 293 25 04/01/2027 798.36 260.80 537.56 44,170.71 148.35 902.48 1,849.20 294 25 05/01/2027 798.36 257.66 540.70 43,630.01 148.35 902.48 1,849.20 295 25 06/01/2027 798.36 254.51 543.85 43,086.15 148.35 902.48 1,849.20 296 25 07/01/2027 798.36 251.34 547.03 42,539.13 148.35 902.48 1,849.20 297 25 08/01/2027 798.36 248.14 550.22 41,988.91 148.35 902.48 1,849.20 298 25 09/01/2027 798.36 244.94 553.43 41,435.48 148.35 902.48 1,849.20 299 25 10/01/2027 798.36 241.71 556.66 40,878.83 148.35 902.48 1,849.20 300 25 11/01/2027 798.36 238.46 559.90 40,318.92 148.35 902.48 1,849.20 301 26 12/01/2027 798.36 235.19 563.17 39,755.75 155.77 957.45 1,911.58 302 26 01/01/2028 798.36 231.91 566.45 39,189.30 155.77 957.45 1,911.58 303 26 02/01/2028 798.36 228.60 569.76 38,619.54 155.77 957.45 1,911.58 304 26 03/01/2028 798.36 225.28 573.08 38,046.46 155.77 957.45 1,911.58 305 26 04/01/2028 798.36 221.94 576.43 37,470.03 155.77 957.45 1,911.58 306 26 05/01/2028 798.36 218.58 579.79 36,890.24 155.77 957.45 1,911.58 307 26 06/01/2028 798.36 215.19 583.17 36,307.07 155.77 957.45 1,911.58 308 26 07/01/2028 798.36 211.79 586.57 35,720.50 155.77 957.45 1,911.58 309 26 08/01/2028 798.36 208.37 589.99 35,130.51 155.77 957.45 1,911.58 310 26 09/01/2028 798.36 204.93 593.44 34,537.07 155.77 957.45 1,911.58 311 26 10/01/2028 798.36 201.47 596.90 33,940.18 155.77 957.45 1,911.58 312 26 11/01/2028 798.36 197.98 600.38 33,339.80 155.77 957.45 1,911.58 313 27 12/01/2028 798.36 194.48 603.88 32,735.92 163.56 1,015.75 1,977.68 314 27 01/01/2029 798.36 190.96 607.40 32,128.52 163.56 1,015.75 1,977.68 315 27 02/01/2029 798.36 187.42 610.95 31,517.57 163.56 1,015.75 1,977.68 316 27 03/01/2029 798.36 183.85 614.51 30,903.06 163.56 1,015.75 1,977.68 317 27 04/01/2029 798.36 180.27 618.10 30,284.96 163.56 1,015.75 1,977.68 318 27 05/01/2029 798.36 176.66 621.70 29,663.26 163.56 1,015.75 1,977.68 319 27 06/01/2029 798.36 173.04 625.33 29,037.93 163.56 1,015.75 1,977.68 320 27 07/01/2029 798.36 169.39 628.98 28,408.96 163.56 1,015.75 1,977.68 321 27 08/01/2029 798.36 165.72 632.64 27,776.32 163.56 1,015.75 1,977.68 322 27 09/01/2029 798.36 162.03 636.33 27,139.98 163.56 1,015.75 1,977.68 323 27 10/01/2029 798.36 158.32 640.05 26,499.93 163.56 1,015.75 1,977.68 324 27 11/01/2029 798.36 154.58 643.78 25,856.15 163.56 1,015.75 1,977.68 325 28 12/01/2029 798.36 150.83 647.54 25,208.62 171.74 1,077.61 2,047.71 326 28 01/01/2030 798.36 147.05 651.31 24,557.31 171.74 1,077.61 2,047.71 327 28 02/01/2030 798.36 143.25 655.11 23,902.19 171.74 1,077.61 2,047.71 328 28 03/01/2030 798.36 139.43 658.93 23,243.26 171.74 1,077.61 2,047.71 329 28 04/01/2030 798.36 135.59 662.78 22,580.48 171.74 1,077.61 2,047.71 330 28 05/01/2030 798.36 131.72 666.64 21,913.84 171.74 1,077.61 2,047.71 331 28 06/01/2030 798.36 127.83 670.53 21,243.31 171.74 1,077.61 2,047.71 332 28 07/01/2030 798.36 123.92 674.44 20,568.86 171.74 1,077.61 2,047.71 333 28 08/01/2030 798.36 119.99 678.38 19,890.49 171.74 1,077.61 2,047.71 334 28 09/01/2030 798.36 116.03 682.34 19,208.15 171.74 1,077.61 2,047.71 2/27/2008 5:55 PM Page 5 of 6 $ASQamortization of a loan.xls.xls Without tax ratesAmortization Schedule Loan Amount To be Amortized 120,000.00 Initial Insurance Amt 552 Interest Rate 7.00% Insurance Inflation Rate 5.00% Monthly Payments 798.36 Number of Years 30 Initial Tax Rate 2.016 Year of Loan 2002 (expressed as $ per $1000 of assessed valuation) Month of Loan 10 Tax Inflation Rate 3.00% Day of Loan 01 Property Value 130,000.00 # of Years in Payment Monthly Interest Principal Additional Carrying Insurance Tax Total Payments Payments Dates Payments Payments Payments Payments Value Payments Payments Payments 335 28 10/01/2030 798.36 112.05 686.32 18,521.84 171.74 1,077.61 2,047.71 336 28 11/01/2030 798.36 108.04 690.32 17,831.52 171.74 1,077.61 2,047.71 337 29 12/01/2030 798.36 104.02 694.35 17,137.17 180.33 1,143.24 2,121.93 338 29 01/01/2031 798.36 99.97 698.40 16,438.77 180.33 1,143.24 2,121.93 339 29 02/01/2031 798.36 95.89 702.47 15,736.30 180.33 1,143.24 2,121.93 340 29 03/01/2031 798.36 91.80 706.57 15,029.74 180.33 1,143.24 2,121.93 341 29 04/01/2031 798.36 87.67 710.69 14,319.05 180.33 1,143.24 2,121.93 342 29 05/01/2031 798.36 83.53 714.84 13,604.21 180.33 1,143.24 2,121.93 343 29 06/01/2031 798.36 79.36 719.01 12,885.21 180.33 1,143.24 2,121.93 344 29 07/01/2031 798.36 75.16 723.20 12,162.01 180.33 1,143.24 2,121.93 345 29 08/01/2031 798.36 70.95 727.42 11,434.59 180.33 1,143.24 2,121.93 346 29 09/01/2031 798.36 66.70 731.66 10,702.93 180.33 1,143.24 2,121.93 347 29 10/01/2031 798.36 62.43 735.93 9,967.00 180.33 1,143.24 2,121.93 348 29 11/01/2031 798.36 58.14 740.22 9,226.78 180.33 1,143.24 2,121.93 349 30 12/01/2031 798.36 53.82 744.54 8,482.24 189.34 1,212.86 2,200.57 350 30 01/01/2032 798.36 49.48 748.88 7,733.35 189.34 1,212.86 2,200.57 351 30 02/01/2032 798.36 45.11 753.25 6,980.10 189.34 1,212.86 2,200.57 352 30 03/01/2032 798.36 40.72 757.65 6,222.46 189.34 1,212.86 2,200.57 353 30 04/01/2032 798.36 36.30 762.07 5,460.39 189.34 1,212.86 2,200.57 354 30 05/01/2032 798.36 31.85 766.51 4,693.88 189.34 1,212.86 2,200.57 355 30 06/01/2032 798.36 27.38 770.98 3,922.90 189.34 1,212.86 2,200.57 356 30 07/01/2032 798.36 22.88 775.48 3,147.42 189.34 1,212.86 2,200.57 357 30 08/01/2032 798.36 18.36 780.00 2,367.42 189.34 1,212.86 2,200.57 358 30 09/01/2032 798.36 13.81 784.55 1,582.86 189.34 1,212.86 2,200.57 359 30 10/01/2032 798.36 9.23 789.13 793.73 189.34 1,212.86 2,200.57 360 30 11/01/2032 798.36 4.63 793.73 0.00 189.34 1,212.86 2,200.57 2/27/2008 5:55 PM Page 6 of 6 $ASQamortization of a loan.xls.xls Without tax rates