(1) You plan the following deposits into your bank account: $500 next year, $1,000 the following year and of 8%, what one-time deposit would you need to support the indicated withdrawals? Enter the rate, the c that all dollar figures in column B are displayed as positive values. (2) If the withdrawals in Question 1 were deposits instead and you could earn 8% per year, what would yo answer is displayed as a positive value. TVM MULTIPLE UNEVEN YEAR 1 2 3 4 5 YR OF LAST CASH FLOW FV PV CASH FLOW r 8% 3 (3) If you were to make annual deposits of $100 over the next 15 years earning 10% per year, what would the inputs into the appropriate cells in column B and set this up so that your answer is displayed as a positi (4) If you wanted to make annual withdrawals of $100 over the next 15 years, earning 10% per year, what from column B from question #3 and set this up so that your answer is displayed as a positive value. TVM ANNUITY PMT YEARS RATE FVA PVA