hello. these are the correcr answers. please do not put any other answers in here. please just explain how these questions were solved. preferabbly using excel. again the answers you see here are correct. i just need to find out how the answers for nominal 292035.81 is found for example. please show formulas. will upvote

You want to withdraw $84,000 per year in real terus for 25 years when you retire. You plan to retire in 35 years, and expect to earn a 12 percent nominal effective angual retum. You will make annal deposits to fund your retirenent account. Inmediately after you make your last deposit, you plan to withdraw $20,000 in real terms to take an around tho world trip. You also wish to leave your grendehildret $2,000,000 in nominal terms at the end of the 25 years of witbdrawals. You will earn an 8 percent effective anmal nominal refurn affer you retire. The inflation rate over the entire period is expected to be an effect anntal rale of 3.8 percent. What is the real amount of you anmal deposif? How moch will your accoant be worth in bominal terms immediately affer your last deposin