John Smith wants to save money to meet three objectives. First, he would like to be able to retire 30 years from now with a retirement income of $17,500 per month for 20 years, with the first payment received 30 years and one month from now. Second, he would like to purchase a cabin in Rivendell in 10 years at an estimated cost of $350,000. Third, after he passes on at the end of the 20 years of withdrawals, he would like to leave an inheritance of $1,500,000 to his nephew Frodo. He can afford to save $1,800 per month for the next 10 years. If he can earn an EAR of 11 percent before he retires and an EAR of 8 percent after he retires, how much will he have to save each month in Years 11 through 30?

Monthly Savings =

*Please solve in Excel if possible so I can learn and understand the formulas.