Blog

Use the spreadsheet “Retirement”. You just graduated from Ca…

Use the spreadsheet “Retirement”. You just graduated from Carlson today and are beginning your first job. You are planning to start investing for retirement and want to retire in 25 years. You will open the account today with the $30,000 that your Aunt Bertha gave you for graduation 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 plan to give your only child $80,000 to help pay for college when they turn 18, twelve years from today.  You will use your retirement account to fund this gift (assuming no penalties or taxes!). You assume you will need money for 40 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 retirement period.  You believe that you will require $130,000 every six months to fund your retirement. You believe that your investment will earn approximately 9% APR with monthly compounding during your investing years (until retirement) and 4% APR with semi-annual compounding during your retirement years.  How much will your monthly investments need to be in order to fund this plan? Answer here and highlight answer in Excel (or put in green box provided).  Format for answer:  $X,XXX.XX; round to nearest cent with no leading 0’s with $ and comma included.  Only input that value and no words or other characters.  Example:  $3,859.49 or $286.88.