{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Loan schedule"],"not_rendered":{"images":3,"defined_names":23},"read":"whole","date_system":"1900"}

{"sheet":"Loan schedule","index":0,"n_rows":100,"n_cols":12,"rows_kept":100,"merged":[[4,8,4,10],[5,8,5,10],[6,8,6,10],[7,8,7,10],[8,8,8,10],[9,8,9,10],[10,1,10,3],[10,6,10,7],[10,8,10,10]]}
[{"$nulls":11}," "]
[null,null,"Loan amortization schedule"]
[]
[null,"Enter values",{"$nulls":4},"Loan summary"]
[null,"Loan amount",null,null,{"v":5000,"d":"$5,000.00"},null,"Scheduled payment",null,{"$f":"IF(LoanIsGood,-PMT(InterestRate/PaymentsPerYear,ScheduledNumberOfPayments,LoanAmount),\"\")","v":{"v":425.7495209777896,"d":"$425.75"}}]
[null,"Annual interest rate",null,null,{"v":0.04,"d":"4.00%"},null,"Scheduled number of payments",null,{"$f":"IF(LoanIsGood,LoanPeriod*PaymentsPerYear,\"\")","v":12}]
[null,"Loan period in years",null,null,1,null,"Actual number of payments",null,{"$f":"ActualNumberOfPayments","v":10}]
[null,"Number of payments per year",null,null,12,null,"Total early payments",null,{"$f":"TotalEarlyPayments","v":{"v":900,"d":"$900.00"}}]
[null,"Start date of loan",null,null,{"$f":"TODAY()","v":"2023-12-31"},null,"Total interest",null,{"$f":"TotalInterest","v":{"v":89.62148596539345,"d":"$89.62"}}]
[]
[null,"Optional extra payments",null,null,{"v":100,"d":"$100.00"},null,"Lender name",null,"Woodgrove Bank"]
[]
[null,"Payment number","Payment\ndate","Beginning\nbalance","Scheduled payment","Extra\npayment","Total\npayment","Principal","Interest","Ending\nbalance","Cumulative\ninterest"]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":1},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":"2023-12-31"},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":{"v":5000,"d":"$5,000.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":{"v":425.7495209777896,"d":"$425.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":{"v":100,"d":"$100.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":{"v":525.7495209777896,"d":"$525.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":{"v":509.08285431112296,"d":"$509.08"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":{"v":16.666666666666668,"d":"$16.67"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":{"v":4490.917145688877,"d":"$4,490.92"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":{"v":16.666666666666668,"d":"$16.67"}}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":2},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":"2024-01-31"},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":{"v":4490.917145688877,"d":"$4,490.92"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":{"v":425.7495209777896,"d":"$425.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":{"v":100,"d":"$100.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":{"v":525.7495209777896,"d":"$525.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":{"v":510.77979715882674,"d":"$510.78"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":{"v":14.969723818962924,"d":"$14.97"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":{"v":3980.1373485300505,"d":"$3,980.14"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":{"v":31.63639048562959,"d":"$31.64"}}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":3},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":"2024-03-02"},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":{"v":3980.1373485300505,"d":"$3,980.14"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":{"v":425.7495209777896,"d":"$425.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":{"v":100,"d":"$100.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":{"v":525.7495209777896,"d":"$525.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":{"v":512.4823964826895,"d":"$512.48"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":{"v":13.26712449510017,"d":"$13.27"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":{"v":3467.654952047361,"d":"$3,467.65"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":{"v":44.90351498072976,"d":"$44.90"}}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":4},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":"2024-03-31"},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":{"v":3467.654952047361,"d":"$3,467.65"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":{"v":425.7495209777896,"d":"$425.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":{"v":100,"d":"$100.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":{"v":525.7495209777896,"d":"$525.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":{"v":514.1906711376317,"d":"$514.19"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":{"v":11.55884984015787,"d":"$11.56"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":{"v":2953.464280909729,"d":"$2,953.46"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":{"v":56.46236482088763,"d":"$56.46"}}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":5},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":"2024-05-01"},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":{"v":2953.464280909729,"d":"$2,953.46"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":{"v":425.7495209777896,"d":"$425.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":{"v":100,"d":"$100.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":{"v":525.7495209777896,"d":"$525.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":{"v":515.9046400414239,"d":"$515.90"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":{"v":9.844880936365763,"d":"$9.84"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":{"v":2437.559640868305,"d":"$2,437.56"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":{"v":66.3072457572534,"d":"$66.31"}}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":6},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":"2024-05-31"},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":{"v":2437.559640868305,"d":"$2,437.56"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":{"v":425.7495209777896,"d":"$425.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":{"v":100,"d":"$100.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":{"v":525.7495209777896,"d":"$525.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":{"v":517.6243221748953,"d":"$517.62"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":{"v":8.125198802894351,"d":"$8.13"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":{"v":1919.9353186934097,"d":"$1,919.94"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":{"v":74.43244456014774,"d":"$74.43"}}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":7},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":"2024-07-01"},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":{"v":1919.9353186934097,"d":"$1,919.94"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":{"v":425.7495209777896,"d":"$425.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":{"v":100,"d":"$100.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":{"v":525.7495209777896,"d":"$525.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":{"v":519.3497365821449,"d":"$519.35"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":{"v":6.3997843956447,"d":"$6.40"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":{"v":1400.5855821112648,"d":"$1,400.59"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":{"v":80.83222895579244,"d":"$80.83"}}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":8},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":"2024-07-31"},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":{"v":1400.5855821112648,"d":"$1,400.59"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":{"v":425.7495209777896,"d":"$425.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":{"v":100,"d":"$100.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":{"v":525.7495209777896,"d":"$525.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":{"v":521.0809023707521,"d":"$521.08"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":{"v":4.6686186070375495,"d":"$4.67"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":{"v":879.5046797405126,"d":"$879.50"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":{"v":85.50084756282999,"d":"$85.50"}}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":9},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":"2024-08-31"},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":{"v":879.5046797405126,"d":"$879.50"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":{"v":425.7495209777896,"d":"$425.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":{"v":100,"d":"$100.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":{"v":525.7495209777896,"d":"$525.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":{"v":522.817838711988,"d":"$522.82"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":{"v":2.931682265801709,"d":"$2.93"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":{"v":356.68684102852467,"d":"$356.69"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":{"v":88.4325298286317,"d":"$88.43"}}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":10},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":"2024-10-01"},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":{"v":356.68684102852467,"d":"$356.69"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":{"v":425.7495209777896,"d":"$425.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":{"v":356.68684102852467,"d":"$356.69"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":{"v":355.4978848917629,"d":"$355.50"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":{"v":1.188956136761749,"d":"$1.19"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":{"v":89.62148596539345,"d":"$89.62"}}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":11},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":"2024-10-31"},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":{"v":425.7495209777896,"d":"$425.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":{"v":89.62148596539345,"d":"$89.62"}}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":12},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":"2024-12-01"},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":{"v":425.7495209777896,"d":"$425.75"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":{"v":89.62148596539345,"d":"$89.62"}}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]
[null,{"$f":"IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])>ScheduledNumberOfPayments,\"\",ROW()-ROW(PaymentSchedule3[[#Headers],[Payment number]])),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",EOMONTH(LoanStartDate,ROW(PaymentSchedule3[[#This Row],[Payment number]])-ROW(PaymentSchedule3[[#Headers],[Payment number]])-2)+DAY(LoanStartDate),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])=1,LoanAmount,INDEX(PaymentSchedule3[Ending\nbalance],ROW()-ROW(PaymentSchedule3[[#Headers],[Beginning\nbalance]])-1)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",ScheduledPayment,\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+ExtraPayments<PaymentSchedule3[[#This Row],[Beginning\nbalance]],ExtraPayments,IF(PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]]>0,PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Scheduled payment]],0)),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Total\npayment]]-PaymentSchedule3[[#This Row],[Interest]],\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",PaymentSchedule3[[#This Row],[Beginning\nbalance]]*(InterestRate/PaymentsPerYear),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",IF(PaymentSchedule3[[#This Row],[Scheduled payment]]+PaymentSchedule3[[#This Row],[Extra\npayment]]<=PaymentSchedule3[[#This Row],[Beginning\nbalance]],PaymentSchedule3[[#This Row],[Beginning\nbalance]]-PaymentSchedule3[[#This Row],[Principal]],0),\"\")","v":""},{"$f":"IF(PaymentSchedule3[[#This Row],[Payment number]]<>\"\",SUM(INDEX(PaymentSchedule3[Interest],1,1):PaymentSchedule3[[#This Row],[Interest]]),\"\")","v":""}]