{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["תרגילי כיתה 1-6","דוגמאות מרצה שאלות 7-11","תרגול עצמי שאלות 12-15","פתרון תרגיל בית שאלות 16-18"],"not_rendered":{"charts":3,"external_links":1},"read":"whole","date_system":"1900"}

{"sheet":"תרגילי כיתה 1-6","index":0,"n_rows":285,"n_cols":20,"rows_kept":285,"merged":[[61,11,61,17],[109,11,113,15],[114,11,114,13],[218,11,218,13],[254,11,254,13],[273,11,279,20],[284,11,289,17]]}
[]
[]
[]
[{"$nulls":8},"שאלה 1",null,null,0,1,2]
[{"$nulls":11},"150-",80,130,"A",{"$f":"IRR(Q5:Q7)","v":{"v":0.23505593642226352,"d":"23.51%"}},{"v":-150,"d":"-₪ 150.00"},-210]
[{"$nulls":11},"210-",140,90,"B",{"$f":"IRR(R5:R7)","v":{"v":0.06796422002578617,"d":"6.80%"}},80,140]
[{"$nulls":16},130,90]
[{"$nulls":11},"א. חשב את הערך הנוכחי לשני הפרוייקטים בהנחה ומחיר הההון 5%"]
[{"$nulls":11},"ב. מה שת\"פ הפרוייקטים?"]
[{"$nulls":11},"ג. איזה פרוייקט עדיף לפי כל קריטריון?"]
[]
[{"$nulls":12},"NPVB","NPVA"]
[{"$nulls":12},{"$f":"NPV(O13,$M$6:$N$6)-210","v":{"v":20,"d":"₪ 20.00"}},{"$f":"NPV(O13,$M$5:$N$5)-150","v":{"v":60,"d":"₪ 60.00"}},{"v":0,"d":"0.00%"}]
[{"$nulls":12},{"$f":"NPV(O14,$M$6:$N$6)-210","v":{"v":16.840505832761494,"d":"₪ 16.84"}},{"$f":"NPV(O14,$M$5:$N$5)-150","v":{"v":56.64640721497892,"d":"₪ 56.65"}},{"v":0.01,"d":"1.00%"}]
[{"$nulls":12},{"v":13.760092272202996,"d":"₪ 13.76"},{"v":53.383314109957695,"d":"₪ 53.38"},{"v":0.02,"d":"2.00%"}]
[{"$nulls":12},{"v":10.75596191912527,"d":"₪ 10.76"},{"v":50.207371100009425,"d":"₪ 50.21"},{"v":0.03,"d":"3.00%"}]
[{"$nulls":12},{"v":7.825443786982248,"d":"₪ 7.83"},{"v":47.11538461538461,"d":"₪ 47.12"},{"v":0.04,"d":"4.00%"}]
[{"$nulls":12},{"v":4.965986394557831,"d":"₪ 4.97"},{"v":44.10430839002265,"d":"₪ 44.10"},{"v":0.05,"d":"5.00%"}]
[{"$nulls":12},{"v":2.1751512993947983,"d":"₪ 2.18"},{"v":41.17123531505871,"d":"₪ 41.17"},{"v":0.06,"d":"6.00%"}]
[{"$nulls":12},{"v":-0.5493929600838783,"d":"₪ -0.55"},{"v":38.313389815704426,"d":"₪ 38.31"},{"v":0.07,"d":"7.00%"}]
[{"$nulls":12},{"v":-3.2098765432099015,"d":"₪ -3.21"},{"v":35.528120713305896,"d":"₪ 35.53"},{"v":0.08,"d":"8.00%"}]
[{"$nulls":12},{"v":-5.808433633532559,"d":"₪ -5.81"},{"v":32.81289453749682,"d":"₪ 32.81"},{"v":0.09,"d":"9.00%"}]
[{"$nulls":12},{"v":-8.347107438016536,"d":"₪ -8.35"},{"v":30.16528925619835,"d":"₪ 30.17"},{"v":0.1,"d":"10.00%"}]
[{"$nulls":12},{"v":-10.827854881908934,"d":"₪ -10.83"},{"v":27.582988393799184,"d":"₪ 27.58"},{"v":0.11,"d":"11.00%"}]
[{"$nulls":12},{"v":-13.252551020408191,"d":"₪ -13.25"},{"v":25.06377551020404,"d":"₪ 25.06"},{"v":0.12,"d":"12.00%"}]
[{"$nulls":12},{"v":-15.62299318662383,"d":"₪ -15.62"},{"v":22.605529015584636,"d":"₪ 22.61"},{"v":0.13,"d":"13.00%"}]
[{"$nulls":12},{"v":-17.940904893813524,"d":"₪ -17.94"},{"v":20.20621729763002,"d":"₪ 20.21"},{"v":0.14,"d":"14.00%"}]
[{"$nulls":12},{"v":-20.207939508506627,"d":"₪ -20.21"},{"v":17.863894139886582,"d":"₪ 17.86"},{"v":0.15,"d":"15.00%"}]
[{"$nulls":12},{"v":-22.425683709869162,"d":"₪ -22.43"},{"v":15.57669441141502,"d":"₪ 15.58"},{"v":0.16,"d":"16.00%"}]
[{"$nulls":12},{"v":-24.59566074950689,"d":"₪ -24.60"},{"v":13.34283000949668,"d":"₪ 13.34"},{"v":0.17,"d":"17.00%"}]
[{"$nulls":12},{"v":-26.719333524849162,"d":"₪ -26.72"},{"v":11.1605860384947,"d":"₪ 11.16"},{"v":0.18,"d":"18.00%"}]
[{"$nulls":12},{"v":-28.79810747828543,"d":"₪ -28.80"},{"v":9.028317209236661,"d":"₪ 9.03"},{"v":0.19,"d":"19.00%"}]
[{"$nulls":12},{"v":-30.833333333333314,"d":"₪ -30.83"},{"v":6.944444444444457,"d":"₪ 6.94"},{"v":0.2,"d":"20.00%"}]
[{"$nulls":12},{"v":-32.826309678300674,"d":"₪ -32.83"},{"v":4.907451676798047,"d":"₪ 4.91"},{"v":0.21,"d":"21.00%"}]
[{"$nulls":12},{"v":-34.778285407148616,"d":"₪ -34.78"},{"v":2.9158828271970094,"d":"₪ 2.92"},{"v":0.22,"d":"22.00%"}]
[{"$nulls":12},{"v":-36.69046202657148,"d":"₪ -36.69"},{"v":0.968338951682199,"d":"₪ 0.97"},{"v":0.23,"d":"23.00%"}]
[{"$nulls":12},{"v":-38.5639958376691,"d":"₪ -38.56"},{"v":-0.9365244536940622,"d":"₪ -0.94"},{"v":0.24,"d":"24.00%"}]
[{"$nulls":12},{"v":-40.400000000000006,"d":"₪ -40.40"},{"v":-2.8000000000000114,"d":"₪ -2.80"},{"v":0.25,"d":"25.00%"}]
[{"$nulls":12},{"v":-42.199546485260754,"d":"₪ -42.20"},{"v":-4.6233308138070015,"d":"₪ -4.62"},{"v":0.26,"d":"26.00%"}]
[{"$nulls":12},{"v":-43.96366792733585,"d":"₪ -43.96"},{"v":-6.40771281542564,"d":"₪ -6.41"},{"v":0.27,"d":"27.00%"}]
[{"$nulls":12},{"v":-45.693359375,"d":"₪ -45.69"},{"v":-8.154296875,"d":"₪ -8.15"},{"v":0.28,"d":"28.00%"}]
[{"$nulls":12},{"v":-47.38957995312782,"d":"₪ -47.39"},{"v":-9.864190853915034,"d":"₪ -9.86"},{"v":0.29,"d":"29.00%"}]
[{"$nulls":12},{"v":-49.05325443786984,"d":"₪ -49.05"},{"v":-11.538461538461547,"d":"₪ -11.54"},{"v":0.3,"d":"30.00%"}]
[{"$nulls":12},{"v":-50.68527475088865,"d":"₪ -50.69"},{"v":-13.178136472233547,"d":"₪ -13.18"},{"v":0.31,"d":"31.00%"}]
[{"$nulls":12},{"v":-52.286501377410474,"d":"₪ -52.29"},{"v":-14.784205693296599,"d":"₪ -14.78"},{"v":0.32,"d":"32.00%"}]
[{"$nulls":12},{"v":-53.857764712533225,"d":"₪ -53.86"},{"v":-16.357623381762693,"d":"₪ -16.36"},{"v":0.33,"d":"33.00%"}]
[{"$nulls":12},{"v":-55.39986633994209,"d":"₪ -55.40"},{"v":-17.89930942303411,"d":"₪ -17.90"},{"v":0.34,"d":"34.00%"}]
[{"$nulls":12},{"v":-56.9135802469136,"d":"₪ -56.91"},{"v":-19.410150891632384,"d":"₪ -19.41"},{"v":0.35,"d":"35.00%"}]
[{"$nulls":12},{"v":-58.399653979238735,"d":"₪ -58.40"},{"v":-20.8910034602076,"d":"₪ -20.89"},{"v":0.36,"d":"36.00%"}]
[{"$nulls":12},{"v":-59.85880973946402,"d":"₪ -59.86"},{"v":-22.342692738025477,"d":"₪ -22.34"},{"v":0.37,"d":"37.00%"}]
[{"$nulls":12},{"v":-61.291745431631995,"d":"₪ -61.29"},{"v":-23.766015542953156,"d":"₪ -23.77"},{"v":0.38,"d":"38.00%"}]
[{"$nulls":12},{"v":-62.69913565550439,"d":"₪ -62.70"},{"v":-25.161741110708576,"d":"₪ -25.16"},{"v":0.39,"d":"39.00%"}]
[{"$nulls":12},{"v":-64.08163265306123,"d":"₪ -64.08"},{"v":-26.530612244897952,"d":"₪ -26.53"},{"v":0.4,"d":"40.00%"}]
[{"$nulls":12},{"v":-65.43986720989889,"d":"₪ -65.44"},{"v":-27.873346411146315,"d":"₪ -27.87"},{"v":0.41,"d":"41.00%"}]
[{"$nulls":12},{"v":-66.7744495139853,"d":"₪ -66.77"},{"v":-29.190636778416987,"d":"₪ -29.19"},{"v":0.42,"d":"42.00%"}]
[{"$nulls":12},{"v":-68.08596997408185,"d":"₪ -68.09"},{"v":-30.48315321042594,"d":"₪ -30.48"},{"v":0.43,"d":"43.00%"}]
[{"$nulls":12},{"v":-69.375,"d":"₪ -69.38"},{"v":-31.751543209876544,"d":"₪ -31.75"},{"v":0.44,"d":"44.00%"}]
[{"$nulls":12},{"v":-70.64209274673007,"d":"₪ -70.64"},{"v":-32.996432818073714,"d":"₪ -33.00"},{"v":0.45,"d":"45.00%"}]
[{"$nulls":12},{"v":-71.88778382435729,"d":"₪ -71.89"},{"v":-34.21842747232125,"d":"₪ -34.22"},{"v":0.46,"d":"46.00%"}]
[]
[]
[{"$nulls":8},"שאלה 2",null,null,"נתונים פרויקטים מסוג A ו-B.\nהפרויקטים לתקופה של שנתיים, סופיים, ומוציאים זה את זה.\n"]
[]
[]
[{"$nulls":11},2,1,0,null,{"$f":"IRR(R67:R69)","v":{"v":0.19999999999999996,"d":"20.00%"}},{"$f":"NPV(R65,R68:R69)-200","v":20.1151449795386},{"v":0.139,"d":"13.90%"}]
[{"$nulls":11},240,40,-200,"A",{"$f":"IRR(Q67:Q69)","v":{"v":0.22956387887231045,"d":"22.96%"}},{"$f":"NPV(R65,Q68:Q69)-204","v":19.768828223701007}]
[{"$nulls":11},62.5,200,-204,"B",null,-204,-200]
[{"$nulls":16},200,40]
[{"$nulls":11}," קיבלתם הצעה מבנק \"מאגדים\" להלוואה בריבית של 13.9%, באיזה פרויקט תעדיפו לבחור?",{"$nulls":4},62.5,240]
[]
[{"$nulls":12},"NPVB","NPVA"]
[{"$nulls":12},{"$f":"NPV(O72,$Q$68:Q$69)-204","v":{"v":58.5,"d":"₪ 58.50"}},{"$f":"NPV(O72,$R$68:$R$69)-200","v":{"v":80,"d":"₪ 80.00"}},{"v":0,"d":"0.00%"}]
[{"$nulls":12},{"$f":"NPV(O73,$Q$68:Q$69)-204","v":{"v":55.288305068130626,"d":"₪ 55.29"}},{"$f":"NPV(O73,$R$68:$R$69)-200","v":{"v":74.87501225370067,"d":"₪ 74.88"}},{"v":0.01,"d":"1.00%"}]
[{"$nulls":12},{"$f":"NPV(O74,$Q$68:Q$69)-204","v":{"v":52.15148019992307,"d":"₪ 52.15"}},{"v":69.89619377162626,"d":"₪ 69.90"},{"v":0.02,"d":"2.00%"}]
[{"$nulls":12},{"$f":"NPV(O75,$Q$68:Q$69)-204","v":{"v":49.08700160241301,"d":"₪ 49.09"}},{"v":65.0579696484117,"d":"₪ 65.06"},{"v":0.03,"d":"3.00%"}]
[{"$nulls":12},{"$f":"NPV(O76,$Q$68:Q$69)-204","v":{"v":46.09245562130178,"d":"₪ 46.09"}},{"v":60.35502958579883,"d":"₪ 60.36"},{"v":0.04,"d":"4.00%"}]
[{"$nulls":12},{"$f":"NPV(O77,$Q$68:Q$69)-204","v":{"v":43.165532879818585,"d":"₪ 43.17"}},{"v":55.78231292517003,"d":"₪ 55.78"},{"v":0.05,"d":"5.00%"}]
[{"$nulls":12},{"$f":"NPV(O78,$Q$68:Q$69)-204","v":{"v":40.304022783908835,"d":"₪ 40.30"}},{"v":51.33499466002138,"d":"₪ 51.33"},{"v":0.06,"d":"6.00%"}]
[{"$nulls":12},{"$f":"NPV(O79,$Q$68:Q$69)-204","v":{"v":37.50580836754301,"d":"₪ 37.51"}},{"v":47.008472355664225,"d":"₪ 47.01"},{"v":0.07,"d":"7.00%"}]
[{"$nulls":12},{"$f":"NPV(O80,$Q$68:Q$69)-204","v":{"v":34.76886145404663,"d":"₪ 34.77"}},{"v":42.798353909464964,"d":"₪ 42.80"},{"v":0.08,"d":"8.00%"}]
[{"$nulls":12},{"$f":"NPV(O81,$Q$68:Q$69)-204","v":{"v":32.09123811127009,"d":"₪ 32.09"}},{"v":38.700446090396355,"d":"₪ 38.70"},{"v":0.09,"d":"9.00%"}]
[{"$nulls":12},{"$f":"NPV(O82,$Q$68:Q$69)-204","v":{"v":29.471074380165277,"d":"₪ 29.47"}},{"v":34.710743801652825,"d":"₪ 34.71"},{"v":0.1,"d":"10.00%"}]
[{"$nulls":12},{"$f":"NPV(O83,$Q$68:Q$69)-204","v":{"v":26.906582257933565,"d":"₪ 26.91"}},{"v":30.825420014609165,"d":"₪ 30.83"},{"v":0.11,"d":"11.00%"}]
[{"$nulls":12},{"$f":"NPV(O84,$Q$68:Q$69)-204","v":{"v":24.39604591836732,"d":"₪ 24.40"}},{"v":27.040816326530575,"d":"₪ 27.04"},{"v":0.12,"d":"12.00%"}]
[{"$nulls":12},{"$f":"NPV(O85,$Q$68:Q$69)-204","v":{"v":21.937818153340146,"d":"₪ 21.94"}},{"v":23.353434098206634,"d":"₪ 23.35"},{"v":0.13,"d":"13.00%"}]
[{"$nulls":12},{"$f":"NPV(O86,$Q$68:Q$69)-204","v":{"v":19.53031702062171,"d":"₪ 19.53"}},{"v":19.759926131117226,"d":"₪ 19.76"},{"v":0.14,"d":"14.00%"}]
[{"$nulls":12},{"$f":"NPV(O87,$Q$68:Q$69)-204","v":{"v":17.172022684310036,"d":"₪ 17.17"}},{"v":16.257088846880947,"d":"₪ 16.26"},{"v":0.15,"d":"15.00%"}]
[{"$nulls":12},{"$f":"NPV(O88,$Q$68:Q$69)-204","v":{"v":14.861474435196214,"d":"₪ 14.86"}},{"v":12.841854934601685,"d":"₪ 12.84"},{"v":0.16,"d":"16.00%"}]
[{"$nulls":12},{"$f":"NPV(O89,$Q$68:Q$69)-204","v":{"v":12.597267879319162,"d":"₪ 12.60"}},{"v":9.51128643436337,"d":"₪ 9.51"},{"v":0.17,"d":"17.00%"}]
[{"$nulls":12},{"$f":"NPV(O90,$Q$68:Q$69)-204","v":{"v":10.37805228382652,"d":"₪ 10.38"}},{"v":6.2625682275208305,"d":"₪ 6.26"},{"v":0.18,"d":"18.00%"}]
[{"$nulls":12},{"$f":"NPV(O91,$Q$68:Q$69)-204","v":{"v":8.202528070051557,"d":"₪ 8.20"}},{"v":3.0930019066450427,"d":"₪ 3.09"},{"v":0.19,"d":"19.00%"}]
[{"$nulls":12},{"$f":"NPV(O92,$Q$68:Q$69)-204","v":{"v":6.069444444444457,"d":"₪ 6.07"}},{"v":0,"d":"₪ 0.00"},{"v":0.2,"d":"20.00%"}]
[{"$nulls":12},{"$f":"NPV(O93,$Q$68:Q$69)-204","v":{"v":3.9775971586640253,"d":"₪ 3.98"}},{"v":-3.0189194727136055,"d":"₪ -3.02"},{"v":0.21,"d":"21.00%"}]
[{"$nulls":12},{"$f":"NPV(O94,$Q$68:Q$69)-204","v":{"v":1.9258263907551907,"d":"₪ 1.93"}},{"v":-5.966138134909954,"d":"₪ -5.97"},{"v":0.22,"d":"22.00%"}]
[{"$nulls":12},{"$f":"NPV(O95,$Q$68:Q$69)-204","v":{"v":-0.08698526009649754,"d":"₪ -0.09"}},{"v":-8.843942097957552,"d":"₪ -8.84"},{"v":0.23,"d":"23.00%"}]
[{"$nulls":12},{"$f":"NPV(O96,$Q$68:Q$69)-204","v":{"v":-2.0619146722164317,"d":"₪ -2.06"}},{"v":-11.654526534859514,"d":"₪ -11.65"},{"v":0.24,"d":"24.00%"}]
[{"$nulls":12},{"$f":"NPV(O97,$Q$68:Q$69)-204","v":{"v":-4,"d":"₪ -4.00"}},{"v":-14.400000000000006,"d":"₪ -14.40"},{"v":0.25,"d":"25.00%"}]
[{"$nulls":12},{"$f":"NPV(O98,$Q$68:Q$69)-204","v":{"v":-5.902242378432845,"d":"₪ -5.90"}},{"v":-17.08238851095993,"d":"₪ -17.08"},{"v":0.26,"d":"26.00%"}]
[]
[]
[]
[]
[]
[{"$nulls":11},"להלן מפורטים נתונים לגבי 3 חלופות שונות להשקעה בפרויקטים אשר אינם מוציאים זה את זה:"]
[{"$nulls":5},"שאלה 3",null,null,{"v":0.2,"d":"20.00%"},{"v":0,"d":"0.00%"},{"v":0.05,"d":"5.00%"},"IRR",0,1,2,3]
[{"$nulls":8},{"$f":"NPV(I105,N106:P106)-2000","v":{"v":-421.2962962962961,"d":"-421.30"}},{"$f":"NPV(J105,N106:P106)-2000","v":{"v":600,"d":"600.00"}},{"$f":"NPV(K105,N106:P106)-2000","v":{"v":272.32480293704793,"d":"272.32"}},{"v":0.1,"d":"10%"},"2,000-",200,200,2200,"A"]
[{"$nulls":8},{"$f":"NPV(I105,N107:P107)-1400","v":{"v":-85.18518518518499,"d":"₪ -85.19"}},{"$f":"NPV(J105,N107:P107)-1400","v":{"v":400,"d":"₪ 400.00"}},{"$f":"NPV(K105,N107:P107)-1400","v":{"v":251.65748839218236,"d":"₪ 251.66"}},{"v":0.156,"d":"15.60%"},"1400-",800,600,400,"B"]
[{"$nulls":8},{"$f":"NPV(I105,N108:P108)-4000","v":{"v":-1106.4814814814813,"d":"₪ -1,106.48"}},{"$f":"NPV(J105,N108:P108)-4000","v":{"v":1000,"d":"₪ 1,000.00"}},{"$f":"NPV(K105,N108:P108)-4000","v":{"v":319.18799265738016,"d":"₪ 319.19"}},{"$f":"IRR(R110:R113)","v":{"v":0.07721734501588928,"d":"8%"}},"4000-",0,0,5000,"C"]
[]
[{"$nulls":11},"להלן מובאות מספר טענות:\n1. אם מחיר ההון הינו 5%, ההשקעה בעלת ה-IRR הנמוך ביותר היא גם הכדאית ביותר.\n2. אם מחיר ההון הינו 0%, כל ההשקעות הן בעלות NPV חיובי.\n3. אם מחיר ההון הינו 20%, כדי להשקיע בפרויקט B.\nסמנו את התשובה הנכונה ביותר\nא. רק טענות 1 ו-2 נכונות.\nב. רק טענות 1 ו-3 נכונות.\nג. רק טענות 2 ו-3 נכונות.\nד. כל הטענות נכונות.\nה. כל הטענות האחרות אינן נכונות.\n",{"$nulls":5},{"v":-4000,"d":"-4,000"}]
[{"$nulls":17},0]
[{"$nulls":17},0]
[{"$nulls":17},{"$f":"P108","v":5000}]
{"$rows_empty":44}
[{"$nulls":11},"מוצע בפניכם הפרויקט הבא:"]
[]
[{"$nulls":8},"שאלה 4",null,{"v":0.05,"d":"5.00%"},0,1,2,"...",50]
[{"$nulls":11},-600,36,36,"...",36]
[{"$nulls":8},50,1,{"$f":"NPV(K160,I162:I211)-600","v":312.79627302761844},{"$f":"K162/K163","v":0.5213271217126974}]
[{"$nulls":8},50,2,600,"בהנחה והריבית השנתית הינה 5%"]
[{"$nulls":8},50,3,null,"חשב את הענ\"נ בפרויקט וקבע האם ההשקעה כדאית"]
[{"$nulls":8},50,4]
[{"$nulls":8},50,5]
[{"$nulls":8},50,6]
[{"$nulls":8},50,7]
[{"$nulls":8},50,8]
[{"$nulls":8},50,9]
[{"$nulls":8},50,10]
[{"$nulls":8},50,11]
[{"$nulls":8},50,12]
[{"$nulls":8},50,13]
[{"$nulls":8},50,14]
[{"$nulls":8},50,15]
[{"$nulls":8},50,16]
[{"$nulls":8},50,17]
[{"$nulls":8},50,18]
[{"$nulls":8},50,19]
[{"$nulls":8},50,20]
[{"$nulls":8},50,21]
[{"$nulls":8},50,22]
[{"$nulls":8},50,23]
[{"$nulls":8},50,24]
[{"$nulls":8},50,25]
[{"$nulls":8},50,26]
[{"$nulls":8},50,27]
[{"$nulls":8},50,28]
[{"$nulls":8},50,29]
[{"$nulls":8},50,30]
[{"$nulls":8},50,31]
[{"$nulls":8},50,32]
[{"$nulls":8},50,33]
[{"$nulls":8},50,34]
[{"$nulls":8},50,35]
[{"$nulls":8},50,36]
[{"$nulls":8},50,37]
[{"$nulls":8},50,38]
[{"$nulls":8},50,39]
[{"$nulls":8},50,40]
[{"$nulls":8},50,41]
[{"$nulls":8},50,42]
[{"$nulls":8},50,43]
[{"$nulls":8},50,44]
[{"$nulls":8},50,45]
[{"$nulls":8},50,46]
[{"$nulls":8},50,47]
[{"$nulls":8},50,48]
[{"$nulls":8},50,49]
[{"$nulls":8},50,50]
{"$rows_empty":19}
[{"$nulls":8},"שאלה 5",null,null,"חברת: \"אופיר מאגדי-הכנה לבחינות\" ניצבת בפני שתי תוכניות השקעה, חד פעמיות המוציאות זו את זו."]
[{"$nulls":11}," ידוע כי מחיר ההון של החברה עומד על 4% ורשמי המזומנים (באלפי ₪)  הצפויים מכל תכנית הינם:"]
[{"$nulls":11},0,1,2,3,4,5,"year",{"v":0.05,"d":"5.00%"}]
[{"$nulls":11},-90,26,26,26,26,26,"A",{"$f":"NPV(S233,T240:T244)-90","v":{"v":22.566393436401285,"d":"22.57"}},{"$f":"IRR(T239:T244)","v":{"v":0.13657411106662054,"d":"14%"}}]
[{"$nulls":11},-42,14,14,14,14,14,"B",{"$f":"NPV(S233,S240:S244)-42","v":{"v":18.61267338883146,"d":"18.61"}},{"$f":"IRR(S239:S244)","v":{"v":0.1985770978730661,"d":"20%"}}]
[]
[{"$nulls":11},"א. חשב לכל תכנית את הענ\"נ והשת\"פ"]
[{"$nulls":11},"ב. ציין איזו תכנית עדיפה",{"$nulls":6},"B","A"]
[{"$nulls":18},-42,-90]
[{"$nulls":17},14,14,26]
[{"$nulls":18},14,26]
[{"$nulls":18},14,26]
[{"$nulls":18},14,26]
[{"$nulls":18},14,26]
{"$rows_empty":29}
[{"$nulls":11},"להלן תזרים מזומנים של פרויקט כלשהו:\n"]
[]
[]
[]
[]
[]
[]
[{"$nulls":8},"שאלה 6",{"$nulls":5},{"v":0.1,"d":"10.00%"}]
[{"$nulls":11},0,1,2,"פרויקט"]
[{"$nulls":11},-21,47,24,"A",{"$f":"IRR(T283:T285)","v":{"v":1.666666666666666,"d":"167%"}},{"$f":"NPV(O281,T284:T285)-21","v":{"v":41.56198347107437,"d":"41.56"}},null,null,-21]
[{"$nulls":19},47]
[{"$nulls":11},"א. חשב את ש.ת.פ הפרויקט\nב. הנח כי עלות ההון שלך הינה 10% ענה מבלי לחשב האם הפרויקט כדאי ומדוע?\nג. בהמשך לסעיף ב' מה יהיה הערך הנוכחי של ההשקעה?\n",{"$nulls":7},24]

