{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["דוגמאות מרצה שאלות 1-6","תרגול עצמי שאלות 7-11","שאלות סיכום  12-15","שאלות מבחינות 16-19"],"read":"whole","date_system":"1900"}

{"sheet":"דוגמאות מרצה שאלות 1-6","index":0,"n_rows":221,"n_cols":27,"rows_kept":221,"merged":[[0,8,0,17]]}
[{"$nulls":8},"לוחות סילוקין"]
[]
[{"$nulls":4},"שאלה 1"]
[{"$nulls":21},"שפיצר"]
[]
[]
[{"$nulls":8},"נתונים:",{"$nulls":12},"נתונים:"]
[{"$nulls":8},"הלוואה",{"v":600000,"d":"600,000"},"PV",{"$nulls":10},"הלוואה",{"v":1000,"d":"1,000"},"PV"]
[{"$nulls":8},"חודשים",30,"n",{"$nulls":10},"מספר תקופות",5,"n"]
[{"$nulls":8},"ריבית",{"v":0.003,"d":"0.30%"},"r",{"$nulls":10},"ריבית",{"v":0.1,"d":"10.00%"},"r"]
[{"$nulls":9},{"$f":"PMT(J10,J9,-J8,,)","v":{"v":20943.462998887866,"d":"₪ 20,943.46"}},"PMT",{"$nulls":11},{"$f":"PMT(W10,W9,-W8,,)","v":{"v":263.7974807947454,"d":"₪ 263.80"}},"PMT"]
[{"$nulls":8},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה",{"$nulls":7},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":8},1,{"$f":"J8","v":{"v":600000,"d":"₪ 600,000.00"}},{"$f":"M13-L13","v":{"v":19143.462998887866,"d":"₪ 19,143.46"}},{"$f":"$J$10*J13","v":{"v":1800,"d":"₪ 1,800.00"}},{"$f":"$J$11","v":{"v":20943.462998887866,"d":"₪ 20,943.46"}},{"$f":"J13-K13","v":{"v":580856.5370011121,"d":"₪ 580,856.54"}},{"$nulls":7},1,{"$f":"W8","v":{"v":1000,"d":"₪ 1,000.00"}},{"$f":"Z13-Y13","v":{"v":163.7974807947454,"d":"₪ 163.80"}},{"$f":"$W$10*W13","v":{"v":100,"d":"₪ 100.00"}},{"$f":"$W$11","v":{"v":263.7974807947454,"d":"₪ 263.80"}},{"$f":"W13-X13","v":{"v":836.2025192052546,"d":"₪ 836.20"}}]
[{"$nulls":8},2,{"$f":"N13","v":{"v":580856.5370011121,"d":"₪ 580,856.54"}},{"$f":"M14-L14","v":{"v":19200.89338788453,"d":"₪ 19,200.89"}},{"$f":"$J$10*J14","v":{"v":1742.5696110033364,"d":"₪ 1,742.57"}},{"$f":"$J$11","v":{"v":20943.462998887866,"d":"₪ 20,943.46"}},{"$f":"J14-K14","v":{"v":561655.6436132276,"d":"₪ 561,655.64"}},{"$nulls":7},2,{"$f":"AA13","v":{"v":836.2025192052546,"d":"₪ 836.20"}},{"$f":"Z14-Y14","v":{"v":180.17722887421996,"d":"₪ 180.18"}},{"$f":"$W$10*W14","v":{"v":83.62025192052546,"d":"₪ 83.62"}},{"$f":"$W$11","v":{"v":263.7974807947454,"d":"₪ 263.80"}},{"$f":"W14-X14","v":{"v":656.0252903310346,"d":"₪ 656.03"}}]
[{"$nulls":8},3,{"$f":"N14","v":{"v":561655.6436132276,"d":"₪ 561,655.64"}},{"v":19258.49606804818,"d":"₪ 19,258.50"},{"v":1684.966930839683,"d":"₪ 1,684.97"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":542397.1475451795,"d":"₪ 542,397.15"},{"$nulls":7},3,{"$f":"AA14","v":{"v":656.0252903310346,"d":"₪ 656.03"}},{"v":198.19495176164196,"d":"₪ 198.19"},{"v":65.60252903310347,"d":"₪ 65.60"},{"v":263.7974807947454,"d":"₪ 263.80"},{"v":457.83033856939267,"d":"₪ 457.83"}]
[{"$nulls":8},4,{"v":542397.1475451795,"d":"₪ 542,397.15"},{"v":19316.271556252326,"d":"₪ 19,316.27"},{"v":1627.1914426355384,"d":"₪ 1,627.19"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":523080.87598892715,"d":"₪ 523,080.88"},{"$nulls":7},4,{"v":457.83033856939267,"d":"₪ 457.83"},{"v":218.01444693780616,"d":"₪ 218.01"},{"v":45.78303385693927,"d":"₪ 45.78"},{"v":263.7974807947454,"d":"₪ 263.80"},{"v":239.8158916315865,"d":"₪ 239.82"}]
[{"$nulls":8},5,{"v":523080.87598892715,"d":"₪ 523,080.88"},{"v":19374.220370921084,"d":"₪ 19,374.22"},{"v":1569.2426279667816,"d":"₪ 1,569.24"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":503706.6556180061,"d":"₪ 503,706.66"},{"$nulls":7},5,{"v":239.8158916315865,"d":"₪ 239.82"},{"v":239.81589163158677,"d":"₪ 239.82"},{"v":23.981589163158652,"d":"₪ 23.98"},{"v":263.7974807947454,"d":"₪ 263.80"},{"v":-2.5579538487363607E-13,"d":"₪ -0.00"}]
[{"$nulls":8},6,{"v":503706.6556180061,"d":"₪ 503,706.66"},{"$f":"M18-L18","v":{"v":19432.34303203385,"d":"₪ 19,432.34"}},{"v":1511.1199668540182,"d":"₪ 1,511.12"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":484274.31258597225,"d":"₪ 484,274.31"}]
[{"$nulls":8},7,{"v":484274.31258597225,"d":"₪ 484,274.31"},{"v":19490.64006112995,"d":"₪ 19,490.64"},{"v":1452.8229377579169,"d":"₪ 1,452.82"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":464783.6725248423,"d":"₪ 464,783.67"}]
[{"$nulls":8},8,{"v":464783.6725248423,"d":"₪ 464,783.67"},{"v":19549.111981313337,"d":"₪ 19,549.11"},{"v":1394.351017574527,"d":"₪ 1,394.35"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":445234.560543529,"d":"₪ 445,234.56"}]
[{"$nulls":8},9,{"v":445234.560543529,"d":"₪ 445,234.56"},{"v":19607.759317257278,"d":"₪ 19,607.76"},{"v":1335.703681630587,"d":"₪ 1,335.70"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":425626.8012262717,"d":"₪ 425,626.80"},{"$nulls":7},"לוח סילוקין רגיל"]
[{"$nulls":8},10,{"v":425626.8012262717,"d":"₪ 425,626.80"},{"v":19666.582595209053,"d":"₪ 19,666.58"},{"v":1276.8804036788151,"d":"₪ 1,276.88"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":405960.21863106266,"d":"₪ 405,960.22"}]
[{"$nulls":8},11,{"v":405960.21863106266,"d":"₪ 405,960.22"},{"v":19725.58234299468,"d":"₪ 19,725.58"},{"v":1217.880655893188,"d":"₪ 1,217.88"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":386234.63628806797,"d":"₪ 386,234.64"}]
[{"$nulls":8},12,{"v":386234.63628806797,"d":"₪ 386,234.64"},{"v":19784.75909002366,"d":"₪ 19,784.76"},{"v":1158.7039088642039,"d":"₪ 1,158.70"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":366449.8771980443,"d":"₪ 366,449.88"},{"$nulls":7},"נתונים:"]
[{"$nulls":8},13,{"v":366449.8771980443,"d":"₪ 366,449.88"},{"v":19844.113367293732,"d":"₪ 19,844.11"},{"v":1099.349631594133,"d":"₪ 1,099.35"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":346605.7638307506,"d":"₪ 346,605.76"},{"$nulls":7},"הלוואה",{"v":1000,"d":"1,000"},"PV"]
[{"$nulls":8},14,{"v":346605.7638307506,"d":"₪ 346,605.76"},{"v":19903.645707395615,"d":"₪ 19,903.65"},{"v":1039.8172914922518,"d":"₪ 1,039.82"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":326702.118123355,"d":"₪ 326,702.12"},{"$nulls":7},"מספר תקופות",5,"n"]
[{"$nulls":8},15,{"v":326702.118123355,"d":"₪ 326,702.12"},{"v":19963.3566445178,"d":"₪ 19,963.36"},{"v":980.106354370065,"d":"₪ 980.11"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":306738.7614788372,"d":"₪ 306,738.76"},{"$nulls":7},"ריבית",{"v":0.1,"d":"10.00%"},"r"]
[{"$nulls":8},16,{"v":306738.7614788372,"d":"₪ 306,738.76"},{"v":20023.246714451354,"d":"₪ 20,023.25"},{"v":920.2162844365115,"d":"₪ 920.22"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":286715.5147643858,"d":"₪ 286,715.51"},{"$nulls":8},{"$f":"W25/W26","v":200},"קרן קבועה"]
[{"$nulls":8},17,{"v":286715.5147643858,"d":"₪ 286,715.51"},{"v":20083.316454594707,"d":"₪ 20,083.32"},{"v":860.1465442931575,"d":"₪ 860.15"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":266632.1983097911,"d":"₪ 266,632.20"},{"$nulls":7},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":8},18,{"v":266632.1983097911,"d":"₪ 266,632.20"},{"v":20143.56640395849,"d":"₪ 20,143.57"},{"v":799.8965949293734,"d":"₪ 799.90"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":246488.63190583262,"d":"₪ 246,488.63"},{"$nulls":7},1,{"$f":"W25","v":{"v":1000,"d":"₪ 1,000.00"}},{"$f":"$W$28","v":{"v":200,"d":"₪ 200.00"}},{"$f":"$W$27*W30","v":{"v":100,"d":"₪ 100.00"}},{"$f":"X30+Y30","v":{"v":300,"d":"₪ 300.00"}},{"$f":"W30-X30","v":{"v":800,"d":"₪ 800.00"}}]
[{"$nulls":8},19,{"v":246488.63190583262,"d":"₪ 246,488.63"},{"v":20203.997103170368,"d":"₪ 20,204.00"},{"v":739.4658957174979,"d":"₪ 739.47"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":226284.63480266224,"d":"₪ 226,284.63"},{"$nulls":7},2,{"$f":"AA30","v":{"v":800,"d":"₪ 800.00"}},{"$f":"$W$28","v":{"v":200,"d":"₪ 200.00"}},{"$f":"$W$27*W31","v":{"v":80,"d":"₪ 80.00"}},{"$f":"X31+Y31","v":{"v":280,"d":"₪ 280.00"}},{"$f":"W31-X31","v":{"v":600,"d":"₪ 600.00"}}]
[{"$nulls":8},20,{"v":226284.63480266224,"d":"₪ 226,284.63"},{"v":20264.609094479878,"d":"₪ 20,264.61"},{"v":678.8539044079868,"d":"₪ 678.85"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":206020.02570818237,"d":"₪ 206,020.03"},{"$nulls":7},3,{"$f":"AA31","v":{"v":600,"d":"₪ 600.00"}},{"v":200,"d":"₪ 200.00"},{"v":60,"d":"₪ 60.00"},{"v":260,"d":"₪ 260.00"},{"v":400,"d":"₪ 400.00"}]
[{"$nulls":8},21,{"v":206020.02570818237,"d":"₪ 206,020.03"},{"v":20325.402921763318,"d":"₪ 20,325.40"},{"v":618.0600771245471,"d":"₪ 618.06"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":185694.62278641906,"d":"₪ 185,694.62"},{"$nulls":7},4,{"v":400,"d":"₪ 400.00"},{"v":200,"d":"₪ 200.00"},{"v":40,"d":"₪ 40.00"},{"v":240,"d":"₪ 240.00"},{"v":200,"d":"₪ 200.00"}]
[{"$nulls":8},22,{"v":185694.62278641906,"d":"₪ 185,694.62"},{"v":20386.37913052861,"d":"₪ 20,386.38"},{"v":557.0838683592572,"d":"₪ 557.08"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":165308.24365589046,"d":"₪ 165,308.24"},{"$nulls":7},5,{"v":200,"d":"₪ 200.00"},{"v":200,"d":"₪ 200.00"},{"v":20,"d":"₪ 20.00"},{"v":220,"d":"₪ 220.00"},{"v":0,"d":"₪ 0.00"}]
[{"$nulls":8},23,{"v":165308.24365589046,"d":"₪ 165,308.24"},{"v":20447.538267920194,"d":"₪ 20,447.54"},{"v":495.9247309676714,"d":"₪ 495.92"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":144860.70538797026,"d":"₪ 144,860.71"}]
[{"$nulls":8},24,{"v":144860.70538797026,"d":"₪ 144,860.71"},{"v":20508.880882723955,"d":"₪ 20,508.88"},{"v":434.58211616391077,"d":"₪ 434.58"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":124351.8245052463,"d":"₪ 124,351.82"}]
[{"$nulls":8},25,{"v":124351.8245052463,"d":"₪ 124,351.82"},{"v":20570.407525372128,"d":"₪ 20,570.41"},{"v":373.0554735157389,"d":"₪ 373.06"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":103781.41697987418,"d":"₪ 103,781.42"}]
[{"$nulls":8},26,{"v":103781.41697987418,"d":"₪ 103,781.42"},{"v":20632.118747948243,"d":"₪ 20,632.12"},{"v":311.34425093962255,"d":"₪ 311.34"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":83149.29823192593,"d":"₪ 83,149.30"}]
[{"$nulls":8},27,{"v":83149.29823192593,"d":"₪ 83,149.30"},{"v":20694.015104192087,"d":"₪ 20,694.02"},{"v":249.4478946957778,"d":"₪ 249.45"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":62455.28312773384,"d":"₪ 62,455.28"}]
[{"$nulls":8},28,{"v":62455.28312773384,"d":"₪ 62,455.28"},{"v":20756.097149504665,"d":"₪ 20,756.10"},{"v":187.36584938320152,"d":"₪ 187.37"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":41699.18597822917,"d":"₪ 41,699.19"}]
[{"$nulls":8},29,{"v":41699.18597822917,"d":"₪ 41,699.19"},{"v":20818.365440953177,"d":"₪ 20,818.37"},{"v":125.09755793468752,"d":"₪ 125.10"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":20880.820537275995,"d":"₪ 20,880.82"}]
[{"$nulls":8},30,{"v":20880.820537275995,"d":"₪ 20,880.82"},{"v":20880.82053727604,"d":"₪ 20,880.82"},{"v":62.64246161182798,"d":"₪ 62.64"},{"v":20943.462998887866,"d":"₪ 20,943.46"},{"v":-4.3655745685100555E-11,"d":"₪ -0.00"}]
[]
[]
[]
[]
[{"$nulls":4},"שאלה 2"]
{"$rows_empty":8}
[{"$nulls":8},"נתונים:"]
[{"$nulls":8},"הלוואה",{"v":200000,"d":"200,000"},"PV"]
[{"$nulls":8},"תקופות",5,"n"]
[{"$nulls":8},"ריבית",{"v":0.04,"d":"4.00%"},"r"]
[{"$nulls":9},{"$f":"PMT(J59,J58,-J57,,)","v":{"v":44925.42269860679,"d":"₪ 44,925.42"}},"PMT"]
[{"$nulls":8},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":8},1,{"$f":"J57","v":{"v":200000,"d":"₪ 200,000.00"}},{"$f":"M62-L62","v":{"v":36925.42269860679,"d":"₪ 36,925.42"}},{"$f":"$J$59*J62","v":{"v":8000,"d":"₪ 8,000.00"}},{"$f":"$J$60","v":{"v":44925.42269860679,"d":"₪ 44,925.42"}},{"$f":"J62-K62","v":{"v":163074.5773013932,"d":"₪ 163,074.58"}}]
[{"$nulls":8},2,{"$f":"N62","v":{"v":163074.5773013932,"d":"₪ 163,074.58"}},{"$f":"M63-L63","v":{"v":38402.43960655106,"d":"₪ 38,402.44"}},{"$f":"$J$59*J63","v":{"v":6522.983092055729,"d":"₪ 6,522.98"}},{"$f":"$J$60","v":{"v":44925.42269860679,"d":"₪ 44,925.42"}},{"$f":"J63-K63","v":{"v":124672.13769484215,"d":"₪ 124,672.14"}}]
[{"$nulls":8},3,{"$f":"N63","v":{"v":124672.13769484215,"d":"₪ 124,672.14"}},{"v":39938.537190813106,"d":"₪ 39,938.54"},{"v":4986.885507793686,"d":"₪ 4,986.89"},{"v":44925.42269860679,"d":"₪ 44,925.42"},{"v":84733.60050402905,"d":"₪ 84,733.60"}]
[{"$nulls":8},4,{"v":84733.60050402905,"d":"₪ 84,733.60"},{"v":41536.07867844563,"d":"₪ 41,536.08"},{"v":3389.344020161162,"d":"₪ 3,389.34"},{"v":44925.42269860679,"d":"₪ 44,925.42"},{"v":43197.52182558342,"d":"₪ 43,197.52"}]
[{"$nulls":8},5,{"v":43197.52182558342,"d":"₪ 43,197.52"},{"v":43197.52182558345,"d":"₪ 43,197.52"},{"v":1727.9008730233368,"d":"₪ 1,727.90"},{"v":44925.42269860679,"d":"₪ 44,925.42"},{"v":0,"d":"₪ 0.00"}]
{"$rows_empty":9}
[{"$nulls":4},"שאלה 3"]
{"$rows_empty":8}
[{"$nulls":8},"נתונים:"]
[{"$nulls":8},"הלוואה",{"v":200000,"d":"200,000"},"PV",null,{"v":0.06,"d":"6.00%"}]
[{"$nulls":8},"חודשים",{"$f":"5*12","v":60},"n",null,12]
[{"$nulls":8},"ריבית",{"$f":"M86/M87","v":{"v":0.005,"d":"0.50%"}},"r"]
[{"$nulls":9},{"$f":"PMT(J88,J87,-J86,,)","v":{"v":3866.560305885583,"d":"₪ 3,866.56"}},"PMT"]
[{"$nulls":8},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":8},1,{"$f":"J86","v":{"v":200000,"d":"₪ 200,000.00"}},{"$f":"M91-L91","v":{"v":2866.560305885583,"d":"₪ 2,866.56"}},{"$f":"$J$88*J91","v":{"v":1000,"d":"₪ 1,000.00"}},{"$f":"$J$89","v":{"v":3866.560305885583,"d":"₪ 3,866.56"}},{"$f":"J91-K91","v":{"v":197133.4396941144,"d":"₪ 197,133.44"}}]
[{"$nulls":8},2,{"$f":"N91","v":{"v":197133.4396941144,"d":"₪ 197,133.44"}},{"$f":"M92-L92","v":{"v":2880.893107415011,"d":"₪ 2,880.89"}},{"$f":"$J$88*J92","v":{"v":985.6671984705721,"d":"₪ 985.67"}},{"$f":"$J$89","v":{"v":3866.560305885583,"d":"₪ 3,866.56"}},{"$f":"J92-K92","v":{"v":194252.5465866994,"d":"₪ 194,252.55"}}]
[{"$nulls":8},3,{"$f":"N92","v":{"v":194252.5465866994,"d":"₪ 194,252.55"}},{"v":2895.297572952086,"d":"₪ 2,895.30"},{"v":971.2627329334971,"d":"₪ 971.26"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":191357.24901374732,"d":"₪ 191,357.25"}]
[{"$nulls":8},4,{"v":191357.24901374732,"d":"₪ 191,357.25"},{"v":2909.7740608168465,"d":"₪ 2,909.77"},{"v":956.7862450687367,"d":"₪ 956.79"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":188447.47495293047,"d":"₪ 188,447.47"}]
[{"$nulls":8},5,{"v":188447.47495293047,"d":"₪ 188,447.47"},{"v":2924.3229311209307,"d":"₪ 2,924.32"},{"v":942.2373747646524,"d":"₪ 942.24"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":185523.15202180954,"d":"₪ 185,523.15"}]
[{"$nulls":8},6,{"v":185523.15202180954,"d":"₪ 185,523.15"},{"v":2938.9445457765355,"d":"₪ 2,938.94"},{"v":927.6157601090478,"d":"₪ 927.62"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":182584.207476033,"d":"₪ 182,584.21"}]
[{"$nulls":8},7,{"v":182584.207476033,"d":"₪ 182,584.21"},{"v":2953.639268505418,"d":"₪ 2,953.64"},{"v":912.9210373801651,"d":"₪ 912.92"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":179630.5682075276,"d":"₪ 179,630.57"}]
[{"$nulls":8},8,{"v":179630.5682075276,"d":"₪ 179,630.57"},{"v":2968.407464847945,"d":"₪ 2,968.41"},{"v":898.152841037638,"d":"₪ 898.15"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":176662.16074267964,"d":"₪ 176,662.16"}]
[{"$nulls":8},9,{"v":176662.16074267964,"d":"₪ 176,662.16"},{"v":2983.249502172185,"d":"₪ 2,983.25"},{"v":883.3108037133982,"d":"₪ 883.31"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":173678.91124050744,"d":"₪ 173,678.91"}]
[{"$nulls":8},10,{"v":173678.91124050744,"d":"₪ 173,678.91"},{"v":2998.1657496830458,"d":"₪ 2,998.17"},{"v":868.3945562025373,"d":"₪ 868.39"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":170680.7454908244,"d":"₪ 170,680.75"}]
[{"$nulls":8},11,{"v":170680.7454908244,"d":"₪ 170,680.75"},{"v":3013.156578431461,"d":"₪ 3,013.16"},{"v":853.403727454122,"d":"₪ 853.40"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":167667.58891239294,"d":"₪ 167,667.59"}]
[{"$nulls":8},12,{"v":167667.58891239294,"d":"₪ 167,667.59"},{"v":3028.2223613236183,"d":"₪ 3,028.22"},{"v":838.3379445619647,"d":"₪ 838.34"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":164639.3665510693,"d":"₪ 164,639.37"}]
[{"$nulls":8},13,{"v":164639.3665510693,"d":"₪ 164,639.37"},{"v":3043.3634731302363,"d":"₪ 3,043.36"},{"v":823.1968327553466,"d":"₪ 823.20"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":161596.00307793907,"d":"₪ 161,596.00"}]
[{"$nulls":8},14,{"v":161596.00307793907,"d":"₪ 161,596.00"},{"v":3058.5802904958878,"d":"₪ 3,058.58"},{"v":807.9800153896954,"d":"₪ 807.98"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":158537.42278744318,"d":"₪ 158,537.42"}]
[{"$nulls":8},15,{"v":158537.42278744318,"d":"₪ 158,537.42"},{"v":3073.873191948367,"d":"₪ 3,073.87"},{"v":792.6871139372159,"d":"₪ 792.69"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":155463.5495954948,"d":"₪ 155,463.55"}]
[{"$nulls":8},16,{"v":155463.5495954948,"d":"₪ 155,463.55"},{"v":3089.242557908109,"d":"₪ 3,089.24"},{"v":777.317747977474,"d":"₪ 777.32"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":152374.3070375867,"d":"₪ 152,374.31"}]
[{"$nulls":8},17,{"v":152374.3070375867,"d":"₪ 152,374.31"},{"v":3104.6887706976495,"d":"₪ 3,104.69"},{"v":761.8715351879335,"d":"₪ 761.87"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":149269.61826688904,"d":"₪ 149,269.62"}]
[{"$nulls":8},18,{"v":149269.61826688904,"d":"₪ 149,269.62"},{"v":3120.212214551138,"d":"₪ 3,120.21"},{"v":746.3480913344453,"d":"₪ 746.35"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":146149.4060523379,"d":"₪ 146,149.41"}]
[{"$nulls":8},19,{"v":146149.4060523379,"d":"₪ 146,149.41"},{"v":3135.813275623894,"d":"₪ 3,135.81"},{"v":730.7470302616895,"d":"₪ 730.75"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":143013.592776714,"d":"₪ 143,013.59"}]
[{"$nulls":8},20,{"v":143013.592776714,"d":"₪ 143,013.59"},{"v":3151.492342002013,"d":"₪ 3,151.49"},{"v":715.0679638835701,"d":"₪ 715.07"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":139862.100434712,"d":"₪ 139,862.10"}]
[{"$nulls":8},21,{"v":139862.100434712,"d":"₪ 139,862.10"},{"v":3167.249803712023,"d":"₪ 3,167.25"},{"v":699.3105021735599,"d":"₪ 699.31"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":136694.85063099998,"d":"₪ 136,694.85"}]
[{"$nulls":8},22,{"v":136694.85063099998,"d":"₪ 136,694.85"},{"v":3183.086052730583,"d":"₪ 3,183.09"},{"v":683.4742531549999,"d":"₪ 683.47"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":133511.7645782694,"d":"₪ 133,511.76"}]
[{"$nulls":8},23,{"v":133511.7645782694,"d":"₪ 133,511.76"},{"v":3199.001482994236,"d":"₪ 3,199.00"},{"v":667.558822891347,"d":"₪ 667.56"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":130312.76309527515,"d":"₪ 130,312.76"}]
[{"$nulls":8},24,{"v":130312.76309527515,"d":"₪ 130,312.76"},{"v":3214.9964904092076,"d":"₪ 3,215.00"},{"v":651.5638154763758,"d":"₪ 651.56"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":127097.76660486594,"d":"₪ 127,097.77"}]
[{"$nulls":8},25,{"v":127097.76660486594,"d":"₪ 127,097.77"},{"v":3231.0714728612534,"d":"₪ 3,231.07"},{"v":635.4888330243298,"d":"₪ 635.49"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":123866.6951320047,"d":"₪ 123,866.70"}]
[{"$nulls":8},26,{"v":123866.6951320047,"d":"₪ 123,866.70"},{"v":3247.2268302255598,"d":"₪ 3,247.23"},{"v":619.3334756600235,"d":"₪ 619.33"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":120619.46830177914,"d":"₪ 120,619.47"}]
[{"$nulls":8},27,{"v":120619.46830177914,"d":"₪ 120,619.47"},{"v":3263.4629643766875,"d":"₪ 3,263.46"},{"v":603.0973415088957,"d":"₪ 603.10"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":117356.00533740246,"d":"₪ 117,356.01"}]
[{"$nulls":8},28,{"v":117356.00533740246,"d":"₪ 117,356.01"},{"v":3279.780279198571,"d":"₪ 3,279.78"},{"v":586.7800266870123,"d":"₪ 586.78"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":114076.22505820388,"d":"₪ 114,076.23"}]
[{"$nulls":8},29,{"v":114076.22505820388,"d":"₪ 114,076.23"},{"v":3296.1791805945636,"d":"₪ 3,296.18"},{"v":570.3811252910194,"d":"₪ 570.38"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":110780.04587760931,"d":"₪ 110,780.05"}]
[{"$nulls":8},30,{"v":110780.04587760931,"d":"₪ 110,780.05"},{"v":3312.6600764975365,"d":"₪ 3,312.66"},{"v":553.9002293880466,"d":"₪ 553.90"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":107467.38580111178,"d":"₪ 107,467.39"}]
[{"$nulls":8},31,{"v":107467.38580111178,"d":"₪ 107,467.39"},{"v":3329.2233768800243,"d":"₪ 3,329.22"},{"v":537.3369290055589,"d":"₪ 537.34"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":104138.16242423176,"d":"₪ 104,138.16"}]
[{"$nulls":8},32,{"v":104138.16242423176,"d":"₪ 104,138.16"},{"v":3345.869493764424,"d":"₪ 3,345.87"},{"v":520.6908121211588,"d":"₪ 520.69"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":100792.29293046735,"d":"₪ 100,792.29"}]
[{"$nulls":8},33,{"v":100792.29293046735,"d":"₪ 100,792.29"},{"v":3362.5988412332463,"d":"₪ 3,362.60"},{"v":503.96146465233676,"d":"₪ 503.96"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":97429.6940892341,"d":"₪ 97,429.69"}]
[{"$nulls":8},34,{"v":97429.6940892341,"d":"₪ 97,429.69"},{"v":3379.4118354394127,"d":"₪ 3,379.41"},{"v":487.14847044617045,"d":"₪ 487.15"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":94050.28225379468,"d":"₪ 94,050.28"}]
[{"$nulls":8},35,{"v":94050.28225379468,"d":"₪ 94,050.28"},{"v":3396.30889461661,"d":"₪ 3,396.31"},{"v":470.2514112689734,"d":"₪ 470.25"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":90653.97335917807,"d":"₪ 90,653.97"}]
[{"$nulls":8},36,{"v":90653.97335917807,"d":"₪ 90,653.97"},{"v":3413.290439089693,"d":"₪ 3,413.29"},{"v":453.2698667958903,"d":"₪ 453.27"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":87240.68292008838,"d":"₪ 87,240.68"}]
[{"$nulls":8},37,{"v":87240.68292008838,"d":"₪ 87,240.68"},{"v":3430.356891285141,"d":"₪ 3,430.36"},{"v":436.20341460044193,"d":"₪ 436.20"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":83810.32602880323,"d":"₪ 83,810.33"}]
[{"$nulls":8},38,{"v":83810.32602880323,"d":"₪ 83,810.33"},{"v":3447.508675741567,"d":"₪ 3,447.51"},{"v":419.05163014401614,"d":"₪ 419.05"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":80362.81735306166,"d":"₪ 80,362.82"}]
[{"$nulls":8},39,{"v":80362.81735306166,"d":"₪ 80,362.82"},{"v":3464.746219120275,"d":"₪ 3,464.75"},{"v":401.81408676530833,"d":"₪ 401.81"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":76898.07113394138,"d":"₪ 76,898.07"}]
[{"$nulls":8},40,{"v":76898.07113394138,"d":"₪ 76,898.07"},{"v":3482.0699502158764,"d":"₪ 3,482.07"},{"v":384.4903556697069,"d":"₪ 384.49"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":73416.0011837255,"d":"₪ 73,416.00"}]
[{"$nulls":8},41,{"v":73416.0011837255,"d":"₪ 73,416.00"},{"v":3499.4802999669555,"d":"₪ 3,499.48"},{"v":367.08000591862753,"d":"₪ 367.08"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":69916.52088375855,"d":"₪ 69,916.52"}]
[{"$nulls":8},42,{"v":69916.52088375855,"d":"₪ 69,916.52"},{"v":3516.97770146679,"d":"₪ 3,516.98"},{"v":349.58260441879276,"d":"₪ 349.58"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":66399.54318229176,"d":"₪ 66,399.54"}]
[{"$nulls":8},43,{"v":66399.54318229176,"d":"₪ 66,399.54"},{"v":3534.5625899741244,"d":"₪ 3,534.56"},{"v":331.9977159114588,"d":"₪ 332.00"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":62864.98059231763,"d":"₪ 62,864.98"}]
[{"$nulls":8},44,{"v":62864.98059231763,"d":"₪ 62,864.98"},{"v":3552.235402923995,"d":"₪ 3,552.24"},{"v":314.3249029615882,"d":"₪ 314.32"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":59312.74518939364,"d":"₪ 59,312.75"}]
[{"$nulls":8},45,{"v":59312.74518939364,"d":"₪ 59,312.75"},{"v":3569.996579938615,"d":"₪ 3,570.00"},{"v":296.5637259469682,"d":"₪ 296.56"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":55742.748609455026,"d":"₪ 55,742.75"}]
[{"$nulls":8},46,{"v":55742.748609455026,"d":"₪ 55,742.75"},{"v":3587.846562838308,"d":"₪ 3,587.85"},{"v":278.71374304727516,"d":"₪ 278.71"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":52154.90204661672,"d":"₪ 52,154.90"}]
[{"$nulls":8},47,{"v":52154.90204661672,"d":"₪ 52,154.90"},{"v":3605.7857956524995,"d":"₪ 3,605.79"},{"v":260.7745102330836,"d":"₪ 260.77"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":48549.11625096422,"d":"₪ 48,549.12"}]
[{"$nulls":8},48,{"v":48549.11625096422,"d":"₪ 48,549.12"},{"v":3623.814724630762,"d":"₪ 3,623.81"},{"v":242.74558125482113,"d":"₪ 242.75"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":44925.30152633346,"d":"₪ 44,925.30"}]
[{"$nulls":8},49,{"v":44925.30152633346,"d":"₪ 44,925.30"},{"v":3641.933798253916,"d":"₪ 3,641.93"},{"v":224.6265076316673,"d":"₪ 224.63"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":41283.367728079545,"d":"₪ 41,283.37"}]
[{"$nulls":8},50,{"v":41283.367728079545,"d":"₪ 41,283.37"},{"v":3660.1434672451855,"d":"₪ 3,660.14"},{"v":206.41683864039774,"d":"₪ 206.42"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":37623.22426083436,"d":"₪ 37,623.22"}]
[{"$nulls":8},51,{"v":37623.22426083436,"d":"₪ 37,623.22"},{"v":3678.4441845814113,"d":"₪ 3,678.44"},{"v":188.1161213041718,"d":"₪ 188.12"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":33944.780076252944,"d":"₪ 33,944.78"}]
[{"$nulls":8},52,{"v":33944.780076252944,"d":"₪ 33,944.78"},{"v":3696.8364055043185,"d":"₪ 3,696.84"},{"v":169.7239003812647,"d":"₪ 169.72"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":30247.943670748624,"d":"₪ 30,247.94"}]
[{"$nulls":8},53,{"v":30247.943670748624,"d":"₪ 30,247.94"},{"v":3715.32058753184,"d":"₪ 3,715.32"},{"v":151.23971835374311,"d":"₪ 151.24"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":26532.623083216786,"d":"₪ 26,532.62"}]
[{"$nulls":8},54,{"v":26532.623083216786,"d":"₪ 26,532.62"},{"v":3733.897190469499,"d":"₪ 3,733.90"},{"v":132.66311541608394,"d":"₪ 132.66"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":22798.725892747287,"d":"₪ 22,798.73"}]
[{"$nulls":8},55,{"v":22798.725892747287,"d":"₪ 22,798.73"},{"v":3752.5666764218468,"d":"₪ 3,752.57"},{"v":113.99362946373644,"d":"₪ 113.99"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":19046.15921632544,"d":"₪ 19,046.16"}]
[{"$nulls":8},56,{"v":19046.15921632544,"d":"₪ 19,046.16"},{"v":3771.329509803956,"d":"₪ 3,771.33"},{"v":95.23079608162719,"d":"₪ 95.23"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":15274.829706521483,"d":"₪ 15,274.83"}]
[{"$nulls":8},57,{"v":15274.829706521483,"d":"₪ 15,274.83"},{"v":3790.186157352976,"d":"₪ 3,790.19"},{"v":76.37414853260742,"d":"₪ 76.37"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":11484.643549168508,"d":"₪ 11,484.64"}]
[{"$nulls":8},58,{"v":11484.643549168508,"d":"₪ 11,484.64"},{"v":3809.1370881397406,"d":"₪ 3,809.14"},{"v":57.42321774584254,"d":"₪ 57.42"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":7675.506461028767,"d":"₪ 7,675.51"}]
[{"$nulls":8},59,{"v":7675.506461028767,"d":"₪ 7,675.51"},{"v":3828.1827735804395,"d":"₪ 3,828.18"},{"v":38.37753230514384,"d":"₪ 38.38"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":3847.3236874483277,"d":"₪ 3,847.32"}]
[{"$nulls":8},60,{"v":3847.3236874483277,"d":"₪ 3,847.32"},{"v":3847.3236874483414,"d":"₪ 3,847.32"},{"v":19.23661843724164,"d":"₪ 19.24"},{"v":3866.560305885583,"d":"₪ 3,866.56"},{"v":-1.3642420526593924E-11,"d":"₪ -0.00"}]
[]
[]
[]
[]
[{"$nulls":4},"שאלה 4",{"$nulls":13},"שאלה 3 - עם לוח שפיצר:"]
[]
[]
[]
[]
[{"$nulls":8},"נתונים:"]
[{"$nulls":8},"הלוואה",{"v":50000,"d":"50,000"},"PV"]
[{"$nulls":8},"מספר תקופות",10,"n",{"$nulls":7},"נתונים:"]
[{"$nulls":8},"ריבית",{"v":0.05,"d":"5.00%"},"r",{"$nulls":7},"הלוואה",{"v":100000,"d":"100,000"},"PV"]
[{"$nulls":9},{"$f":"J161/J162","v":5000},"קרן קבועה",{"$nulls":7},"שנים",5,"n"]
[{"$nulls":8},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה",{"$nulls":4},"ריבית",{"v":0.1,"d":"10.00%"},"r"]
[{"$nulls":8},1,{"$f":"J161","v":{"v":50000,"d":"₪ 50,000.00"}},{"$f":"$J$164","v":{"v":5000,"d":"₪ 5,000.00"}},{"$f":"$J$163*J166","v":{"v":2500,"d":"₪ 2,500.00"}},{"$f":"K166+L166","v":{"v":7500,"d":"₪ 7,500.00"}},{"$f":"J166-K166","v":{"v":45000,"d":"₪ 45,000.00"}}]
[{"$nulls":8},2,{"$f":"N166","v":{"v":45000,"d":"₪ 45,000.00"}},{"$f":"$J$164","v":{"v":5000,"d":"₪ 5,000.00"}},{"$f":"$J$163*J167","v":{"v":2250,"d":"₪ 2,250.00"}},{"$f":"K167+L167","v":{"v":7250,"d":"₪ 7,250.00"}},{"$f":"J167-K167","v":{"v":40000,"d":"₪ 40,000.00"}},{"$nulls":4},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":8},3,{"$f":"N167","v":{"v":40000,"d":"₪ 40,000.00"}},{"v":5000,"d":"₪ 5,000.00"},{"v":2000,"d":"₪ 2,000.00"},{"v":7000,"d":"₪ 7,000.00"},{"v":35000,"d":"₪ 35,000.00"},{"$nulls":4},1,{"$f":"T163","v":{"v":100000,"d":"100,000.00"}},{"$f":"PPMT($T$165,S168,$T$164,$T$163,0)","v":{"v":-16379.748079474539,"d":"(16,379.75)"}},{"$f":"IPMT($T$165,S168,$T$164,$T$163,0)","v":{"v":-10000,"d":"(10,000.00)"}},{"$f":"PMT($T$165,$T$164,$T$163)","v":{"v":-26379.74807947454,"d":"(26,379.75)"}},{"$f":"T168+U168","v":{"v":83620.25192052546,"d":"83,620.25"}}]
[{"$nulls":8},4,{"v":35000,"d":"₪ 35,000.00"},{"v":5000,"d":"₪ 5,000.00"},{"v":1750,"d":"₪ 1,750.00"},{"v":6750,"d":"₪ 6,750.00"},{"v":30000,"d":"₪ 30,000.00"},{"$nulls":4},2,{"$f":"X168","v":{"v":83620.25192052546,"d":"83,620.25"}},{"$f":"PPMT($T$165,S169,$T$164,$T$163,0)","v":{"v":-18017.722887421995,"d":"(18,017.72)"}},{"$f":"IPMT($T$165,S169,$T$164,$T$163,0)","v":{"v":-8362.025192052546,"d":"(8,362.03)"}},{"$f":"PMT($T$165,$T$164,$T$163)","v":{"v":-26379.74807947454,"d":"(26,379.75)"}},{"$f":"T169+U169","v":{"v":65602.52903310346,"d":"65,602.53"}}]
[{"$nulls":8},5,{"v":30000,"d":"₪ 30,000.00"},{"v":5000,"d":"₪ 5,000.00"},{"v":1500,"d":"₪ 1,500.00"},{"v":6500,"d":"₪ 6,500.00"},{"v":25000,"d":"₪ 25,000.00"},{"$nulls":4},3,{"$f":"X169","v":{"v":65602.52903310346,"d":"65,602.53"}},{"v":-19819.495176164193,"d":"(19,819.50)"},{"v":-6560.2529033103465,"d":"(6,560.25)"},{"v":-26379.74807947454,"d":"(26,379.75)"},{"v":45783.03385693927,"d":"45,783.03"}]
[{"$nulls":8},6,{"v":25000,"d":"₪ 25,000.00"},{"v":5000,"d":"₪ 5,000.00"},{"v":1250,"d":"₪ 1,250.00"},{"v":6250,"d":"₪ 6,250.00"},{"v":20000,"d":"₪ 20,000.00"},{"$nulls":4},4,{"v":45783.03385693927,"d":"45,783.03"},{"v":-21801.444693780613,"d":"(21,801.44)"},{"v":-4578.303385693928,"d":"(4,578.30)"},{"v":-26379.74807947454,"d":"(26,379.75)"},{"v":23981.589163158656,"d":"23,981.59"}]
[{"$nulls":8},7,{"v":20000,"d":"₪ 20,000.00"},{"v":5000,"d":"₪ 5,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":6000,"d":"₪ 6,000.00"},{"v":15000,"d":"₪ 15,000.00"},{"$nulls":4},5,{"v":23981.589163158656,"d":"23,981.59"},{"v":-23981.58916315867,"d":"(23,981.59)"},{"v":-2398.158916315867,"d":"(2,398.16)"},{"v":-26379.74807947454,"d":"(26,379.75)"},{"v":0,"d":"0.00"}]
[{"$nulls":8},8,{"v":15000,"d":"₪ 15,000.00"},{"v":5000,"d":"₪ 5,000.00"},{"v":750,"d":"₪ 750.00"},{"v":5750,"d":"₪ 5,750.00"},{"v":10000,"d":"₪ 10,000.00"}]
[{"$nulls":8},9,{"v":10000,"d":"₪ 10,000.00"},{"v":5000,"d":"₪ 5,000.00"},{"v":500,"d":"₪ 500.00"},{"v":5500,"d":"₪ 5,500.00"},{"v":5000,"d":"₪ 5,000.00"}]
[{"$nulls":8},10,{"v":5000,"d":"₪ 5,000.00"},{"v":5000,"d":"₪ 5,000.00"},{"v":250,"d":"₪ 250.00"},{"v":5250,"d":"₪ 5,250.00"},{"v":0,"d":"₪ 0.00"}]
{"$rows_empty":9}
[{"$nulls":4},"שאלה 5"]
[]
[]
[]
[]
[]
[{"$nulls":8},"נתונים:"]
[{"$nulls":8},"הלוואה",{"v":80000,"d":"80,000"},"PV"]
[{"$nulls":8},"מספר תקופות",5,"n"]
[{"$nulls":8},"ריבית",{"v":0.05,"d":"5.00%"},"r"]
[]
[{"$nulls":8},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":8},1,{"$f":"J192","v":{"v":80000,"d":"₪ 80,000.00"}},{"v":0,"d":"₪ 0.00"},{"$f":"$J$194*J197","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"K197+L197","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"J197-K197","v":{"v":80000,"d":"₪ 80,000.00"}}]
[{"$nulls":8},2,{"$f":"N197","v":{"v":80000,"d":"₪ 80,000.00"}},{"v":0,"d":"₪ 0.00"},{"$f":"$J$194*J198","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"K198+L198","v":{"v":4000,"d":"₪ 4,000.00"}},{"$f":"J198-K198","v":{"v":80000,"d":"₪ 80,000.00"}}]
[{"$nulls":8},3,{"$f":"N198","v":{"v":80000,"d":"₪ 80,000.00"}},{"v":0,"d":"₪ 0.00"},{"v":4000,"d":"₪ 4,000.00"},{"v":4000,"d":"₪ 4,000.00"},{"v":80000,"d":"₪ 80,000.00"}]
[{"$nulls":8},4,{"v":80000,"d":"₪ 80,000.00"},{"v":0,"d":"₪ 0.00"},{"v":4000,"d":"₪ 4,000.00"},{"v":4000,"d":"₪ 4,000.00"},{"v":80000,"d":"₪ 80,000.00"}]
[{"$nulls":8},5,{"v":80000,"d":"₪ 80,000.00"},{"$f":"J192","v":{"v":80000,"d":"₪ 80,000.00"}},{"v":4000,"d":"₪ 4,000.00"},{"v":84000,"d":"₪ 84,000.00"},{"v":0,"d":"₪ 0.00"}]
[]
[]
[]
[]
[{"$nulls":4},"שאלה 6"]
[]
[]
[]
[]
[{"$nulls":8},"נתונים:"]
[{"$nulls":8},"הלוואה",{"v":20000,"d":"20,000"},"PV"]
[{"$nulls":8},"מספר תקופות",5,"n"]
[{"$nulls":8},"ריבית",{"v":0.04,"d":"4.00%"},"r"]
[]
[{"$nulls":8},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":8},1,{"$f":"J212","v":{"v":20000,"d":"₪ 20,000.00"}},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"$f":"K217+L217","v":{"v":0,"d":"₪ 0.00"}},{"$f":"FV($J$214,I217,,-$J$212)","v":{"v":20800,"d":"₪ 20,800.00"}}]
[{"$nulls":8},2,{"$f":"N217","v":{"v":20800,"d":"₪ 20,800.00"}},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"$f":"K218+L218","v":{"v":0,"d":"₪ 0.00"}},{"$f":"FV($J$214,I218,,-$J$212)","v":{"v":21632.000000000004,"d":"₪ 21,632.00"}}]
[{"$nulls":8},3,{"$f":"N218","v":{"v":21632.000000000004,"d":"₪ 21,632.00"}},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":22497.280000000002,"d":"₪ 22,497.28"}]
[{"$nulls":8},4,{"v":22497.280000000002,"d":"₪ 22,497.28"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":23397.171200000004,"d":"₪ 23,397.17"}]
[{"$nulls":8},5,{"v":23397.171200000004,"d":"₪ 23,397.17"},{"$f":"J212","v":{"v":20000,"d":"₪ 20,000.00"}},{"$f":"N221-K221","v":{"v":4333.058048000006,"d":"₪ 4,333.06"}},{"v":24333.058048000006,"d":"₪ 24,333.06"},{"$f":"FV($J$214,I221,,-$J$212)","v":{"v":24333.058048000006,"d":"₪ 24,333.06"}}]

{"sheet":"תרגול עצמי שאלות 7-11","index":1,"n_rows":202,"n_cols":16,"rows_kept":202}
[]
[]
[]
[{"$nulls":7},"שאלה 7"]
[]
[]
[{"$nulls":10},"נתונים:"]
[{"$nulls":10},"הלוואה",{"v":180000,"d":"180,000"},"PV",null,{"v":0.1255,"d":"12.55%"},"r"]
[{"$nulls":10},"תקופות",{"$f":"3*4","v":12},"n",null,{"$f":"(1+O8)^0.25-1","v":0.02999798439457879},"רבעון"]
[{"$nulls":10},"ריבית",{"$f":"O9","v":{"v":0.02999798439457879,"d":"3.00%"}},"r"]
[{"$nulls":11},{"$f":"PMT(L10,L9,-L8,,)","v":{"v":18082.957809260202,"d":"₪ 18,082.96"}},"PMT"]
[{"$nulls":10},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":10},1,{"$f":"L8","v":{"v":180000,"d":"₪ 180,000.00"}},{"$f":"O13-N13","v":{"v":12683.320618236019,"d":"₪ 12,683.32"}},{"$f":"$L$10*L13","v":{"v":5399.637191024182,"d":"₪ 5,399.64"}},{"$f":"$L$11","v":{"v":18082.957809260202,"d":"₪ 18,082.96"}},{"$f":"L13-M13","v":{"v":167316.67938176397,"d":"₪ 167,316.68"}}]
[{"$nulls":10},2,{"$f":"P13","v":{"v":167316.67938176397,"d":"₪ 167,316.68"}},{"$f":"O14-N14","v":{"v":13063.794672213304,"d":"₪ 13,063.79"}},{"$f":"$L$10*L14","v":{"v":5019.163137046899,"d":"₪ 5,019.16"}},{"$f":"$L$11","v":{"v":18082.957809260202,"d":"₪ 18,082.96"}},{"$f":"L14-M14","v":{"v":154252.88470955068,"d":"₪ 154,252.88"}}]
[{"$nulls":10},3,{"$f":"P14","v":{"v":154252.88470955068,"d":"₪ 154,252.88"}},{"v":13455.68218092434,"d":"₪ 13,455.68"},{"v":4627.275628335863,"d":"₪ 4,627.28"},{"v":18082.957809260202,"d":"₪ 18,082.96"},{"v":140797.20252862634,"d":"₪ 140,797.20"}]
[{"$nulls":10},4,{"v":140797.20252862634,"d":"₪ 140,797.20"},{"v":13859.32552500612,"d":"₪ 13,859.33"},{"v":4223.632284254082,"d":"₪ 4,223.63"},{"v":18082.957809260202,"d":"₪ 18,082.96"},{"v":126937.87700362022,"d":"₪ 126,937.88"}]
[{"$nulls":10},5,{"v":126937.87700362022,"d":"₪ 126,937.88"},{"v":14275.07735582464,"d":"₪ 14,275.08"},{"v":3807.8804534355613,"d":"₪ 3,807.88"},{"v":18082.957809260202,"d":"₪ 18,082.96"},{"v":112662.79964779557,"d":"₪ 112,662.80"}]
[{"$nulls":10},6,{"v":112662.79964779557,"d":"₪ 112,662.80"},{"v":14703.300903576073,"d":"₪ 14,703.30"},{"v":3379.6569056841286,"d":"₪ 3,379.66"},{"v":18082.957809260202,"d":"₪ 18,082.96"},{"v":97959.4987442195,"d":"₪ 97,959.50"}]
[{"$nulls":10},7,{"v":97959.4987442195,"d":"₪ 97,959.50"},{"v":15144.370294630346,"d":"₪ 15,144.37"},{"v":2938.587514629857,"d":"₪ 2,938.59"},{"v":18082.957809260202,"d":"₪ 18,082.96"},{"v":82815.12844958916,"d":"₪ 82,815.13"}]
[{"$nulls":10},8,{"v":82815.12844958916,"d":"₪ 82,815.13"},{"v":15598.670878394389,"d":"₪ 15,598.67"},{"v":2484.2869308658137,"d":"₪ 2,484.29"},{"v":18082.957809260202,"d":"₪ 18,082.96"},{"v":67216.45757119477,"d":"₪ 67,216.46"}]
[{"$nulls":10},9,{"v":67216.45757119477,"d":"₪ 67,216.46"},{"v":16066.599563980635,"d":"₪ 16,066.60"},{"v":2016.358245279568,"d":"₪ 2,016.36"},{"v":18082.957809260202,"d":"₪ 18,082.96"},{"v":51149.858007214134,"d":"₪ 51,149.86"}]
[{"$nulls":10},10,{"v":51149.858007214134,"d":"₪ 51,149.86"},{"v":16548.565166974873,"d":"₪ 16,548.57"},{"v":1534.3926422853306,"d":"₪ 1,534.39"},{"v":18082.957809260202,"d":"₪ 18,082.96"},{"v":34601.29284023926,"d":"₪ 34,601.29"}]
[{"$nulls":10},11,{"v":34601.29284023926,"d":"₪ 34,601.29"},{"v":17044.988766606453,"d":"₪ 17,044.99"},{"v":1037.9690426537481,"d":"₪ 1,037.97"},{"v":18082.957809260202,"d":"₪ 18,082.96"},{"v":17556.304073632804,"d":"₪ 17,556.30"}]
[{"$nulls":10},12,{"v":17556.304073632804,"d":"₪ 17,556.30"},{"v":17556.304073632884,"d":"₪ 17,556.30"},{"v":526.6537356273169,"d":"₪ 526.65"},{"v":18082.957809260202,"d":"₪ 18,082.96"},{"v":-8.003553375601768e-11,"d":"₪ -0.00"}]
[]
[]
[]
[]
[]
[{"$nulls":7},"שאלה 8"]
{"$rows_empty":7}
[{"$nulls":10},"נתונים:"]
[{"$nulls":10},"הלוואה",{"v":1000000,"d":"1,000,000"},"PV"]
[{"$nulls":10},"חודשים",{"$f":"5*12","v":60},"n"]
[{"$nulls":10},"ריבית",{"v":0.003,"d":"0.30%"},"r"]
[{"$nulls":11},{"$f":"PMT(L41,L40,-L39,,)","v":{"v":18236.562647637405,"d":"₪ 18,236.56"}},"PMT"]
[{"$nulls":10},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":10},1,{"$f":"L39","v":{"v":1000000,"d":"₪ 1,000,000.00"}},{"$f":"O44-N44","v":{"v":15236.562647637405,"d":"₪ 15,236.56"}},{"$f":"$L$41*L44","v":{"v":3000,"d":"₪ 3,000.00"}},{"$f":"$L$42","v":{"v":18236.562647637405,"d":"₪ 18,236.56"}},{"$f":"L44-M44","v":{"v":984763.4373523626,"d":"₪ 984,763.44"}}]
[{"$nulls":10},2,{"$f":"P44","v":{"v":984763.4373523626,"d":"₪ 984,763.44"}},{"$f":"O45-N45","v":{"v":15282.272335580317,"d":"₪ 15,282.27"}},{"$f":"$L$41*L45","v":{"v":2954.2903120570877,"d":"₪ 2,954.29"}},{"$f":"$L$42","v":{"v":18236.562647637405,"d":"₪ 18,236.56"}},{"$f":"L45-M45","v":{"v":969481.1650167822,"d":"₪ 969,481.17"}}]
[{"$nulls":10},3,{"$f":"P45","v":{"v":969481.1650167822,"d":"₪ 969,481.17"}},{"v":15328.119152587058,"d":"₪ 15,328.12"},{"v":2908.443495050347,"d":"₪ 2,908.44"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":954153.0458641952,"d":"₪ 954,153.05"}]
[{"$nulls":10},4,{"v":954153.0458641952,"d":"₪ 954,153.05"},{"v":15374.10351004482,"d":"₪ 15,374.10"},{"v":2862.4591375925856,"d":"₪ 2,862.46"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":938778.9423541503,"d":"₪ 938,778.94"}]
[{"$nulls":10},5,{"v":938778.9423541503,"d":"₪ 938,778.94"},{"v":15420.225820574955,"d":"₪ 15,420.23"},{"v":2816.336827062451,"d":"₪ 2,816.34"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":923358.7165335754,"d":"₪ 923,358.72"}]
[{"$nulls":10},6,{"v":923358.7165335754,"d":"₪ 923,358.72"},{"v":15466.48649803668,"d":"₪ 15,466.49"},{"v":2770.0761496007262,"d":"₪ 2,770.08"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":907892.2300355388,"d":"₪ 907,892.23"}]
[{"$nulls":10},7,{"v":907892.2300355388,"d":"₪ 907,892.23"},{"v":15512.885957530789,"d":"₪ 15,512.89"},{"v":2723.676690106616,"d":"₪ 2,723.68"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":892379.344078008,"d":"₪ 892,379.34"}]
[{"$nulls":10},8,{"v":892379.344078008,"d":"₪ 892,379.34"},{"v":15559.424615403383,"d":"₪ 15,559.42"},{"v":2677.1380322340237,"d":"₪ 2,677.14"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":876819.9194626046,"d":"₪ 876,819.92"}]
[{"$nulls":10},9,{"v":876819.9194626046,"d":"₪ 876,819.92"},{"v":15606.102889249592,"d":"₪ 15,606.10"},{"v":2630.459758387814,"d":"₪ 2,630.46"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":861213.816573355,"d":"₪ 861,213.82"}]
[{"$nulls":10},10,{"v":861213.816573355,"d":"₪ 861,213.82"},{"v":15652.921197917341,"d":"₪ 15,652.92"},{"v":2583.641449720065,"d":"₪ 2,583.64"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":845560.8953754377,"d":"₪ 845,560.90"}]
[{"$nulls":10},11,{"v":845560.8953754377,"d":"₪ 845,560.90"},{"v":15699.879961511093,"d":"₪ 15,699.88"},{"v":2536.682686126313,"d":"₪ 2,536.68"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":829861.0154139266,"d":"₪ 829,861.02"}]
[{"$nulls":10},12,{"v":829861.0154139266,"d":"₪ 829,861.02"},{"v":15746.979601395626,"d":"₪ 15,746.98"},{"v":2489.58304624178,"d":"₪ 2,489.58"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":814114.0358125309,"d":"₪ 814,114.04"}]
[{"$nulls":10},13,{"v":814114.0358125309,"d":"₪ 814,114.04"},{"v":15794.220540199813,"d":"₪ 15,794.22"},{"v":2442.342107437593,"d":"₪ 2,442.34"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":798319.8152723311,"d":"₪ 798,319.82"}]
[{"$nulls":10},14,{"v":798319.8152723311,"d":"₪ 798,319.82"},{"v":15841.603201820411,"d":"₪ 15,841.60"},{"v":2394.9594458169936,"d":"₪ 2,394.96"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":782478.2120705107,"d":"₪ 782,478.21"}]
[{"$nulls":10},15,{"v":782478.2120705107,"d":"₪ 782,478.21"},{"v":15889.128011425873,"d":"₪ 15,889.13"},{"v":2347.434636211532,"d":"₪ 2,347.43"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":766589.0840590849,"d":"₪ 766,589.08"}]
[{"$nulls":10},16,{"v":766589.0840590849,"d":"₪ 766,589.08"},{"v":15936.79539546015,"d":"₪ 15,936.80"},{"v":2299.7672521772547,"d":"₪ 2,299.77"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":750652.2886636248,"d":"₪ 750,652.29"}]
[{"$nulls":10},17,{"v":750652.2886636248,"d":"₪ 750,652.29"},{"v":15984.60578164653,"d":"₪ 15,984.61"},{"v":2251.9568659908746,"d":"₪ 2,251.96"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":734667.6828819782,"d":"₪ 734,667.68"}]
[{"$nulls":10},18,{"v":734667.6828819782,"d":"₪ 734,667.68"},{"v":16032.559598991471,"d":"₪ 16,032.56"},{"v":2204.0030486459345,"d":"₪ 2,204.00"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":718635.1232829868,"d":"₪ 718,635.12"}]
[{"$nulls":10},19,{"v":718635.1232829868,"d":"₪ 718,635.12"},{"v":16080.657277788445,"d":"₪ 16,080.66"},{"v":2155.9053698489606,"d":"₪ 2,155.91"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":702554.4660051983,"d":"₪ 702,554.47"}]
[{"$nulls":10},20,{"v":702554.4660051983,"d":"₪ 702,554.47"},{"v":16128.89924962181,"d":"₪ 16,128.90"},{"v":2107.663398015595,"d":"₪ 2,107.66"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":686425.5667555765,"d":"₪ 686,425.57"}]
[{"$nulls":10},21,{"v":686425.5667555765,"d":"₪ 686,425.57"},{"v":16177.285947370676,"d":"₪ 16,177.29"},{"v":2059.2767002667297,"d":"₪ 2,059.28"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":670248.2808082058,"d":"₪ 670,248.28"}]
[{"$nulls":10},22,{"v":670248.2808082058,"d":"₪ 670,248.28"},{"v":16225.817805212788,"d":"₪ 16,225.82"},{"v":2010.7448424246174,"d":"₪ 2,010.74"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":654022.463002993,"d":"₪ 654,022.46"}]
[{"$nulls":10},23,{"v":654022.463002993,"d":"₪ 654,022.46"},{"v":16274.495258628427,"d":"₪ 16,274.50"},{"v":1962.067389008979,"d":"₪ 1,962.07"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":637747.9677443646,"d":"₪ 637,747.97"}]
[{"$nulls":10},24,{"v":637747.9677443646,"d":"₪ 637,747.97"},{"v":16323.31874440431,"d":"₪ 16,323.32"},{"v":1913.243903233094,"d":"₪ 1,913.24"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":621424.6489999603,"d":"₪ 621,424.65"}]
[{"$nulls":10},25,{"v":621424.6489999603,"d":"₪ 621,424.65"},{"v":16372.288700637524,"d":"₪ 16,372.29"},{"v":1864.2739469998808,"d":"₪ 1,864.27"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":605052.3602993228,"d":"₪ 605,052.36"}]
[{"$nulls":10},26,{"v":605052.3602993228,"d":"₪ 605,052.36"},{"v":16421.40556673944,"d":"₪ 16,421.41"},{"v":1815.1570808979684,"d":"₪ 1,815.16"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":588630.9547325834,"d":"₪ 588,630.95"}]
[{"$nulls":10},27,{"v":588630.9547325834,"d":"₪ 588,630.95"},{"v":16470.669783439655,"d":"₪ 16,470.67"},{"v":1765.8928641977502,"d":"₪ 1,765.89"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":572160.2849491438,"d":"₪ 572,160.28"}]
[{"$nulls":10},28,{"v":572160.2849491438,"d":"₪ 572,160.28"},{"v":16520.081792789973,"d":"₪ 16,520.08"},{"v":1716.4808548474314,"d":"₪ 1,716.48"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":555640.2031563538,"d":"₪ 555,640.20"}]
[{"$nulls":10},29,{"v":555640.2031563538,"d":"₪ 555,640.20"},{"v":16569.642038168346,"d":"₪ 16,569.64"},{"v":1666.9206094690614,"d":"₪ 1,666.92"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":539070.5611181854,"d":"₪ 539,070.56"}]
[{"$nulls":10},30,{"v":539070.5611181854,"d":"₪ 539,070.56"},{"v":16619.35096428285,"d":"₪ 16,619.35"},{"v":1617.2116833545563,"d":"₪ 1,617.21"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":522451.21015390253,"d":"₪ 522,451.21"}]
[{"$nulls":10},31,{"v":522451.21015390253,"d":"₪ 522,451.21"},{"v":16669.209017175697,"d":"₪ 16,669.21"},{"v":1567.3536304617076,"d":"₪ 1,567.35"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":505782.0011367268,"d":"₪ 505,782.00"}]
[{"$nulls":10},32,{"v":505782.0011367268,"d":"₪ 505,782.00"},{"v":16719.216644227225,"d":"₪ 16,719.22"},{"v":1517.3460034101804,"d":"₪ 1,517.35"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":489062.7844924996,"d":"₪ 489,062.78"}]
[{"$nulls":10},33,{"v":489062.7844924996,"d":"₪ 489,062.78"},{"v":16769.374294159905,"d":"₪ 16,769.37"},{"v":1467.1883534774988,"d":"₪ 1,467.19"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":472293.4101983397,"d":"₪ 472,293.41"}]
[{"$nulls":10},34,{"v":472293.4101983397,"d":"₪ 472,293.41"},{"v":16819.682417042386,"d":"₪ 16,819.68"},{"v":1416.8802305950192,"d":"₪ 1,416.88"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":455473.72778129735,"d":"₪ 455,473.73"}]
[{"$nulls":10},35,{"v":455473.72778129735,"d":"₪ 455,473.73"},{"v":16870.141464293512,"d":"₪ 16,870.14"},{"v":1366.4211833438922,"d":"₪ 1,366.42"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":438603.5863170038,"d":"₪ 438,603.59"}]
[{"$nulls":10},36,{"v":438603.5863170038,"d":"₪ 438,603.59"},{"v":16920.751888686395,"d":"₪ 16,920.75"},{"v":1315.8107589510114,"d":"₪ 1,315.81"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":421682.83442831744,"d":"₪ 421,682.83"}]
[{"$nulls":10},37,{"v":421682.83442831744,"d":"₪ 421,682.83"},{"v":16971.51414435245,"d":"₪ 16,971.51"},{"v":1265.0485032849524,"d":"₪ 1,265.05"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":404711.320283965,"d":"₪ 404,711.32"}]
[{"$nulls":10},38,{"v":404711.320283965,"d":"₪ 404,711.32"},{"v":17022.42868678551,"d":"₪ 17,022.43"},{"v":1214.133960851895,"d":"₪ 1,214.13"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":387688.89159717946,"d":"₪ 387,688.89"}]
[{"$nulls":10},39,{"v":387688.89159717946,"d":"₪ 387,688.89"},{"v":17073.495972845867,"d":"₪ 17,073.50"},{"v":1163.0666747915384,"d":"₪ 1,163.07"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":370615.3956243336,"d":"₪ 370,615.40"}]
[{"$nulls":10},40,{"v":370615.3956243336,"d":"₪ 370,615.40"},{"v":17124.716460764404,"d":"₪ 17,124.72"},{"v":1111.8461868730008,"d":"₪ 1,111.85"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":353490.6791635692,"d":"₪ 353,490.68"}]
[{"$nulls":10},41,{"v":353490.6791635692,"d":"₪ 353,490.68"},{"v":17176.090610146697,"d":"₪ 17,176.09"},{"v":1060.4720374907076,"d":"₪ 1,060.47"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":336314.5885534225,"d":"₪ 336,314.59"}]
[{"$nulls":10},42,{"v":336314.5885534225,"d":"₪ 336,314.59"},{"v":17227.618881977138,"d":"₪ 17,227.62"},{"v":1008.9437656602674,"d":"₪ 1,008.94"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":319086.9696714453,"d":"₪ 319,086.97"}]
[{"$nulls":10},43,{"v":319086.9696714453,"d":"₪ 319,086.97"},{"v":17279.30173862307,"d":"₪ 17,279.30"},{"v":957.260909014336,"d":"₪ 957.26"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":301807.66793282225,"d":"₪ 301,807.67"}]
[{"$nulls":10},44,{"v":301807.66793282225,"d":"₪ 301,807.67"},{"v":17331.13964383894,"d":"₪ 17,331.14"},{"v":905.4230037984668,"d":"₪ 905.42"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":284476.52828898333,"d":"₪ 284,476.53"}]
[{"$nulls":10},45,{"v":284476.52828898333,"d":"₪ 284,476.53"},{"v":17383.133062770456,"d":"₪ 17,383.13"},{"v":853.42958486695,"d":"₪ 853.43"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":267093.39522621286,"d":"₪ 267,093.40"}]
[{"$nulls":10},46,{"v":267093.39522621286,"d":"₪ 267,093.40"},{"v":17435.282461958766,"d":"₪ 17,435.28"},{"v":801.2801856786386,"d":"₪ 801.28"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":249658.1127642541,"d":"₪ 249,658.11"}]
[{"$nulls":10},47,{"v":249658.1127642541,"d":"₪ 249,658.11"},{"v":17487.588309344643,"d":"₪ 17,487.59"},{"v":748.9743382927624,"d":"₪ 748.97"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":232170.52445490946,"d":"₪ 232,170.52"}]
[{"$nulls":10},48,{"v":232170.52445490946,"d":"₪ 232,170.52"},{"v":17540.051074272676,"d":"₪ 17,540.05"},{"v":696.5115733647284,"d":"₪ 696.51"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":214630.47338063677,"d":"₪ 214,630.47"}]
[{"$nulls":10},49,{"v":214630.47338063677,"d":"₪ 214,630.47"},{"v":17592.671227495495,"d":"₪ 17,592.67"},{"v":643.8914201419103,"d":"₪ 643.89"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":197037.80215314127,"d":"₪ 197,037.80"}]
[{"$nulls":10},50,{"v":197037.80215314127,"d":"₪ 197,037.80"},{"v":17645.449241177983,"d":"₪ 17,645.45"},{"v":591.1134064594238,"d":"₪ 591.11"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":179392.35291196327,"d":"₪ 179,392.35"}]
[{"$nulls":10},51,{"v":179392.35291196327,"d":"₪ 179,392.35"},{"v":17698.385588901514,"d":"₪ 17,698.39"},{"v":538.1770587358899,"d":"₪ 538.18"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":161693.96732306175,"d":"₪ 161,693.97"}]
[{"$nulls":10},52,{"v":161693.96732306175,"d":"₪ 161,693.97"},{"v":17751.48074566822,"d":"₪ 17,751.48"},{"v":485.08190196918525,"d":"₪ 485.08"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":143942.48657739352,"d":"₪ 143,942.49"}]
[{"$nulls":10},53,{"v":143942.48657739352,"d":"₪ 143,942.49"},{"v":17804.735187905226,"d":"₪ 17,804.74"},{"v":431.82745973218056,"d":"₪ 431.83"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":126137.75138948829,"d":"₪ 126,137.75"}]
[{"$nulls":10},54,{"v":126137.75138948829,"d":"₪ 126,137.75"},{"v":17858.149393468942,"d":"₪ 17,858.15"},{"v":378.41325416846485,"d":"₪ 378.41"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":108279.60199601934,"d":"₪ 108,279.60"}]
[{"$nulls":10},55,{"v":108279.60199601934,"d":"₪ 108,279.60"},{"v":17911.72384164935,"d":"₪ 17,911.72"},{"v":324.838805988058,"d":"₪ 324.84"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":90367.87815436999,"d":"₪ 90,367.88"}]
[{"$nulls":10},56,{"v":90367.87815436999,"d":"₪ 90,367.88"},{"v":17965.459013174295,"d":"₪ 17,965.46"},{"v":271.10363446311,"d":"₪ 271.10"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":72402.41914119569,"d":"₪ 72,402.42"}]
[{"$nulls":10},57,{"v":72402.41914119569,"d":"₪ 72,402.42"},{"v":18019.35539021382,"d":"₪ 18,019.36"},{"v":217.20725742358707,"d":"₪ 217.21"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":54383.06375098186,"d":"₪ 54,383.06"}]
[{"$nulls":10},58,{"v":54383.06375098186,"d":"₪ 54,383.06"},{"v":18073.41345638446,"d":"₪ 18,073.41"},{"v":163.1491912529456,"d":"₪ 163.15"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":36309.650294597406,"d":"₪ 36,309.65"}]
[{"$nulls":10},59,{"v":36309.650294597406,"d":"₪ 36,309.65"},{"v":18127.63369675361,"d":"₪ 18,127.63"},{"v":108.92895088379223,"d":"₪ 108.93"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":18182.016597843794,"d":"₪ 18,182.02"}]
[{"$nulls":10},60,{"v":18182.016597843794,"d":"₪ 18,182.02"},{"v":18182.016597843874,"d":"₪ 18,182.02"},{"v":54.54604979353138,"d":"₪ 54.55"},{"v":18236.562647637405,"d":"₪ 18,236.56"},{"v":-8.003553375601768e-11,"d":"₪ -0.00"}]
{"$rows_empty":9}
[{"$nulls":7},"שאלה 9"]
[]
[]
[]
[]
[]
[{"$nulls":10},"נתונים:"]
[{"$nulls":10},"הלוואה",{"v":610000,"d":"610,000"},"PV"]
[{"$nulls":10},"מספר תקופות",25,"n"]
[{"$nulls":10},"ריבית",{"v":0.0287,"d":"2.87%"},"r"]
[{"$nulls":11},{"$f":"L120/L121","v":24400},"קרן קבועה"]
[{"$nulls":10},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":10},1,{"$f":"L120","v":{"v":610000,"d":"₪ 610,000.00"}},{"$f":"$L$123","v":{"v":24400,"d":"₪ 24,400.00"}},{"$f":"$L$122*L125","v":{"v":17507,"d":"₪ 17,507.00"}},{"$f":"M125+N125","v":{"v":41907,"d":"₪ 41,907.00"}},{"$f":"L125-M125","v":{"v":585600,"d":"₪ 585,600.00"}}]
[{"$nulls":10},2,{"$f":"P125","v":{"v":585600,"d":"₪ 585,600.00"}},{"$f":"$L$123","v":{"v":24400,"d":"₪ 24,400.00"}},{"$f":"$L$122*L126","v":{"v":16806.72,"d":"₪ 16,806.72"}},{"$f":"M126+N126","v":{"v":41206.72,"d":"₪ 41,206.72"}},{"$f":"L126-M126","v":{"v":561200,"d":"₪ 561,200.00"}}]
[{"$nulls":10},3,{"$f":"P126","v":{"v":561200,"d":"₪ 561,200.00"}},{"v":24400,"d":"₪ 24,400.00"},{"v":16106.44,"d":"₪ 16,106.44"},{"v":40506.44,"d":"₪ 40,506.44"},{"v":536800,"d":"₪ 536,800.00"}]
[{"$nulls":10},4,{"v":536800,"d":"₪ 536,800.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":15406.16,"d":"₪ 15,406.16"},{"v":39806.16,"d":"₪ 39,806.16"},{"v":512400,"d":"₪ 512,400.00"}]
[{"$nulls":10},5,{"v":512400,"d":"₪ 512,400.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":14705.88,"d":"₪ 14,705.88"},{"v":39105.88,"d":"₪ 39,105.88"},{"v":488000,"d":"₪ 488,000.00"}]
[{"$nulls":10},6,{"v":488000,"d":"₪ 488,000.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":14005.6,"d":"₪ 14,005.60"},{"v":38405.6,"d":"₪ 38,405.60"},{"v":463600,"d":"₪ 463,600.00"}]
[{"$nulls":10},7,{"v":463600,"d":"₪ 463,600.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":13305.32,"d":"₪ 13,305.32"},{"v":37705.32,"d":"₪ 37,705.32"},{"v":439200,"d":"₪ 439,200.00"}]
[{"$nulls":10},8,{"v":439200,"d":"₪ 439,200.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":12605.039999999999,"d":"₪ 12,605.04"},{"v":37005.04,"d":"₪ 37,005.04"},{"v":414800,"d":"₪ 414,800.00"}]
[{"$nulls":10},9,{"v":414800,"d":"₪ 414,800.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":11904.76,"d":"₪ 11,904.76"},{"v":36304.76,"d":"₪ 36,304.76"},{"v":390400,"d":"₪ 390,400.00"}]
[{"$nulls":10},10,{"v":390400,"d":"₪ 390,400.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":11204.48,"d":"₪ 11,204.48"},{"v":35604.479999999996,"d":"₪ 35,604.48"},{"v":366000,"d":"₪ 366,000.00"}]
[{"$nulls":10},11,{"v":366000,"d":"₪ 366,000.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":10504.2,"d":"₪ 10,504.20"},{"v":34904.2,"d":"₪ 34,904.20"},{"v":341600,"d":"₪ 341,600.00"}]
[{"$nulls":10},12,{"v":341600,"d":"₪ 341,600.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":9803.92,"d":"₪ 9,803.92"},{"v":34203.92,"d":"₪ 34,203.92"},{"v":317200,"d":"₪ 317,200.00"}]
[{"$nulls":10},13,{"v":317200,"d":"₪ 317,200.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":9103.64,"d":"₪ 9,103.64"},{"v":33503.64,"d":"₪ 33,503.64"},{"v":292800,"d":"₪ 292,800.00"}]
[{"$nulls":10},14,{"v":292800,"d":"₪ 292,800.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":8403.36,"d":"₪ 8,403.36"},{"v":32803.36,"d":"₪ 32,803.36"},{"v":268400,"d":"₪ 268,400.00"}]
[{"$nulls":10},15,{"v":268400,"d":"₪ 268,400.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":7703.08,"d":"₪ 7,703.08"},{"v":32103.08,"d":"₪ 32,103.08"},{"v":244000,"d":"₪ 244,000.00"}]
[{"$nulls":10},16,{"v":244000,"d":"₪ 244,000.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":7002.8,"d":"₪ 7,002.80"},{"v":31402.8,"d":"₪ 31,402.80"},{"v":219600,"d":"₪ 219,600.00"}]
[{"$nulls":10},17,{"v":219600,"d":"₪ 219,600.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":6302.5199999999995,"d":"₪ 6,302.52"},{"v":30702.52,"d":"₪ 30,702.52"},{"v":195200,"d":"₪ 195,200.00"}]
[{"$nulls":10},18,{"v":195200,"d":"₪ 195,200.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":5602.24,"d":"₪ 5,602.24"},{"v":30002.239999999998,"d":"₪ 30,002.24"},{"v":170800,"d":"₪ 170,800.00"}]
[{"$nulls":10},19,{"v":170800,"d":"₪ 170,800.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":4901.96,"d":"₪ 4,901.96"},{"v":29301.96,"d":"₪ 29,301.96"},{"v":146400,"d":"₪ 146,400.00"}]
[{"$nulls":10},20,{"v":146400,"d":"₪ 146,400.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":4201.68,"d":"₪ 4,201.68"},{"v":28601.68,"d":"₪ 28,601.68"},{"v":122000,"d":"₪ 122,000.00"}]
[{"$nulls":10},21,{"v":122000,"d":"₪ 122,000.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":3501.4,"d":"₪ 3,501.40"},{"v":27901.4,"d":"₪ 27,901.40"},{"v":97600,"d":"₪ 97,600.00"}]
[{"$nulls":10},22,{"v":97600,"d":"₪ 97,600.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":2801.12,"d":"₪ 2,801.12"},{"v":27201.12,"d":"₪ 27,201.12"},{"v":73200,"d":"₪ 73,200.00"}]
[{"$nulls":10},23,{"v":73200,"d":"₪ 73,200.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":2100.84,"d":"₪ 2,100.84"},{"v":26500.84,"d":"₪ 26,500.84"},{"v":48800,"d":"₪ 48,800.00"}]
[{"$nulls":10},24,{"v":48800,"d":"₪ 48,800.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":1400.56,"d":"₪ 1,400.56"},{"v":25800.56,"d":"₪ 25,800.56"},{"v":24400,"d":"₪ 24,400.00"}]
[{"$nulls":10},25,{"v":24400,"d":"₪ 24,400.00"},{"v":24400,"d":"₪ 24,400.00"},{"v":700.28,"d":"₪ 700.28"},{"v":25100.28,"d":"₪ 25,100.28"},{"v":0,"d":"₪ 0.00"}]
[]
[]
[]
[]
[]
[{"$nulls":7},"שאלה 10"]
[]
[]
[]
[]
[]
[]
[{"$nulls":10},"נתונים:"]
[{"$nulls":10},"הלוואה",{"v":120000,"d":"120,000"},"PV"]
[{"$nulls":10},"חודשים",6,"n"]
[{"$nulls":10},"ריבית",{"v":0.008,"d":"0.80%"},"r"]
[]
[{"$nulls":10},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":10},1,{"$f":"L163","v":{"v":120000,"d":"₪ 120,000.00"}},{"v":0,"d":"₪ 0.00"},{"$f":"$L$165*L168","v":{"v":960,"d":"₪ 960.00"}},{"$f":"M168+N168","v":{"v":960,"d":"₪ 960.00"}},{"$f":"L168-M168","v":{"v":120000,"d":"₪ 120,000.00"}}]
[{"$nulls":10},2,{"$f":"P168","v":{"v":120000,"d":"₪ 120,000.00"}},{"v":0,"d":"₪ 0.00"},{"$f":"$L$165*L169","v":{"v":960,"d":"₪ 960.00"}},{"$f":"M169+N169","v":{"v":960,"d":"₪ 960.00"}},{"$f":"L169-M169","v":{"v":120000,"d":"₪ 120,000.00"}}]
[{"$nulls":10},3,{"$f":"P169","v":{"v":120000,"d":"₪ 120,000.00"}},{"v":0,"d":"₪ 0.00"},{"v":960,"d":"₪ 960.00"},{"v":960,"d":"₪ 960.00"},{"v":120000,"d":"₪ 120,000.00"}]
[{"$nulls":10},4,{"v":120000,"d":"₪ 120,000.00"},{"v":0,"d":"₪ 0.00"},{"v":960,"d":"₪ 960.00"},{"v":960,"d":"₪ 960.00"},{"v":120000,"d":"₪ 120,000.00"}]
[{"$nulls":10},5,{"v":120000,"d":"₪ 120,000.00"},{"v":0,"d":"₪ 0.00"},{"v":960,"d":"₪ 960.00"},{"v":960,"d":"₪ 960.00"},{"v":120000,"d":"₪ 120,000.00"}]
[{"$nulls":10},6,{"v":120000,"d":"₪ 120,000.00"},{"$f":"L163","v":{"v":120000,"d":"₪ 120,000.00"}},{"v":960,"d":"₪ 960.00"},{"v":120960,"d":"₪ 120,960.00"},{"v":0,"d":"₪ 0.00"}]
{"$rows_empty":9}
[{"$nulls":7},"שאלה 11"]
[]
[]
[]
[]
[{"$nulls":10},"נתונים:"]
[{"$nulls":10},"הלוואה",{"v":35000,"d":"35,000"},"PV"]
[{"$nulls":10},"חודשים",8,"n"]
[{"$nulls":10},"ריבית שנתית אפקטיבית",{"v":0.0616,"d":"6.16%"},"r"]
[{"$nulls":10},"ריבית חודשית",{"$f":"(1+L191)^(1/12)-1","v":{"v":0.004993861638155073,"d":"0.50%"}},"r"]
[]
[{"$nulls":10},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":10},1,{"$f":"L189","v":{"v":35000,"d":"₪ 35,000.00"}},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"$f":"N195+M195","v":{"v":0,"d":"₪ 0.00"}},{"$f":"FV($L$192,K195,,-$L$189)","v":{"v":35174.78515733543,"d":"₪ 35,174.79"}}]
[{"$nulls":10},2,{"$f":"P195","v":{"v":35174.78515733543,"d":"₪ 35,174.79"}},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"$f":"N196+M196","v":{"v":0,"d":"₪ 0.00"}},{"$f":"FV($L$192,K196,,-$L$189)","v":{"v":35350.44316756299,"d":"₪ 35,350.44"}}]
[{"$nulls":10},3,{"$f":"P196","v":{"v":35350.44316756299,"d":"₪ 35,350.44"}},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"$f":"FV($L$192,K197,,-$L$189)","v":{"v":35526.97838958926,"d":"₪ 35,526.98"}}]
[{"$nulls":10},4,{"v":35526.97838958926,"d":"₪ 35,526.98"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":35704.39520408859,"d":"₪ 35,704.40"}]
[{"$nulls":10},5,{"v":35704.39520408859,"d":"₪ 35,704.40"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":35882.698013611815,"d":"₪ 35,882.70"}]
[{"$nulls":10},6,{"v":35882.698013611815,"d":"₪ 35,882.70"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":36061.89124269549,"d":"₪ 36,061.89"}]
[{"$nulls":10},7,{"v":36061.89124269549,"d":"₪ 36,061.89"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":0,"d":"₪ 0.00"},{"v":36241.97933797171,"d":"₪ 36,241.98"}]
[{"$nulls":10},8,{"v":36241.97933797171,"d":"₪ 36,241.98"},{"$f":"L189","v":{"v":35000,"d":"₪ 35,000.00"}},{"$f":"O202-M202","v":{"v":1422.966768278413,"d":"₪ 1,422.97"}},{"$f":"FV(L192,L190,,-L189)","v":{"v":36422.96676827841,"d":"₪ 36,422.97"}},{"$f":"FV($L$192,K202,,-$L$189)","v":{"v":36422.96676827841,"d":"₪ 36,422.97"}}]

{"sheet":"שאלות סיכום  12-15","index":2,"n_rows":316,"n_cols":16,"rows_kept":316}
[]
[]
[{"$nulls":6},"שאלה 12"]
[]
[]
[]
[]
[]
[{"$nulls":10},"נתונים:"]
[{"$nulls":10},"הלוואה",{"v":85000,"d":"85,000"},"PV",null,{"v":0.0744,"d":"7.44%"}]
[{"$nulls":10},"חודשים",{"$f":"2*12","v":24},"n",null,12]
[{"$nulls":10},"ריבית",{"$f":"(1+O10)^(1/O11)-1","v":{"v":0.005998114262842247,"d":"0.60%"}},"r"]
[{"$nulls":11},{"$f":"PMT(L12,L11,-L10,,)","v":{"v":3813.2933884246236,"d":"₪ 3,813.29"}},"PMT"]
[{"$nulls":10},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":10},1,{"$f":"L10","v":{"v":85000,"d":"₪ 85,000.00"}},{"$f":"O15-N15","v":{"v":3303.4536760830324,"d":"₪ 3,303.45"}},{"$f":"$L$12*L15","v":{"v":509.839712341591,"d":"₪ 509.84"}},{"$f":"$L$13","v":{"v":3813.2933884246236,"d":"₪ 3,813.29"}},{"$f":"L15-M15","v":{"v":81696.54632391696,"d":"₪ 81,696.55"}}]
[{"$nulls":10},2,{"$f":"P15","v":{"v":81696.54632391696,"d":"₪ 81,696.55"}},{"$f":"O16-N16","v":{"v":3323.268168694185,"d":"₪ 3,323.27"}},{"$f":"$L$12*L16","v":{"v":490.02521973043866,"d":"₪ 490.03"}},{"$f":"$L$13","v":{"v":3813.2933884246236,"d":"₪ 3,813.29"}},{"$f":"L16-M16","v":{"v":78373.27815522278,"d":"₪ 78,373.28"}}]
[{"$nulls":10},3,{"$f":"P16","v":{"v":78373.27815522278,"d":"₪ 78,373.28"}},{"v":3343.201510896079,"d":"₪ 3,343.20"},{"v":470.09187752854444,"d":"₪ 470.09"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":75030.0766443267,"d":"₪ 75,030.08"}]
[{"$nulls":10},4,{"v":75030.0766443267,"d":"₪ 75,030.08"},{"v":3363.254415562141,"d":"₪ 3,363.25"},{"v":450.038972862483,"d":"₪ 450.04"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":71666.82222876456,"d":"₪ 71,666.82"}]
[{"$nulls":10},5,{"v":71666.82222876456,"d":"₪ 71,666.82"},{"v":3383.427599841691,"d":"₪ 3,383.43"},{"v":429.8657885829325,"d":"₪ 429.87"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":68283.39462892288,"d":"₪ 68,283.39"}]
[{"$nulls":10},6,{"v":68283.39462892288,"d":"₪ 68,283.39"},{"v":3403.7217851855958,"d":"₪ 3,403.72"},{"v":409.571603239028,"d":"₪ 409.57"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":64879.67284373728,"d":"₪ 64,879.67"}]
[{"$nulls":10},7,{"v":64879.67284373728,"d":"₪ 64,879.67"},{"v":3424.1376973720644,"d":"₪ 3,424.14"},{"v":389.15569105255935,"d":"₪ 389.16"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":61455.53514636522,"d":"₪ 61,455.54"}]
[{"$nulls":10},8,{"v":61455.53514636522,"d":"₪ 61,455.54"},{"v":3444.6760665326074,"d":"₪ 3,444.68"},{"v":368.6173218920162,"d":"₪ 368.62"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":58010.85907983261,"d":"₪ 58,010.86"}]
[{"$nulls":10},9,{"v":58010.85907983261,"d":"₪ 58,010.86"},{"v":3465.337627178148,"d":"₪ 3,465.34"},{"v":347.9557612464756,"d":"₪ 347.96"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":54545.521452654466,"d":"₪ 54,545.52"}]
[{"$nulls":10},10,{"v":54545.521452654466,"d":"₪ 54,545.52"},{"v":3486.123118225289,"d":"₪ 3,486.12"},{"v":327.1702701993345,"d":"₪ 327.17"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":51059.39833442918,"d":"₪ 51,059.40"}]
[{"$nulls":10},11,{"v":51059.39833442918,"d":"₪ 51,059.40"},{"v":3507.0332830227403,"d":"₪ 3,507.03"},{"v":306.2601054018833,"d":"₪ 306.26"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":47552.365051406436,"d":"₪ 47,552.37"}]
[{"$nulls":10},12,{"v":47552.365051406436,"d":"₪ 47,552.37"},{"v":3528.0688693779016,"d":"₪ 3,528.07"},{"v":285.22451904672215,"d":"₪ 285.22"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":44024.296182028535,"d":"₪ 44,024.30"}]
[{"$nulls":10},13,{"v":44024.296182028535,"d":"₪ 44,024.30"},{"v":3549.230629583607,"d":"₪ 3,549.23"},{"v":264.06275884101683,"d":"₪ 264.06"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":40475.065552444925,"d":"₪ 40,475.07"}]
[{"$nulls":10},14,{"v":40475.065552444925,"d":"₪ 40,475.07"},{"v":3570.519320445029,"d":"₪ 3,570.52"},{"v":242.7740679795948,"d":"₪ 242.77"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":36904.5462319999,"d":"₪ 36,904.55"}]
[{"$nulls":10},15,{"v":36904.5462319999,"d":"₪ 36,904.55"},{"v":3591.935703306744,"d":"₪ 3,591.94"},{"v":221.3576851178797,"d":"₪ 221.36"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":33312.610528693156,"d":"₪ 33,312.61"}]
[{"$nulls":10},16,{"v":33312.610528693156,"d":"₪ 33,312.61"},{"v":3613.4805440799605,"d":"₪ 3,613.48"},{"v":199.81284434466323,"d":"₪ 199.81"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":29699.129984613195,"d":"₪ 29,699.13"}]
[{"$nulls":10},17,{"v":29699.129984613195,"d":"₪ 29,699.13"},{"v":3635.1546132699095,"d":"₪ 3,635.15"},{"v":178.13877515471424,"d":"₪ 178.14"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":26063.975371343287,"d":"₪ 26,063.98"}]
[{"$nulls":10},18,{"v":26063.975371343287,"d":"₪ 26,063.98"},{"v":3656.9586860034005,"d":"₪ 3,656.96"},{"v":156.33470242122323,"d":"₪ 156.33"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":22407.016685339888,"d":"₪ 22,407.02"}]
[{"$nulls":10},19,{"v":22407.016685339888,"d":"₪ 22,407.02"},{"v":3678.893542056542,"d":"₪ 3,678.89"},{"v":134.3998463680814,"d":"₪ 134.40"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":18728.123143283345,"d":"₪ 18,728.12"}]
[{"$nulls":10},20,{"v":18728.123143283345,"d":"₪ 18,728.12"},{"v":3700.9599658826296,"d":"₪ 3,700.96"},{"v":112.3334225419938,"d":"₪ 112.33"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":15027.163177400715,"d":"₪ 15,027.16"}]
[{"$nulls":10},21,{"v":15027.163177400715,"d":"₪ 15,027.16"},{"v":3723.1587466401984,"d":"₪ 3,723.16"},{"v":90.13464178442504,"d":"₪ 90.13"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":11304.004430760517,"d":"₪ 11,304.00"}]
[{"$nulls":10},22,{"v":11304.004430760517,"d":"₪ 11,304.00"},{"v":3745.490678221247,"d":"₪ 3,745.49"},{"v":67.8027102033766,"d":"₪ 67.80"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":7558.513752539269,"d":"₪ 7,558.51"}]
[{"$nulls":10},23,{"v":7558.513752539269,"d":"₪ 7,558.51"},{"v":3767.9565592796284,"d":"₪ 3,767.96"},{"v":45.336829144995065,"d":"₪ 45.34"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":3790.557193259641,"d":"₪ 3,790.56"}]
[{"$nulls":10},24,{"v":3790.557193259641,"d":"₪ 3,790.56"},{"v":3790.5571932596135,"d":"₪ 3,790.56"},{"v":22.736195165009928,"d":"₪ 22.74"},{"v":3813.2933884246236,"d":"₪ 3,813.29"},{"v":2.7284841053187847E-11,"d":"₪ 0.00"}]
[]
[{"$nulls":10},"סעיף ב",{"$f":"P26","v":{"v":44024.296182028535,"d":"44,024.30"}}]
[]
[]
[{"$nulls":6},"שאלה 13"]
[]
[]
[]
[]
[]
[]
[{"$nulls":10},"נתונים:",null,null,"סעיף ב",{"$f":"P67","v":{"v":42499.99999999999,"d":"₪ 42,500.00"}}]
[{"$nulls":10},"הלוואה",{"v":85000,"d":"85,000"},"PV",null,{"v":0.0873,"d":"8.73%"}]
[{"$nulls":10},"חודשים",{"$f":"2*12","v":24},"n",null,12]
[{"$nulls":10},"ריבית",{"$f":"(1+O51)^(1/O52)-1","v":{"v":0.006999177128982348,"d":"0.70%"}},"r"]
[{"$nulls":11},{"$f":"L51/L52","v":{"v":3541.6666666666665,"d":"₪ 3,541.67"}},"החזר קרן שווה"]
[{"$nulls":10},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":10},1,{"$f":"L51","v":{"v":85000,"d":"₪ 85,000.00"}},{"$f":"$L$54","v":{"v":3541.6666666666665,"d":"₪ 3,541.67"}},{"$f":"$L$53*L56","v":{"v":594.9300559634996,"d":"₪ 594.93"}},{"$f":"M56+N56","v":{"v":4136.596722630166,"d":"₪ 4,136.60"}},{"$f":"L56-M56","v":{"v":81458.33333333333,"d":"₪ 81,458.33"}}]
[{"$nulls":10},2,{"$f":"P56","v":{"v":81458.33333333333,"d":"₪ 81,458.33"}},{"$f":"$L$54","v":{"v":3541.6666666666665,"d":"₪ 3,541.67"}},{"$f":"$L$53*L57","v":{"v":570.141303631687,"d":"₪ 570.14"}},{"$f":"M57+N57","v":{"v":4111.807970298353,"d":"₪ 4,111.81"}},{"$f":"L57-M57","v":{"v":77916.66666666666,"d":"₪ 77,916.67"}}]
[{"$nulls":10},3,{"$f":"P57","v":{"v":77916.66666666666,"d":"₪ 77,916.67"}},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":545.3525512998746,"d":"₪ 545.35"},{"v":4087.019217966541,"d":"₪ 4,087.02"},{"v":74374.99999999999,"d":"₪ 74,375.00"}]
[{"$nulls":10},4,{"v":74374.99999999999,"d":"₪ 74,375.00"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":520.563798968062,"d":"₪ 520.56"},{"v":4062.2304656347287,"d":"₪ 4,062.23"},{"v":70833.33333333331,"d":"₪ 70,833.33"}]
[{"$nulls":10},5,{"v":70833.33333333331,"d":"₪ 70,833.33"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":495.7750466362495,"d":"₪ 495.78"},{"v":4037.441713302916,"d":"₪ 4,037.44"},{"v":67291.66666666664,"d":"₪ 67,291.67"}]
[{"$nulls":10},6,{"v":67291.66666666664,"d":"₪ 67,291.67"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":470.98629430443697,"d":"₪ 470.99"},{"v":4012.6529609711033,"d":"₪ 4,012.65"},{"v":63749.99999999998,"d":"₪ 63,750.00"}]
[{"$nulls":10},7,{"v":63749.99999999998,"d":"₪ 63,750.00"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":446.19754197262455,"d":"₪ 446.20"},{"v":3987.864208639291,"d":"₪ 3,987.86"},{"v":60208.333333333314,"d":"₪ 60,208.33"}]
[{"$nulls":10},8,{"v":60208.333333333314,"d":"₪ 60,208.33"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":421.4087896408121,"d":"₪ 421.41"},{"v":3963.075456307479,"d":"₪ 3,963.08"},{"v":56666.66666666665,"d":"₪ 56,666.67"}]
[{"$nulls":10},9,{"v":56666.66666666665,"d":"₪ 56,666.67"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":396.6200373089996,"d":"₪ 396.62"},{"v":3938.286703975666,"d":"₪ 3,938.29"},{"v":53124.999999999985,"d":"₪ 53,125.00"}]
[{"$nulls":10},10,{"v":53124.999999999985,"d":"₪ 53,125.00"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":371.8312849771871,"d":"₪ 371.83"},{"v":3913.4979516438534,"d":"₪ 3,913.50"},{"v":49583.33333333332,"d":"₪ 49,583.33"}]
[{"$nulls":10},11,{"v":49583.33333333332,"d":"₪ 49,583.33"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":347.04253264537465,"d":"₪ 347.04"},{"v":3888.709199312041,"d":"₪ 3,888.71"},{"v":46041.66666666666,"d":"₪ 46,041.67"}]
[{"$nulls":10},12,{"v":46041.66666666666,"d":"₪ 46,041.67"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":322.2537803135622,"d":"₪ 322.25"},{"v":3863.920446980229,"d":"₪ 3,863.92"},{"v":42499.99999999999,"d":"₪ 42,500.00"}]
[{"$nulls":10},13,{"v":42499.99999999999,"d":"₪ 42,500.00"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":297.46502798174976,"d":"₪ 297.47"},{"v":3839.131694648416,"d":"₪ 3,839.13"},{"v":38958.33333333333,"d":"₪ 38,958.33"}]
[{"$nulls":10},14,{"v":38958.33333333333,"d":"₪ 38,958.33"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":272.6762756499373,"d":"₪ 272.68"},{"v":3814.342942316604,"d":"₪ 3,814.34"},{"v":35416.666666666664,"d":"₪ 35,416.67"}]
[{"$nulls":10},15,{"v":35416.666666666664,"d":"₪ 35,416.67"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":247.8875233181248,"d":"₪ 247.89"},{"v":3789.5541899847913,"d":"₪ 3,789.55"},{"v":31874.999999999996,"d":"₪ 31,875.00"}]
[{"$nulls":10},16,{"v":31874.999999999996,"d":"₪ 31,875.00"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":223.0987709863123,"d":"₪ 223.10"},{"v":3764.765437652979,"d":"₪ 3,764.77"},{"v":28333.33333333333,"d":"₪ 28,333.33"}]
[{"$nulls":10},17,{"v":28333.33333333333,"d":"₪ 28,333.33"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":198.31001865449983,"d":"₪ 198.31"},{"v":3739.9766853211663,"d":"₪ 3,739.98"},{"v":24791.66666666666,"d":"₪ 24,791.67"}]
[{"$nulls":10},18,{"v":24791.66666666666,"d":"₪ 24,791.67"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":173.52126632268732,"d":"₪ 173.52"},{"v":3715.1879329893536,"d":"₪ 3,715.19"},{"v":21249.999999999993,"d":"₪ 21,250.00"}]
[{"$nulls":10},19,{"v":21249.999999999993,"d":"₪ 21,250.00"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":148.73251399087485,"d":"₪ 148.73"},{"v":3690.3991806575414,"d":"₪ 3,690.40"},{"v":17708.333333333325,"d":"₪ 17,708.33"}]
[{"$nulls":10},20,{"v":17708.333333333325,"d":"₪ 17,708.33"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":123.94376165906235,"d":"₪ 123.94"},{"v":3665.6104283257287,"d":"₪ 3,665.61"},{"v":14166.666666666659,"d":"₪ 14,166.67"}]
[{"$nulls":10},21,{"v":14166.666666666659,"d":"₪ 14,166.67"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":99.15500932724987,"d":"₪ 99.16"},{"v":3640.8216759939164,"d":"₪ 3,640.82"},{"v":10624.999999999993,"d":"₪ 10,625.00"}]
[{"$nulls":10},22,{"v":10624.999999999993,"d":"₪ 10,625.00"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":74.3662569954374,"d":"₪ 74.37"},{"v":3616.0329236621037,"d":"₪ 3,616.03"},{"v":7083.333333333327,"d":"₪ 7,083.33"}]
[{"$nulls":10},23,{"v":7083.333333333327,"d":"₪ 7,083.33"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":49.577504663624914,"d":"₪ 49.58"},{"v":3591.2441713302915,"d":"₪ 3,591.24"},{"v":3541.66666666666,"d":"₪ 3,541.67"}]
[{"$nulls":10},24,{"v":3541.66666666666,"d":"₪ 3,541.67"},{"v":3541.6666666666665,"d":"₪ 3,541.67"},{"v":24.788752331812436,"d":"₪ 24.79"},{"v":3566.4554189984788,"d":"₪ 3,566.46"},{"v":-6.366462912410498e-12,"d":"₪ -0.00"}]
[]
[]
[{"$nulls":10},"סעיף ב"]
[]
[]
[]
[]
[]
[{"$nulls":6},"שאלה 14"]
[]
[]
[]
[]
[]
[]
[{"$nulls":10},"נתונים:"]
[{"$nulls":10},{"v":92000,"d":"92,000"},"pv"]
[{"$nulls":10},24,"n"]
[{"$nulls":10},{"v":0.0545,"d":"5.450%"},"r","שנתי",5.45]
[{"$nulls":10},{"$f":"(1+K98)^(1/N99)-1","v":{"v":0.004432019218941319,"d":"0.44%"}},"r","חודשי",12]
[]
[{"$nulls":10},"סעיף א"]
[{"$nulls":10},"תשלום","יתרת הקרן בתחילת התקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך התשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":10},1,{"$f":"K96","v":{"v":92000,"d":"92,000"}},0,{"$f":"$K$99*L103","v":{"v":407.7457681426013,"d":"408"}},{"$f":"N103+M103","v":{"v":407.7457681426013,"d":"408"}},{"$f":"L103-M103","v":{"v":92000,"d":"92,000"}}]
[{"$nulls":10},2,{"$f":"L103-M103","v":{"v":92000,"d":"92,000"}},0,{"$f":"$K$99*L104","v":{"v":407.7457681426013,"d":"408"}},{"$f":"N104+M104","v":{"v":407.7457681426013,"d":"408"}},{"$f":"L104-M104","v":{"v":92000,"d":"92,000"}}]
[{"$nulls":10},3,{"$f":"L104-M104","v":{"v":92000,"d":"92,000"}},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},4,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},5,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},6,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},7,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},8,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},9,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},10,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},11,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},12,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},13,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},14,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},15,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},16,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},17,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},18,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},19,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},20,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},21,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},22,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},23,{"v":92000,"d":"92,000"},0,{"v":407.7457681426013,"d":"408"},{"v":407.7457681426013,"d":"408"},{"v":92000,"d":"92,000"}]
[{"$nulls":10},24,{"v":92000,"d":"92,000"},{"$f":"K96","v":{"v":92000,"d":"92,000"}},{"v":407.7457681426013,"d":"408"},{"v":92407.7457681426,"d":"92408"},0]
[{"$nulls":13},{"$f":"SUM(N103:N126)","v":{"v":9785.898435422434,"d":"9,786"}}]
[{"$nulls":10},"סעיף ב"]
[]
[{"$nulls":11},{"$f":"K96","v":{"v":92000,"d":"92,000"}}]
[]
[]
[]
[]
[{"$nulls":6},"שאלה 15"]
[]
[]
[]
[]
[]
[{"$nulls":10},"נתונים:"]
[{"$nulls":10},{"v":76000,"d":"76,000"},"pv"]
[{"$nulls":10},24,"n"]
[{"$nulls":11},"r","שנתי"]
[{"$nulls":10},{"v":0.006,"d":"0.60%"},"r","חודשי",12]
[]
[{"$nulls":10},"סעיף א"]
[{"$nulls":10},"תשלום","יתרת הקרן בתחילת התקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך התשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":10},1,{"$f":"K142","v":{"v":76000,"d":"76,000"}},0,0,{"$f":"M149+N149","v":0},{"$f":"FV($K$145,K149,,-$K$142)","v":{"v":76456,"d":"76,456"}}]
[{"$nulls":10},2,{"$f":"P149","v":{"v":76456,"d":"76,456"}},0,0,{"$f":"M150+N150","v":0},{"$f":"FV($K$145,K150,,-$K$142)","v":{"v":76914.73599999999,"d":"76,915"}}]
[{"$nulls":10},3,{"$f":"P150","v":{"v":76914.73599999999,"d":"76,915"}},0,0,0,{"v":77376.224416,"d":"77,376"}]
[{"$nulls":10},4,{"v":77376.224416,"d":"77,376"},0,0,0,{"v":77840.481762496,"d":"77,840"}]
[{"$nulls":10},5,{"v":77840.481762496,"d":"77,840"},0,0,0,{"v":78307.52465307097,"d":"78,308"}]
[{"$nulls":10},6,{"v":78307.52465307097,"d":"78,308"},0,0,0,{"v":78777.3698009894,"d":"78,777"}]
[{"$nulls":10},7,{"v":78777.3698009894,"d":"78,777"},0,0,0,{"v":79250.03401979532,"d":"79,250"}]
[{"$nulls":10},8,{"v":79250.03401979532,"d":"79,250"},0,0,0,{"v":79725.5342239141,"d":"79,726"}]
[{"$nulls":10},9,{"v":79725.5342239141,"d":"79,726"},0,0,0,{"v":80203.8874292576,"d":"80,204"}]
[{"$nulls":10},10,{"v":80203.8874292576,"d":"80,204"},0,0,0,{"v":80685.11075383313,"d":"80,685"}]
[{"$nulls":10},11,{"v":80685.11075383313,"d":"80,685"},0,0,0,{"v":81169.22141835613,"d":"81,169"}]
[{"$nulls":10},12,{"v":81169.22141835613,"d":"81,169"},0,0,0,{"v":81656.23674686627,"d":"81,656"}]
[{"$nulls":10},13,{"v":81656.23674686627,"d":"81,656"},0,0,0,{"v":82146.17416734748,"d":"82,146"}]
[{"$nulls":10},14,{"v":82146.17416734748,"d":"82,146"},0,0,0,{"v":82639.05121235155,"d":"82,639"}]
[{"$nulls":10},15,{"v":82639.05121235155,"d":"82,639"},0,0,0,{"v":83134.88551962565,"d":"83,135"}]
[{"$nulls":10},16,{"v":83134.88551962565,"d":"83,135"},0,0,0,{"v":83633.69483274342,"d":"83,634"}]
[{"$nulls":10},17,{"v":83633.69483274342,"d":"83,634"},0,0,0,{"v":84135.49700173987,"d":"84,135"}]
[{"$nulls":10},18,{"v":84135.49700173987,"d":"84,135"},0,0,0,{"v":84640.30998375031,"d":"84,640"}]
[{"$nulls":10},19,{"v":84640.30998375031,"d":"84,640"},0,0,0,{"v":85148.15184365281,"d":"85,148"}]
[{"$nulls":10},20,{"v":85148.15184365281,"d":"85,148"},0,0,0,{"v":85659.04075471473,"d":"85,659"}]
[{"$nulls":10},21,{"v":85659.04075471473,"d":"85,659"},0,0,0,{"v":86172.99499924302,"d":"86,173"}]
[{"$nulls":10},22,{"v":86172.99499924302,"d":"86,173"},0,0,0,{"v":86690.03296923847,"d":"86,690"}]
[{"$nulls":10},23,{"v":86690.03296923847,"d":"86,690"},0,0,0,{"v":87210.1731670539,"d":"87,210"}]
[{"$nulls":10},24,{"v":87210.1731670539,"d":"87,210"},{"$f":"K142","v":{"v":76000,"d":"76,000"}},{"$f":"P172-M172","v":{"v":11733.434206056234,"d":"11,733"}},{"v":87733.43420605623,"d":"87,733"},{"v":87733.43420605623,"d":"87,733"}]
[]
[]
[{"$nulls":10},"סעיף ב"]
[{"$nulls":11},{"$f":"FV(K145,N145,,-K142)","v":{"v":81656.23674686627,"d":"81,656.24"}}]
{"$rows_empty":69}
[{"$nulls":10},"נתונים:"]
[{"$nulls":10},{"v":300000,"d":"300,000"},"pv"]
[{"$nulls":10},60,"n"]
[{"$nulls":10},{"v":0.03659,"d":"3.659%"},"r","שנתי"]
[{"$nulls":10},{"$f":"(1+K249)^(1/N250)-1","v":{"v":2.999195263894805E-3,"d":"0.30%"}},"r","חודשי",12,{"$f":"60-30","v":30}]
[]
[{"$nulls":10},"סעיף א"]
[{"$nulls":10},"תשלום","יתרת הקרן בתחילת התקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך התשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":10},1,{"$f":"K247","v":{"v":300000,"d":"300,000.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"N254+M254","v":{"v":0,"d":"0.00"}},{"$f":"FV($K$250,K254,,-$K$247,0)","v":{"v":300899.75857916847,"d":"300,899.76"}}]
[{"$nulls":10},2,{"$f":"P254","v":{"v":300899.75857916847,"d":"300,899.76"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"N255+M255","v":{"v":0,"d":"0.00"}},{"$f":"FV($K$250,K255,,-$K$247,0)","v":{"v":301802.2157100062,"d":"301,802.22"}}]
[{"$nulls":10},3,{"$f":"P255","v":{"v":301802.2157100062,"d":"301,802.22"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":302707.3794859966,"d":"302,707.38"}]
[{"$nulls":10},4,{"v":302707.3794859966,"d":"302,707.38"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":303615.2580248971,"d":"303,615.26"}]
[{"$nulls":10},5,{"v":303615.2580248971,"d":"303,615.26"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":304525.85946881154,"d":"304,525.86"}]
[{"$nulls":10},6,{"v":304525.85946881154,"d":"304,525.86"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":305439.19198426395,"d":"305,439.19"}]
[{"$nulls":10},7,{"v":305439.19198426395,"d":"305,439.19"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":306355.26376227103,"d":"306,355.26"}]
[{"$nulls":10},8,{"v":306355.26376227103,"d":"306,355.26"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":307274.0830184161,"d":"307,274.08"}]
[{"$nulls":10},9,{"v":307274.0830184161,"d":"307,274.08"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":308195.6579929225,"d":"308,195.66"}]
[{"$nulls":10},10,{"v":308195.6579929225,"d":"308,195.66"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":309119.9969507279,"d":"309,120.00"}]
[{"$nulls":10},11,{"v":309119.9969507279,"d":"309,120.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":310047.10818155773,"d":"310,047.11"}]
[{"$nulls":10},12,{"v":310047.10818155773,"d":"310,047.11"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":310977.0000000002,"d":"310,977.00"}]
[{"$nulls":10},13,{"v":310977.0000000002,"d":"310,977.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":311909.6807455804,"d":"311,909.68"}]
[{"$nulls":10},14,{"v":311909.6807455804,"d":"311,909.68"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":312845.1587828355,"d":"312,845.16"}]
[{"$nulls":10},15,{"v":312845.1587828355,"d":"312,845.16"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":313783.4425013894,"d":"313,783.44"}]
[{"$nulls":10},16,{"v":313783.4425013894,"d":"313,783.44"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":314724.54031602823,"d":"314,724.54"}]
[{"$nulls":10},17,{"v":314724.54031602823,"d":"314,724.54"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":315668.4606667756,"d":"315,668.46"}]
[{"$nulls":10},18,{"v":315668.4606667756,"d":"315,668.46"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":316615.2120189683,"d":"316,615.21"}]
[{"$nulls":10},19,{"v":316615.2120189683,"d":"316,615.21"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":317564.80286333273,"d":"317,564.80"}]
[{"$nulls":10},20,{"v":317564.80286333273,"d":"317,564.80"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":318517.24171606015,"d":"318,517.24"}]
[{"$nulls":10},21,{"v":318517.24171606015,"d":"318,517.24"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":319472.53711888375,"d":"319,472.54"}]
[{"$nulls":10},22,{"v":319472.53711888375,"d":"319,472.54"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":320430.69763915526,"d":"320,430.70"}]
[{"$nulls":10},23,{"v":320430.69763915526,"d":"320,430.70"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":321391.7318699211,"d":"321,391.73"}]
[{"$nulls":10},24,{"v":321391.7318699211,"d":"321,391.73"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":322355.6484300004,"d":"322,355.65"}]
[{"$nulls":10},25,{"v":322355.6484300004,"d":"322,355.65"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":323322.4559640614,"d":"323,322.46"}]
[{"$nulls":10},26,{"v":323322.4559640614,"d":"323,322.46"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":324292.16314269963,"d":"324,292.16"}]
[{"$nulls":10},27,{"v":324292.16314269963,"d":"324,292.16"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":325264.77866251545,"d":"325,264.78"}]
[{"$nulls":10},28,{"v":325264.77866251545,"d":"325,264.78"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":326240.3112461919,"d":"326,240.31"}]
[{"$nulls":10},29,{"v":326240.3112461919,"d":"326,240.31"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":327218.7696425731,"d":"327,218.77"}]
[{"$nulls":10},30,{"v":327218.7696425731,"d":"327,218.77"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":328200.16262674256,"d":"328,200.16"}]
[{"$nulls":10},31,{"v":328200.16262674256,"d":"328,200.16"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":329184.4990001022,"d":"329,184.50"}]
[{"$nulls":10},32,{"v":329184.4990001022,"d":"329,184.50"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":330171.787590451,"d":"330,171.79"}]
[{"$nulls":10},33,{"v":330171.787590451,"d":"330,171.79"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":331162.0372520639,"d":"331,162.04"}]
[{"$nulls":10},34,{"v":331162.0372520639,"d":"331,162.04"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":332155.2568657721,"d":"332,155.26"}]
[{"$nulls":10},35,{"v":332155.2568657721,"d":"332,155.26"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":333151.4553390418,"d":"333,151.46"}]
[{"$nulls":10},36,{"v":333151.4553390418,"d":"333,151.46"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":334150.6416060543,"d":"334,150.64"}]
[{"$nulls":10},37,{"v":334150.6416060543,"d":"334,150.64"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":335152.8246277866,"d":"335,152.82"}]
[{"$nulls":10},38,{"v":335152.8246277866,"d":"335,152.82"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":336158.01339209126,"d":"336,158.01"}]
[{"$nulls":10},39,{"v":336158.01339209126,"d":"336,158.01"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":337166.21691377717,"d":"337,166.22"}]
[{"$nulls":10},40,{"v":337166.21691377717,"d":"337,166.22"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"FV($K$250,K293,,-$K$247,0)","v":{"v":338177.4442346903,"d":"338,177.44"}}]
[{"$nulls":10},41,{"v":338177.4442346903,"d":"338,177.44"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":339191.70442379505,"d":"339,191.70"}]
[{"$nulls":10},42,{"v":339191.70442379505,"d":"339,191.70"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":340209.0065772553,"d":"340,209.01"}]
[{"$nulls":10},43,{"v":340209.0065772553,"d":"340,209.01"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":341229.3598185162,"d":"341,229.36"}]
[{"$nulls":10},44,{"v":341229.3598185162,"d":"341,229.36"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":342252.77329838584,"d":"342,252.77"}]
[{"$nulls":10},45,{"v":342252.77329838584,"d":"342,252.77"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":343279.25619511714,"d":"343,279.26"}]
[{"$nulls":10},46,{"v":343279.25619511714,"d":"343,279.26"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":344308.8177144909,"d":"344,308.82"}]
[{"$nulls":10},47,{"v":344308.8177144909,"d":"344,308.82"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":345341.4670898975,"d":"345,341.47"}]
[{"$nulls":10},48,{"v":345341.4670898975,"d":"345,341.47"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":346377.21358242,"d":"346,377.21"}]
[{"$nulls":10},49,{"v":346377.21358242,"d":"346,377.21"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":347416.06648091757,"d":"347,416.07"}]
[{"$nulls":10},50,{"v":347416.06648091757,"d":"347,416.07"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":348458.0351021081,"d":"348,458.04"}]
[{"$nulls":10},51,{"v":348458.0351021081,"d":"348,458.04"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":349503.12879065244,"d":"349,503.13"}]
[{"$nulls":10},52,{"v":349503.12879065244,"d":"349,503.13"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":350551.3569192379,"d":"350,551.36"}]
[{"$nulls":10},53,{"v":350551.3569192379,"d":"350,551.36"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":351602.7288886619,"d":"351,602.73"}]
[{"$nulls":10},54,{"v":351602.7288886619,"d":"351,602.73"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":352657.25412791735,"d":"352,657.25"}]
[{"$nulls":10},55,{"v":352657.25412791735,"d":"352,657.25"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":353714.9420942759,"d":"353,714.94"}]
[{"$nulls":10},56,{"v":353714.9420942759,"d":"353,714.94"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":354775.802273374,"d":"354,775.80"}]
[{"$nulls":10},57,{"v":354775.802273374,"d":"354,775.80"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":355839.8441792967,"d":"355,839.84"}]
[{"$nulls":10},58,{"v":355839.8441792967,"d":"355,839.84"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":356907.07735466433,"d":"356,907.08"}]
[{"$nulls":10},59,{"v":356907.07735466433,"d":"356,907.08"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"FV($K$250,K312,,-$K$247,0)","v":{"v":357977.511370717,"d":"357,977.51"}}]
[{"$nulls":10},60,{"v":357977.511370717,"d":"357,977.51"},{"$f":"K247","v":{"v":300000,"d":"300,000.00"}},{"$f":"O313-M313","v":{"v":59051.15582740103,"d":"59,051.16"}},{"$f":"FV(K250,K248,,-K247)","v":{"v":359051.15582740103,"d":"359,051.16"}},{"v":0,"d":"0.00"}]
[]
[{"$nulls":10},"סעיף ב'"]
[{"$nulls":11},{"$f":"K247","v":{"v":300000,"d":"300,000"}}]

{"sheet":"שאלות מבחינות 16-19","index":3,"n_rows":333,"n_cols":14,"rows_kept":333,"merged":[[1,8,1,16],[3,8,7,14],[143,8,148,15],[164,8,168,14],[302,8,302,14]]}
[]
[{"$nulls":8},"שאלה 1"]
[]
[{"$nulls":5},"שאלה 16",null,null,"נלקחה הלוואה על סכום של 500,000 ש\"ח אשר תוחזר על פי לוח סילוקין שפיצר \nההלוואה תוחזר בתשלומים חודשיים, למשך 10 שנים.\nהריבית האפקטיבית השנתית הינה 3.65%\nמה יהיה גובה התשלום על חשבון הריבית בתשלום מספר 111?\n"]
[]
[]
[]
[]
[]
[{"$nulls":8},"נתונים:"]
[{"$nulls":8},"הלוואה",{"v":500000,"d":"500,000"},"PV",null,{"v":0.0365,"d":"3.65%"}]
[{"$nulls":8},"חודשים",{"$f":"10*12","v":120},"n",null,12]
[{"$nulls":8},"ריבית",{"$f":"(1+M11)^(1/12)-1","v":{"v":0.002991938013361173,"d":"0.30%"}},"r"]
[{"$nulls":9},{"$f":"PMT(J13,J12,-J11,,)","v":{"v":4965.477474648475,"d":"₪ 4,965.48"}},"PMT"]
[{"$nulls":8},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":8},1,{"$f":"J11","v":{"v":500000,"d":"₪ 500,000.00"}},{"$f":"M16-L16","v":{"v":3469.508467967889,"d":"₪ 3,469.51"}},{"$f":"$J$13*J16","v":{"v":1495.9690066805865,"d":"₪ 1,495.97"}},{"$f":"$J$14","v":{"v":4965.477474648475,"d":"₪ 4,965.48"}},{"$f":"J16-K16","v":{"v":496530.4915320321,"d":"₪ 496,530.49"}}]
[{"$nulls":8},2,{"$f":"N16","v":{"v":496530.4915320321,"d":"₪ 496,530.49"}},{"$f":"M17-L17","v":{"v":3479.889022240881,"d":"₪ 3,479.89"}},{"$f":"$J$13*J17","v":{"v":1485.5884524075948,"d":"₪ 1,485.59"}},{"$f":"$J$14","v":{"v":4965.477474648475,"d":"₪ 4,965.48"}},{"$f":"J17-K17","v":{"v":493050.6025097912,"d":"₪ 493,050.60"}}]
[{"$nulls":8},3,{"$f":"N17","v":{"v":493050.6025097912,"d":"₪ 493,050.60"}},{"v":3490.3006344888017,"d":"₪ 3,490.30"},{"v":1475.176840159674,"d":"₪ 1,475.18"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":489560.3018753024,"d":"₪ 489,560.30"}]
[{"$nulls":8},4,{"v":489560.3018753024,"d":"₪ 489,560.30"},{"v":3500.743397635187,"d":"₪ 3,500.74"},{"v":1464.7340770132882,"d":"₪ 1,464.73"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":486059.5584776672,"d":"₪ 486,059.56"}]
[{"$nulls":8},5,{"v":486059.5584776672,"d":"₪ 486,059.56"},{"v":3511.217404881595,"d":"₪ 3,511.22"},{"v":1454.2600697668804,"d":"₪ 1,454.26"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":482548.3410727856,"d":"₪ 482,548.34"}]
[{"$nulls":8},6,{"v":482548.3410727856,"d":"₪ 482,548.34"},{"v":3521.722749708436,"d":"₪ 3,521.72"},{"v":1443.7547249400398,"d":"₪ 1,443.75"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":479026.61832307716,"d":"₪ 479,026.62"}]
[{"$nulls":8},7,{"v":479026.61832307716,"d":"₪ 479,026.62"},{"v":3532.2595258758074,"d":"₪ 3,532.26"},{"v":1433.2179487726683,"d":"₪ 1,433.22"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":475494.35879720136,"d":"₪ 475,494.36"}]
[{"$nulls":8},8,{"v":475494.35879720136,"d":"₪ 475,494.36"},{"v":3542.827827424332,"d":"₪ 3,542.83"},{"v":1422.6496472241433,"d":"₪ 1,422.65"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":471951.530969777,"d":"₪ 471,951.53"}]
[{"$nulls":8},9,{"v":471951.530969777,"d":"₪ 471,951.53"},{"v":3553.4277486759966,"d":"₪ 3,553.43"},{"v":1412.0497259724787,"d":"₪ 1,412.05"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":468398.10322110105,"d":"₪ 468,398.10"}]
[{"$nulls":8},10,{"v":468398.10322110105,"d":"₪ 468,398.10"},{"v":3564.0593842349926,"d":"₪ 3,564.06"},{"v":1401.4180904134826,"d":"₪ 1,401.42"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":464834.04383686604,"d":"₪ 464,834.04"}]
[{"$nulls":8},11,{"v":464834.04383686604,"d":"₪ 464,834.04"},{"v":3574.7228289885625,"d":"₪ 3,574.72"},{"v":1390.7546456599132,"d":"₪ 1,390.75"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":461259.3210078775,"d":"₪ 461,259.32"}]
[{"$nulls":8},12,{"v":461259.3210078775,"d":"₪ 461,259.32"},{"v":3585.4181781078432,"d":"₪ 3,585.42"},{"v":1380.0592965406324,"d":"₪ 1,380.06"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":457673.90282976965,"d":"₪ 457,673.90"}]
[{"$nulls":8},13,{"v":457673.90282976965,"d":"₪ 457,673.90"},{"v":3596.14552704872,"d":"₪ 3,596.15"},{"v":1369.3319475997555,"d":"₪ 1,369.33"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":454077.7573027209,"d":"₪ 454,077.76"}]
[{"$nulls":8},14,{"v":454077.7573027209,"d":"₪ 454,077.76"},{"v":3606.9049715526758,"d":"₪ 3,606.90"},{"v":1358.5725030957997,"d":"₪ 1,358.57"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":450470.85233116825,"d":"₪ 450,470.85"}]
[{"$nulls":8},15,{"v":450470.85233116825,"d":"₪ 450,470.85"},{"v":3617.6966076476456,"d":"₪ 3,617.70"},{"v":1347.7808670008299,"d":"₪ 1,347.78"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":446853.1557235206,"d":"₪ 446,853.16"}]
[{"$nulls":8},16,{"v":446853.1557235206,"d":"₪ 446,853.16"},{"v":3628.5205316488746,"d":"₪ 3,628.52"},{"v":1336.956942999601,"d":"₪ 1,336.96"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":443224.6351918717,"d":"₪ 443,224.64"}]
[{"$nulls":8},17,{"v":443224.6351918717,"d":"₪ 443,224.64"},{"v":3639.3768401597763,"d":"₪ 3,639.38"},{"v":1326.1006344886994,"d":"₪ 1,326.10"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":439585.25835171196,"d":"₪ 439,585.26"}]
[{"$nulls":8},18,{"v":439585.25835171196,"d":"₪ 439,585.26"},{"v":3650.2656300727967,"d":"₪ 3,650.27"},{"v":1315.211844575679,"d":"₪ 1,315.21"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":435934.99272163917,"d":"₪ 435,934.99"}]
[{"$nulls":8},19,{"v":435934.99272163917,"d":"₪ 435,934.99"},{"v":3661.186998570277,"d":"₪ 3,661.19"},{"v":1304.2904760781985,"d":"₪ 1,304.29"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":432273.8057230689,"d":"₪ 432,273.81"}]
[{"$nulls":8},20,{"v":432273.8057230689,"d":"₪ 432,273.81"},{"v":3672.1410431253234,"d":"₪ 3,672.14"},{"v":1293.3364315231522,"d":"₪ 1,293.34"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":428601.6646799436,"d":"₪ 428,601.66"}]
[{"$nulls":8},21,{"v":428601.6646799436,"d":"₪ 428,601.66"},{"v":3683.1278615026736,"d":"₪ 3,683.13"},{"v":1282.3496131458019,"d":"₪ 1,282.35"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":424918.5368184409,"d":"₪ 424,918.54"}]
[{"$nulls":8},22,{"v":424918.5368184409,"d":"₪ 424,918.54"},{"v":3694.1475517595727,"d":"₪ 3,694.15"},{"v":1271.3299228889025,"d":"₪ 1,271.33"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":421224.38926668133,"d":"₪ 421,224.39"}]
[{"$nulls":8},23,{"v":421224.38926668133,"d":"₪ 421,224.39"},{"v":3705.2002122466474,"d":"₪ 3,705.20"},{"v":1260.2772624018278,"d":"₪ 1,260.28"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":417519.1890544347,"d":"₪ 417,519.19"}]
[{"$nulls":8},24,{"v":417519.1890544347,"d":"₪ 417,519.19"},{"v":3716.285941608782,"d":"₪ 3,716.29"},{"v":1249.1915330396932,"d":"₪ 1,249.19"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":413802.90311282594,"d":"₪ 413,802.90"}]
[{"$nulls":8},25,{"v":413802.90311282594,"d":"₪ 413,802.90"},{"v":3727.404838786001,"d":"₪ 3,727.40"},{"v":1238.0726358624743,"d":"₪ 1,238.07"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":410075.49827403994,"d":"₪ 410,075.50"}]
[{"$nulls":8},26,{"v":410075.49827403994,"d":"₪ 410,075.50"},{"v":3738.5570030143513,"d":"₪ 3,738.56"},{"v":1226.9204716341242,"d":"₪ 1,226.92"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":406336.9412710256,"d":"₪ 406,336.94"}]
[{"$nulls":8},27,{"v":406336.9412710256,"d":"₪ 406,336.94"},{"v":3749.7425338267876,"d":"₪ 3,749.74"},{"v":1215.7349408216878,"d":"₪ 1,215.73"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":402587.1987371988,"d":"₪ 402,587.20"}]
[{"$nulls":8},28,{"v":402587.1987371988,"d":"₪ 402,587.20"},{"v":3760.961531054061,"d":"₪ 3,760.96"},{"v":1204.5159435944142,"d":"₪ 1,204.52"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":398826.2372061447,"d":"₪ 398,826.24"}]
[{"$nulls":8},29,{"v":398826.2372061447,"d":"₪ 398,826.24"},{"v":3772.214094825611,"d":"₪ 3,772.21"},{"v":1193.2633798228644,"d":"₪ 1,193.26"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":395054.0231113191,"d":"₪ 395,054.02"}]
[{"$nulls":8},30,{"v":395054.0231113191,"d":"₪ 395,054.02"},{"v":3783.5003255704564,"d":"₪ 3,783.50"},{"v":1181.977149078019,"d":"₪ 1,181.98"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":391270.52278574865,"d":"₪ 391,270.52"}]
[{"$nulls":8},31,{"v":391270.52278574865,"d":"₪ 391,270.52"},{"v":3794.820324018095,"d":"₪ 3,794.82"},{"v":1170.6571506303803,"d":"₪ 1,170.66"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":387475.7024617306,"d":"₪ 387,475.70"}]
[{"$nulls":8},32,{"v":387475.7024617306,"d":"₪ 387,475.70"},{"v":3806.1741911994004,"d":"₪ 3,806.17"},{"v":1159.303283449075,"d":"₪ 1,159.30"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":383669.52827053115,"d":"₪ 383,669.53"}]
[{"$nulls":8},33,{"v":383669.52827053115,"d":"₪ 383,669.53"},{"v":3817.5620284475244,"d":"₪ 3,817.56"},{"v":1147.9154462009512,"d":"₪ 1,147.92"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":379851.96624208364,"d":"₪ 379,851.97"}]
[{"$nulls":8},34,{"v":379851.96624208364,"d":"₪ 379,851.97"},{"v":3828.9839373988007,"d":"₪ 3,828.98"},{"v":1136.493537249675,"d":"₪ 1,136.49"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":376022.9823046848,"d":"₪ 376,022.98"}]
[{"$nulls":8},35,{"v":376022.9823046848,"d":"₪ 376,022.98"},{"v":3840.4400199936536,"d":"₪ 3,840.44"},{"v":1125.037454654822,"d":"₪ 1,125.04"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":372182.5422846912,"d":"₪ 372,182.54"}]
[{"$nulls":8},36,{"v":372182.5422846912,"d":"₪ 372,182.54"},{"v":3851.9303784775057,"d":"₪ 3,851.93"},{"v":1113.5470961709696,"d":"₪ 1,113.55"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":368330.6119062137,"d":"₪ 368,330.61"}]
[{"$nulls":8},37,{"v":368330.6119062137,"d":"₪ 368,330.61"},{"v":3863.4551154016935,"d":"₪ 3,863.46"},{"v":1102.0223592467821,"d":"₪ 1,102.02"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":364467.156790812,"d":"₪ 364,467.16"}]
[{"$nulls":8},38,{"v":364467.156790812,"d":"₪ 364,467.16"},{"v":3875.014333624378,"d":"₪ 3,875.01"},{"v":1090.463141024097,"d":"₪ 1,090.46"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":360592.1424571876,"d":"₪ 360,592.14"}]
[{"$nulls":8},39,{"v":360592.1424571876,"d":"₪ 360,592.14"},{"v":3886.6081363114686,"d":"₪ 3,886.61"},{"v":1078.8693383370069,"d":"₪ 1,078.87"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":356705.5343208761,"d":"₪ 356,705.53"}]
[{"$nulls":8},40,{"v":356705.5343208761,"d":"₪ 356,705.53"},{"v":3898.236626937538,"d":"₪ 3,898.24"},{"v":1067.2408477109377,"d":"₪ 1,067.24"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":352807.2976939386,"d":"₪ 352,807.30"}]
[{"$nulls":8},41,{"v":352807.2976939386,"d":"₪ 352,807.30"},{"v":3909.899909286749,"d":"₪ 3,909.90"},{"v":1055.5775653617266,"d":"₪ 1,055.58"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":348897.39778465184,"d":"₪ 348,897.40"}]
[{"$nulls":8},42,{"v":348897.39778465184,"d":"₪ 348,897.40"},{"v":3921.5980874537813,"d":"₪ 3,921.60"},{"v":1043.8793871946941,"d":"₪ 1,043.88"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":344975.79969719803,"d":"₪ 344,975.80"}]
[{"$nulls":8},43,{"v":344975.79969719803,"d":"₪ 344,975.80"},{"v":3933.331265844759,"d":"₪ 3,933.33"},{"v":1032.1462088037165,"d":"₪ 1,032.15"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":341042.4684313533,"d":"₪ 341,042.47"}]
[{"$nulls":8},44,{"v":341042.4684313533,"d":"₪ 341,042.47"},{"v":3945.099549178182,"d":"₪ 3,945.10"},{"v":1020.3779254702936,"d":"₪ 1,020.38"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":337097.36888217507,"d":"₪ 337,097.37"}]
[{"$nulls":8},45,{"v":337097.36888217507,"d":"₪ 337,097.37"},{"v":3956.903042485862,"d":"₪ 3,956.90"},{"v":1008.5744321626133,"d":"₪ 1,008.57"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":333140.4658396892,"d":"₪ 333,140.47"}]
[{"$nulls":8},46,{"v":333140.4658396892,"d":"₪ 333,140.47"},{"v":3968.7418511138603,"d":"₪ 3,968.74"},{"v":996.7356235346153,"d":"₪ 996.74"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":329171.72398857534,"d":"₪ 329,171.72"}]
[{"$nulls":8},47,{"v":329171.72398857534,"d":"₪ 329,171.72"},{"v":3980.616080723425,"d":"₪ 3,980.62"},{"v":984.8613939250504,"d":"₪ 984.86"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":325191.1079078519,"d":"₪ 325,191.11"}]
[{"$nulls":8},48,{"v":325191.1079078519,"d":"₪ 325,191.11"},{"v":3992.525837291938,"d":"₪ 3,992.53"},{"v":972.9516373565373,"d":"₪ 972.95"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":321198.58207055996,"d":"₪ 321,198.58"}]
[{"$nulls":8},49,{"v":321198.58207055996,"d":"₪ 321,198.58"},{"v":4004.4712271138587,"d":"₪ 4,004.47"},{"v":961.0062475346168,"d":"₪ 961.01"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":317194.1108434461,"d":"₪ 317,194.11"}]
[{"$nulls":8},50,{"v":317194.1108434461,"d":"₪ 317,194.11"},{"v":4016.4523568016716,"d":"₪ 4,016.45"},{"v":949.0251178468038,"d":"₪ 949.03"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":313177.65848664445,"d":"₪ 313,177.66"}]
[{"$nulls":8},51,{"v":313177.65848664445,"d":"₪ 313,177.66"},{"v":4028.4693332868405,"d":"₪ 4,028.47"},{"v":937.0081413616348,"d":"₪ 937.01"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":309149.1891533576,"d":"₪ 309,149.19"}]
[{"$nulls":8},52,{"v":309149.1891533576,"d":"₪ 309,149.19"},{"v":4040.5222638207615,"d":"₪ 4,040.52"},{"v":924.9552108277142,"d":"₪ 924.96"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":305108.66688953683,"d":"₪ 305,108.67"}]
[{"$nulls":8},53,{"v":305108.66688953683,"d":"₪ 305,108.67"},{"v":4052.611255975719,"d":"₪ 4,052.61"},{"v":912.8662186727566,"d":"₪ 912.87"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":301056.0556335611,"d":"₪ 301,056.06"}]
[{"$nulls":8},54,{"v":301056.0556335611,"d":"₪ 301,056.06"},{"v":4064.7364176458477,"d":"₪ 4,064.74"},{"v":900.7410570026275,"d":"₪ 900.74"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":296991.3192159153,"d":"₪ 296,991.32"}]
[{"$nulls":8},55,{"v":296991.3192159153,"d":"₪ 296,991.32"},{"v":4076.897857048096,"d":"₪ 4,076.90"},{"v":888.5796176003795,"d":"₪ 888.58"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":292914.4213588672,"d":"₪ 292,914.42"}]
[{"$nulls":8},56,{"v":292914.4213588672,"d":"₪ 292,914.42"},{"v":4089.095682723189,"d":"₪ 4,089.10"},{"v":876.3817919252866,"d":"₪ 876.38"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":288825.325676144,"d":"₪ 288,825.33"}]
[{"$nulls":8},57,{"v":288825.325676144,"d":"₪ 288,825.33"},{"v":4101.330003536599,"d":"₪ 4,101.33"},{"v":864.1474711118759,"d":"₪ 864.15"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":284723.9956726074,"d":"₪ 284,724.00"}]
[{"$nulls":8},58,{"v":284723.9956726074,"d":"₪ 284,724.00"},{"v":4113.60092867952,"d":"₪ 4,113.60"},{"v":851.8765459689561,"d":"₪ 851.88"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":280610.39474392787,"d":"₪ 280,610.39"}]
[{"$nulls":8},59,{"v":280610.39474392787,"d":"₪ 280,610.39"},{"v":4125.908567669833,"d":"₪ 4,125.91"},{"v":839.5689069786421,"d":"₪ 839.57"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":276484.486176258,"d":"₪ 276,484.49"}]
[{"$nulls":8},60,{"v":276484.486176258,"d":"₪ 276,484.49"},{"v":4138.2530303530975,"d":"₪ 4,138.25"},{"v":827.224444295378,"d":"₪ 827.22"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":272346.2331459049,"d":"₪ 272,346.23"}]
[{"$nulls":8},61,{"v":272346.2331459049,"d":"₪ 272,346.23"},{"v":4150.634426903518,"d":"₪ 4,150.63"},{"v":814.8430477449575,"d":"₪ 814.84"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":268195.5987190014,"d":"₪ 268,195.60"}]
[{"$nulls":8},62,{"v":268195.5987190014,"d":"₪ 268,195.60"},{"v":4163.052867824936,"d":"₪ 4,163.05"},{"v":802.4246068235393,"d":"₪ 802.42"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":264032.5458511765,"d":"₪ 264,032.55"}]
[{"$nulls":8},63,{"v":264032.5458511765,"d":"₪ 264,032.55"},{"v":4175.508463951814,"d":"₪ 4,175.51"},{"v":789.9690106966617,"d":"₪ 789.97"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":259857.03738722467,"d":"₪ 259,857.04"}]
[{"$nulls":8},64,{"v":259857.03738722467,"d":"₪ 259,857.04"},{"v":4188.001326450222,"d":"₪ 4,188.00"},{"v":777.476148198253,"d":"₪ 777.48"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":255669.03606077444,"d":"₪ 255,669.04"}]
[{"$nulls":8},65,{"v":255669.03606077444,"d":"₪ 255,669.04"},{"v":4200.531566818836,"d":"₪ 4,200.53"},{"v":764.9459078296395,"d":"₪ 764.95"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":251468.5044939556,"d":"₪ 251,468.50"}]
[{"$nulls":8},66,{"v":251468.5044939556,"d":"₪ 251,468.50"},{"$f":"M81-L81","v":{"v":4213.0992968899245,"d":"₪ 4,213.10"}},{"$f":"$J$13*J81","v":{"v":752.3781777585507,"d":"₪ 752.38"}},{"$f":"$J$14","v":{"v":4965.477474648475,"d":"₪ 4,965.48"}},{"$f":"J81-K81","v":{"v":247255.40519706567,"d":"₪ 247,255.41"}}]
[{"$nulls":8},67,{"$f":"N81","v":{"v":247255.40519706567,"d":"₪ 247,255.41"}},{"v":4225.704628830355,"d":"₪ 4,225.70"},{"v":739.7728458181205,"d":"₪ 739.77"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":243029.7005682353,"d":"₪ 243,029.70"}]
[{"$nulls":8},68,{"v":243029.7005682353,"d":"₪ 243,029.70"},{"v":4238.347675142589,"d":"₪ 4,238.35"},{"v":727.1297995058866,"d":"₪ 727.13"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":238791.35289309273,"d":"₪ 238,791.35"}]
[{"$nulls":8},69,{"v":238791.35289309273,"d":"₪ 238,791.35"},{"v":4251.0285486656885,"d":"₪ 4,251.03"},{"v":714.4489259827866,"d":"₪ 714.45"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":234540.32434442703,"d":"₪ 234,540.32"}]
[{"$nulls":8},70,{"v":234540.32434442703,"d":"₪ 234,540.32"},{"v":4263.747362576325,"d":"₪ 4,263.75"},{"v":701.7301120721502,"d":"₪ 701.73"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":230276.5769818507,"d":"₪ 230,276.58"}]
[{"$nulls":8},71,{"v":230276.5769818507,"d":"₪ 230,276.58"},{"v":4276.504230389786,"d":"₪ 4,276.50"},{"v":688.9732442586895,"d":"₪ 688.97"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":226000.07275146092,"d":"₪ 226,000.07"}]
[{"$nulls":8},72,{"v":226000.07275146092,"d":"₪ 226,000.07"},{"v":4289.299265960989,"d":"₪ 4,289.30"},{"v":676.1782086874865,"d":"₪ 676.18"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":221710.77348549993,"d":"₪ 221,710.77"}]
[{"$nulls":8},73,{"v":221710.77348549993,"d":"₪ 221,710.77"},{"v":4302.1325834855,"d":"₪ 4,302.13"},{"v":663.3448911629756,"d":"₪ 663.34"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":217408.64090201442,"d":"₪ 217,408.64"}]
[{"$nulls":8},74,{"v":217408.64090201442,"d":"₪ 217,408.64"},{"v":4315.00429750055,"d":"₪ 4,315.00"},{"v":650.4731771479256,"d":"₪ 650.47"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":213093.63660451386,"d":"₪ 213,093.64"}]
[{"$nulls":8},75,{"v":213093.63660451386,"d":"₪ 213,093.64"},{"v":4327.914522886059,"d":"₪ 4,327.91"},{"v":637.5629517624169,"d":"₪ 637.56"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":208765.72208162778,"d":"₪ 208,765.72"}]
[{"$nulls":8},76,{"v":208765.72208162778,"d":"₪ 208,765.72"},{"v":4340.863374865659,"d":"₪ 4,340.86"},{"v":624.6140997828162,"d":"₪ 624.61"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":204424.8587067621,"d":"₪ 204,424.86"}]
[{"$nulls":8},77,{"v":204424.8587067621,"d":"₪ 204,424.86"},{"v":4353.850969007727,"d":"₪ 4,353.85"},{"v":611.6265056407483,"d":"₪ 611.63"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":200071.00773775438,"d":"₪ 200,071.01"}]
[{"$nulls":8},78,{"v":200071.00773775438,"d":"₪ 200,071.01"},{"v":4366.877421226411,"d":"₪ 4,366.88"},{"v":598.6000534220647,"d":"₪ 598.60"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":195704.13031652797,"d":"₪ 195,704.13"}]
[{"$nulls":8},79,{"v":195704.13031652797,"d":"₪ 195,704.13"},{"v":4379.942847782667,"d":"₪ 4,379.94"},{"v":585.5346268658087,"d":"₪ 585.53"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":191324.1874687453,"d":"₪ 191,324.19"}]
[{"$nulls":8},80,{"v":191324.1874687453,"d":"₪ 191,324.19"},{"v":4393.047365285297,"d":"₪ 4,393.05"},{"v":572.4301093631784,"d":"₪ 572.43"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":186931.14010346,"d":"₪ 186,931.14"}]
[{"$nulls":8},81,{"v":186931.14010346,"d":"₪ 186,931.14"},{"v":4406.19109069199,"d":"₪ 4,406.19"},{"v":559.2863839564852,"d":"₪ 559.29"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":182524.94901276802,"d":"₪ 182,524.95"}]
[{"$nulls":8},82,{"v":182524.94901276802,"d":"₪ 182,524.95"},{"v":4419.374141310365,"d":"₪ 4,419.37"},{"v":546.1033333381105,"d":"₪ 546.10"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":178105.57487145765,"d":"₪ 178,105.57"}]
[{"$nulls":8},83,{"v":178105.57487145765,"d":"₪ 178,105.57"},{"v":4432.596634799017,"d":"₪ 4,432.60"},{"v":532.8808398494587,"d":"₪ 532.88"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":173672.97823665864,"d":"₪ 173,672.98"}]
[{"$nulls":8},84,{"v":173672.97823665864,"d":"₪ 173,672.98"},{"v":4445.858689168569,"d":"₪ 4,445.86"},{"v":519.6187854799067,"d":"₪ 519.62"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":169227.1195474901,"d":"₪ 169,227.12"}]
[{"$nulls":8},85,{"v":169227.1195474901,"d":"₪ 169,227.12"},{"v":4459.160422782725,"d":"₪ 4,459.16"},{"v":506.3170518657512,"d":"₪ 506.32"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":164767.95912470735,"d":"₪ 164,767.96"}]
[{"$nulls":8},86,{"v":164767.95912470735,"d":"₪ 164,767.96"},{"v":4472.5019543593235,"d":"₪ 4,472.50"},{"v":492.97552028915186,"d":"₪ 492.98"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":160295.45717034803,"d":"₪ 160,295.46"}]
[{"$nulls":8},87,{"v":160295.45717034803,"d":"₪ 160,295.46"},{"v":4485.8834029714035,"d":"₪ 4,485.88"},{"v":479.59407167707207,"d":"₪ 479.59"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":155809.57376737663,"d":"₪ 155,809.57"}]
[{"$nulls":8},88,{"v":155809.57376737663,"d":"₪ 155,809.57"},{"v":4499.304888048259,"d":"₪ 4,499.30"},{"v":466.17258660021594,"d":"₪ 466.17"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":151310.26887932836,"d":"₪ 151,310.27"}]
[{"$nulls":8},89,{"v":151310.26887932836,"d":"₪ 151,310.27"},{"v":4512.766529376513,"d":"₪ 4,512.77"},{"v":452.7109452719626,"d":"₪ 452.71"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":146797.50234995186,"d":"₪ 146,797.50"}]
[{"$nulls":8},90,{"v":146797.50234995186,"d":"₪ 146,797.50"},{"v":4526.268447101178,"d":"₪ 4,526.27"},{"v":439.20902754729707,"d":"₪ 439.21"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":142271.23390285068,"d":"₪ 142,271.23"}]
[{"$nulls":8},91,{"v":142271.23390285068,"d":"₪ 142,271.23"},{"v":4539.810761726738,"d":"₪ 4,539.81"},{"v":425.6667129217378,"d":"₪ 425.67"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":137731.42314112396,"d":"₪ 137,731.42"}]
[{"$nulls":8},92,{"v":137731.42314112396,"d":"₪ 137,731.42"},{"v":4553.3935941182135,"d":"₪ 4,553.39"},{"v":412.08388053026147,"d":"₪ 412.08"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":133178.02954700575,"d":"₪ 133,178.03"}]
[{"$nulls":8},93,{"v":133178.02954700575,"d":"₪ 133,178.03"},{"v":4567.017065502251,"d":"₪ 4,567.02"},{"v":398.4604091462239,"d":"₪ 398.46"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":128611.0124815035,"d":"₪ 128,611.01"}]
[{"$nulls":8},94,{"v":128611.0124815035,"d":"₪ 128,611.01"},{"v":4580.681297468197,"d":"₪ 4,580.68"},{"v":384.79617718027856,"d":"₪ 384.80"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":124030.3311840353,"d":"₪ 124,030.33"}]
[{"$nulls":8},95,{"v":124030.3311840353,"d":"₪ 124,030.33"},{"v":4594.386411969184,"d":"₪ 4,594.39"},{"v":371.09106267929087,"d":"₪ 371.09"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":119435.94477206611,"d":"₪ 119,435.94"}]
[{"$nulls":8},96,{"v":119435.94477206611,"d":"₪ 119,435.94"},{"v":4608.1325313232255,"d":"₪ 4,608.13"},{"v":357.34494332525026,"d":"₪ 357.34"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":114827.81224074289,"d":"₪ 114,827.81"}]
[{"$nulls":8},97,{"v":114827.81224074289,"d":"₪ 114,827.81"},{"v":4621.919778214297,"d":"₪ 4,621.92"},{"v":343.55769643417807,"d":"₪ 343.56"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":110205.89246252859,"d":"₪ 110,205.89"}]
[{"$nulls":8},98,{"v":110205.89246252859,"d":"₪ 110,205.89"},{"v":4635.748275693442,"d":"₪ 4,635.75"},{"v":329.7291989550328,"d":"₪ 329.73"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":105570.14418683514,"d":"₪ 105,570.14"}]
[{"$nulls":8},99,{"v":105570.14418683514,"d":"₪ 105,570.14"},{"v":4649.618147179864,"d":"₪ 4,649.62"},{"v":315.8593274686121,"d":"₪ 315.86"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":100920.52603965528,"d":"₪ 100,920.53"}]
[{"$nulls":8},100,{"v":100920.52603965528,"d":"₪ 100,920.53"},{"v":4663.529516462025,"d":"₪ 4,663.53"},{"v":301.9479581864507,"d":"₪ 301.95"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":96256.99652319326,"d":"₪ 96,257.00"}]
[{"$nulls":8},101,{"v":96256.99652319326,"d":"₪ 96,257.00"},{"v":4677.482507698759,"d":"₪ 4,677.48"},{"v":287.9949669497162,"d":"₪ 287.99"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":91579.5140154945,"d":"₪ 91,579.51"}]
[{"$nulls":8},102,{"v":91579.5140154945,"d":"₪ 91,579.51"},{"v":4691.477245420375,"d":"₪ 4,691.48"},{"v":274.0002292281003,"d":"₪ 274.00"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":86888.03677007412,"d":"₪ 86,888.04"}]
[{"$nulls":8},103,{"v":86888.03677007412,"d":"₪ 86,888.04"},{"v":4705.513854529768,"d":"₪ 4,705.51"},{"v":259.9636201187081,"d":"₪ 259.96"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":82182.52291554435,"d":"₪ 82,182.52"}]
[{"$nulls":8},104,{"v":82182.52291554435,"d":"₪ 82,182.52"},{"v":4719.592460303533,"d":"₪ 4,719.59"},{"v":245.88501434494282,"d":"₪ 245.89"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":77462.93045524081,"d":"₪ 77,462.93"}]
[{"$nulls":8},105,{"v":77462.93045524081,"d":"₪ 77,462.93"},{"v":4733.713188393088,"d":"₪ 4,733.71"},{"v":231.7642862553879,"d":"₪ 231.76"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":72729.21726684773,"d":"₪ 72,729.22"}]
[{"$nulls":8},106,{"v":72729.21726684773,"d":"₪ 72,729.22"},{"v":4747.87616482579,"d":"₪ 4,747.88"},{"v":217.6013098226855,"d":"₪ 217.60"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":67981.34110202194,"d":"₪ 67,981.34"}]
[{"$nulls":8},107,{"v":67981.34110202194,"d":"₪ 67,981.34"},{"v":4762.081516006064,"d":"₪ 4,762.08"},{"v":203.39595864241176,"d":"₪ 203.40"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":63219.25958601587,"d":"₪ 63,219.26"}]
[{"$nulls":8},108,{"v":63219.25958601587,"d":"₪ 63,219.26"},{"v":4776.329368716527,"d":"₪ 4,776.33"},{"v":189.1481059319486,"d":"₪ 189.15"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":58442.93021729934,"d":"₪ 58,442.93"}]
[{"$nulls":8},109,{"v":58442.93021729934,"d":"₪ 58,442.93"},{"v":4790.619850119123,"d":"₪ 4,790.62"},{"v":174.85762452935225,"d":"₪ 174.86"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":53652.31036718022,"d":"₪ 53,652.31"}]
[{"$nulls":8},110,{"v":53652.31036718022,"d":"₪ 53,652.31"},{"v":4804.953087756257,"d":"₪ 4,804.95"},{"v":160.52438689221825,"d":"₪ 160.52"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":48847.35727942396,"d":"₪ 48,847.36"}]
[{"$nulls":8},111,{"v":48847.35727942396,"d":"₪ 48,847.36"},{"v":4819.329209551932,"d":"₪ 4,819.33"},{"v":146.14826509654316,"d":"₪ 146.15"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":44028.02806987203,"d":"₪ 44,028.03"}]
[{"$nulls":8},112,{"v":44028.02806987203,"d":"₪ 44,028.03"},{"v":4833.748343812893,"d":"₪ 4,833.75"},{"v":131.72913083558288,"d":"₪ 131.73"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":39194.27972605914,"d":"₪ 39,194.28"}]
[{"$nulls":8},113,{"v":39194.27972605914,"d":"₪ 39,194.28"},{"v":4848.210619229768,"d":"₪ 4,848.21"},{"v":117.26685541870748,"d":"₪ 117.27"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":34346.069106829375,"d":"₪ 34,346.07"}]
[{"$nulls":8},114,{"v":34346.069106829375,"d":"₪ 34,346.07"},{"v":4862.716164878223,"d":"₪ 4,862.72"},{"v":102.76130977025262,"d":"₪ 102.76"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":29483.35294195115,"d":"₪ 29,483.35"}]
[{"$nulls":8},115,{"v":29483.35294195115,"d":"₪ 29,483.35"},{"v":4877.265110220108,"d":"₪ 4,877.27"},{"v":88.21236442836762,"d":"₪ 88.21"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":24606.08783173104,"d":"₪ 24,606.09"}]
[{"$nulls":8},116,{"v":24606.08783173104,"d":"₪ 24,606.09"},{"v":4891.857585104615,"d":"₪ 4,891.86"},{"v":73.6198895438599,"d":"₪ 73.62"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":19714.230246626426,"d":"₪ 19,714.23"}]
[{"$nulls":8},117,{"v":19714.230246626426,"d":"₪ 19,714.23"},{"v":4906.493719769439,"d":"₪ 4,906.49"},{"v":58.98375487903621,"d":"₪ 58.98"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":14807.736526856988,"d":"₪ 14,807.74"}]
[{"$nulls":8},118,{"v":14807.736526856988,"d":"₪ 14,807.74"},{"v":4921.173644841935,"d":"₪ 4,921.17"},{"v":44.30382980654017,"d":"₪ 44.30"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":9886.562882015052,"d":"₪ 9,886.56"}]
[{"$nulls":8},119,{"v":9886.562882015052,"d":"₪ 9,886.56"},{"v":4935.897491340289,"d":"₪ 4,935.90"},{"v":29.579983308186428,"d":"₪ 29.58"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":4950.665390674763,"d":"₪ 4,950.67"}]
[{"$nulls":8},120,{"v":4950.665390674763,"d":"₪ 4,950.67"},{"v":4950.665390674684,"d":"₪ 4,950.67"},{"v":14.812083973791365,"d":"₪ 14.81"},{"v":4965.477474648475,"d":"₪ 4,965.48"},{"v":7.912603905424476e-11,"d":"₪ 0.00"}]
[]
[{"$nulls":9},"סעיף ב",{"$f":"L126","v":{"v":146.14826509654316,"d":"146.15"}}]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"שאלה 17",null,null,"שושי לוותה סכום של 40,000 ש\"ח לתקופה של שנה בריבית שנתית בשיעור של 12% מחושבת חודשית.                                                                                                               ההלוואה תוחזר בתשלומים סוף חודשיים שווים. \nבעקבות בקשתה של שושי הסכים מנהל הבנק לאפשר לה לשלם רק החל מסוף החודש החמישי                                                                                                                      (במקום מסוף החודש הראשון) מועד תום ההלוואה נותר כשהיה. \n\nחשב מה גובה התשלום החודשי של שושי?\n"]
[]
[]
[]
[]
[]
[{"$nulls":9},40000,"PV0",null,{"v":0.12,"d":"12.00%"}]
[{"$nulls":9},{"$f":"M150/M151","v":{"v":0.01,"d":"1.00%"}},"R",null,12]
[{"$nulls":6},{"$f":"J152*8","v":{"v":-43518.98942987042,"d":"₪ -43,518.99"}},null,null,{"$f":"PMT(J151,J154,J155,,)","v":{"v":-5439.873678733802,"d":"₪ -5,439.87"}},"PMT"]
[{"$nulls":9},0,"FV"]
[{"$nulls":9},8,"N",4]
[{"$nulls":9},{"$f":"FV(J151,L154,,-J150)","v":{"v":41624.1604,"d":"₪ 41,624.16"}},"FV4"]
{"$rows_empty":9}
[{"$nulls":5},"שאלה 18",null,null,"נלקחה הלוואה בגובה 80,000 ש\"ח אשר תוחזר על פי לוח סילוקין רגיל (תשלומי קרן שווים).\nהריבית האפקטיבית השנתית הינה 6.16%.\nההלוואה תוחזר בהחזרים חודשיים שווים וזאת למשך 10  שנים.\n\nמצא, מהו התשלום על חשבון הקרן בתשלום ה-44\n"]
[]
[]
[]
[]
[]
[{"$nulls":8},"נתונים:"]
[{"$nulls":8},"הלוואה",{"v":80000,"d":"80,000"},"PV",null,{"v":0.0616,"d":"6.16%"}]
[{"$nulls":8},"חודשים",{"$f":"10*12","v":120},"n",null,12]
[{"$nulls":8},"ריבית",{"$f":"(1+M172)^(1/12)-1","v":{"v":0.004993861638155073,"d":"0.50%"}},"r"]
[{"$nulls":9},{"$f":"J172/J173","v":{"v":666.6666666666666,"d":"₪ 666.67"}},"החזר קרן קבוע"]
[{"$nulls":8},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":8},1,{"$f":"J172","v":{"v":80000,"d":"₪ 80,000.00"}},{"$f":"$J$175","v":{"v":666.6666666666666,"d":"₪ 666.67"}},{"$f":"$J$174*J177","v":{"v":399.50893105240584,"d":"₪ 399.51"}},{"$f":"K177+L177","v":{"v":1066.1755977190724,"d":"₪ 1,066.18"}},{"$f":"J177-K177","v":{"v":79333.33333333333,"d":"₪ 79,333.33"}}]
[{"$nulls":8},2,{"$f":"N177","v":{"v":79333.33333333333,"d":"₪ 79,333.33"}},{"$f":"$J$175","v":{"v":666.6666666666666,"d":"₪ 666.67"}},{"$f":"$J$174*J178","v":{"v":396.1796899603024,"d":"₪ 396.18"}},{"$f":"K178+L178","v":{"v":1062.846356626969,"d":"₪ 1,062.85"}},{"$f":"J178-K178","v":{"v":78666.66666666666,"d":"₪ 78,666.67"}}]
[{"$nulls":8},3,{"$f":"N178","v":{"v":78666.66666666666,"d":"₪ 78,666.67"}},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":392.850448868199,"d":"₪ 392.85"},{"v":1059.5171155348658,"d":"₪ 1,059.52"},{"v":77999.99999999999,"d":"₪ 78,000.00"}]
[{"$nulls":8},4,{"v":77999.99999999999,"d":"₪ 78,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":389.5212077760956,"d":"₪ 389.52"},{"v":1056.1878744427622,"d":"₪ 1,056.19"},{"v":77333.33333333331,"d":"₪ 77,333.33"}]
[{"$nulls":8},5,{"v":77333.33333333331,"d":"₪ 77,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":386.1919666839922,"d":"₪ 386.19"},{"v":1052.8586333506587,"d":"₪ 1,052.86"},{"v":76666.66666666664,"d":"₪ 76,666.67"}]
[{"$nulls":8},6,{"v":76666.66666666664,"d":"₪ 76,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":382.86272559188876,"d":"₪ 382.86"},{"v":1049.5293922585554,"d":"₪ 1,049.53"},{"v":75999.99999999997,"d":"₪ 76,000.00"}]
[{"$nulls":8},7,{"v":75999.99999999997,"d":"₪ 76,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":379.5334844997854,"d":"₪ 379.53"},{"v":1046.200151166452,"d":"₪ 1,046.20"},{"v":75333.3333333333,"d":"₪ 75,333.33"}]
[{"$nulls":8},8,{"v":75333.3333333333,"d":"₪ 75,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":376.204243407682,"d":"₪ 376.20"},{"v":1042.8709100743486,"d":"₪ 1,042.87"},{"v":74666.66666666663,"d":"₪ 74,666.67"}]
[{"$nulls":8},9,{"v":74666.66666666663,"d":"₪ 74,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":372.87500231557857,"d":"₪ 372.88"},{"v":1039.5416689822453,"d":"₪ 1,039.54"},{"v":73999.99999999996,"d":"₪ 74,000.00"}]
[{"$nulls":8},10,{"v":73999.99999999996,"d":"₪ 74,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":369.54576122347515,"d":"₪ 369.55"},{"v":1036.2124278901417,"d":"₪ 1,036.21"},{"v":73333.33333333328,"d":"₪ 73,333.33"}]
[{"$nulls":8},11,{"v":73333.33333333328,"d":"₪ 73,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":366.21652013137174,"d":"₪ 366.22"},{"v":1032.8831867980384,"d":"₪ 1,032.88"},{"v":72666.66666666661,"d":"₪ 72,666.67"}]
[{"$nulls":8},12,{"v":72666.66666666661,"d":"₪ 72,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":362.8872790392683,"d":"₪ 362.89"},{"v":1029.553945705935,"d":"₪ 1,029.55"},{"v":71999.99999999994,"d":"₪ 72,000.00"}]
[{"$nulls":8},13,{"v":71999.99999999994,"d":"₪ 72,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":359.55803794716496,"d":"₪ 359.56"},{"v":1026.2247046138316,"d":"₪ 1,026.22"},{"v":71333.33333333327,"d":"₪ 71,333.33"}]
[{"$nulls":8},14,{"v":71333.33333333327,"d":"₪ 71,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":356.22879685506155,"d":"₪ 356.23"},{"v":1022.8954635217282,"d":"₪ 1,022.90"},{"v":70666.6666666666,"d":"₪ 70,666.67"}]
[{"$nulls":8},15,{"v":70666.6666666666,"d":"₪ 70,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":352.89955576295813,"d":"₪ 352.90"},{"v":1019.5662224296248,"d":"₪ 1,019.57"},{"v":69999.99999999993,"d":"₪ 70,000.00"}]
[{"$nulls":8},16,{"v":69999.99999999993,"d":"₪ 70,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":349.5703146708547,"d":"₪ 349.57"},{"v":1016.2369813375213,"d":"₪ 1,016.24"},{"v":69333.33333333326,"d":"₪ 69,333.33"}]
[{"$nulls":8},17,{"v":69333.33333333326,"d":"₪ 69,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":346.2410735787513,"d":"₪ 346.24"},{"v":1012.9077402454179,"d":"₪ 1,012.91"},{"v":68666.66666666658,"d":"₪ 68,666.67"}]
[{"$nulls":8},18,{"v":68666.66666666658,"d":"₪ 68,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":342.91183248664794,"d":"₪ 342.91"},{"v":1009.5784991533146,"d":"₪ 1,009.58"},{"v":67999.99999999991,"d":"₪ 68,000.00"}]
[{"$nulls":8},19,{"v":67999.99999999991,"d":"₪ 68,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":339.5825913945445,"d":"₪ 339.58"},{"v":1006.2492580612111,"d":"₪ 1,006.25"},{"v":67333.33333333324,"d":"₪ 67,333.33"}]
[{"$nulls":8},20,{"v":67333.33333333324,"d":"₪ 67,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":336.2533503024411,"d":"₪ 336.25"},{"v":1002.9200169691078,"d":"₪ 1,002.92"},{"v":66666.66666666657,"d":"₪ 66,666.67"}]
[{"$nulls":8},21,{"v":66666.66666666657,"d":"₪ 66,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":332.9241092103377,"d":"₪ 332.92"},{"v":999.5907758770043,"d":"₪ 999.59"},{"v":65999.9999999999,"d":"₪ 66,000.00"}]
[{"$nulls":8},22,{"v":65999.9999999999,"d":"₪ 66,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":329.5948681182343,"d":"₪ 329.59"},{"v":996.261534784901,"d":"₪ 996.26"},{"v":65333.333333333234,"d":"₪ 65,333.33"}]
[{"$nulls":8},23,{"v":65333.333333333234,"d":"₪ 65,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":326.2656270261309,"d":"₪ 326.27"},{"v":992.9322936927975,"d":"₪ 992.93"},{"v":64666.66666666657,"d":"₪ 64,666.67"}]
[{"$nulls":8},24,{"v":64666.66666666657,"d":"₪ 64,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":322.93638593402756,"d":"₪ 322.94"},{"v":989.6030526006941,"d":"₪ 989.60"},{"v":63999.999999999905,"d":"₪ 64,000.00"}]
[{"$nulls":8},25,{"v":63999.999999999905,"d":"₪ 64,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":319.6071448419242,"d":"₪ 319.61"},{"v":986.2738115085908,"d":"₪ 986.27"},{"v":63333.33333333324,"d":"₪ 63,333.33"}]
[{"$nulls":8},26,{"v":63333.33333333324,"d":"₪ 63,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":316.27790374982084,"d":"₪ 316.28"},{"v":982.9445704164875,"d":"₪ 982.94"},{"v":62666.66666666658,"d":"₪ 62,666.67"}]
[{"$nulls":8},27,{"v":62666.66666666658,"d":"₪ 62,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":312.9486626577174,"d":"₪ 312.95"},{"v":979.615329324384,"d":"₪ 979.62"},{"v":61999.99999999991,"d":"₪ 62,000.00"}]
[{"$nulls":8},28,{"v":61999.99999999991,"d":"₪ 62,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":309.61942156561406,"d":"₪ 309.62"},{"v":976.2860882322807,"d":"₪ 976.29"},{"v":61333.33333333325,"d":"₪ 61,333.33"}]
[{"$nulls":8},29,{"v":61333.33333333325,"d":"₪ 61,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":306.2901804735107,"d":"₪ 306.29"},{"v":972.9568471401774,"d":"₪ 972.96"},{"v":60666.666666666584,"d":"₪ 60,666.67"}]
[{"$nulls":8},30,{"v":60666.666666666584,"d":"₪ 60,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":302.96093938140734,"d":"₪ 302.96"},{"v":969.627606048074,"d":"₪ 969.63"},{"v":59999.99999999992,"d":"₪ 60,000.00"}]
[{"$nulls":8},31,{"v":59999.99999999992,"d":"₪ 60,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":299.631698289304,"d":"₪ 299.63"},{"v":966.2983649559706,"d":"₪ 966.30"},{"v":59333.333333333256,"d":"₪ 59,333.33"}]
[{"$nulls":8},32,{"v":59333.333333333256,"d":"₪ 59,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":296.30245719720057,"d":"₪ 296.30"},{"v":962.9691238638673,"d":"₪ 962.97"},{"v":58666.66666666659,"d":"₪ 58,666.67"}]
[{"$nulls":8},33,{"v":58666.66666666659,"d":"₪ 58,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":292.9732161050972,"d":"₪ 292.97"},{"v":959.6398827717638,"d":"₪ 959.64"},{"v":57999.99999999993,"d":"₪ 58,000.00"}]
[{"$nulls":8},34,{"v":57999.99999999993,"d":"₪ 58,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":289.64397501299385,"d":"₪ 289.64"},{"v":956.3106416796604,"d":"₪ 956.31"},{"v":57333.33333333326,"d":"₪ 57,333.33"}]
[{"$nulls":8},35,{"v":57333.33333333326,"d":"₪ 57,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":286.3147339208905,"d":"₪ 286.31"},{"v":952.9814005875571,"d":"₪ 952.98"},{"v":56666.6666666666,"d":"₪ 56,666.67"}]
[{"$nulls":8},36,{"v":56666.6666666666,"d":"₪ 56,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":282.98549282878713,"d":"₪ 282.99"},{"v":949.6521594954538,"d":"₪ 949.65"},{"v":55999.999999999935,"d":"₪ 56,000.00"}]
[{"$nulls":8},37,{"v":55999.999999999935,"d":"₪ 56,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":279.6562517366837,"d":"₪ 279.66"},{"v":946.3229184033503,"d":"₪ 946.32"},{"v":55333.33333333327,"d":"₪ 55,333.33"}]
[{"$nulls":8},38,{"v":55333.33333333327,"d":"₪ 55,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":276.32701064458035,"d":"₪ 276.33"},{"v":942.993677311247,"d":"₪ 942.99"},{"v":54666.666666666606,"d":"₪ 54,666.67"}]
[{"$nulls":8},39,{"v":54666.666666666606,"d":"₪ 54,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":272.997769552477,"d":"₪ 273.00"},{"v":939.6644362191437,"d":"₪ 939.66"},{"v":53999.99999999994,"d":"₪ 54,000.00"}]
[{"$nulls":8},40,{"v":53999.99999999994,"d":"₪ 54,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":269.66852846037364,"d":"₪ 269.67"},{"v":936.3351951270403,"d":"₪ 936.34"},{"v":53333.33333333328,"d":"₪ 53,333.33"}]
[{"$nulls":8},41,{"v":53333.33333333328,"d":"₪ 53,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":266.3392873682703,"d":"₪ 266.34"},{"v":933.0059540349368,"d":"₪ 933.01"},{"v":52666.66666666661,"d":"₪ 52,666.67"}]
[{"$nulls":8},42,{"v":52666.66666666661,"d":"₪ 52,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":263.0100462761669,"d":"₪ 263.01"},{"v":929.6767129428335,"d":"₪ 929.68"},{"v":51999.99999999995,"d":"₪ 52,000.00"}]
[{"$nulls":8},43,{"v":51999.99999999995,"d":"₪ 52,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":259.6808051840635,"d":"₪ 259.68"},{"v":926.3474718507301,"d":"₪ 926.35"},{"v":51333.333333333285,"d":"₪ 51,333.33"}]
[{"$nulls":8},44,{"v":51333.333333333285,"d":"₪ 51,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":256.35156409196014,"d":"₪ 256.35"},{"v":923.0182307586267,"d":"₪ 923.02"},{"v":50666.66666666662,"d":"₪ 50,666.67"}]
[{"$nulls":8},45,{"v":50666.66666666662,"d":"₪ 50,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":253.02232299985678,"d":"₪ 253.02"},{"v":919.6889896665234,"d":"₪ 919.69"},{"v":49999.999999999956,"d":"₪ 50,000.00"}]
[{"$nulls":8},46,{"v":49999.999999999956,"d":"₪ 50,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":249.69308190775342,"d":"₪ 249.69"},{"v":916.3597485744201,"d":"₪ 916.36"},{"v":49333.33333333329,"d":"₪ 49,333.33"}]
[{"$nulls":8},47,{"v":49333.33333333329,"d":"₪ 49,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":246.36384081565004,"d":"₪ 246.36"},{"v":913.0305074823167,"d":"₪ 913.03"},{"v":48666.66666666663,"d":"₪ 48,666.67"}]
[{"$nulls":8},48,{"v":48666.66666666663,"d":"₪ 48,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":243.03459972354668,"d":"₪ 243.03"},{"v":909.7012663902133,"d":"₪ 909.70"},{"v":47999.99999999996,"d":"₪ 48,000.00"}]
[{"$nulls":8},49,{"v":47999.99999999996,"d":"₪ 48,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":239.70535863144332,"d":"₪ 239.71"},{"v":906.37202529811,"d":"₪ 906.37"},{"v":47333.3333333333,"d":"₪ 47,333.33"}]
[{"$nulls":8},50,{"v":47333.3333333333,"d":"₪ 47,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":236.37611753933993,"d":"₪ 236.38"},{"v":903.0427842060066,"d":"₪ 903.04"},{"v":46666.666666666635,"d":"₪ 46,666.67"}]
[{"$nulls":8},51,{"v":46666.666666666635,"d":"₪ 46,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":233.04687644723657,"d":"₪ 233.05"},{"v":899.7135431139031,"d":"₪ 899.71"},{"v":45999.99999999997,"d":"₪ 46,000.00"}]
[{"$nulls":8},52,{"v":45999.99999999997,"d":"₪ 46,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":229.7176353551332,"d":"₪ 229.72"},{"v":896.3843020217998,"d":"₪ 896.38"},{"v":45333.33333333331,"d":"₪ 45,333.33"}]
[{"$nulls":8},53,{"v":45333.33333333331,"d":"₪ 45,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":226.38839426302982,"d":"₪ 226.39"},{"v":893.0550609296964,"d":"₪ 893.06"},{"v":44666.66666666664,"d":"₪ 44,666.67"}]
[{"$nulls":8},54,{"v":44666.66666666664,"d":"₪ 44,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":223.05915317092646,"d":"₪ 223.06"},{"v":889.7258198375931,"d":"₪ 889.73"},{"v":43999.99999999998,"d":"₪ 44,000.00"}]
[{"$nulls":8},55,{"v":43999.99999999998,"d":"₪ 44,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":219.72991207882308,"d":"₪ 219.73"},{"v":886.3965787454897,"d":"₪ 886.40"},{"v":43333.333333333314,"d":"₪ 43,333.33"}]
[{"$nulls":8},56,{"v":43333.333333333314,"d":"₪ 43,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":216.40067098671972,"d":"₪ 216.40"},{"v":883.0673376533864,"d":"₪ 883.07"},{"v":42666.66666666665,"d":"₪ 42,666.67"}]
[{"$nulls":8},57,{"v":42666.66666666665,"d":"₪ 42,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":213.07142989461636,"d":"₪ 213.07"},{"v":879.738096561283,"d":"₪ 879.74"},{"v":41999.999999999985,"d":"₪ 42,000.00"}]
[{"$nulls":8},58,{"v":41999.999999999985,"d":"₪ 42,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":209.74218880251297,"d":"₪ 209.74"},{"v":876.4088554691796,"d":"₪ 876.41"},{"v":41333.33333333332,"d":"₪ 41,333.33"}]
[{"$nulls":8},59,{"v":41333.33333333332,"d":"₪ 41,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":206.4129477104096,"d":"₪ 206.41"},{"v":873.0796143770763,"d":"₪ 873.08"},{"v":40666.66666666666,"d":"₪ 40,666.67"}]
[{"$nulls":8},60,{"v":40666.66666666666,"d":"₪ 40,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":203.08370661830625,"d":"₪ 203.08"},{"v":869.7503732849729,"d":"₪ 869.75"},{"v":39999.99999999999,"d":"₪ 40,000.00"}]
[{"$nulls":8},61,{"v":39999.99999999999,"d":"₪ 40,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":199.75446552620286,"d":"₪ 199.75"},{"v":866.4211321928694,"d":"₪ 866.42"},{"v":39333.33333333333,"d":"₪ 39,333.33"}]
[{"$nulls":8},62,{"v":39333.33333333333,"d":"₪ 39,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":196.4252244340995,"d":"₪ 196.43"},{"v":863.0918911007661,"d":"₪ 863.09"},{"v":38666.666666666664,"d":"₪ 38,666.67"}]
[{"$nulls":8},63,{"v":38666.666666666664,"d":"₪ 38,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":193.09598334199612,"d":"₪ 193.10"},{"v":859.7626500086627,"d":"₪ 859.76"},{"v":38000,"d":"₪ 38,000.00"}]
[{"$nulls":8},64,{"v":38000,"d":"₪ 38,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":189.76674224989276,"d":"₪ 189.77"},{"v":856.4334089165594,"d":"₪ 856.43"},{"v":37333.333333333336,"d":"₪ 37,333.33"}]
[{"$nulls":8},65,{"v":37333.333333333336,"d":"₪ 37,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":186.4375011577894,"d":"₪ 186.44"},{"v":853.104167824456,"d":"₪ 853.10"},{"v":36666.66666666667,"d":"₪ 36,666.67"}]
[{"$nulls":8},66,{"v":36666.66666666667,"d":"₪ 36,666.67"},{"$f":"$J$175","v":{"v":666.6666666666666,"d":"₪ 666.67"}},{"$f":"$J$174*J242","v":{"v":183.108260065686,"d":"₪ 183.11"}},{"$f":"K242+L242","v":{"v":849.7749267323527,"d":"₪ 849.77"}},{"$f":"J242-K242","v":{"v":36000.00000000001,"d":"₪ 36,000.00"}}]
[{"$nulls":8},67,{"$f":"N242","v":{"v":36000.00000000001,"d":"₪ 36,000.00"}},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":179.77901897358265,"d":"₪ 179.78"},{"v":846.4456856402493,"d":"₪ 846.45"},{"v":35333.33333333334,"d":"₪ 35,333.33"}]
[{"$nulls":8},68,{"v":35333.33333333334,"d":"₪ 35,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":176.4497778814793,"d":"₪ 176.45"},{"v":843.1164445481459,"d":"₪ 843.12"},{"v":34666.66666666668,"d":"₪ 34,666.67"}]
[{"$nulls":8},69,{"v":34666.66666666668,"d":"₪ 34,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":173.1205367893759,"d":"₪ 173.12"},{"v":839.7872034560426,"d":"₪ 839.79"},{"v":34000.000000000015,"d":"₪ 34,000.00"}]
[{"$nulls":8},70,{"v":34000.000000000015,"d":"₪ 34,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":169.79129569727255,"d":"₪ 169.79"},{"v":836.4579623639391,"d":"₪ 836.46"},{"v":33333.33333333335,"d":"₪ 33,333.33"}]
[{"$nulls":8},71,{"v":33333.33333333335,"d":"₪ 33,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":166.4620546051692,"d":"₪ 166.46"},{"v":833.1287212718358,"d":"₪ 833.13"},{"v":32666.666666666682,"d":"₪ 32,666.67"}]
[{"$nulls":8},72,{"v":32666.666666666682,"d":"₪ 32,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":163.1328135130658,"d":"₪ 163.13"},{"v":829.7994801797324,"d":"₪ 829.80"},{"v":32000.000000000015,"d":"₪ 32,000.00"}]
[{"$nulls":8},73,{"v":32000.000000000015,"d":"₪ 32,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":159.8035724209624,"d":"₪ 159.80"},{"v":826.470239087629,"d":"₪ 826.47"},{"v":31333.333333333347,"d":"₪ 31,333.33"}]
[{"$nulls":8},74,{"v":31333.333333333347,"d":"₪ 31,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":156.47433132885902,"d":"₪ 156.47"},{"v":823.1409979955256,"d":"₪ 823.14"},{"v":30666.66666666668,"d":"₪ 30,666.67"}]
[{"$nulls":8},75,{"v":30666.66666666668,"d":"₪ 30,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":153.14509023675564,"d":"₪ 153.15"},{"v":819.8117569034223,"d":"₪ 819.81"},{"v":30000.00000000001,"d":"₪ 30,000.00"}]
[{"$nulls":8},76,{"v":30000.00000000001,"d":"₪ 30,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":149.81584914465225,"d":"₪ 149.82"},{"v":816.4825158113189,"d":"₪ 816.48"},{"v":29333.333333333343,"d":"₪ 29,333.33"}]
[{"$nulls":8},77,{"v":29333.333333333343,"d":"₪ 29,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":146.48660805254886,"d":"₪ 146.49"},{"v":813.1532747192155,"d":"₪ 813.15"},{"v":28666.666666666675,"d":"₪ 28,666.67"}]
[{"$nulls":8},78,{"v":28666.666666666675,"d":"₪ 28,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":143.15736696044547,"d":"₪ 143.16"},{"v":809.8240336271122,"d":"₪ 809.82"},{"v":28000.000000000007,"d":"₪ 28,000.00"}]
[{"$nulls":8},79,{"v":28000.000000000007,"d":"₪ 28,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":139.82812586834208,"d":"₪ 139.83"},{"v":806.4947925350087,"d":"₪ 806.49"},{"v":27333.33333333334,"d":"₪ 27,333.33"}]
[{"$nulls":8},80,{"v":27333.33333333334,"d":"₪ 27,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":136.4988847762387,"d":"₪ 136.50"},{"v":803.1655514429053,"d":"₪ 803.17"},{"v":26666.66666666667,"d":"₪ 26,666.67"}]
[{"$nulls":8},81,{"v":26666.66666666667,"d":"₪ 26,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":133.1696436841353,"d":"₪ 133.17"},{"v":799.8363103508019,"d":"₪ 799.84"},{"v":26000.000000000004,"d":"₪ 26,000.00"}]
[{"$nulls":8},82,{"v":26000.000000000004,"d":"₪ 26,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":129.84040259203192,"d":"₪ 129.84"},{"v":796.5070692586985,"d":"₪ 796.51"},{"v":25333.333333333336,"d":"₪ 25,333.33"}]
[{"$nulls":8},83,{"v":25333.333333333336,"d":"₪ 25,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":126.51116149992852,"d":"₪ 126.51"},{"v":793.1778281665952,"d":"₪ 793.18"},{"v":24666.666666666668,"d":"₪ 24,666.67"}]
[{"$nulls":8},84,{"v":24666.666666666668,"d":"₪ 24,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":123.18192040782513,"d":"₪ 123.18"},{"v":789.8485870744918,"d":"₪ 789.85"},{"v":24000,"d":"₪ 24,000.00"}]
[{"$nulls":8},85,{"v":24000,"d":"₪ 24,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":119.85267931572174,"d":"₪ 119.85"},{"v":786.5193459823884,"d":"₪ 786.52"},{"v":23333.333333333332,"d":"₪ 23,333.33"}]
[{"$nulls":8},86,{"v":23333.333333333332,"d":"₪ 23,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":116.52343822361836,"d":"₪ 116.52"},{"v":783.1901048902849,"d":"₪ 783.19"},{"v":22666.666666666664,"d":"₪ 22,666.67"}]
[{"$nulls":8},87,{"v":22666.666666666664,"d":"₪ 22,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":113.19419713151497,"d":"₪ 113.19"},{"v":779.8608637981816,"d":"₪ 779.86"},{"v":21999.999999999996,"d":"₪ 22,000.00"}]
[{"$nulls":8},88,{"v":21999.999999999996,"d":"₪ 22,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":109.86495603941158,"d":"₪ 109.86"},{"v":776.5316227060782,"d":"₪ 776.53"},{"v":21333.33333333333,"d":"₪ 21,333.33"}]
[{"$nulls":8},89,{"v":21333.33333333333,"d":"₪ 21,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":106.5357149473082,"d":"₪ 106.54"},{"v":773.2023816139748,"d":"₪ 773.20"},{"v":20666.66666666666,"d":"₪ 20,666.67"}]
[{"$nulls":8},90,{"v":20666.66666666666,"d":"₪ 20,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":103.2064738552048,"d":"₪ 103.21"},{"v":769.8731405218714,"d":"₪ 769.87"},{"v":19999.999999999993,"d":"₪ 20,000.00"}]
[{"$nulls":8},91,{"v":19999.999999999993,"d":"₪ 20,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":99.87723276310142,"d":"₪ 99.88"},{"v":766.5438994297681,"d":"₪ 766.54"},{"v":19333.333333333325,"d":"₪ 19,333.33"}]
[{"$nulls":8},92,{"v":19333.333333333325,"d":"₪ 19,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":96.54799167099803,"d":"₪ 96.55"},{"v":763.2146583376647,"d":"₪ 763.21"},{"v":18666.666666666657,"d":"₪ 18,666.67"}]
[{"$nulls":8},93,{"v":18666.666666666657,"d":"₪ 18,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":93.21875057889464,"d":"₪ 93.22"},{"v":759.8854172455613,"d":"₪ 759.89"},{"v":17999.99999999999,"d":"₪ 18,000.00"}]
[{"$nulls":8},94,{"v":17999.99999999999,"d":"₪ 18,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":89.88950948679125,"d":"₪ 89.89"},{"v":756.5561761534578,"d":"₪ 756.56"},{"v":17333.33333333332,"d":"₪ 17,333.33"}]
[{"$nulls":8},95,{"v":17333.33333333332,"d":"₪ 17,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":86.56026839468787,"d":"₪ 86.56"},{"v":753.2269350613545,"d":"₪ 753.23"},{"v":16666.666666666653,"d":"₪ 16,666.67"}]
[{"$nulls":8},96,{"v":16666.666666666653,"d":"₪ 16,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":83.23102730258448,"d":"₪ 83.23"},{"v":749.8976939692511,"d":"₪ 749.90"},{"v":15999.999999999987,"d":"₪ 16,000.00"}]
[{"$nulls":8},97,{"v":15999.999999999987,"d":"₪ 16,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":79.9017862104811,"d":"₪ 79.90"},{"v":746.5684528771477,"d":"₪ 746.57"},{"v":15333.333333333321,"d":"₪ 15,333.33"}]
[{"$nulls":8},98,{"v":15333.333333333321,"d":"₪ 15,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":76.57254511837772,"d":"₪ 76.57"},{"v":743.2392117850443,"d":"₪ 743.24"},{"v":14666.666666666655,"d":"₪ 14,666.67"}]
[{"$nulls":8},99,{"v":14666.666666666655,"d":"₪ 14,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":73.24330402627434,"d":"₪ 73.24"},{"v":739.909970692941,"d":"₪ 739.91"},{"v":13999.999999999989,"d":"₪ 14,000.00"}]
[{"$nulls":8},100,{"v":13999.999999999989,"d":"₪ 14,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":69.91406293417096,"d":"₪ 69.91"},{"v":736.5807296008376,"d":"₪ 736.58"},{"v":13333.333333333323,"d":"₪ 13,333.33"}]
[{"$nulls":8},101,{"v":13333.333333333323,"d":"₪ 13,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":66.58482184206758,"d":"₪ 66.58"},{"v":733.2514885087342,"d":"₪ 733.25"},{"v":12666.666666666657,"d":"₪ 12,666.67"}]
[{"$nulls":8},102,{"v":12666.666666666657,"d":"₪ 12,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":63.2555807499642,"d":"₪ 63.26"},{"v":729.9222474166309,"d":"₪ 729.92"},{"v":11999.99999999999,"d":"₪ 12,000.00"}]
[{"$nulls":8},103,{"v":11999.99999999999,"d":"₪ 12,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":59.92633965786083,"d":"₪ 59.93"},{"v":726.5930063245274,"d":"₪ 726.59"},{"v":11333.333333333325,"d":"₪ 11,333.33"}]
[{"$nulls":8},104,{"v":11333.333333333325,"d":"₪ 11,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":56.59709856575745,"d":"₪ 56.60"},{"v":723.263765232424,"d":"₪ 723.26"},{"v":10666.666666666659,"d":"₪ 10,666.67"}]
[{"$nulls":8},105,{"v":10666.666666666659,"d":"₪ 10,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":53.26785747365407,"d":"₪ 53.27"},{"v":719.9345241403207,"d":"₪ 719.93"},{"v":9999.999999999993,"d":"₪ 10,000.00"}]
[{"$nulls":8},106,{"v":9999.999999999993,"d":"₪ 10,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":49.93861638155069,"d":"₪ 49.94"},{"v":716.6052830482173,"d":"₪ 716.61"},{"v":9333.333333333327,"d":"₪ 9,333.33"}]
[{"$nulls":8},107,{"v":9333.333333333327,"d":"₪ 9,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":46.609375289447314,"d":"₪ 46.61"},{"v":713.2760419561139,"d":"₪ 713.28"},{"v":8666.66666666666,"d":"₪ 8,666.67"}]
[{"$nulls":8},108,{"v":8666.66666666666,"d":"₪ 8,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":43.28013419734393,"d":"₪ 43.28"},{"v":709.9468008640106,"d":"₪ 709.95"},{"v":7999.999999999994,"d":"₪ 8,000.00"}]
[{"$nulls":8},109,{"v":7999.999999999994,"d":"₪ 8,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":39.95089310524055,"d":"₪ 39.95"},{"v":706.6175597719072,"d":"₪ 706.62"},{"v":7333.333333333327,"d":"₪ 7,333.33"}]
[{"$nulls":8},110,{"v":7333.333333333327,"d":"₪ 7,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":36.621652013137165,"d":"₪ 36.62"},{"v":703.2883186798038,"d":"₪ 703.29"},{"v":6666.66666666666,"d":"₪ 6,666.67"}]
[{"$nulls":8},111,{"v":6666.66666666666,"d":"₪ 6,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":33.292410921033785,"d":"₪ 33.29"},{"v":699.9590775877004,"d":"₪ 699.96"},{"v":5999.999999999993,"d":"₪ 6,000.00"}]
[{"$nulls":8},112,{"v":5999.999999999993,"d":"₪ 6,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":29.9631698289304,"d":"₪ 29.96"},{"v":696.629836495597,"d":"₪ 696.63"},{"v":5333.333333333326,"d":"₪ 5,333.33"}]
[{"$nulls":8},113,{"v":5333.333333333326,"d":"₪ 5,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":26.633928736827016,"d":"₪ 26.63"},{"v":693.3005954034936,"d":"₪ 693.30"},{"v":4666.666666666659,"d":"₪ 4,666.67"}]
[{"$nulls":8},114,{"v":4666.666666666659,"d":"₪ 4,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":23.304687644723632,"d":"₪ 23.30"},{"v":689.9713543113903,"d":"₪ 689.97"},{"v":3999.9999999999923,"d":"₪ 4,000.00"}]
[{"$nulls":8},115,{"v":3999.9999999999923,"d":"₪ 4,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":19.97544655262025,"d":"₪ 19.98"},{"v":686.6421132192869,"d":"₪ 686.64"},{"v":3333.3333333333258,"d":"₪ 3,333.33"}]
[{"$nulls":8},116,{"v":3333.3333333333258,"d":"₪ 3,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":16.64620546051687,"d":"₪ 16.65"},{"v":683.3128721271835,"d":"₪ 683.31"},{"v":2666.6666666666592,"d":"₪ 2,666.67"}]
[{"$nulls":8},117,{"v":2666.6666666666592,"d":"₪ 2,666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":13.31696436841349,"d":"₪ 13.32"},{"v":679.9836310350801,"d":"₪ 679.98"},{"v":1999.9999999999927,"d":"₪ 2,000.00"}]
[{"$nulls":8},118,{"v":1999.9999999999927,"d":"₪ 2,000.00"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":9.98772327631011,"d":"₪ 9.99"},{"v":676.6543899429768,"d":"₪ 676.65"},{"v":1333.3333333333262,"d":"₪ 1,333.33"}]
[{"$nulls":8},119,{"v":1333.3333333333262,"d":"₪ 1,333.33"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":6.658482184206728,"d":"₪ 6.66"},{"v":673.3251488508733,"d":"₪ 673.33"},{"v":666.6666666666596,"d":"₪ 666.67"}]
[{"$nulls":8},120,{"v":666.6666666666596,"d":"₪ 666.67"},{"v":666.6666666666666,"d":"₪ 666.67"},{"v":3.3292410921033464,"d":"₪ 3.33"},{"v":669.9959077587699,"d":"₪ 670.00"},{"v":-7.048583938740194e-12,"d":"₪ -0.00"}]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"שאלה 19",null,null,"לקחת היום הלוואה בגובה 660,000 ש\"ח ל- 12 שנים. בריבית אפקטיבית שנתית של 4.6%. \nעל פי מסמכי ההלוואה, ב- 9 השנים הראשונות היא תוחזר בהחזרי קרן שנתיים שווים. \nבשנה ה- 10 מוסכם כי ישונה לוח הסילוקין להחזרים שנתיים קבועים ושווים. \nבנה את לוח הסילוקין.\nחשב:\nא. מהו ההחזר על חשבון הריבית בתקופה 4?\nב. מהו התשלום הכולל בתקופה 9?\nג. מהו ה- PMT בתקופה 11?\n"]
[]
[]
[{"$nulls":8},"נתונים:",{"$nulls":3},"א",{"$f":"L315","v":{"v":22770,"d":"₪ 22,770.00"}}]
[{"$nulls":8},"הלוואה",{"v":660000,"d":"660,000"},"PV",null,"ב",{"$f":"M320","v":{"v":65120,"d":"65,120"}}]
[{"$nulls":8},"תקופות",12,"n",null,"ג",{"$f":"M332","v":{"v":60135.82951712611,"d":"₪ 60,135.83"}}]
[{"$nulls":8},"ריבית",{"v":0.046,"d":"4.60%"},"r"]
[{"$nulls":9},{"$f":"J307/J308","v":{"v":55000,"d":"₪ 55,000.00"}},"קרן שווה"]
[{"$nulls":8},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":8},1,{"$f":"J307","v":{"v":660000,"d":"₪ 660,000.00"}},{"$f":"$J$310","v":{"v":55000,"d":"₪ 55,000.00"}},{"$f":"$J$309*J312","v":{"v":30360,"d":"₪ 30,360.00"}},{"$f":"K312+L312","v":{"v":85360,"d":"₪ 85,360.00"}},{"$f":"J312-K312","v":{"v":605000,"d":"₪ 605,000.00"}}]
[{"$nulls":8},2,{"$f":"N312","v":{"v":605000,"d":"₪ 605,000.00"}},{"$f":"$J$310","v":{"v":55000,"d":"₪ 55,000.00"}},{"$f":"$J$309*J313","v":{"v":27830,"d":"₪ 27,830.00"}},{"$f":"K313+L313","v":{"v":82830,"d":"₪ 82,830.00"}},{"$f":"J313-K313","v":{"v":550000,"d":"₪ 550,000.00"}}]
[{"$nulls":8},3,{"$f":"N313","v":{"v":550000,"d":"₪ 550,000.00"}},{"v":55000,"d":"₪ 55,000.00"},{"v":25300,"d":"₪ 25,300.00"},{"v":80300,"d":"₪ 80,300.00"},{"v":495000,"d":"₪ 495,000.00"}]
[{"$nulls":8},4,{"v":495000,"d":"₪ 495,000.00"},{"v":55000,"d":"₪ 55,000.00"},{"v":22770,"d":"₪ 22,770.00"},{"v":77770,"d":"₪ 77,770.00"},{"v":440000,"d":"₪ 440,000.00"}]
[{"$nulls":8},5,{"v":440000,"d":"₪ 440,000.00"},{"v":55000,"d":"₪ 55,000.00"},{"v":20240,"d":"₪ 20,240.00"},{"v":75240,"d":"₪ 75,240.00"},{"v":385000,"d":"₪ 385,000.00"}]
[{"$nulls":8},6,{"v":385000,"d":"₪ 385,000.00"},{"v":55000,"d":"₪ 55,000.00"},{"v":17710,"d":"₪ 17,710.00"},{"v":72710,"d":"₪ 72,710.00"},{"v":330000,"d":"₪ 330,000.00"}]
[{"$nulls":8},7,{"v":330000,"d":"₪ 330,000.00"},{"v":55000,"d":"₪ 55,000.00"},{"v":15180,"d":"₪ 15,180.00"},{"v":70180,"d":"₪ 70,180.00"},{"v":275000,"d":"₪ 275,000.00"}]
[{"$nulls":8},8,{"v":275000,"d":"₪ 275,000.00"},{"v":55000,"d":"₪ 55,000.00"},{"v":12650,"d":"₪ 12,650.00"},{"v":67650,"d":"₪ 67,650.00"},{"v":220000,"d":"₪ 220,000.00"}]
[{"$nulls":8},9,{"v":220000,"d":"₪ 220,000.00"},{"v":55000,"d":"₪ 55,000.00"},{"v":10120,"d":"₪ 10,120.00"},{"v":65120,"d":"₪ 65,120.00"},{"v":165000,"d":"₪ 165,000.00"}]
[{"$nulls":8},10,{"v":165000,"d":"₪ 165,000.00"},{"v":55000,"d":"₪ 55,000.00"},{"v":7590,"d":"₪ 7,590.00"},{"v":62590,"d":"₪ 62,590.00"},{"v":110000,"d":"₪ 110,000.00"}]
[{"$nulls":8},11,{"v":110000,"d":"₪ 110,000.00"},{"v":55000,"d":"₪ 55,000.00"},{"v":5060,"d":"₪ 5,060.00"},{"v":60060,"d":"₪ 60,060.00"},{"v":55000,"d":"₪ 55,000.00"}]
[{"$nulls":8},12,{"v":55000,"d":"₪ 55,000.00"},{"v":55000,"d":"₪ 55,000.00"},{"v":2530,"d":"₪ 2,530.00"},{"v":57530,"d":"₪ 57,530.00"},{"v":0,"d":"₪ 0.00"}]
[]
[{"$nulls":8},"נתונים:"]
[{"$nulls":8},"הלוואה",{"$f":"N320","v":{"v":165000,"d":"165,000"}},"PV"]
[{"$nulls":8},"תקופות",3,"n"]
[{"$nulls":8},"ריבית",{"v":0.046,"d":"4.60%"},"r"]
[{"$nulls":9},{"$f":"PMT(J328,J327,-J326,,)","v":{"v":60135.82951712611,"d":"₪ 60,135.83"}},"PMT"]
[{"$nulls":8},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":7},10,1,{"$f":"J326","v":{"v":165000,"d":"₪ 165,000.00"}},{"$f":"M331-L331","v":{"v":52545.82951712611,"d":"₪ 52,545.83"}},{"$f":"$J$328*J331","v":{"v":7590,"d":"₪ 7,590.00"}},{"$f":"$J$329","v":{"v":60135.82951712611,"d":"₪ 60,135.83"}},{"$f":"J331-K331","v":{"v":112454.17048287389,"d":"₪ 112,454.17"}}]
[{"$nulls":7},11,2,{"$f":"N331","v":{"v":112454.17048287389,"d":"₪ 112,454.17"}},{"$f":"M332-L332","v":{"v":54962.93767491391,"d":"₪ 54,962.94"}},{"$f":"$J$328*J332","v":{"v":5172.891842212199,"d":"₪ 5,172.89"}},{"$f":"$J$329","v":{"v":60135.82951712611,"d":"₪ 60,135.83"}},{"$f":"J332-K332","v":{"v":57491.232807959976,"d":"₪ 57,491.23"}}]
[{"$nulls":7},12,3,{"$f":"N332","v":{"v":57491.232807959976,"d":"₪ 57,491.23"}},{"v":57491.232807959954,"d":"₪ 57,491.23"},{"v":2644.5967091661587,"d":"₪ 2,644.60"},{"v":60135.82951712611,"d":"₪ 60,135.83"},{"v":0,"d":"₪ 0.00"}]