Question

In: Finance

Chris Jones wishes to have $200,000 in a retirement fund 30 years from now. He can...

Chris Jones wishes to have $200,000 in a retirement fund 30 years from now. He can create the retirement fund by making a single lump-sum deposit today. Use next table to solve the following problems.

  1. If he can earn 8 percent on his investments, how much must Chris deposit today to create the retirement fund? Round PV-factor to three decimal places. Round your answer to the nearest cent.
    Calculate your answer based on the PV-factor.

    $  


    Calculate your answer based on the financial calculator.

    $  


  2. If he can earn only 6 percent on his investments? Round PV-factor to three decimal places. Round your answer to the nearest cent.
    Calculate your answer based on the PV-factor.

    $  


    Calculate your answer based on the financial calculator.

    $  


  3. If upon retirement in 30 years Chris plans to invest the $200,000 in a fund that earns 6%, what is the maximum annual withdrawal he can make over the following 20 years? Round the answer to the nearest cent. Round PVA-factor to three decimal places.
    Calculate your answer based on the PVA-factor.

    $  


    Calculate your answer based on the financial calculator.

    $  


  4. How much would Chris need to have on deposit at retirement to annually withdraw $35,000 over the 20 years if the retirement fund earns 6%? Round the answer to the nearest cent. Round PVA-factor to three decimal places.
    Calculate your answer based on the PVA-factor.

    $  


    Calculate your answer based on the financial calculator.

    $  


  5. To achieve his annual withdrawal goal of $35,000 calculated in part c, how much more than the amount calculated in part a must Chris deposit today in an investment earning 6% annual interest? Round PVA-factor to three decimal places. Round your answer to the nearest cent. If an amount is zero, enter "0".

    $  

Solutions

Expert Solution

PV table:

a. FV = $200,000

Time till retirement = 30 years

r = 8 percent on his investments

  • We need to calculate the PV that will result in FV of 200000 in 30 years at 8% compounding
  • required PV factor is 0.09934
  • Formula for required FV:
    • or

b. Calculate your answer based on the financial calculator.

  • Inputs for Financial calculator:
    • PMT=0
    • I/Y = 0.08
    • FV = 200000
    • T=30
    • CPT PV
    • In the financial calculator the PV value will be negative because it is an outflow which will result in an outflow of 200000 @ 8% after 30 years

FV = $200,000

Time till retirement = 30 years

r = 6 percent on his investments

c. Answer based on the PV-factor.

  • required PV factor is 0.1741
  • Formula for required FV:
    • or

d. Answer based on the financial calculator.

  • Inputs for Financial calculator:
    • PMT=0
    • I/Y = 0.06
    • FV = 200000
    • T=30
    • CPT PV
    • In the financial calculator the PV value will be negative because it is an outflow which will result in an outflow of 200000 @ 6% after 30 years

e. answer based on the PVA-factor.

PV = $200,000

Time till last withdrawal = 20 years

r = 6 percent on his investments

  • We need to calculate the PMT that can come from a PV of 200000 and FV = 0 in 20 years at 6% compounding
  • required PVA factor is 11.4699
  • Formula for required FV:
    • or

f. answer based on the financial calculator.

  • Inputs for Financial calculator:
    • I/Y = 0.06
    • PV = 200000
    • T=20
    • FV=0
    • CPT PMT
    • In the financial calculator the PMT value will be negative because it is an outflow or a withdrawal which will result from outflow of 200000 @ 6% during each of the 20 years

g. answer based on the PVA-factor.

PMT =35000  

Time till last withdrawal = 20 years

r = 6 percent on his investments

  • We need to calculate the PV that can come result in a PMT of 35000 and FV = 0 in 20 years at 6% compounding
  • required PVA factor is 11.4699
  • Formula for required FV:
    • or

h. answer based on the financial calculator.

  • Inputs for Financial calculator:
    • I/Y = 0.06
    • T=20
    • FV=0
    • PMT = -35000
    • CPT PV
    • In the financial calculator the PMT value will be negative because it is an outflow or a withdrawal of 35000 @ 6% during each of the 20 years

To achieve his annual withdrawal goal of $35,000 calculated in part c, how much more than the amount calculated in part a must Chris deposit today in an investment earning 6% annual interest? Round PVA-factor to three decimal places. Round your answer to the nearest cent. If an amount is zero, enter "0".

Total FV required = $401446.50

Of this 200000 will be achieved as per part a, and for the remaining 201446.50 will be calculated as follows

