Calculating Amortization Schedule

9/16/2008 Amortization Schedule by Don Shultz This amortization schedule will calculate the monthly payment amount and illustrate the principal and interest portions of each payment up to 30 years. Also, this illustrates the loan balance and accumulated interest paid after each payment. Enter data in boxes below: Amount Financed 10,000.00 Annual Rate (enter 5% as .05) 6.75% Term in Years 5.0 Pmt. No. 1 2 3 4 5 6 7 8 9 10 11 12/1 yr 13 14 15 16 17 18 19 20 21 22 23 24/2 yrs 25 26 27 28 29 30 31 32 33 34 35 36/3 yrs 37 38 39 40 41 42 43 44 45 Begin Bal. 10,000.00 9,859.42 9,718.04 9,575.87 9,432.90 9,289.12 9,144.54 8,999.14 8,852.93 8,705.89 8,558.03 8,409.33 8,259.80 8,109.43 7,958.21 7,806.14 7,653.21 7,499.43 7,344.78 7,189.26 7,032.86 6,875.59 6,717.43 6,558.38 6,398.44 6,237.59 6,075.85 5,913.19 5,749.61 5,585.12 5,419.70 5,253.35 5,086.07 4,917.84 4,748.67 4,578.55 4,407.47 4,235.43 4,062.42 3,888.43 3,713.47 3,537.52 3,360.59 3,182.66 3,003.72 Interest 56.25 55.46 54.66 53.86 53.06 52.25 51.44 50.62 49.80 48.97 48.14 47.30 46.46 45.62 44.76 43.91 43.05 42.18 41.31 40.44 39.56 38.68 37.79 36.89 35.99 35.09 34.18 33.26 32.34 31.42 30.49 29.55 28.61 27.66 26.71 25.75 24.79 23.82 22.85 21.87 20.89 19.90 18.90 17.90 16.90 (Assumes monthly payments) 0.563% (rate per month) 60 (# of months) Calculated Pmt: Loan Principal Add'l Princ.? Balance 140.58 0.00 9,859.42 141.38 0.00 9,718.04 142.17 0.00 9,575.87 142.97 0.00 9,432.90 143.77 0.00 9,289.12 144.58 0.00 9,144.54 145.40 0.00 8,999.14 146.21 0.00 8,852.93 147.04 0.00 8,705.89 147.86 0.00 8,558.03 148.70 0.00 8,409.33 149.53 0.00 8,259.80 150.37 0.00 8,109.43 151.22 0.00 7,958.21 152.07 0.00 7,806.14 152.93 0.00 7,653.21 153.79 0.00 7,499.43 154.65 0.00 7,344.78 155.52 0.00 7,189.26 156.40 0.00 7,032.86 157.27 0.00 6,875.59 158.16 0.00 6,717.43 159.05 0.00 6,558.38 159.94 0.00 6,398.44 160.84 0.00 6,237.59 161.75 0.00 6,075.85 162.66 0.00 5,913.19 163.57 0.00 5,749.61 164.49 0.00 5,585.12 165.42 0.00 5,419.70 166.35 0.00 5,253.35 167.28 0.00 5,086.07 168.23 0.00 4,917.84 169.17 0.00 4,748.67 170.12 0.00 4,578.55 171.08 0.00 4,407.47 172.04 0.00 4,235.43 173.01 0.00 4,062.42 173.98 0.00 3,888.43 174.96 0.00 3,713.47 175.95 0.00 3,537.52 176.94 0.00 3,360.59 177.93 0.00 3,182.66 178.93 0.00 3,003.72 179.94 0.00 2,823.79 196.83 Accum. Int. Paid 56.25 111.71 166.37 220.24 273.30 325.55 376.99 427.61 477.40 526.38 574.51 621.82 668.28 713.89 758.66 802.57 845.62 887.80 929.12 969.56 1,009.12 1,047.79 1,085.58 1,122.47 1,158.46 1,193.54 1,227.72 1,260.98 1,293.32 1,324.74 1,355.23 1,384.78 1,413.39 1,441.05 1,467.76 1,493.51 1,518.31 1,542.13 1,564.98 1,586.85 1,607.74 1,627.64 1,646.54 1,664.45 1,681.34 fec03744-8743-48ba-b6a5-1f32f3060107.xls/Ammo 9/16/2008 Pmt. No. 46 47 48/4 yrs 49 50 51 52 53 54 55 56 57 58 59 60/5 yrs 61 62 63 64 65 66 67 68 69 70 71 72/6 yrs 73 74 75 76 77 78 79 80 81 82 83 84/7 yrs 85 86 87 88 89 90 91 92 93 94 95 96/8 yrs 97 98 99 100 101 102 Begin Bal. 2,823.79 2,642.83 2,460.87 2,277.87 2,093.85 1,908.80 1,722.70 1,535.55 1,347.36 1,158.10 967.78 776.39 583.92 390.37 195.73 0.00 -196.83 -394.78 -593.83 -794.01 -995.31 -1,197.74 -1,401.31 -1,606.03 -1,811.90 -2,018.92 -2,227.12 -2,436.48 -2,647.02 -2,858.74 -3,071.66 -3,285.77 -3,501.09 -3,717.61 -3,935.36 -4,154.33 -4,374.53 -4,595.98 -4,818.66 -5,042.60 -5,267.80 -5,494.27 -5,722.01 -5,951.03 -6,181.34 -6,412.94 -6,645.85 -6,880.07 -7,115.60 -7,352.46 -7,590.65 -7,830.19 -8,071.07 -8,313.30 -8,556.90 -8,801.86 -9,048.21 Interest 15.88 14.87 13.84 12.81 11.78 10.74 9.69 8.64 7.58 6.51 5.44 4.37 3.28 2.20 1.10 0.00 -1.11 -2.22 -3.34 -4.47 -5.60 -6.74 -7.88 -9.03 -10.19 -11.36 -12.53 -13.71 -14.89 -16.08 -17.28 -18.48 -19.69 -20.91 -22.14 -23.37 -24.61 -25.85 -27.10 -28.36 -29.63 -30.91 -32.19 -33.47 -34.77 -36.07 -37.38 -38.70 -40.03 -41.36 -42.70 -44.04 -45.40 -46.76 -48.13 -49.51 -50.90 Principal Add'l Princ.? 180.95 0.00 181.97 0.00 182.99 0.00 184.02 0.00 185.06 0.00 186.10 0.00 187.14 0.00 188.20 0.00 189.26 0.00 190.32 0.00 191.39 0.00 192.47 0.00 193.55 0.00 194.64 0.00 195.73 0.00 196.83 0.00 197.94 0.00 199.06 0.00 200.17 0.00 201.30 0.00 202.43 0.00 203.57 0.00 204.72 0.00 205.87 0.00 207.03 0.00 208.19 0.00 209.36 0.00 210.54 0.00 211.72 0.00 212.92 0.00 214.11 0.00 215.32 0.00 216.53 0.00 217.75 0.00 218.97 0.00 220.20 0.00 221.44 0.00 222.69 0.00 223.94 0.00 225.20 0.00 226.47 0.00 227.74 0.00 229.02 0.00 230.31 0.00 231.60 0.00 232.91 0.00 234.22 0.00 235.53 0.00 236.86 0.00 238.19 0.00 239.53 0.00 240.88 0.00 242.23 0.00 243.60 0.00 244.97 0.00 246.35 0.00 247.73 0.00 Balance 2,642.83 2,460.87 2,277.87 2,093.85 1,908.80 1,722.70 1,535.55 1,347.36 1,158.10 967.78 776.39 583.92 390.37 195.73 0.00 -196.83 -394.78 -593.83 -794.01 -995.31 -1,197.74 -1,401.31 -1,606.03 -1,811.90 -2,018.92 -2,227.12 -2,436.48 -2,647.02 -2,858.74 -3,071.66 -3,285.77 -3,501.09 -3,717.61 -3,935.36 -4,154.33 -4,374.53 -4,595.98 -4,818.66 -5,042.60 -5,267.80 -5,494.27 -5,722.01 -5,951.03 -6,181.34 -6,412.94 -6,645.85 -6,880.07 -7,115.60 -7,352.46 -7,590.65 -7,830.19 -8,071.07 -8,313.30 -8,556.90 -8,801.86 -9,048.21 -9,295.94 Int. Paid 1,697.23 1,712.09 1,725.94 1,738.75 1,750.53 1,761.26 1,770.95 1,779.59 1,787.17 1,793.68 1,799.13 1,803.49 1,806.78 1,808.98 1,810.08 1,810.08 1,808.97 1,806.75 1,803.41 1,798.94 1,793.34 1,786.61 1,778.72 1,769.69 1,759.50 1,748.14 1,735.61 1,721.91 1,707.02 1,690.94 1,673.66 1,655.18 1,635.48 1,614.57 1,592.44 1,569.07 1,544.46 1,518.61 1,491.50 1,463.14 1,433.51 1,402.60 1,370.42 1,336.94 1,302.17 1,266.10 1,228.72 1,190.02 1,149.99 1,108.63 1,065.94 1,021.89 976.49 929.73 881.60 832.09 781.19 fec03744-8743-48ba-b6a5-1f32f3060107.xls/Ammo 9/16/2008 Pmt. No. 103 104 105 106 107 108/9yrs 109 110 111 112 113 114 115 116 117 118 119 120/10yrs 121 122 123 124 125 126 127 128 129 130 131 132/11yrs 133 134 135 136 137 138 139 140 141 142 143 144/12yrs 145 146 147 148 149 150 151 152 153 154 155 156/13yrs 157 158 159 Begin Bal. -9,295.94 -9,545.06 -9,795.59 -10,047.52 -10,300.88 -10,555.65 -10,811.86 -11,069.52 -11,328.62 -11,589.17 -11,851.20 -12,114.70 -12,379.67 -12,646.15 -12,914.11 -13,183.59 -13,454.58 -13,727.10 -14,001.15 -14,276.74 -14,553.88 -14,832.58 -15,112.85 -15,394.69 -15,678.12 -15,963.15 -16,249.78 -16,538.01 -16,827.88 -17,119.37 -17,412.50 -17,707.28 -18,003.72 -18,301.82 -18,601.60 -18,903.07 -19,206.24 -19,511.11 -19,817.69 -20,126.00 -20,436.04 -20,747.83 -21,061.37 -21,376.68 -21,693.76 -22,012.62 -22,333.27 -22,655.73 -22,980.01 -23,306.10 -23,634.03 -23,963.81 -24,295.44 -24,628.94 -24,964.31 -25,301.57 -25,640.72 Interest -52.29 -53.69 -55.10 -56.52 -57.94 -59.38 -60.82 -62.27 -63.72 -65.19 -66.66 -68.15 -69.64 -71.13 -72.64 -74.16 -75.68 -77.21 -78.76 -80.31 -81.87 -83.43 -85.01 -86.60 -88.19 -89.79 -91.40 -93.03 -94.66 -96.30 -97.95 -99.60 -101.27 -102.95 -104.63 -106.33 -108.04 -109.75 -111.47 -113.21 -114.95 -116.71 -118.47 -120.24 -122.03 -123.82 -125.62 -127.44 -129.26 -131.10 -132.94 -134.80 -136.66 -138.54 -140.42 -142.32 -144.23 Principal Add'l Princ.? 249.12 0.00 250.53 0.00 251.93 0.00 253.35 0.00 254.78 0.00 256.21 0.00 257.65 0.00 259.10 0.00 260.56 0.00 262.02 0.00 263.50 0.00 264.98 0.00 266.47 0.00 267.97 0.00 269.48 0.00 270.99 0.00 272.52 0.00 274.05 0.00 275.59 0.00 277.14 0.00 278.70 0.00 280.27 0.00 281.84 0.00 283.43 0.00 285.02 0.00 286.63 0.00 288.24 0.00 289.86 0.00 291.49 0.00 293.13 0.00 294.78 0.00 296.44 0.00 298.11 0.00 299.78 0.00 301.47 0.00 303.16 0.00 304.87 0.00 306.58 0.00 308.31 0.00 310.04 0.00 311.79 0.00 313.54 0.00 315.30 0.00 317.08 0.00 318.86 0.00 320.66 0.00 322.46 0.00 324.27 0.00 326.10 0.00 327.93 0.00 329.78 0.00 331.63 0.00 333.50 0.00 335.37 0.00 337.26 0.00 339.16 0.00 341.06 0.00 Balance -9,545.06 -9,795.59 -10,047.52 -10,300.88 -10,555.65 -10,811.86 -11,069.52 -11,328.62 -11,589.17 -11,851.20 -12,114.70 -12,379.67 -12,646.15 -12,914.11 -13,183.59 -13,454.58 -13,727.10 -14,001.15 -14,276.74 -14,553.88 -14,832.58 -15,112.85 -15,394.69 -15,678.12 -15,963.15 -16,249.78 -16,538.01 -16,827.88 -17,119.37 -17,412.50 -17,707.28 -18,003.72 -18,301.82 -18,601.60 -18,903.07 -19,206.24 -19,511.11 -19,817.69 -20,126.00 -20,436.04 -20,747.83 -21,061.37 -21,376.68 -21,693.76 -22,012.62 -22,333.27 -22,655.73 -22,980.01 -23,306.10 -23,634.03 -23,963.81 -24,295.44 -24,628.94 -24,964.31 -25,301.57 -25,640.72 -25,981.79 Int. Paid 728.90 675.21 620.11 563.59 505.65 446.27 385.46 323.19 259.47 194.28 127.62 59.47 -10.17 -81.30 -153.94 -228.10 -303.78 -381.00 -459.75 -540.06 -621.93 -705.36 -790.37 -876.96 -965.15 -1,054.95 -1,146.35 -1,239.38 -1,334.03 -1,430.33 -1,528.28 -1,627.88 -1,729.15 -1,832.10 -1,936.73 -2,043.06 -2,151.10 -2,260.85 -2,372.32 -2,485.53 -2,600.48 -2,717.19 -2,835.66 -2,955.90 -3,077.93 -3,201.75 -3,327.38 -3,454.81 -3,584.08 -3,715.17 -3,848.12 -3,982.91 -4,119.57 -4,258.11 -4,398.54 -4,540.86 -4,685.09 fec03744-8743-48ba-b6a5-1f32f3060107.xls/Ammo 9/16/2008 Pmt. No. 160 161 162 163 164 165 166 167 168/14yrs 169 170 171 172 173 174 175 176 177 178 179 180/15yrs 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 Begin Bal. -25,981.79 -26,324.77 -26,669.68 -27,016.53 -27,365.34 -27,716.10 -28,068.84 -28,423.56 -28,780.28 -29,139.00 -29,499.74 -29,862.51 -30,227.32 -30,594.19 -30,963.11 -31,334.12 -31,707.21 -32,082.39 -32,459.69 -32,839.11 -33,220.67 -33,604.37 -33,990.23 -34,378.26 -34,768.47 -35,160.88 -35,555.49 -35,952.32 -36,351.39 -36,752.70 -37,156.27 -37,562.11 -37,970.23 -38,380.65 -38,793.37 -39,208.42 -39,625.80 -40,045.53 -40,467.62 -40,892.09 -41,318.94 -41,748.19 -42,179.86 -42,613.96 -43,050.50 -43,489.49 -43,930.95 -44,374.90 -44,821.34 -45,270.30 -45,721.78 -46,175.80 -46,632.37 -47,091.51 -47,553.24 -48,017.56 -48,484.49 Interest -146.15 -148.08 -150.02 -151.97 -153.93 -155.90 -157.89 -159.88 -161.89 -163.91 -165.94 -167.98 -170.03 -172.09 -174.17 -176.25 -178.35 -180.46 -182.59 -184.72 -186.87 -189.02 -191.20 -193.38 -195.57 -197.78 -200.00 -202.23 -204.48 -206.73 -209.00 -211.29 -213.58 -215.89 -218.21 -220.55 -222.90 -225.26 -227.63 -230.02 -232.42 -234.83 -237.26 -239.70 -242.16 -244.63 -247.11 -249.61 -252.12 -254.65 -257.19 -259.74 -262.31 -264.89 -267.49 -270.10 -272.73 Principal Add'l Princ.? 342.98 0.00 344.91 0.00 346.85 0.00 348.80 0.00 350.76 0.00 352.74 0.00 354.72 0.00 356.72 0.00 358.72 0.00 360.74 0.00 362.77 0.00 364.81 0.00 366.86 0.00 368.93 0.00 371.00 0.00 373.09 0.00 375.19 0.00 377.30 0.00 379.42 0.00 381.55 0.00 383.70 0.00 385.86 0.00 388.03 0.00 390.21 0.00 392.41 0.00 394.61 0.00 396.83 0.00 399.07 0.00 401.31 0.00 403.57 0.00 405.84 0.00 408.12 0.00 410.42 0.00 412.73 0.00 415.05 0.00 417.38 0.00 419.73 0.00 422.09 0.00 424.46 0.00 426.85 0.00 429.25 0.00 431.67 0.00 434.10 0.00 436.54 0.00 438.99 0.00 441.46 0.00 443.95 0.00 446.44 0.00 448.95 0.00 451.48 0.00 454.02 0.00 456.57 0.00 459.14 0.00 461.72 0.00 464.32 0.00 466.93 0.00 469.56 0.00 Balance -26,324.77 -26,669.68 -27,016.53 -27,365.34 -27,716.10 -28,068.84 -28,423.56 -28,780.28 -29,139.00 -29,499.74 -29,862.51 -30,227.32 -30,594.19 -30,963.11 -31,334.12 -31,707.21 -32,082.39 -32,459.69 -32,839.11 -33,220.67 -33,604.37 -33,990.23 -34,378.26 -34,768.47 -35,160.88 -35,555.49 -35,952.32 -36,351.39 -36,752.70 -37,156.27 -37,562.11 -37,970.23 -38,380.65 -38,793.37 -39,208.42 -39,625.80 -40,045.53 -40,467.62 -40,892.09 -41,318.94 -41,748.19 -42,179.86 -42,613.96 -43,050.50 -43,489.49 -43,930.95 -44,374.90 -44,821.34 -45,270.30 -45,721.78 -46,175.80 -46,632.37 -47,091.51 -47,553.24 -48,017.56 -48,484.49 -48,954.05 Int. Paid -4,831.23 -4,979.31 -5,129.33 -5,281.30 -5,435.23 -5,591.13 -5,749.02 -5,908.90 -6,070.79 -6,234.69 -6,400.63 -6,568.61 -6,738.64 -6,910.73 -7,084.90 -7,261.15 -7,439.50 -7,619.97 -7,802.55 -7,987.27 -8,174.14 -8,363.16 -8,554.36 -8,747.74 -8,943.31 -9,141.09 -9,341.09 -9,543.32 -9,747.80 -9,954.53 -10,163.53 -10,374.82 -10,588.40 -10,804.29 -11,022.51 -11,243.05 -11,465.95 -11,691.21 -11,918.84 -12,148.85 -12,381.27 -12,616.11 -12,853.37 -13,093.07 -13,335.23 -13,579.86 -13,826.97 -14,076.58 -14,328.70 -14,583.35 -14,840.53 -15,100.27 -15,362.58 -15,627.47 -15,894.95 -16,165.05 -16,437.78 fec03744-8743-48ba-b6a5-1f32f3060107.xls/Ammo 9/16/2008 Pmt. No. 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 Begin Bal. -48,954.05 -49,426.25 -49,901.11 -50,378.64 -50,858.85 -51,341.77 -51,827.40 -52,315.77 -52,806.88 -53,300.75 -53,797.40 -54,296.85 -54,799.10 -55,304.18 -55,812.10 -56,322.88 -56,836.53 -57,353.07 -57,872.51 -58,394.88 -58,920.19 -59,448.45 -59,979.68 -60,513.90 -61,051.13 -61,591.37 -62,134.66 -62,681.00 -63,230.42 -63,782.92 -64,338.54 -64,897.27 -65,459.16 -66,024.20 -66,592.42 -67,163.84 -67,738.47 -68,316.33 -68,897.45 -69,481.83 -70,069.50 -70,660.47 -71,254.77 -71,852.42 -72,453.42 -73,057.81 -73,665.59 -74,276.79 -74,891.44 -75,509.53 -76,131.11 -76,756.18 -77,384.77 -78,016.89 -78,652.57 -79,291.83 -79,934.68 Interest -275.37 -278.02 -280.69 -283.38 -286.08 -288.80 -291.53 -294.28 -297.04 -299.82 -302.61 -305.42 -308.24 -311.09 -313.94 -316.82 -319.71 -322.61 -325.53 -328.47 -331.43 -334.40 -337.39 -340.39 -343.41 -346.45 -349.51 -352.58 -355.67 -358.78 -361.90 -365.05 -368.21 -371.39 -374.58 -377.80 -381.03 -384.28 -387.55 -390.84 -394.14 -397.47 -400.81 -404.17 -407.55 -410.95 -414.37 -417.81 -421.26 -424.74 -428.24 -431.75 -435.29 -438.85 -442.42 -446.02 -449.63 Principal Add'l Princ.? 472.20 0.00 474.86 0.00 477.53 0.00 480.21 0.00 482.92 0.00 485.63 0.00 488.36 0.00 491.11 0.00 493.87 0.00 496.65 0.00 499.44 0.00 502.25 0.00 505.08 0.00 507.92 0.00 510.78 0.00 513.65 0.00 516.54 0.00 519.45 0.00 522.37 0.00 525.31 0.00 528.26 0.00 531.23 0.00 534.22 0.00 537.23 0.00 540.25 0.00 543.29 0.00 546.34 0.00 549.42 0.00 552.51 0.00 555.61 0.00 558.74 0.00 561.88 0.00 565.04 0.00 568.22 0.00 571.42 0.00 574.63 0.00 577.86 0.00 581.11 0.00 584.38 0.00 587.67 0.00 590.98 0.00 594.30 0.00 597.64 0.00 601.00 0.00 604.39 0.00 607.78 0.00 611.20 0.00 614.64 0.00 618.10 0.00 621.58 0.00 625.07 0.00 628.59 0.00 632.12 0.00 635.68 0.00 639.26 0.00 642.85 0.00 646.47 0.00 Balance -49,426.25 -49,901.11 -50,378.64 -50,858.85 -51,341.77 -51,827.40 -52,315.77 -52,806.88 -53,300.75 -53,797.40 -54,296.85 -54,799.10 -55,304.18 -55,812.10 -56,322.88 -56,836.53 -57,353.07 -57,872.51 -58,394.88 -58,920.19 -59,448.45 -59,979.68 -60,513.90 -61,051.13 -61,591.37 -62,134.66 -62,681.00 -63,230.42 -63,782.92 -64,338.54 -64,897.27 -65,459.16 -66,024.20 -66,592.42 -67,163.84 -67,738.47 -68,316.33 -68,897.45 -69,481.83 -70,069.50 -70,660.47 -71,254.77 -71,852.42 -72,453.42 -73,057.81 -73,665.59 -74,276.79 -74,891.44 -75,509.53 -76,131.11 -76,756.18 -77,384.77 -78,016.89 -78,652.57 -79,291.83 -79,934.68 -80,581.15 Int. Paid -16,713.14 -16,991.17 -17,271.86 -17,555.24 -17,841.32 -18,130.12 -18,421.65 -18,715.92 -19,012.96 -19,312.78 -19,615.39 -19,920.81 -20,229.05 -20,540.14 -20,854.08 -21,170.90 -21,490.61 -21,813.22 -22,138.75 -22,467.22 -22,798.65 -23,133.04 -23,470.43 -23,810.82 -24,154.23 -24,500.68 -24,850.19 -25,202.77 -25,558.44 -25,917.22 -26,279.13 -26,644.17 -27,012.38 -27,383.77 -27,758.35 -28,136.15 -28,517.18 -28,901.45 -29,289.00 -29,679.84 -30,073.98 -30,471.44 -30,872.25 -31,276.42 -31,683.97 -32,094.92 -32,509.29 -32,927.10 -33,348.36 -33,773.10 -34,201.34 -34,633.10 -35,068.38 -35,507.23 -35,949.65 -36,395.67 -36,845.30 fec03744-8743-48ba-b6a5-1f32f3060107.xls/Ammo 9/16/2008 Pmt. No. 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 Begin Bal. -80,581.15 -81,231.25 -81,885.01 -82,542.45 -83,203.58 -83,868.44 -84,537.03 -85,209.39 -85,885.53 -86,565.47 -87,249.23 -87,936.84 -88,628.32 -89,323.69 -90,022.97 -90,726.19 -91,433.36 -92,144.50 -92,859.65 -93,578.82 -94,302.04 -95,029.32 -95,760.69 -96,496.18 -97,235.81 -97,979.60 -98,727.56 -99,479.74 -100,236.15 -100,996.81 -101,761.75 -102,531.00 -103,304.57 -104,082.49 -104,864.79 -105,651.49 -106,442.62 -107,238.19 -108,038.24 -108,842.79 -109,651.86 -110,465.49 -111,283.69 -112,106.50 -112,933.93 -113,766.02 -114,602.79 -115,444.26 -116,290.47 -117,141.44 -117,997.20 -118,857.77 -119,723.18 -120,593.45 -121,468.63 -122,348.72 -123,233.77 Interest -453.27 -456.93 -460.60 -464.30 -468.02 -471.76 -475.52 -479.30 -483.11 -486.93 -490.78 -494.64 -498.53 -502.45 -506.38 -510.33 -514.31 -518.31 -522.34 -526.38 -530.45 -534.54 -538.65 -542.79 -546.95 -551.14 -555.34 -559.57 -563.83 -568.11 -572.41 -576.74 -581.09 -585.46 -589.86 -594.29 -598.74 -603.21 -607.72 -612.24 -616.79 -621.37 -625.97 -630.60 -635.25 -639.93 -644.64 -649.37 -654.13 -658.92 -663.73 -668.57 -673.44 -678.34 -683.26 -688.21 -693.19 Principal Add'l Princ.? 650.10 0.00 653.76 0.00 657.44 0.00 661.14 0.00 664.85 0.00 668.59 0.00 672.36 0.00 676.14 0.00 679.94 0.00 683.77 0.00 687.61 0.00 691.48 0.00 695.37 0.00 699.28 0.00 703.21 0.00 707.17 0.00 711.15 0.00 715.15 0.00 719.17 0.00 723.22 0.00 727.28 0.00 731.37 0.00 735.49 0.00 739.63 0.00 743.79 0.00 747.97 0.00 752.18 0.00 756.41 0.00 760.66 0.00 764.94 0.00 769.24 0.00 773.57 0.00 777.92 0.00 782.30 0.00 786.70 0.00 791.12 0.00 795.57 0.00 800.05 0.00 804.55 0.00 809.08 0.00 813.63 0.00 818.20 0.00 822.81 0.00 827.43 0.00 832.09 0.00 836.77 0.00 841.48 0.00 846.21 0.00 850.97 0.00 855.76 0.00 860.57 0.00 865.41 0.00 870.28 0.00 875.17 0.00 880.10 0.00 885.05 0.00 890.02 0.00 Balance -81,231.25 -81,885.01 -82,542.45 -83,203.58 -83,868.44 -84,537.03 -85,209.39 -85,885.53 -86,565.47 -87,249.23 -87,936.84 -88,628.32 -89,323.69 -90,022.97 -90,726.19 -91,433.36 -92,144.50 -92,859.65 -93,578.82 -94,302.04 -95,029.32 -95,760.69 -96,496.18 -97,235.81 -97,979.60 -98,727.56 -99,479.74 -100,236.15 -100,996.81 -101,761.75 -102,531.00 -103,304.57 -104,082.49 -104,864.79 -105,651.49 -106,442.62 -107,238.19 -108,038.24 -108,842.79 -109,651.86 -110,465.49 -111,283.69 -112,106.50 -112,933.93 -113,766.02 -114,602.79 -115,444.26 -116,290.47 -117,141.44 -117,997.20 -118,857.77 -119,723.18 -120,593.45 -121,468.63 -122,348.72 -123,233.77 -124,123.79 Int. Paid -37,298.57 -37,755.49 -38,216.10 -38,680.40 -39,148.42 -39,620.18 -40,095.70 -40,575.00 -41,058.11 -41,545.04 -42,035.82 -42,530.46 -43,029.00 -43,531.44 -44,037.82 -44,548.16 -45,062.47 -45,580.78 -46,103.12 -46,629.50 -47,159.95 -47,694.49 -48,233.14 -48,775.93 -49,322.88 -49,874.02 -50,429.36 -50,988.93 -51,552.76 -52,120.87 -52,693.28 -53,270.02 -53,851.10 -54,436.57 -55,026.43 -55,620.72 -56,219.46 -56,822.68 -57,430.39 -58,042.63 -58,659.42 -59,280.79 -59,906.76 -60,537.36 -61,172.62 -61,812.55 -62,457.19 -63,106.56 -63,760.70 -64,419.62 -65,083.35 -65,751.93 -66,425.37 -67,103.71 -67,786.97 -68,475.18 -69,168.37 fec03744-8743-48ba-b6a5-1f32f3060107.xls/Ammo 9/16/2008 Pmt. No. 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360/30yrs Begin Bal. -124,123.79 -125,018.82 -125,918.89 -126,824.02 -127,734.24 -128,649.58 -129,570.06 -130,495.73 -131,426.60 -132,362.71 -133,304.09 -134,250.76 -135,202.75 -136,160.10 -137,122.84 -138,090.99 -139,064.59 -140,043.66 -141,028.24 -142,018.36 -143,014.04 -144,015.33 -145,022.25 -146,034.84 -147,053.12 -148,077.13 -149,106.90 -150,142.46 -151,183.84 -152,231.09 Interest -698.20 -703.23 -708.29 -713.39 -718.51 -723.65 -728.83 -734.04 -739.27 -744.54 -749.84 -755.16 -760.52 -765.90 -771.32 -776.76 -782.24 -787.75 -793.28 -798.85 -804.45 -810.09 -815.75 -821.45 -827.17 -832.93 -838.73 -844.55 -850.41 -856.30 Principal Add'l Princ.? 895.03 0.00 900.07 0.00 905.13 0.00 910.22 0.00 915.34 0.00 920.49 0.00 925.67 0.00 930.87 0.00 936.11 0.00 941.37 0.00 946.67 0.00 952.00 0.00 957.35 0.00 962.74 0.00 968.15 0.00 973.60 0.00 979.07 0.00 984.58 0.00 990.12 0.00 995.69 0.00 1,001.29 0.00 1,006.92 0.00 1,012.58 0.00 1,018.28 0.00 1,024.01 0.00 1,029.77 0.00 1,035.56 0.00 1,041.39 0.00 1,047.24 0.00 1,053.13 0.00 Balance -125,018.82 -125,918.89 -126,824.02 -127,734.24 -128,649.58 -129,570.06 -130,495.73 -131,426.60 -132,362.71 -133,304.09 -134,250.76 -135,202.75 -136,160.10 -137,122.84 -138,090.99 -139,064.59 -140,043.66 -141,028.24 -142,018.36 -143,014.04 -144,015.33 -145,022.25 -146,034.84 -147,053.12 -148,077.13 -149,106.90 -150,142.46 -151,183.84 -152,231.09 -153,284.22 Int. Paid -69,866.57 -70,569.80 -71,278.09 -71,991.48 -72,709.98 -73,433.64 -74,162.47 -74,896.51 -75,635.78 -76,380.32 -77,130.16 -77,885.32 -78,645.83 -79,411.73 -80,183.05 -80,959.81 -81,742.05 -82,529.80 -83,323.08 -84,121.93 -84,926.39 -85,736.47 -86,552.22 -87,373.67 -88,200.84 -89,033.78 -89,872.50 -90,717.05 -91,567.46 -92,423.76 fec03744-8743-48ba-b6a5-1f32f3060107.xls/Ammo