Please answer every single part, A-I. The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Enter your answers as positive values.

a. Find the FV of $1,000 invested to earn 12% after 6 years. Round your answer to the nearest cent. $ b. What is the investment's FV at rates of 0%, 6%, and 20% after 0, 1, 2, 3, 4, and 5 years? Round your answers to the nearest cent. Interest Rate Year 0% 6% 20% O $ $ $ 1 2 $ $ 3 $ $ $ 4 TA 5 c. Find the PV of $1,000 due in 6 years if the discount rate is 12%. Round your answer to the nearest cent. $ d. A security has a cost of $1,000 and will return $2,000 after 6 years. What rate of return does the security provide? Round your answer to two decimal places. % e. Suppose California's population is 35.9 million people, and its population is expected to grow by 4% annually. How long will it take for the population to double? Round your answer to the nearest whole number. years f. Find the PV of an ordinary annuity that pays $1,000 each of the next 6 years if the interest rate is 15%. Then find the FV of that same annuity. Round your answers to the nearest cent. PV of ordinary annuity: $ FV of ordinary annuity: $ g. How will the PV and FV of the annuity in part f change if it is an annuity due rather than an ordinary annuity? Round your answers to the nearest cent. PV of annuity due: $ FV of annuity due: $ h. What will the FV and the PV for parts a and c be if the interest rate is 12% with semiannual compounding rather than 12% with annual compounding? Round your answers to the nearest cent. FV with semiannual compounding: $ PV with semiannual compounding: $ i. Find the annual payments for an ordinary annuity and an annuity due for 12 years with a PV of $1,000 and an interest rate of 10%. Round your answers to the nearest cent. Annual payment for ordinary annuity: $ Annual payment for annuity due