can you help me by something me how and what to input, i have a hard time knowing how to yse excel but i understand harding formula. can you show me what and how to input in excel. modifcation to this problem in black bold. this is a long problem so i took a few pics :) thanks

P6-24 Modified (see template for modifications to the problem) 5 6 7 8 9 -0 You are trying to plan for retirement in 10 years and currently you have $200,000 in a savings account and $275,000 in stocks. In addition, you plan to deposit $8,000 per year into your savings account at the end of each of the next 5 years, and then $10,000 per year at the end of each year for the final five years until you retire a. Assuming your savings account returns 4% compounded annually, and your investment in stocks will return 9% compounded annually, how much will you have at the end of 10 years? b. If you expect to live for 20 years after you retire, and at retirement you deposit all of your savings (including socks) in a bank account paying SX how much can you withdrawal each year after you retire (making 20 equal withdrawls beginning one year after you retire) so that you end up with a zero balance at death? 11 Note: there are multiple methods that can be used to solve this problem. The template below is laid out for one of those methods, but you can chose another A) EV Savings Savings PV 1 nper pmt FV EV Stocks PV 1 nper pmt FV + 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 EV SRK Annuity years 1-5) Step 1: PV 1 nper pmt FV Step 2: PV nper pmt FV FV $10K Annuity (years 6-10 Step 1: PV i nper pmt FV Total FV (Year 10) B) PV i nper pmt FV