Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please use excel for any work Three employees of the Horizon Distributing Company will receive annual pension payments from the company when they retire. The
please use excel for any work
Three employees of the Horizon Distributing Company will receive annual pension payments from the company when they retire. The employees will receive their annual payments for as long as they live. Life expectancy for each employee is 15 years beyond retirement. Their names, the amount of their annual pension payments, and the date they will receive their first payment are shown below: Compute the present value of the pension obligation to these three employees as of December 31, 2016. Assume an 11% interest rate. The company wants to have enough cash invested at December 31, 2019, to provide for all three employees. To accumulate enough cash, they will make three equal annual contributions to a fund that will earn 11% interest compounded annually. The first contribution will be made on December 31, 2016. Compute the amount of this required annual contributionStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started