What is the present value of a stream of 5 end-of-year annual cash receipts of $900 given a discount rate of 9% (Round your final answers to 2 decimal places.) a. Use the appropriate table (Appendix C Table 1. Table 2) to answer the above question b Use the appropriate built-in function in Excel to answer the above question PV of annuity PV of annuity b. 96 968 T 2560 961 % 25% 0080 E + 10% 0909 0826 0.751 0.683 0621 13% 0885 0.783 0.693 0613 0.543 15% 0.870 0.756 0658 0.872 0.497 OSEO 9 1950 0.450 0.432 0513 0,467 0.424 7% 0.935 0.873 0816 0.763 0.713 0.666 0623 0.582 0.544 0508 0.475 04 0415 0.388 0362 0339 0.317 0.296 TABLE 1 Present Value of S1 Periods 5% 6% 1 0962 0943 2 0.925 0907 0.890 3 0.889 0.864 0.840 4 0.855 0833 0.792 5 0.822 0.784 0.747 6 0.790 0.746 0.705 0.760 0.711 0665 8 0731 0627 0.627 9 0.703 0.645 0.592 10 0.676 0.614 0 558 11 0.650 0.583 0 527 12 0625 0.557 0.497 13 0 530 0.469 14 0.577 0.442 15 0.481 0417 16 0.534 0.458 0.394 17 0.513 0.436 0371 18 0.494 0.416 0.350 19 0.475 0396 0.331 20 0.456 0372 0.312 22 0.422 0342 24 0.390 0.310 0.247 25 0.375 0.295 0.233 30 030R 0.231 0 174 35 0.253 0.181 0.130 0.208 0.142 0.097 6 11% 0901 0812 0.731 0.659 0.593 0.535 0.482 0.434 0.391 0.352 0317 0.286 0.258 0.232 0.209 0.188 0.170 129 0893 0.797 0.712 0.636 0.367 0507 0.452 0.404 0.361 0.322 0.287 0.257 0.229 0.205 0.926 0.857 0.794 0.735 0681 0630 0.583 0.540 0 500 0.463 0.429 0397 0.368 0340 0315 0.192 0.270 0.250 0232 0.215 0.184 0.158 0.146 0.099 0.068 0016 99 0917 0842 0.772 0.708 0.650 0.596 0.542 0 502 0.460 0.422 0388 0.356 0.326 0.299 0.275 0.252 0.231 0.212 0.194 0.178 0 0.126 0.116 0.075 0.049 0032 98EO 0.877 0769 0.675 0592 0519 0.456 0.400 0351 0308 0270 0.237 0208 0.182 0.160 0.140 0123 3096 0.769 0.592 0.455 0 0.269 0.207 0.159 0.123 0.094 0.073 0.056 0043 0033 1090 0.425 0376 0.333 0.295 0.261 0.231 0204 0.181 0.160 0 141 0.125 0.111 0098 20% 0833 0694 0579 0.182 0.402 0335 0279 0233 0.194 0.162 0135 0.112 0.093 0078 0.065 0054 0.045 0.038 0.031 0.026 0018 0013 0.610 O S12 0.410 0328 0.262 0210 0.168 0134 0107 0.086 0.069 0.055 0044 0.035 0.028 0.023 0.018 0.014 0.012 0.007 0.003 0.004 SOS O SZOO SSSO 0350 0.319 0.290 0.263 0239 0218 0.198 0.180 0.164 0.149 0123 0.102 0.092 0037 0036 0.022 0.183 0376 0.327 0284 0.247 0.215 0.187 0.163 0.141 0.123 0.102 0.093 0.081 0.070 0.061 0.046 0035 0030 0015 0.008 0.004 8010 0.020 0.015 0012 0.009 0.007 ESTO 0277 2800 5000 0278 OSTO 0258 0.226 0.197 0.184 0.131 0.163 0.146 0.130 0.116 0.101 0.083 0066 0.059 0033 0019 0011 0.138 0.124 0.101 0082 0.074 0.044 0.026 0.015 O 0 095 0.083 0.073 0.056 0043 0.038 0020 0.010 0.005 0.068 0.053 0017 0.026 0.014 oto 0 0.003 0.002 0.001 0.000 0.000 0.000 1000 1600 DI 0.001 0.002 0001 0 000 0.000 8000 0.067 OF Na The present Valve PV) Dactor for pademoder per period 1 (1+" Forecample, the Poor 10 years 1-(1+0.107-0621 Gred) % % 10% 15% 6060 0.800 1.440 2624 9% 0917 1.759 2531 3.240 3.890 4486 5.033 1736 2.487 3170 2561 1496 0.87 1647 2322 2914 3.433 3.899 4283 4.639 9 20% 0.833 1528 2.106 2589 2.991 3326 3605 TOLE SSE 11% 0.901 1.713 2/444 3.102 3.696 4.231 4.712 5.146 5.337 5889 6.207 6:492 6.750 6.982 866 12% 0.893 1690 2402 3.037 3603 4111 4564 4968 5328 5.650 5.938 6 194 6.424 6628 6811 SESS LESE TABLE 2 Present Value of Annuity of S1 Periods 4% 5 7% 896 1 0962 0.952 0.943 0935 0.926 2 1.886 1.859 1833 1.808 1783 3 2.775 2723 2673 2577 4 3.630 3546 3.463 3387 3312 $ 4.452 4.329 4.212 4 100 3993 5.242 5.076 4917 4.767 4.623 7 6.002 5.786 5582 5389 5.206 S 6.733 6.463 6210 5.971 5.747 9 7435 7108 6.802 6.515 6.247 10 8.111 7.722 7.360 7024 6,710 11 8.760 8.306 7.887 7.499 7139 12 9385 8.863 8.384 7.943 7.536 13 9.986 9.394 8358 7.904 14 10 563 9.899 9.295 8.745 8.244 15 11 118 10 380 9.712 9108 8559 16 11.652 10.838 10.106 9.447 8.851 17 12.166 11.274 10.477 9.763 9.122 18 12.659 11 690 10.828 10.059 9372 19 13.134 12085 11.158 10 336 9.604 20 13. 590 12.462 11 470 10.594 9.818 22 14.451 13.163 12,042 11061 10.201 24 15.247 13.799 12550 11.469 10 529 25 15.622 14.094 12.783 11 654 10.675 30 17.292 15.372 13.765 12.409 11.258 35 18.663 16374 14.498 12948 11655 40 19.793 17.159 15.046 13.332 11 925 916+ + 13 0.885 1668 2361 2974 3.517 3.998 4423 4.799 5.132 5:426 5,687 3918 6 122 6302 6462 6604 6.729 6.840 6.938 5.216 5453 5.660 5842 8.853 2362 2.689 2.951 3.161 3329 3.463 3.571 3656 3.725 3.780 3.824 3.859 3.887 3.910 9 15% 0.870 1626 2283 2855 3352 3.784 4.160 4487 4.772 5019 5234 5.421 5.583 5724 5.847 5.954 6047 6 128 6.198 6.259 6359 6.434 6,464 6.566 6.617 6642 2009 4.868 5335 3.759 6.145 6.495 6.814 7.103 7367 7606 7.824 8.022 8202 8.365 $ 514 8.772 8.985 9.077 9.427 9.644 9.779 7198 3095 0.769 1361 1816 2.166 2.436 2613 2.802 2.925 3.019 3.092 3.147 3.190 3.223 3.249 13.268 3283 3.295 3304 3.311 3.316 3323 3327 3329 3.332 3333 3.333 E 3.995 6418 6.805 7.161 7.487 7.786 8,061 8.313 8.544 8.756 8.950 9.129 9.42 9.707 9.823 10.274 10.567 10.752 4.031 4.192 4327 -1.439 4.533 4611 4615 4.730 4.775 4.812 4843 4870 4.909 4937 1269 7 120 6 7250 3925 SZOL 7379 7549 7.702 7839 7963 8.176 8.348 8.422 8 694 8.855 6 142 6265 6:373 6467 6.550 6.623 6.743 6.835 6873 7.003 7,070 7.105 7366 7469 7.645 7.784 7,843 8.055 3.942 3.954 3970 3.981 3.985 3.995 3.998 3.999 7.170 7283 7330 17.496 7.586 7634 3161 4.919 4992 1 9413 1568 $.244 4997 Note: The presente (PV) muity factor for periods and a rate of per period -1-(1+- For example for 0.10 the PV ty factor - 3 791 ded)