{"sheet":"דוגמאות מרצה שאלות 7-11","index":1,"n_rows":256,"n_cols":18,"rows_kept":256,"merged":[[129,9,129,12],[165,12,166,14],[170,12,171,14],[175,12,176,14]]}
[]
[]
[]
[{"$nulls":4},"שאלה 7"]
[]
[]
[]
[]
[{"$nulls":8},"נתונים"]
[]
[{"$nulls":8},-200,"השקעה",0,1,2,3]
[{"$nulls":8},160,"תקבול שנה 1","200-",160,180,140]
[{"$nulls":8},180,"תקבול שנה 2"]
[{"$nulls":8},140,"תקבול שנה 3"]
[]
[{"$nulls":8},{"v":0.08,"d":"8%"},"r","ריבית שנתית"]
[]
[]
[{"$nulls":9},{"$f":"NPV(I16,I12:I14)+I11","v":{"v":213.6056495452928,"d":"₪ 213.61"}},"ערך נוכחי נקי (NPV)"]
[{"$nulls":9},{"$f":"IRR(I11:I14)","v":{"v":0.6213659322608895,"d":"62%"}}]
[{"$nulls":9},{"$f":"IF(J19>0,\"כדאי\",IF(J19<0,\"לא כדאי\",\"אדיש\"))","v":"כדאי"},"האם הפרויקט כדאי?"]
{"$rows_empty":9}
[{"$nulls":4},"שאלה 8"]
[]
[]
[]
[]
[]
[]
[{"$nulls":8},"נתונים",0,1,2,"....",30]
[{"$nulls":8},"דרך 1","800-",40,40,40,40]
[]
[{"$nulls":8},-800,"I0","השקעה"]
[{"$nulls":8},-40,"PMT","תקבול שנתי"]
[{"$nulls":8},30,"n","מספר שנים"]
[{"$nulls":8},{"v":0.12,"d":"12%"},"r","ריבית שנתית"]
[{"$nulls":8},0,"Type","תחילת / סוף שנה"]
[]
[{"$nulls":9},{"$f":"PV(I44,I43,I42,,)-800","v":{"v":-477.79264129330545,"d":"₪ -477.79"}},"ערך נוכחי נקי (NPV)"]
[]
[{"$nulls":8},"דרך 2"]
[]
[{"$nulls":8},-800,"השקעה"]
[{"$nulls":8},40,"תקבול שנה 1"]
[{"$nulls":8},40,"תקבול שנה 2"]
[{"$nulls":8},40,"תקבול שנה 3"]
[{"$nulls":8},40,"תקבול שנה 4"]
[{"$nulls":8},40,"תקבול שנה 5"]
[{"$nulls":8},40,"תקבול שנה 6"]
[{"$nulls":8},40,"תקבול שנה 7"]
[{"$nulls":8},40,"תקבול שנה 8"]
[{"$nulls":8},40,"תקבול שנה 9"]
[{"$nulls":8},40,"תקבול שנה 10"]
[{"$nulls":8},40,"תקבול שנה 11"]
[{"$nulls":8},40,"תקבול שנה 12"]
[{"$nulls":8},40,"תקבול שנה 13"]
[{"$nulls":8},40,"תקבול שנה 14"]
[{"$nulls":8},40,"תקבול שנה 15"]
[{"$nulls":8},40,"תקבול שנה 16"]
[{"$nulls":8},40,"תקבול שנה 17"]
[{"$nulls":8},40,"תקבול שנה 18"]
[{"$nulls":8},40,"תקבול שנה 19"]
[{"$nulls":8},40,"תקבול שנה 20"]
[{"$nulls":8},40,"תקבול שנה 21"]
[{"$nulls":8},40,"תקבול שנה 22"]
[{"$nulls":8},40,"תקבול שנה 23"]
[{"$nulls":8},40,"תקבול שנה 24"]
[{"$nulls":8},40,"תקבול שנה 25"]
[{"$nulls":8},40,"תקבול שנה 26"]
[{"$nulls":8},40,"תקבול שנה 27"]
[{"$nulls":8},40,"תקבול שנה 28"]
[{"$nulls":8},40,"תקבול שנה 29"]
[{"$nulls":8},40,"תקבול שנה 30"]
[]
[{"$nulls":8},{"v":0.12,"d":"12%"},"r","ריבית שנתית"]
[]
[{"$nulls":9},{"$f":"NPV(I83,I52:I81)+I51","v":{"v":-477.7926412933059,"d":"₪ -477.79"}},"ערך נוכחי נקי (NPV)"]
[]
[{"$nulls":9},{"$f":"IF(J85>0,\"כדאי\",IF(J85<0,\"לא כדאי\",\"אדיש\"))","v":"לא כדאי"},"האם הפרויקט כדאי?"]
{"$rows_empty":11}
[{"$nulls":4},"שאלה 9"]
[]
[]
[]
[]
[]
[]
[{"$nulls":8},"נתונים",0,1,2,3,4,5,6,7,8]
[{"$nulls":8},"סעיף א'","500-",90,70,60,50,30,100,0,900]
[]
[{"$nulls":8},-500,"השקעה"]
[{"$nulls":8},90,"תקבול שנה 1"]
[{"$nulls":8},70,"תקבול שנה 2"]
[{"$nulls":8},60,"תקבול שנה 3"]
[{"$nulls":8},50,"תקבול שנה 4"]
[{"$nulls":8},30,"תקבול שנה 5"]
[{"$nulls":8},100,"תקבול שנה 6"]
[{"$nulls":8},0,"תקבול שנה 7"]
[{"$nulls":8},900,"תקבול שנה 8"]
[]
[{"$nulls":9},{"$f":"IRR(I109:I117)","v":{"v":0.17050060777899168,"d":"17.05%"}},"שיעור תשואה פנימי (IRR)"]
[]
[{"$nulls":8},"סעיף ב'"]
[]
[{"$nulls":8},{"v":0.11,"d":"11%"},"r","ריבית שנתית"]
[{"$nulls":9},{"$f":"NPV(I123,I110:I117)-500","v":{"v":176.50415311232666,"d":"176.50"}}]
[{"$nulls":9},{"$f":"IF(J119>I123,\"כדאי\",\"לא כדאי\")","v":"כדאי"},"האם הפרויקט כדאי?"]
{"$rows_empty":10}
[{"$nulls":4},"שאלה 10"]
[]
[]
[]
[]
[{"$nulls":8},"פרויקט",0,1,2,3,"IRR"]
[{"$nulls":8},"A","200-",120,120,120,{"v":0.3631,"d":"36.31%"}]
[{"$nulls":8},"B","100-",80,80,80,{"v":0.6073,"d":"60.73%"}]
[]
[]
[{"$nulls":8},"נתונים"]
[]
[{"$nulls":8},"פרויקט B","פרויקט A"]
[{"$nulls":8},-100,-200]
[{"$nulls":8},80,120]
[{"$nulls":8},80,120]
[{"$nulls":8},80,120]
[]
[{"$nulls":8},"NPV (B)","NPV (A)","עלות ההון"]
[{"$nulls":8},{"$f":"NPV($K155,I$150:I$152)+I$149","v":{"v":140,"d":"140.00"}},{"$f":"NPV($K155,J$150:J$152)+J$149","v":{"v":160,"d":"160.00"}},{"v":0,"d":"0%"}]
[{"$nulls":8},{"v":135.27881657884447,"d":"135.28"},{"v":152.91822486826663,"d":"152.92"},{"v":0.01,"d":"1%"}]
[{"$nulls":8},{"v":130.710661811822,"d":"130.71"},{"v":146.06599271773297,"d":"146.07"},{"v":0.02,"d":"2%"}]
[{"$nulls":8},{"v":126.2889083915745,"d":"126.29"},{"v":139.43336258736167,"d":"139.43"},{"v":0.03,"d":"3%"}]
[{"$nulls":8},{"v":122.0072826581702,"d":"122.01"},{"v":133.01092398725535,"d":"133.01"},{"v":0.04,"d":"4%"}]
[{"$nulls":8},{"v":117.85984234963826,"d":"117.86"},{"v":126.78976352445738,"d":"126.79"},{"v":0.05,"d":"5%"}]
[{"$nulls":8},{"v":113.84095595693086,"d":"113.84"},{"v":120.76143393539633,"d":"120.76"},{"v":0.06,"d":"6%"}]
[{"$nulls":8},{"v":109.94528355331201,"d":"109.95"},{"v":114.91792532996794,"d":"114.92"},{"v":0.07,"d":"7%"}]
[{"$nulls":8},{"v":106.1677589798303,"d":"106.17"},{"v":109.25163846974544,"d":"109.25"},{"v":0.08,"d":"8%"}]
[{"$nulls":8},{"v":102.50357327905394,"d":"102.50"},{"v":103.7553599185809,"d":"103.76"},{"v":0.09,"d":"9%"},null,"סעיף א'"]
[{"$nulls":8},{"v":99.99999479708129,"d":"100.00"},{"v":99.99999219562193,"d":"100.00"},{"v":0.09701027212615332,"d":"9.701%"}]
[{"$nulls":8},{"v":98.94815927873776,"d":"98.95"},{"v":98.42223891810659,"d":"98.42"},{"v":0.1,"d":"10%"},null,"כאשר עלות ההון היא 5% פרויקט A עדיף (NPV גבוה יותר) - הגרף הירוק"]
[{"$nulls":8},{"v":95.49717723567241,"d":"95.50"},{"v":93.24576585350871,"d":"93.25"},{"v":0.11,"d":"11%"}]
[{"$nulls":8},{"v":92.14650145772592,"d":"92.15"},{"v":88.21975218658889,"d":"88.22"},{"v":0.12,"d":"12%"}]
[{"$nulls":8},{"v":88.8922078291105,"d":"88.89"},{"v":83.33831174366577,"d":"83.34"},{"v":0.13,"d":"13%"},null,"סעיף ב'"]
[{"$nulls":8},{"v":85.73056217027639,"d":"85.73"},{"v":78.5958432554146,"d":"78.60"},{"v":0.14,"d":"14%"}]
[{"$nulls":8},{"v":82.65800936960636,"d":"82.66"},{"v":73.98701405440949,"d":"73.99"},{"v":0.15,"d":"15%"},null,"כאשר עלות ההון היא 9.7% קיימת אדישות בין הפרויקטים כיון שהענ\"נ של שניהם זהה."]
[{"$nulls":8},{"v":79.67116322932472,"d":"79.67"},{"v":69.50674484398706,"d":"69.51"},{"v":0.16,"d":"16%"}]
[{"$nulls":8},{"v":76.76679697280181,"d":"76.77"},{"v":65.15019545920273,"d":"65.15"},{"v":0.17,"d":"17%"}]
[{"$nulls":8},{"v":73.94183436475981,"d":"73.94"},{"v":60.91275154713969,"d":"60.91"},{"v":0.18,"d":"18%"},null,"סעיף ג'"]
[{"$nulls":8},{"$f":"NPV($K175,I$150:I$152)+I$149","v":{"v":71.19334139983229,"d":"71.19"}},{"v":56.79001209974848,"d":"56.79"},{"v":0.19,"d":"19%"}]
[{"$nulls":8},{"v":68.51851851851853,"d":"68.52"},{"v":52.77777777777783,"d":"52.78"},{"v":0.2,"d":"20%"},null,"כאשר עלות ההון נעה 9.7% ל-60.73%, פרויקט B עדיף (NPV גבוה יותר) - הגרף האדום"]
[{"$nulls":8},{"v":65.91469331284671,"d":"65.91"},{"v":48.87203996927008,"d":"48.87"},{"v":0.21,"d":"21%"}]
[{"$nulls":8},{"v":63.37931368704869,"d":"63.38"},{"v":45.06897053057301,"d":"45.07"},{"v":0.22,"d":"22%"}]
[{"$nulls":8},{"v":60.90994144127444,"d":"60.91"},{"v":41.36491216191163,"d":"41.36"},{"v":0.23,"d":"23%"}]
[{"$nulls":8},{"v":58.504246248867105,"d":"58.50"},{"v":37.75636937330063,"d":"37.76"},{"v":0.24,"d":"24%"}]
[{"$nulls":8},56.16,{"v":34.24000000000001,"d":"34.24"},{"v":0.25,"d":"25%"}]
[{"$nulls":8},{"v":53.87507148656053,"d":"53.88"},{"v":30.81260722984075,"d":"30.81"},{"v":0.26,"d":"26%"}]
[{"$nulls":8},{"v":51.64742140507903,"d":"51.65"},{"v":27.47113210761853,"d":"27.47"},{"v":0.27,"d":"27%"}]
[{"$nulls":8},{"v":49.47509765625,"d":"49.48"},{"v":24.212646484375,"d":"24.21"},{"v":0.28,"d":"28%"}]
[{"$nulls":8},{"v":47.35623092120002,"d":"47.36"},{"v":21.03434638180002,"d":"21.03"},{"v":0.29,"d":"29%"}]
[{"$nulls":8},{"v":45.28903049613109,"d":"45.29"},{"v":17.933545744196635,"d":"17.93"},{"v":0.3,"d":"30%"}]
[{"$nulls":8},{"v":43.27178036832137,"d":"43.27"},{"v":14.907670552482074,"d":"14.91"},{"v":0.31,"d":"31%"}]
[{"$nulls":8},{"v":41.302835517711515,"d":"41.30"},{"v":11.9542532765673,"d":"11.95"},{"v":0.32,"d":"32%"}]
[{"$nulls":8},{"v":39.38061842944745,"d":"39.38"},{"v":9.070927644171206,"d":"9.07"},{"v":0.33,"d":"33%"}]
[{"$nulls":8},{"v":37.503615803805616,"d":"37.50"},{"v":6.255423705708466,"d":"6.26"},{"v":0.34,"d":"34%"}]
[{"$nulls":8},{"v":35.67037545089667,"d":"35.67"},{"v":3.505563176345049,"d":"3.51"},{"v":0.35,"d":"35%"}]
[{"$nulls":8},{"v":33.33272514934629,"d":"33.33"},{"v":-0.000912275980567756,"d":"-0.00"},{"v":0.3631,"d":"36.31%"}]
[{"$nulls":8},{"v":33.87950335843681,"d":"33.88"},{"v":0.819255037655239,"d":"0.82"},{"v":0.36,"d":"36%"}]
[{"$nulls":8},{"v":32.129660921701515,"d":"32.13"},{"v":-1.8055086174477424,"d":"-1.81"},{"v":0.37,"d":"37%"}]
[{"$nulls":8},{"$f":"NPV($K195,I$150:I$152)+I$149","v":{"v":30.419562325537527,"d":"30.42"}},{"v":-4.37065651169371,"d":"-4.37"},{"v":0.38,"d":"38%"}]
[{"$nulls":8},{"v":28.747972069009023,"d":"28.75"},{"v":-6.878041896486479,"d":"-6.88"},{"v":0.39,"d":"39%"}]
[{"$nulls":8},{"v":27.11370262390672,"d":"27.11"},{"v":-9.329446064139916,"d":"-9.33"},{"v":0.4,"d":"40%"}]
[{"$nulls":8},{"v":25.515612218943858,"d":"25.52"},{"v":-11.726581671584228,"d":"-11.73"},{"v":0.41,"d":"41%"}]
[{"$nulls":8},{"v":23.952602742022464,"d":"23.95"},{"v":-14.071095886966305,"d":"-14.07"},{"v":0.42,"d":"42%"}]
[{"$nulls":8},{"v":22.423617753462736,"d":"22.42"},{"v":-16.364573369805896,"d":"-16.36"},{"v":0.43,"d":"43%"}]
[{"$nulls":8},{"v":20.92764060356653,"d":"20.93"},{"v":-18.60853909465021,"d":"-18.61"},{"v":0.44,"d":"44%"}]
[{"$nulls":8},{"v":19.463692648325065,"d":"19.46"},{"v":-20.80446102751239,"d":"-20.80"},{"v":0.45,"d":"45%"}]
[{"$nulls":8},{"v":18.03083155748979,"d":"18.03"},{"v":-22.95375266376533,"d":"-22.95"},{"v":0.46,"d":"46%"}]
[{"$nulls":8},{"v":16.62814970960389,"d":"16.63"},{"v":-25.05777543559418,"d":"-25.06"},{"v":0.47,"d":"47%"}]
[{"$nulls":8},{"v":15.254772668943616,"d":"15.25"},{"v":-27.11784099658459,"d":"-27.12"},{"v":0.48,"d":"48%"}]
[{"$nulls":8},{"v":13.909857739644735,"d":"13.91"},{"v":-29.135213390532925,"d":"-29.14"},{"v":0.49,"d":"49%"}]
[{"$nulls":8},{"v":12.59259259259261,"d":"12.59"},{"v":-31.111111111111114,"d":"-31.11"},{"v":0.5,"d":"50%"}]
[{"$nulls":8},{"v":11.302193960936421,"d":"11.30"},{"v":-33.04670905859538,"d":"-33.05"},{"v":0.51,"d":"51%"}]
[{"$nulls":8},{"v":10.037906400349897,"d":"10.04"},{"v":-34.94314039947514,"d":"-34.94"},{"v":0.52,"d":"52%"}]
[{"$nulls":8},{"v":8.799001110404717,"d":"8.80"},{"v":-36.80149833439293,"d":"-36.80"},{"v":0.53,"d":"53%"}]
[{"$nulls":8},{"v":7.58477481364983,"d":"7.58"},{"v":-38.62283777952524,"d":"-38.62"},{"v":0.54,"d":"54%"}]
[{"$nulls":8},{"v":6.394548689201443,"d":"6.39"},{"v":-40.40817696619786,"d":"-40.41"},{"v":0.55,"d":"55%"}]
[{"$nulls":8},{"v":5.227667357844865,"d":"5.23"},{"v":-42.15849896323272,"d":"-42.16"},{"v":0.56,"d":"56%"}]
[{"$nulls":8},{"v":4.08349791583386,"d":"4.08"},{"v":-43.8747531262492,"d":"-43.87"},{"v":0.57,"d":"57%"}]
[{"$nulls":8},{"$f":"NPV($K215,I$150:I$152)+I$149","v":{"v":2.9614290147432314,"d":"2.96"}},{"v":-45.55785647788514,"d":"-45.56"},{"v":0.58,"d":"58%"}]
[{"$nulls":8},{"v":1.860869984891849,"d":"1.86"},{"v":-47.208695022662255,"d":"-47.21"},{"v":0.59,"d":"59%"}]
[{"$nulls":8},{"v":0.78125,"d":"0.78"},{"v":-48.828125,"d":"-48.83"},{"v":0.6,"d":"60%"}]
[{"$nulls":8},{"v":0.006031591305159623,"d":"0.01"},{"v":-49.99095261304225,"d":"-49.99"},{"v":0.6073,"d":"60.73%"}]
[{"$nulls":8},{"v":-0.2779827191123587,"d":"-0.28"},{"v":-50.416974078668545,"d":"-50.42"},{"v":0.61,"d":"61%"}]
[{"$nulls":8},{"v":-1.317361663853589,"d":"-1.32"},{"v":-51.976042495780376,"d":"-51.98"},{"v":0.62,"d":"62%"}]
[{"$nulls":8},{"v":-2.337402762156259,"d":"-2.34"},{"v":-53.50610414323441,"d":"-53.51"},{"v":0.63,"d":"63%"}]
[{"$nulls":8},{"v":-3.3386050695724094,"d":"-3.34"},{"v":-55.00790760435862,"d":"-55.01"},{"v":0.64,"d":"64%"}]
[{"$nulls":8},{"v":-4.321451428889432,"d":"-4.32"},{"v":-56.482177143334155,"d":"-56.48"},{"v":0.65,"d":"65%"}]
[{"$nulls":8},{"v":-5.286409099892097,"d":"-5.29"},{"v":-57.92961364983816,"d":"-57.93"},{"v":0.66,"d":"66%"}]
[{"$nulls":8},{"v":-6.23393036079942,"d":"-6.23"},{"v":-59.35089554119915,"d":"-59.35"},{"v":0.67,"d":"67%"}]
[{"$nulls":8},{"v":-7.16445308282043,"d":"-7.16"},{"v":-60.746679624230666,"d":"-60.75"},{"v":0.68,"d":"68%"}]
[{"$nulls":8},{"v":-8.078401279188796,"d":"-8.08"},{"v":-62.11760191878318,"d":"-62.12"},{"v":0.69,"d":"69%"}]
[{"$nulls":8},{"v":-8.976185629961321,"d":"-8.98"},{"v":-63.46427844494198,"d":"-63.46"},{"v":0.7,"d":"70%"}]
[]
[]
[]
[]
[]
[{"$nulls":4},"שאלה 11"]
[]
[]
[]
[]
[]
[{"$nulls":8},"כל הנתונים באלפי ₪:"]
[{"$nulls":8},{"v":0.1,"d":"10%"},"r","עלות ההון"]
[{"$nulls":8},500,null,"מגבלה תקציבית"]
[]
[{"$nulls":8},"פרויקט",0,1,2,3,4,"NPV","PI"]
[{"$nulls":8},"D",-50,0,0,120,0,40,{"$f":"O245/-J245","v":0.8}]
[{"$nulls":8},"A",-100,100,0,100,0,66,{"$f":"O246/-J246","v":0.66}]
[{"$nulls":8},"B",-150,0,100,0,200,69,0.46]
[{"$nulls":8},"C",-300,300,0,200,0,123,0.41]
[{"$nulls":8},"E",-500,0,0,400,500,142,0.284]
[]
[{"$nulls":8},"הפרויקט הנבחר","PI","סכום ההשקעה","הענ\"נ שמתקבל","הסכום שנותר להשקעה"]
[{"$nulls":8},"D",0.8,50,40,{"$f":"I242-K252","v":450}]
[{"$nulls":8},"A",0.66,100,66,{"$f":"M252-K253","v":350}]
[{"$nulls":8},"B",0.46,150,69,{"$f":"M253-K254","v":200}]
[{"$nulls":8},"C",0.41,200,{"$f":"(K255/-J248)*O248","v":82},0]
[{"$nulls":8},"סה\"כ",null,null,{"$f":"SUM(L252:L255)","v":257}]

