$(1)$ You plan the following deposits into your bank account: $$500$ next year, $$1,000$ the following year and $$2,000$ the year after that. If

$4$

you can earn an annual rate of return of $8\%,$ what one$-$time deposit would you need to support the indicated withdrawals? Enter the rate, the cash flows and the answer in the indicated cells in column B$.$ Be sure that all dollar figures in column B are displayed as positive values.

$5(2)$ If the withdrawals in Question $1$ were deposits instead and you could earn $8\%$ per year, what would your balance be immediately after your last deposit? Be sure that your answer is displayed as a positive value.

$\backslash$table$[[6,,,],[7,,,],[8,$TVM MULTIPLE UNEVEN,,$],[9,,,],[10,$YEAR,CASH FLOW,r$],[11,1,,],[12,2,,],[13,3,,],[14,4,,],[15,5,,],[16,,,],[17,$YR OF LAST CASH FLOW,,$],[18,$FV$,,],[19,$PV$,,],[20,,,]]$

$(3)$ If you were to make annual deposits of $$100$ over the next $15$ years earning $10\%$ per year, what would your balance be immediately after making your final deposit? Enter the inputs into the appropriate cells in column B and set this up so that your answer is displayed as a positive value.

$(4)$ If you wanted to make annual withdrawals of $$100$ over the next $15$ years, earning $10\%$ per year, what one$-$time deposit would you need to make today? Use the inputs 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