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

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?
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...
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...
A worker age 45 wishes to accumulate a fund for retirement by depositing $2,500 at the...
A worker age 45 wishes to accumulate a fund for retirement by depositing $2,500 at the beginning of each year for 20 years. Starting at age 65 the worker plans to make 20 annual withdrawals at the beginning of each year. Assuming all payments are certain to be made, find the amount of each withdrawal starting at age 65 to the nearest dollar, if the effective rate of interest is 9% during the first 20 years but only 8% thereafter.
Michael is 30 years old. He comes up with a plan to save for his retirement...
Michael is 30 years old. He comes up with a plan to save for his retirement at 65 years. Currently, he has saved $40,000 in a balanced superannuation account earning 5.5% annually. He has set himself a retirement target of $2,000,000. How much must be deposited in his superannuation account starting next year each year to reach his target? Assume his contributions are to be invested at 5.5% annually. Please, round your answer to two decimal places.
I would like to have $50,000 after retirement in 20 years 8 months from now. How...
I would like to have $50,000 after retirement in 20 years 8 months from now. How much should I invest right now to reach my goal if interest rate remains the same for the next 30 years as 3% p.a.?
You are doing some long-range retirement planning. On the day you retire (23 years from now) you want to be able to withdraw $200,000
You are doing some long-range retirement planning. On the day you retire (23 years from now) you want to be able to withdraw $200,000. Then, you want to withdraw the following amounts at the end of each year after that (during your retirement period).                           Years 1-4            $160,000                           Years 5-9            $175,000                           Years 10-15       $165,000                           Years 16-26       $145,000At the end of the 26th year in retirement, you’d like to have $500,000 remaining in your retirement account available for withdraw. During your retirement...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT