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
- xls loan calculator worksheet purchase add
- pdf finance charges on simple interest contracts
- pdf hospital outpatient billing and reimbursement guide
- pdf the math behind loan modification chapa home
- pdf how to correct missed or late contributions employee and or
- pdf 360 day interest calculation
- pdf understanding your simple interest auto loan
- pdf calculators graveco software
- pdf understanding how a precomputed loan works
- pdf interest payment on clean claims not paid timely
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