question archive You currently have $15,000 to start investing and also have a stable career, so you plan to work for 40 years and then retire; your retirement life is expected to last another 20 years

You currently have $15,000 to start investing and also have a stable career, so you plan to work for 40 years and then retire; your retirement life is expected to last another 20 years

Subject:FinancePrice:3.86 Bought12

You currently have $15,000 to start investing and also have a stable career, so you plan to work for 40 years and then retire; your retirement life is expected to last another 20 years. According to your plan, besides $15,000 initial contribution today, by the end of each working year you need to contribute an extra equal amount of money into your retirement fund until the day you retire. Your retirement fund balance is expected to earn an annual nominal (i.e., inflated) return of 9.71% on average in the US financial market over time. Beginning at the day you retire, you withdraw an equal (not growing) nominal income amount per year from your retirement fund, so as to cover your annual retirement living costs. However, your annual withdrawal income amount will be subject to 15% income tax. Also, the US inflation in the long term is expected to be 2.5% per year. You want your first annual withdrawal nominal amount, after tax, to be sufficient to carry the same purchasing power (i.e., living standard) as today's $35,000. In addition, you want to leave another $300,000 after-tax nominal inheritance to your heirs when your life ends (your heirs will also be taxed 15% on the inheritance that they collect). Solve and answer the following: To meet all above future financial needs as planned, from now till the day of your retirement, what should be the equal (not growing) nominal amount for you to contribute each working year?

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

  • Equal Nominal Annual Contribution = 1217.04

Step-by-step explanation

Step 1 :

Using Excel function

Annual Withdrawal after tax after retirement = FV(rate,nper,pmt,pv)

  • rate (inflation rate) = 2.5%
  • nper = 40
  • pmt =0
  • pv= -35000

Annual Withdrawal after tax after retirement = FV(2.5%,40,0,-35000)

Annual Withdrawal after tax after retirement =   93,977.2343 

 

Step 2 :

Annual Withdrawal before tax = Annual Withdrawal after tax /(1-tax rate)

Annual Withdrawal before tax = 93977.2343/(1-15%)

Annual Withdrawal before tax = 110561.4521

 

Step 3 :

Inheritance Amount before tax = Inheritance Amount after tax/(1-tax rate)

Inheritance Amount before tax = 300000/(1-15%)

Inheritance Amount before tax = 352941.1765

 

Step 4 :

Amount needed at the time of Retirement = PV(RATE,NPER,PMT,FV,TYPE)

  • rate = 9.71%
  • nper = 20
  • pmt = 110561.4521
  • fv = 352941.1765
  • type = beginning = 1

Amount needed at the time of Retirement = PV(9.71%,20,110561.4521,352941.1765,1)

Amount needed at the time of Retirement = 1,108,751.03

 

Step 5 :

Equal Nominal Annual Contribution = PMT(RATE,NPER,PV,FV)

  • RATE = 9.71%
  • NPER = 40
  • PV = -15000
  • FV= 1108751.03

Equal Nominal Annual Contribution = PMT(9.71%,40,-15000,1108751.03)

Equal Nominal Annual Contribution = 1217.04