Use the “Retirement” spreadsheet to complete your work. You…
Use the “Retirement” spreadsheet to complete your work. You just graduated from Carlson today and are beginning a new job. You are planning to start investing for retirement and want to retire in 25 years. You will open the account today and will begin investing an equal sum at the end of each month, starting one month from today with your last payment made the day of retirement. You also assume that you will need to withdraw $100,000 six years from now as a down payment on a new home. You assume you will need money for 35 years of retirement. Because you want to travel after retirement, you want to receive semi-annual payments. You plan to collect the first payment the day you retire. You will receive the last payment six months prior to the end of the 35-year retirement period. You believe that you will require $150,000 every six months to fund your retirement. You believe that your investment will earn approximately 9% APR (annual percentage rate) with monthly compounding during your investing years (until retirement) and 2.5% APR with semi-annual compounding during your retirement years. Answer here and in Excel. Answer format: $X,XXX.XX or $XXX.XX with dollar sign, comma, and decimal; round to nearest cent. How much will your monthly investments need to be in order to fund this plan?
Read Details