XLS Loan Calculator Worksheet - Purchase ADD

PADD Loan Calculator ToolLoan Amount:468000Balloon Payment:0Interest Rate (APR):0.095Payment Rhythm:MonthlyLoan Term in Years:10Payments in Advance / Arrears:Arrears="Payment Amount ("&F8&"):"=IF(Q20>0,"N/A",ROUND(((F5-F6)*F7/(1-(P10/(P10+F7))^(P10*P11/P10))+F6*F7)/P10*P10/(P10+R16*F7),8))=IF(Q20>0,"Please enter / correct all required information in the red boxes!","")Loan Summary:=C11=F11Number of Loan Payments over Loan Term:=IF(Q20>0,"N/A",F9*P10)Total Interest Paid over Loan Term:=IF(Q20>0,"N/A",(O11-O10+1)*(((F5-F6)*F7/(1-(P10/(P10+F7))^(P10*F9))+F6*F7)/P10*IF(R16=1,P10/(P10+F7),1))-F5)Total Amount Paid over Loan Term:=IF(Q20>0,"N/A",F5+F17)=IF(Q11=2,"Time when Principal exceeds Interest Payments:","Time until Principal exceeds Interest Payments:")=IF(Q11=2,TEXT(S16,"MM/YYYY")&" ",TEXT(S50,"# ?/12")&" Years ")This calculator will give you just an estimate of your actual loan payment and amortization schedule. Your actual loan payment amount and amortization schedule will be determined at the time of loan closing, when and if your loan application has been approved.