Time till retirement = 30 years

r = 6 percent on his investments

  • We need to calculate the PV that will result in FV of 201446.50 in 30 years at 6% compounding
  • required PV factor is 0.1741
  • Formula for required FV:
  • or

Related Solutions

Austin Miller wishes to have $200,000 in a retirement fund 25 years from now. He can...
Austin Miller wishes to have $200,000 in a retirement fund 25 years from now. He can create the retirement fund by making a single lump-sum deposit today. Use next table to solve the following problems. If upon retirement in 25 years, Austin plans to invest $200,000 in a fund that earns 10%, what is the maximum annual withdrawal he can make over the following 15 years? Round the answer to the nearest cent. Round PVA-factor to three decimal places. Calculate...
Daryl wishes to save money to provide for his retirement. Beginning one month from now, he...
Daryl wishes to save money to provide for his retirement. Beginning one month from now, he will begin depositing a fixed amount into a retirement savings account that will earn 12% compounded monthly. He will make 360 such deposits. Then, one year after making his final deposit, he will withdraw $100,000 annually for 25 years. The fund will continue to earn 12% compounded monthly. How much should the monthly deposits be for his retirement plan? A) 189.58 B) 199.58 C)...
A man wishes to provide a fund for his retirement such that from his 60th to...
A man wishes to provide a fund for his retirement such that from his 60th to 70th birthdays he will be able to withdraw equal sums of ₱18,000 for his yearly expenses. He invests equal amounts for his 41st to 59th birthdays in a fund earning 10% compounded annually. How much should each of these amounts be?
You would like to save $5,000 today, in preparation for retirement 30 years from now. You...
You would like to save $5,000 today, in preparation for retirement 30 years from now. You have to choose between putting it into one of the two plans describe below: i) Pay no taxes toady, and put the money into an interest-bearing account. When you withdraw the money on retirement, you pay a 20% tax rate on the money taken from the account. (This is how an Individual Retirement Account, or, IRA works) ii) Pay a tax rate of 15%...
A person wishes to have $27,500 cash for a new car 4 years from now. How...
A person wishes to have $27,500 cash for a new car 4 years from now. How much should be placed in an account now, if the account pays 4.2% annual interest rate, compounded weekly? $ (Round to the nearest dollar)
Finance. A person wishes to have $21,900 cash for a new car 7 years from now....
Finance. A person wishes to have $21,900 cash for a new car 7 years from now. How much should be placed in an account​ now, if the account pays 5.5% annual interest​ rate, compounded​ weekly?
Selyn Cohen is 63 years old and recently retired. He wishes to provide retirement income for...
Selyn Cohen is 63 years old and recently retired. He wishes to provide retirement income for himself and is considering an annuity contract with the Philo Life Insurance Company. Such a contract pays him an equal-dollar amount each year that he lives. For this cash-flow stream, he must put up a specific amount of money at the beginning. According to actuary tables, his life expectancy is 15 years, and that is the duration on which the insurance company bases its...
Collins wishes to retire in 30 years’ time and has estimated that he will require a...
Collins wishes to retire in 30 years’ time and has estimated that he will require a monthly pension income of K24,000 per month for 20 years subsequent to retirement. Collins will contribute to a retirement fund which will enable her to take out a monthly pension of K24,000 after retirement. The retirement fund is currently earning a return of 9% per annum, interest compounded monthly, and this level is expected to remain unchanged and to be sustainable over the next...
Mr. Jones wishes to establish a fund for his newborn child’s education. The fund pays $60,000...
Mr. Jones wishes to establish a fund for his newborn child’s education. The fund pays $60,000 on the child’s 18th, 19th, 20th, and 21st birthdays. The fund will be set up by the deposit of a fixed sum on the child’s 1st through 17th birthdays. The fund earns 6 percent annual interest. A) What is the required annual deposit. B) What would the annual payments be, if the tuition fees in the above example are $60,000, $67,000, $75,000 and $83,000,...
Daryl Kearns saved $200,000 during the 25 years that he worked for a major corporation. Now...
Daryl Kearns saved $200,000 during the 25 years that he worked for a major corporation. Now he has retired at the age of 50 and has begun to draw a comfortable pension check every month. He wants to ensure the financial security of his retirement by investing his savings wisely and is currently considering two investment opportunities. Both investments require an initial payment of $190,000. The following table presents the estimated cash inflows for the two alternatives: Year 1 Year...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT