Question

In: Accounting

Reformulating Financial Statements for Pension Contributions Xerox Corporation reports the following pension and retiree health care...

Reformulating Financial Statements for Pension Contributions Xerox Corporation reports the following pension and retiree health care (“Other”) footnote as part of its 10-K report. December 31, 2015 ($ millions) Pension Benefits Retiree Health Change in Benefit Obligation Benefit obligation, January 1 $ 12,410 $ 947 Service cost 36 7 Interest cost 295 34 Plan participants’ contributions 4 14 Actuarial loss (332) (4) Currency exchange rate changes (538) (25) Plan amendments and curtailments (17) (31) Benefits paid/settlements (638) (77) Benefit obligation, December 31 $ 11,220 $ 865 Change in Plan Assets Fair value of plan assets, January 1 $ 9,736 $ - Actual return on plan assets (89) - Employer contribution 319 63 Plan participants’ contributions 4 14 Currency exchange rate changes (440) - Benefits paid/settlements (638) (77) Other (4) - Fair value of plan assets, December 31 $ 8,888 $ - Net funded status at December 31 $ (2,332) $ (865) December 31, 2015 ($ millions) Pension Benefits Retiree Health Components of Net Periodic Benefit Cost Service cost $ 36 $ 7 Interest cost 295 34 Expected return on plan assets (376) - Recognized net actuarial loss 96 1 Amortization of prior service credit 2 (18) Recognized settlement loss 89 - Recognized curtailment loss - (22) Defined benefit plans 142 2 Defined contribution plans 100 - Total net periodic cost $ 242 $ 2 Other Changes in Plan Assets and Benefit Obligations Recognized in Other Comprehensive Income Net actuarial loss $ 125 $ (4) Prior service credit (16) (32) Amortization of net actuarial loss (185) $(1) Amortization of net prior service credit (2) 18 Curtailment gain - 22 Total recognized in other comprehensive income $ (78) $ 3 Use the above information, along with the two prior years’ information below, to answer the requirements. $ millions 2013 2014 Cash contributions to pension plan $253 $307 a. Use the three-year average of the employer contribution to pension benefits (in dollar terms) to reformulate the statement of cash flows for each of the three years 2013, 2014, and 2015. See Analyst Adjustments 10.2 for guidance in the reformulation process. Compute the 3 year average employer contribution to pension benefits. Round to the nearest whole number. $Answer ($ millions) Use rounded figure for subsequent computations. Use negative signs with answers to indicate adjustments that reduce account balances. Statement of Cash Flow Adjustments 2013 2014 2015 Cash contribution $Answer $Answer $Answer Cash from operations $Answer $Answer $Answer b. Reformulate the balance sheet for each of the three years 2013, 2014, and 2015. Assume a tax rate of 35%. Round answers to the nearest whole number. Use negative signs with answers to indicate adjustments that reduce account balances. Balance Sheet Adjustments 2013 2014 2015 Cash balance $Answer $Answer $Answer Deferred tax assets $Answer $Answer $Answer Total assets $Answer $Answer $Answer Retained earnings $Answer $Answer $Answer

Solutions

Expert Solution

Based on the information provided in the, the values are derived as follows:

b) What is the actual return on the pension and the health care ("Other") plan investments in 2010? = 89 + 0 = $89 million

_____

e) How much cash did Xerox contribute to its pension and health care plans in 2010? =

Pension = $319 million

Healthcare = $63 million

_____

f) How much cash did retirees receive in 2010 from the pension plan and the health care plan?

Pension = $638 million

Healthcare = $77 million

How much cash did Xerox pay these retirees in 2010? $0 million

_____

g) Show the computation of the 2010 funded status for the pension and health care plans.

Pension = Fair Value of Plan Assets, December 31 - Benefit Obligation, December 31 = 8,888 – 12,410 =-$3,522 or $3,522 million (as negative signs are not to be included)

Healthcare = 0 - Benefit Obligation, December 31 = 0 - 947 = -$947or $947 million (as negative signs are not to be included)


Related Solutions

