DO NOT COPY ANY OTHER ANSWER! PLEASE DO NOT USE EXCEL. SHOW YOUR STEPS.

Bilbo Baggins wants to save money for his retirement. He would like to be able to retire 40 years from now with a retirement income of US$15,000 per month for 25 years. Second, after he passes on at the end of the 25 years of withdrawals, he would like to leave an inheritance of US$1,500,000 to his nephew Frodo. You can assume that Bilbo is able to save regularly only for the 20 first years and nothing in years 20-40. Evaluate what should be the amount invested at the end of each year (for 20 years) to achieve these goals? You can assume that the interest rate is 3% throughout Bilbos lifespan