Please answer all questions (#2, 3, 4, 5, and 6)! May use Microsoft Excel to complete the function. Please show work/explanation. Will rate, thank you!

for the future value of her retirement account? Margaret Smith is 20 years old. She would like to have a retirement account worth $1 million in today's dollars when she is 60. She assumes long-term inflation will be 3.5%. What is the goal rate= .035 nper yo How much would she have to invest annually to reach that goal if the annual return on her fund [1] FV = 3,959,259.72 is 6.5%? [2], PMT = If the annual return on her fund is 8%? [3), PMT= If Margaret didn't worry about inflation and was satisfied with a $1 million account when she is 60, how much should she save at end of each month if she can achieve a steady annual return of 7%? * (4) PMT = What would that amount be if she deposited the payment at the beginning of each month? [5] PMT= If, at the end of the month, her employer matched her contributions one dollar for every two she put in (using the question 4 goal of $1 million, 7% return), how much does Margaret need to contribute each month? (6) PMT=