Can you please answer the problem using excel and showing all of your work with details and formulas to how you got the answer. Keep the same format please. Below i will attach the work that i have completed thus far, thank you!

P6-22 (Solving a comprehensive problem) You would like to have $75,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 the 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 it in the bank in an effort to reach your goal of $75,000 at the end of 15 years. In addition to the deposit, how large must your equal annual deposits for all 15 years be to reach your goal? (Again, assume you can earn 8 percent on this deposit.) A) Savings PV i $ nper pmt FV 8.00% 15.00 $2,762.22 75,000.00 $ B) PV i nper pmt FV $23,643.13 8.00% 15.00 $ $ 75,000.00 B C D E F F A) Savings $ PV i nper pmt FV 8.00% 15.00 $2,762.22 75,000.00 $ B) PV i nper pmt $23,643.13 8.00% 15.00 AA $ $ FV 75,000.00 C) $ PV i nper pmt FV 20,000.00 8.00% 10.00 $ $ $43,178.50 $ PV i nper pmt FV 31,821.50 8.00% 15.00