Part $1$: You receive an email from a very polite person which states you are entitled to a $$1$ million inheritance. After some research, you find that the money can be invested into an account paying a fixed $4\%$ rate, compounded quarterly. How much retirement money would be in the account after $25$ years? $($round to nearest dollar$)$

I NEED THE EXCEL FORMULA PLEASE. The answer is $$2,704814$

Part $2$: The email from the last question turned out to be fraudulent, but you'd still like to have the sum of money the invested inheritance would have provided after $25$ years. How much money would need to be invested at the beginning of each month for the next $25$ years in order to have the same sum from question $5?$ You estimate conservatively that your money will earn $3\%$ a year. $($round to the nearest dollar$)$ I NEED THE EXCEL FORMULA PLEASE. The correct answer is: $(6,049)$

Part $3$: Another pleasant fellow emails to inform you that you have won a Swiss lottery. You can take your winnings in a lump sum of $$2,000,000$ or receive annual end of year payments of $$105,000$ for $30$ years. Assuming that your money can earn $3\%$ a year, what is the value of the annual annuity stream option? $($round to the nearest dollar$)$ I NEED THE EXCEL FORMULA PLEASE. The correct answer is: $(2,058,046)$