Table B9.2 is Below

Please show all formulas

What is the present value of $850 per year for six years if the required return is 11 percent (using Table B9.2)
				=
What is the present value of $850 per year for six years if the required return is 11 percent (using Excel's PV function).
	Rate
	Number of periods
	Payments
	Future value
	Type
	PV
Explanation of any differences between the answers using the two approaches.
What-if?
Consider the following after you have completed the requirements of E9-3.
1. Assume the annual payment is $950 rather than $850. Recompute the present value.
	Rate
	Number of periods
	Payments
	Future value
	Type
	PV
2. Calculate the difference between your answer to the original question and part 1 of the what-if section.
	Difference
3. Explain why the difference in part 2 is not equal to difference in the two payments of $100.

TABLE B9.2 Present value of an annuity of $1 per period

6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 16% 20% 30%

0.9434 0.9346 0.9259 0.9174 0.9091 0.9009 0.8929 0.8850 0.8772 0.8696 0.8621 0.8333 0.7692 1.8334 1.8080 1.7833 1.7591 1.7355 1.7125 1.6901 1.6681 1.6467 1.6257 1.6052 1.5278 1.3609 2.6730 2.6243 2.5771 2.5313 2.4869 2.4437 2.4018 2.3612 2.3216 2.2832 2.2459 2.1065 1.8161 3.4651 3.3872 3.3121 3.2397 3.1699 3.1024 3.0373 2.9745 2.9137 2.8550 2.7982 2.5887 2.1662 4.2124 4.1002 3.9927 3.8897 3.7908 3.6959 3.6048 3.5172 3.4331 3.3522 3.2743 2.9906 2.4356 4.9173 4.7665 4.6229 4.4859 4.3553 4.2305 4.1114 3.9975 3.8887 3.7845 3.6847 3.3255 2.6427 5.5824 5.3893 5.2064 5.0330 4.8684 4.7122 4.5638 4.4226 4.2883 4.1604 4.0386 3.6046 2.8021 6.2098 5.9713 5.7466 5.5348 5.3349 5.1461 4.9676 4.7988 4.6389 4.4873 4.3436 3.8372 2.9247 6.8017 6.5152 6.2469 5.9952 5.7590 5.5370 5.3282 5.1317 4.9464 4.7716 4.6065 4.0310 3.0190 7.3601 7.0236 6.7101 6.4177 6.1446 5.8892 5.6502 5.4262 5.2161 5.0188 4.8332 4.1925 3.0915 7.8869 7.4987 7.1390 6.8052 6.4951 6.2065 5.9377 5.6869 5.4527 5.2337 5.0286 4.3271 3.1473 8.3838 7.9427 7.5361 7.1607 6.8137 6.4924 6.1944 5.9176 5.6603 5.4206 5.1971 4.4392 3.1903 8.8527 8.3577 7.9038 7.4869 7.1034 6.7499 6.4235 6.1218 5.8424 5.5831 5.3423 4.5327 3.2233 9.2950 8.7455 8.2442 7.7862 7.3667 6.9819 6.6282 6.3025 6.0021 5.7245 5.4675 4.6106 3.2487 9.7122 9.1079 8.5595 8.0607 7.6061 7.1909 6.8109 6.4624 6.1422 5.8474 5.5755 4.6755 3.2682 10.1059 9.4466 8.8514 8.3126 7.8237 7.3792 6.9740 6.6039 6.2651 5.9542 5.6685 4.7296 3.2832 10.4773 9.7632 9.1216 8.5436 8.0216 7.5488 7.1196 6.7291 6.3729 6.0472 5.7487 4.7746 3.2948 10.8276 10.0591 9.3719 8.7556 8.2014 7.7016 7.2497 6.8399 6.4674 6.1280 5.8178 4.8122 3.3037 11.1581 10.3356 9.6036 8.9501 8.3649 7.8393 7.3658 6.9380 6.5504 6.1982 5.8775 4.8435 3.3105 11.4699 10.5940 9.8181 9.1285 8.5136 7.9633 7.4694 7.0248 6.6231 6.2593 5.9288 4.8696 3.3158