{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Bond Amortization (Digital)","Bond Amortization (Print)"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Bond Amortization (Digital)","index":0,"n_rows":48,"n_cols":6,"rows_kept":48}
[]
["OUR BOND"]
["amortization"]
[]
[null,"BOND PURCHASE PRICE",{"v":100000,"d":"$100,000.00"}]
[null,"FACE VALUE OF BOND",{"v":96149,"d":"$96,149.00"}]
[null,"YEARS UNTIL MATURITY",10]
[null,"COUPON RATE",{"v":0.1,"d":"10.00%"}]
[null,"EFFECTIVE RATE",{"v":0.05,"d":"5.00%"}]
[]
[{"$nulls":4},"AMORTIZATION"]
[{"$nulls":4},"OF (DISCOUNT)","CARRYING"]
[null,"PAYMENTS","CASH PAID","EXPENSE","OR PREMIUM","AMOUNT"]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":1},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F13)","v":{"v":2500,"d":"$2,500.00"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":2307.45,"d":"$2,307.45"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F13-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":97692.55,"d":"$97,692.55"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":2},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F14)","v":{"v":2442.3137500000003,"d":"$2,442.31"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":2365.1362499999996,"d":"$2,365.14"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F14-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":95327.41375,"d":"$95,327.41"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":3},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F15)","v":{"v":2383.1853437500004,"d":"$2,383.19"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":2424.2646562499995,"d":"$2,424.26"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F15-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":92903.14909375,"d":"$92,903.15"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":4},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F16)","v":{"v":2322.5787273437504,"d":"$2,322.58"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":2484.8712726562494,"d":"$2,484.87"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F16-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":90418.27782109375,"d":"$90,418.28"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":5},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F17)","v":{"v":2260.456945527344,"d":"$2,260.46"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":2546.993054472656,"d":"$2,546.99"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F17-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":87871.2847666211,"d":"$87,871.28"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":6},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F18)","v":{"v":2196.7821191655275,"d":"$2,196.78"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":2610.6678808344723,"d":"$2,610.67"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F18-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":85260.61688578663,"d":"$85,260.62"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":7},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F19)","v":{"v":2131.515422144666,"d":"$2,131.52"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":2675.934577855334,"d":"$2,675.93"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F19-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":82584.68230793129,"d":"$82,584.68"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":8},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F20)","v":{"v":2064.617057698282,"d":"$2,064.62"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":2742.8329423017176,"d":"$2,742.83"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F20-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":79841.84936562958,"d":"$79,841.85"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":9},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F21)","v":{"v":1996.0462341407394,"d":"$1,996.05"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":2811.4037658592606,"d":"$2,811.40"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F21-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":77030.44559977032,"d":"$77,030.45"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":10},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F22)","v":{"v":1925.761139994258,"d":"$1,925.76"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":2881.688860005742,"d":"$2,881.69"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F22-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":74148.75673976458,"d":"$74,148.76"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":11},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F23)","v":{"v":1853.7189184941144,"d":"$1,853.72"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":2953.7310815058854,"d":"$2,953.73"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F23-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":71195.02565825869,"d":"$71,195.03"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":12},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F24)","v":{"v":1779.8756414564673,"d":"$1,779.88"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":3027.5743585435325,"d":"$3,027.57"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F24-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":68167.45129971516,"d":"$68,167.45"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":13},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F25)","v":{"v":1704.1862824928792,"d":"$1,704.19"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":3103.2637175071204,"d":"$3,103.26"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F25-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":65064.18758220804,"d":"$65,064.19"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":14},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F26)","v":{"v":1626.604689555201,"d":"$1,626.60"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":3180.845310444799,"d":"$3,180.85"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F26-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":61883.34227176324,"d":"$61,883.34"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":15},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F27)","v":{"v":1547.0835567940812,"d":"$1,547.08"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":3260.3664432059186,"d":"$3,260.37"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F27-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":58622.975828557326,"d":"$58,622.98"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":16},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F28)","v":{"v":1465.5743957139332,"d":"$1,465.57"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":3341.875604286067,"d":"$3,341.88"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F28-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":55281.10022427126,"d":"$55,281.10"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":17},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F29)","v":{"v":1382.0275056067815,"d":"$1,382.03"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":3425.4224943932186,"d":"$3,425.42"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F29-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":51855.677729878036,"d":"$51,855.68"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":18},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F30)","v":{"v":1296.391943246951,"d":"$1,296.39"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":3511.0580567530487,"d":"$3,511.06"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F30-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":48344.61967312499,"d":"$48,344.62"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":19},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F31)","v":{"v":1208.6154918281247,"d":"$1,208.62"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":3598.8345081718753,"d":"$3,598.83"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F31-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":44745.785164953115,"d":"$44,745.79"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":20},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F32)","v":{"v":1118.6446291238278,"d":"$1,118.64"}},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":{"v":3688.8053708761718,"d":"$3,688.81"}},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F32-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":{"v":41056.97979407694,"d":"$41,056.98"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F33)","v":0},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F33-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F34)","v":0},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F34-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F35)","v":0},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F35-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F36)","v":0},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F36-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F37)","v":0},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F37-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F38)","v":0},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F38-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F39)","v":0},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F39-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F40)","v":0},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F40-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F41)","v":0},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F41-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F42)","v":0},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F42-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F43)","v":0},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F43-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F44)","v":0},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F44-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F45)","v":0},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F45-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F46)","v":0},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F46-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule[])+1,ROW()-ROW(AmortizationSchedule[])+1,0)","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F47)","v":0},{"$f":"AmortizationSchedule[[#This Row],[CASH PAID]]-AmortizationSchedule[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule[[#This Row],[OR PREMIUM]],$F47-AmortizationSchedule[[#This Row],[OR PREMIUM]])*(AmortizationSchedule[[#This Row],[PAYMENTS]]>0)","v":0}]

{"sheet":"Bond Amortization (Print)","index":1,"n_rows":48,"n_cols":6,"rows_kept":48}
[]
["OUR BOND"]
["amortization"]
[]
[null,"BOND PURCHASE PRICE",{"$f":"PurchasePrice","v":{"v":100000,"d":"$100,000.00"}}]
[null,"FACE VALUE OF BOND",{"$f":"FaceValue","v":{"v":96149,"d":"$96,149.00"}}]
[null,"YEARS UNTIL MATURITY",15]
[null,"COUPON RATE",{"$f":"CouponRate","v":{"v":0.1,"d":"10.00%"}}]
[null,"EFFECTIVE RATE",{"$f":"EffectiveRate","v":{"v":0.05,"d":"5.00%"}}]
[]
[{"$nulls":4},"AMORTIZATION"]
[{"$nulls":4},"OF (DISCOUNT)","CARRYING"]
[null,"PAYMENTS","CASH PAID","EXPENSE","OR PREMIUM","AMOUNT"]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":1},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F13)","v":{"v":2500,"d":"$2,500.00"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":2307.45,"d":"$2,307.45"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F13-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":97692.55,"d":"$97,692.55"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":2},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F14)","v":{"v":2442.3137500000003,"d":"$2,442.31"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":2365.1362499999996,"d":"$2,365.14"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F14-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":95327.41375,"d":"$95,327.41"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":3},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F15)","v":{"v":2383.1853437500004,"d":"$2,383.19"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":2424.2646562499995,"d":"$2,424.26"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F15-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":92903.14909375,"d":"$92,903.15"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":4},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F16)","v":{"v":2322.5787273437504,"d":"$2,322.58"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":2484.8712726562494,"d":"$2,484.87"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F16-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":90418.27782109375,"d":"$90,418.28"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":5},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F17)","v":{"v":2260.456945527344,"d":"$2,260.46"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":2546.993054472656,"d":"$2,546.99"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F17-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":87871.2847666211,"d":"$87,871.28"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":6},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F18)","v":{"v":2196.7821191655275,"d":"$2,196.78"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":2610.6678808344723,"d":"$2,610.67"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F18-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":85260.61688578663,"d":"$85,260.62"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":7},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F19)","v":{"v":2131.515422144666,"d":"$2,131.52"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":2675.934577855334,"d":"$2,675.93"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F19-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":82584.68230793129,"d":"$82,584.68"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":8},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F20)","v":{"v":2064.617057698282,"d":"$2,064.62"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":2742.8329423017176,"d":"$2,742.83"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F20-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":79841.84936562958,"d":"$79,841.85"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":9},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F21)","v":{"v":1996.0462341407394,"d":"$1,996.05"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":2811.4037658592606,"d":"$2,811.40"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F21-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":77030.44559977032,"d":"$77,030.45"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":10},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F22)","v":{"v":1925.761139994258,"d":"$1,925.76"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":2881.688860005742,"d":"$2,881.69"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F22-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":74148.75673976458,"d":"$74,148.76"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":11},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F23)","v":{"v":1853.7189184941144,"d":"$1,853.72"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":2953.7310815058854,"d":"$2,953.73"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F23-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":71195.02565825869,"d":"$71,195.03"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":12},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F24)","v":{"v":1779.8756414564673,"d":"$1,779.88"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":3027.5743585435325,"d":"$3,027.57"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F24-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":68167.45129971516,"d":"$68,167.45"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":13},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F25)","v":{"v":1704.1862824928792,"d":"$1,704.19"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":3103.2637175071204,"d":"$3,103.26"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F25-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":65064.18758220804,"d":"$65,064.19"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":14},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F26)","v":{"v":1626.604689555201,"d":"$1,626.60"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":3180.845310444799,"d":"$3,180.85"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F26-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":61883.34227176324,"d":"$61,883.34"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":15},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F27)","v":{"v":1547.0835567940812,"d":"$1,547.08"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":3260.3664432059186,"d":"$3,260.37"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F27-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":58622.975828557326,"d":"$58,622.98"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":16},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F28)","v":{"v":1465.5743957139332,"d":"$1,465.57"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":3341.875604286067,"d":"$3,341.88"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F28-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":55281.10022427126,"d":"$55,281.10"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":17},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F29)","v":{"v":1382.0275056067815,"d":"$1,382.03"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":3425.4224943932186,"d":"$3,425.42"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F29-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":51855.677729878036,"d":"$51,855.68"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":18},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F30)","v":{"v":1296.391943246951,"d":"$1,296.39"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":3511.0580567530487,"d":"$3,511.06"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F30-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":48344.61967312499,"d":"$48,344.62"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":19},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F31)","v":{"v":1208.6154918281247,"d":"$1,208.62"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":3598.8345081718753,"d":"$3,598.83"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F31-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":44745.785164953115,"d":"$44,745.79"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":20},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":{"v":4807.45,"d":"$4,807.45"}},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F32)","v":{"v":1118.6446291238278,"d":"$1,118.64"}},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":{"v":3688.8053708761718,"d":"$3,688.81"}},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F32-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":{"v":41056.97979407694,"d":"$41,056.98"}}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F33)","v":0},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F33-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F34)","v":0},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F34-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F35)","v":0},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F35-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F36)","v":0},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F36-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F37)","v":0},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F37-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F38)","v":0},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F38-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F39)","v":0},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F39-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F40)","v":0},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F40-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F41)","v":0},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F41-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F42)","v":0},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F42-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F43)","v":0},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F43-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F44)","v":0},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F44-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F45)","v":0},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F45-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F46)","v":0},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F46-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":0}]
[null,{"$f":"IF(YearsToMaturity*2>=ROW()-ROW(AmortizationSchedule4[])+1,ROW()-ROW(AmortizationSchedule4[])+1,0)","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*FaceValue*CouponRate*0.5","v":0},{"$f":"(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)*EffectiveRate*0.5*IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice,$F47)","v":0},{"$f":"AmortizationSchedule4[[#This Row],[CASH PAID]]-AmortizationSchedule4[[#This Row],[EXPENSE]]","v":0},{"$f":"IF(AmortizationSchedule4[[#This Row],[PAYMENTS]]=1,PurchasePrice-AmortizationSchedule4[[#This Row],[OR PREMIUM]],$F47-AmortizationSchedule4[[#This Row],[OR PREMIUM]])*(AmortizationSchedule4[[#This Row],[PAYMENTS]]>0)","v":0}]