PROBLEM $(1-4)$

$(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 you can

$4$ 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.

$(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.

TVM MULTIPLE UNEVEN

$(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

$22$ today? Use the inputs from column B from question #$3$ and set this up so that your answer is displayed as a positive value.

b

Please show the formulas using excel for the yellow highlighted areas. thank you.!!