If you invest $10,000 per period for the following number of periods, how much would you have received at the end? Use Appendix C. (Round "Factor" to 3 decimal places. Round the final answers to the nearest whole dollar.)

a. 9 years at 10 percent

Future value $

b. 20 years at 8 percent

Future value $

c. 24 periods at 10 percent

Future value $

You invest a single amount of $15,700 for 7 years at 15 percent. At the end of 7 years you take the proceeds and invest them for 13 years at 16 percent.

How much will you have after 20 years? Use Appendix A. (Round "FV Factor" to 3 decimal places. Round the final answer to the nearest whole dollar.)

Future value $

At a growth (interest) rate of 7 percent annually, how long will it take for a sum to double? To triple? Use Appendix A. (Round the final answers to the nearest whole year.)

Time taken to double	7 7 Incorrect	years
Time taken to triple	13 13 Incorrect	years

You will receive $9,000 three years from now. The discount rate is 13 percent. Use Appendix B.

a. What is the value of your investment two years from now? (Round your answer to 2 decimal places.)

Value of investment

b. What is the value of your investment one year from now? (Round your answer to 2 decimal places.)

Value of investment

APPENDIX C Future Value of an Annuity of $1, FV... FV = A(+1=+ Period 1......... 2......... 3......... 6......... 7......... 8......... 9......... 10....... 11 ....... 12........ 13........ 14........ 15........ 16........ 17..... 18. 1% 1.000 2.010 3.030 4.060 5.101 6.152 7.214 8.286 9.369 10.462 11.567 12.683 13.809 14.947 16.097 17.258 18.430 19.615 20.811 22.019 28.243 34.785 48.886 64.463 2% 1.000 2.020 3.060 4.122 5.204 6.308 7.434 8.583 9.755 10.950 12.169 13.412 14.680 15.974 17.293 18.639 20.012 21.412 22.841 24.297 32.030 40.588 60.402 84.579 3% 1.000 2.030 3.091 4.184 5.309 6.468 7.662 8.892 10.159 11.464 12.808 14.192 15.618 17.086 18.599 20.157 21.762 23.414 25.117 26.870 36.459 47.575 75.401 112.80 4% 1.000 2.040 3.122 4.246 5.416 6.633 7.898 9.214 10.583 12.006 13.486 15.026 16.627 18.292 20.024 21.825 23.698 25.645 27.671 29.778 41.646 56.085 95.026 152.67 5% 1.000 2.050 3.153 4.310 5.526 6.802 8.142 9.549 11.027 12.578 14.207 15.917 17.713 19.599 21.579 23.657 25.840 28.132 30.539 33.066 47.727 66.439 120.80 209.35 Percent 6% 1.000 2.060 3.184 4.375 5.637 6.975 8.394 9.897 11.491 13.181 14.972 16.870 18.882 21.015 23.276 25.673 28.213 30.906 33.760 36.786 54.865 79.058 154.76 290.34 7% 1.000 2.070 3.215 4.440 5.751 7.153 8.654 10.260 11.978 13.816 15.784 17.888 20.141 22.550 25.129 27.888 30.840 33.999 37.379 40.995 63.249 94.461 199.64 406.53 8% 1.000 2.080 3.246 4.506 5.867 7.336 8.923 10.637 12.488 14.487 16.645 18.977 21.495 24.215 27.152 30.324 33.750 37.450 41.446 45.762 73.106 113.28 259.06 573.77 9% 1.000 2.090 3.278 4.573 5.985 7.523 9.200 11.028 13.021 15.193 17.560 20.141 22.953 26.019 29.361 33.003 36.974 41.301 46.018 51.160 84.701 136.31 337.89 815.08 10% 1.000 2.100 3.310 4.641 6.105 7.716 9.487 11.436 13.579 15.937 18.531 21.384 24.523 27.975 31.772 35.950 40.545 45.599 51.159 57.275 98.347 164.49 442.59 1,163.9 11% 1.000 2.110 3.342 4.710 6.228 7.913 9.783 11.859 14.164 16.722 19.561 22.713 26.212 30.095 34.405 39.190 44.501 50.396 56.939 64.203 114.41 199.02 581.83 1.668.8 19..... 20..... 25..... 30..... 40..... 50........ Period 12% 1.000 2.120 3.374 4.779 6.353 8.115 10.089 12.300 14.776 17.549 20.655 24.133 28.029 32.393 37.280 42.753 48.884 55.750 63.440 72.052 133.33 241.33 767.09 2,400.0 13% 1.000 2.130 3.407 4.850 6.480 8.323 10.405 12.757 15.416 18.420 21.814 25.650 29.985 34.883 40.417 46.672 53.739 61.725 70.749 80.947 155.62 293.20 1,013.7 3,459.5 14% 1.000 2.140 3.440 4.921 6.610 8.536 10.730 13.233 16.085 19.337 23.045 27.271 32.089 37.581 43.842 50.980 59.118 68.394 78.969 91.025 181.87 356.79 1,342.0 4,994.5 15% 1.000 2.150 3.473 4.993 6.742 8.754 11.067 13.727 16.786 20.304 24.349 29.002 34.352 40.505 47.580 55.717 65.075 75.836 88.212 102.44 212.79 434.75 1,779.1 7,217.7 16% 1.000 2.160 3.506 5.066 6.877 8.977 11.414 14.240 17.519 21.321 25.733 30.850 36.786 43.672 51.660 60.925 71.673 84.141 98.603 115.38 249.21 530.31 2,360.8 10,436. Percent 17% 1.000 2.170 3.539 5.141 7.014 9.207 11.772 14.773 18.285 22.393 27.200 32.824 39.404 47.103 56.110 66.649 78.979 93.406 110.29 130.03 292.11 647.44 3,134.5 15,090. 18% 19% 1.000 1.000 2.180 2.190 3.572 3.606 5.215 5.291 7.154 7.297 9.442 9.683 12.142 12.523 15.327 15.902 19.086 19.923 23.521 24.701 28.755 30.404 34.931 37.180 42.219 45.244 50.818 54.841 60.965 66.261 72.939 79.850 87.068 96.022 103.74 115.27 123.41 138.17 146.63 165.42 342.60 402.04 790.95 966.7 4,163.215,529.8 21,813. 31,515. 20% 1.000 2.200 3.640 5.368 7.442 9.930 12.916 16.499 20.799 25.959 32.150 39.581 48.497 59.196 72.035 87.442 05.93 128.12 154.74 186.69 471.98 1.181.9 7,343. 9 45,497. 25% 1.000 2.250 3.813 5.766 8.207 11.259 15.073 19.842 25.802 33.253 42.566 54.208 68.760 86.949 109.69 138.11 173.64 218.05 273.56 342.95 1,054.8 3,227.2 30,089. 280,256. 30% 1.000 2.300 3.990 6.187 9.043 12.756 17.583 23.858 32.015 42.619 56.405 74.327 97.625 127.91 167.29 218.47 285.01 371.52 483.97 630.17 2,348.80 8.730.0 120,393 165,976 15. 16... 17. 18.... 19.... 20...... 25...... 30....... 40....... 50......... If annuity in advance, calculate factor with BGN set on calculator Note: Factor calculation with calculator Set PMT - 1 Set PV - 0 Select N -number of required periods Select wy - required interest rate COMP FV -? Excel Spreadsheet FV .n, O, PMT, 0) I = Decimal or % 1 = For beginning of period (5th spoti APPENDIX A Future Value of $1, FV. FV = PV(1 + i)" Period ......... ........ 7% 1.070 1.145 1.225 1.311 1.403 1.501 1% 1.010 1.020 1.030 1.041 1.051 1.062 1.072 1.083 1.094 1.105 1.116 1.127 1.138 1.149 1.161 1.173 1.184 1.196 1.208 1.220 1.282 1.348 1.489 1.645 2% 1.020 1.040 1.061 1.082 1.104 1.126 1.149 1.172 1.195 1.219 1.243 1.268 1.294 1.319 1.346 1.373 1.400 1.428 1.457 1.486 1.641 1.811 2.208 2.692 3% 1.030 1.061 1.093 1.126 1.159 1.194 1.230 1.267 1.305 1.344 1.384 1.426 1.469 1.513 1.558 1.605 1.653 1.702 1.754 1.806 2.094 2.427 3.262 4.384 4% 1.040 1.082 1.125 1.170 1.217 1.265 1.316 1.369 1.423 1.480 1.539 1.601 1.665 1.732 1.801 1.873 1.948 2.026 2.107 2.191 2.666 3.243 4.801 7.107 5% 1.050 1.103 1.158 1.216 1.276 1.340 1.407 1.477 1.551 1.629 1.710 1.796 1.886 1.980 2.079 2.183 2.292 2.407 2.527 2.653 3.386 4.322 7.040 11.467 Percent 6% 1.060 1.124 1.191 1.262 1.338 1.419 1.504 1.594 1.689 1.791 1.898 2.012 2.133 2.261 2.397 2.540 2.693 2.854 3.026 3.207 4.292 5.743 10.286 18.420 8% 1.080 1.166 1.260 1.360 1.469 1.587 1.714 1.851 1.999 2.159 2.332 2.518 2.720 2.937 3.172 3.426 3.700 3.996 4.316 4.661 6.848 10.063 21.725 46.902 9% 1.090 1.188 1.295 1.412 1.539 1.677 1.828 1.993 2.172 2.367 2.580 2.813 3.066 3.342 3.642 3.970 4.328 4.717 5.142 5.604 8.623 13.268 31.409 7 4.358 1.606 1.718 1.838 1.967 2.105 2.252 2.410 2.579 2.759 2.952 3.159 3.380 3.617 3.870 5.427 7.612 14.974 29.457 10% 1.100 1.210 1.331 1.464 1.611 1.772 1.949 2.144 2.358 2.594 2.853 3.138 3.452 3.797 4.177 4.595 5.054 5.560 6.116 6.727 10.835 17.449 45.259 117.39 11% 1.110 1.232 1.368 1.518 1.685 1.870 2.076 2.305 2.558 2.839 3.152 3.498 3.883 4.310 4.785 5.311 5.895 6.544 7.263 8.062 13.585 22.892 65.001 184.57 ........ 16....... 50........ Period 16% 1.160 1.346 1.561 1.811 2.100 2.436 2.826 3.278 Percent 17% 1.170 1.369 1.602 1.874 2.192 2.565 3.001 20% 1.200 1.440 1.728 2.074 2.488 2.986 3.583 4.300 3.511 3.803 5.160 12% 1.120 1.254 1.405 1.574 1.762 1.974 2.211 2.476 2.773 3.106 3.479 3.896 4.363 4.887 5.474 6.130 6.866 7.690 8.613 9.646 17.000 29.960 93.051 289.00 13% 1.130 1.277 1.443 1.630 1.842 2.082 2.353 2.658 3.004 3.395 3.836 4.335 4.898 5.535 6.254 7.067 7.986 9.024 10.197 11.523 21.231 39.116 132.78 450.74 14% 1.140 1.300 1.482 1.689 1.925 2.195 2.502 2.853 3.252 3.707 4.226 4.818 5.492 6.261 7.138 8.137 9.276 10.575 12.056 13.743 26.462 50.950 188.88 700.23 15% 1.150 1.323 1.521 1.749 2.011 2.313 2.660 3.059 3.518 4.046 4.652 5.350 6.153 7.076 8.137 9.358 10.761 12.375 14.232 16.367 32.919 66.212 267.86 1.083.7 4.411 5.117 5.936 6.886 7.988 9.266 10.748 12.468 14.463 16.777 19.461 40.874 85.850 378.72 1.670.7 18% 1.180 1.392 1.643 1.939 2.288 2.700 3.185 3.759 4.435 5.234 6.176 7.288 8.599 10.147 11.974 14.129 16.672 19.673 23.214 27.393 62.669 143.37 750.38 3,927.4 4.108 4.807 5.624 6.580 7.699 9.007 10.539 12.330 14.426 16.879 19.748 23.106 50.658 111.07 533.87 2,566.2 19% 1.190 1.416 1.685 2.005 2.386 2.840 3.379 4.021 4.785 5.696 6.777 8.064 9.596 11.420 13.590 16.172 19.244 22.091 27.252 32.429 77.388 184.68 1,051.7 5,988.9 :::::::: 25% 1.250 1.563 1.953 2.441 3.052 3.815 4.768 5.960 7.451 9.313 11.642 14.552 18.190 22.737 28.422 35.527 44.409 55.511 69.389 86.736 264.70 807.79 7,523.2 70,065. 6.192 7.430 8.916 10.699 12.839 15.407 18.488 22.186 26.623 31.948 38.338 95.396 237.38 1,469.8 9,100.4 30% 1.300 1.690 2.197 2.856 3.713 4.827 6.276 8.157 10.604 13.786 17.922 23.298 30.288 39.374 51.186 66.542 86.504 112.46 146.19 190.05 705.64 2,620.0 36,119. 497,929. ...... Note: Factor calculation with calculator Set PV-1 Set PMT -0 Solect N = number of required periods Select MY = required Interest rate COMP FV - ? Excel Spreadsheet FVn, O, PV, O) I=Decimal or 1- For beginning of period (5th spot) APPENDIX A Future Value of $1, FV. FV = PV(1 + i)" Period ......... ........ 7% 1.070 1.145 1.225 1.311 1.403 1.501 1% 1.010 1.020 1.030 1.041 1.051 1.062 1.072 1.083 1.094 1.105 1.116 1.127 1.138 1.149 1.161 1.173 1.184 1.196 1.208 1.220 1.282 1.348 1.489 1.645 2% 1.020 1.040 1.061 1.082 1.104 1.126 1.149 1.172 1.195 1.219 1.243 1.268 1.294 1.319 1.346 1.373 1.400 1.428 1.457 1.486 1.641 1.811 2.208 2.692 3% 1.030 1.061 1.093 1.126 1.159 1.194 1.230 1.267 1.305 1.344 1.384 1.426 1.469 1.513 1.558 1.605 1.653 1.702 1.754 1.806 2.094 2.427 3.262 4.384 4% 1.040 1.082 1.125 1.170 1.217 1.265 1.316 1.369 1.423 1.480 1.539 1.601 1.665 1.732 1.801 1.873 1.948 2.026 2.107 2.191 2.666 3.243 4.801 7.107 5% 1.050 1.103 1.158 1.216 1.276 1.340 1.407 1.477 1.551 1.629 1.710 1.796 1.886 1.980 2.079 2.183 2.292 2.407 2.527 2.653 3.386 4.322 7.040 11.467 Percent 6% 1.060 1.124 1.191 1.262 1.338 1.419 1.504 1.594 1.689 1.791 1.898 2.012 2.133 2.261 2.397 2.540 2.693 2.854 3.026 3.207 4.292 5.743 10.286 18.420 8% 1.080 1.166 1.260 1.360 1.469 1.587 1.714 1.851 1.999 2.159 2.332 2.518 2.720 2.937 3.172 3.426 3.700 3.996 4.316 4.661 6.848 10.063 21.725 46.902 9% 1.090 1.188 1.295 1.412 1.539 1.677 1.828 1.993 2.172 2.367 2.580 2.813 3.066 3.342 3.642 3.970 4.328 4.717 5.142 5.604 8.623 13.268 31.409 7 4.358 1.606 1.718 1.838 1.967 2.105 2.252 2.410 2.579 2.759 2.952 3.159 3.380 3.617 3.870 5.427 7.612 14.974 29.457 10% 1.100 1.210 1.331 1.464 1.611 1.772 1.949 2.144 2.358 2.594 2.853 3.138 3.452 3.797 4.177 4.595 5.054 5.560 6.116 6.727 10.835 17.449 45.259 117.39 11% 1.110 1.232 1.368 1.518 1.685 1.870 2.076 2.305 2.558 2.839 3.152 3.498 3.883 4.310 4.785 5.311 5.895 6.544 7.263 8.062 13.585 22.892 65.001 184.57 ........ 16....... 50........ Period 16% 1.160 1.346 1.561 1.811 2.100 2.436 2.826 3.278 Percent 17% 1.170 1.369 1.602 1.874 2.192 2.565 3.001 20% 1.200 1.440 1.728 2.074 2.488 2.986 3.583 4.300 3.511 3.803 5.160 12% 1.120 1.254 1.405 1.574 1.762 1.974 2.211 2.476 2.773 3.106 3.479 3.896 4.363 4.887 5.474 6.130 6.866 7.690 8.613 9.646 17.000 29.960 93.051 289.00 13% 1.130 1.277 1.443 1.630 1.842 2.082 2.353 2.658 3.004 3.395 3.836 4.335 4.898 5.535 6.254 7.067 7.986 9.024 10.197 11.523 21.231 39.116 132.78 450.74 14% 1.140 1.300 1.482 1.689 1.925 2.195 2.502 2.853 3.252 3.707 4.226 4.818 5.492 6.261 7.138 8.137 9.276 10.575 12.056 13.743 26.462 50.950 188.88 700.23 15% 1.150 1.323 1.521 1.749 2.011 2.313 2.660 3.059 3.518 4.046 4.652 5.350 6.153 7.076 8.137 9.358 10.761 12.375 14.232 16.367 32.919 66.212 267.86 1.083.7 4.411 5.117 5.936 6.886 7.988 9.266 10.748 12.468 14.463 16.777 19.461 40.874 85.850 378.72 1.670.7 18% 1.180 1.392 1.643 1.939 2.288 2.700 3.185 3.759 4.435 5.234 6.176 7.288 8.599 10.147 11.974 14.129 16.672 19.673 23.214 27.393 62.669 143.37 750.38 3,927.4 4.108 4.807 5.624 6.580 7.699 9.007 10.539 12.330 14.426 16.879 19.748 23.106 50.658 111.07 533.87 2,566.2 19% 1.190 1.416 1.685 2.005 2.386 2.840 3.379 4.021 4.785 5.696 6.777 8.064 9.596 11.420 13.590 16.172 19.244 22.091 27.252 32.429 77.388 184.68 1,051.7 5,988.9 :::::::: 25% 1.250 1.563 1.953 2.441 3.052 3.815 4.768 5.960 7.451 9.313 11.642 14.552 18.190 22.737 28.422 35.527 44.409 55.511 69.389 86.736 264.70 807.79 7,523.2 70,065. 6.192 7.430 8.916 10.699 12.839 15.407 18.488 22.186 26.623 31.948 38.338 95.396 237.38 1,469.8 9,100.4 30% 1.300 1.690 2.197 2.856 3.713 4.827 6.276 8.157 10.604 13.786 17.922 23.298 30.288 39.374 51.186 66.542 86.504 112.46 146.19 190.05 705.64 2,620.0 36,119. 497,929. ...... Note: Factor calculation with calculator Set PV-1 Set PMT -0 Solect N = number of required periods Select MY = required Interest rate COMP FV - ? Excel Spreadsheet FVn, O, PV, O) I=Decimal or 1- For beginning of period (5th spot) APPENDIX B Present Value of $1,PV) PV = Fvlat = FV(1 + i)- Period 9% 0.917 0.842 0.772 0.708 1% 0.990 0.980 0.971 0.961 0.951 0.942 0.933 0.923 0.914 0.905 0.896 0.887 0.879 0.870 0.861 0.853 0.844 0.836 0.828 0.820 0.780 0.742 0.672 0.608 2% 0.980 0.961 0.942 0.924 0.906 0.888 0.871 0.853 0.837 0.820 0.804 0.788 0.773 0.758 0.743 0.728 0.714 0.700 0.686 0.673 0.610 0.552 0.453 0.372 3% 0.971 0.943 0.915 0.885 0.863 0.837 0.813 0.789 0.766 0.744 0.722 0.701 0.681 0.661 0.642 0.623 0.605 0.587 0.570 0.554 0.478 0.412 0.307 0.228 4% 0.962 0.925 0.889 0.855 0.822 0.790 0.760 0.731 0.703 0.676 0.650 0.625 0.601 0.577 0.555 0.534 0.513 0.494 0.475 0.456 0.375 0.308 0.208 0.141 5% 0.952 0.907 0.864 0.823 0.784 0.746 0.711 0.677 0.645 0.614 0.585 0.557 0.530 0.505 0.481 0.458 0.436 0.416 0.396 0.377 0.295 0.231 0.142 0.087 Percent 6% 0.943 0.890 0.840 0.792 0.747 0.705 0.665 0.627 0.592 0.558 0.527 0.497 0.469 0.442 0.417 0.394 0.371 0.350 0.331 0.312 0.233 0.174 0.097 0.054 7% 0.935 0.873 0.816 0.763 0.713 0.666 0.623 0.582 0.544 0.508 0.475 0.444 0.415 0.388 0.362 0.339 0.317 0.296 0.277 0.258 0.184 0.131 0.067 0.034 8% 0.926 0.857 0.794 0.735 0.681 0.630 0.583 0.540 0.500 0.463 0.429 0.397 0.368 0.340 0.315 0.292 0.270 0.250 0.232 0.215 0.146 0.099 0.046 0.021 10% 0.909 0.826 0.751 0.683 0.621 0.564 0.513 0.467 0.424 0.386 0.350 0.319 0.290 0.263 0.239 0.218 0.198 0.180 0.164 0.149 0.092 0.057 0.022 0.009 0.650 0.596 0.547 0.502 0.460 0.422 0.388 0.356 0.326 0.299 0.275 0.252 0.231 0.212 0.194 0.178 0.116 0.075 0.032 0.013 11% 0.901 0.812 0.731 0.659 0.593 0.535 0.482 0.434 0.391 0.352 0.317 0.286 0.258 0.232 0.209 0.188 0.170 0.153 0.138 0.124 0.074 0.044 0.015 0.005 ..... .... ........ Period 0 ... 10. ....... 12% 0.893 0.797 0.712 0.636 0.567 0.507 0.452 0.404 0.361 0.322 0.287 0.257 0.229 0.205 0.183 0.163 0.146 0.130 0.116 0.104 0.059 0.033 0.011 0.003 0 13% 0.885 0.783 0.693 0.613 0.543 0.480 0.425 0.376 0.333 0.295 0.261 0.231 0.204 0.181 0.160 0.141 0.125 0.111 0.098 0.087 0.047 0.026 0.008 0.002 14% 0.877 0.769 0.675 0.592 519 0.456 0.400 0.351 0.300 0.270 0.237 0.208 0.182 0.160 0.140 0.123 0.108 0.095 0.083 0.073 0.038 0.020 0.005 0.001 15% 0.870 0.756 0.658 0.572 0.497 0.432 0.376 0.327 0.284 0.247 0.215 0.187 0.163 0.141 0.123 0.107 0.093 0.081 0.070 0.061 0.030 0.015 0.004 0.001 16% 0.862 0.743 0.641 0.552 0.476 0.410 0.354 0.305 0.263 0.227 0.195 0.168 0.145 0.125 0.108 0.093 0.080 0.069 0.060 0.051 0.024 0.012 0.003 0.001 0 Percent 17% 18% 0.855 0.847 0.731 0.718 0.624 0.609 0.534 0.515 0.456 0.437 0.390 0.370 0.333 0.314 0.285 0.266 0.243 0.225 0.208 0.191 0.178 0.162 0.152 0.137 0.130 0.116 0.111 0.099 0.095 0.084 0.081 0.071 0.069 0.060 0.059 0.051 0.051 0.043 0.043 0.037 0.0200.016 0.0090.007 0.002 0.001 0 19% 20% 0.840 0.833 0.706 0.694 0.593 0.579 0.499 0.482 0.419 0.402 0.352 0.335 0.296 0.279 0.2490.233 0.209 0.194 .176 0.162 0.148 0.135 0.124 0.112 0.104 0.093 0.088 0.078 0.074 0.065 0.062 0.054 0.052 0.045 0.044 0.038 0.037 0.031 0.031 0.026 0.013 0.010 0.005 0.004 0.001 0.001 0 0 25% 0.800 0.640 0.512 0.410 0.320 0.262 0.210 0.168 0.134 0.107 0.086 0.069 0.055 0.044 0.035 0.028 0.023 0.018 0.014 0.012 0.004 0.0010 0 0 30% 0.769 0.592 0.455 0.350 0.269 0.207 0.159 0.123 0.094 0.073 0.056 0.043 0.033 0.025 0.020 0.015 0.012 0.009 0.007 0.005 0.001 35% 0.741 0.549 0.406 0.301 .223 0.165 0.122 0.091 0.067 0.050 0.037 0.027 0.020 0.015 0.011 0.008 0.006 0.005 0.003 0.002 0.0010 40% 0.714 0.510 0.364 0.260 0.186 0.133 0.095 0.068 0.048 0.035 0.025 0.018 0.013 0.009 0.006 0.005 0.003 0.002 0.002 0.001 50% 0.667 0.444 0.296 0.198 0.132 0.088 0.059 0.039 0.026 0.017 0.012 0.008 0.005 0.003 0.002 0.002 0.001 0.001 0 0 0 50........ 0 0 Note: Factor calculation with calculator. Set FV -1 Set PMT - 0 Select N = number of required periods Select 1Y = required interest rate COMP PV - ? Excel Spreadsheet PV 4., FV) 1 - Decimal or % 1= For beginning of period (5th spot)