{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["ПСК"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"ПСК","index":0,"n_rows":18,"n_cols":21,"rows_kept":18,"merged":[[2,8,2,19]]}
["Ставка",{"v":0.25,"d":"25%"}]
[]
["Номер платежа","Дата","Дата в годах","Денежный поток","Погашение процентов","Погашение основного долга","Остаток основного долга","Множители разделения на части","12 частей:",{"$nulls":11},"Сумма"]
[0,"2022-04-01",{"$f":"YEAR(B4)-2000+(B4-DATE(YEAR(B4),1,0))/(DATE(YEAR(B4)+1,1,1)-DATE(YEAR(B4),1,1))","v":22.24931506849315},{"$f":"-G4","v":-150000},null,null,150000,null,{"$f":"D5/H5","v":3020.1324832214755},{"$f":"D6/H6","v":3055.9179632605465},{"$f":"D7/H7","v":2897.7959034902483},{"$f":"D8/H8","v":2932.1318202216353},{"$f":"D9/H9","v":2871.1686502505613},{"$f":"D10/H10","v":2722.6060558407503},{"$f":"D11/H11","v":2754.866152113618},{"$f":"D12/H12","v":2612.321386317973},{"$f":"D13/H13","v":2643.2747220888605},{"$f":"D14/H14","v":2588.317299966288},{"$f":"D15/H15","v":2293.842690500295},{"$f":"D16/H16","v":119607.60736759487},{"$f":"SUM(I4:T4)","v":149999.98249486712}]
[1,{"$f":"EDATE(B4,1)","v":"2022-05-01"},{"$f":"YEAR(B5)-2000+(B5-DATE(YEAR(B5),1,0))/(DATE(YEAR(B5)+1,1,1)-DATE(YEAR(B5),1,1))","v":22.33150684931507},{"$f":"E5","v":3082.19},{"$f":"ROUND(G4*$B$1*($C5-$C4),2)","v":3082.19},{"$f":"0","v":0},{"$f":"G4-F5","v":150000},{"$f":"(1+$B$1*(C5-C4))","v":1.0205479452054798},{"$f":"I4*(1+$B$1*($C5-$C4))","v":3082.19},{"$f":"J4*(1+$B$1*($C5-$C4))","v":3118.7107981220656},{"$f":"K4*(1+$B$1*($C5-$C4))","v":2957.3396549318295},{"$f":"L4*(1+$B$1*($C5-$C4))","v":2992.381104198793},{"$f":"M4*(1+$B$1*($C5-$C4))","v":2930.165266351601},{"$f":"N4*(1+$B$1*($C5-$C4))","v":2778.550015892273},{"$f":"O4*(1+$B$1*($C5-$C4))","v":2811.4729908556797},{"$f":"P4*(1+$B$1*($C5-$C4))","v":2665.999223023138},{"$f":"Q4*(1+$B$1*($C5-$C4))","v":2697.588586241372},2641.5019020203904,2340.976444414685,122065.29792994275]
[2,{"$f":"EDATE(B5,1)","v":"2022-06-01"},22.416438356164385,{"$f":"E6","v":3184.93},{"$f":"ROUND(G5*$B$1*($C6-$C5),2)","v":3184.93},{"$f":"0","v":0},{"$f":"G5-F6","v":150000},{"$f":"H5*(1+$B$1*(C6-C5))","v":1.0422171139050482},null,{"$f":"J5*(1+$B$1*($C6-$C5))","v":3184.9300000000003},{"$f":"K5*(1+$B$1*($C6-$C5))","v":3020.132483221478},3055.9179632605483,{"$f":"M5*(1+$B$1*($C6-$C5))","v":2992.381104198793},2837.5466258187535,2871.168650250561,2722.6060558407526,{"$f":"Q5*(1+$B$1*($C6-$C5))","v":2754.8661521136205},{"$f":"R5*(1+$B$1*($C6-$C5))","v":2697.5885862413716},{"$f":"S5*(1+$B$1*($C6-$C5))","v":2390.682108645408},{"$f":"T5*(1+$B$1*($C6-$C5))","v":124657.09535174292}]
[3,"2022-07-01",22.4986301369863,3082.19,3082.19,{"$f":"0","v":0},150000,{"$f":"H6*(1+$B$1*(C7-C6))","v":1.0636325340537816},null,null,3082.19,3118.7107981220647,3053.86838716178,2895.8523784040685,2930.165266351598,2778.550015892273,2811.4729908556797,2753.0184886983843,2439.8057136175726,127218.54251650468]
[4,"2022-08-01",22.583561643835615,3184.93,3184.93,{"$f":"0","v":0},150000,1.0862165125165675,{"$nulls":3},3184.9299999999994,3118.7107981220647,2957.3396549318263,2992.3811041987897,2837.5466258187535,2871.168650250561,2811.472990855679,2491.60980753685,129919.75814527979]
[5,"2022-09-01",22.66849315068493,3184.93,3184.93,{"$f":"0","v":0},150000,1.1092800138097276,{"$nulls":4},3184.9299999999994,3020.132483221475,3055.917963260545,2897.795903490248,2932.131820221635,2871.1686502505604,2544.5138513955094,132678.3283524741]
[6,"2022-10-01",22.75068493150685,3082.19,3082.19,{"$f":"0","v":0},150000,1.1320734387510238,{"$nulls":5},3082.1899999999996,3118.7107981220643,2957.339654931829,2992.3811041987924,2930.1652663516,2596.7983825885685,135404.5953734154]
[7,"2022-11-01",22.835616438356166,3184.93,3184.93,{"$f":"0","v":0},150000,1.1561106145053266,{"$nulls":6},3184.929999999999,3020.1324832214777,3055.917963260548,2992.381104198792,2651.9358824928468,138279.6244532619]
[8,"2022-12-01",22.91780821917808,3082.19,3082.19,{"$f":"0","v":0},150000,1.1798663120636546,{"$nulls":7},3082.1899999999996,3118.7107981220643,3053.868387161779,2706.427715694753,141120.98659956173]
[9,"2023-01-01",23.002739726027396,3184.93,3184.93,{"$f":"0","v":0},150000,1.2049182680047323,{"$nulls":8},3184.929999999999,3118.710798122064,2763.8929617129293,144117.39110955244]
[10,"2023-02-01",23.087671232876712,3184.93,3184.93,{"$f":"0","v":0},150000,1.2305021490377097,{"$nulls":9},{"$f":"R13*(1+$B$1*($C14-$C13))","v":3184.9299999999985},{"$f":"S13*(1+$B$1*($C14-$C13))","v":2822.578360215053},{"$f":"T13*(1+$B$1*($C14-$C13))","v":147177.41790708405}]
[11,"2023-03-01",23.164383561643834,2876.71,2876.71,{"$f":"0","v":0},150000,1.2541008203891175,{"$nulls":10},{"$f":"S14*(1+$B$1*($C15-$C14))","v":2876.7099999999987},{"$f":"T14*(1+$B$1*($C15-$C14))","v":149999.99852448015}]
[12,"2023-04-01",23.24931506849315,{"$f":"SUM(E16:F16)","v":153184.93},3184.93,{"$f":"G15","v":150000},0,1.2807289884932702,{"$nulls":11},153184.92999999996]
[null,"ПСК по ст. 6 353-ФЗ:",null,{"$f":"IRR(D4:D16)*12","v":{"v":0.2500741876426069,"d":"25.007%"}}]
[null,"Уточненная ПСК:",null,{"$f":"пск(D4:D16,B4:B16)","v":{"v":0.2499998668981353,"d":"25.000%"}}]