ROBLEM $(1-4)$ 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 in 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. 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 YR OF LAST CASH FLOW $3$ FV P

SHOW FORMULAS IN EXCEL!!!! $($show excel sheet$)($the boxes need formulas for credit$)$