{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"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":"Лист1","index":0,"n_rows":131,"n_cols":9,"rows_kept":131,"cut":false,"hidden":false,"merged":[[8,3,8,8]]}
[]
[null,null,null,null,"Кредит",-10000]
[null,null,null,null,"Процент",0.1]
[null,null,null,null,"Период",10]
[null,null,null,null,"Начало периода","2019-04-19"]
[null,null,null,null,"Конец периода",{"$f":"EDATE(F5,F4*12)","v":"2029-04-19"}]
[null,null,null,null,"Сумма переплаты по кредиту",{"$f":"G131","v":-5858.0884258114029}]
[null,null,null,null,"Сумма выплат за весь период",{"$f":"F131","v":15858.088425811426}]
[null,null,null,"График выплат"]
[null,null,null,"Период","Дата платежа","Платеж","% по кредиту","тело долга","Остаток долга"]
[null,null,null,1,{"$f":"EDATE(F$5,D11)","v":"2019-05-19"},{"$f":"PMT($F$3/12,$F$4*12,$F$2)","v":132.15073688176165},{"$f":"F2*F3/12","v":-83.333333333333329},{"$f":"F11+G11","v":48.817403548428317},{"$f":"H11+F2","v":-9951.182596451572}]
[null,null,null,2,{"$f":"EDATE(F$5,D12)","v":"2019-06-19"},{"$f":"PMT($F$3/12,$F$4*12,$F$2)","v":132.15073688176165},{"$f":"I11*$F$3/12","v":-82.926521637096428},{"$f":"F12+G12","v":49.224215244665217},{"$f":"I11+H12","v":-9901.9583812069068}]
[null,null,null,3,"2019-07-19",132.15073688176165,{"$f":"I12*$F$3/12","v":-82.516319843390889},{"$f":"F13+G13","v":49.634417038370756},{"$f":"I12+H13","v":-9852.3239641685359}]
[null,null,null,4,"2019-08-19",132.15073688176165,-82.102699701404461,50.048037180357184,-9802.275926988179]
[null,null,null,5,"2019-09-19",132.15073688176165,-81.685632724901495,50.46510415686015,-9751.8108228313195]
[null,null,null,6,"2019-10-19",132.15073688176165,-81.265090190261006,50.885646691500639,-9700.9251761398191]
[null,null,null,7,"2019-11-19",132.15073688176165,-80.841043134498491,51.309693747263154,-9649.6154823925554]
[null,null,null,8,"2019-12-19",132.15073688176165,-80.413462353271299,51.737274528490346,-9597.8782078640652]
[null,null,null,9,"2020-01-19",132.15073688176165,-79.982318398867207,52.168418482894438,-9545.7097893811715]
[null,null,null,10,"2020-02-19",132.15073688176165,-79.547581578176434,52.603155303585211,-9493.1066340775869]
[null,null,null,11,"2020-03-19",132.15073688176165,-79.109221950646557,53.041514931115088,-9440.0651191464713]
[null,null,null,12,"2020-04-19",132.15073688176165,-78.6672093262206,53.483527555541045,-9386.5815915909297]
[null,null,null,13,"2020-05-19",132.15073688176165,-78.221513263257748,53.929223618503897,-9332.6523679724251]
[null,null,null,14,"2020-06-19",132.15073688176165,-77.772103066436884,54.378633815324761,-9278.273734157101]
[null,null,null,15,"2020-07-19",132.15073688176165,-77.318947784642504,54.831789097119142,-9223.4419450599817]
[null,null,null,16,"2020-08-19",132.15073688176165,-76.862016208833182,55.288720672928463,-9168.1532243870533]
[null,null,null,17,"2020-09-19",132.15073688176165,-76.401276869892115,55.74946001186953,-9112.4037643751835]
[null,null,null,18,"2020-10-19",132.15073688176165,-75.936698036459873,56.214038845301772,-9056.1897255298809]
[null,null,null,19,"2020-11-19",132.15073688176165,-75.468247712749005,56.682489169012641,-8999.5072363608688]
[null,null,null,20,"2020-12-19",132.15073688176165,-74.995893636340568,57.154843245421077,-8942.3523931154468]
[null,null,null,21,"2021-01-19",132.15073688176165,{"$f":"I30*$F$3/12","v":-74.519603275962069},{"$f":"F31+G31","v":57.631133605799576},{"$f":"I30+H31","v":-8884.721259509648}]
[null,null,null,22,"2021-02-19",132.15073688176165,-74.039343829247073,58.111393052514572,-8826.6098664571327]
[null,null,null,23,"2021-03-19",132.15073688176165,-73.555082220476109,58.595654661285536,-8768.0142117958476]
[null,null,null,24,"2021-04-19",132.15073688176165,-73.066785098298737,59.083951783462908,-8708.9302600123847]
[null,null,null,25,"2021-05-19",132.15073688176165,-72.574418833436539,59.576318048325106,-8649.3539419640601]
[null,null,null,26,"2021-06-19",132.15073688176165,-72.07794951636717,60.072787365394476,-8589.281154598666]
[null,null,null,27,"2021-07-19",132.15073688176165,-71.577342954988879,60.573393926772766,-8528.707760671894]
[null,null,null,28,"2021-08-19",132.15073688176165,-71.072564672265784,61.078172209495861,-8467.6295884623978]
[null,null,null,29,"2021-09-19",132.15073688176165,-70.563579903853324,61.587156977908322,-8406.0424314844895]
[null,null,null,30,"2021-10-19",132.15073688176165,-70.050353595704081,62.100383286057564,-8343.9420481984325]
[null,null,null,31,"2021-11-19",132.15073688176165,-69.532850401653604,62.617886480108041,-8281.3241617183248]
[null,null,null,32,"2021-12-19",132.15073688176165,-69.011034680986043,63.139702200775602,-8218.1844595175498]
[null,null,null,33,"2022-01-19",132.15073688176165,-68.484870495979592,63.665866385782053,-8154.5185931317674]
[null,null,null,34,"2022-02-19",132.15073688176165,-67.954321609431403,64.196415272330242,-8090.322177859437]
[null,null,null,35,"2022-03-19",132.15073688176165,-67.419351482161986,64.73138539959966,-8025.5907924598378]
[null,null,null,36,"2022-04-19",132.15073688176165,-66.879923270498651,65.270813611262994,-7960.3199788485745]
[null,null,null,37,"2022-05-19",132.15073688176165,-66.335999823738121,65.814737058023525,-7894.5052417905508]
[null,null,null,38,"2022-06-19",132.15073688176165,-65.787543681587934,66.363193200173711,-7828.1420485903773]
[null,null,null,39,"2022-07-19",132.15073688176165,-65.234517071586481,66.916219810175164,-7761.2258287802024]
[null,null,null,40,"2022-08-19",132.15073688176165,-64.676881906501691,67.473854975259954,-7693.7519738049423]
[null,null,null,41,"2022-09-19",132.15073688176165,-64.114599781707852,68.036137100053793,-7625.7158367048887]
[null,null,null,42,"2022-10-19",132.15073688176165,-63.547631972540749,68.603104909220889,-7557.112731795668]
[null,null,null,43,"2022-11-19",132.15073688176165,-62.975939431630572,69.174797450131081,-7487.9379343455366]
[null,null,null,44,"2022-12-19",132.15073688176165,-62.399482786212808,69.75125409554883,-7418.1866802499881]
[null,null,null,45,"2023-01-19",132.15073688176165,-61.818222335416571,70.332514546345067,-7347.854165703643]
[null,null,null,46,"2023-02-19",132.15073688176165,-61.232118047530356,70.918618834231296,-7276.9355468694121]
[null,null,null,47,"2023-03-19",132.15073688176165,-60.641129557245108,71.509607324516537,-7205.4259395448953]
[null,null,null,48,"2023-04-19",132.15073688176165,-60.045216162874134,72.105520718887504,-7133.3204188260079]
[null,null,null,49,"2023-05-19",132.15073688176165,-59.444336823550067,72.706400058211585,-7060.6140187677966]
[null,null,null,50,"2023-06-19",132.15073688176165,-58.838450156398302,73.31228672536335,-6987.3017320424333]
[null,null,null,51,"2023-07-19",132.15073688176165,-58.227514433686942,73.923222448074711,-6913.3785095943585]
[null,null,null,52,"2023-08-19",132.15073688176165,-57.611487579952986,74.539249301808667,-6838.8392602925496]
[null,null,null,53,"2023-09-19",132.15073688176165,-56.990327169104582,75.160409712657071,-6763.6788505798922]
[null,null,null,54,"2023-10-19",132.15073688176165,-56.363990421499103,75.786746460262549,-6687.8921041196299]
[null,null,null,55,"2023-11-19",132.15073688176165,-55.73243420099692,76.418302680764725,-6611.4738014388649]
[null,null,null,56,"2023-12-19",132.15073688176165,-55.095615011990539,77.055121869771114,-6534.4186795690939]
[null,null,null,57,"2024-01-19",132.15073688176165,-54.453488996409114,77.697247885352539,-6456.7214316837417]
[null,null,null,58,"2024-02-19",132.15073688176165,-53.806011930697849,78.344724951063796,-6378.376706732678]
[null,null,null,59,"2024-03-19",132.15073688176165,-53.153139222772325,78.997597658989321,-6299.3791090736886]
[null,null,null,60,"2024-04-19",132.15073688176165,-52.494825908947405,79.65591097281424,-6219.7231981008745]
[null,null,null,61,"2024-05-19",132.15073688176165,-51.83102665084062,80.319710230921032,-6139.4034878699531]
[null,null,null,62,"2024-06-19",132.15073688176165,-51.161695732249619,80.989041149512019,-6058.4144467204414]
[null,null,null,63,"2024-07-19",132.15073688176165,-50.486787056003685,81.663949825757953,-5976.7504968946832]
[null,null,null,64,"2024-08-19",132.15073688176165,-49.806254140789029,82.344482740972609,-5894.4060141537102]
[null,null,null,65,"2024-09-19",132.15073688176165,{"$f":"I74*$F$3/12","v":-49.120050117947585},{"$f":"F75+G75","v":83.03068676381406},{"$f":"I74+H75","v":-5811.3753273898965}]
[null,null,null,66,{"$f":"EDATE(F$5,D76)","v":"2024-10-19"},{"$f":"PMT($F$3/12,$F$4*12,$F$2)","v":132.15073688176165},-48.428127728249137,83.722609153512508,-5727.6527182363843]
[null,null,null,67,"2024-11-19",132.15073688176165,-47.730439318636542,84.420297563125104,-5643.2324206732592]
[null,null,null,68,"2024-12-19",132.15073688176165,-47.026936838943833,85.123800042817805,-5558.1086206304417]
[null,null,null,69,"2025-01-19",132.15073688176165,-46.317571838587014,85.833165043174631,-5472.2754555872671]
[null,null,null,70,"2025-02-19",132.15073688176165,-45.602295463227229,86.548441418534424,-5385.7270141687322]
[null,null,null,71,"2025-03-19",132.15073688176165,-44.881058451406098,87.269678430355555,-5298.457335738377]
[null,null,null,72,"2025-04-19",132.15073688176165,-44.153811131153141,87.996925750608511,-5210.4604099877688]
[null,null,null,73,"2025-05-19",132.15073688176165,-43.420503416564742,88.730233465196903,-5121.730176522572]
[null,null,null,74,"2025-06-19",132.15073688176165,-42.681084804354775,89.469652077406863,-5032.2605244451652]
[null,null,null,75,"2025-07-19",132.15073688176165,-41.935504370376378,90.215232511385267,-4942.0452919337795]
[null,null,null,76,"2025-08-19",132.15073688176165,-41.183710766114835,90.967026115646803,-4851.0782658181324]
[null,null,null,77,"2025-09-19",132.15073688176165,-40.425652215151104,91.725084666610542,-4759.3531811515222]
[null,null,null,78,"2025-10-19",132.15073688176165,-39.661276509596021,92.489460372165624,-4666.8637207793563]
[null,null,null,79,"2025-11-19",132.15073688176165,-38.890531006494633,93.260205875267019,-4573.603514904089]
[null,null,null,80,"2025-12-19",132.15073688176165,-38.11336262420074,94.037374257560913,-4479.5661406465279]
[null,null,null,81,"2026-01-19",132.15073688176165,-37.329717838721066,94.821019043040579,-4384.745121603487]
[null,null,null,82,"2026-02-19",132.15073688176165,-36.539542680029058,95.611194201732587,-4289.1339274017546]
[null,null,null,83,"2026-03-19",132.15073688176165,-35.742782728347954,96.407954153413698,-4192.7259732483408]
[null,null,null,84,"2026-04-19",132.15073688176165,-34.939383110402844,97.211353771358802,-4095.5146194769818]
[null,null,null,85,"2026-05-19",132.15073688176165,-34.129288495641518,98.021448386120127,-3997.4931710908618]
[null,null,null,86,"2026-06-19",132.15073688176165,-33.312443092423848,98.838293789337797,-3898.6548773015238]
[null,null,null,87,"2026-07-19",132.15073688176165,-32.488790644179367,99.661946237582271,-3798.9929310639413]
[null,null,null,88,"2026-08-19",132.15073688176165,-31.658274425532849,100.49246245622879,-3698.5004686077127]
[null,null,null,89,"2026-09-19",132.15073688176165,-30.820837238397605,101.32989964336404,-3597.1705689643486]
[null,null,null,90,"2026-10-19",132.15073688176165,-29.976421408036241,102.1743154737254,-3494.9962534906231]
[null,null,null,91,"2026-11-19",132.15073688176165,-29.12496877908853,103.02576810267311,-3391.9704853879498]
[null,null,null,92,"2026-12-19",132.15073688176165,-28.266420711566251,103.88431617019539,-3288.0861692177546]
[null,null,null,93,"2027-01-19",132.15073688176165,-27.400718076814623,104.75001880494702,-3183.3361504128075]
[null,null,null,94,"2027-02-19",132.15073688176165,-26.527801253440064,105.62293562832158,-3077.7132147844859]
[null,null,null,95,"2027-03-19",132.15073688176165,-25.64761012320405,106.5031267585576,-2971.2100880259281]
[null,null,null,96,"2027-04-19",132.15073688176165,-24.760084066882737,107.39065281487891,-2863.819435211049]
[null,null,null,97,"2027-05-19",132.15073688176165,-23.865161960092077,108.28557492166956,-2755.5338602893794]
[null,null,null,98,"2027-06-19",132.15073688176165,-22.962782169078164,109.18795471268348,-2646.3459055766957]
[null,null,null,99,"2027-07-19",132.15073688176165,-22.052882546472464,110.09785433528918,-2536.2480512414068]
[null,null,null,100,"2027-08-19",132.15073688176165,-21.135400427011724,111.01533645474993,-2425.2327147866567]
[null,null,null,101,"2027-09-19",132.15073688176165,-20.210272623222142,111.94046425853951,-2313.2922505281172]
[null,null,null,102,"2027-10-19",132.15073688176165,-19.277435421067644,112.87330146069399,-2200.418949067423]
[null,null,null,103,"2027-11-19",132.15073688176165,-18.33682457556186,113.81391230619978,-2086.6050367612233]
[null,null,null,104,"2027-12-19",132.15073688176165,-17.38837530634353,114.76236157541811,-1971.8426751858053]
[null,null,null,105,"2028-01-19",132.15073688176165,-16.432022293215045,115.7187145885466,-1856.1239605972587]
[null,null,null,106,"2028-02-19",132.15073688176165,-15.467699671643823,116.68303721011782,-1739.4409233871409]
[null,null,null,107,"2028-03-19",132.15073688176165,-14.495341028226173,117.65539585353547,-1621.7855275336053]
[null,null,null,108,"2028-04-19",132.15073688176165,-13.514879396113379,118.63585748564827,-1503.149670047957]
[null,null,null,109,"2028-05-19",132.15073688176165,-12.526247250399642,119.624489631362,-1383.525180416595]
[null,null,null,110,"2028-06-19",132.15073688176165,-11.529376503471626,120.62136037829002,-1262.903820038305]
[null,null,null,111,"2028-07-19",132.15073688176165,-10.524198500319208,121.62653838144243,-1141.2772816568624]
[null,null,null,112,"2028-08-19",132.15073688176165,-9.5106440138071875,122.64009286795445,-1018.637188788908]
[null,null,null,113,"2028-09-19",132.15073688176165,-8.4886432399075673,123.66209364185409,-894.97509514705393]
[null,null,null,114,"2028-10-19",132.15073688176165,-7.4581257928921163,124.69261108886953,-770.28248405818442]
[null,null,null,115,"2028-11-19",132.15073688176165,-6.4190207004848707,125.73171618127678,-644.55076787690768]
[null,null,null,116,"2028-12-19",132.15073688176165,-5.3712563989742312,126.77948048278742,-517.77128739412024]
[null,null,null,117,"2029-01-19",132.15073688176165,-4.3147607282843357,127.8359761534773,-389.93531124064293]
[null,null,null,118,"2029-02-19",132.15073688176165,-3.2494609270053583,128.9012759547563,-261.0340352858866]
[null,null,null,119,"2029-03-19",132.15073688176165,-2.1752836273823886,129.97545325437926,-131.05858203150734]
[null,null,null,120,"2029-04-19",132.15073688176165,-1.0921548502625613,131.05858203149907,-8.2707174442475662E-12]
[null,null,null,null,null,{"$f":"SUM(F10:F130)","v":15858.088425811426},{"$f":"SUM(G10:G130)","v":-5858.0884258114029},{"$f":"SUM(H10:H130)","v":9999.9999999999945}]