The PADD does not guarantee the correctness of any results. First 12 Month Amortization ScheduleAnnual Amortization ScheduleMonthPrincipalInterestBalanceYearPrincipalInterestBalanceTotal=SUM(D31:D42)=SUM(E31:E42)=F5-D30Total=SUM(I31:I61)=SUM(J31:J61)=IF(Q20>0,F5,"-")=IF(Q20>0,"",IF($Q$11=2,TEXT(S31,"MM/YYYY"),O31))=IF(C31="","",IF($P$10=$P$5,$F$11-E31,0))=IF(C31="","",IF($P$10=$P$5,F5*$F$7/$P$10,0))=IF(C31="","",F5-D31)=IF(Q20>0,"",IF(Q11=2,YEAR(TODAY()),1))=IF(OR(H31="",O31=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q31)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P31))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H31="",O31=""),"",(Q31-P31+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I31)=IF(OR(H31="",O31=""),"",IF(H31=$P$27,ROUND(F5-I31,2),F5-I31))=IF(C31="","",IF($Q$11=2,TEXT(S32,"MM/YYYY"),C31+1))=IF(C31="","",IF(OR($P$10=$P$5,$P$10=$P$6),$F$11-E32,0))=IF(C31="","",IF(OR($P$10=$P$5,$P$10=$P$6),F31*$F$7/$P$10,0))=IF(C31="","",F31-D32)=IF(OR(H31="",O32=""),"",IF(H31+1>$P$27,"",H31+1))=IF(OR(H32="",O32=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q32)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P32))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H32="",O32=""),"",(Q32-P32+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I32)=IF(OR(H32="",O32=""),"",IF(H32=$P$27,ROUND(K31-I32,2),K31-I32))=IF(C32="","",IF($Q$11=2,TEXT(S33,"MM/YYYY"),C32+1))=IF(C32="","",IF(OR($P$10=$P$5,$P$10=$P$7),$F$11-E33,0))=IF(C32="","",IF(OR($P$10=$P$5,$P$10=$P$7),F32*$F$7/$P$10,0))=IF(C32="","",F32-D33)=IF(OR(H32="",O33=""),"",IF(H32+1>$P$27,"",H32+1))=IF(OR(H33="",O33=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q33)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P33))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H33="",O33=""),"",(Q33-P33+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I33)=IF(OR(H33="",O33=""),"",IF(H33=$P$27,ROUND(K32-I33,2),K32-I33))=IF(C33="","",IF($Q$11=2,TEXT(S34,"MM/YYYY"),C33+1))=IF(C33="","",IF(OR($P$10=$P$5,$P$10=$P$6),$F$11-E34,0))=IF(C33="","",IF(OR($P$10=$P$5,$P$10=$P$6),F33*$F$7/$P$10,0))=IF(C33="","",F33-D34)=IF(OR(H33="",O34=""),"",IF(H33+1>$P$27,"",H33+1))=IF(OR(H34="",O34=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q34)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P34))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H34="",O34=""),"",(Q34-P34+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I34)=IF(OR(H34="",O34=""),"",IF(H34=$P$27,ROUND(K33-I34,2),K33-I34))=IF(C34="","",IF($Q$11=2,TEXT(S35,"MM/YYYY"),C34+1))=IF(C34="","",IF(OR($P$10=$P$5),$F$11-E35,0))=IF(C34="","",IF(OR($P$10=$P$5),F34*$F$7/$P$10,0))=IF(C34="","",F34-D35)=IF(OR(H34="",O35=""),"",IF(H34+1>$P$27,"",H34+1))=IF(OR(H35="",O35=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q35)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P35))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H35="",O35=""),"",(Q35-P35+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I35)=IF(OR(H35="",O35=""),"",IF(H35=$P$27,ROUND(K34-I35,2),K34-I35))=IF(C35="","",IF($Q$11=2,TEXT(S36,"MM/YYYY"),C35+1))=IF(C35="","",IF(OR($P$10=$P$5,$P$10=$P$6,$P$10=$P$7,$P$10=$P$8),$F$11-E36,0))=IF(C35="","",IF(OR($P$10=$P$5,$P$10=$P$6,$P$10=$P$7,$P$10=$P$8),F35*$F$7/$P$10,0))=IF(C35="","",F35-D36)=IF(OR(H35="",O36=""),"",IF(H35+1>$P$27,"",H35+1))=IF(OR(H36="",O36=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q36)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P36))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H36="",O36=""),"",(Q36-P36+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I36)=IF(OR(H36="",O36=""),"",IF(H36=$P$27,ROUND(K35-I36,2),K35-I36))=IF(C36="","",IF($Q$11=2,TEXT(S37,"MM/YYYY"),C36+1))=IF(C36="","",IF(OR($P$10=$P$5),$F$11-E37,0))=IF(C36="","",IF(OR($P$10=$P$5),F36*$F$7/$P$10,0))=IF(C36="","",F36-D37)=IF(OR(H36="",O37=""),"",IF(H36+1>$P$27,"",H36+1))=IF(OR(H37="",O37=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q37)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P37))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H37="",O37=""),"",(Q37-P37+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I37)=IF(OR(H37="",O37=""),"",IF(H37=$P$27,ROUND(K36-I37,2),K36-I37))=IF(C37="","",IF($Q$11=2,TEXT(S38,"MM/YYYY"),C37+1))=IF(C37="","",IF(OR($P$10=$P$5,$P$10=$P$6),$F$11-E38,0))=IF(C37="","",IF(OR($P$10=$P$5,$P$10=$P$6),F37*$F$7/$P$10,0))=IF(C37="","",F37-D38)=IF(OR(H37="",O38=""),"",IF(H37+1>$P$27,"",H37+1))=IF(OR(H38="",O38=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q38)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P38))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H38="",O38=""),"",(Q38-P38+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I38)=IF(OR(H38="",O38=""),"",IF(H38=$P$27,ROUND(K37-I38,2),K37-I38))=IF(C38="","",IF($Q$11=2,TEXT(S39,"MM/YYYY"),C38+1))=IF(C38="","",IF(OR($P$10=$P$5,$P$10=$P$7),$F$11-E39,0))=IF(C38="","",IF(OR($P$10=$P$5,$P$10=$P$7),F38*$F$7/$P$10,0))=IF(C38="","",F38-D39)=IF(OR(H38="",O39=""),"",IF(H38+1>$P$27,"",H38+1))=IF(OR(H39="",O39=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q39)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P39))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H39="",O39=""),"",(Q39-P39+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I39)=IF(OR(H39="",O39=""),"",IF(H39=$P$27,ROUND(K38-I39,2),K38-I39))=IF(C39="","",IF($Q$11=2,TEXT(S40,"MM/YYYY"),C39+1))=IF(C39="","",IF(OR($P$10=$P$5,$P$10=$P$6),$F$11-E40,0))=IF(C39="","",IF(OR($P$10=$P$5,$P$10=$P$6),F39*$F$7/$P$10,0))=IF(C39="","",F39-D40)=IF(OR(H39="",O40=""),"",IF(H39+1>$P$27,"",H39+1))=IF(OR(H40="",O40=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q40)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P40))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H40="",O40=""),"",(Q40-P40+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I40)=IF(OR(H40="",O40=""),"",IF(H40=$P$27,ROUND(K39-I40,2),K39-I40))=IF(C40="","",IF($Q$11=2,TEXT(S41,"MM/YYYY"),C40+1))=IF(C40="","",IF(OR($P$10=$P$5),$F$11-E41,0))=IF(C40="","",IF(OR($P$10=$P$5),F40*$F$7/$P$10,0))=IF(C40="","",F40-D41)=IF(OR(H40="",O41=""),"",IF(H40+1>$P$27,"",H40+1))=IF(OR(H41="",O41=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q41)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P41))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H41="",O41=""),"",(Q41-P41+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I41)=IF(OR(H41="",O41=""),"",IF(H41=$P$27,ROUND(K40-I41,2),K40-I41))=IF(C41="","",IF($Q$11=2,TEXT(S42,"MM/YYYY"),C41+1))=IF(C41="","",IF(OR($P$10=$P$5,$P$10=$P$6,$P$10=$P$7,$P$10=$P$8,$P$10=$P$9),$F$11-E42,0))=IF(C41="","",IF(OR($P$10=$P$5,$P$10=$P$6,$P$10=$P$7,$P$10=$P$8,$P$10=$P$9),F41*$F$7/$P$10,0))=IF(C41="","",F41-D42)=IF(OR(H41="",O42=""),"",IF(H41+1>$P$27,"",H41+1))=IF(OR(H42="",O42=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q42)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P42))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H42="",O42=""),"",(Q42-P42+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I42)=IF(OR(H42="",O42=""),"",IF(H42=$P$27,ROUND(K41-I42,2),K41-I42))=IF(OR(H42="",O43=""),"",IF(H42+1>$P$27,"",H42+1))=IF(OR(H43="",O43=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q43)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P43))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H43="",O43=""),"",(Q43-P43+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I43)=IF(OR(H43="",O43=""),"",IF(H43=$P$27,ROUND(K42-I43,2),K42-I43))=IF(OR(H43="",O44=""),"",IF(H43+1>$P$27,"",H43+1))=IF(OR(H44="",O44=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q44)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P44))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H44="",O44=""),"",(Q44-P44+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I44)=IF(OR(H44="",O44=""),"",IF(H44=$P$27,ROUND(K43-I44,2),K43-I44))=IF(OR(H44="",O45=""),"",IF(H44+1>$P$27,"",H44+1))=IF(OR(H45="",O45=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q45)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P45))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H45="",O45=""),"",(Q45-P45+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I45)=IF(OR(H45="",O45=""),"",IF(H45=$P$27,ROUND(K44-I45,2),K44-I45))=IF(OR(H45="",O46=""),"",IF(H45+1>$P$27,"",H45+1))=IF(OR(H46="",O46=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q46)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P46))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H46="",O46=""),"",(Q46-P46+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I46)=IF(OR(H46="",O46=""),"",IF(H46=$P$27,ROUND(K45-I46,2),K45-I46))=IF(OR(H46="",O47=""),"",IF(H46+1>$P$27,"",H46+1))=IF(OR(H47="",O47=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q47)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P47))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H47="",O47=""),"",(Q47-P47+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I47)=IF(OR(H47="",O47=""),"",IF(H47=$P$27,ROUND(K46-I47,2),K46-I47))=IF(OR(H47="",O48=""),"",IF(H47+1>$P$27,"",H47+1))=IF(OR(H48="",O48=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q48)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P48))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H48="",O48=""),"",(Q48-P48+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I48)=IF(OR(H48="",O48=""),"",IF(H48=$P$27,ROUND(K47-I48,2),K47-I48))=IF(OR(H48="",O49=""),"",IF(H48+1>$P$27,"",H48+1))=IF(OR(H49="",O49=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q49)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P49))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H49="",O49=""),"",(Q49-P49+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I49)=IF(OR(H49="",O49=""),"",IF(H49=$P$27,ROUND(K48-I49,2),K48-I49))=IF(OR(H49="",O50=""),"",IF(H49+1>$P$27,"",H49+1))=IF(OR(H50="",O50=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q50)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P50))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H50="",O50=""),"",(Q50-P50+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I50)=IF(OR(H50="",O50=""),"",IF(H50=$P$27,ROUND(K49-I50,2),K49-I50))=IF(OR(H50="",O51=""),"",IF(H50+1>$P$27,"",H50+1))=IF(OR(H51="",O51=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q51)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P51))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H51="",O51=""),"",(Q51-P51+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I51)=IF(OR(H51="",O51=""),"",IF(H51=$P$27,ROUND(K50-I51,2),K50-I51))=IF(OR(H51="",O52=""),"",IF(H51+1>$P$27,"",H51+1))=IF(OR(H52="",O52=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q52)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P52))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H52="",O52=""),"",(Q52-P52+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I52)=IF(OR(H52="",O52=""),"",IF(H52=$P$27,ROUND(K51-I52,2),K51-I52))=IF(OR(H52="",O53=""),"",IF(H52+1>$P$27,"",H52+1))=IF(OR(H53="",O53=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q53)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P53))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H53="",O53=""),"",(Q53-P53+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I53)=IF(OR(H53="",O53=""),"",IF(H53=$P$27,ROUND(K52-I53,2),K52-I53))=IF(OR(H53="",O54=""),"",IF(H53+1>$P$27,"",H53+1))=IF(OR(H54="",O54=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q54)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P54))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H54="",O54=""),"",(Q54-P54+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I54)=IF(OR(H54="",O54=""),"",IF(H54=$P$27,ROUND(K53-I54,2),K53-I54))=IF(OR(H54="",O55=""),"",IF(H54+1>$P$27,"",H54+1))=IF(OR(H55="",O55=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q55)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P55))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H55="",O55=""),"",(Q55-P55+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I55)=IF(OR(H55="",O55=""),"",IF(H55=$P$27,ROUND(K54-I55,2),K54-I55))=IF(OR(H55="",O56=""),"",IF(H55+1>$P$27,"",H55+1))=IF(OR(H56="",O56=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q56)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P56))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H56="",O56=""),"",(Q56-P56+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I56)=IF(OR(H56="",O56=""),"",IF(H56=$P$27,ROUND(K55-I56,2),K55-I56))=IF(OR(H56="",O57=""),"",IF(H56+1>$P$27,"",H56+1))=IF(OR(H57="",O57=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q57)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P57))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H57="",O57=""),"",(Q57-P57+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I57)=IF(OR(H57="",O57=""),"",IF(H57=$P$27,ROUND(K56-I57,2),K56-I57))=IF(OR(H57="",O58=""),"",IF(H57+1>$P$27,"",H57+1))=IF(OR(H58="",O58=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q58)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P58))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H58="",O58=""),"",(Q58-P58+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I58)=IF(OR(H58="",O58=""),"",IF(H58=$P$27,ROUND(K57-I58,2),K57-I58))=IF(OR(H58="",O59=""),"",IF(H58+1>$P$27,"",H58+1))=IF(OR(H59="",O59=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q59)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P59))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H59="",O59=""),"",(Q59-P59+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I59)=IF(OR(H59="",O59=""),"",IF(H59=$P$27,ROUND(K58-I59,2),K58-I59))=IF(OR(H59="",O60=""),"",IF(H59+1>$P$27,"",H59+1))=IF(OR(H60="",O60=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q60)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P60))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H60="",O60=""),"",(Q60-P60+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I60)=IF(OR(H60="",O60=""),"",IF(H60=$P$27,ROUND(K59-I60,2),K59-I60))=IF(OR(H60="",O61=""),"",IF(H60+1>$P$27,"",H60+1))=IF(OR(H61="",O61=""),"",($F$5-$F$6)*(1/(1+$F$7/$P$10)^($F$9*$P$10-Q61)-1/(1+$F$7/$P$10)^($F$9*$P$10+1-P61))/(1-1/(1+$F$7/$P$10)^($F$9*$P$10)))=IF(OR(H61="",O61=""),"",(Q61-P61+1)*((($F$5-$F$6)*$F$7/(1-($P$10/($P$10+$F$7))^($P$10*$F$9))+$F$6*$F$7)/$P$10*IF($R$16=1,$P$10/($P$10+$F$7),1))-I61)=IF(OR(H61="",O61=""),"",IF(H61=$P$27,ROUND(K60-I61,2),K60-I61)) ................
................

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

Google Online Preview   Download