You are planning to save for retirement over the next 30 years. To save for retirement, you will invest $1,850 per month in a stock account in real dollars and $610 per month in a bond account in real dollars. The effective annual return of the stock account is expected to be 10 percent, and the bond account will earn 6 percent. When you retire, you will combine your money into an account with an effective return of 8 percent. The returns are stated in nominal terms. The inflation rate over this period is expected to be 4 percent.

a. How much can you withdraw each month from your account in real terms assuming a 25-year withdrawal period?

b. What is the nominal dollar amount of your last withdrawal?

Please use excel if possible!