$*****($PLEASE ANSWER ON EXCEL AND SHOW FORMULAS$)*****$

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