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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- pdf equivalent payments compound interest
- pdf formula sheet for financial mathematics george brown college
- pdf understanding your simple interest auto loan
- pdf 8 3 simple interest installment loans hitchens
- pdf loan interest calculation 360 365 daily interest cu answers
- pdf hp 12c loan amortizations amortization the hp12c amortization
- pdf single payment loan
- pdf 360 day interest calculation cu answers
- pdf interest rate formulas new mexico state university
- pdf long term loan repayment methods extension
Related searches
- simple loan calculator amortization schedule
- free budget calculator worksheet pdf
- auto loan calculator payment calculator e
- auto loan calculator payment calculator ex
- car calculator loan calculator georgia
- auto loan calculator payment calculator excel
- maximum va loan amount worksheet fillable
- free budget calculator worksheet excel
- auto loan calculator payment calculator free
- mortgage loan comparison worksheet template
- va entitlement calculator worksheet 2020
- va loan comparison worksheet form