How to solve these questions in excel? Answer the following questions:
e. Suppose California's population is 36 5 million people and its population is expected to grow by 2% annually. How long will it take for the population to double?
f. Find the PV of an ordinary annuity that pays $1,000 each of the next 5 years if the interest rate is 15%. What is the annuity's FV?
g. How will the PV and FV of the annuity in Part f change if it is an annuity due?
h. What will the FV and the PV be for $1,000 due in 5 years if the interest rate is 10%, semiannual compounding?
i. What will the annual payments be for an ordinary annuity for 10 years with a PV of $1,000 if the interest rate is 8%? What will the payments be if this is an annuity due?