{"sheet":"תרגול עצמי שאלות 12-15","index":2,"n_rows":183,"n_cols":18,"rows_kept":183,"merged":[[0,8,0,17],[63,8,64,12],[96,1,96,5]]}
[{"$nulls":8},"קריטריונים לבחינת כדאיות השקעה - תרגול עצמי"]
[]
[]
[{"$nulls":5},"שאלה 12",{"$nulls":5},5]
[{"$nulls":11},0]
[{"$nulls":11},600]
[]
[]
[{"$nulls":8},"נתונים"]
[{"$nulls":8},"סעיף א'"]
[]
[{"$nulls":8},{"v":0.05,"d":"5%"},"r","עלות ההון"]
[]
[{"$nulls":8},"פרויקט ב'","פרויקט א'"]
[{"$nulls":8},-1000,-750,"השקעה"]
[{"$nulls":8},300,0,"תקבול שנה 1"]
[{"$nulls":8},300,0,"תקבול שנה 2"]
[{"$nulls":8},300,1000,"תקבול שנה 3"]
[{"$nulls":8},300,0,"תקבול שנה 4"]
[{"$nulls":8},300,0,"תקבול שנה 5"]
[]
[{"$nulls":8},{"$f":"NPV(I12,I16:I20)-1000","v":{"v":298.8430011892458,"d":"₪ 298.84"}},{"$f":"NPV(I12,J16:J20)-750","v":{"v":113.83759853147603,"d":"₪ 113.84"}},"ערך נוכחי נקי (NPV)"]
[{"$nulls":8},{"$f":"IRR(I15:I20)","v":{"v":0.15238237116630637,"d":"15%"}},{"$f":"IRR(J15:J20)","v":{"v":0.10064241629820714,"d":"10%"}},"IRR"]
[{"$nulls":8},{"$f":"I22/-I15","v":0.2988430011892458},{"$f":"J22/-J15","v":0.1517834647086347},"PI"]
[{"$nulls":8},"סעיף ב'"]
[]
[{"$nulls":9},{"$f":"IF(J22>I22,\"פרויקט א\",\"פרויקט ב'\")","v":"פרויקט ב'"},"איזה פרויקט עדיף?"]
[]
[]
[]
[]
[]
[]
[{"$nulls":17},"שנה"]
[{"$nulls":5},"שאלה 13",{"$nulls":11},"תוכנית א'"]
[{"$nulls":17},"תוכנית ב'"]
[]
[]
[]
[]
[{"$nulls":8},"נתונים",5,4,3,2,1,0]
[{"$nulls":9},32,32,32,32,32,-100]
[{"$nulls":8},"סעיף א'",24,24,24,24,24,-64]
[]
[{"$nulls":8},{"v":0.06,"d":"6%"},"r","עלות ההון"]
[]
[{"$nulls":8},"תוכנית ב'","תוכנית א'"]
[{"$nulls":8},-64,-100,"השקעה"]
[{"$nulls":8},24,32,"תקבול שנה 1"]
[{"$nulls":8},24,32,"תקבול שנה 2"]
[{"$nulls":8},24,32,"תקבול שנה 3"]
[{"$nulls":8},24,32,"תקבול שנה 4"]
[{"$nulls":8},24,32,"תקבול שנה 5"]
[]
[{"$nulls":8},{"$f":"NPV($I$45,I49:I53)+I48","v":{"v":37.096730853577114,"d":"₪ 37.10"}},{"$f":"NPV($I$45,J49:J53)+J48","v":{"v":34.79564113810281,"d":"₪ 34.80"}},"ערך נוכחי נקי (NPV)"]
[{"$nulls":8},{"$f":"IRR(I48:I53)","v":{"v":0.25413002038866117,"d":"25.41%"}},{"$f":"IRR(J48:J53)","v":{"v":0.18030666893028036,"d":"18.03%"}},"שיעור תשואה פנימי (IRR)"]
[]
[]
[{"$nulls":8},"סעיף ב'"]
[]
[]
[{"$nulls":9},{"$f":"IF(J55>I55,\"תוכנית א'\",\"תוכנית ב'\")","v":"תוכנית ב'"},"איזו תוכנית עדיפה?"]
[]
[{"$nulls":8},"אמנם קיימת סתירה בין קריטריון הענ\"נ לקריטריון השת\"פ אולם, תמיד נפעל על בסיס קריטריון הענ\"נ"]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"שאלה 14"]
[]
[]
[]
[{"$nulls":8},"נתונים","פרויקט B","פרויקט A"]
[{"$nulls":9},-100,-200]
[{"$nulls":9},120,100]
[{"$nulls":9},80,200]
[{"$nulls":9},{"$f":"IRR(J76:J78)","v":{"v":0.6770329614255977,"d":"67.70%"}},{"$f":"IRR(K76:K78)","v":{"v":0.2807764064044149,"d":"28%"}}]
[{"$nulls":9},"NPV (B)","NPV (A)","עלות ההון"]
[{"$nulls":9},{"$f":"NPV(L81,$J$77:$J$78)-100","v":{"v":100,"d":"100.00"}},{"$f":"NPV(L81,$K$77:$K$78)-200","v":{"v":100,"d":"100.00"}},{"v":0,"d":"0%"}]
[{"$nulls":9},{"$f":"NPV(L82,$J$77:$J$78)-100","v":{"v":97.23556514067249,"d":"97.24"}},{"$f":"NPV(L82,$K$77:$K$78)-200","v":{"v":95.06911087148325,"d":"95.07"}},{"v":0.01,"d":"1%"}]
[{"$nulls":9},{"v":94.54056132256824,"d":"94.54"},{"v":90.27297193387159,"d":"90.27"},{"v":0.02,"d":"2%"}]
[{"$nulls":9},{"v":91.91252709963237,"d":"91.91"},{"v":85.60656046752757,"d":"85.61"},{"v":0.03,"d":"3%"}]
[{"$nulls":9},{"v":89.34911242603548,"d":"89.35"},{"v":81.06508875739638,"d":"81.07"},{"v":0.04,"d":"4%"}]
[{"$nulls":9},{"v":86.84807256235828,"d":"86.85"},{"v":76.64399092970518,"d":"76.64"},{"v":0.05,"d":"5%"}]
[{"$nulls":9},{"v":84.40726237095049,"d":"84.41"},{"v":72.33891064435744,"d":"72.34"},{"v":0.06,"d":"6%"}]
[{"$nulls":9},{"v":82.02463097213732,"d":"82.02"},{"v":68.14568957987592,"d":"68.15"},{"v":0.07,"d":"7%"}]
[{"$nulls":9},{"v":79.69821673525377,"d":"79.70"},{"v":64.06035665294922,"d":"64.06"},{"v":0.08,"d":"8%"}]
[{"$nulls":9},{"v":77.42614258059083,"d":"77.43"},{"v":60.079117919367036,"d":"60.08"},{"v":0.09,"d":"9%"}]
[{"$nulls":9},{"v":75.2066115702479,"d":"75.21"},{"v":56.198347107437996,"d":"56.20"},{"v":0.1,"d":"10%"}]
[{"$nulls":9},{"v":73.03790276763246,"d":"73.04"},{"v":52.41457673890105,"d":"52.41"},{"v":0.11,"d":"11%"}]
[{"$nulls":9},{"v":70.91836734693874,"d":"70.92"},{"v":48.724489795918316,"d":"48.72"},{"v":0.12,"d":"12%"}]
[{"$nulls":9},{"v":68.84642493539042,"d":"68.85"},{"v":45.12491189599814,"d":"45.12"},{"v":0.13,"d":"13%"}]
[{"$nulls":9},{"v":66.8205601723607,"d":"66.82"},{"v":41.61280393967371,"d":"41.61"},{"v":0.14,"d":"14%"}]
[null,"פרויקט B עדיף בכל עלות הון (אך עד עלות של 67.703%)",{"$nulls":7},{"v":64.83931947069948,"d":"64.84"},{"v":38.18525519848774,"d":"38.19"},{"v":0.15,"d":"15%"}]
[null,"כאשר עלות ההון מעל 67.703% לא נבחר באף אחד מהפרויקטים",{"$nulls":7},{"v":62.9013079667063,"d":"62.90"},{"v":34.839476813317475,"d":"34.84"},{"v":0.16,"d":"16%"}]
[{"$nulls":9},{"v":61.00518664621228,"d":"61.01"},{"v":31.5727956753598,"d":"31.57"},{"v":0.17,"d":"17%"}]
[{"$nulls":9},{"v":59.149669635162326,"d":"59.15"},{"v":28.382648664176997,"d":"28.38"},{"v":0.18,"d":"18%"}]
[{"$nulls":9},{"v":57.333521643951684,"d":"57.33"},{"v":25.266577219122922,"d":"25.27"},{"v":0.19,"d":"19%"}]
[{"$nulls":9},{"v":55.55555555555557,"d":"55.56"},{"v":22.222222222222257,"d":"22.22"},{"v":0.2,"d":"20%"}]
[{"$nulls":9},{"v":53.81463014821392,"d":"53.81"},{"v":19.2473191721877,"d":"19.25"},{"v":0.21,"d":"21%"}]
[{"$nulls":9},{"v":52.10964794410103,"d":"52.11"},{"v":16.33969363074442,"d":"16.34"},{"v":0.22,"d":"22%"}]
[{"$nulls":9},{"v":50.43955317601959,"d":"50.44"},{"v":13.497256923788768,"d":"13.50"},{"v":0.23,"d":"23%"}]
[{"$nulls":9},{"v":48.80332986472425,"d":"48.80"},{"v":10.718002081165423,"d":"10.72"},{"v":0.24,"d":"24%"}]
[{"$nulls":9},{"v":47.19999999999999,"d":"47.20"},{"v":8,"d":"8.00"},{"v":0.25,"d":"25%"}]
[{"$nulls":9},{"v":45.628621819098015,"d":"45.63"},{"v":5.341395817586289,"d":"5.34"},{"v":0.26,"d":"26%"}]
[{"$nulls":9},{"v":44.088288176576356,"d":"44.09"},{"v":2.7404054808109493,"d":"2.74"},{"v":0.27,"d":"27%"}]
[{"$nulls":9},{"v":42.578125,"d":"42.58"},{"v":0.1953125,"d":"0.20"},{"v":0.28,"d":"28%"}]
[{"$nulls":9},{"v":42.46211251235326,"d":"42.46"},{"v":0,"d":"0.00"},{"v":0.2807764064044149,"d":"28.078%"}]
[{"$nulls":9},{"v":41.09728982633254,"d":"41.10"},{"v":-2.295535124091117,"d":"-2.30"},{"v":0.29,"d":"29%"}]
[{"$nulls":9},{"v":39.6449704142012,"d":"39.64"},{"v":-4.73372781065089,"d":"-4.73"},{"v":0.3,"d":"30%"}]
[{"$nulls":9},{"v":38.22038342753916,"d":"38.22"},{"v":-7.1207971563428885,"d":"-7.12"},{"v":0.31,"d":"31%"}]
[{"$nulls":9},{"v":36.822773186409535,"d":"36.82"},{"v":-9.45821854912765,"d":"-9.46"},{"v":0.32,"d":"32%"}]
[{"$nulls":9},{"v":35.45141048108994,"d":"35.45"},{"v":-11.747413646899219,"d":"-11.75"},{"v":0.33,"d":"33%"}]
[{"$nulls":9},{"v":34.10559144575626,"d":"34.11"},{"v":-13.989752728892881,"d":"-13.99"},{"v":0.34,"d":"34%"}]
[{"$nulls":9},{"v":32.78463648834017,"d":"32.78"},{"v":-16.186556927297687,"d":"-16.19"},{"v":0.35,"d":"35%"}]
[{"$nulls":9},{"v":31.487889273356416,"d":"31.49"},{"v":-18.33910034602073,"d":"-18.34"},{"v":0.36,"d":"36%"}]
[{"$nulls":9},{"v":30.21471575470187,"d":"30.21"},{"v":-20.448612073099298,"d":"-20.45"},{"v":0.37,"d":"37%"}]
[{"$nulls":9},{"v":28.96450325561858,"d":"28.96"},{"v":-22.51627809283761,"d":"-22.52"},{"v":0.38,"d":"38%"}]
[{"$nulls":9},{"v":27.736659593188733,"d":"27.74"},{"v":-24.54324310335906,"d":"-24.54"},{"v":0.39,"d":"39%"}]
[{"$nulls":9},{"v":26.530612244897966,"d":"26.53"},{"v":-26.530612244897952,"d":"-26.53"},{"v":0.4,"d":"40%"}]
[{"$nulls":9},{"v":25.34580755495196,"d":"25.35"},{"v":-28.47945274382576,"d":"-28.48"},{"v":0.41,"d":"41%"}]
[{"$nulls":9},{"v":24.18170997817893,"d":"24.18"},{"v":-30.390795477087863,"d":"-30.39"},{"v":0.42,"d":"42%"}]
[{"$nulls":9},{"v":23.037801359479687,"d":"23.04"},{"v":-32.265636461440636,"d":"-32.27"},{"v":0.43,"d":"43%"}]
[{"$nulls":9},{"v":21.913580246913583,"d":"21.91"},{"v":-34.10493827160494,"d":"-34.10"},{"v":0.44,"d":"44%"}]
[{"$nulls":9},{"v":20.808561236623078,"d":"20.81"},{"v":-35.909631391200946,"d":"-35.91"},{"v":0.45,"d":"45%"}]
[{"$nulls":9},{"v":19.722274347907685,"d":"19.72"},{"v":-37.680615500093836,"d":"-37.68"},{"v":0.46,"d":"46%"}]
[{"$nulls":9},{"v":18.6542644268592,"d":"18.65"},{"v":-39.418760701559535,"d":"-39.42"},{"v":0.47,"d":"47%"}]
[{"$nulls":9},{"v":17.60409057706356,"d":"17.60"},{"v":-41.124908692476254,"d":"-41.12"},{"v":0.48,"d":"48%"}]
[{"$nulls":9},{"v":16.57132561596326,"d":"16.57"},{"v":-42.79987387955498,"d":"-42.80"},{"v":0.49,"d":"49%"}]
[{"$nulls":9},{"v":15.555555555555557,"d":"15.56"},{"v":-44.44444444444443,"d":"-44.44"},{"v":0.5,"d":"50%"}]
[{"$nulls":9},{"v":14.556379106179548,"d":"14.56"},{"v":-46.059383360378945,"d":"-46.06"},{"v":0.51,"d":"51%"}]
[{"$nulls":9},{"v":13.57340720221606,"d":"13.57"},{"v":-47.64542936288089,"d":"-47.65"},{"v":0.52,"d":"52%"}]
[{"$nulls":9},{"v":12.606262548592412,"d":"12.61"},{"v":-49.20329787688496,"d":"-49.20"},{"v":0.53,"d":"53%"}]
[{"$nulls":9},{"v":11.654579187046721,"d":"11.65"},{"v":-50.73368190251307,"d":"-50.73"},{"v":0.54,"d":"54%"}]
[{"$nulls":9},{"v":10.718002081165452,"d":"10.72"},{"v":-52.237252861602514,"d":"-52.24"},{"v":0.55,"d":"55%"}]
[{"$nulls":9},{"v":9.79618671926363,"d":"9.80"},{"v":-53.7146614069691,"d":"-53.71"},{"v":0.56,"d":"56%"}]
[{"$nulls":9},{"v":8.888798734228587,"d":"8.89"},{"v":-55.166538196275695,"d":"-55.17"},{"v":0.57,"d":"57%"}]
[{"$nulls":9},{"v":7.995513539496855,"d":"8.00"},{"v":-56.59349463227048,"d":"-56.59"},{"v":0.58,"d":"58%"}]
[{"$nulls":9},{"v":7.1160159803805385,"d":"7.12"},{"v":-57.99612357106125,"d":"-58.00"},{"v":0.59,"d":"59%"}]
[{"$nulls":9},6.25,{"v":-59.375,"d":"-59.38"},{"v":0.6,"d":"60%"}]
[{"$nulls":9},{"v":5.3971683191234945,"d":"5.40"},{"v":-60.7306816866633,"d":"-60.73"},{"v":0.61,"d":"61%"}]
[{"$nulls":9},{"v":4.557232129248575,"d":"4.56"},{"v":-62.06370980033532,"d":"-62.06"},{"v":0.62,"d":"62%"}]
[{"$nulls":9},{"v":3.729910798298775,"d":"3.73"},{"v":-63.37460950732054,"d":"-63.37"},{"v":0.63,"d":"63%"}]
[{"$nulls":9},{"$f":"NPV(L146,$J$77:$J$78)-100","v":{"v":2.9149315883402664,"d":"2.91"}},{"$f":"NPV(L146,$K$77:$K$78)-200","v":{"v":-64.66389054134444,"d":"-64.66"}},{"v":0.64,"d":"64%"}]
[{"$nulls":9},{"v":2.112029384756667,"d":"2.11"},{"v":-65.93204775022957,"d":"-65.93"},{"v":0.65,"d":"65%"}]
[{"$nulls":9},{"v":1.3209464363477963,"d":"1.32"},{"v":-67.1795616199739,"d":"-67.18"},{"v":0.66,"d":"66%"}]
[{"$nulls":9},{"v":0.5414321058481875,"d":"0.54"},{"v":-68.40689877729571,"d":"-68.41"},{"v":0.67,"d":"67%"}]
[{"$nulls":9},{"v":-0.22675736961451776,"d":"-0.23"},{"v":-69.61451247165536,"d":"-69.61"},{"v":0.68,"d":"68%"}]
[{"$nulls":9},{"v":9.980283266486367e-11,"d":"0.00"},{"v":-69.25824035656834,"d":"-69.26"},{"v":0.6770329614255977,"d":"67.703%"}]
[{"$nulls":9},{"v":-0.9838591085746202,"d":"-0.98"},{"v":-70.80284303770875,"d":"-70.80"},{"v":0.69,"d":"69%"}]
[{"$nulls":9},{"v":-1.730103806228371,"d":"-1.73"},{"v":-71.97231833910033,"d":"-71.97"},{"v":0.7,"d":"70%"}]
{"$rows_empty":7}
[{"$nulls":5},"שאלה 15"]
[]
[]
[]
[]
[{"$nulls":8},"נתונים"]
[]
[{"$nulls":8},600000,null,"מגבלה תקציבית"]
[]
[{"$nulls":8},"פרויקט","השקעה ראשונית","ערך נוכחי נקי","PI"]
[{"$nulls":8},"B",-150000,114000,{"$f":"K171/-J171","v":0.76}]
[{"$nulls":8},"A",-50000,35000,{"$f":"K172/-J172","v":0.7}]
[{"$nulls":8},"C",-100000,56000,0.56]
[{"$nulls":8},"D",-500000,155000,0.31]
[{"$nulls":8},"E",-300000,88000,0.29333333333333333]
[]
[]
[{"$nulls":8},"הפרויקט הנבחר","PI","סכום ההשקעה","הענ\"נ שמתקבל","הסכום שנותר להשקעה"]
[{"$nulls":8},"B",0.76,150000,114000,{"$f":"I168-K179","v":450000}]
[{"$nulls":8},"A",0.7,50000,35000,{"$f":"M179-K180","v":400000}]
[{"$nulls":8},"C",0.56,100000,56000,{"$f":"M180-K181","v":300000}]
[{"$nulls":8},"D",0.31,{"$f":"M181","v":300000},{"$f":"(K182/(-J174))*K174","v":93000},{"$f":"M181-K182","v":0}]
[{"$nulls":8},"סה\"כ",null,null,{"$f":"SUM(L179:L182)","v":298000}]

