What is the cost or the amount required to purchase

Assignment Help Finance Basics

Reference no: EM132019974

Question: Erin O'Reilly was recently employed by the human resources department of a moderate-sized engineering firm. Management is considering the adoption of a defined-benefit pension plan in which the firm will pay 75 percent of an individual's last annual salary if the employee has worked for the firm for 25 years. The amount of the pension is to be reduced by 3 percent for every year less than 25, so that an individual who has been employed for 15 years will receive a pension of 45 percent of the last year's salary [75 percent - (10 x 3%)]. Pension payments will start at age 65, provided the individual has retired. There is no provision for early retirement. Continuing to work after age 65 may increase the individual's pension if the person has worked for less than 25 years or if the salary were to increase.

One of the first tasks given O'Reilly is to estimate the amount that the firm must set aside today to fund pensions. While management plans to hire actuaries to make the final determination, the managers believe the exercise may highlight some problems that they will want to be able to discuss with the actuaries. O'Reilly was instructed to select two representative employees and estimate their annual pensions and the annual contributions necessary to fund the pensions.

O'Reilly decided to select Arnold Berg and Vanessa Barber. Berg is 58 years old, has been with the firm for 27 years, and is earning $34,000. Barber is 47, has been with the firm for 3 years, and earns $42,000 annually. O'Reilly believes that Berg will be with the firm until he retires; he is a competent worker whose salary will not increase by more than 4 percent annually, and it is anticipated he will retire at age 65. Barber is a more valuable employee, and O'Reilly expects Barber's salary to rise at least 7 percent annually in order to retain her until retirement at age 65.

To determine the amount that must be invested annually to fund each pension, O'Reilly needs (in addition to an estimate of the amount of the pension) an estimate of how long the pension will be distributed (i.e., life expectancy) and how much the invested funds will earn. Since the firm must pay an interest rate of 8 percent to borrow money, she decides that the invested funds should be able to earn at least that amount. While O'Reilly believes she is able to perform the assignment, she has come to you for assistance to help answer the following questions.

a. If each individual retires at age 65, how much will his or her estimated pension be? (Show your work on Excel)

b. Life expectancy for both employees is 15 years at age 65. If the firm buys an annuity from an insurance company to fund each pension and the insurance company asserts it is able to earn 9 percent on the funds invested in the annuity, what is the cost or the amount required to purchase the annuity contracts? (Show your work on Excel)

c. If the firm can earn 8 percent on the money it must invest annually to fund the pension, how much will the firm have to invest annually to have the funds necessary to purchase the annuities? (Show your work on Excel)

Reference no: EM132019974

Questions Cloud

What is the most you can pay for the equipment : You have just been offered a contract worth $1.15 million per year for 5 years. However, to take the contract, you will need to purchase some new equipment.

Comment on the acceptability of the project : NPV Calculate the net present value (NPV) for a 30-year project with an initial investment of $10,000 and a cash inflow of $3,000 per year.

What does the concept of free cash flow represent : Nova Electrics anticipates cash flow from operating activities of $14 million in 20X1. It will need to spend $9.5 million on capital investments to remain.

Prepare room rate trend numbers from the average room rate : Prepare room rate trend numbers from the average room rate using 100% (or 100) as the base trend index number for Year 1

What is the cost or the amount required to purchase : Life expectancy for both employees is 15 years at age 65. If the firm buys an annuity from an insurance company to fund each pension and the insurance company.

Determine the net present value for the project : NPV and IRR Benson Designs has prepared the following estimates for a long-term project it is considering. The initial investment is $47,700.

Calculate mollycaits operating breakeven point : If Molly renegotiates the contract at a price of $10.00 per figurine, what will the EBIT be? Calculate Mollycaits' operating breakeven point

What is the value of ending inventory : Assuming that the company sold 17,000 units during the last six months of the year at $30 each, what would gross profit be?

How many books must JWG sell this year : How many books must JWG sell this year to achieve the breakeven point for the stated operating costs if all figures remain the same as for last year

User Account

All Pages