Excel > Excel Stuff > Investment Related Workbooks > Amortization Schedule
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Excel > Excel Stuff > Investment Related Workbooks > Amortization Schedule as PDF for free.
More details
- Words: 1,984
- Pages: 1
Page 1 House Price Downpayment % Original Principal Number of Payments Annual Interest Rate Payment Period 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 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 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 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 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
Prepared by Timothy R. Mayes 10/14/2008
300,000 10.00% 270,000 360 6.25% $1,662.44 Pmt $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,653.82
Amortization Schedule Int Prin $1,406.25 $1,404.92 $1,403.57 $1,402.23 $1,400.87 $1,399.51 $1,398.14 $1,396.76 $1,395.38 $1,393.99 $1,392.59 $1,391.18 $1,389.77 $1,388.35 $1,386.92 $1,385.49 $1,384.05 $1,382.60 $1,381.14 $1,379.67 $1,378.20 $1,376.72 $1,375.23 $1,373.74 $1,372.23 $1,370.72 $1,369.20 $1,367.68 $1,366.14 $1,364.60 $1,363.05 $1,361.49 $1,359.92 $1,358.34 $1,356.76 $1,355.17 $1,353.57 $1,351.96 $1,350.34 $1,348.72 $1,347.08 $1,345.44 $1,343.79 $1,342.13 $1,340.46 $1,338.78 $1,337.10 $1,335.40 $1,333.70 $1,331.99 $1,330.27 $1,328.54 $1,326.80 $1,325.05 $1,323.29 $1,321.53 $1,319.75 $1,317.97 $1,316.17 $1,314.37 $1,312.55 $1,310.73 $1,308.90 $1,307.06 $1,305.21 $1,303.35 $1,301.48 $1,299.60 $1,297.71 $1,295.81 $1,293.90 $1,291.98 $1,290.05 $1,288.11 $1,286.16 $1,284.20 $1,282.23 $1,280.25 $1,278.26 $1,276.26 $1,274.25 $1,272.23 $1,270.19 $1,268.15 $1,266.10 $1,264.03 $1,261.96 $1,259.87 $1,257.78 $1,255.67 $1,253.55 $1,251.42 $1,249.28 $1,247.13 $1,244.96 $1,242.79 $1,240.60 $1,238.41 $1,236.20 $1,233.98 $1,231.75 $1,229.50 $1,227.25 $1,224.98 $1,222.70 $1,220.41 $1,218.11 $1,215.80 $1,213.47 $1,211.13 $1,208.78 $1,206.42 $1,204.04 $1,201.66 $1,199.26 $1,196.84 $1,194.42 $1,191.98 $1,189.53 $1,187.07 $1,184.59 $1,182.10 $1,179.60 $1,177.09 $1,174.56 $1,172.02 $1,169.46 $1,166.90 $1,164.32 $1,161.72 $1,159.11 $1,156.49 $1,153.86 $1,151.21 $1,148.55 $1,145.87 $1,143.18 $1,140.47 $1,137.76 $1,135.02 $1,132.28 $1,129.51 $1,126.74 $1,123.95 $1,121.14 $1,118.33 $1,115.49 $1,112.64 $1,109.78 $1,106.90 $1,104.01 $1,101.10 $1,098.18 $1,095.24 $1,092.28 $1,089.31 $1,086.33 $1,083.33 $1,080.31 $1,077.28 $1,074.23 $1,071.17 $1,068.09 $1,064.99 $1,061.88 $1,058.75 $1,055.61 $1,052.45 $1,049.27 $1,046.08 $1,042.87 $1,039.64 $1,036.40 $1,033.14 $1,029.86 $1,026.56 $1,023.25 $1,019.92 $1,016.58 $1,013.21 $1,009.83 $1,006.43 $1,003.02 $999.58 $996.13 $992.66 $989.17 $985.66 $982.14 $978.60 $975.03 $971.45 $967.85 $964.24 $960.60 $956.94 $953.27 $949.58 $945.86 $942.13 $938.38 $934.61 $930.82 $927.01 $923.18 $919.33 $915.46 $911.57 $907.66 $903.72 $899.77 $895.80 $891.81 $887.79 $883.76 $879.70 $875.63 $871.53 $867.41 $863.27 $859.11 $854.92 $850.72 $846.49 $842.24 $837.97 $833.67 $829.36 $825.02 $820.66 $816.27 $811.87 $807.44 $802.98 $798.51 $794.01 $789.48 $784.94 $780.37 $775.77 $771.15 $766.51 $761.85 $757.15 $752.44 $747.70 $742.94 $738.15 $733.33 $728.49 $723.63 $718.74 $713.82 $708.88 $703.92 $698.93 $693.91 $688.86 $683.79 $678.70 $673.57 $668.42 $663.24 $658.04 $652.81 $647.55 $642.26 $636.95 $631.61 $626.24 $620.84 $615.42 $609.97 $604.48 $598.97 $593.44 $587.87 $582.27 $576.64 $570.99 $565.31 $559.59 $553.85 $548.07 $542.27 $536.43 $530.57 $524.68 $518.75 $512.79 $506.80 $500.79 $494.74 $488.65 $482.54 $476.40 $470.22 $464.01 $457.77 $451.49 $445.19 $438.85 $432.47 $426.07 $419.63 $413.15 $406.65 $400.11 $393.53 $386.92 $380.28 $373.60 $366.89 $360.14 $353.36 $346.54 $339.69 $332.80 $325.87 $318.91 $311.91 $304.88 $297.81 $290.70 $283.56 $276.38 $269.16 $261.90 $254.61 $247.27 $239.90 $232.49 $225.05 $217.56 $210.03 $202.47 $194.87 $187.22 $179.54 $171.82 $164.05 $156.25 $148.40 $140.52 $132.59 $124.62 $116.61 $108.56 $100.47 $92.33 $84.16 $75.94 $67.67 $59.37 $51.02 $42.62 $34.19 $25.71 $17.18 $8.61
$256.19 $257.52 $258.86 $260.21 $261.57 $262.93 $264.30 $265.67 $267.06 $268.45 $269.85 $271.25 $272.66 $274.08 $275.51 $276.95 $278.39 $279.84 $281.30 $282.76 $284.24 $285.72 $287.20 $288.70 $290.20 $291.71 $293.23 $294.76 $296.30 $297.84 $299.39 $300.95 $302.52 $304.09 $305.68 $307.27 $308.87 $310.48 $312.10 $313.72 $315.35 $317.00 $318.65 $320.31 $321.98 $323.65 $325.34 $327.03 $328.74 $330.45 $332.17 $333.90 $335.64 $337.39 $339.14 $340.91 $342.69 $344.47 $346.27 $348.07 $349.88 $351.70 $353.54 $355.38 $357.23 $359.09 $360.96 $362.84 $364.73 $366.63 $368.54 $370.46 $372.39 $374.33 $376.28 $378.24 $380.21 $382.19 $384.18 $386.18 $388.19 $390.21 $392.24 $394.29 $396.34 $398.40 $400.48 $402.56 $404.66 $406.77 $408.89 $411.02 $413.16 $415.31 $417.47 $419.65 $421.83 $424.03 $426.24 $428.46 $430.69 $432.93 $435.19 $437.45 $439.73 $442.02 $444.32 $446.64 $448.97 $451.30 $453.65 $456.02 $458.39 $460.78 $463.18 $465.59 $468.02 $470.45 $472.90 $475.37 $477.84 $480.33 $482.83 $485.35 $487.88 $490.42 $492.97 $495.54 $498.12 $500.71 $503.32 $505.94 $508.58 $511.23 $513.89 $516.57 $519.26 $521.96 $524.68 $527.41 $530.16 $532.92 $535.70 $538.49 $541.29 $544.11 $546.95 $549.79 $552.66 $555.54 $558.43 $561.34 $564.26 $567.20 $570.15 $573.12 $576.11 $579.11 $582.13 $585.16 $588.21 $591.27 $594.35 $597.44 $600.56 $603.68 $606.83 $609.99 $613.17 $616.36 $619.57 $622.80 $626.04 $629.30 $632.58 $635.87 $639.18 $642.51 $645.86 $649.22 $652.61 $656.00 $659.42 $662.86 $666.31 $669.78 $673.27 $676.77 $680.30 $683.84 $687.40 $690.98 $694.58 $698.20 $701.84 $705.49 $709.17 $712.86 $716.57 $720.30 $724.06 $727.83 $731.62 $735.43 $739.26 $743.11 $746.98 $750.87 $754.78 $758.71 $762.66 $766.64 $770.63 $774.64 $778.68 $782.73 $786.81 $790.91 $795.03 $799.17 $803.33 $807.51 $811.72 $815.95 $820.20 $824.47 $828.76 $833.08 $837.42 $841.78 $846.16 $850.57 $855.00 $859.45 $863.93 $868.43 $872.95 $877.50 $882.07 $886.66 $891.28 $895.92 $900.59 $905.28 $910.00 $914.74 $919.50 $924.29 $929.10 $933.94 $938.81 $943.70 $948.61 $953.55 $958.52 $963.51 $968.53 $973.57 $978.64 $983.74 $988.87 $994.02 $999.19 $1,004.40 $1,009.63 $1,014.89 $1,020.17 $1,025.49 $1,030.83 $1,036.20 $1,041.59 $1,047.02 $1,052.47 $1,057.95 $1,063.46 $1,069.00 $1,074.57 $1,080.17 $1,085.79 $1,091.45 $1,097.13 $1,102.85 $1,108.59 $1,114.36 $1,120.17 $1,126.00 $1,131.87 $1,137.76 $1,143.69 $1,149.64 $1,155.63 $1,161.65 $1,167.70 $1,173.78 $1,179.90 $1,186.04 $1,192.22 $1,198.43 $1,204.67 $1,210.94 $1,217.25 $1,223.59 $1,229.96 $1,236.37 $1,242.81 $1,249.28 $1,255.79 $1,262.33 $1,268.90 $1,275.51 $1,282.16 $1,288.83 $1,295.55 $1,302.29 $1,309.08 $1,315.90 $1,322.75 $1,329.64 $1,336.56 $1,343.53 $1,350.52 $1,357.56 $1,364.63 $1,371.73 $1,378.88 $1,386.06 $1,393.28 $1,400.54 $1,407.83 $1,415.16 $1,422.53 $1,429.94 $1,437.39 $1,444.88 $1,452.40 $1,459.97 $1,467.57 $1,475.21 $1,482.90 $1,490.62 $1,498.39 $1,506.19 $1,514.03 $1,521.92 $1,529.85 $1,537.81 $1,545.82 $1,553.87 $1,561.97 $1,570.10 $1,578.28 $1,586.50 $1,594.76 $1,603.07 $1,611.42 $1,619.81 $1,628.25 $1,636.73 $1,645.25 $1,645.21
Extra Prin $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$-
Balance $270,000.00 $269,743.81 $269,486.29 $269,227.43 $268,967.22 $268,705.66 $268,442.73 $268,178.43 $267,912.76 $267,645.70 $267,377.25 $267,107.40 $266,836.15 $266,563.49 $266,289.40 $266,013.89 $265,736.94 $265,458.55 $265,178.71 $264,897.41 $264,614.65 $264,330.42 $264,044.70 $263,757.50 $263,468.80 $263,178.60 $262,886.88 $262,593.65 $262,298.89 $262,002.59 $261,704.75 $261,405.36 $261,104.41 $260,801.89 $260,497.80 $260,192.12 $259,884.85 $259,575.98 $259,265.50 $258,953.41 $258,639.69 $258,324.33 $258,007.34 $257,688.69 $257,368.38 $257,046.40 $256,722.75 $256,397.41 $256,070.38 $255,741.64 $255,411.19 $255,079.02 $254,745.12 $254,409.48 $254,072.10 $253,732.95 $253,392.04 $253,049.36 $252,704.89 $252,358.62 $252,010.55 $251,660.67 $251,308.97 $250,955.43 $250,600.05 $250,242.83 $249,883.74 $249,522.78 $249,159.94 $248,795.21 $248,428.58 $248,060.05 $247,689.59 $247,317.20 $246,942.88 $246,566.60 $246,188.37 $245,808.16 $245,425.98 $245,041.80 $244,655.62 $244,267.43 $243,877.22 $243,484.98 $243,090.70 $242,694.36 $242,295.95 $241,895.47 $241,492.91 $241,088.25 $240,681.48 $240,272.59 $239,861.58 $239,448.42 $239,033.11 $238,615.64 $238,195.99 $237,774.16 $237,350.13 $236,923.89 $236,495.43 $236,064.74 $235,631.81 $235,196.62 $234,759.17 $234,319.44 $233,877.42 $233,433.09 $232,986.45 $232,537.49 $232,086.18 $231,632.53 $231,176.51 $230,718.12 $230,257.34 $229,794.16 $229,328.57 $228,860.55 $228,390.10 $227,917.19 $227,441.82 $226,963.98 $226,483.65 $226,000.81 $225,515.47 $225,027.59 $224,537.17 $224,044.20 $223,548.66 $223,050.54 $222,549.82 $222,046.50 $221,540.56 $221,031.98 $220,520.75 $220,006.86 $219,490.29 $218,971.03 $218,449.07 $217,924.39 $217,396.98 $216,866.82 $216,333.89 $215,798.20 $215,259.71 $214,718.42 $214,174.31 $213,627.36 $213,077.57 $212,524.91 $211,969.37 $211,410.94 $210,849.61 $210,285.35 $209,718.15 $209,147.99 $208,574.87 $207,998.76 $207,419.65 $206,837.52 $206,252.36 $205,664.16 $205,072.89 $204,478.54 $203,881.10 $203,280.54 $202,676.86 $202,070.03 $201,460.04 $200,846.88 $200,230.52 $199,610.95 $198,988.15 $198,362.11 $197,732.81 $197,100.23 $196,464.36 $195,825.18 $195,182.66 $194,536.80 $193,887.58 $193,234.97 $192,578.97 $191,919.55 $191,256.69 $190,590.39 $189,920.61 $189,247.34 $188,570.57 $187,890.27 $187,206.43 $186,519.03 $185,828.04 $185,133.46 $184,435.26 $183,733.42 $183,027.93 $182,318.77 $181,605.91 $180,889.33 $180,169.03 $179,444.97 $178,717.15 $177,985.53 $177,250.10 $176,510.84 $175,767.73 $175,020.75 $174,269.88 $173,515.10 $172,756.39 $171,993.73 $171,227.09 $170,456.46 $169,681.82 $168,903.14 $168,120.41 $167,333.60 $166,542.69 $165,747.67 $164,948.50 $164,145.17 $163,337.66 $162,525.94 $161,709.99 $160,889.79 $160,065.32 $159,236.56 $158,403.48 $157,566.06 $156,724.28 $155,878.12 $155,027.55 $154,172.55 $153,313.09 $152,449.16 $151,580.73 $150,707.78 $149,830.28 $148,948.21 $148,061.54 $147,170.26 $146,274.34 $145,373.75 $144,468.46 $143,558.47 $142,643.73 $141,724.23 $140,799.94 $139,870.84 $138,936.90 $137,998.09 $137,054.39 $136,105.78 $135,152.23 $134,193.71 $133,230.20 $132,261.67 $131,288.10 $130,309.45 $129,325.71 $128,336.85 $127,342.83 $126,343.64 $125,339.24 $124,329.61 $123,314.73 $122,294.55 $121,269.07 $120,238.24 $119,202.05 $118,160.45 $117,113.44 $116,060.97 $115,003.01 $113,939.55 $112,870.55 $111,795.98 $110,715.82 $109,630.02 $108,538.58 $107,441.45 $106,338.60 $105,230.01 $104,115.65 $102,995.48 $101,869.48 $100,737.61 $99,599.85 $98,456.16 $97,306.52 $96,150.89 $94,989.24 $93,821.54 $92,647.75 $91,467.86 $90,281.82 $89,089.60 $87,891.17 $86,686.50 $85,475.56 $84,258.30 $83,034.71 $81,804.75 $80,568.38 $79,325.57 $78,076.29 $76,820.50 $75,558.17 $74,289.26 $73,013.75 $71,731.59 $70,442.76 $69,147.21 $67,844.92 $66,535.84 $65,219.94 $63,897.20 $62,567.56 $61,230.99 $59,887.47 $58,536.95 $57,179.39 $55,814.76 $54,443.03 $53,064.15 $51,678.09 $50,284.81 $48,884.27 $47,476.44 $46,061.28 $44,638.74 $43,208.80 $41,771.41 $40,326.53 $38,874.13 $37,414.16 $35,946.59 $34,471.38 $32,988.48 $31,497.86 $29,999.47 $28,493.28 $26,979.25 $25,457.33 $23,927.48 $22,389.67 $20,843.85 $19,289.97 $17,728.00 $16,157.90 $14,579.62 $12,993.12 $11,398.36 $9,795.29 $8,183.87 $6,564.05 $4,935.81 $3,299.08 $1,653.82 $-
Note: To generate an amortization schedule simply enter the correct numbers into B1, B2, B4, and B5. If you do not plan on making extra principal payments, enter 0 into every cell in the E7:E366 range (or leave them blank). This worksheet is protected so that the formulas cannot be changed in any way by mistake. You can only change B1, B2, B4, B5 and E7:E366. If you wish to edit the formulas, choose Tools - Protection - Unprotect Sheet from the menus. One more thing: I have set up this sheet so that if there are extra principal payments or a shorter amortization period (i.e., a 15 year mortgage) all of the cells beyond the payoff point are blanked out. By the way, I do not provide any guarantees. Use this sheet at your own risk, though I'm 99.99% confident that it is correct.
Prepared by Timothy R. Mayes 10/14/2008
300,000 10.00% 270,000 360 6.25% $1,662.44 Pmt $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,662.44 $1,653.82
Amortization Schedule Int Prin $1,406.25 $1,404.92 $1,403.57 $1,402.23 $1,400.87 $1,399.51 $1,398.14 $1,396.76 $1,395.38 $1,393.99 $1,392.59 $1,391.18 $1,389.77 $1,388.35 $1,386.92 $1,385.49 $1,384.05 $1,382.60 $1,381.14 $1,379.67 $1,378.20 $1,376.72 $1,375.23 $1,373.74 $1,372.23 $1,370.72 $1,369.20 $1,367.68 $1,366.14 $1,364.60 $1,363.05 $1,361.49 $1,359.92 $1,358.34 $1,356.76 $1,355.17 $1,353.57 $1,351.96 $1,350.34 $1,348.72 $1,347.08 $1,345.44 $1,343.79 $1,342.13 $1,340.46 $1,338.78 $1,337.10 $1,335.40 $1,333.70 $1,331.99 $1,330.27 $1,328.54 $1,326.80 $1,325.05 $1,323.29 $1,321.53 $1,319.75 $1,317.97 $1,316.17 $1,314.37 $1,312.55 $1,310.73 $1,308.90 $1,307.06 $1,305.21 $1,303.35 $1,301.48 $1,299.60 $1,297.71 $1,295.81 $1,293.90 $1,291.98 $1,290.05 $1,288.11 $1,286.16 $1,284.20 $1,282.23 $1,280.25 $1,278.26 $1,276.26 $1,274.25 $1,272.23 $1,270.19 $1,268.15 $1,266.10 $1,264.03 $1,261.96 $1,259.87 $1,257.78 $1,255.67 $1,253.55 $1,251.42 $1,249.28 $1,247.13 $1,244.96 $1,242.79 $1,240.60 $1,238.41 $1,236.20 $1,233.98 $1,231.75 $1,229.50 $1,227.25 $1,224.98 $1,222.70 $1,220.41 $1,218.11 $1,215.80 $1,213.47 $1,211.13 $1,208.78 $1,206.42 $1,204.04 $1,201.66 $1,199.26 $1,196.84 $1,194.42 $1,191.98 $1,189.53 $1,187.07 $1,184.59 $1,182.10 $1,179.60 $1,177.09 $1,174.56 $1,172.02 $1,169.46 $1,166.90 $1,164.32 $1,161.72 $1,159.11 $1,156.49 $1,153.86 $1,151.21 $1,148.55 $1,145.87 $1,143.18 $1,140.47 $1,137.76 $1,135.02 $1,132.28 $1,129.51 $1,126.74 $1,123.95 $1,121.14 $1,118.33 $1,115.49 $1,112.64 $1,109.78 $1,106.90 $1,104.01 $1,101.10 $1,098.18 $1,095.24 $1,092.28 $1,089.31 $1,086.33 $1,083.33 $1,080.31 $1,077.28 $1,074.23 $1,071.17 $1,068.09 $1,064.99 $1,061.88 $1,058.75 $1,055.61 $1,052.45 $1,049.27 $1,046.08 $1,042.87 $1,039.64 $1,036.40 $1,033.14 $1,029.86 $1,026.56 $1,023.25 $1,019.92 $1,016.58 $1,013.21 $1,009.83 $1,006.43 $1,003.02 $999.58 $996.13 $992.66 $989.17 $985.66 $982.14 $978.60 $975.03 $971.45 $967.85 $964.24 $960.60 $956.94 $953.27 $949.58 $945.86 $942.13 $938.38 $934.61 $930.82 $927.01 $923.18 $919.33 $915.46 $911.57 $907.66 $903.72 $899.77 $895.80 $891.81 $887.79 $883.76 $879.70 $875.63 $871.53 $867.41 $863.27 $859.11 $854.92 $850.72 $846.49 $842.24 $837.97 $833.67 $829.36 $825.02 $820.66 $816.27 $811.87 $807.44 $802.98 $798.51 $794.01 $789.48 $784.94 $780.37 $775.77 $771.15 $766.51 $761.85 $757.15 $752.44 $747.70 $742.94 $738.15 $733.33 $728.49 $723.63 $718.74 $713.82 $708.88 $703.92 $698.93 $693.91 $688.86 $683.79 $678.70 $673.57 $668.42 $663.24 $658.04 $652.81 $647.55 $642.26 $636.95 $631.61 $626.24 $620.84 $615.42 $609.97 $604.48 $598.97 $593.44 $587.87 $582.27 $576.64 $570.99 $565.31 $559.59 $553.85 $548.07 $542.27 $536.43 $530.57 $524.68 $518.75 $512.79 $506.80 $500.79 $494.74 $488.65 $482.54 $476.40 $470.22 $464.01 $457.77 $451.49 $445.19 $438.85 $432.47 $426.07 $419.63 $413.15 $406.65 $400.11 $393.53 $386.92 $380.28 $373.60 $366.89 $360.14 $353.36 $346.54 $339.69 $332.80 $325.87 $318.91 $311.91 $304.88 $297.81 $290.70 $283.56 $276.38 $269.16 $261.90 $254.61 $247.27 $239.90 $232.49 $225.05 $217.56 $210.03 $202.47 $194.87 $187.22 $179.54 $171.82 $164.05 $156.25 $148.40 $140.52 $132.59 $124.62 $116.61 $108.56 $100.47 $92.33 $84.16 $75.94 $67.67 $59.37 $51.02 $42.62 $34.19 $25.71 $17.18 $8.61
$256.19 $257.52 $258.86 $260.21 $261.57 $262.93 $264.30 $265.67 $267.06 $268.45 $269.85 $271.25 $272.66 $274.08 $275.51 $276.95 $278.39 $279.84 $281.30 $282.76 $284.24 $285.72 $287.20 $288.70 $290.20 $291.71 $293.23 $294.76 $296.30 $297.84 $299.39 $300.95 $302.52 $304.09 $305.68 $307.27 $308.87 $310.48 $312.10 $313.72 $315.35 $317.00 $318.65 $320.31 $321.98 $323.65 $325.34 $327.03 $328.74 $330.45 $332.17 $333.90 $335.64 $337.39 $339.14 $340.91 $342.69 $344.47 $346.27 $348.07 $349.88 $351.70 $353.54 $355.38 $357.23 $359.09 $360.96 $362.84 $364.73 $366.63 $368.54 $370.46 $372.39 $374.33 $376.28 $378.24 $380.21 $382.19 $384.18 $386.18 $388.19 $390.21 $392.24 $394.29 $396.34 $398.40 $400.48 $402.56 $404.66 $406.77 $408.89 $411.02 $413.16 $415.31 $417.47 $419.65 $421.83 $424.03 $426.24 $428.46 $430.69 $432.93 $435.19 $437.45 $439.73 $442.02 $444.32 $446.64 $448.97 $451.30 $453.65 $456.02 $458.39 $460.78 $463.18 $465.59 $468.02 $470.45 $472.90 $475.37 $477.84 $480.33 $482.83 $485.35 $487.88 $490.42 $492.97 $495.54 $498.12 $500.71 $503.32 $505.94 $508.58 $511.23 $513.89 $516.57 $519.26 $521.96 $524.68 $527.41 $530.16 $532.92 $535.70 $538.49 $541.29 $544.11 $546.95 $549.79 $552.66 $555.54 $558.43 $561.34 $564.26 $567.20 $570.15 $573.12 $576.11 $579.11 $582.13 $585.16 $588.21 $591.27 $594.35 $597.44 $600.56 $603.68 $606.83 $609.99 $613.17 $616.36 $619.57 $622.80 $626.04 $629.30 $632.58 $635.87 $639.18 $642.51 $645.86 $649.22 $652.61 $656.00 $659.42 $662.86 $666.31 $669.78 $673.27 $676.77 $680.30 $683.84 $687.40 $690.98 $694.58 $698.20 $701.84 $705.49 $709.17 $712.86 $716.57 $720.30 $724.06 $727.83 $731.62 $735.43 $739.26 $743.11 $746.98 $750.87 $754.78 $758.71 $762.66 $766.64 $770.63 $774.64 $778.68 $782.73 $786.81 $790.91 $795.03 $799.17 $803.33 $807.51 $811.72 $815.95 $820.20 $824.47 $828.76 $833.08 $837.42 $841.78 $846.16 $850.57 $855.00 $859.45 $863.93 $868.43 $872.95 $877.50 $882.07 $886.66 $891.28 $895.92 $900.59 $905.28 $910.00 $914.74 $919.50 $924.29 $929.10 $933.94 $938.81 $943.70 $948.61 $953.55 $958.52 $963.51 $968.53 $973.57 $978.64 $983.74 $988.87 $994.02 $999.19 $1,004.40 $1,009.63 $1,014.89 $1,020.17 $1,025.49 $1,030.83 $1,036.20 $1,041.59 $1,047.02 $1,052.47 $1,057.95 $1,063.46 $1,069.00 $1,074.57 $1,080.17 $1,085.79 $1,091.45 $1,097.13 $1,102.85 $1,108.59 $1,114.36 $1,120.17 $1,126.00 $1,131.87 $1,137.76 $1,143.69 $1,149.64 $1,155.63 $1,161.65 $1,167.70 $1,173.78 $1,179.90 $1,186.04 $1,192.22 $1,198.43 $1,204.67 $1,210.94 $1,217.25 $1,223.59 $1,229.96 $1,236.37 $1,242.81 $1,249.28 $1,255.79 $1,262.33 $1,268.90 $1,275.51 $1,282.16 $1,288.83 $1,295.55 $1,302.29 $1,309.08 $1,315.90 $1,322.75 $1,329.64 $1,336.56 $1,343.53 $1,350.52 $1,357.56 $1,364.63 $1,371.73 $1,378.88 $1,386.06 $1,393.28 $1,400.54 $1,407.83 $1,415.16 $1,422.53 $1,429.94 $1,437.39 $1,444.88 $1,452.40 $1,459.97 $1,467.57 $1,475.21 $1,482.90 $1,490.62 $1,498.39 $1,506.19 $1,514.03 $1,521.92 $1,529.85 $1,537.81 $1,545.82 $1,553.87 $1,561.97 $1,570.10 $1,578.28 $1,586.50 $1,594.76 $1,603.07 $1,611.42 $1,619.81 $1,628.25 $1,636.73 $1,645.25 $1,645.21
Extra Prin $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$-
Balance $270,000.00 $269,743.81 $269,486.29 $269,227.43 $268,967.22 $268,705.66 $268,442.73 $268,178.43 $267,912.76 $267,645.70 $267,377.25 $267,107.40 $266,836.15 $266,563.49 $266,289.40 $266,013.89 $265,736.94 $265,458.55 $265,178.71 $264,897.41 $264,614.65 $264,330.42 $264,044.70 $263,757.50 $263,468.80 $263,178.60 $262,886.88 $262,593.65 $262,298.89 $262,002.59 $261,704.75 $261,405.36 $261,104.41 $260,801.89 $260,497.80 $260,192.12 $259,884.85 $259,575.98 $259,265.50 $258,953.41 $258,639.69 $258,324.33 $258,007.34 $257,688.69 $257,368.38 $257,046.40 $256,722.75 $256,397.41 $256,070.38 $255,741.64 $255,411.19 $255,079.02 $254,745.12 $254,409.48 $254,072.10 $253,732.95 $253,392.04 $253,049.36 $252,704.89 $252,358.62 $252,010.55 $251,660.67 $251,308.97 $250,955.43 $250,600.05 $250,242.83 $249,883.74 $249,522.78 $249,159.94 $248,795.21 $248,428.58 $248,060.05 $247,689.59 $247,317.20 $246,942.88 $246,566.60 $246,188.37 $245,808.16 $245,425.98 $245,041.80 $244,655.62 $244,267.43 $243,877.22 $243,484.98 $243,090.70 $242,694.36 $242,295.95 $241,895.47 $241,492.91 $241,088.25 $240,681.48 $240,272.59 $239,861.58 $239,448.42 $239,033.11 $238,615.64 $238,195.99 $237,774.16 $237,350.13 $236,923.89 $236,495.43 $236,064.74 $235,631.81 $235,196.62 $234,759.17 $234,319.44 $233,877.42 $233,433.09 $232,986.45 $232,537.49 $232,086.18 $231,632.53 $231,176.51 $230,718.12 $230,257.34 $229,794.16 $229,328.57 $228,860.55 $228,390.10 $227,917.19 $227,441.82 $226,963.98 $226,483.65 $226,000.81 $225,515.47 $225,027.59 $224,537.17 $224,044.20 $223,548.66 $223,050.54 $222,549.82 $222,046.50 $221,540.56 $221,031.98 $220,520.75 $220,006.86 $219,490.29 $218,971.03 $218,449.07 $217,924.39 $217,396.98 $216,866.82 $216,333.89 $215,798.20 $215,259.71 $214,718.42 $214,174.31 $213,627.36 $213,077.57 $212,524.91 $211,969.37 $211,410.94 $210,849.61 $210,285.35 $209,718.15 $209,147.99 $208,574.87 $207,998.76 $207,419.65 $206,837.52 $206,252.36 $205,664.16 $205,072.89 $204,478.54 $203,881.10 $203,280.54 $202,676.86 $202,070.03 $201,460.04 $200,846.88 $200,230.52 $199,610.95 $198,988.15 $198,362.11 $197,732.81 $197,100.23 $196,464.36 $195,825.18 $195,182.66 $194,536.80 $193,887.58 $193,234.97 $192,578.97 $191,919.55 $191,256.69 $190,590.39 $189,920.61 $189,247.34 $188,570.57 $187,890.27 $187,206.43 $186,519.03 $185,828.04 $185,133.46 $184,435.26 $183,733.42 $183,027.93 $182,318.77 $181,605.91 $180,889.33 $180,169.03 $179,444.97 $178,717.15 $177,985.53 $177,250.10 $176,510.84 $175,767.73 $175,020.75 $174,269.88 $173,515.10 $172,756.39 $171,993.73 $171,227.09 $170,456.46 $169,681.82 $168,903.14 $168,120.41 $167,333.60 $166,542.69 $165,747.67 $164,948.50 $164,145.17 $163,337.66 $162,525.94 $161,709.99 $160,889.79 $160,065.32 $159,236.56 $158,403.48 $157,566.06 $156,724.28 $155,878.12 $155,027.55 $154,172.55 $153,313.09 $152,449.16 $151,580.73 $150,707.78 $149,830.28 $148,948.21 $148,061.54 $147,170.26 $146,274.34 $145,373.75 $144,468.46 $143,558.47 $142,643.73 $141,724.23 $140,799.94 $139,870.84 $138,936.90 $137,998.09 $137,054.39 $136,105.78 $135,152.23 $134,193.71 $133,230.20 $132,261.67 $131,288.10 $130,309.45 $129,325.71 $128,336.85 $127,342.83 $126,343.64 $125,339.24 $124,329.61 $123,314.73 $122,294.55 $121,269.07 $120,238.24 $119,202.05 $118,160.45 $117,113.44 $116,060.97 $115,003.01 $113,939.55 $112,870.55 $111,795.98 $110,715.82 $109,630.02 $108,538.58 $107,441.45 $106,338.60 $105,230.01 $104,115.65 $102,995.48 $101,869.48 $100,737.61 $99,599.85 $98,456.16 $97,306.52 $96,150.89 $94,989.24 $93,821.54 $92,647.75 $91,467.86 $90,281.82 $89,089.60 $87,891.17 $86,686.50 $85,475.56 $84,258.30 $83,034.71 $81,804.75 $80,568.38 $79,325.57 $78,076.29 $76,820.50 $75,558.17 $74,289.26 $73,013.75 $71,731.59 $70,442.76 $69,147.21 $67,844.92 $66,535.84 $65,219.94 $63,897.20 $62,567.56 $61,230.99 $59,887.47 $58,536.95 $57,179.39 $55,814.76 $54,443.03 $53,064.15 $51,678.09 $50,284.81 $48,884.27 $47,476.44 $46,061.28 $44,638.74 $43,208.80 $41,771.41 $40,326.53 $38,874.13 $37,414.16 $35,946.59 $34,471.38 $32,988.48 $31,497.86 $29,999.47 $28,493.28 $26,979.25 $25,457.33 $23,927.48 $22,389.67 $20,843.85 $19,289.97 $17,728.00 $16,157.90 $14,579.62 $12,993.12 $11,398.36 $9,795.29 $8,183.87 $6,564.05 $4,935.81 $3,299.08 $1,653.82 $-
Note: To generate an amortization schedule simply enter the correct numbers into B1, B2, B4, and B5. If you do not plan on making extra principal payments, enter 0 into every cell in the E7:E366 range (or leave them blank). This worksheet is protected so that the formulas cannot be changed in any way by mistake. You can only change B1, B2, B4, B5 and E7:E366. If you wish to edit the formulas, choose Tools - Protection - Unprotect Sheet from the menus. One more thing: I have set up this sheet so that if there are extra principal payments or a shorter amortization period (i.e., a 15 year mortgage) all of the cells beyond the payoff point are blanked out. By the way, I do not provide any guarantees. Use this sheet at your own risk, though I'm 99.99% confident that it is correct.
