{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Loan"],"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":"Loan","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,"Период",1]
[null,null,null,null,"Начало периода","2019-04-22"]
[null,null,null,null,"Конец периода",{"$f":"EDATE(F5,F4*12)","v":"2020-04-22"}]
[null,null,null,null,"Сумма переплаты по кредиту",{"$f":"SUM(INDIRECT(\"G\"&11):INDIRECT(\"G\"&F4*12+10))","v":-549.90646760115067}]
[null,null,null,null,"Сумма выплат за весь период",{"$f":"SUM(INDIRECT(\"f\"&11):INDIRECT(\"f\"&F4*12+10))","v":10549.906467601151}]
[null,null,null,"График выплат"]
[null,null,null,"Период","Дата платежа","Платеж","% по кредиту","тело долга","Остаток долга"]
[null,null,null,1,{"$f":"EDATE(F$5,D11)","v":"2019-05-22"},{"$f":"PMT($F$3/12,$F$4*12,$F$2)","v":879.15887230009594},{"$f":"F2*F3/12","v":-83.333333333333329},{"$f":"F11+G11","v":795.82553896676256},{"$f":"H11+F2","v":-9204.1744610332371}]
[null,null,null,2,{"$f":"EDATE(F$5,D12)","v":"2019-06-22"},{"$f":"PMT($F$3/12,$F$4*12,$F$2)","v":879.15887230009594},{"$f":"I11*$F$3/12","v":-76.701453841943646},{"$f":"F12+G12","v":802.45741845815223},{"$f":"I11+H12","v":-8401.7170425750846}]
[null,null,null,3,"2019-07-22",879.15887230009594,{"$f":"I12*$F$3/12","v":-70.014308688125709},{"$f":"F13+G13","v":809.14456361197017},{"$f":"I12+H13","v":-7592.5724789631149}]
[null,null,null,4,"2019-08-22",879.15887230009594,-63.271437324692634,815.88743497540327,-6776.6850439877117]
[null,null,null,5,"2019-09-22",879.15887230009594,-56.472375366564272,822.68649693353166,-5953.9985470541797]
[null,null,null,6,"2019-10-22",879.15887230009594,-49.61665455878483,829.54221774131111,-5124.4563293128685]
[null,null,null,7,"2019-11-22",879.15887230009594,-42.703802744273908,836.45506955582198,-4288.0012597570467]
[null,null,null,8,"2019-12-22",879.15887230009594,-35.733343831308723,843.42552846878721,-3444.5757312882597]
[null,null,null,9,"2020-01-22",879.15887230009594,-28.704797760735499,850.45407453936048,-2594.1216567488991]
[null,null,null,10,"2020-02-22",879.15887230009594,-21.617680472907495,857.54119182718841,-1736.5804649217107]
[null,null,null,11,"2020-03-22",879.15887230009594,-14.47150387434759,864.68736842574833,-871.89309649596237]
[null,null,null,12,"2020-04-22",879.15887230009594,-7.2657758041330203,871.89309649596294,0]
[null,null,null,13,"2020-05-22",879.15887230009594,0,879.15887230009594,879.15887230009594]
[null,null,null,14,"2020-06-22",879.15887230009594,7.3263239358341332,886.48519623593006,1765.644068536026]
[null,null,null,15,"2020-07-22",879.15887230009594,14.71370057113355,893.87257287122952,2659.5166414072555]
[null,null,null,16,"2020-08-22",879.15887230009594,22.162638678393794,901.32151097848975,3560.8381523857452]
[null,null,null,17,"2020-09-22",879.15887230009594,29.673651269881208,908.83252356997718,4469.6706759557219]
[null,null,null,18,"2020-10-22",879.15887230009594,37.247255632964347,916.40612793306025,5386.0768038887818]
[null,null,null,19,"2020-11-22",879.15887230009594,44.883973365739848,924.04284566583578,6310.1196495546174]
[null,null,null,20,"2020-12-22",879.15887230009594,52.584330412955147,931.74320271305112,7241.8628522676681]
[null,null,null,21,"2021-01-22",879.15887230009594,{"$f":"I30*$F$3/12","v":60.348857102230568},{"$f":"F31+G31","v":939.5077294023265},{"$f":"I30+H31","v":8181.3705816699949}]
[null,null,null,22,"2021-02-22",879.15887230009594,68.178088180583288,947.33696048067918,9128.7075421506743]
[null,null,null,23,"2021-03-22",879.15887230009594,76.072562851255626,955.23143515135155,10083.938977302027]
[null,null,null,24,"2021-04-22",879.15887230009594,84.032824810850229,963.19169711094617,11047.130674412972]
[null,null,null,25,"2021-05-22",879.15887230009594,92.059422286774762,971.21829458687068,12018.348968999842]
[null,null,null,26,"2021-06-22",879.15887230009594,100.15290807499868,979.3117803750946,12997.660749374936]
[null,null,null,27,"2021-07-22",879.15887230009594,108.31383957812447,987.47271187822037,13985.133461253157]
[null,null,null,28,"2021-08-22",879.15887230009594,116.54277884377632,995.70165114387225,14980.83511239703]
[null,null,null,29,"2021-09-22",879.15887230009594,124.84029260330858,1003.9991649034046,15984.834277300433]
[null,null,null,30,"2021-10-22",879.15887230009594,133.20695231083695,1012.3658246109329,16997.200101911367]
[null,null,null,31,"2021-11-22",879.15887230009594,141.64333418259471,1020.8022064826906,18018.002308394058]
[null,null,null,32,"2021-12-22",879.15887230009594,150.15001923661717,1029.3088915367132,19047.311199930769]
[null,null,null,33,"2022-01-22",879.15887230009594,158.72759333275641,1037.8864656328524,20085.197665563621]
[null,null,null,34,"2022-02-22",879.15887230009594,167.37664721303017,1046.535519513126,21131.733185076748]
[null,null,null,35,"2022-03-22",879.15887230009594,176.09777654230626,1055.2566488424022,22186.98983391915]
[null,null,null,36,"2022-04-22",879.15887230009594,184.89158194932625,1064.0504542494223,23251.040288168573]
[null,null,null,37,"2022-05-22",879.15887230009594,193.75866906807144,1072.9175413681673,24323.957829536739]
[null,null,null,38,"2022-06-22",879.15887230009594,202.69964857947284,1081.8585208795687,25405.816350416309]
[null,null,null,39,"2022-07-22",879.15887230009594,211.71513625346927,1090.8740085535651,26496.690358969874]
[null,null,null,40,"2022-08-22",879.15887230009594,220.80575299141563,1099.9646252915115,27596.654984261386]
[null,null,null,41,"2022-09-22",879.15887230009594,229.97212486884487,1109.1309971689409,28705.785981430327]
[null,null,null,42,"2022-10-22",879.15887230009594,239.21488317858606,1118.3737554786819,29824.159736909009]
[null,null,null,43,"2022-11-22",879.15887230009594,248.53466447424174,1127.6935367743376,30951.853273683348]
[null,null,null,44,"2022-12-22",879.15887230009594,257.93211061402792,1137.0909829141237,32088.944256597471]
[null,null,null,45,"2023-01-22",879.15887230009594,267.40786880497893,1146.5667411050749,33235.51099770255]
[null,null,null,46,"2023-02-22",879.15887230009594,276.96259164752126,1156.1214639476173,34391.632461650166]
[null,null,null,47,"2023-03-22",879.15887230009594,286.59693718041808,1165.755809480514,35557.38827113068]
[null,null,null,48,"2023-04-22",879.15887230009594,296.31156892608902,1175.4704412261849,36732.858712356865]
[null,null,null,49,"2023-05-22",879.15887230009594,306.10715593630721,1185.2660282364031,37918.124740593266]
[null,null,null,50,"2023-06-22",879.15887230009594,315.98437283827724,1195.1432451383732,39113.26798573164]
[null,null,null,51,"2023-07-22",879.15887230009594,325.94389988109702,1205.1027721811929,40318.370757912831]
[null,null,null,52,"2023-08-22",879.15887230009594,335.98642298260694,1215.1452952827028,41533.516053195533]
[null,null,null,53,"2023-09-22",879.15887230009594,346.11263377662948,1225.2715060767255,42758.787559272256]
[null,null,null,54,"2023-10-22",879.15887230009594,356.32322966060218,1235.4821019606982,43994.269661232953]
[null,null,null,55,"2023-11-22",879.15887230009594,366.61891384360797,1245.7777861437039,45240.047447376659]
[null,null,null,56,"2023-12-22",879.15887230009594,377.00039539480554,1256.1592676949015,46496.206715071559]
[null,null,null,57,"2024-01-22",879.15887230009594,387.468389292263,1266.627261592359,47762.833976663918]
[null,null,null,58,"2024-02-22",879.15887230009594,398.02361647219936,1277.1824887722953,49040.016465436216]
[null,null,null,59,"2024-03-22",879.15887230009594,408.66680387863516,1287.8256761787311,50327.84214161495]
[null,null,null,60,"2024-04-22",879.15887230009594,419.39868451345797,1298.5575568135539,51626.399698428504]
[null,null,null,61,"2024-05-22",879.15887230009594,430.21999748690422,1309.3788697870002,52935.778568215501]
[null,null,null,62,"2024-06-22",879.15887230009594,441.13148806846249,1320.2903603685584,54256.068928584056]
[null,null,null,63,"2024-07-22",879.15887230009594,452.13390773820055,1331.2927800382965,55587.361708622353]
[null,null,null,64,"2024-08-22",879.15887230009594,463.22801423851962,1342.3868865386155,56929.748595160971]
[null,null,null,65,"2024-09-22",879.15887230009594,{"$f":"I74*$F$3/12","v":474.41457162634146},{"$f":"F75+G75","v":1353.5734439264374},{"$f":"I74+H75","v":58283.322039087405}]
[null,null,null,66,{"$f":"EDATE(F$5,D76)","v":"2024-10-22"},{"$f":"PMT($F$3/12,$F$4*12,$F$2)","v":879.15887230009594},485.69435032572841,1364.8532226258244,59648.17526171323]
[null,null,null,67,"2024-11-22",879.15887230009594,497.06812718094358,1376.2269994810395,61024.402261194271]
[null,null,null,68,"2024-12-22",879.15887230009594,508.53668550995229,1387.6955578100483,62412.097819004317]
[null,null,null,69,"2025-01-22",879.15887230009594,520.1008151583693,1399.2596874584651,63811.35750646278]
[null,null,null,70,"2025-02-22",879.15887230009594,531.76131255385656,1410.9201848539524,65222.277691316733]
[null,null,null,71,"2025-03-22",879.15887230009594,543.51898076097279,1422.6778530610686,66644.955544377808]
[null,null,null,72,"2025-04-22",879.15887230009594,555.37462953648173,1434.5335018365777,68079.489046214381]
[null,null,null,73,"2025-05-22",879.15887230009594,567.32907538511984,1446.4879476852157,69525.976993899603]
[null,null,null,74,"2025-06-22",879.15887230009594,579.38314161583003,1458.542013915926,70984.519007815528]
[null,null,null,75,"2025-07-22",879.15887230009594,591.53765839846278,1470.6965306985587,72455.215538514094]
[null,null,null,76,"2025-08-22",879.15887230009594,603.79346282095082,1482.9523351210469,73938.167873635146]
[null,null,null,77,"2025-09-22",879.15887230009594,616.1513989469596,1495.3102712470554,75433.478144882203]
[null,null,null,78,"2025-10-22",879.15887230009594,628.61231787401846,1507.7711901741145,76941.249335056316]
[null,null,null,79,"2025-11-22",879.15887230009594,641.17707779213595,1520.335950092232,78461.585285148554]
[null,null,null,80,"2025-12-22",879.15887230009594,653.84654404290461,1533.0054163430004,79994.590701491557]
[null,null,null,81,"2026-01-22",879.15887230009594,666.6215891790963,1545.7804614791921,81540.371162970754]
[null,null,null,82,"2026-02-22",879.15887230009594,679.50309302475637,1558.6619653248522,83099.033128295603]
[null,null,null,83,"2026-03-22",879.15887230009594,692.49194273579678,1571.6508150358927,84670.683943331489]
[null,null,null,84,"2026-04-22",879.15887230009594,705.5890328610958,1584.7479051611917,86255.431848492677]
[null,null,null,85,"2026-05-22",879.15887230009594,718.79526540410563,1597.9541377042015,87853.385986196881]
[null,null,null,86,"2026-06-22",879.15887230009594,732.11154988497401,1611.2704221850699,89464.656408381954]
[null,null,null,87,"2026-07-22",879.15887230009594,745.53880340318301,1624.6976757032789,91089.354084085237]
[null,null,null,88,"2026-08-22",879.15887230009594,759.0779507007104,1638.2368230008065,92727.590907086036]
[null,null,null,89,"2026-09-22",879.15887230009594,772.7299242257169,1651.8887965258127,94379.479703611854]
[null,null,null,90,"2026-10-22",879.15887230009594,786.49566419676546,1665.6545364968615,96045.134240108717]
[null,null,null,91,"2026-11-22",879.15887230009594,800.37611866757277,1679.5349909676688,97724.66923107639]
[null,null,null,92,"2026-12-22",879.15887230009594,814.37224359230322,1693.5311158923992,99418.200346968792]
[null,null,null,93,"2027-01-22",879.15887230009594,828.48500289140668,1707.6438751915025,101125.84422216029]
[null,null,null,94,"2027-02-22",879.15887230009594,842.71536851800249,1721.8742408180983,102847.71846297839]
[null,null,null,95,"2027-03-22",879.15887230009594,857.06432052481989,1736.2231928249157,104583.9416558033]
[null,null,null,96,"2027-04-22",879.15887230009594,871.53284713169421,1750.6917194317903,106334.63337523509]
[null,null,null,97,"2027-05-22",879.15887230009594,886.12194479362586,1765.2808170937219,108099.91419232881]
[null,null,null,98,"2027-06-22",879.15887230009594,900.83261826940679,1779.9914905695027,109879.90568289832]
[null,null,null,99,"2027-07-22",879.15887230009594,915.66588069081934,1794.8247529909154,111674.73043588923]
[null,null,null,100,"2027-08-22",879.15887230009594,930.62275363241031,1809.7816259325064,113484.51206182173]
[null,null,null,101,"2027-09-22",879.15887230009594,945.70426718184774,1824.8631394819436,115309.37520130367]
[null,null,null,102,"2027-10-22",879.15887230009594,960.91146001086406,1840.0703323109601,117149.44553361463]
[null,null,null,103,"2027-11-22",879.15887230009594,976.24537944678866,1855.4042517468847,119004.84978536153]
[null,null,null,104,"2027-12-22",879.15887230009594,991.70708154467945,1870.8659538447755,120875.71573920629]
[null,null,null,105,"2028-01-22",879.15887230009594,1007.2976311600524,1886.4565034601483,122762.17224266645]
[null,null,null,106,"2028-02-22",879.15887230009594,1023.0181020222204,1902.1769743223163,124664.34921698876]
[null,null,null,107,"2028-03-22",879.15887230009594,1038.8695768082398,1918.0284491083357,126582.37766609709]
[null,null,null,108,"2028-04-22",879.15887230009594,1054.8531472174757,1934.0120195175716,128516.38968561466]
[null,null,null,109,"2028-05-22",879.15887230009594,1070.969914046789,1950.1287863468849,130466.51847196155]
[null,null,null,110,"2028-06-22",879.15887230009594,1087.2209872663464,1966.3798595664423,132432.89833152801]
[null,null,null,111,"2028-07-22",879.15887230009594,1103.6074860960669,1982.7663583961628,134415.66468992416]
[null,null,null,112,"2028-08-22",879.15887230009594,1120.1305390827013,1999.2894113827972,136414.95410130697]
[null,null,null,113,"2028-09-22",879.15887230009594,1136.7912841775581,2015.950156477654,138430.90425778463]
[null,null,null,114,"2028-10-22",879.15887230009594,1153.590868814872,2032.7497411149679,140463.65399889959]
[null,null,null,115,"2028-11-22",879.15887230009594,1170.53044999083,2049.6893222909257,142513.34332119051]
[null,null,null,116,"2028-12-22",879.15887230009594,1187.6111943432543,2066.7700666433502,144580.11338783384]
[null,null,null,117,"2029-01-22",879.15887230009594,1204.8342782319487,2083.9931505320446,146664.10653836589]
[null,null,null,118,"2029-02-22",879.15887230009594,1222.2008878197157,2101.3597601198117,148765.4662984857]
[null,null,null,119,"2029-03-22",879.15887230009594,1239.7122191540475,2118.8710914541434,150884.33738993984]
[null,null,null,120,"2029-04-22",879.15887230009594,1257.3694782494988,2136.5283505495945,153020.86574048945]
[null,null,null,null,null,{"$f":"SUM(F10:F130)","v":105499.06467601127},{"$f":"SUM(G10:G130)","v":57521.801064477913},{"$f":"SUM(H10:H130)","v":163020.86574048945}]