Question

In: Finance

You grandfather has retired with a pension that is worth $370,000. His life expectancy is 19...

You grandfather has retired with a pension that is worth $370,000. His life expectancy is 19 more years. If the pension payments are based on an assumed return of 8 percent per year, What will be your grandfather's annuity payment at the end of each year?

Solutions

Expert Solution

Ans:- we will use the PMT function of excel to find the answer.

Rate=8%, Nper=19, PV=-$370,000, FV=0

Therefore, the annuity payment at the end of each will be approx $38,527.22


Related Solutions

What are the consequences of increasing life expectancy for pension systems?
What are the consequences of increasing life expectancy for pension systems?
Scenario: In Riverland, life expectancy is rising and has just surpassed life expectancy in its neighbor...
Scenario: In Riverland, life expectancy is rising and has just surpassed life expectancy in its neighbor country, Lakeland. Refer to the scenario above. This implies that ________. A) Riverland's per capita GDP has surpassed Lakeland's B) Riverland's Human Development Index has surpassed Lakeland's C) Riverland's Human Development Index likely will be greater than Lakeland's if its per capita GDP is greater and schooling is of similar length and quality D) Riverland's per capita GDP likely will be greater than Lakeland's...
Explain the term life expectancy .why do you think life expectancy of women is much longer...
Explain the term life expectancy .why do you think life expectancy of women is much longer than man? Use own words please and thank you!
solve the following questions 1. A person is planning for his retired life. He has 10...
solve the following questions 1. A person is planning for his retired life. He has 10 more years of service. He would like to deposit Rs. 30,000 at the end of the first year and thereafter he wishes to deposit the same amount (Rs. 30,000) with an annual decrease of Rs. 2,000 for the next 9 years with an interest rate of 18%. Find the total amount at the end of the 10th year of the above series. 2. A...
Your father is retired and living on his pension benefits and the interest he gets from...
Your father is retired and living on his pension benefits and the interest he gets from savings. However, the interest income he receives has dwindled to only 2 percent a year on his RM200,000 in savings as interest rates in the economy have dropped. You have been thinking about recommending that he purchase some corporate bonds with at least part of his savings as a way of increasing his interest income. Specifically, you have identified three corporate bond issues for...
Your father is retired and living on his pension benefits and the interest he gets from...
Your father is retired and living on his pension benefits and the interest he gets from savings. However, the interest income he receives has dwindled to only 2 percent a year on his RM200,000 in savings as interest rates in the economy have dropped. You have been thinking about recommending that he purchase some corporate bonds with at least part of his savings as a way of increasing his interest income. Specifically, you have identified three corporate bond issues for...
You manage a pension fund that will provide retired workers with lifetime annuities. You determine that...
You manage a pension fund that will provide retired workers with lifetime annuities. You determine that the payouts of the fund are essentially going to resemble level perpetuities of $4 million per year. The interest rate is 10%. You plan to fully fund the obligation using 5-year and 15-year maturity zero-coupon bonds. Requirement 1: How much market value of each of the zeros will be necessary to fund the plan if you desire an immunized position? (Enter your answer in...
You manage a pension fund that will provide retired workers with lifetime annuities. You determine that...
You manage a pension fund that will provide retired workers with lifetime annuities. You determine that the payouts of the fund are going to closely resemble level perpetuities of $2.1 million per year. The interest rate is 10%. You plan to fully fund the obligation using 5-year and 20-year maturity zero-coupon bonds. a. How much market value of each of the zeros will be necessary to fund the plan if you desire an immunized position? (Do not round intermediate calculations....
You manage a pension fund that will provide retired workers with lifetime annuities. You determine that...
You manage a pension fund that will provide retired workers with lifetime annuities. You determine that the payouts of the fund are essentially going to resemble level perpetuities of $1.3 million per year. The interest rate is 7%. You plan to fully fund the obligation using 5-year and 20-year maturity zero-coupon bonds. a. How much market value of each of the zeros will be necessary to fund the plan if you desire an immunized position? (Do not round intermediate calculations....
You manage a pension fund that will provide retired workers with lifetime annuities. You determine that...
You manage a pension fund that will provide retired workers with lifetime annuities. You determine that the payouts of the fund are essentially going to resemble level perpetuities of $1.5 million per year. The interest rate is 10%. You plan to fully fund the obligation using 5-year and 20-year maturity zero-coupon bonds. a. How much market value of each of the zeros will be necessary to fund the plan if you desire an immunized position? (Do not round intermediate calculations....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT