Question

In: Accounting

I need show work also 6.) Use the pension formula (including a projection of future salary...

I need show work also

6.)

Use the pension formula (including a projection of future salary levels) to determine the retirement benefits earned to date.

FACTS:

The company has a defined benefit plan

Jessica's salary at the end of 2017 is

$    119,000

Retirement expected after

45

years of service

Retirement period is expected to be

20

years

Interest Rate

4.0%

Benefits are calculated as a formula as the product of:

Service already provided

22

years

Percentage

3.0%

Final year's salary is projected to be

$    250,000

Solutions

Expert Solution

1)Pension Formula to determine retirement benefits earned to date

1.5% * Years of Service * Final Year's Salary(to take in account of inflation)

=0.015* 22years(below)* 250,000 =82,500 Per Year.

   **this estimates the employee has earned (till2017) of retirement benefit. that's why 22years**

2)Find Present Value of retirement benefits as of retirement Date

Number of year from retirement,n=20years(retirement period)

inerest rate,i=4%

PV of retirement annuity at retirement date ==82,500*13.5903 (w1) =1,121,200

**using annuity because equal amount for a period of ime.

annuity factor can be obtained from PV of aanuity table for 20years @4%

or

(W1) ==82,500*13.5903 =1,121,200

2)Find Present Value of retirement benefits as of now (2017)

n,years from 2017 now to retirement=45 total - 22 service till now =23years

i=4% =r

Present Value of retirement benefit = 1,121,200 8 pv factor 23years @4%

=1,121,200 * 0.4057(w2)

=454,870

W2) PV = = =0.4057


Related Solutions

please use excel to do it. it also need to come with formula. formula is very...
please use excel to do it. it also need to come with formula. formula is very important. many many thanks. Prepare a sales budget for January through March and for the Quarter in total. The selling price per unit is $50.00. December of the previous year           20,000 January                                     100,000 February                                   80,000 March                                       60,000 April                                         40,000                           2. Prepare a purchases budget and the schedule for Disbursements for Purchases for January through March and for the first quarter in total. Assume...
Show all your work (use of formula, etc.) in solving the problems. You still need to...
Show all your work (use of formula, etc.) in solving the problems. You still need to show your work even if you use the financial calculator to get the answers. (Please show all work and do not use excel) 3. Forrest Corporation has 500,000 shares of common stock, 10,000 shares of preferred stock, and 5,000 bonds with 8 percent (coupon) outstanding. The common stock currently sells for $25 per share and has a beta of 0.95. Preferred stocks pay a...
Show all your work (use of formula, etc.) in solving the problems. You still need to...
Show all your work (use of formula, etc.) in solving the problems. You still need to show your work even if you use the financial calculator to get the answers. (Please show all work and do not use excel) 2. At an output level of 2,000 units, you calculate that the degree of operating leverage is 3. Fixed costs are $35,000. (a) If output rises to 2,500 units, calculate the percentage change in OCF, new OCF and new DOL. (b)...
Show all your work (use of formula, etc.) in solving the problems. You still need to...
Show all your work (use of formula, etc.) in solving the problems. You still need to show your work even if you use the financial calculator to get the answers. 3. You are taking out a thirty-year mortgage loan of $470,000 from your bank. The interest rate is 4 percent per year, and the loan calls for equal monthly payments. How much interest is paid in the fourth month? How much total principal is paid after four months? (Draw an...
Show all your work (use of formula, etc.) in solving the problems. You still need to...
Show all your work (use of formula, etc.) in solving the problems. You still need to show your work even if you use the financial calculator to get the answers. Please do not use excel. Thank you! 3. You are taking out a thirty-year mortgage loan of $470,000 from your bank. The interest rate is 4 percent per year, and the loan calls for equal monthly payments. How much interest is paid in the fourth month? How much total principal...
Show all your work (use of formula, etc.) in solving the problems. You still need to...
Show all your work (use of formula, etc.) in solving the problems. You still need to show your work even if you use the financial calculator to get the answers. 5. Rizzi Co. is growing quickly. The company just paid a $1.6 per share dividend and dividends are expected to grow at a 25%, 15% and 10% rate respectively for the next three years, with the growth rate falling off to a constant 6 percent thereafter. If the required return...
Show all your work (use of formula, etc.) in solving the problems. You still need to...
Show all your work (use of formula, etc.) in solving the problems. You still need to show your work even if you use the financial calculator to get the answers. 4. Bond Q is a 4 percent coupon bond. Bond R is an 6 percent coupon bond. Both bonds have 15 years to maturity, make annual coupon payments, and have a YTM of 6 percent. If interest rate (YTM) changes from 6 percent to 8 percent, what is the percentage...
Show all your work (use of formula, etc.) in solving the problems. You still need to...
Show all your work (use of formula, etc.) in solving the problems. You still need to show your work even if you use the financial calculator to get the answers. Please do not use excel. Thank you! 4. Bond Q is a 4 percent coupon bond. Bond R is an 6 percent coupon bond. Both bonds have 15 years to maturity, make annual coupon payments, and have a YTM of 6 percent. If interest rate (YTM) changes from 6 percent...
Show all your work (use of formula, etc.) in solving the problems. You still need to...
Show all your work (use of formula, etc.) in solving the problems. You still need to show your work even if you use the financial calculator to get the answers. Please do not use excel. 2. At an output level of 2,000 units, you calculate that the degree of operating leverage is 3. Fixed costs are $35,000. (a) If output rises to 2,500 units, calculate the percentage change in OCF, new OCF and new DOL. (b) If output falls to...
Use Excel to show your work and include the formula in the cell to show how...
Use Excel to show your work and include the formula in the cell to show how you arrived at your figures. Round percentages (example if 49.2, round to 49). Background: ABC, Inc., produces widgets. The company manufactures three levels of widgets-Economy, Better and Best. Selected information on the widgets is given below. Economy Better Best Selling price per widget $40.00 $60.00 $90.00 Variable expense per widget production $22.00 $27.00 $31.50 Selling (5% of selling price) $2.00 $3.00 $4.50 All sales...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT