{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["\"простые\""],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"\"простые\"","index":0,"n_rows":68,"n_cols":8,"rows_kept":68}
["Ставка",{"v":0.169,"d":"16.90%"},"ЧБП=",12,"ПСК=",{"$f":"H1*D1","v":{"v":0.1689546252227902,"d":"16.895%"}},"i=",0.014079552101899184]
["Аннуитет",{"$f":"ROUND(G4*B1/12/(1-(1+B1/12)^-60),2)","v":11401.42},null,null,"ek=",0,"Σ=",{"$f":"SUM(H4:H64)","v":{"v":6.6335815063212067E-7,"d":"0.00"}}]
["Месяц, qk","Дата","Дата в годах","Денежный поток","Погашение процентов","Погашение основного долга","Остаток основного долга","Дисконтированный денежный поток"]
[0,"2020-12-09",{"$f":"YEAR(B4)-2000+(B4-DATE(YEAR(B4),1,0))/(DATE(YEAR(B4)+1,1,1)-DATE(YEAR(B4),1,1))","v":20.939890710382514},{"$f":"-G4","v":{"v":-459756.1,"d":"-459756.10"}},null,null,{"v":459756.1,"d":"459756.10"},{"$f":"D4/(1+$H$1)^A4","v":-459756.1}]
[1,{"$f":"EDATE(B4,1)","v":"2021-01-09"},{"$f":"YEAR(B5)-2000+(B5-DATE(YEAR(B5),1,0))/(DATE(YEAR(B5)+1,1,1)-DATE(YEAR(B5),1,1))","v":21.024657534246575},{"$f":"$B$2","v":11401.42},{"$f":"ROUND(G4*$B$1*(C5-C4),2)","v":6586.28},{"$f":"ROUND(D5-E5,2)","v":4815.14},{"$f":"ROUND(G4-F5,2)","v":454940.96},{"$f":"D5/(1+$H$1)^A5","v":11243.121879706667}]
[2,{"$f":"EDATE(B5,1)","v":"2021-02-09"},21.10958904109589,{"$f":"$B$2","v":11401.42},{"$f":"ROUND(G5*$B$1*(C6-C5),2)","v":6529.96},{"$f":"ROUND(D6-E6,2)","v":4871.46},{"$f":"ROUND(G5-F6,2)","v":{"v":450069.5,"d":"450069.50"}},{"$f":"D6/(1+$H$1)^A6","v":11087.021581692348}]
[3,{"$f":"EDATE(B6,1)","v":"2021-03-09"},21.186301369863013,11401.42,{"$f":"ROUND(G6*$B$1*(C7-C6),2)","v":5834.87},5566.55,{"$f":"ROUND(G6-F7,2)","v":444502.95},{"$f":"D7/(1+$H$1)^A7","v":10933.088591237341}]
[4,{"$f":"EDATE(B7,1)","v":"2021-04-09"},21.27123287671233,{"$f":"$B$2","v":11401.42},{"$f":"ROUND(G7*$B$1*(C8-C7),2)","v":6380.14},5021.28,{"$f":"ROUND(G7-F8,2)","v":439481.67},{"$f":"D8/(1+$H$1)^A8","v":10781.292817290469}]
[5,{"$f":"EDATE(B8,1)","v":"2021-05-09"},21.353424657534248,{"$f":"$B$2","v":11401.42},{"$f":"ROUND(G8*$B$1*(C9-C8),2)","v":6104.58},5296.84,{"$f":"ROUND(G8-F9,2)","v":434184.83},{"$f":"D9/(1+$H$1)^A9","v":10631.604586586827}]
[6,"2021-06-09",21.438356164383563,11401.42,{"$f":"ROUND(G9*$B$1*(C10-C9),2)","v":6232.04},5169.38,{"$f":"ROUND(G9-F10,2)","v":429015.45},{"$f":"D10/(1+$H$1)^A10","v":10483.994637847227}]
[7,"2021-07-09",21.52054794520548,11401.42,{"$f":"ROUND(G10*$B$1*(C11-C10),2)","v":{"v":5959.2,"d":"5959.20"}},5442.22,{"$f":"ROUND(G10-F11,2)","v":423573.23},{"$f":"D11/(1+$H$1)^A11","v":10338.434116058133}]
[8,"2021-08-09",21.605479452054794,11401.42,{"$f":"ROUND(G11*$B$1*(C12-C11),2)","v":6079.73},5321.69,{"$f":"ROUND(G11-F12,2)","v":418251.54},{"$f":"D12/(1+$H$1)^A12","v":10194.894566831066}]
[9,"2021-09-09",21.69041095890411,11401.42,{"$f":"ROUND(G12*$B$1*(C13-C12),2)","v":6003.34},5398.08,{"$f":"ROUND(G12-F13,2)","v":412853.46},{"$f":"D13/(1+$H$1)^A13","v":10053.347930840278}]
[10,"2021-10-09",21.77260273972603,11401.42,{"$f":"ROUND(G13*$B$1*(C14-C13),2)","v":{"v":5734.7,"d":"5734.70"}},5666.72,{"$f":"ROUND(G13-F14,2)","v":407186.74},{"$f":"D14/(1+$H$1)^A14","v":9913.766538337688}]
[11,"2021-11-09",21.85753424657534,11401.42,{"$f":"ROUND(G14*$B$1*(C15-C14),2)","v":5844.52},{"v":5556.9,"d":"5556.90"},{"$f":"ROUND(G14-F15,2)","v":401629.84},{"$f":"D15/(1+$H$1)^A15","v":9776.123103743945}]
[12,"2021-12-09",21.93972602739726,11401.42,{"$f":"ROUND(G15*$B$1*(C16-C15),2)","v":{"v":5578.8,"d":"5578.80"}},5822.62,{"$f":"ROUND(G15-F16,2)","v":395807.22},{"$f":"D16/(1+$H$1)^A16","v":9640.39072031461}]
[13,"2022-01-09",22.024657534246575,11401.42,{"$f":"ROUND(G16*$B$1*(C17-C16),2)","v":5681.19},5720.23,{"$f":"ROUND(G16-F17,2)","v":390086.99},{"$f":"D17/(1+$H$1)^A17","v":9506.542854880383}]
[14,"2022-02-09",22.10958904109589,11401.42,{"$f":"ROUND(G17*$B$1*(C18-C17),2)","v":5599.08},5802.34,{"$f":"ROUND(G17-F18,2)","v":384284.65},{"$f":"D18/(1+$H$1)^A18","v":9374.553342660363}]
[15,"2022-03-09",22.186301369863013,11401.42,{"$f":"ROUND(G18*$B$1*(C19-C18),2)","v":4982.01},6419.41,{"$f":"ROUND(G18-F19,2)","v":377865.24},{"$f":"D19/(1+$H$1)^A19","v":9244.396382147312}]
[16,"2022-04-09",22.27123287671233,11401.42,{"$f":"ROUND(G19*$B$1*(C20-C19),2)","v":5423.66},5977.76,{"$f":"ROUND(G19-F20,2)","v":371887.48},{"$f":"D20/(1+$H$1)^A20","v":9116.046530063939}]
[17,"2022-05-09",22.353424657534248,11401.42,{"$f":"ROUND(G20*$B$1*(C21-C20),2)","v":5165.67},6235.75,{"$f":"ROUND(G20-F21,2)","v":365651.73},{"$f":"D21/(1+$H$1)^A21","v":8989.478696389215}]
[18,"2022-06-09",22.438356164383563,11401.42,{"$f":"ROUND(G21*$B$1*(C22-C21),2)","v":5248.35},6153.07,{"$f":"ROUND(G21-F22,2)","v":359498.66},{"$f":"D22/(1+$H$1)^A22","v":8864.66813945373}]
[19,"2022-07-09",22.52054794520548,11401.42,{"$f":"ROUND(G22*$B$1*(C23-C22),2)","v":4993.58},6407.84,{"$f":"ROUND(G22-F23,2)","v":353090.82},{"$f":"D23/(1+$H$1)^A23","v":8741.59046110316}]
[20,"2022-08-09",22.605479452054794,11401.42,{"$f":"ROUND(G23*$B$1*(C24-C23),2)","v":5068.06},6333.36,{"$f":"ROUND(G23-F24,2)","v":346757.46},{"$f":"D24/(1+$H$1)^A24","v":8620.221601928888}]
[21,"2022-09-09",22.69041095890411,11401.42,{"$f":"ROUND(G24*$B$1*(C25-C24),2)","v":4977.16},6424.26,{"$f":"ROUND(G24-F25,2)","v":{"v":340333.2,"d":"340333.20"}},{"$f":"D25/(1+$H$1)^A25","v":8500.537836564807}]
[22,"2022-10-09",22.77260273972603,11401.42,{"$f":"ROUND(G25*$B$1*(C26-C25),2)","v":4727.37},6674.05,{"$f":"ROUND(G25-F26,2)","v":333659.15},{"$f":"D26/(1+$H$1)^A26","v":8382.515769049483}]
[23,"2022-11-09",22.85753424657534,11401.42,{"$f":"ROUND(G26*$B$1*(C27-C26),2)","v":4789.15},6612.27,{"$f":"ROUND(G26-F27,2)","v":327046.88},{"$f":"D27/(1+$H$1)^A27","v":8266.132328252655}]
[24,"2022-12-09",22.93972602739726,11401.42,{"$f":"ROUND(G27*$B$1*(C28-C27),2)","v":4542.82},{"v":6858.6,"d":"6858.60"},{"$f":"ROUND(G27-F28,2)","v":320188.28},{"$f":"D28/(1+$H$1)^A28","v":8151.36476336527}]
[25,"2023-01-09",23.024657534246575,11401.42,{"$f":"ROUND(G28*$B$1*(C29-C28),2)","v":{"v":4595.8,"d":"4595.80"}},6805.62,{"$f":"ROUND(G28-F29,2)","v":313382.66},{"$f":"D29/(1+$H$1)^A29","v":8038.190639452105}]
[26,"2023-02-09",23.10958904109589,11401.42,{"$f":"ROUND(G29*$B$1*(C30-C29),2)","v":4498.11},6903.31,{"$f":"ROUND(G29-F30,2)","v":306479.35},{"$f":"D30/(1+$H$1)^A30","v":7926.587833066169}]
[27,"2023-03-09",23.186301369863013,11401.42,{"$f":"ROUND(G30*$B$1*(C31-C30),2)","v":3973.32},{"v":7428.1,"d":"7428.10"},{"$f":"ROUND(G30-F31,2)","v":299051.25},{"$f":"D31/(1+$H$1)^A31","v":7816.534527923969}]
[28,"2023-04-09",23.27123287671233,11401.42,{"$f":"ROUND(G31*$B$1*(C32-C31),2)","v":4292.41},7109.01,{"$f":"ROUND(G31-F32,2)","v":291942.24},{"$f":"D32/(1+$H$1)^A32","v":7708.009210640832}]
[29,"2023-05-09",23.353424657534248,11401.42,{"$f":"ROUND(G32*$B$1*(C33-C32),2)","v":{"v":4055.2,"d":"4055.20"}},7346.22,{"$f":"ROUND(G32-F33,2)","v":284596.02},{"$f":"D33/(1+$H$1)^A33","v":7600.9906665254375}]
[30,"2023-06-09",23.438356164383563,11401.42,{"$f":"ROUND(G33*$B$1*(C34-C33),2)","v":4084.93},7316.49,{"$f":"ROUND(G33-F34,2)","v":277279.53},{"$f":"D34/(1+$H$1)^A34","v":7495.457975432738}]
[31,"2023-07-09",23.52054794520548,11401.42,{"$f":"ROUND(G34*$B$1*(C35-C34),2)","v":3851.53},7549.89,{"$f":"ROUND(G34-F35,2)","v":269729.64},{"$f":"D35/(1+$H$1)^A35","v":7391.390507674451}]
[32,"2023-08-09",23.605479452054794,11401.42,{"$f":"ROUND(G35*$B$1*(C36-C35),2)","v":3871.54},7529.88,{"$f":"ROUND(G35-F36,2)","v":262199.76},{"$f":"D36/(1+$H$1)^A36","v":7288.767919986352}]
[33,"2023-09-09",23.69041095890411,11401.42,{"$f":"ROUND(G36*$B$1*(C37-C36),2)","v":3763.46},7637.96,{"$f":"ROUND(G36-F37,2)","v":{"v":254561.8,"d":"254561.80"}},{"$f":"D37/(1+$H$1)^A37","v":7187.570151551527}]
[34,"2023-10-09",23.77260273972603,11401.42,{"$f":"ROUND(G37*$B$1*(C38-C37),2)","v":3535.97},7865.45,{"$f":"ROUND(G37-F38,2)","v":246696.35},{"$f":"D38/(1+$H$1)^A38","v":7087.777420078862}]
[35,"2023-11-09",23.85753424657534,11401.42,{"$f":"ROUND(G38*$B$1*(C39-C38),2)","v":3540.94},7860.48,{"$f":"ROUND(G38-F39,2)","v":238835.87},{"$f":"D39/(1+$H$1)^A39","v":6989.370217935968}]
[36,"2023-12-09",23.93972602739726,11401.42,{"$f":"ROUND(G39*$B$1*(C40-C39),2)","v":3317.53},8083.89,{"$f":"ROUND(G39-F40,2)","v":230751.98},{"$f":"D40/(1+$H$1)^A40","v":6892.3293083358085}]
[37,"2024-01-09",24.024590163934427,11401.42,{"$f":"ROUND(G40*$B$1*(C41-C40),2)","v":3309.45},8091.97,{"$f":"ROUND(G40-F41,2)","v":222660.01},{"$f":"D41/(1+$H$1)^A41","v":6796.6357215762455}]
[38,"2024-02-09",24.10928961748634,11401.42,{"$f":"ROUND(G41*$B$1*(C42-C41),2)","v":{"v":3187.2,"d":"3187.20"}},8214.22,{"$f":"ROUND(G41-F42,2)","v":214445.79},{"$f":"D42/(1+$H$1)^A42","v":6702.270751331835}]
[39,"2024-03-09",24.188524590163933,11401.42,{"$f":"ROUND(G42*$B$1*(C43-C42),2)","v":2871.58},8529.84,{"$f":"ROUND(G42-F43,2)","v":205915.95},{"$f":"D43/(1+$H$1)^A43","v":6609.215950997068}]
[40,"2024-04-09",24.273224043715846,11401.42,{"$f":"ROUND(G43*$B$1*(C44-C43),2)","v":2947.52},{"v":8453.9,"d":"8453.90"},{"$f":"ROUND(G43-F44,2)","v":197462.05},{"$f":"D44/(1+$H$1)^A44","v":6517.453130080414}]
[41,"2024-05-09",24.3551912568306,11401.42,{"$f":"ROUND(G44*$B$1*(C45-C44),2)","v":2735.33},8666.09,{"$f":"ROUND(G44-F45,2)","v":188795.96},{"$f":"D45/(1+$H$1)^A45","v":6426.96435064841}]
[42,"2024-06-09",24.439890710382514,11401.42,{"$f":"ROUND(G45*$B$1*(C46-C45),2)","v":2702.46},8698.96,{"$f":"ROUND(G45-F46,2)","v":{"v":180097,"d":"180097.00"}},{"$f":"D46/(1+$H$1)^A46","v":6337.731923819129}]
[43,"2024-07-09",24.52185792349727,11401.42,{"$f":"ROUND(G46*$B$1*(C47-C46),2)","v":2494.79},8906.63,{"$f":"ROUND(G46-F47,2)","v":171190.37},{"$f":"D47/(1+$H$1)^A47","v":6249.738406304326}]
[44,"2024-08-09",24.60655737704918,11401.42,{"$f":"ROUND(G47*$B$1*(C48-C47),2)","v":2450.45},8950.97,{"$f":"ROUND(G47-F48,2)","v":{"v":162239.4,"d":"162239.40"}},{"$f":"D48/(1+$H$1)^A48","v":6162.966596999607}]
[45,"2024-09-09",24.69125683060109,11401.42,{"$f":"ROUND(G48*$B$1*(C49-C48),2)","v":2322.33},9079.09,{"$f":"ROUND(G48-F49,2)","v":153160.31},{"$f":"D49/(1+$H$1)^A49","v":6077.399533621919}]
[46,"2024-10-09",24.773224043715846,11401.42,{"$f":"ROUND(G49*$B$1*(C50-C49),2)","v":2121.65},9279.77,{"$f":"ROUND(G49-F50,2)","v":143880.54},{"$f":"D50/(1+$H$1)^A50","v":5993.02048939375}]
[47,"2024-11-09",24.85792349726776,11401.42,{"$f":"ROUND(G50*$B$1*(C51-C50),2)","v":2059.54},9341.88,{"$f":"ROUND(G50-F51,2)","v":134538.66},{"$f":"D51/(1+$H$1)^A51","v":5909.812969773347}]
[48,"2024-12-09",24.939890710382514,11401.42,{"$f":"ROUND(G51*$B$1*(C52-C51),2)","v":1863.69},9537.73,{"$f":"ROUND(G51-F52,2)","v":125000.93},{"$f":"D52/(1+$H$1)^A52","v":5827.760709230337}]
[49,"2025-01-09",25.024657534246575,11401.42,{"$f":"ROUND(G52*$B$1*(C53-C52),2)","v":1790.71},9610.71,{"$f":"ROUND(G52-F53,2)","v":115390.22},{"$f":"D53/(1+$H$1)^A53","v":5746.8476680661215}]
[50,"2025-02-09",25.10958904109589,11401.42,{"$f":"ROUND(G53*$B$1*(C54-C53),2)","v":1656.24},9745.18,{"$f":"ROUND(G53-F54,2)","v":105645.04},{"$f":"D54/(1+$H$1)^A54","v":5667.058029278411}]
[51,"2025-03-09",25.186301369863013,11401.42,{"$f":"ROUND(G54*$B$1*(C55-C54),2)","v":1369.62},{"v":10031.8,"d":"10031.80"},{"$f":"ROUND(G54-F55,2)","v":95613.24},{"$f":"D55/(1+$H$1)^A55","v":5588.376195469285}]
[52,"2025-04-09",25.27123287671233,11401.42,{"$f":"ROUND(G55*$B$1*(C56-C55),2)","v":1372.38},10029.04,{"$f":"ROUND(G55-F56,2)","v":{"v":85584.2,"d":"85584.20"}},{"$f":"D56/(1+$H$1)^A56","v":5510.786785796212}]
[53,"2025-05-09",25.353424657534248,11401.42,{"$f":"ROUND(G56*$B$1*(C57-C56),2)","v":{"v":1188.8,"d":"1188.80"}},10212.62,{"$f":"ROUND(G56-F57,2)","v":75371.58},{"$f":"D57/(1+$H$1)^A57","v":5434.2746329653455}]
[54,"2025-06-09",25.438356164383563,11401.42,{"$f":"ROUND(G57*$B$1*(C58-C57),2)","v":1081.84},10319.58,{"$f":"ROUND(G57-F58,2)","v":{"v":65052,"d":"65052.00"}},{"$f":"D58/(1+$H$1)^A58","v":5358.824780266634}]
[55,"2025-07-09",25.52054794520548,11401.42,{"$f":"ROUND(G58*$B$1*(C59-C58),2)","v":{"v":903.6,"d":"903.60"}},10497.82,{"$f":"ROUND(G58-F59,2)","v":54554.18},{"$f":"D59/(1+$H$1)^A59","v":5284.422478650033}]
[56,"2025-08-09",25.605479452054794,11401.42,{"$f":"ROUND(G59*$B$1*(C60-C59),2)","v":783.04},10618.38,{"$f":"ROUND(G59-F60,2)","v":{"v":43935.8,"d":"43935.80"}},{"$f":"D60/(1+$H$1)^A60","v":5211.053183842357}]
[57,"2025-09-09",25.69041095890411,11401.42,{"$f":"ROUND(G60*$B$1*(C61-C60),2)","v":630.63},10770.79,{"$f":"ROUND(G60-F61,2)","v":33165.01},{"$f":"D61/(1+$H$1)^A61","v":5138.702553504132}]
[58,"2025-10-09",25.77260273972603,11401.42,{"$f":"ROUND(G61*$B$1*(C62-C61),2)","v":460.68},10940.74,{"$f":"ROUND(G61-F62,2)","v":22224.27},{"$f":"D62/(1+$H$1)^A62","v":5067.356444425943}]
[59,"2025-11-09",25.85753424657534,11401.42,{"$f":"ROUND(G62*$B$1*(C63-C62),2)","v":318.99},11082.43,{"$f":"ROUND(G62-F63,2)","v":11141.84},{"$f":"D63/(1+$H$1)^A63","v":4997.000909763687}]
[60,"2025-12-09",25.93972602739726,{"v":11296.6,"d":"11296.60"},{"$f":"ROUND(G63*$B$1*(C64-C63),2)","v":154.76},11141.84,{"$f":"ROUND(G63-F64,2)","v":{"v":0,"d":"0.00"}},{"$f":"D64/(1+$H$1)^A64","v":4882.319649908588}]
[]
[null,"ПСК по 2008-У",null,{"$f":"XIRR(D4:D64,B4:B64)","v":{"v":0.18265575766563416,"d":"18.27%"}}]
[null,"ПСК по 6 ст. 353-ФЗ",null,{"$f":"IRR(D4:D64,0)*12","v":{"v":0.16895462522339985,"d":"16.895%"}}]
[null,"Точное значение ПСК",null,{"$f":"ПСК(D4:D64,C4:C64)","v":0.16899997074021664},"По научной работе Романенко Р.В. \"Формула ПСК\""]