2019. Sisters Inc., is now a worldwide pet food conglomerate, run by two sisters, Big Sister, the CEO, and Little Sister, the President. As a result of a massive “we are the 100% minus 1% strike,” that attracted national media attention, the company started negotiating a new union agreement with its employee union, “Pets R. US” effective January 1, 2019, and as the new union representative, Guy W.G. Shepherd is responsible for determining how the agreement will impact the company’s overhead, especially its defined benefit pension plan.
Moreover, Guy needs to decide if the agreement is fair and whether Sisters Inc. is not “lowballing” and can really afford to provide a higher pension expense to its employees and avoid future labor strikes.
As a threshold for “lowballing,” the union agreed that pension expense should be at least 1% of Sister’s budgeted net income for 2020, based on what other pension plans are offering and the theme of the last labor strike. Therefore, if the pension expense is greater than 1% of budgeted net income, Guy W.G. Shepherd is prepared to accept Sisters’ proposal on behalf of “Pets R Us.” If it is less than 1%, it’s back to the drawing board for further negotiations.
At first, Sisters Inc. wanted to delay the negotiations and give W.G. Shepherd some pumpkin and chicken (his favorite meal) and even offered to invite him to his favorite ball game, but W.G. Shepherd refused since he didn’t want that to influence his decision-making ability as a steward and representative of the union.
After a late night of negotiations Sisters’ CEO Big Sister finally gave W.G. Shepherd something real to chew on. Sisters Inc. proposed a new defined pension plan called the “Meow Max Plan” that creates a defined benefit plan for employees who are expected to retire in six years at the end of 2025 since those were the employees who were most active in the recent strike.
Mew Max Pension Plan Details and Assumptions |
Employee Details |
||
Discount rate |
5.50% |
Start of Plan |
1 Jan. 2019 |
Pension Plan Benefit Payments |
Expected retirement date |
31 Dec. 2025 |
|
Annual payments are paid at year end and continue for 30 years, 100 employees are expected to retire in 2025. At this time, Sisters Inc. has made no plans to provide any contributions to the plan, but may decide to do so in a few years. |
Average Salary from last 5 years: |
$50,000 |
|
Estimated years in retirement |
30 |
Budgeted Net Income for 2020: $150 million
Benefit Formula: Average of Last 5 Years’ Salary × Number of Years of Service × 0.025
2. What is the present value of estimated future retirement payments at the start of retirement for one employee? (Hint: Use the amount calculated above as your annuity payment and the given assumptions above for the number of years and discount rate)
B. $90,143
C. $103,050
D. $109,003
3. What is the average undiscounted service cost earned by employees each year? (Hint: Divide the amount you calculated above by the number of years of service)
C. $18,167
D. $21,801
Benefit Formula: Average of Last 5 Years’ Salary × Number of Years of Service × 0.025 |
Average Salary from last 5 years: $50,000 |
Estimated Retirement Payment One Employee Will Earn At The End Of Year | |
USING Benifit Formula | |
= 50,000 * 6* 0.025 | |
7,500 |
Present Value Of Estimated Future Retirement Payments At The Start Of Retirement For One Employee |
Annuity Factor for 30 Years @ 5.5% Per Annum | 14.53375 |
Present Value Of Estimated Future Retirement = Annuity Factor * Estimated Retirement Payment
= 14.53375 * 7500 = 109,003
Average Undiscounted Service Cost Earned By Employees = Present Value Of Estimated Future Retirement / Number Of Years Of Service = 109,003 / 6 = 18,167 |
Discounted Service Cost Component | |||
At End of Year | Annual Service Cost | Discount Factor @ 5.5% | Present Value |
2025 | 18,167 | 1.0000 | 18,167.18 |
2024 | 18,167 | 0.9479 | 17,220.08 |
2023 | 18,167 | 0.8985 | 16,322.35 |
2022 | 18,167 | 0.8516 | 15,471.42 |
2021 | 18,167 | 0.8072 | 14,664.85 |
2020 | 18,167 | 0.7651 | 13,900.33 |
2019 | 18,167 | 0.7252 | 13,175.67 |
Projected Benefit Obligation at the end of 2019
= Discounted Service Cost Component * No. Of Employees
=13,176 * 100
= 1, 317,600
Service Cost At The End Of 2020 Assuming Just One Employee Was In The Plan | |||
At End of Year | Annual Service Cost | Discount Factor @ 5.5% | Present Value |
2025 | 18,167 | 1.0000 | 18,167.18 |
2024 | 18,167 | 0.9479 | 17,220.08 |
2023 | 18,167 | 0.8985 | 16,322.35 |
2022 | 18,167 | 0.8516 | 15,471.42 |
2021 | 18,167 | 0.8072 | 14,664.85 |
2020 | 18,167 | 0.7651 | 13,900.33 |
AS PER HOMEWORKLIB POLICY, IN CASE OF MULTIPLE SUBPARTS, WE CAN ANSWER UPTO AN EXTENT I.E. 4 SUBPARTS, BUT STILL I PROVIDE BEST POSSIBLE SUGGESTIONS WHICH WILL HELP YOU TO SOLVE FURTHER PARTS
2019. Sisters Inc., is now a worldwide pet food conglomerate, run by two sisters, Big Sister, the...
(S.0.3) Larsen Company has a defined benefit pension plan which covers 220 employees. Based upon negotiations with the employees, Larsen Company amends its pension plan as of 1/1/17 and grants $111,600 of prior service cost to its employees. The following schedule reflects employee groups based on expected years of retirement. Group A B C D E Number of Employees 30 40 35 70 45 220 Expected Retirement on 12/31 2017 2018 2019 2020 2021 . Instructions: Compute the annual amortization...
Cheyenne, Inc. is a furniture manufacturing company with 50 employees. Recently, after a long negotiation with the local labor union, the company decided to initiate a pension plan as a part of its compensation plan. The plan will start on January 1, 2020. Each employee covered by the plan is entitled to a pension payment each year after retirement. As required by accounting standards, the controller of the company needs to report the pension obligation (liability). On the basis of...
LARFAGE is French industrial company specializing in three major products: cement, construction aggregates, and concrete. Lafarge Zambia operates 2 integrated cement plants (situated in Ndola and Lusaka) with a total production capacity of 1.4 million tonnes per annum. The 440 direct employees supported by several hundred more contracted employees. As the key enablers of its strategy and vision, its people are at the heart of everything the company does. The Lafarge Group aspires to build and sustain a Learning Organization...
Sarasota, Inc. is a furniture manufacturing company with 50 employees. Recently, after a long negotiation with the local labor union, the company decided to initiate a pension plan as a part of its compensation plan. The plan will start on January 1, 2020. Each employee covered by the plan is entitled to a pension payment each year after retirement. As required by accounting standards, the controller of the company needs to report the pension obligation (liability). On the basis of...
* Question 6 Cheyenne Inc. has sponsored a noncontributory, defined benefit pension plan for its employees since 1997. Prior to 2020, cumulative net pension expense recognized equaled cumulative contributions to the plan. Other relevant information about the pension plan on January 1, 2020, is as follows. 1. The company has 200 employees. All these employees are expected to receive benefits under the plan. The average remaining service life per employee is 12 years. 2. The projected benefit obligation amounted to...
Sheridan Inc. has sponsored a noncontributory, defined benefit pension plan for its employees since 1997. Prior to 2020, cumulative net pension expense recognized equaled cumulative contributions to the plan. Other relevant information about the pension plan on January 1, 2020, is as follows. 1. The company has 200 employees. All these employees are expected to receive benefits under the plan. The average remaining service life per employee is 12 years. 2. The projected benefit obligation amounted to $4,903,000 and the...
Question 4 --/1 View Policies Current Attempt in Progress Sunland Inc. has sponsored a noncontributory, defined benefit pension plan for its employees since 1997. Prior to 2020, cumulative net pension expense recognized equaled cumulative contributions to the plan. Other relevant information about the pension plan on January 1, 2020, is as follows. 1. The company has 200 employees. All these employees are expected to receive benefits under the plan. The average remaining service life per employee is 12 years. 2....
P19.12 You are the auditor of Beaton and Gunter Inc., the Canadian subsidiary of a public multinational engineering company that offers a defined benefit pension plan to its eligible employees. Employees are permitted to join the plan after two years of employment, and benefits vest immediately. You have received the following information from the fund trustee for the year ended December 31, 2020: Discount rate 5% Rate of compensation increase 3.5% Defined Benefit Obligation Defined benefit obligation at January 1,...
E6.11 (LO4) (Evaluation of Purchase Options) Rossi Excavating Inc. is purchasing a bulldozer. The equipment has a price of €100,000. The manufacturer has offered a payment plan that would allow Rossi to make 10 equal annual payments of €15,582, with the first payment due 1 year after the purchase Instructions a. How much total interest will Rossi pay on this payment plan? b. Rossi could borrow €100,000 from its bank to finance the purchase at an annual rate of 8%....
To complete the assignment, you will be using financial statement excerpts from the 2018 10Ks of Delta, Honeywell, and Ford Motor Company. I have extracted the portions of the 10K you will require for the assignment and posted the information 2. What is the total amount of income taxes owed by Ford Motor Company in 2018? How much of the amount owed is due to federal, state & local and non-US government agencies? Excerpt from Ford Motor Company 2018 10K...