these are the correct answers however i need to understand how this question is solved. please explain including formulas. prefferably in excel. thank you. you are a life saver! will upvote!

You want to withdraw $84,000 per year in real terms for 25 years when you retire. You plan to retire in 35 years, and expect to earn a 12 percent nominal effective annual return. You will make annual deposits to fund your retirement account. Immediately after you make your last deposit, you plan to withdraw $20,000 in real terms to take an around the world trip. You also wish to leave your grandehildrer $2,000,000 in nominal terms at the end of the 25 years of withdrawals. You will earn an 8 percent effective annual nominal retum after you retire. The inflation rate over the entire period is expected to be an effect annual rate of 3.8 percent. What is the real amount of you annual deposit? How much will your account be worth in nominal terms immediately after your last deposit? Real pretirement EAR 7.8998% Real post retirement EAR 4.0462% Amount needed at retirement: (real)