Biweekly Mortgages - Mortgage Professor

Standard MortgageCopyright Jack Guttentag 2003XXXXXXStandard With Extra Payment of 1/12 of Regular PaymentXXXXXXXXXXXXXXXXXXXXXInterest Rate 0.066XXXTerm (Months)300XXXLoan Amount200000XXXMonthly Payment=-PMT($E$12/12,$E$13,$E$14,0,0)=ROUNDUP($E$15,2)XXXTotal Interest=SUM(F381)XXXTotal Interest=SUM(M381)Month of Payoff=$E$13XXXMonth of Payoff=MATCH(0,N22:N382,0)XXXXXXMonthlyLoanCumulativeXXXMonthlyLoanCumulative MonthPaymentInterestPrincipalBalanceInterestXXXMonPaymentInterestPrincipalBalance Interest1=IF(A220,1,0)=A22+1=IF(A230,1,0)=A23+1=IF(A240,1,0)=A24+1=IF(A250,1,0)=A25+1=IF(A260,1,0)=A26+1=IF(A270,1,0)=A27+1=IF(A280,1,0)=A28+1=IF(A290,1,0)=A29+1=IF(A300,1,0)=A30+1=IF(A310,1,0)=A31+1=IF(A320,1,0)=A32+1=IF(A330,1,0)=A33+1=IF(A340,1,0)=A34+1=IF(A350,1,0)=A35+1=IF(A360,1,0)=A36+1=IF(A370,1,0)=A37+1=IF(A380,1,0)=A38+1=IF(A390,1,0)=A39+1=IF(A400,1,0)=A40+1=IF(A410,1,0)=A41+1=IF(A420,1,0)=A42+1=IF(A430,1,0)=A43+1=IF(A440,1,0)=A44+1=IF(A450,1,0)=A45+1=IF(A460,1,0)=A46+1=IF(A470,1,0)=A47+1=IF(A480,1,0)=A48+1=IF(A490,1,0)=A49+1=IF(A500,1,0)=A50+1=IF(A510,1,0)=A51+1=IF(A520,1,0)=A52+1=IF(A530,1,0)=A53+1=IF(A540,1,0)=A54+1=IF(A550,1,0)=A55+1=IF(A560,1,0)=A56+1=IF(A570,1,0)=A57+1=IF(A580,1,0)=A58+1=IF(A590,1,0)=A59+1=IF(A600,1,0)=A60+1=IF(A610,1,0)=A61+1=IF(A620,1,0)=A62+1=IF(A630,1,0)=A63+1=IF(A640,1,0)=A64+1=IF(A650,1,0)=A65+1=IF(A660,1,0)=A66+1=IF(A670,1,0)=A67+1=IF(A680,1,0)=A68+1=IF(A690,1,0)=A69+1=IF(A700,1,0)=A70+1=IF(A710,1,0)=A71+1=IF(A720,1,0)=A72+1=IF(A730,1,0)=A73+1=IF(A740,1,0)=A74+1=IF(A750,1,0)=A75+1=IF(A760,1,0)=A76+1=IF(A770,1,0)=A77+1=IF(A780,1,0)=A78+1=IF(A790,1,0)=A79+1=IF(A800,1,0)=A80+1=IF(A810,1,0)=A81+1=IF(A820,1,0)=A82+1=IF(A830,1,0)=A83+1=IF(A840,1,0)=A84+1=IF(A850,1,0)=A85+1=IF(A860,1,0)=A86+1=IF(A870,1,0)=A87+1=IF(A880,1,0)=A88+1=IF(A890,1,0)=A89+1=IF(A900,1,0)=A90+1=IF(A910,1,0)=A91+1=IF(A920,1,0)=A92+1=IF(A930,1,0)=A93+1=IF(A940,1,0)=A94+1=IF(A950,1,0)=A95+1=IF(A960,1,0)=A96+1=IF(A970,1,0)=A97+1=IF(A980,1,0)=A98+1=IF(A990,1,0)=A99+1=IF(A1000,1,0) ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download