{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Valuation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Valuation","index":0,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Val Date","2024-08-10",null,null,null,null,null,null,null,null,"USD SOFR Curve:"]
[null,null,null,null,null,null,null,null,null,null,null,"Tenor","Months","Maturity Date","Rate"]
[null,"Fixed Leg:",null,null,"Float Leg:",null,null,null,null,null,null,"O/N",null,"2024-08-11",5.3499999999999999E-2]
[null,"i",0.04,null,"i","SOFR",null,null,null,null,null,"1M",1,{"$f":"EDATE($C$2,M5)","v":"2024-09-10"},5.457E-2]
[null,"Notional",1000000,null,"Notional",1000000,null,null,null,null,null,"3M",3,{"$f":"EDATE($C$2,M6)","v":"2024-11-10"},5.56614E-2]
[null,"Freq","6M",null,"Freq","6M",null,null,null,null,null,"6M",6,"2025-02-10",4.0632799999999997E-2]
[null,null,null,null,null,null,null,null,null,null,null,"9M",9,"2025-05-10",4.1445500000000003E-2]
[null,null,null,null,null,null,null,null,null,null,null,"1Y",12,"2025-08-10",4.2274399999999997E-2]
[null,null,null,null,null,null,null,null,null,null,null,"2Y",24,"2026-08-10",4.3965400000000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,"3Y",36,"2027-08-10",4.1767100000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,"4Y",48,"2028-08-10",4.2602399999999999E-2]
[]
[]
[null,"Fixed:"]
[]
[null,"Tenor","Date","Freq","Notional","Coupon rate","CF","Rate","TTM","DF","Discounted CF"]
[null,6,{"$f":"EDATE($C$2,B18)","v":"2025-02-10"},0.5,{"$f":"$C$6","v":1000000},{"$f":"$C$5","v":0.04},{"$f":"F18*D18*E18","v":20000},{"$f":"Interpo(C18,$N$4:$N$12,$O$4:$O$12)","v":4.0632799999999997E-2},{"$f":"YEARFRAC($C$2,C18,3)","v":0.50410958904109593},{"$f":"(1+H18)^(-I18)","v":0.98012204867616703},{"$f":"G18*J18","v":19602.440973523342}]
[null,12,{"$f":"EDATE($C$2,B19)","v":"2025-08-10"},0.5,{"$f":"$C$6","v":1000000},{"$f":"$C$5","v":0.04},{"$f":"F19*D19*E19","v":20000},{"$f":"Interpo(C19,$N$4:$N$12,$O$4:$O$12)","v":4.2274399999999997E-2},{"$f":"YEARFRAC($C$2,C19,3)","v":1},{"$f":"(1+H19)^(-I19)","v":0.95944023953768798},{"$f":"G19*J19","v":19188.804790753758}]
[null,18,"2026-02-10",0.5,1000000,0.04,20000,4.3126849315068494E-2,1.5041095890410958,0.938466892376421,18769.337847528419]
[null,24,"2026-08-10",0.5,1000000,0.04,20000,4.3965400000000002E-2,2,0.91754588051057961,18350.917610211593]
[null,null,null,null,null,"Total",{"$f":"SUM(G18:G21)","v":80000},null,null,"Total",{"$f":"SUM(K18:K21)","v":75911.501222017119}]
[null,"Float:"]
[]
[null,"Tenor","Start Date","End Date","Freq","Notional","DF Start","DF End","Coupon rate","CF","Rate","TTM","DF","Discounted CF"]
[null,6,{"$f":"EDATE(D26,-6)","v":"2024-08-10"},{"$f":"EDATE($C$2,B26)","v":"2025-02-10"},0.5,{"$f":"$C$6","v":1000000},{"$f":"(1+Interpo(C26,$N$4:$N$12,$O$4:$O$12))^(-YEARFRAC($C$2,C26,3))","v":1},{"$f":"(1+Interpo(D26,$N$4:$N$12,$O$4:$O$12))^(-YEARFRAC($C$2,D26,3))","v":0.98012204867616703},{"$f":"(G26/H26-1)/YEARFRAC(C26,D26,3)","v":4.0231525929318689E-2},{"$f":"I26*E26*F26","v":20115.762964659345},{"$f":"Interpo(D26,$N$4:$N$12,$O$4:$O$12)","v":4.0632799999999997E-2},{"$f":"YEARFRAC($C$2,D26,3)","v":0.50410958904109593},{"$f":"(1+K26)^(-L26)","v":0.98012204867616703},{"$f":"J26*M26","v":19715.902807606086}]
[null,12,{"$f":"D26","v":"2025-02-10"},{"$f":"EDATE($C$2,B27)","v":"2025-08-10"},0.5,{"$f":"$C$6","v":1000000},{"$f":"(1+Interpo(C27,$N$4:$N$12,$O$4:$O$12))^(-YEARFRAC($C$2,C27,3))","v":0.98012204867616703},0.95944023953768798,{"$f":"(G27/H27-1)/YEARFRAC(C27,D27,3)","v":4.3469524181844403E-2},{"$f":"I27*E27*F27","v":21734.762090922202},{"$f":"Interpo(D27,$N$4:$N$12,$O$4:$O$12)","v":4.2274399999999997E-2},{"$f":"YEARFRAC($C$2,D27,3)","v":1},{"$f":"(1+K27)^(-L27)","v":0.95944023953768798},{"$f":"J27*M27","v":20853.205346809056}]
[null,18,{"$f":"D27","v":"2025-08-10"},{"$f":"EDATE($C$2,B28)","v":"2026-02-10"},0.5,1000000,0.95944023953768798,0.938466892376421,4.4332664171014419E-2,{"$f":"I28*E28*F28","v":22166.332085507209},{"$f":"Interpo(D28,$N$4:$N$12,$O$4:$O$12)","v":4.3126849315068494E-2},{"$f":"YEARFRAC($C$2,D28,3)","v":1.5041095890410958},0.938466892376421,20802.3687876697]
[null,24,"2026-02-10",{"$f":"EDATE($C$2,B29)","v":"2026-08-10"},0.5,1000000,0.938466892376421,0.91754588051057961,4.5980023158030202E-2,{"$f":"I29*E29*F29","v":22990.011579015099},{"$f":"Interpo(D29,$N$4:$N$12,$O$4:$O$12)","v":4.3965400000000002E-2},{"$f":"YEARFRAC($C$2,D29,3)","v":2},0.91754588051057961,21094.390417215829]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J26:J29)","v":87006.868720103856},null,null,"Total",{"$f":"SUM(N26:N29)","v":82465.867359300668}]
[]
[null,"Float Leg Payer",{"$f":"-N30+K22","v":-6554.3661372835486}]
[null,"Fixed Leg payer",{"$f":"-K22+N30","v":6554.3661372835486}]