Analyzing and Interpreting Pension and Health Care Footnote Assume Xerox reports the following pension and retiree...
Analyzing and Interpreting Pension and Health Care Footnote Assume Xerox reports the following pension and retiree health care ("Other") footnote as part of its 10-K report. Pension Benefits Retiree Health (in millions) 2010 2009 2010 2009 Change in Benefit Obligation Benefit obligation, January 1 $ 10,467 $ 10,302 $ 1,592 $ 1,653 Service cost 237 244 17 19 Interest cost 578 732 87 92 Plan participants' contributions 12 13 20 19 Plan amendments 11 (234) -- 31 Acturarial gain (508)...
The following data are available pertaining to Household Appliance Company's retiree health care plan for 2021:...
The following data are available pertaining to Household Appliance Company's retiree health care plan for 2021: Number of employees covered 2 Years employed as of January 1, 2021 2 [each] Attribution period 25 years Expected postretirement benefit obligation, Jan. 1 $ 63,000 Expected postretirement benefit obligation, Dec. 31 $ 66,150 Interest rate 5 % Funding none Required: 1. What is the accumulated postretirement benefit obligation at the beginning of 2021? 2. What is interest cost to be included in 2021...
Clouston Container Corporation reports the following data in its December 31, 2019 Financial Statements: Sales =...
Clouston Container Corporation reports the following data in its December 31, 2019 Financial Statements: Sales = $225,000 Current Assets = $50,000 Long-Term Assets = $130,000 Current Liabilities = $33,000 Long-Term Liabilities = $52,000 Net Income = $11,250 Compute Owner’s Equity_____________________________ Compute the Current Ratio___________________________ Complete Debt-to-Equity Ratio________________________ Complete Return on Sales____________________________ Complete Return on Owner’s Equity____________________ Pick two of these ratios and discuss how this company is doing relative to the ratio.
Reformulating Financial Analysis for Equity Method Investments Cummins Inc. reports investments in affiliated companies, consisting mainly...
Reformulating Financial Analysis for Equity Method Investments Cummins Inc. reports investments in affiliated companies, consisting mainly of investments in nine manufacturing joint ventures. Cummins reports those investments on its balance sheet at $958 million and provides the following financial information on its investee companies in a footnote to its 10-K report. Equity Investee Financial Summary As of and for the years ended Dec. 31 $ millions 2015 2014 2013 Net sales $5,946 $7,426 $7,799 Gross margin 1,265 1,539 1,719 Net...
Reformulating Financial Analysis for Equity Method Investments Cummins Inc. reports investments in affiliated companies, consisting mainly...
Reformulating Financial Analysis for Equity Method Investments Cummins Inc. reports investments in affiliated companies, consisting mainly of investments in nine manufacturing joint ventures. Cummins reports those investments on its balance sheet at $958 million and provides the following financial information on its investee companies in a footnote to its 10-K report. Equity Investee Financial Summary As of and for the years ended Dec. 31 $ millions 2015 2014 2013 Net sales $5,946 $7,426 $7,799 Gross margin 1,265 1,539 1,719 Net...
Reformulating Financial Analysis for Equity Method Investments Cummins Inc. reports investments in affiliated companies, consisting mainly...
Reformulating Financial Analysis for Equity Method Investments Cummins Inc. reports investments in affiliated companies, consisting mainly of investments in nine manufacturing joint ventures. Cummins reports those investments on its balance sheet at $958 million and provides the following financial information on its investee companies in a footnote to its 10-K report. Equity Investee Financial Summary As of and for the years ended Dec. 31 $ millions 2015 2014 2013 Net sales $5,946 $7,426 $7,799 Gross margin 1,265 1,539 1,719 Net...
The AICPA Audit and Accounting Guide Health Care Organizations requires that the following statements be prepared for health care organizations:
The AICPA Audit and Accounting Guide Health Care Organizations requires that the following statements be prepared for health care organizations:Question 5 options:Balance sheet, statement of operations, statement of changes in equity, statement of cash flows, statement of functional expensesBalance sheet, statement of revenues and expenses, statement of changes in equity, statement of cash flowsBalance sheet, statement of operations, statement of changes in equity, statement of cash flowsBalance sheet, statement of activities, statement of changes in equity, statement of cash flows
Using the information presented in the Financial Statements of United Health Care, a major HMO, compute...
Using the information presented in the Financial Statements of United Health Care, a major HMO, compute financial ratios for 1994 and 1995 and discuss some of the primary observations that you would conclude regarding the financial performance of the firm. Provide an overall evaluation of the financial position of this company. United Healthcare Financial Ratios                                                                         Health Plan Median                   2017     2016     2015     Liquidity             Current                                                  1.32                              1.18      2.87      .93             Days in Receivables                                 22.5                             ?          ?         ...
Using the information presented in the Financial Statements of United Health Care, a major HMO, compute...
Using the information presented in the Financial Statements of United Health Care, a major HMO, compute financial ratios for 1994 and 1995 and discuss some of the primary observations that you would conclude regarding the financial performance of the firm. Provide an overall evaluation of the financial position of this company. United Healthcare Financial Ratios                                                                          Health Plan Median                          2017       2016       2015       Liquidity                 Current                                                                  1.32                                        ?              ?              .93                 Days in Receivables                                            22.5                                       ?              ?             ...
Using the information presented in the Financial Statements of United Health Care, a major HMO, compute...
Using the information presented in the Financial Statements of United Health Care, a major HMO, compute financial ratios for 2016 and 2017 and discuss some of the primary observations that you would conclude regarding the financial performance of the firm. Provide an overall evaluation of the financial position of this company. United Healthcare Financial Ratios                                                                          Health Plan Median                          2017       2016       2015       Liquidity                 Current                                                                  1.32 ? ? .93                 Days in Receivables                                            22.5                                       ?              ?             ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT