Biweekly Mortgage Payment Amortization
Inputs Loan principal amount Annual interest rate Loan period in years (30 max.) Base year Loan start date Date of first payment First 26 Payments Payment # 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 Payment Date 01/15/08 01/29/08 02/12/08 02/26/08 03/11/08 03/25/08 04/08/08 04/22/08 05/06/08 05/20/08 06/03/08 06/17/08 07/01/08 07/15/08 07/29/08 08/12/08 08/26/08 09/09/08 09/23/08 10/07/08 10/21/08 11/04/08 11/18/08 12/02/08 12/16/08 12/30/08 Beginning Balance $ 550,000.00 548,969.16 547,937.13 546,903.91 545,869.49 544,833.88 543,797.07 542,759.07 541,719.87 540,679.47 539,637.87 538,595.07 537,551.07 536,505.86 535,459.45 534,411.83 533,363.00 532,312.96 531,261.71 530,209.24 529,155.56 528,100.66 527,044.55 525,987.22 524,928.67 523,868.90 Payment $ 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 1,665.46 $ Principal 1,030.84 1,032.03 1,033.22 1,034.42 1,035.61 1,036.81 1,038.00 1,039.20 1,040.40 1,041.60 1,042.80 1,044.00 1,045.21 1,046.41 1,047.62 1,048.83 1,050.04 1,051.25 1,052.47 1,053.68 1,054.90 1,056.11 1,057.33 1,058.55 1,059.77 1,061.00 $ Interest 634.62 633.43 632.24 631.04 629.85 628.65 627.46 626.26 625.06 623.86 622.66 621.46 620.25 619.05 617.84 616.63 615.42 614.21 612.99 611.78 610.56 609.35 608.13 606.91 605.69 604.46 Cumulative Principal $ 1,030.84 2,062.87 3,096.09 4,130.51 5,166.12 6,202.93 7,240.93 8,280.13 9,320.53 10,362.13 11,404.93 12,448.93 13,494.14 14,540.55 15,588.17 16,637.00 17,687.04 18,738.29 19,790.76 20,844.44 21,899.34 22,955.45 24,012.78 25,071.33 26,131.10 27,192.10 Cumulative Interest $ 634.62 1,268.05 1,900.29 2,531.33 3,161.18 3,789.83 4,417.29 5,043.55 5,668.61 6,292.47 6,915.13 7,536.59 8,156.84 8,775.89 9,393.73 10,010.36 10,625.78 11,239.99 11,852.98 12,464.76 13,075.32 13,684.67 14,292.80 14,899.71 15,505.40 16,109.86 Ending Balance $ 548,969.16 547,937.13 546,903.91 545,869.49 544,833.88 543,797.07 542,759.07 541,719.87 540,679.47 539,637.87 538,595.07 537,551.07 536,505.86 535,459.45 534,411.83 533,363.00 532,312.96 531,261.71 530,209.24 529,155.56 528,100.66 527,044.55 525,987.22 524,928.67 523,868.90 522,807.90 $ 550,000 3.000% 16 2008 01/01/08 01/15/08 Key Figures Annual loan payments Biweekly payments Interest over term of loan Sum of all payments $ $ $ $ 43,301.96 1,665.46 142,831.36 692,831.36
Payments for Calendar Years after Year 1 Year 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Beginning Balance $ 522,807.90 494,788.51 465,915.94 436,164.58 405,507.68 373,917.69 341,366.20 307,823.96 273,260.80 237,645.65 200,946.49 163,130.33 124,163.17 84,009.98 42,634.65 Payment $ 43,301.96 43,301.96 43,301.96 43,301.96 43,301.96 43,301.96 43,301.96 43,301.96 43,301.96 43,301.96 43,301.96 43,301.96 43,301.96 43,301.96 43,301.96 $ Principal 28,019.39 28,872.57 29,751.36 30,656.90 31,589.99 32,551.49 33,542.24 34,563.16 35,615.15 36,699.16 37,816.16 38,967.16 40,153.19 41,375.33 42,634.65 $ Interest 15,282.57 14,429.39 13,550.60 12,645.06 11,711.97 10,750.47 9,759.72 8,738.80 7,686.81 6,602.80 5,485.80 4,334.80 3,148.77 1,926.63 667.31 Ending Balance $ 494,788.51 465,915.94 436,164.58 405,507.68 373,917.69 341,366.20 307,823.96 273,260.80 237,645.65 200,946.49 163,130.33 124,163.17 84,009.98 42,634.65 -