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

$($Please solve these steps using excel because i need to enter in the correct formulas in the yellow boxes. Thank you so much$)$