Present value tables 1. Using formulas (but not functions) and cell references from columns F, G, and H only, create the Present value of $1 Table B so the values are the same as those in Table A. a. Enter the necessary formula in cell G20 so it can be copied and pasted to cell H20. Use dollar signs in the formula only when necessary. b. Copy the formula in G20 to H20. Double check that the result in H20 equals the value in D20. c. Enter the necessary formula in cell G21 so it can be copied to across to cell H21 and down and across to cells G22 through H29. Use dollar signs only when necessary. d. Copy the formula in G21 to H21 AND copy the formula in G21 to cells G22 through H29. 2. Using formulas (but not functions) and cell references, create the Present value of an annuity of $1 Table D so the values are the same as those in Table C. Do not reference any of the values in column K in your formulas. a. Use one value in column G to determine the amount in cell N20. b. Enter the necessary formula in cell N21. Use only values in columns G and N to determine the answer. Do not type in any numbers in the formulas; cell references only. c. Copy down the formula in cell N21 so that cells N22:N29 are all correctly filled in. (Note: H17 is a numerical value.) TABLE A - Answer Key Present value of $1 TABLE B - to be completed Present value of $1 TABLE C - Answer Key TABLE D - to be completed Present value of an annuity of $1 Present value of an annuity of $1 7% 8% 7% 1 1 1 1 2 2 2 3 2 3 4 5 3 4 3 4 4 7% 0.93458 0.87344 0.81630 0.76290 0.71299 0.66634 0.62275 0.58201 0.54393 0.50835 8% 0.92593 0.85734 0.79384 0.73503 0.68059 0.63017 0.58349 0.54027 0.50025 0.46320 5 7% 0.93458 1.80802 2.62432 3.38721 4.10020 4.76654 5.38929 5.97130 6.51524 7.02359 5 5 6 6 6 6 6 7 7 7 6 7 8 9) 10 8 8 9 10 9 10 8 9 10