Please show cell referencing!!!! i need help learning to do the problem

Note: Use zero for Pmt since there are no periodic payments. Note that the PV is given a negative sign because it is an outflow (cost to buy the security). Also, note that you must seroll down the menu to complete the inputs. 6. Suppose California's population is 30 millian people, and its population is expected to grow by 2% per year. How long would it take for the population to double? C. Find the PV of an anneity that pays $1,000 at the end of each of the next 5 years if the interest rate is 15%. Then find the FV of that uame annuity. f. Find the PV of an annuity that pays $1,000 at the end of each of the next 5 years if the interest rate is 15%. Then find the FV of that same annuity. g. How would the PV and FV of the annuity change if it were an annuity due rather than an ordinary annuity? For the PV, each payment would be received one period sooner, hence would be discounted back one 2 less year. This would make the PV larger. We can find the PV of the annuity due by finding the PV of an ordinary annuity and then multiplying it by (1+i). PV annuity due = x Exactly the same adjustment is made to find the TV of the annuity due. FV annuity due = h. What weuld the V V and the PV for preblems a and c be if the interest rate were 10% with scmiannual compeunding rather than 10% with annual compounding