please answer using excel and explain

9) You have just retired with $1,000,000 in savings. This is the amount that you will be drawing down for the rest of your life. How long can you rely on your savings if you expect to earn 6% and withdraw $70,000 per year? Assume that your first withdrawal will occur one year from today. Use Excel's =NPER(RATE,PMT,PV,[FV],[TYPE]) function. RATE is 6%, PMT is $70,000,PV is $1,000,000, and TYPE is 0 since payments are made at the end of the period. If the [type] argument is omitted, it takes on the default value of 0 . Assuming that you can live for about a year on the last withdrawal, then you can afford to live for about another 34.40 years