1) (2 points) Complete the table by computing the present values (PVS) of $20,000 received in the given years from 0 to 50 when the interest rate is 5% when the interest rate is 10% when the interest rate is 20% using the PV formula (not the PV Excel function) and absolute or/and relative references (e.g., $B$2, $B2, B$2, or B2) in the most efficient way (show your formulas using the formulatext Excel function). 2) (1.5 points) Draw a scatter plot of the PVs of $20,000 using the table in 1). X-values: Years Y-values: PVS (three Y-series: PVs at 5%, PVs at 10% and PVs at 20%) Add the chart title, "Scatter chart of PVs of $20,000 at various interest rates." 3) (1.5 points) Draw a line chart of the PVs of $20,000 using the table in 1). X-values: Years Y-values: PVs (three Y-series: PVs at 5%, PVs at 10% and PVs at 20%) Add the chart title, "Line chart of PVs of $20,000 at various interest rates." 4) (1 point) Choose the correct answer in the following statements: When the interest rate increases, the PV of $20,000 (increases, decreases). The PVs of $20,000 are (positively, negatively) associated with the interest rates (r). 1 FV 2 3 1) 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A Year 0 1 1.5 3 5.5 7.5 10 13 17 20 25 32 40 46 50 $ B 20,000 5% C PV 10% D 20% E 5% 25 26 4) (1 point) Choose a correct answer in the following statements 27 When the interest rate increases, the PV of $10,000 (increases, decreases). 28 *The PVs of $10,000 are (positively, negatively) associated with the interest rates (r). formulatext 10% G 20% H