{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["16.1"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"16.1","index":0,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[10,11,10,12],[16,11,16,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Fixed","Floating","Extra DF","Fwd Spread","ECB","PCB","NCB","PCB+NCB",null,"Spread ",1E-3]
[null,0,null,null,null,null,-23968.198039239775,0,-23968.198039239775,-23968.198039239775]
[null,0.25,371755.68177702895,199816.97260967878,{"$f":"EXP(-B11*Spread)","v":0.99975003124739603},{"$f":"EXP(-Spread*B10)-EXP(-Spread*B11)","v":2.4996875260396845E-4},147970.51112811209,1231697.154579361,-1079963.1740837849,151733.98049557605,null,"Discounting Approach"]
[null,0.5,370920.23134231567,224281.9958961806,0.99950012497916929,2.4990626822674056E-4,294608.74657424306,1739123.4757107836,-1440139.7616456964,298983.71406508726,null,"Value (base rate)",{"$f":"-SUM(C11:C50)+SUM(D11:D50)","v":-23968.198039239272}]
[null,0.75,370022.97965550306,240872.93605706826,0.99925028117970072,2.4984379946857427E-4,423758.79017267638,2104120.049047919,-1675997.1072961099,428122.94175180909,null,"Value (adjusted rate)",{"$f":"-SUMPRODUCT(C11:C50,E11:E50)+SUMPRODUCT(D11:D50,E11:E50)","v":-33401.060900790617}]
[null,1,369088.70592713356,250811.73915960654,0.99900049983337502,2.4978134632569482E-4,542035.75694020535,2404492.2783330837,-1859540.6960981633,544951.58223492047,null,"Difference",{"$f":"M13-M12","v":-9432.8628615513444}]
[null,1.25,368126.35867744981,258348.25494865931,0.99875078092458092,2.4971890879410541E-4,651813.86066899414,2629639.1920511033,-1974652.4588369341,654986.73321416928,null,"ColVA",{"$f":"-SUMPRODUCT(G10:G49,F11:F50)","v":-9432.8628615501329}]
[null,1.5,367142.6810324192,264074.53557868442,0.99850112443771089,2.4965648687003128E-4,754882.00612272986,2828193.8553273785,-2070732.4371609618,757461.4181664167]
[null,1.75,366141.81434895005,268689.04254204739,0.99825153035716152,2.4959408054936461E-4,852334.77792963223,2986872.4581918796,-2131811.8264942244,855060.63169765519,null,"Monte Carlo Approach"]
[null,2,365124.00880455971,273236.38775580417,0.99800199866733308,2.4953168982844165E-4,944222.39897838794,3126373.669948535,-2180415.1238292251,945958.54611930996,null,"ColRA",{"$f":"-SUMPRODUCT(H10:H49,F11:F50)","v":-24225.836138389168}]
[null,2.25,364086.56097793393,278509.48365792941,0.99775252935262992,2.4946931470315459E-4,1029799.4762983917,3229291.0855759773,-2195537.1797337686,1033753.9058422088,null,"ColPA",{"$f":"-SUMPRODUCT(I10:I49,F11:F50)","v":14799.023484925005}]
[null,2.5,363028.11548113823,284146.44209280302,0.99750312239746008,2.4940695516983968E-4,1108681.1496867272,3317409.7075456427,-2205203.6233258331,1112206.0842198096,null,"ColVA",{"$f":"M19+M18","v":-9426.8126534641633}]
[null,2.75,361947.10146653157,290205.10459238925,0.99725377778623581,2.4934461122427809E-4,1180423.1465608703,3390345.0232233028,-2207065.5541899563,1183279.4690333465]
[null,3,360840.85792303085,296978.13248341641,0.997004495503373,2.4928228286280607E-4,1244285.8720004861,3439713.2797624865,-2191564.7365524136,1248148.5432100729]
[null,3.25,359706.43108687922,304544.11708769057,0.99675527553329146,2.4921997008153784E-4,1299448.1859996743,3481438.6159833265,-2180033.3463794771,1301405.2696038494]
[null,3.5,358543.1195795536,312298.39122834947,0.99650611786041488,2.4915767287658763E-4,1345692.914350878,3499589.2849114188,-2151671.2027265299,1347918.0821848889]
[null,3.75,357351.05492516537,320017.35688274022,0.99625702246917103,2.4909539124384761E-4,1383026.6123933024,3502549.5009121057,-2118253.775861925,1384295.7250501807]
[null,4,356130.6819319725,327616.91092426662,0.99600798934399148,2.4903312517954301E-4,1411540.3834010081,3489527.6168388687,-2076051.5603305853,1413476.0565082834]
[null,4.25,354882.64727442095,335042.86108766432,0.99575901846931159,2.4897087467989909E-4,1431380.1695877663,3464622.095564927,-2032251.7228304124,1432370.3727345145]
[null,4.5,353607.85230994225,342226.83610166673,0.99551010982957056,2.4890863974103006E-4,1442761.1857960417,3432962.7808149415,-1989524.0529211867,1443438.7278937548]
[null,4.75,352307.42493493587,349108.02013594646,0.99526126340921184,2.4884642035871707E-4,1445960.5905950316,3379496.4986369787,-1934535.884460056,1444960.6141769227]
[null,5,350982.7347099781,355621.53690140706,0.99501247919268232,2.4878421652951843E-4,1441321.788403603,3316799.0290991724,-1876673.9865980623,1440125.0425011101]
[null,5.25,349635.2044437452,361753.09160615399,0.9947637571644331,2.487220282492153E-4,1429203.901241194,3243467.4469960867,-1817099.3266926215,1426368.1203034653]
[null,5.5,348265.63119888306,367670.66976164386,0.99451509730891907,2.4865985551403291E-4,1409798.8626784324,3154291.7004863275,-1747066.5525691502,1407225.1479171773]
[null,5.75,346874.66810896411,373412.91004534537,0.99426649961059888,2.4859769832019651E-4,1383260.6207420516,3054539.9190355721,-1673556.2983270574,1380983.6207085147]
[null,6,345462.98056840897,378976.52095441049,0.99401796405393528,2.4853555666359828E-4,1349747.08035605,2946989.9305383912,-1600374.7963935626,1346615.1341448287]
[null,6.25,344031.2791101808,384349.38475923054,0.9937694906233947,2.4847343054057447E-4,1309428.9747070011,2832214.836891857,-1525876.1048402986,1306338.7320515583]
[null,6.5,342580.28909564018,389527.52068205364,0.99352107930344769,2.4841131994701726E-4,1262481.743120586,2700650.8888977342,-1441244.1997491335,1259406.6891486007]
[null,6.75,341110.70288355427,394519.78847943048,0.99327273007856842,2.4834922487926292E-4,1209072.6575247103,2564479.4572014501,-1359150.5839848137,1205328.8732166365]
[null,7,339623.28508496284,399306.79156817694,0.99302444293323511,2.4828714533331464E-4,1149389.1510414965,2420112.4268930866,-1276440.2722354117,1143672.154657675]
[null,7.25,338118.79240001785,403890.65367650858,0.99277621785192982,2.4822508130528664E-4,1083617.2897650057,2263612.4200655925,-1185578.0600032494,1078034.3600623431]
[null,7.5,336597.80785441399,408317.99881982931,0.99252805481913842,2.4816303279140417E-4,1011897.0987995905,2100314.5837966348,-1094399.7408342334,1005914.8429624015]
[null,7.75,335060.98467315617,412569.98154571844,0.99227995381935086,2.481009997875594E-4,934388.1019270278,1922773.6933333073,-993524.03118298517,929249.66215032211]
[null,8,333508.8974237442,416667.71796294855,0.99203191483706066,2.4803898229019961E-4,851229.28138782363,1738688.9681351481,-893158.32216589001,845530.64596925804]
[null,8.25,331942.17671279551,420596.16401306511,0.99178393785676544,2.4797698029521698E-4,762575.29408755398,1550862.4919139976,-794384.86839544028,756477.62351855729]
[null,8.5,330361.3717854023,424377.16171630501,0.99153602286296671,2.4791499379872572E-4,668559.50415665132,1350319.4518201121,-686310.80573848146,664008.64608163061]
[null,8.75,328767.11791138374,427987.61718618736,0.99128816984016976,2.4785302279695109E-4,569339.00488184765,1145546.2833762383,-580353.78362752346,565192.49974871485]
[null,9,327159.93791818619,431457.7162946476,0.99104037877288365,2.4779106728611833E-4,465041.22650538624,930250.61224301776,-468356.21285608388,461894.39938693389]
[null,9.25,325540.46283645241,434758.41120370617,0.99079264964562164,2.4772912726200857E-4,355823.27813813242,708228.95154989359,-354797.81840491609,353431.1331449775]
[null,9.5,323909.21398997307,437919.15341726551,0.99054498244290046,2.4766720272118015E-4,241813.33871083995,478645.28441903263,-238254.51097016531,240390.77344886732]
[null,9.75,322266.79293913103,440918.40291061724,0.99029737714924104,2.4760529365941419E-4,123161.72873935377,243083.71599485772,-120656.63391514042,122427.08207971729]
[null,10,320613.72935771942,443775.45809707319,0.99004983374916811,2.4754340007293596E-4,0,0,0,0]