You are planning to save for retirement over the next 30 years. To save for retirement, you will invest $1,750 per month in a stock account in real dollars and $600 per month in a bond account in real dollars. The effective annual return of the stock account is expected to be 13 percent, and the bond account will have an annual return of 5 percent. When you retire, you will combine your money into an account with an effective annual return of 7 percent. The inflation rate over this period is expected to be 3 percent.

How much can you withdraw each month from your account in real terms assuming a 25-year withdrawal period? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

Monthly withdrawal: ___________

What is the nominal dollar amount of your last withdrawal? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

Last withdrawal: _________

*Help with the excel formulas used would be great!