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

{"sheet":"Loan analysis","index":0,"n_rows":66,"n_cols":12,"rows_kept":66,"merged":[[0,0,0,10],[1,1,1,9],[1,11,15,11],[7,1,7,9]]}
["LOAN ANALYSIS WORKSHEET"]
[null,"LOAN ANALYSIS",{"$nulls":9},"Rate slicer to filter table data based on Rates is in this cell."]
[null,null,"INTEREST RATE",{"v":0.05,"d":"5.00%"},{"$nulls":3},"MONTHLY PAYMENT",{"$f":"IFERROR(PMT(InterestRate/12,LoanYears*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":105.62540936671392,"d":"$105.63"}}]
[null,null,"YEARS OF LOAN",10,{"$nulls":3},"TOTAL PAYMENT",{"$f":"IFERROR(MonthlyPayments*LoanYears*12, \"\")","v":{"v":12675.049124005669,"d":"$12,675.05"}}]
[null,null,"LOAN AMOUNT",{"v":10000,"d":"$10,000.00"},{"$nulls":3},"TOTAL INTEREST",{"$f":"IFERROR(TotalPayments-LoanAmount, \"\")","v":{"v":2675.049124005669,"d":"$2,675.05"}}]
[null,null,"PAYMENTS DUE","Start of period"]
[]
[null,"YEARS"]
[null,"RATE","3","5","10","12","15","20","25","30"]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.02,"d":"2.00%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":285.9492053157043,"d":"$285.95"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":174.98595727032657,"d":"$174.99"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":91.86035325380436,"d":"$91.86"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":78.0383053428547,"d":"$78.04"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":64.24379706067144,"d":"$64.24"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":50.5041599046706,"d":"$50.50"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":42.31490901604726,"d":"$42.31"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":36.90044652467426,"d":"$36.90"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.022500000000000003,"d":"2.25%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":286.98038692573107,"d":"$286.98"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":176.04336626960756,"d":"$176.04"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":92.96306607183222,"d":"$92.96"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":79.15707849309105,"d":"$79.16"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":65.38587846346418,"d":"$65.39"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":51.683921205444236,"d":"$51.68"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":43.53144804681021,"d":"$43.53"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":38.15307321516957,"d":"$38.15"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.025,"d":"2.50%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":288.01372805170166,"d":"$288.01"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":177.1046480380568,"d":"$177.10"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":94.0739143823347,"d":"$94.07"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":80.28567655482807,"d":"$80.29"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":66.54029528572006,"d":"$66.54"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":52.880122381594674,"d":"$52.88"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":44.76840589537997,"d":"$44.77"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":39.429944164763285,"d":"$39.43"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.027500000000000004,"d":"2.75%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":289.04922626449695,"d":"$289.05"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":178.16979754108667,"d":"$178.17"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":95.1928802805532,"d":"$95.19"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":81.42407270166504,"d":"$81.42"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":67.7070018633307,"d":"$67.71"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":54.09266830400493,"d":"$54.09"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":46.025610167616904,"d":"$46.03"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":40.73077673652979,"d":"$40.73"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.030000000000000002,"d":"3.00%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":290.0868791087514,"d":"$290.09"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":179.23880961658992,"d":"$179.24"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":96.31994483629877,"d":"$96.32"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":82.5722383489316,"d":"$82.57"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":68.88594915491173,"d":"$68.89"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":55.321456145028634,"d":"$55.32"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":47.302874200266636,"d":"$47.30"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":42.05526520992024,"d":"$42.06"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.0325,"d":"3.25%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":291.12668410293776,"d":"$291.13"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":180.31167897543517,"d":"$180.31"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":97.45508810157712,"d":"$97.46"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":83.73014317048559,"d":"$83.73"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":70.07708478735586,"d":"$70.08"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":56.5663755489894,"d":"$56.57"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":48.59999754066054,"d":"$48.60"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":43.40308189377575,"d":"$43.40"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.035,"d":"3.50%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":292.16863873945135,"d":"$292.17"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":181.38840020197492,"d":"$181.39"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":98.59828911864064,"d":"$98.60"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":84.89775511655137,"d":"$84.90"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":71.2803531044296,"d":"$71.28"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":57.827308814267724,"d":"$57.83"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":49.91676645711603,"d":"$49.92"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":44.77387830250016,"d":"$44.77"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.037500000000000006,"d":"3.75%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":293.21274048469655,"d":"$293.21"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":182.46896775456702,"d":"$182.47"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":99.74952592846124,"d":"$99.75"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":86.07504043257859,"d":"$86.08"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":72.49569521832166,"d":"$72.50"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":59.104131086377315,"d":"$59.10"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":51.25295447749337,"d":"$51.25"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":46.16728638725261,"d":"$46.17"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.04,"d":"4.00%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":294.2589867791729,"d":"$294.26"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":183.5533759661098,"d":"$183.55"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":100.9087755796161,"d":"$100.91"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":87.26196367909674,"d":"$87.26"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":73.72304906404685,"d":"$73.72"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":60.39671056140385,"d":"$60.40"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":52.60832295326684,"d":"$52.61"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":47.58291981383317,"d":"$47.58"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.0425,"d":"4.25%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":295.3073750375634,"d":"$295.31"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":184.64161904458928,"d":"$184.64"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":102.07601413757926,"d":"$102.08"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":88.45848775254319,"d":"$88.46"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":74.96234945660363,"d":"$74.96"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":61.70490869915229,"d":"$61.70"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":53.982621646391344,"d":"$53.98"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":49.02037527883583,"d":"$49.02"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.045,"d":"4.50%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":296.3579026488227,"d":"$296.36"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":185.73369107364033,"d":"$185.73"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":103.25121669441126,"d":"$103.25"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":89.66457390703825,"d":"$89.66"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":76.21352815077974,"d":"$76.21"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":63.02858044532627,"d":"$63.03"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":55.37558933618819,"d":"$55.38"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":50.47923385562945,"d":"$50.48"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.0475,"d":"4.75%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":297.4105669762669,"d":"$297.41"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":186.82958601312,"d":"$186.83"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":104.43435737883848,"d":"$104.43"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":90.88018177708229,"d":"$90.88"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":77.4765139034964,"d":"$77.48"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":64.3675744620434,"d":"$64.37"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":56.786954443436954,"d":"$56.79"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":51.959062361795645,"d":"$51.96"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.05,"d":"5.00%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":298.46536535766455,"d":"$298.47"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":187.92929769969396,"d":"$187.93"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":105.62540936671392,"d":"$105.63"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":92.10526940114713,"d":"$92.11"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":78.75123253857704,"d":"$78.75"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":65.72173336597417,"d":"$65.72"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":58.21643566884439,"d":"$58.22"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":53.459414739798085,"d":"$53.46"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.052500000000000005,"d":"5.25%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":299.52229510532624,"d":"$299.52"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":189.03281984743478,"d":"$189.03"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":106.82434489185054,"d":"$106.82"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":93.3397932461341,"d":"$93.34"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":80.03760701382407,"d":"$80.04"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":67.09089397337966,"d":"$67.09"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":59.66374264306418,"d":"$59.66"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":54.97983344287724,"d":"$54.98"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.055,"d":"5.50%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":300.5813535061994,"d":"$300.58"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":190.14014604843376,"d":"$190.14"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":108.03113525721847,"d":"$108.03"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":94.58370823267036,"d":"$94.58"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":81.33555749028346,"d":"$81.34"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":68.47488755131367,"d":"$68.47"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":61.12857658546365,"d":"$61.13"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":56.51985081844906,"d":"$56.52"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.0575,"d":"5.75%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":301.6425378219598,"d":"$301.64"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":191.25126977342427,"d":"$191.25"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":109.24575084649672,"d":"$109.25"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":95.83696776121339,"d":"$95.84"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":82.64500140357447,"d":"$82.65"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":69.87354007424965,"d":"$69.87"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":62.610630968873295,"d":"$62.61"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":58.07899048163082,"d":"$58.08"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.060000000000000005,"d":"6.00%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":302.7058452891056,"d":"$302.71"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":192.36618437241705,"d":"$192.37"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":110.46816113596958,"d":"$110.47"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":97.09952373893319,"d":"$97.10"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":83.96585353715933,"d":"$83.97"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":71.28667248538953,"d":"$71.29"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":64.10959218761279,"d":"$64.11"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":59.65676867191565,"d":"$59.66"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.0625,"d":"6.25%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":303.7712731190534,"d":"$303.77"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":193.48488307534896,"d":"$193.48"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":111.6983347067591,"d":"$111.70"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":98.37132660734247,"d":"$98.37"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":85.29802609742599,"d":"$85.30"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":72.71410096191359,"d":"$72.71"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":65.62514022615974,"d":"$65.63"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":61.25269558645968,"d":"$61.25"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.065,"d":"6.50%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":304.8388184982324,"d":"$304.84"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":194.6073589927414,"d":"$194.61"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":112.93623925738187,"d":"$112.94"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":99.65232537064145,"d":"$99.65"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":86.64142879045453,"d":"$86.64"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":74.15563718343277,"d":"$74.16"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":67.15694932591525,"d":"$67.16"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":62.86627668392512,"d":"$62.87"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.0675,"d":"6.75%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":305.9084785881832,"d":"$305.91"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":195.7336051163731,"d":"$195.73"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":114.18184161662232,"d":"$114.18"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":100.94246762474683,"d":"$100.94"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":87.99596890033773,"d":"$88.00"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":75.61108860291417,"d":"$75.61"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":68.70468864762181,"d":"$68.70"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":64.49701395333402,"d":"$64.50"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.07,"d":"7.00%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":306.9802505256531,"d":"$306.98"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":196.86361431996224,"d":"$196.86"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":115.43510775670993,"d":"$115.44"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":102.24169958697078,"d":"$102.24"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":89.36155136892397,"d":"$89.36"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":77.08025871935787,"d":"$77.08"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":70.26802292710109,"d":"$70.27"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":66.14440714291797,"d":"$66.14"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.07250000000000001,"d":"7.25%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":308.05413142269634,"d":"$308.05"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":197.99737935986155,"d":"$198.00"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":116.6960028067916,"d":"$116.70"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":103.54996612631801,"d":"$103.55"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":90.73807887685098,"d":"$90.74"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":78.5629473515189,"d":"$78.56"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":71.84661312210385,"d":"$71.85"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":67.80795494449619,"d":"$67.81"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.07500000000000001,"d":"7.50%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":309.130118366772,"d":"$309.13"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":199.13489287576414,"d":"$199.13"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":117.96449106668744,"d":"$117.96"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":104.86721079436661,"d":"$104.87"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":92.12545192573795,"d":"$92.13"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":80.05895091198086,"d":"$80.06"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":73.44011704819474,"d":"$73.44"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":69.48715612946876,"d":"$69.49"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.0775,"d":"7.75%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":310.20820842084464,"d":"$310.21"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":200.2761473914207,"d":"$200.28"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":119.24053602091966,"d":"$119.24"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":106.19337585669896,"d":"$106.19"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":93.52356892140419,"d":"$93.52"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":81.56806268090793,"d":"$81.57"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":75.04819000173603,"d":"$75.05"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":71.18151063306577,"d":"$71.18"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.08,"d":"8.00%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":311.28839862348525,"d":"$311.29"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":201.42113531536768,"d":"$201.42"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":120.52410035300356,"d":"$120.52"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":107.52840232484915,"d":"$107.53"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":94.93232625798193,"d":"$94.93"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":83.09007307882081,"d":"$83.09"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":76.6704853681791,"d":"$76.67"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":72.89052058404398,"d":"$72.89"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.0825,"d":"8.25%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":312.37068598897275,"d":"$312.37"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":202.5698489416666,"d":"$202.57"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":121.81514595998924,"d":"$121.82"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":108.87222998873155,"d":"$108.87"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":96.35161840279233,"d":"$96.35"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":84.62476993776498,"d":"$84.62"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":78.30665521402236,"d":"$78.31"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":74.61369127755917,"d":"$74.61"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.085,"d":"8.50%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":313.45506750739656,"d":"$313.46"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":203.7222804506537,"d":"$203.72"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":123.11363396724316,"d":"$123.11"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":110.22479744951684,"d":"$110.22"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":97.78133798185452,"d":"$97.78"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":86.17193877026403,"d":"$86.17"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":79.95635086094808,"d":"$79.96"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":76.35053208946631,"d":"$76.35"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.08750000000000001,"d":"8.75%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":314.54154014475984,"d":"$314.54"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":204.8784219097006,"d":"$204.88"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":124.41952474345811,"d":"$124.42"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":111.5860421529205,"d":"$111.59"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":99.22137586589827,"d":"$99.22"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":87.73136303547648,"d":"$87.73"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":81.61922344080483,"d":"$81.62"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":78.1005573308001,"d":"$78.10"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.09,"d":"9.00%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":315.6301008430837,"d":"$315.63"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":206.03826527398516,"d":"$206.04"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":125.73277791588036,"d":"$125.73"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":112.95590042286908,"d":"$112.96"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":100.67162125675284,"d":"$100.67"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":89.30282440200227,"d":"$89.30"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":83.29492443025741,"d":"$83.29"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":79.86328704166577,"d":"$79.86"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.0925,"d":"9.25%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":316.72074652051236,"d":"$316.72"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":207.20180238727306,"d":"$207.20"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":127.05335238574207,"d":"$127.05"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":114.33430749550973,"d":"$114.33"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":102.13196177398673,"d":"$102.13"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":90.8861030068138,"d":"$90.89"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":84.98310616408062,"d":"$84.98"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":81.63824772422008,"d":"$81.64"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.095,"d":"9.50%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":317.8134740714181,"d":"$317.81"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":208.36902498270865,"d":"$208.37"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":128.3812063438879,"d":"$128.38"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":115.72119755352816,"d":"$115.72"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":103.60228354167373,"d":"$103.60"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":92.48097770981576,"d":"$92.48"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":86.68342232622483,"d":"$86.68"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":83.42497301484066,"d":"$83.42"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.0975,"d":"9.75%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":318.9082803665087,"d":"$318.91"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":209.5399246836167,"d":"$209.54"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":129.71629728658425,"d":"$129.72"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":117.11650376074061,"d":"$117.12"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":105.08247127516486,"d":"$105.08"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":94.08722634357015,"d":"$94.09"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":88.39552841793136,"d":"$88.40"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":85.22300429597031,"d":"$85.22"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.1,"d":"10.00%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":320.00516225293376,"d":"$320.01"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":210.71449300431348,"d":"$210.71"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":131.05858203149916,"d":"$131.06"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":118.52015829692567,"d":"$118.52"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":106.57240836774706,"d":"$106.57"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":95.70462595775284,"d":"$95.70"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":90.11908220232004,"d":"$90.12"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":87.03189124847592,"d":"$87.03"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.10250000000000001,"d":"10.25%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":321.1041165543931,"d":"$321.10"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":211.89272135092753,"d":"$211.89"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":132.4080167338417,"d":"$132.41"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":119.93209239286139,"d":"$119.93"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":108.07197697707208,"d":"$108.07"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":97.33295305794117,"d":"$97.33"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":91.85374412501193,"d":"$91.85"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":88.85119234568077,"d":"$88.85"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.10500000000000001,"d":"10.50%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":322.20514007124586,"d":"$322.21"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":213.0746010222301,"d":"$213.07"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":133.7645569026488,"d":"$133.76"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":121.35223636553422,"d":"$121.35"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":109.58105811124365,"d":"$109.58"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":98.97198383836383,"d":"$98.97"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":93.59917771048471,"d":"$93.60"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":90.68047529051513,"d":"$90.68"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.1075,"d":"10.75%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":323.3082295806191,"d":"$323.31"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":214.26012321047475,"d":"$214.26"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":135.12815741720826,"d":"$135.13"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":122.78051965348615,"d":"$122.78"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":111.09953171445169,"d":"$111.10"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":100.62149440827733,"d":"$100.62"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":95.35504993398706,"d":"$95.36"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":92.51931739747884,"d":"$92.52"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.11,"d":"11.00%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":324.41338183651897,"d":"$324.41"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":215.44927900224585,"d":"$215.45"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":136.4987725436061,"d":"$136.50"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":124.2168708522664,"d":"$124.22"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":112.62727675204845,"d":"$112.63"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":102.2812610116654,"d":"$102.28"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":97.12103156895945,"d":"$97.12"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":94.3673059213278,"d":"$94.37"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.1125,"d":"11.25%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":325.52059356994073,"d":"$325.52"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":216.64205937931695,"d":"$216.64"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":137.87635595138676,"d":"$137.88"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":125.66121774995565,"d":"$125.66"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":114.16417129496233,"d":"$114.16"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":103.9510602399904,"d":"$103.95"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":98.8967975100235,"d":"$98.90"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":96.22403833457855,"d":"$96.22"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.115,"d":"11.50%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":326.6298614889815,"d":"$326.63"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":217.83845521951693,"d":"$217.84"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":139.2608607303148,"d":"$139.26"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":127.1134873627299,"d":"$127.11"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":115.71009260335104,"d":"$115.71"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":105.63066923775739,"d":"$105.63"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":100.68202707170923,"d":"$100.68"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":98.08912255607758,"d":"$98.09"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.11750000000000001,"d":"11.75%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":327.74118227895116,"d":"$327.74"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":219.03845729760536,"d":"$219.04"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":140.65223940722603,"d":"$140.65"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":128.57360597043194,"d":"$128.57"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":117.26491720939782,"d":"$117.26"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":107.31986590068385,"d":"$107.32"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":102.47640426318773,"d":"$102.48"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":99.96217713300346,"d":"$99.96"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.12000000000000001,"d":"12.00%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":328.85455260248705,"d":"$328.85"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":220.24205628615618,"d":"$220.24"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":142.0504439629578,"d":"$142.05"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":130.04149915212,"d":"$130.04"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":118.82852099915976,"d":"$118.83"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":109.01842906629801,"d":"$109.02"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":104.27961803936911,"d":"$104.28"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":101.84283137876282,"d":"$101.84"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.1225,"d":"12.25%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":329.96996909966674,"d":"$329.97"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":221.44924275644985,"d":"$221.45"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":143.45542584934563,"d":"$143.46"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":131.5170918215616,"d":"$131.52"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":120.40077929338015,"d":"$120.40"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":110.72613869681948,"d":"$110.73"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":106.09136252880742,"d":"$106.09"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":103.73072546930672,"d":"$103.73"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.125,"d":"12.50%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":331.0874283881223,"d":"$331.09"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":222.66000717937325,"d":"$222.66"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":144.86713600627613,"d":"$144.87"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":133.00030826264344,"d":"$133.00"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":121.9815669271816,"d":"$121.98"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":112.44277605420564,"d":"$112.44"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":107.91133723893016,"d":"$107.91"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":105.6255105004364,"d":"$105.63"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.1275,"d":"12.75%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":332.20692706315657,"d":"$332.21"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":223.87433992632825,"d":"$223.87"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":146.285524878785,"d":"$146.29"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":134.49107216466734,"d":"$134.49"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":123.57075832856101,"d":"$123.57"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":114.168123867275,"d":"$114.17"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":109.73924723917668,"d":"$109.74"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":107.52684850868467,"d":"$107.53"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.13,"d":"13.00%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":333.32846169785756,"d":"$333.33"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":225.09223127014695,"d":"$225.09"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":147.7105424341878,"d":"$147.71"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":135.98930665750333,"d":"$135.99"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":125.16822759561032,"d":"$125.17"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":115.90196649084618,"d":"$115.90"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":111.57480332268867,"d":"$111.57"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":109.43441245835723,"d":"$109.43"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.1325,"d":"13.25%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":334.45202884321606,"d":"$334.45"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":226.3136713860157,"d":"$226.31"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":149.14213817923465,"d":"$149.14"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":137.49493434657197,"d":"$137.49"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":126.77384857239383,"d":"$126.77"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":117.64409005685862,"d":"$117.64"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":113.41772214724854,"d":"$113.42"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":111.34788619729831,"d":"$111.35"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.135,"d":"13.50%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":335.5776250282421,"d":"$335.58"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":227.53865035240574,"d":"$227.54"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":150.5802611772761,"d":"$150.58"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":139.00787734762827,"d":"$139.01"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":128.3874949234142,"d":"$128.39"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":119.39428261746444,"d":"$119.39"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":115.26772635620402,"d":"$115.27"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":113.26696438390547,"d":"$113.27"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.1375,"d":"13.75%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":336.7052467600828,"d":"$336.71"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":228.76715815201143,"d":"$228.77"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":152.02486006543077,"d":"$152.02"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":140.52805732132072,"d":"$140.53"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":130.00904020660613,"d":"$130.01"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":121.1523342801065,"d":"$121.15"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":117.12454468015545,"d":"$117.12"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":115.19135238786798,"d":"$115.19"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.14,"d":"14.00%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":337.8348905241412,"d":"$337.83"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":229.9991846726955,"d":"$230.00"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":153.4758830717441,"d":"$153.48"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":142.05539550749933,"d":"$142.06"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":131.63835794479937,"d":"$131.64"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":122.91803733461997,"d":"$122.92"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":118.98791202021243,"d":"$118.99"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":117.12076616703801,"d":"$117.12"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.14250000000000002,"d":"14.25%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":338.9665527841947,"d":"$338.97"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":231.23471970844096,"d":"$231.23"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":154.9332780323271,"d":"$154.93"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":143.58981275924765,"d":"$143.59"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":133.27532169559802,"d":"$133.28"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":124.69118637241462,"d":"$124.69"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":120.8575695136488,"d":"$120.86"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":119.05493212276738,"d":"$119.05"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.14500000000000002,"d":"14.50%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":340.1002299825154,"d":"$340.10"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":232.47375296031026,"d":"$232.47"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":156.39699240846633,"d":"$156.40"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":145.13122957661466,"d":"$145.13"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":134.91980511962703,"d":"$134.92"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":126.47157839781806,"d":"$126.47"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":122.73326458280418,"d":"$122.73"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":120.99358693595931,"d":"$120.99"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.14750000000000002,"d":"14.75%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":341.2359185399892,"d":"$341.24"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":233.71627403741022,"d":"$233.72"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":157.86697330369327,"d":"$157.87"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":146.6795661400227,"d":"$146.68"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":136.57168204710075,"d":"$136.57"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":128.25901293167556,"d":"$128.26"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":124.61475096809038,"d":"$124.61"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":122.93647738599182,"d":"$122.94"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.15000000000000002,"d":"15.00%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":342.3736148562384,"d":"$342.37"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":234.96227245786412,"d":"$234.96"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":159.3431674808055,"d":"$159.34"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":148.23474234332937,"d":"$148.23"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":138.23082654267387,"d":"$138.23"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":130.05329210732225,"d":"$130.05"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":126.50178874596895,"d":"$126.50"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":124.88336015457222,"d":"$124.88"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.15250000000000002,"d":"15.25%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":343.5133153097413,"d":"$343.51"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":236.21173764978897,"d":"$236.21"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":160.82552137882797,"d":"$160.83"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":149.79667782652098,"d":"$149.80"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":139.89711296853707,"d":"$139.90"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":131.85422075905723,"d":"$131.85"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":128.39414433276553,"d":"$128.39"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":126.8340016164791,"d":"$126.83"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.15500000000000003,"d":"15.50%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":344.65501625795577,"d":"$344.66"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":237.46465895228022,"d":"$237.46"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":162.31398112990624,"d":"$162.31"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":151.36529200801766,"d":"$151.37"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":141.57041604572686,"d":"$141.57"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":133.66160650326583,"d":"$133.66"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":130.29159047518598,"d":"$130.29"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":128.7881776190451,"d":"$128.79"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.15750000000000003,"d":"15.75%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":345.7987140374411,"d":"$345.80"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":238.72102561640054,"d":"$238.72"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":163.8084925761222,"d":"$163.81"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":152.94050411656926,"d":"$152.94"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":143.25061091361997,"d":"$143.25"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":135.47525981234799,"d":"$135.48"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":132.19390622838986,"d":"$132.19"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":130.74567325212365,"d":"$130.75"}}]
[null,{"$f":"IFERROR(MAX((ROW()-ROW(Data[[#Headers],[RATE]]))*0.0025+0.0175,0.0025), \"\")","v":{"v":0.16000000000000003,"d":"16.00%"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[3]]),1)/12,Data[[#Headers],[3]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":346.9444049639811,"d":"$346.94"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[5]]),1)/12,Data[[#Headers],[5]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":239.98082680617566,"d":"$239.98"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[10]]),1)/12,Data[[#Headers],[10]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":165.3090012862229,"d":"$165.31"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[12]]),1)/12,Data[[#Headers],[12]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":154.5222332227232,"d":"$154.52"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[15]]),1)/12,Data[[#Headers],[15]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":144.937573187589,"d":"$144.94"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[20]]),1)/12,Data[[#Headers],[20]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":137.29499408162317,"d":"$137.29"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[25]]),1)/12,Data[[#Headers],[25]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":134.10087692246663,"d":"$134.10"}},{"$f":"IFERROR(PMT(INDEX(Data[],ROW()-ROW(Data[[#Headers],[30]]),1)/12,Data[[#Headers],[30]]*12,-LoanAmount,0,IF(PaymentsDue=\"End of Period\",0,1)), \"\")","v":{"v":132.70628261017836,"d":"$132.71"}}]