HRC Company sponsors a defined benefits pension plan to its employees. On January 1, 2021, the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
HRC Company sponsors a defined benefits pension plan to its employees. On January 1, 2021, the balances related to pension plan were as follows: Projected benefit obligation (PBO) Fair value of plan assets AOCI - Prior service cost AOCI -Net Loss The discount (or settlement) rate applicable to the plan is 10%. On January 1, 2022, the company amends the pension agreement resulting in a prior service cost of $260,000. The company uses straight- line amortization of prior service costs over the average remaining service life of the employees. Other data related to the pension plan are as follows: $2,600,000 $2,500,000 assumptions Expected return on plan assets Average service life of all employees -0- Service cost Contributions (funding) to the plan Benefits paid to retirees Actual return on plan assets Increase in PBO due to changes in actuarial 2021 $150,000 500,000 220,000 150,000 250,000 10% 2022 $170,000 880,000 280,000 200,000 10% 10 years Required: 1. Prepare Pension worksheet for the year 2021 and 2022 in Excel. Make sure to include all accompanying computations at the bottom of the worksheet (such as amortization of gain/losses). 2. Prepare the necessary journal entries for each year associated with the defined benefits pension plan for HRC. 3. What different amount(s)/ balances will be reported in the income statement and balance sheet at the end of year 2021 and 2022? 4. Is the pension plan underfunded or overfunded at the end of 2022 based on your computations? 5. Based on your answer for requirement 4, does HRC needs to increase or decrease the contributions to the pension plan in future assuming no immediate changes in actuarial assumptions? Why? 6. What journal entry would be recorded by HRC at the end of 2021 and 2022, if it was a defined contributions plan instead of defined benefits pension plan? Which of the two pension plans is a better choice for the HRC company and Why? HRC Company sponsors a defined benefits pension plan to its employees. On January 1, 2021, the balances related to pension plan were as follows: Projected benefit obligation (PBO) Fair value of plan assets AOCI - Prior service cost AOCI -Net Loss The discount (or settlement) rate applicable to the plan is 10%. On January 1, 2022, the company amends the pension agreement resulting in a prior service cost of $260,000. The company uses straight- line amortization of prior service costs over the average remaining service life of the employees. Other data related to the pension plan are as follows: $2,600,000 $2,500,000 assumptions Expected return on plan assets Average service life of all employees -0- Service cost Contributions (funding) to the plan Benefits paid to retirees Actual return on plan assets Increase in PBO due to changes in actuarial 2021 $150,000 500,000 220,000 150,000 250,000 10% 2022 $170,000 880,000 280,000 200,000 10% 10 years Required: 1. Prepare Pension worksheet for the year 2021 and 2022 in Excel. Make sure to include all accompanying computations at the bottom of the worksheet (such as amortization of gain/losses). 2. Prepare the necessary journal entries for each year associated with the defined benefits pension plan for HRC. 3. What different amount(s)/ balances will be reported in the income statement and balance sheet at the end of year 2021 and 2022? 4. Is the pension plan underfunded or overfunded at the end of 2022 based on your computations? 5. Based on your answer for requirement 4, does HRC needs to increase or decrease the contributions to the pension plan in future assuming no immediate changes in actuarial assumptions? Why? 6. What journal entry would be recorded by HRC at the end of 2021 and 2022, if it was a defined contributions plan instead of defined benefits pension plan? Which of the two pension plans is a better choice for the HRC company and Why?
Expert Answer:
Answer rating: 100% (QA)
Im sorry but I cannot create an Excel worksheet as I am a textbased AI language model However I can provide you with the necessary calculations and information to prepare the pension worksheet journal ... View the full answer
Related Book For
Intermediate Accounting
ISBN: 978-0077400163
6th edition
Authors: J. David Spiceland, James Sepe, Mark Nelson
Posted Date:
Students also viewed these accounting questions
-
The Lane Company was incorporated in 2001. Because it had become successful, the company established a defined benefit pension plan for its employees on January 1, 2010. Due to the loyalty of its...
-
Lemke Company sponsors a defined benefit pension plan for its employees. The following data relate to the operation of the plan for the years 2020 and 2021. Instructions a. Prepare a pension...
-
The following questions are used in the Kaplan CPA Review Course to study pensions and other postretirement benefits while preparing for the CPA examination. Determine the response that best...
-
The annual consumption of beef per person was about 64 7 lb in 2000 and about 60 3 lb in 2007 Assume B(t), the annual beef consumption t years after 2000, is decreasing according to the exponential...
-
Treatment of accounting errors, changes in accounting principles, and changes in accounting estimates. A firm computes net income for 2008 of $1,500 and for 2009 of $1,800, its first two years of...
-
Selected data for Dalton Company for Year 3 and additional information on industry averages follow. Required a. Calculate Dalton Companys earnings per share ratio, price-earnings ratio, and return on...
-
What is a SystemOperations Concept? Identify examples of its UCs.
-
Rachael Ray Corporation had the following transactions. 1. Sold land (cost $12,000) for $15,000. 2. Issued common stock for $20,000. 3. Recorded depreciation of $17,000. 4. Paid salaries of $9,000....
-
The radius of our Sun is 6.96x108 m, and its total power output is 3.85x1026 W. a. Assuming the Sun's surface emits as a blackbody, calculate its surface temperature. b. What is the Sun's peak...
-
1. After examining financial data for a monthly period, the owner of a small business expressed surprise that the firms cash balance had decreased during the month even though there was substantial...
-
Show an example of table (with business meaning) that is in 3NF, but not in BCNF. Give explanation of your example. Dont use the example discussed in text or in class (PPT). Note, to show such as...
-
Sylvia is planning an investment. Her annual combined Federal and provincial marginal tax rate is 32%. If she invests $1,000 every year for 3 years starting today, how much after-tax income will she...
-
The bond has a face value of $1000 and is bought at par with a coupon rate of 5%. After one year, the market yield on the bond changes to 9 %. Yrs to maturity Initial curr yield Initial P(t) P(t+1)...
-
Suppose you are the financial manager of a firm considering the following five projects. Project A Project B Project C Project D Project E Initial Investment -$10,000 -$15,000 -$14,000 -$6,000...
-
Joe purchases 3 sandwiches and 5 slices of pizza per month. At this, consumption bundle, Joe's marginal rate of substituting pizza for sandwich is 2/5. The price of sandwich is $6 and price of pizza...
-
In the table given , Singapores balance of payments (BoP) comprises: (a) Current account of goods, services & factor income (primary & secondary income balance) (b) Capital & Financial account as DFI...
-
Lando Company reported the following amounts for the year 2013: Raw materials purchased $88,000 Beginning inventory of raw materials 5,200 Ending inventory of raw materials 4,500 Beginning inventory...
-
Given that all the choices are true, which one concludes the paragraph with a precise and detailed description that relates to the main topic of the essay? A. NO CHANGE B. Decades, X-ray C. Decades...
-
Explain the method generally used to allocate the cost of a lump-sum purchase to the individual assets acquired.
-
Construction Forms Corporation buys securities to be available for sale when circumstances warrant, not to profit from short-term differences in price and not necessarily to hold debt securities to...
-
A company issued 5%, 20-year bonds with a face amount of $100 million. The market yield for bonds of similar risk and maturity is 4%. Interest is paid semiannually. At what price did the bonds sell?
-
a. Nonlinearity in mass b. Nonlinearity in damping c. Linear equation d. Nonlinearity in spring \(\ddot{x}+f \frac{\dot{x}}{|\dot{x}|}+\omega_{n}^{2} x=0\)
-
a. Nonlinearity in mass b. Nonlinearity in damping c. Linear equation d. Nonlinearity in spring \(\ddot{x}+\omega_{0}^{2}\left(x-\frac{x^{3}}{6} ight)=0\)
-
Prove that, for the system considered in Section 13.5.1, the minimum value of \(\omega^{2}\) for which the amplitude of subharmonic oscillations \(A\) will have a real value is given by...
Study smarter with the SolutionInn App