problems30
USING DATA TABLE TO GRAPH A FUNCTIONx 3f(x) 6 - =3*B22-2*B2-15x 6 - =B3, data table header-6 105-5 70-4 41-3 18-2 1-1 -100 -151 -142 -73 64 255 506 817 118Finding the zeros: If you set x positive (say, x = 5), then Solver will find thefirst zero. If you set x negative (say x = -3), Solver will find the second zeroFirst zerox 2.59411f(x) -7.9E-07Second zerox -1.92744f(x) -3.7E-07These answers were inserted by copying the Solver resultsand using Paste Special|Values.86420-2-4-6-8-3 003 06 09 01 2 01 5 0A B C D E F G H I12345678910111213141516171819202122232425262728293031323334J12345678910111213141516171819202122232425262728293031323334利用模拟运算表对一个函数作图x 3f(x) 6 - =3*B22-2*B2-15x 6 - =B3, data table header-6 105-5 70-4 41-3 18-2 1-1 -100 -151 -142 -73 64 255 506 817 118Finding the zeros: If you set x positive (say, x = 5), then Solver will find thefirst zero. If you set x negative (say x = -3), Solver will find the second zeroFirst zerox 2.59411f(x) -7.9E-07Second zerox -1.92744f(x) -3.7E-07These answers were inserted by copying the Solver resultsand using Paste Special|Values.86420-2-4-6-8-3 003 06 09 01 2 01 5 0A B C D E F G H I12345678910111213141516171819202122232425262728293031323334J12345678910111213141516171819202122232425262728293031323334DATA TABLE AND PVRate 15%Number of periods 15Payment -10 To get a positive PV, we let the payment be negative (see Chapters 1 & 34)Present value $58.47 - =PV(B2,B3,B4)Rate $58.47 - =B5, data table header0% 150.002% 128.494% 111.186% 97.128% 85.5910% 76.0612% 68.1114% 61.4216% 55.7518% 50.9220% 46.752 0 %1 5 %1 0 %5 %0 %05 01 0 01 5 02 0 0A B C D E F123456789101112131415161718192021DATA TABLE AND PVTo get a positive PV, we let the payment be negative (see Chapters 1 & 34)2 0 %1 5 %1 0 %5 %0 %05 01 0 01 5 02 0 0G H123456789101112131415161718192021模拟运算表与 PV利率 15%期数 15付款 -10为得到一个正的PV,我们让付款为负数(见章1和34)。现值 $58.47 - =PV(B2,B3,B4)利率 $58.47 - =B5, 模拟运算表表头0% 150.002% 128.494% 111.186% 97.128% 85.5910% 76.0612% 68.1114% 61.4216% 55.7518% 50.9220% 46.752 0 %1 5 %1 0 %5 %0 %05 01 0 01 5 02 0 0A B C D E F123456789101112131415161718192021模拟运算表与 PV2 0 %1 5 %1 0 %5 %0 %05 01 0 01 5 02 0 0G H123456789101112131415161718192021NPV, DISCOUNT AND GROWTH RATESGrowth rate 10%Discount rate 15%Cost 500Year 1 cash flow 100Year 0 1 2 3 4 5Cash flow -500.00 100.00 110.00 121.00 133.10 146.41NPV -101.42 - =NPV(B3,C8:G8)+B8IRR 6.60% - =IRR(B8:G8) Cell B15 contains the data tablefunction =B10Growth($101.42) 0% 3% 6% 9% 12%0% 0.00 30.91 63.71 98.47 135.28Discount rate 3% -42.03 -14.56 14.55 45.38 78.016% -78.76 -54.26 -28.30 -0.84 28.219% -111.03 -89.08 -65.85 -41.28 -15.3312% -139.52 -119.78 -98.91 -76.86 -53.5715% -164.78 -146.97 -128.15 -108.28 -87.3218% -187.28 -171.15 -154.13 -136.16 -117.2321% -207.40 -192.75 -177.30 -161.01 -143.8424% -225.46 -212.11 -198.04 -183.22 -167.62A B C D E F G H123456789101112131415161718192021222324NPV, 折现率与增长率增长率 10%折现率 15%成本 500年1,现金流 100年 0 1 2 3 4 5现金流 -500.00 100.00 110.00 121.00 133.10 146.41NPV -101.42 - =NPV(B3,C8:G8)+B8IRR 6.60% - =IRR(B8:G8) Cell B15 含有模拟运算表函数=B10增长率($101.42) 0% 3% 6% 9% 12%0% 0.00 30.91 63.71 98.47 135.28折现率 3% -42.03 -14.56 14.55 45.38 78.016% -78.76 -54.26 -28.30 -0.84 28.219% -111.03 -89.08 -65.85 -41.28 -15.3312% -139.52 -119.78 -98.91 -76.86 -53.5715% -164.78 -146.97 -128.15 -108.28 -87.3218% -187.28 -171.15 -154.13 -136.16 -117.2321% -207.40 -192.75 -177.30 -161.01 -143.8424% -225.46 -212.11 -198.04 -183.22 -167.62A B C D E F G H123456789101112131415161718192021222324TWO-DIMENSIONAL DATA TABLE-3-DIMENSIONAL GRAPHx 1y 2Sin(x*y) 0.909297 - =SIN(B2*B3)Data table0.909297 0 0.2 0.4 0.6 0.8 10 0 0 0 0 0 00.2 0 0.039989 0.079915 0.119712 0.159318 0.1986690.4 0 0.079915 0.159318 0.237703 0.314567 0.3894180.6 0 0.119712 0.237703 0.352274 0.461779 0.5646420.8 0 0.159318 0.314567 0.461779 0.597195 0.7173561 0 0.198669 0.389418 0.564642 0.717356 0.8414711.2 0 0.237703 0.461779 0.659385 0.819192 0.9320391.4 0 0.276356 0.531186 0.744643 0.9001 0.985451.6 0 0.314567 0.597195 0.819192 0.958016 0.9995741.8 0 0.352274 0.659385 0.881958 0.991458 0.9738482 0 0.389418 0.717356 0.932039 0.999574 0.9092971.2 1.4 1.6 1.8 20 0 0 0 00.237703 0.276356 0.314567 0.352274 0.3894180.461779 0.531186 0.597195 0.659385 0.7173560.659385 0.744643 0.819192 0.881958 0.9320390.819192 0.9001 0.958016 0.991458 0.9995740.932039 0.98545 0.999574 0.973848 0.9092970.991458 0.994043 0.939645 0.831383 0.6754630.994043 0.925212 0.784316 0.582331 0.3349880.939645 0.784316 0.549355 0.258619 -0.058370.831383 0.582331 0.258619 -0.09825 -0.442520.675463 0.334988 -0.05837 -0.44252 -0.7568二维模拟运算表-三维图x 1y 2Sin(x*y) 0.909297 - =SIN(B2*B3)模拟运算表0.909297 0 0.2 0.4 0.6 0.8 10 0 0 0 0 0 00.2 0 0.039989 0.079915 0.119712 0.159318 0.1986690.4 0 0.079915 0.159318 0.237703 0.314567 0.3894180.6 0 0.119712 0.237703 0.352274 0.461779 0.5646420.8 0 0.159318 0.314567 0.461779 0.597195 0.7173561 0 0.198669 0.389418 0.564642 0.717356 0.8414711.2 0 0.237703 0.461779 0.659385 0.819192 0.9320391.4 0 0.276356 0.531186 0.744643 0.9001 0.985451.6 0 0.314567 0.597195 0.819192 0.958016 0.9995741.8 0 0.352274 0.659385 0.881958 0.991458 0.9738482 0 0.389418 0.717356 0.932039 0.999574 0.9092971.2 1.4 1.6 1.8 20 0 0 0 00.237703 0.276356 0.314567 0.352274 0.3894180.461779 0.531186 0.597195 0.659385 0.7173560.659385 0.744643 0.819192 0.881958 0.9320390.819192 0.9001 0.958016 0.991458 0.9995740.932039 0.98545 0.999574 0.973848 0.9092970.991458 0.994043 0.939645 0.831383 0.6754630.994043 0.925212 0.784316 0.582331 0.3349880.939645 0.784316 0.549355 0.258619 -0.058370.831383 0.582331 0.258619 -0.09825 -0.442520.675463 0.334988 -0.05837 -0.44252 -0.7568