How do I solve by using excel spreadsheet? like for instance A I would do PV=1,000 I/YR=.10, N= 5, then I would input it to the formula bar as rate 10% nper 5 the pv -1000. For the rest of the parts I don't know how to set up the problems.

Assuming a rate of 10% annually, find the PV of $1,000 after 5 years. What is the investment's FV rates of 0%, 5%, and 20% after 0, 1, 2, 3, years? Find the PV of $1,000 due in 5 years if the discount rate is 10% s2.000 after s years? What is the rate of return on a security that costs $1,000 and returns Suppose California's population is 36.5 million people and its population is expected grow by 2% annually. How long will it take for the population to double? if the Find the PV of an ordinary annuity that pays $1000 each of the next 5 years e interest rate is 15%. What is the annuity's FV? change if it is an g. How will the PV and FV of the annuity in part annuity due? What will the Fv be for s1000 due in 5 years if the interest rate is 10 s, semiannual compounding? What will the annual payments be for an ordinary annuity for 10 years with a PV of $1000 if the interest rate is What will the payments be if this is an annuity due? Find the PV and the FV of an investment that pays 8% annually and makes the following end-of-year payments: Five banks offer nominal rates of 6% on deposits, but A pays interest annually; B pa semiannually; C pays quarterly; D pays monthly; and E pays daily. in each bank What effective annual rate does each bank pay? If you deposit $5,000 today, much have in each bank at the end of 1 year? 2 years? If all of the banks are insured by the government (the FDIC) and thus are equally be equally able to attract funds? If not (and the TVM is the only they consideration), what nominal rate will cause all of the banks to provide the same effective annual rate as Bank A? Suppose you don't have the $5,000 but need it at the end of 1 year. You plan to make a of annually for A, semiannually for B, quarterly for C, monthly for D, and daily for E with payments beginning today. How large must the payments be to each bank? Even if the five banks provided the same effective annual rate, would a rational investor be indifferent between the banks? Explain. Suppose you borrow $15,000. The loan's annual interest rate is 8%, and it requires four equal end-of year payments. Set up an amortization schedule that shows the annual payments, interest payments, principal repayments, and beginning and ending loan balances