{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["פתרון שאלות אמריקאיות 1-15","פתרון שאלה פתוחה"],"not_rendered":{"images":18},"read":"whole","date_system":"1900"}

{"sheet":"פתרון שאלות אמריקאיות 1-15","index":0,"n_rows":569,"n_cols":31,"rows_kept":569}
[]
["מבחן מה-30.7.19 2019ב"]
[]
["אופיר מאגדי   0507484348"]
["מורה פרטי ומרצה למימון, שוק ההון ושמאות מקרקעין."]
["רוצים להכיר אותי? כנסו לאתר",{"$nulls":3},"www.NPV.co.il"]
[]
["רוצים לקרוא עוד? כמסו לאתר:",{"$nulls":3},"www.IRR.co.il"]
[]
["מנכ\"ל חברת Primary Capital",{"$nulls":3},"www.prim.co.il"]
{"$rows_empty":9}
[{"$nulls":8},"תקופת משיכות",{"$nulls":5},"תקופת הפקדות"]
[]
[{"$nulls":8},"ריבית שנתית",{"v":0.0491,"d":"4.91%"},{"$nulls":4},{"$f":"5*12","v":60},"N"]
[{"$nulls":8},"ריבית חודשית:",{"$f":"(1+J22)^(1/12)-1","v":{"v":4.002376012389508E-3,"d":"0.40%"}}]
[{"$nulls":8},"חודשים",24,{"$nulls":5},{"$f":"PMT(J23,O22,,J26)","v":{"v":-2372.2533526513366,"d":"₪ -2,372.25"}}]
[{"$nulls":8},"תקבול חודשי",{"v":7000,"d":"7,000.00"}]
[{"$nulls":8},"PV",{"$f":"PV(J23,J24,-J25,,1)","v":{"v":160518.74847101956,"d":"₪ 160,518.75"}}]
{"$rows_empty":23}
[{"$nulls":8},"הלוואה",50000]
[{"$nulls":8},"ריבית נקובה שנתית",{"v":0.12,"d":"12%"},null,null,".....10",1,0]
[{"$nulls":8},"ריבית חודשית",{"$f":"J51/12","v":{"v":0.01,"d":"1.00%"}},null,null,{"$f":"FV(J52,J53,,-O52)","v":{"v":55231.10627056024,"d":"₪ 55,231.11"}},null,{"$f":"J50","v":50000}]
[{"$nulls":8},"חודשים",10,null,null,{"$f":"J55","v":{"v":1200,"d":"1,200"}},null,{"$f":"-J54","v":{"v":-1000,"d":"-1,000"}}]
[{"$nulls":8},"ע. פתיחת תיק",{"v":1000,"d":"1,000"},null,null,{"$f":"M52+M53","v":{"v":56431.10627056024,"d":"56,431"}},0,{"$f":"O52+O53","v":{"v":49000,"d":"49,000"}}]
[{"$nulls":8},"ע.סגירת תיק",{"v":1200,"d":"1,200"}]
[{"$nulls":8},"סכום ההחזר (קרן+ריבית)",{"$nulls":5},{"$f":"RATE(J53,,-O54,M54)","v":{"v":0.014220182191441624,"d":"1.42%"}}]
[]
[{"$nulls":8},"ריבית גלומה ל-10 חודשים:",{"$f":"(1+O56)^10-1","v":{"v":0.15165523001143377,"d":"15.17%"}}]
[]
[{"$nulls":8},"הריבית השנתית האפקטיבית:",{"$f":"(1+O56)^12-1","v":{"v":0.18464160472519242,"d":"18.46%"}}]
{"$rows_empty":61}
[{"$nulls":8},"אג\"ח סדרה ב",null,"אג\"ח סדרה א"]
[{"$nulls":8},"ערך נקוב",{"v":200000,"d":"200,000"},"ערך נקוב",{"v":100000,"d":"100,000"}]
[{"$nulls":8},"ריבית נקובה שנתית",{"v":0.1,"d":"10%"},"קופון",{"v":5000,"d":"5,000"}]
[{"$nulls":8},"מרווח בין קופונים ",2,"מרווח בין קופונים",1]
[{"$nulls":8},"מספר קופונים ",{"$f":"5*2","v":10},"מספר קופונים",7]
[{"$nulls":8},"מחיר בהנפקה",{"v":250000,"d":"250,000"}]
[{"$nulls":8},"הקופון",{"$f":"J123*J124/J125","v":{"v":10000,"d":"10,000"}},"נחשב מחיר בהנפקה",{"$f":"PV(J130,L126,L124,L123)","v":{"v":-103389.46533199727,"d":"(103,389.47)"}}]
[{"$nulls":8},"נחשב את התשואה החצי-שנתית לפדיון",{"$f":"RATE(J126,J128,-J127,J123)","v":{"v":0.021892127573485375,"d":"2.19%"}}]
[{"$nulls":8},"תשואה שנתית לפדיון",{"$f":"(1+J129)^(2)-1","v":{"v":0.04426352039666437,"d":"4.43%"}}]
{"$rows_empty":28}
[{"$nulls":11},4,3,2,1]
[{"$nulls":10},{"v":0.01,"d":"1.00%"},{"$f":"RATE(1,,-K165,I165)","v":{"v":0.04126288659793799,"d":"4.13%"}},{"$f":"(1+M161)^12-1","v":{"v":0.04281800719861484,"d":"4.28%"}},{"$f":"RATE(1,,-N165,M165)","v":{"v":0.04166666666666673,"d":"4.17%"}},{"$f":"EFFECT(4%,4)","v":{"v":0.040604010000000024,"d":"4.06%"}}]
[{"$nulls":10},{"$f":"K160/2","v":{"v":0.005,"d":"0.50%"}},null,{"v":0.0035,"d":"0.35%"}]
[{"$nulls":8},2,1,0,null,1,0]
[{"$nulls":8},{"$f":"FV(K161,2,,-K163)","v":{"v":101002.49999999997,"d":"₪ 101,002.50"}},null,{"$f":"N163","v":100000},null,{"$f":"N163","v":100000},100000]
[{"$nulls":10},{"$f":"-0.03*K163","v":-3000},null,null,{"$f":"-0.04*N163","v":-4000}]
[{"$nulls":8},{"$f":"I163+I164","v":101002.49999999997},0,{"$f":"K163+K164","v":97000},null,{"$f":"M163","v":100000},{"$f":"N163+N164","v":96000}]
{"$rows_empty":26}
[{"$nulls":8},0]
[{"$nulls":8},1,{"v":-50000,"d":"-50,000"}]
[{"$nulls":8},2]
[{"$nulls":8},3]
[{"$nulls":8},4,"X"]
[{"$nulls":8},5,{"v":200000,"d":"200,000"}]
[]
[{"$nulls":8},"ריבית שנתית",{"v":0.08,"d":"8%"}]
[]
[{"$nulls":8},"ה - 50,000 בזמן 1 שווה בזמן 5:",{"$f":"FV(J199,4,,J193)","v":{"v":68024.44800000002,"d":"₪ 68,024.45"}},"יש 4 תקופות זמן"]
[{"$nulls":8},"ולכן חסר לסכום הנכס:",{"$f":"J197-J201","v":{"v":131975.55199999997,"d":"131,975.55"}},"זהו הערך העתידי החסר"]
[{"$nulls":8},"מיהו הסכום החד פעמי הנוכחי בזמן 4 שיביא ערך עתידי זה? "]
[{"$nulls":8},"הערה: יש 1 תקופות זמן בין זמן 4 לזמן 5 - ",{"$f":"PV(J199,1,,J202)","v":{"v":-122199.58518518515,"d":"₪ -122,199.59"}}]
{"$rows_empty":25}
[{"$nulls":9},"B","A"]
[{"$nulls":9},-300,-200,"השקעה"]
[{"$nulls":9},322,220,"תקבול"]
[]
[{"$nulls":9},{"$f":"NPV(M234,J232)-300","v":-1.2987012987013031},{"$f":"NPV(M234,K232)-200","v":4.081632653061206},"NPV",{"v":0.078,"d":"7.80%"}]
[{"$nulls":10},{"$f":"IRR(K231:K232)","v":{"v":0.10000000000000009,"d":"10%"}},"IRR"]
{"$rows_empty":13}
[{"$nulls":19},"רגיל",{"$nulls":5},"שפיצר"]
[{"$nulls":18},"נתונים:",{"$nulls":6},"נתונים:"]
[{"$nulls":18},"הלוואה",{"$f":"AE285","v":{"v":886520.4828940689,"d":"886,520"}},"PV",{"$nulls":4},"הלוואה",{"v":2000000,"d":"2,000,000"},"PV",null,{"v":0.1539,"d":"15.39%"}]
[{"$nulls":18},"מספר תקופות",18,"n",{"$nulls":4},"חודשים",{"$f":"4*12","v":48},"n",null,12]
[{"$nulls":18},"ריבית",{"$f":"(1+W253)^(1/12)-1","v":{"v":0.01200039289517818,"d":"1.20%"}},"r",null,{"v":0.1539,"d":"15.39%"},"Rשנתי ",null,"ריבית",{"$f":"(1+AD251)^(1/AD252)-1","v":{"v":0.01200039289517818,"d":"1.20%"}},"r",null,{"$f":"2.5*12","v":30}]
[{"$nulls":19},{"$f":"T251/T252","v":49251.13793855938},"קרן קבועה",{"$nulls":5},{"$f":"PMT(AA253,AA252,-AA251,,)","v":{"v":55055.57887503393,"d":"₪ 55,055.58"}},"PMT"]
[{"$nulls":18},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה",null,"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":18},1,{"$f":"T251","v":{"v":886520.4828940689,"d":"₪ 886,520.48"}},{"$f":"$T$254","v":{"v":49251.13793855938,"d":"₪ 49,251.14"}},{"$f":"$T$253*T256","v":{"v":10638.594104351914,"d":"₪ 10,638.59"}},{"$f":"V256+U256","v":{"v":59889.732042911295,"d":"₪ 59,889.73"}},{"$f":"T256-U256","v":{"v":837269.3449555095,"d":"₪ 837,269.34"}},31,1,{"$f":"AA251","v":{"v":2000000,"d":"₪ 2,000,000.00"}},{"$f":"AD256-AC256","v":{"v":31054.793084677567,"d":"₪ 31,054.79"}},{"$f":"$AA$253*AA256","v":{"v":24000.78579035636,"d":"₪ 24,000.79"}},{"$f":"$AA$254","v":{"v":55055.57887503393,"d":"₪ 55,055.58"}},{"$f":"AA256-AB256","v":{"v":1968945.2069153225,"d":"₪ 1,968,945.21"}}]
[{"$nulls":18},2,{"$f":"X256","v":{"v":837269.3449555095,"d":"₪ 837,269.34"}},{"$f":"$T$254","v":{"v":49251.13793855938,"d":"₪ 49,251.14"}},{"$f":"$T$253*T257","v":{"v":10047.561098554586,"d":"₪ 10,047.56"}},{"$f":"V257+U257","v":{"v":59298.69903711397,"d":"₪ 59,298.70"}},{"$f":"T257-U257","v":{"v":788018.2070169501,"d":"₪ 788,018.21"}},32,2,{"$f":"AE256","v":{"v":1968945.2069153225,"d":"₪ 1,968,945.21"}},{"$f":"AD257-AC257","v":{"v":31427.46280297216,"d":"₪ 31,427.46"}},{"$f":"$AA$253*AA257","v":{"v":23628.116072061766,"d":"₪ 23,628.12"}},{"$f":"$AA$254","v":{"v":55055.57887503393,"d":"₪ 55,055.58"}},{"$f":"AA257-AB257","v":{"v":1937517.7441123503,"d":"₪ 1,937,517.74"}}]
[{"$nulls":18},3,{"$f":"X257","v":{"v":788018.2070169501,"d":"₪ 788,018.21"}},{"v":49251.13793855938,"d":"₪ 49,251.14"},{"v":9456.528092757257,"d":"₪ 9,456.53"},{"v":58707.666031316636,"d":"₪ 58,707.67"},{"v":738767.0690783907,"d":"₪ 738,767.07"},33,3,{"$f":"AE257","v":{"v":1937517.7441123503,"d":"₪ 1,937,517.74"}},{"v":31804.604704306425,"d":"₪ 31,804.60"},{"v":23250.974170727502,"d":"₪ 23,250.97"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1905713.1394080438,"d":"₪ 1,905,713.14"}]
[{"$nulls":18},4,{"v":738767.0690783907,"d":"₪ 738,767.07"},{"v":49251.13793855938,"d":"₪ 49,251.14"},{"v":8865.495086959927,"d":"₪ 8,865.50"},{"v":58116.63302551931,"d":"₪ 58,116.63"},{"v":689515.9311398313,"d":"₪ 689,515.93"},34,4,{"v":1905713.1394080438,"d":"₪ 1,905,713.14"},{"v":32186.272456633935,"d":"₪ 32,186.27"},{"v":22869.306418399992,"d":"₪ 22,869.31"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1873526.86695141,"d":"₪ 1,873,526.87"}]
[{"$nulls":18},5,{"v":689515.9311398313,"d":"₪ 689,515.93"},{"v":49251.13793855938,"d":"₪ 49,251.14"},{"v":8274.4620811626,"d":"₪ 8,274.46"},{"v":57525.600019721984,"d":"₪ 57,525.60"},{"v":640264.7932012719,"d":"₪ 640,264.79"},35,5,{"v":1873526.86695141,"d":"₪ 1,873,526.87"},{"v":32572.520371944793,"d":"₪ 32,572.52"},{"v":22483.058503089134,"d":"₪ 22,483.06"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1840954.346579465,"d":"₪ 1,840,954.35"}]
[{"$nulls":18},6,{"v":640264.7932012719,"d":"₪ 640,264.79"},{"v":49251.13793855938,"d":"₪ 49,251.14"},{"v":7683.42907536527,"d":"₪ 7,683.43"},{"v":56934.56701392465,"d":"₪ 56,934.57"},{"v":591013.6552627125,"d":"₪ 591,013.66"},36,6,{"v":1840954.346579465,"d":"₪ 1,840,954.35"},{"v":32963.403413994325,"d":"₪ 32,963.40"},{"v":22092.175461039602,"d":"₪ 22,092.18"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1807990.9431654708,"d":"₪ 1,807,990.94"}]
[{"$nulls":18},7,{"v":591013.6552627125,"d":"₪ 591,013.66"},{"v":49251.13793855938,"d":"₪ 49,251.14"},{"v":7092.396069567942,"d":"₪ 7,092.40"},{"v":56343.534008127324,"d":"₪ 56,343.53"},{"v":541762.5173241531,"d":"₪ 541,762.52"},37,7,{"v":1807990.9431654708,"d":"₪ 1,807,990.94"},{"v":33358.97720612452,"d":"₪ 33,358.98"},{"v":21696.601668909414,"d":"₪ 21,696.60"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1774631.9659593464,"d":"₪ 1,774,631.97"}]
[{"$nulls":18},8,{"v":541762.5173241531,"d":"₪ 541,762.52"},{"v":49251.13793855938,"d":"₪ 49,251.14"},{"v":6501.363063770613,"d":"₪ 6,501.36"},{"v":55752.50100233,"d":"₪ 55,752.50"},{"v":492511.3793855937,"d":"₪ 492,511.38"},38,8,{"v":1774631.9659593464,"d":"₪ 1,774,631.97"},{"v":33759.298039179295,"d":"₪ 33,759.30"},{"v":21296.280835854628,"d":"₪ 21,296.28"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1740872.667920167,"d":"₪ 1,740,872.67"}]
[{"$nulls":18},9,{"v":492511.3793855937,"d":"₪ 492,511.38"},{"v":49251.13793855938,"d":"₪ 49,251.14"},{"v":5910.330057973284,"d":"₪ 5,910.33"},{"v":55161.467996532665,"d":"₪ 55,161.47"},{"v":443260.2414470343,"d":"₪ 443,260.24"},39,9,{"v":1740872.667920167,"d":"₪ 1,740,872.67"},{"v":34164.42287951487,"d":"₪ 34,164.42"},{"v":20891.155995519057,"d":"₪ 20,891.16"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1706708.2450406523,"d":"₪ 1,706,708.25"}]
[{"$nulls":18},10,{"v":443260.2414470343,"d":"₪ 443,260.24"},{"v":49251.13793855938,"d":"₪ 49,251.14"},{"v":5319.297052175955,"d":"₪ 5,319.30"},{"v":54570.43499073534,"d":"₪ 54,570.43"},{"v":394009.1035084749,"d":"₪ 394,009.10"},40,10,{"v":1706708.2450406523,"d":"₪ 1,706,708.25"},{"v":34574.40937710606,"d":"₪ 34,574.41"},{"v":20481.169497927865,"d":"₪ 20,481.17"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1672133.8356635463,"d":"₪ 1,672,133.84"}]
[{"$nulls":18},11,{"v":394009.1035084749,"d":"₪ 394,009.10"},{"v":49251.13793855938,"d":"₪ 49,251.14"},{"v":4728.2640463786265,"d":"₪ 4,728.26"},{"v":53979.40198493801,"d":"₪ 53,979.40"},{"v":344757.9655699155,"d":"₪ 344,757.97"},41,11,{"v":1672133.8356635463,"d":"₪ 1,672,133.84"},{"v":34989.31587375006,"d":"₪ 34,989.32"},{"v":20066.26300128386,"d":"₪ 20,066.26"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1637144.5197897963,"d":"₪ 1,637,144.52"}]
[{"$nulls":18},12,{"v":344757.9655699155,"d":"₪ 344,757.97"},{"v":49251.13793855938,"d":"₪ 49,251.14"},{"v":4137.231040581298,"d":"₪ 4,137.23"},{"v":53388.36897914068,"d":"₪ 53,388.37"},{"v":295506.8276313561,"d":"₪ 295,506.83"},42,12,{"v":1637144.5197897963,"d":"₪ 1,637,144.52"},{"v":35409.20141136856,"d":"₪ 35,409.20"},{"v":19646.377463665365,"d":"₪ 19,646.38"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1601735.3183784278,"d":"₪ 1,601,735.32"}]
[{"$nulls":18},13,{"v":295506.8276313561,"d":"₪ 295,506.83"},{"v":49251.13793855938,"d":"₪ 49,251.14"},{"v":3546.1980347839685,"d":"₪ 3,546.20"},{"v":52797.33597334335,"d":"₪ 52,797.34"},{"v":246255.6896927967,"d":"₪ 246,255.69"},43,13,{"v":1601735.3183784278,"d":"₪ 1,601,735.32"},{"v":35834.12574040948,"d":"₪ 35,834.13"},{"v":19221.453134624444,"d":"₪ 19,221.45"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1565901.1926380182,"d":"₪ 1,565,901.19"}]
[{"$nulls":18},14,{"v":246255.6896927967,"d":"₪ 246,255.69"},{"v":49251.13793855938,"d":"₪ 49,251.14"},{"v":2955.16502898664,"d":"₪ 2,955.17"},{"v":52206.30296754602,"d":"₪ 52,206.30"},{"v":197004.55175423733,"d":"₪ 197,004.55"},44,14,{"v":1565901.1926380182,"d":"₪ 1,565,901.19"},{"v":36264.14932834962,"d":"₪ 36,264.15"},{"v":18791.42954668431,"d":"₪ 18,791.43"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1529637.0433096685,"d":"₪ 1,529,637.04"}]
[{"$nulls":18},15,{"v":197004.55175423733,"d":"₪ 197,004.55"},{"v":49251.13793855938,"d":"₪ 49,251.14"},{"v":2364.132023189312,"d":"₪ 2,364.13"},{"v":51615.269961748694,"d":"₪ 51,615.27"},{"v":147753.41381567795,"d":"₪ 147,753.41"},45,15,{"v":1529637.0433096685,"d":"₪ 1,529,637.04"},{"v":36699.33336829922,"d":"₪ 36,699.33"},{"v":18356.245506734704,"d":"₪ 18,356.25"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1492937.7099413692,"d":"₪ 1,492,937.71"}]
[{"$nulls":18},16,{"$f":"X270","v":{"v":147753.41381567795,"d":"₪ 147,753.41"}},{"v":49251.13793855938,"d":"₪ 49,251.14"},{"v":1773.0990173919834,"d":"₪ 1,773.10"},{"$f":"V271+U271","v":{"v":51024.23695595137,"d":"₪ 51,024.24"}},{"$f":"T271-U271","v":{"v":98502.27587711858,"d":"₪ 98,502.28"}},46,16,{"v":1492937.7099413692,"d":"₪ 1,492,937.71"},{"v":37139.739787709936,"d":"₪ 37,139.74"},{"v":17915.83908732399,"d":"₪ 17,915.84"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1455797.9701536593,"d":"₪ 1,455,797.97"}]
[{"$nulls":18},17,{"v":98502.27587711858,"d":"₪ 98,502.28"},{"v":49251.13793855938,"d":"₪ 49,251.14"},{"v":1182.0660115946548,"d":"₪ 1,182.07"},{"v":50433.203950154035,"d":"₪ 50,433.20"},{"v":49251.13793855919,"d":"₪ 49,251.14"},47,17,{"v":1455797.9701536593,"d":"₪ 1,455,797.97"},{"v":37585.43125718714,"d":"₪ 37,585.43"},{"v":17470.14761784679,"d":"₪ 17,470.15"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1418212.5388964722,"d":"₪ 1,418,212.54"}]
[{"$nulls":18},18,{"v":49251.13793855919,"d":"₪ 49,251.14"},{"v":49251.13793855938,"d":"₪ 49,251.14"},{"v":591.0330057973263,"d":"₪ 591.03"},{"v":49842.17094435671,"d":"₪ 49,842.17"},{"v":-1.8917489796876907E-10,"d":"₪ -0.00"},48,18,{"v":1418212.5388964722,"d":"₪ 1,418,212.54"},{"v":38036.47119940809,"d":"₪ 38,036.47"},{"v":17019.107675625834,"d":"₪ 17,019.11"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1380176.067697064,"d":"₪ 1,380,176.07"}]
[{"$nulls":24},19,19,{"v":1380176.067697064,"d":"₪ 1,380,176.07"},{"v":38492.92379814712,"d":"₪ 38,492.92"},{"v":16562.655076886807,"d":"₪ 16,562.66"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1341683.143898917,"d":"₪ 1,341,683.14"}]
[{"$nulls":24},20,20,{"v":1341683.143898917,"d":"₪ 1,341,683.14"},{"v":38954.85400740904,"d":"₪ 38,954.85"},{"v":16100.724867624886,"d":"₪ 16,100.72"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1302728.289891508,"d":"₪ 1,302,728.29"}]
[{"$nulls":24},21,21,{"v":1302728.289891508,"d":"₪ 1,302,728.29"},{"v":39422.32756067225,"d":"₪ 39,422.33"},{"v":15633.251314361672,"d":"₪ 15,633.25"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1263305.9623308356,"d":"₪ 1,263,305.96"}]
[{"$nulls":24},22,22,{"v":1263305.9623308356,"d":"₪ 1,263,305.96"},{"v":39895.410980242734,"d":"₪ 39,895.41"},{"v":15160.167894791193,"d":"₪ 15,160.17"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1223410.5513505929,"d":"₪ 1,223,410.55"}]
[{"$nulls":24},23,23,{"v":1223410.5513505929,"d":"₪ 1,223,410.55"},{"v":40374.17158672025,"d":"₪ 40,374.17"},{"v":14681.407288313674,"d":"₪ 14,681.41"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1183036.3797638726,"d":"₪ 1,183,036.38"}]
[{"$nulls":24},24,24,{"v":1183036.3797638726,"d":"₪ 1,183,036.38"},{"v":40858.677508578236,"d":"₪ 40,858.68"},{"v":14196.901366455691,"d":"₪ 14,196.90"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1142177.7022552944,"d":"₪ 1,142,177.70"}]
[{"$nulls":24},25,25,{"v":1142177.7022552944,"d":"₪ 1,142,177.70"},{"v":41348.99769185855,"d":"₪ 41,349.00"},{"v":13706.581183175374,"d":"₪ 13,706.58"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1100828.7045634359,"d":"₪ 1,100,828.70"}]
[{"$nulls":24},26,26,{"v":1100828.7045634359,"d":"₪ 1,100,828.70"},{"v":41845.20190998267,"d":"₪ 41,845.20"},{"v":13210.376965051255,"d":"₪ 13,210.38"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1058983.5026534533,"d":"₪ 1,058,983.50"}]
[{"$nulls":24},27,27,{"v":1058983.5026534533,"d":"₪ 1,058,983.50"},{"v":42347.36077368052,"d":"₪ 42,347.36"},{"v":12708.218101353405,"d":"₪ 12,708.22"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":1016636.1418797728,"d":"₪ 1,016,636.14"}]
[{"$nulls":24},28,28,{"v":1016636.1418797728,"d":"₪ 1,016,636.14"},{"v":42855.54574103854,"d":"₪ 42,855.55"},{"v":12200.033133995381,"d":"₪ 12,200.03"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":973780.5961387343,"d":"₪ 973,780.60"}]
[{"$nulls":24},29,29,{"v":973780.5961387343,"d":"₪ 973,780.60"},{"v":43369.82912766829,"d":"₪ 43,369.83"},{"v":11685.749747365639,"d":"₪ 11,685.75"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":930410.767011066,"d":"₪ 930,410.77"}]
[{"$nulls":24},30,30,{"v":930410.767011066,"d":"₪ 930,410.77"},{"v":43890.28411699705,"d":"₪ 43,890.28"},{"v":11165.294758036876,"d":"₪ 11,165.29"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":886520.4828940689,"d":"₪ 886,520.48"}]
[{"$nulls":24},31,31,{"v":886520.4828940689,"d":"₪ 886,520.48"},{"v":44416.984770682015,"d":"₪ 44,416.98"},{"v":10638.594104351914,"d":"₪ 10,638.59"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":842103.4981233869,"d":"₪ 842,103.50"}]
[{"$nulls":24},32,32,{"v":842103.4981233869,"d":"₪ 842,103.50"},{"v":44950.006039149346,"d":"₪ 44,950.01"},{"v":10105.572835884584,"d":"₪ 10,105.57"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":797153.4920842375,"d":"₪ 797,153.49"}]
[{"$nulls":24},33,33,{"v":797153.4920842375,"d":"₪ 797,153.49"},{"v":45489.42377225977,"d":"₪ 45,489.42"},{"v":9566.155102774159,"d":"₪ 9,566.16"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":751664.0683119778,"d":"₪ 751,664.07"}]
[{"$nulls":24},34,34,{"v":751664.0683119778,"d":"₪ 751,664.07"},{"v":46035.31473010214,"d":"₪ 46,035.31"},{"v":9020.264144931785,"d":"₪ 9,020.26"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":705628.7535818757,"d":"₪ 705,628.75"}]
[{"$nulls":24},35,35,{"v":705628.7535818757,"d":"₪ 705,628.75"},{"v":46587.75659391655,"d":"₪ 46,587.76"},{"v":8467.822281117376,"d":"₪ 8,467.82"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":659040.9969879591,"d":"₪ 659,041.00"}]
[{"$nulls":24},36,36,{"v":659040.9969879591,"d":"₪ 659,041.00"},{"v":47146.82797714848,"d":"₪ 47,146.83"},{"v":7908.750897885449,"d":"₪ 7,908.75"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":611894.1690108107,"d":"₪ 611,894.17"}]
[{"$nulls":24},37,37,{"v":611894.1690108107,"d":"₪ 611,894.17"},{"v":47712.60843663564,"d":"₪ 47,712.61"},{"v":7342.970438398289,"d":"₪ 7,342.97"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":564181.5605741751,"d":"₪ 564,181.56"}]
[{"$nulls":24},38,38,{"v":564181.5605741751,"d":"₪ 564,181.56"},{"v":48285.178483929056,"d":"₪ 48,285.18"},{"v":6770.4003911048685,"d":"₪ 6,770.40"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":515896.382090246,"d":"₪ 515,896.38"}]
[{"$nulls":24},39,39,{"v":515896.382090246,"d":"₪ 515,896.38"},{"v":48864.61959675001,"d":"₪ 48,864.62"},{"v":6190.959278283916,"d":"₪ 6,190.96"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":467031.762493496,"d":"₪ 467,031.76"}]
[{"$nulls":24},40,40,{"v":467031.762493496,"d":"₪ 467,031.76"},{"v":49451.014230584435,"d":"₪ 49,451.01"},{"v":5604.564644449492,"d":"₪ 5,604.56"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":417580.74826291157,"d":"₪ 417,580.75"}]
[{"$nulls":24},41,41,{"v":417580.74826291157,"d":"₪ 417,580.75"},{"v":50044.445830416495,"d":"₪ 50,044.45"},{"v":5011.1330446174325,"d":"₪ 5,011.13"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":367536.30243249505,"d":"₪ 367,536.30"}]
[{"$nulls":24},42,42,{"v":367536.30243249505,"d":"₪ 367,536.30"},{"v":50644.99884260295,"d":"₪ 50,645.00"},{"v":4410.580032430972,"d":"₪ 4,410.58"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":316891.3035898921,"d":"₪ 316,891.30"}]
[{"$nulls":24},43,43,{"v":316891.3035898921,"d":"₪ 316,891.30"},{"v":51252.75872689003,"d":"₪ 51,252.76"},{"v":3802.820148143893,"d":"₪ 3,802.82"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":265638.5448630021,"d":"₪ 265,638.54"}]
[{"$nulls":24},44,44,{"v":265638.5448630021,"d":"₪ 265,638.54"},{"v":51867.81196857449,"d":"₪ 51,867.81"},{"v":3187.7669064594406,"d":"₪ 3,187.77"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":213770.7328944276,"d":"₪ 213,770.73"}]
[{"$nulls":24},45,45,{"v":213770.7328944276,"d":"₪ 213,770.73"},{"v":52490.24609081061,"d":"₪ 52,490.25"},{"v":2565.3327842233216,"d":"₪ 2,565.33"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":161280.486803617,"d":"₪ 161,280.49"}]
[{"$nulls":24},46,46,{"v":161280.486803617,"d":"₪ 161,280.49"},{"v":53120.14966706492,"d":"₪ 53,120.15"},{"v":1935.4292079690038,"d":"₪ 1,935.43"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":108160.33713655209,"d":"₪ 108,160.34"}]
[{"$nulls":24},47,47,{"v":108160.33713655209,"d":"₪ 108,160.34"},{"v":53757.61233372037,"d":"₪ 53,757.61"},{"v":1297.9665413135563,"d":"₪ 1,297.97"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":54402.72480283172,"d":"₪ 54,402.72"}]
[{"$nulls":24},48,48,{"v":54402.72480283172,"d":"₪ 54,402.72"},{"v":54402.72480283169,"d":"₪ 54,402.72"},{"v":652.8540722022356,"d":"₪ 652.85"},{"v":55055.57887503393,"d":"₪ 55,055.58"},{"v":0,"d":"₪ 0.00"}]
[]
[]
[]
[{"$nulls":19},"רגיל",{"$nulls":5},"שפיצר"]
[{"$nulls":18},"נתונים:",{"$nulls":6},"נתונים:"]
[{"$nulls":18},"הלוואה",{"v":300000,"d":"300,000"},"PV",{"$nulls":4},"הלוואה",{"v":300000,"d":"300,000"},"PV"]
[{"$nulls":18},"מספר תקופות",60,"n",{"$nulls":4},"חודשים",60,"n"]
[{"$nulls":18},"ריבית",{"v":0.01,"d":"1.00%"},"r",null,null,"Rשנתי ",null,"ריבית",{"v":0.01,"d":"1.00%"},"r"]
[{"$nulls":19},{"$f":"T309/T310","v":5000},"קרן קבועה",{"$nulls":5},{"$f":"PMT(AA311,AA310,-AA309,,)","v":{"v":6673.334305470533,"d":"₪ 6,673.33"}},"PMT"]
[{"$nulls":18},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה",null,"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":18},1,{"$f":"T309","v":{"v":300000,"d":"₪ 300,000.00"}},{"$f":"T312","v":{"v":5000,"d":"₪ 5,000.00"}},{"$f":"$T$311*T314","v":{"v":3000,"d":"₪ 3,000.00"}},{"$f":"V314+U314","v":{"v":8000,"d":"₪ 8,000.00"}},{"$f":"T314-U314","v":{"v":295000,"d":"₪ 295,000.00"}},null,1,{"$f":"AA309","v":{"v":300000,"d":"₪ 300,000.00"}},{"$f":"AD314-AC314","v":{"v":3673.334305470533,"d":"₪ 3,673.33"}},{"$f":"$AA$311*AA314","v":{"v":3000,"d":"₪ 3,000.00"}},{"$f":"$AA$312","v":{"v":6673.334305470533,"d":"₪ 6,673.33"}},{"$f":"AA314-AB314","v":{"v":296326.6656945295,"d":"₪ 296,326.67"}}]
[{"$nulls":18},2,{"$f":"X314","v":{"v":295000,"d":"₪ 295,000.00"}},{"$f":"T312","v":{"v":5000,"d":"₪ 5,000.00"}},{"$f":"$T$253*T315","v":{"v":3540.1159040775633,"d":"₪ 3,540.12"}},{"$f":"V315+U315","v":{"v":8540.115904077564,"d":"₪ 8,540.12"}},{"$f":"T315-U315","v":{"v":290000,"d":"₪ 290,000.00"}},null,2,{"$f":"AE314","v":{"v":296326.6656945295,"d":"₪ 296,326.67"}},{"$f":"AD315-AC315","v":{"v":51499.542461381454,"d":"₪ 51,499.54"}},{"$f":"$AA$253*AA315","v":{"v":3556.0364136524713,"d":"₪ 3,556.04"}},{"$f":"$AA$254","v":{"v":55055.57887503393,"d":"₪ 55,055.58"}},{"$f":"AA315-AB315","v":{"v":244827.123233148,"d":"₪ 244,827.12"}}]
[]
[{"$nulls":29},{"$f":"W314-AD314","v":{"v":1326.6656945294671,"d":"₪ 1,326.67"}}]
[]
[]
[]
[{"$nulls":18},"נתונים:"]
[{"$nulls":18},"הלוואה",{"v":100000,"d":"100,000"},"PV"]
[{"$nulls":18},"מספר תקופות",{"$f":"5*12","v":60},"n"]
[{"$nulls":18},"ריבית",{"v":0.01,"d":"1.00%"},"r"]
[]
[{"$nulls":18},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":18},1,{"$f":"T322","v":{"v":100000,"d":"₪ 100,000.00"}},{"v":0,"d":"₪ 0.00"},{"$f":"$T$324*T327","v":{"v":1000,"d":"₪ 1,000.00"}},{"$f":"U327+V327","v":{"v":1000,"d":"₪ 1,000.00"}},{"$f":"T327-U327","v":{"v":100000,"d":"₪ 100,000.00"}}]
[{"$nulls":18},2,{"$f":"X327","v":{"v":100000,"d":"₪ 100,000.00"}},{"v":0,"d":"₪ 0.00"},{"$f":"$T$324*T328","v":{"v":1000,"d":"₪ 1,000.00"}},{"$f":"U328+V328","v":{"v":1000,"d":"₪ 1,000.00"}},{"$f":"T328-U328","v":{"v":100000,"d":"₪ 100,000.00"}}]
[{"$nulls":18},3,{"$f":"X328","v":{"v":100000,"d":"₪ 100,000.00"}},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},4,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},5,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},6,{"$f":"X331","v":{"v":100000,"d":"₪ 100,000.00"}},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"$f":"T332-U332","v":{"v":100000,"d":"₪ 100,000.00"}}]
[{"$nulls":18},7,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},8,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},9,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},10,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},11,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},12,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},13,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},14,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},15,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},16,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},17,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},18,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},19,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},20,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},21,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},22,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},23,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},24,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},25,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},26,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},27,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},28,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},29,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},30,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},31,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},32,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},33,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":8},"ערך נקוב",{"v":1000,"d":"1,000"},{"$nulls":8},34,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":8},"מרווח בין קופונים",2,{"$nulls":8},35,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":8},"מספר קופונים",{"$f":"7*2","v":14},{"$nulls":8},36,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":8},"מחיר בהנפקה",945.39,{"$nulls":8},37,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":8},"תשואה שנתית לפדיון",{"v":0.07122,"d":"7.12%"},{"$nulls":8},38,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":8},"תשואה חצי שנתית לפדיון",{"$f":"(1+J364)^(1/2)-1","v":{"v":0.0349975845382442,"d":"3.50%"}},{"$nulls":8},39,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},40,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":8},"נחשב את גובה הקופון",{"$f":"PMT(J365,J362,-J363,J360)","v":{"v":29.996988071436355,"d":"30 "}},{"$nulls":8},41,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":8},"נחשב את הריבית הנקובה על האג\"ח",{"$f":"J367/J360","v":{"v":0.029996988071436356,"d":"3.00%"}},{"$nulls":8},42,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":9},{"$f":"2*J368","v":{"v":0.05999397614287271,"d":"6.00%"}},{"$nulls":8},43,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},44,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},45,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},46,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},47,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},48,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},49,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},50,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},51,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},52,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},53,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},54,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},55,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},56,{"$f":"X381","v":{"v":100000,"d":"₪ 100,000.00"}},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"$f":"T382-U382","v":{"v":100000,"d":"₪ 100,000.00"}}]
[{"$nulls":18},57,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},58,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},59,{"v":100000,"d":"₪ 100,000.00"},{"v":0,"d":"₪ 0.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":1000,"d":"₪ 1,000.00"},{"v":100000,"d":"₪ 100,000.00"}]
[{"$nulls":18},60,{"v":100000,"d":"₪ 100,000.00"},{"$f":"T386","v":{"v":100000,"d":"₪ 100,000.00"}},{"v":1000,"d":"₪ 1,000.00"},{"v":101000,"d":"₪ 101,000.00"},{"v":0,"d":"₪ 0.00"}]
[]
[{"$nulls":21},190]
[{"$nulls":21},100]
[{"$nulls":22},{"$f":"W386*V388/V389","v":{"v":191900,"d":"₪ 191,900.00"}}]
{"$rows_empty":7}
[{"$nulls":8},"מגבלת תקציב",{"v":120000,"d":"120,000"}]
[]
[{"$nulls":8},"הפרוייקטים","השקעה","NPV","PI"]
[{"$nulls":8},"A",{"v":50000,"d":"50,000"},{"v":18661,"d":"18,661"},0.37]
[{"$nulls":8},"B",{"v":6000,"d":"6,000"},{"$f":"L411","v":{"v":2582,"d":"2,582"}},0.43]
[{"$nulls":8},"C",{"v":30000,"d":"30,000"},{"v":4170,"d":"4,170"},0.14]
[{"$nulls":8},"D",{"v":14000,"d":"14,000"},{"$f":"L414","v":{"v":3165,"d":"3,165"}},0.22]
[{"$nulls":8},"E",{"v":40000,"d":"40,000"},{"v":4718,"d":"4,718"},0.12]
[{"$nulls":8},"F",{"v":30000,"d":"30,000"},{"$f":"L413","v":{"v":7053,"d":"7,053"}},0.23]
[]
[]
[]
[{"$nulls":8},"הפרוייקטים הנבחרים לפי סדר יורד של PI","השקעה","PI","ענ\"נ","יתרת תקציב"]
[{"$nulls":8},"B",{"v":6000,"d":"6,000"},0.43,{"v":2582,"d":"2,582"},{"$f":"J398-J411","v":{"v":114000,"d":"114,000"}}]
[{"$nulls":8},"A",{"v":50000,"d":"50,000"},0.37,{"$f":"K401","v":{"v":18661,"d":"18,661"}},{"$f":"M411-J412","v":{"v":64000,"d":"64,000"}}]
[{"$nulls":8},"F",{"v":30000,"d":"30,000"},0.23,{"v":7053,"d":"7,053"},{"$f":"M412-J413","v":{"v":34000,"d":"34,000"}}]
[{"$nulls":8},"D",{"v":14000,"d":"14,000"},0.22,{"v":3165,"d":"3,165"},{"v":20000,"d":"20,000"}]
[{"$nulls":8},"C",{"v":20000,"d":"20,000"},0.14,{"$f":"J415/J403*K403","v":{"v":2780,"d":"2,780"}},0]
[{"$nulls":11},{"$f":"SUM(L411:L415)","v":{"v":34241,"d":"34,241"}}]
{"$rows_empty":19}
[{"$nulls":8},"החזר חודשי",{"v":6000,"d":"6,000"}]
[{"$nulls":8},"מספר שנים",30]
[{"$nulls":8},"מספר חודשים",{"$f":"J437*12","v":360}]
[{"$nulls":8},"type",1]
[{"$nulls":8},"ריבית אפקטיבית שנתית",{"v":0.07442,"d":"7.44%"}]
[{"$nulls":8},"ריבית חודשית",{"$f":"(1+J440)^(1/12)-1","v":{"v":0.005999674807535937,"d":"0.60%"}}]
[]
[{"$nulls":9},{"$f":"PV(J441,J438,J436,,J439)","v":{"v":-889266.0300742063,"d":"₪ -889,266.03"}}]
{"$rows_empty":33}
[{"$nulls":8},"הריבית הריאלית לשנה היא 2%.",{"v":0.02,"d":"2%"}]
[{"$nulls":8},"מכאן שהריבית הריאלית ל- 3 שנים היא:",3]
[]
[{"$nulls":9},{"$f":"(1+J477)^J478-1","v":{"v":0.06120799999999993,"d":"6.12%"}}]
{"$rows_empty":34}
[{"$nulls":8},"שפיצר"]
[{"$nulls":8},"נתונים:"]
[{"$nulls":8},"הלוואה",{"v":200000,"d":"200,000"},"PV",null,{"v":0.09,"d":"9.00%"}]
[{"$nulls":8},"חודשים",{"$f":"4*12","v":48},"n",null,12]
[{"$nulls":8},"ריבית",{"$f":"M517/M518","v":{"v":0.0075,"d":"0.75%"}},"r"]
[{"$nulls":9},{"$f":"PMT(J519,J518,-J517,,)","v":{"v":4977.008474786842,"d":"₪ 4,977.01"}},"PMT"]
[{"$nulls":8},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":8},1,{"$f":"J517","v":{"v":200000,"d":"₪ 200,000.00"}},{"$f":"M522-L522","v":{"v":3477.0084747868423,"d":"₪ 3,477.01"}},{"$f":"$J$519*J522","v":{"v":1500,"d":"₪ 1,500.00"}},{"$f":"$J$520","v":{"v":4977.008474786842,"d":"₪ 4,977.01"}},{"$f":"J522-K522","v":{"v":196522.99152521315,"d":"₪ 196,522.99"}}]
[{"$nulls":8},2,{"$f":"N522","v":{"v":196522.99152521315,"d":"₪ 196,522.99"}},{"$f":"M523-L523","v":{"v":3503.086038347744,"d":"₪ 3,503.09"}},{"$f":"$J$519*J523","v":{"v":1473.9224364390986,"d":"₪ 1,473.92"}},{"$f":"$J$520","v":{"v":4977.008474786842,"d":"₪ 4,977.01"}},{"$f":"J523-K523","v":{"v":193019.9054868654,"d":"₪ 193,019.91"}}]
[{"$nulls":8},3,{"$f":"N523","v":{"v":193019.9054868654,"d":"₪ 193,019.91"}},{"v":3529.3591836353517,"d":"₪ 3,529.36"},{"v":1447.6492911514904,"d":"₪ 1,447.65"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":189490.54630323005,"d":"₪ 189,490.55"}]
[{"$nulls":8},4,{"v":189490.54630323005,"d":"₪ 189,490.55"},{"v":3555.8293775126167,"d":"₪ 3,555.83"},{"v":1421.1790972742253,"d":"₪ 1,421.18"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":185934.71692571742,"d":"₪ 185,934.72"}]
[{"$nulls":8},5,{"v":185934.71692571742,"d":"₪ 185,934.72"},{"v":3582.4980978439617,"d":"₪ 3,582.50"},{"v":1394.5103769428806,"d":"₪ 1,394.51"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":182352.21882787347,"d":"₪ 182,352.22"}]
[{"$nulls":8},6,{"v":182352.21882787347,"d":"₪ 182,352.22"},{"v":3609.366833577791,"d":"₪ 3,609.37"},{"v":1367.641641209051,"d":"₪ 1,367.64"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":178742.85199429566,"d":"₪ 178,742.85"}]
[{"$nulls":8},7,{"v":178742.85199429566,"d":"₪ 178,742.85"},{"v":3636.437084829625,"d":"₪ 3,636.44"},{"v":1340.5713899572174,"d":"₪ 1,340.57"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":175106.41490946602,"d":"₪ 175,106.41"}]
[{"$nulls":8},8,{"v":175106.41490946602,"d":"₪ 175,106.41"},{"v":3663.710362965847,"d":"₪ 3,663.71"},{"v":1313.2981118209952,"d":"₪ 1,313.30"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":171442.70454650017,"d":"₪ 171,442.70"}]
[{"$nulls":8},9,{"v":171442.70454650017,"d":"₪ 171,442.70"},{"v":3691.188190688091,"d":"₪ 3,691.19"},{"v":1285.8202840987512,"d":"₪ 1,285.82"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":167751.51635581208,"d":"₪ 167,751.52"}]
[{"$nulls":8},10,{"v":167751.51635581208,"d":"₪ 167,751.52"},{"v":3718.872102118252,"d":"₪ 3,718.87"},{"v":1258.1363726685906,"d":"₪ 1,258.14"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":164032.64425369384,"d":"₪ 164,032.64"}]
[{"$nulls":8},11,{"v":164032.64425369384,"d":"₪ 164,032.64"},{"v":3746.763642884139,"d":"₪ 3,746.76"},{"v":1230.2448319027037,"d":"₪ 1,230.24"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":160285.8806108097,"d":"₪ 160,285.88"}]
[{"$nulls":8},12,{"v":160285.8806108097,"d":"₪ 160,285.88"},{"v":3774.86437020577,"d":"₪ 3,774.86"},{"v":1202.1441045810727,"d":"₪ 1,202.14"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":156511.01624060393,"d":"₪ 156,511.02"}]
[{"$nulls":8},13,{"v":156511.01624060393,"d":"₪ 156,511.02"},{"v":3803.175852982313,"d":"₪ 3,803.18"},{"v":1173.8326218045295,"d":"₪ 1,173.83"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":152707.8403876216,"d":"₪ 152,707.84"}]
[{"$nulls":8},14,{"v":152707.8403876216,"d":"₪ 152,707.84"},{"v":3831.69967187968,"d":"₪ 3,831.70"},{"v":1145.308802907162,"d":"₪ 1,145.31"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":148876.14071574193,"d":"₪ 148,876.14"}]
[{"$nulls":8},15,{"v":148876.14071574193,"d":"₪ 148,876.14"},{"v":3860.4374194187776,"d":"₪ 3,860.44"},{"v":1116.5710553680644,"d":"₪ 1,116.57"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":145015.70329632316,"d":"₪ 145,015.70"}]
[{"$nulls":8},16,{"v":145015.70329632316,"d":"₪ 145,015.70"},{"v":3889.3907000644185,"d":"₪ 3,889.39"},{"v":1087.6177747224237,"d":"₪ 1,087.62"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":141126.31259625874,"d":"₪ 141,126.31"}]
[{"$nulls":8},17,{"v":141126.31259625874,"d":"₪ 141,126.31"},{"v":3918.5611303149017,"d":"₪ 3,918.56"},{"v":1058.4473444719406,"d":"₪ 1,058.45"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":137207.75146594385,"d":"₪ 137,207.75"}]
[{"$nulls":8},18,{"v":137207.75146594385,"d":"₪ 137,207.75"},{"v":3947.950338792263,"d":"₪ 3,947.95"},{"v":1029.0581359945788,"d":"₪ 1,029.06"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":133259.8011271516,"d":"₪ 133,259.80"}]
[{"$nulls":8},19,{"v":133259.8011271516,"d":"₪ 133,259.80"},{"v":3977.5599663332055,"d":"₪ 3,977.56"},{"v":999.4485084536368,"d":"₪ 999.45"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":129282.24116081838,"d":"₪ 129,282.24"}]
[{"$nulls":8},20,{"v":129282.24116081838,"d":"₪ 129,282.24"},{"v":4007.3916660807045,"d":"₪ 4,007.39"},{"v":969.6168087061378,"d":"₪ 969.62"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":125274.84949473767,"d":"₪ 125,274.85"}]
[{"$nulls":8},21,{"v":125274.84949473767,"d":"₪ 125,274.85"},{"v":4037.44710357631,"d":"₪ 4,037.45"},{"v":939.5613712105326,"d":"₪ 939.56"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":121237.40239116136,"d":"₪ 121,237.40"}]
[{"$nulls":8},22,{"v":121237.40239116136,"d":"₪ 121,237.40"},{"v":4067.727956853132,"d":"₪ 4,067.73"},{"v":909.2805179337101,"d":"₪ 909.28"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":117169.67443430822,"d":"₪ 117,169.67"}]
[{"$nulls":8},23,{"v":117169.67443430822,"d":"₪ 117,169.67"},{"v":4098.235916529531,"d":"₪ 4,098.24"},{"v":878.7725582573116,"d":"₪ 878.77"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":113071.43851777869,"d":"₪ 113,071.44"}]
[{"$nulls":8},24,{"v":113071.43851777869,"d":"₪ 113,071.44"},{"v":4128.972685903502,"d":"₪ 4,128.97"},{"v":848.0357888833402,"d":"₪ 848.04"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":108942.46583187519,"d":"₪ 108,942.47"}]
[{"$nulls":8},25,{"v":108942.46583187519,"d":"₪ 108,942.47"},{"v":4159.939981047778,"d":"₪ 4,159.94"},{"v":817.0684937390639,"d":"₪ 817.07"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":104782.52585082741,"d":"₪ 104,782.53"}]
[{"$nulls":8},26,{"v":104782.52585082741,"d":"₪ 104,782.53"},{"v":4191.139530905637,"d":"₪ 4,191.14"},{"v":785.8689438812056,"d":"₪ 785.87"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":100591.38631992177,"d":"₪ 100,591.39"}]
[{"$nulls":8},27,{"v":100591.38631992177,"d":"₪ 100,591.39"},{"v":4222.573077387429,"d":"₪ 4,222.57"},{"v":754.4353973994133,"d":"₪ 754.44"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":96368.81324253435,"d":"₪ 96,368.81"}]
[{"$nulls":8},28,{"v":96368.81324253435,"d":"₪ 96,368.81"},{"v":4254.242375467835,"d":"₪ 4,254.24"},{"v":722.7660993190076,"d":"₪ 722.77"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":92114.57086706652,"d":"₪ 92,114.57"}]
[{"$nulls":8},29,{"v":92114.57086706652,"d":"₪ 92,114.57"},{"v":4286.1491932838435,"d":"₪ 4,286.15"},{"v":690.8592815029989,"d":"₪ 690.86"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":87828.42167378268,"d":"₪ 87,828.42"}]
[{"$nulls":8},30,{"v":87828.42167378268,"d":"₪ 87,828.42"},{"v":4318.295312233472,"d":"₪ 4,318.30"},{"v":658.7131625533701,"d":"₪ 658.71"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":83510.1263615492,"d":"₪ 83,510.13"}]
[{"$nulls":8},31,{"v":83510.1263615492,"d":"₪ 83,510.13"},{"v":4350.682527075223,"d":"₪ 4,350.68"},{"v":626.325947711619,"d":"₪ 626.33"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":79159.44383447399,"d":"₪ 79,159.44"}]
[{"$nulls":8},32,{"v":79159.44383447399,"d":"₪ 79,159.44"},{"v":4383.312646028287,"d":"₪ 4,383.31"},{"v":593.6958287585549,"d":"₪ 593.70"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":74776.1311884457,"d":"₪ 74,776.13"}]
[{"$nulls":8},33,{"v":74776.1311884457,"d":"₪ 74,776.13"},{"v":4416.1874908735,"d":"₪ 4,416.19"},{"v":560.8209839133427,"d":"₪ 560.82"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":70359.94369757219,"d":"₪ 70,359.94"}]
[{"$nulls":8},34,{"v":70359.94369757219,"d":"₪ 70,359.94"},{"v":4449.308897055051,"d":"₪ 4,449.31"},{"v":527.6995777317915,"d":"₪ 527.70"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":65910.63480051715,"d":"₪ 65,910.63"}]
[{"$nulls":8},35,{"v":65910.63480051715,"d":"₪ 65,910.63"},{"v":4482.678713782963,"d":"₪ 4,482.68"},{"v":494.32976100387856,"d":"₪ 494.33"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":61427.95608673418,"d":"₪ 61,427.96"}]
[{"$nulls":8},36,{"v":61427.95608673418,"d":"₪ 61,427.96"},{"v":4516.298804136336,"d":"₪ 4,516.30"},{"v":460.7096706505063,"d":"₪ 460.71"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":56911.657282597844,"d":"₪ 56,911.66"}]
[{"$nulls":8},37,{"v":56911.657282597844,"d":"₪ 56,911.66"},{"v":4550.171045167359,"d":"₪ 4,550.17"},{"v":426.8374296194838,"d":"₪ 426.84"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":52361.48623743049,"d":"₪ 52,361.49"}]
[{"$nulls":8},38,{"v":52361.48623743049,"d":"₪ 52,361.49"},{"v":4584.297328006113,"d":"₪ 4,584.30"},{"v":392.71114678072865,"d":"₪ 392.71"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":47777.188909424374,"d":"₪ 47,777.19"}]
[{"$nulls":8},39,{"v":47777.188909424374,"d":"₪ 47,777.19"},{"v":4618.679557966159,"d":"₪ 4,618.68"},{"v":358.3289168206828,"d":"₪ 358.33"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":43158.50935145821,"d":"₪ 43,158.51"}]
[{"$nulls":8},40,{"v":43158.50935145821,"d":"₪ 43,158.51"},{"v":4653.319654650906,"d":"₪ 4,653.32"},{"v":323.68882013593657,"d":"₪ 323.69"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":38505.189696807305,"d":"₪ 38,505.19"}]
[{"$nulls":8},41,{"v":38505.189696807305,"d":"₪ 38,505.19"},{"v":4688.2195520607875,"d":"₪ 4,688.22"},{"v":288.78892272605475,"d":"₪ 288.79"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":33816.97014474652,"d":"₪ 33,816.97"}]
[{"$nulls":8},42,{"v":33816.97014474652,"d":"₪ 33,816.97"},{"v":4723.381198701243,"d":"₪ 4,723.38"},{"v":253.62727608559888,"d":"₪ 253.63"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":29093.588946045274,"d":"₪ 29,093.59"}]
[{"$nulls":8},43,{"v":29093.588946045274,"d":"₪ 29,093.59"},{"v":4758.806557691502,"d":"₪ 4,758.81"},{"v":218.20191709533955,"d":"₪ 218.20"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":24334.78238835377,"d":"₪ 24,334.78"}]
[{"$nulls":8},44,{"v":24334.78238835377,"d":"₪ 24,334.78"},{"v":4794.497606874189,"d":"₪ 4,794.50"},{"v":182.51086791265328,"d":"₪ 182.51"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":19540.284781479582,"d":"₪ 19,540.28"}]
[{"$nulls":8},45,{"v":19540.284781479582,"d":"₪ 19,540.28"},{"v":4830.4563389257455,"d":"₪ 4,830.46"},{"v":146.55213586109687,"d":"₪ 146.55"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":14709.828442553837,"d":"₪ 14,709.83"}]
[{"$nulls":8},46,{"v":14709.828442553837,"d":"₪ 14,709.83"},{"v":4866.684761467688,"d":"₪ 4,866.68"},{"v":110.32371331915377,"d":"₪ 110.32"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":9843.143681086149,"d":"₪ 9,843.14"}]
[{"$nulls":8},47,{"v":9843.143681086149,"d":"₪ 9,843.14"},{"v":4903.184897178696,"d":"₪ 4,903.18"},{"v":73.82357760814611,"d":"₪ 73.82"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":4939.958783907453,"d":"₪ 4,939.96"}]
[{"$nulls":8},48,{"v":4939.958783907453,"d":"₪ 4,939.96"},{"v":4939.958783907537,"d":"₪ 4,939.96"},{"v":37.04969087930589,"d":"₪ 37.05"},{"v":4977.008474786842,"d":"₪ 4,977.01"},{"v":-8.36735125631094e-11,"d":"₪ -0.00"}]

{"sheet":"פתרון שאלה פתוחה","index":1,"n_rows":61,"n_cols":18,"rows_kept":61}
{"$rows_empty":12}
[{"$nulls":14},"פרויקט א' לאחר התיקון"]
[{"$nulls":17},{"v":0.1,"d":"10%"}]
[{"$nulls":14},-26.5,"השקעה"]
[{"$nulls":14},4,"תקבול 1"]
[{"$nulls":14},4,"תקבול 2"]
[{"$nulls":14},4,"תקבול 3"]
[{"$nulls":14},4,"תקבול 4"]
[{"$nulls":14},4,"תקבול 5"]
[{"$nulls":14},4,"תקבול 6"]
[{"$nulls":14},4,"תקבול 7"]
[{"$nulls":14},4,"תקבול 8"]
[{"$nulls":14},3,"תקבול 9"]
[{"$nulls":14},3,"תקבול 10"]
[{"$nulls":14},3,"תקבול 11"]
[{"$nulls":14},2.5,"תקבול 12"]
[{"$nulls":14},{"$f":"NPV(R14,O16:O27)-26.5","v":-0.8833137422632298},"NPV"]
[{"$nulls":14},{"$f":"IRR(O15:O27)","v":{"v":0.09270154284594523,"d":"9.27%"}},"IRR"]
{"$rows_empty":13}
[{"$nulls":3},"שפיצר",{"$nulls":3},".ד",{"$f":"I52+1500000","v":{"v":23898155.815978296,"d":"₪ 23,898,155.82"}}]
[{"$nulls":3},"נתונים:"]
[{"$nulls":3},"הלוואה",{"v":26500000,"d":"26,500,000"},"PV",null,{"v":0.1,"d":"10.00%"}]
[{"$nulls":3},"חודשים",12,"n"]
[{"$nulls":3},"ריבית",{"$f":"H45","v":{"v":0.1,"d":"10.00%"}},"r"]
[{"$nulls":4},{"$f":"PMT(E47,E46,-E45,,)","v":{"v":3889227.8501576143,"d":"₪ 3,889,227.85"}},"PMT"]
[{"$nulls":3},"מספר תקבול","יתרת הקרן בתחילת תקופה","תשלום ע\"ח קרן","תשלום ע\"ח ריבית","סך הכל תשלום","יתרת הקרן בסוף התקופה"]
[{"$nulls":3},1,{"$f":"E45","v":{"v":26500000,"d":"₪ 26,500,000.00"}},{"$f":"H50-G50","v":{"v":1239227.8501576143,"d":"₪ 1,239,227.85"}},{"$f":"$E$47*E50","v":{"v":2650000,"d":"₪ 2,650,000.00"}},{"$f":"$E$48","v":{"v":3889227.8501576143,"d":"₪ 3,889,227.85"}},{"$f":"E50-F50","v":{"v":25260772.149842385,"d":"₪ 25,260,772.15"}}]
[{"$nulls":3},2,{"$f":"I50","v":{"v":25260772.149842385,"d":"₪ 25,260,772.15"}},{"$f":"H51-G51","v":{"v":1363150.6351733757,"d":"₪ 1,363,150.64"}},{"$f":"$E$47*E51","v":{"v":2526077.2149842386,"d":"₪ 2,526,077.21"}},{"$f":"$E$48","v":{"v":3889227.8501576143,"d":"₪ 3,889,227.85"}},{"$f":"E51-F51","v":{"v":23897621.51466901,"d":"₪ 23,897,621.51"}}]
[{"$nulls":3},3,{"$f":"I51","v":{"v":23897621.51466901,"d":"₪ 23,897,621.51"}},{"v":1499465.6986907134,"d":"₪ 1,499,465.70"},{"v":2389762.151466901,"d":"₪ 2,389,762.15"},{"v":3889227.8501576143,"d":"₪ 3,889,227.85"},{"v":22398155.815978296,"d":"₪ 22,398,155.82"}]
[{"$nulls":3},4,{"v":22398155.815978296,"d":"₪ 22,398,155.82"},{"v":1649412.2685597846,"d":"₪ 1,649,412.27"},{"v":2239815.5815978297,"d":"₪ 2,239,815.58"},{"v":3889227.8501576143,"d":"₪ 3,889,227.85"},{"v":20748743.547418512,"d":"₪ 20,748,743.55"}]
[{"$nulls":3},5,{"v":20748743.547418512,"d":"₪ 20,748,743.55"},{"v":1814353.495415763,"d":"₪ 1,814,353.50"},{"v":2074874.3547418513,"d":"₪ 2,074,874.35"},{"v":3889227.8501576143,"d":"₪ 3,889,227.85"},{"v":18934390.05200275,"d":"₪ 18,934,390.05"}]
[{"$nulls":3},6,{"v":18934390.05200275,"d":"₪ 18,934,390.05"},{"v":1995788.844957339,"d":"₪ 1,995,788.84"},{"v":1893439.0052002752,"d":"₪ 1,893,439.01"},{"v":3889227.8501576143,"d":"₪ 3,889,227.85"},{"v":16938601.20704541,"d":"₪ 16,938,601.21"}]
[{"$nulls":3},7,{"v":16938601.20704541,"d":"₪ 16,938,601.21"},{"v":2195367.7294530733,"d":"₪ 2,195,367.73"},{"v":1693860.120704541,"d":"₪ 1,693,860.12"},{"v":3889227.8501576143,"d":"₪ 3,889,227.85"},{"v":14743233.477592336,"d":"₪ 14,743,233.48"}]
[{"$nulls":3},8,{"v":14743233.477592336,"d":"₪ 14,743,233.48"},{"v":2414904.5023983805,"d":"₪ 2,414,904.50"},{"v":1474323.3477592338,"d":"₪ 1,474,323.35"},{"v":3889227.8501576143,"d":"₪ 3,889,227.85"},{"v":12328328.975193955,"d":"₪ 12,328,328.98"}]
[{"$nulls":3},9,{"v":12328328.975193955,"d":"₪ 12,328,328.98"},{"v":2656394.952638219,"d":"₪ 2,656,394.95"},{"v":1232832.8975193955,"d":"₪ 1,232,832.90"},{"v":3889227.8501576143,"d":"₪ 3,889,227.85"},{"v":9671934.022555735,"d":"₪ 9,671,934.02"}]
[{"$nulls":3},10,{"v":9671934.022555735,"d":"₪ 9,671,934.02"},{"v":2922034.4479020406,"d":"₪ 2,922,034.45"},{"v":967193.4022555735,"d":"₪ 967,193.40"},{"v":3889227.8501576143,"d":"₪ 3,889,227.85"},{"v":6749899.574653694,"d":"₪ 6,749,899.57"}]
[{"$nulls":3},11,{"$f":"I59","v":{"v":6749899.574653694,"d":"₪ 6,749,899.57"}},{"$f":"H60-G60","v":{"v":3214237.8926922446,"d":"₪ 3,214,237.89"}},{"v":674989.9574653695,"d":"₪ 674,989.96"},{"v":3889227.8501576143,"d":"₪ 3,889,227.85"},{"$f":"E60-F60","v":{"v":3535661.68196145,"d":"₪ 3,535,661.68"}}]
[{"$nulls":3},12,{"v":3535661.68196145,"d":"₪ 3,535,661.68"},{"v":3535661.6819614694,"d":"₪ 3,535,661.68"},{"v":353566.168196145,"d":"₪ 353,566.17"},{"v":3889227.8501576143,"d":"₪ 3,889,227.85"},{"v":-1.9557774066925049E-8,"d":"₪ -0.00"}]