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 07/07/05 07/21/05 08/04/05 08/18/05 09/01/05 09/15/05 09/29/05 10/13/05 10/27/05 11/10/05 11/24/05 12/08/05 12/22/05 01/05/06 01/19/06 02/02/06 02/16/06 03/02/06 03/16/06 03/30/06 04/13/06 04/27/06 05/11/06 05/25/06 06/08/06 06/22/06 Beginning Cumulative Cumulative Ending Payment Principal Interest Balance Principal Interest Balance $ 654,645.00 $ 2,085.44 $ 1,330.08 $ 755.36 $ 1,330.08 $ 755.36 $ 653,314.92 653,314.92 2,085.44 1,331.62 753.82 2,661.70 1,509.18 651,983.30 651,983.30 2,085.44 1,333.15 752.29 3,994.85 2,261.47 650,650.15 650,650.15 2,085.44 1,334.69 750.75 5,329.54 3,012.22 649,315.46 649,315.46 2,085.44 1,336.23 749.21 6,665.77 3,761.43 647,979.23 647,979.23 2,085.44 1,337.77 747.67 8,003.54 4,509.10 646,641.46 646,641.46 2,085.44 1,339.32 746.12 9,342.86 5,255.22 645,302.14 645,302.14 2,085.44 1,340.86 744.58 10,683.72 5,999.80 643,961.28 643,961.28 2,085.44 1,342.41 743.03 12,026.13 6,742.83 642,618.87 642,618.87 2,085.44 1,343.96 741.48 13,370.09 7,484.31 641,274.91 641,274.91 2,085.44 1,345.51 739.93 14,715.60 8,224.24 639,929.40 639,929.40 2,085.44 1,347.06 738.38 16,062.66 8,962.62 638,582.34 638,582.34 2,085.44 1,348.61 736.83 17,411.27 9,699.45 637,233.73 637,233.73 2,085.44 1,350.17 735.27 18,761.44 10,434.72 635,883.56 635,883.56 2,085.44 1,351.73 733.71 20,113.17 11,168.43 634,531.83 634,531.83 2,085.44 1,353.29 732.15 21,466.46 11,900.58 633,178.54 633,178.54 2,085.44 1,354.85 730.59 22,821.31 12,631.17 631,823.69 631,823.69 2,085.44 1,356.41 729.03 24,177.72 13,360.20 630,467.28 630,467.28 2,085.44 1,357.98 727.46 25,535.70 14,087.66 629,109.30 629,109.30 2,085.44 1,359.54 725.90 26,895.24 14,813.56 627,749.76 627,749.76 2,085.44 1,361.11 724.33 28,256.35 15,537.89 626,388.65 626,388.65 2,085.44 1,362.68 722.76 29,619.03 16,260.65 625,025.97 625,025.97 2,085.44 1,364.26 721.18 30,983.29 16,981.83 623,661.71 623,661.71 2,085.44 1,365.83 719.61 32,349.12 17,701.44 622,295.88 622,295.88 2,085.44 1,367.41 718.03 33,716.53 18,419.47 620,928.47 620,928.47 2,085.44 1,368.98 716.46 35,085.51 19,135.93 619,559.49 $ Key Figures 654,645 Annual loan payments 3.000% Biweekly payments 15 Interest over term of loan 2005 Sum of all payments 06/23/05 07/07/05 $ $ $ $ 54,221.44 2,085.44 158,676.60 813,321.60
Payments for Calendar Years after Year 1 Year 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Beginning Ending Payment Principal Interest Balance Balance $ 637,233.73 $ 54,221.44 $ 35,615.32 $ 18,606.12 $ 601,618.41 601,618.41 54,221.44 36,699.46 17,521.98 564,918.95 564,918.95 54,221.44 37,816.47 16,404.97 527,102.48 527,102.48 54,221.44 38,967.48 15,253.96 488,135.00 488,135.00 54,221.44 40,153.52 14,067.92 447,981.48 447,981.48 54,221.44 41,375.66 12,845.78 406,605.82 406,605.82 54,221.44 42,635.00 11,586.44 363,970.82 363,970.82 54,221.44 43,932.68 10,288.76 320,038.14 320,038.14 54,221.44 45,269.83 8,951.61 274,768.31 274,768.31 54,221.44 46,647.71 7,573.73 228,120.60 228,120.60 54,221.44 48,067.50 6,153.94 180,053.10 180,053.10 54,221.44 49,530.53 4,690.91 130,522.57 130,522.57 54,221.44 51,038.06 3,183.38 79,484.51 79,484.51 54,221.44 52,591.50 1,629.94 26,893.01 26,893.01 27,110.72 26,893.01 217.71 -