{"sheet":"פתרון תרגיל בית שאלות 16-18","index":3,"n_rows":80,"n_cols":11,"rows_kept":80}
[]
[]
[]
[]
[]
[{"$nulls":4},"לפנייך 2 פרוייקטים, מחיר ההון השנתי 8%"]
[null,null,"שאלה 16"]
[{"$nulls":4},"נתונים:"]
[{"$nulls":4},"פרויקט",0,1,2,3,4,5]
[{"$nulls":4},"A",{"v":-64000,"d":"-64,000"},{"v":20000,"d":"20,000"},{"$f":"G10","v":{"v":20000,"d":"20,000"}},{"$f":"H10","v":{"v":20000,"d":"20,000"}},{"$f":"I10","v":{"v":20000,"d":"20,000"}},{"$f":"J10","v":{"v":20000,"d":"20,000"}}]
[{"$nulls":4},"B",{"v":-35000,"d":"-35,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"}]
[]
[{"$nulls":5},{"v":0.08,"d":"8.00%"},"r (year)","נתון",null,"B","A"]
[{"$nulls":9},-35000,-64000]
[{"$nulls":4},"א. חשב את הערך הנוכחי לשני הפרוייקטים",{"$nulls":4},15000,20000]
[{"$nulls":4},"ב. מה שת\"פ הפרוייקטים?",{"$nulls":4},15000,20000]
[{"$nulls":4},"ג. איזה פרוייקט עדיף לפי כל קריטריון?",{"$nulls":4},15000,20000]
[{"$nulls":9},15000,20000]
[{"$nulls":9},15000,20000]
[{"$nulls":8},"NPV",{"$f":"NPV(F13,J15:J19)-35000","v":24890.650556171277},{"$f":"NPV(F13,K15:K19)-64000","v":15854.200741561712}]
[{"$nulls":8},"IRR",{"$f":"IRR(J14:J19)","v":{"v":0.3227253265888068,"d":"32%"}},{"$f":"IRR(K14:K19)","v":{"v":0.16991110392284514,"d":"17%"}}]
{"$rows_empty":17}
[{"$nulls":4},"ידוע כי החברה אדישה לגבי פרויקט C"]
[{"$nulls":4},"נתונים:"]
[null,"שאלה 17",null,null,"פרויקט",0,1,2,3,"IRR","NPV"]
[{"$nulls":4},"A",-700,0,0,900,{"$f":"IRR(H51:H54)","v":{"v":0.0873803730028917,"d":"8.74%"}},{"$f":"NPV(J44,H52:H54)-700","v":14.449016918152552}]
[{"$nulls":4},"B",-1000,0,0,1331,{"$f":"IRR(I51:I54)","v":{"v":0.10000000000000009,"d":"10.00%"}},{"$f":"NPV(J44,I52:I54)-1000","v":56.590712797845526}]
[{"$nulls":4},"C",-1000,1080,null,null,{"$f":"IRR(J51:J52)","v":{"v":0.08000000000000007,"d":"8.00%"}}]
[]
[{"$nulls":4},"א. חשב את הערך הנוכחי לשני הפרוייקטים הראשונים"]
[{"$nulls":4},"ב. מה שת\"פ הפרוייקטים?"]
[{"$nulls":4},"ג. איזה פרוייקט עדיף לפי כל קריטריון?"]
[]
[{"$nulls":7},"A","B","C"]
[{"$nulls":7},-700,-1000,-1000]
[{"$nulls":7},0,0,1080]
[{"$nulls":7},0,0]
[{"$nulls":7},900,1331]
{"$rows_empty":16}
[{"$nulls":4},"לפנייך הפרויקט הבא:"]
[]
[null,"שאלה 18",null,null,"פרויקט",0,1,2]
[{"$nulls":4},"A",-42,94,48]
[{"$nulls":9},"A"]
[{"$nulls":4},"א. חשב את שת\"פ הפרויקט",{"$nulls":4},-42]
[{"$nulls":4},"ב. האם בריבית של 20% הפרויקט רווחי?",{"$nulls":4},94]
[{"$nulls":9},48]
[{"$nulls":9},{"$f":"IRR(J76:J78)","v":{"v":1.666666666666666,"d":"167%"}},"IRR"]
[{"$nulls":7},{"v":1.7,"d":"170.00%"},null,{"$f":"NPV(H80,J77:J78)-42","v":-0.6008230452674965},"NPV"]