can you help me by breaking down all the inputs in excel so i can see what exactly goes where becuase i have a hard time knowing how to input. i know the hardcode but not how or what to input in excel

H N 0 P6-53 Modified (see template for modifications to the problem) You would like to have $1,000,000 in 20 years. To accumulate this amount, you plan to deposit an equalsum in the bank each year that will earn interest compounded annually. Your first payment will be made at the end of the year 2. 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 sumbe? (Assume you can earn 7% on the deposit.) c. At the end of 10 years, you will receive $150,000 and deposit this in the bank toward your goal of $1,000,000 at the end of 20 years. In addition to this deposit, how much must you deposit in equal anual deposits to reach your coal at 2032 A PV 1 aper prit FV 8 PV nper pmt FV 10 11 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 Step PV Hint: Arstin Step 1 determine how much $150K will be worth at the end of 20 years 1 nper pmt FV Hint: In Step 10 for the figure use $1,000,000 minus the amount from Step 8 Step 2 PV 1 nper pmt FV 42 43 P6-53M P6-54M P6-24M + Instructions & Questions Roche P6-53 Modified (see template for modifications to the problem) You would like to have $1,000,000 in 20 years. To accumulate this amount, you plan to deposit an equal sum in the bank each year that will earn 7% 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-sumbe? (Assume you can earn 7% on the deposit.) c. At the end of 10 years, you will receive $150,000 and deposit this in the bank toward your goal of $1,000,000 at the end of 20 years. In addition to this deposit, how much must you deposit in equal annual deposits to reach your goal at 7%