Please help, my all formulas failed. please do in excel and share formula.

(Comprehensive problem) You would like to have $53,000 in 15 years. To accumulate this amount, you plan to deposit an equal sum in the bank each year that will earn 8 percent interest compounded annually. Your first payment will be made at the end of the year. a. How much must you deposit annually to accumulate this amount? b. If you decide to make a large lump-sum deposit today instead of the annual deposits, how large should this lump-sum deposit be? (Assume you can earn 8 percent on this deposit.) c. At the end of five years, you will receive $20,000 and deposit this in the bank toward your goal of $53,000 at the end of year 15 . In addition to the lump-sum deposit, how much must you deposit in equal annual amounts, beginning in year 1 to reach your goal? (Again, assume you can earn 8 percent on your deposits.) a. How much must you deposit annually to accumulate this amount? $ (Round to the nearest cent.) b. If you decide to make a large lump-sum deposit today instead of the annual deposits, how large should the lump-sum deposit be? $ (Round to the nearest cent.) c. If you deposit $20,000 received at the end of five years in the bank, what will the amount grow to by the end of year 15 ? (Round to the nearest cent.) (Present value of complex cash flows) How much do you have to deposit today so that beginning 11 years from now you can withdraw $14,000 a year for the next 7 years (periods 11 through 17) plus an additional amount of $28,000 in the last year (period 17)? Assume an interest rate of 9 percent. The amount of money you have to deposit today is $ (Round to the nearest cent.)