Question

In: Accounting

What dollar amount does your firm report for its defined-benefit pension plan and its OPEB plan on its year-end 2016 balance sheet?

Use the following information answer the questions below.

Company Name :- XEROX CORP

Total liabilities ($millions)         $ 13090

Total assets ($millions)               $ 18051

Net operating cash flows ($millions)                            $ 1095

Income from continuing operations ($millions)           $ 1349

  

Pension plan assumptions

      Discount rate 4.1 %      Expected asset return 5.8 %    Rate of salary increase 21  %

Pension plan disclosures

Projected benefit obligation ($millions)                       $ 1120

Fair value of pension plan assets ($millions)               $ 1123

Accumulated benefit obligation ($millions)                 $ 2230

Cash contributions to the pension plan during the year ($millions)                                 $ 1350

% of pension assets invested in equities 23 %

% of pension assets invested in bonds 28 %

OPEB disclosures

Expected postemployment benefit obligation ($millions)                                     $ 2305

Accumulated postemployment benefit obligation ($millions)                                     $ 4421

Fair value of plan assets ($millions)   $ 2230

From 2016 and previous financial statements

Actual percentage return on pension plan assets ($ actual return / $ beginning of year fair value of plan assets)

2016 5.6 %    2015 4.55 %   2014 6.3 %   2013 4.2  %   2012 3.98 %    2011 2.22 %

1. What dollar amount does your firm report for its defined-benefit pension plan and its OPEB plan on its year-end 2016 balance sheet? Prove this amount by reconciling from the related off-balance sheet footnote accounts.

2. What dollar amount does your firm report for its defined-benefit pension plan and its OPEB plan on its year-ending 2016 income statement?

3. Are your firm's defined-benefit pension plan and/or its OPEB plan material to your firm's financial position and financial performance? Explain using selected data from your firm's financial statements.

4. Are your firm's defined-benefit pension plan and its OPEB plan well-funded or poorly funded as of year-end 2016? Explain.

5.  Is your firm's 2016 expected return on plan assets assumption reasonable? Explain.

NOTE: At a minimum compare your firm's expected return on plan assets in 2016 with its average (geometric mean) return over the past 6 years. See details on computing the mean return below.

6. Defined-benefit pension plans and OPEB plans typically generate temporary differences between financial books and tax books. Discuss the significance of your firm's defined-benefit pension plans and OPEB plans to its year-end 2016 deferred tax accounts. Use dollar amounts from the tax footnote.

*Compute average (geometric mean) return

Suppose that in 3 successive years the return on an investment is 5%, 20%, and -4%. The geometric mean, or compound annual rate of return, is computed as:

             [(1.05)*(1.20)*0.96)]1/3 -1 = 0.065 = 6.5%

Solutions

Expert Solution

To solve this question just input those variables which are to be used in logistic regression, as the question talks about using two variables only that is total loans and leases to total assets & total expenses/ total assets, so we will not input total cap/assets as an input variable in our excel, here we go

As one can see, we have taken only two variables , total exp/assets and total lns & leases/ assets in calculation, follwing steps have been followed to construct the above table

1. Assume logit= b0+ b1* independent variable1+ b2* independent variable 2 , take values of b0=0.1, b1=0.1, b2=0.1, note that these values of b0, b1 and b2 are just taken for calculation, one could assume any values here for bo , b1 and b2

2. Calculate exponential of logit in the next column by using exp (value in previous column)

3. Calculate probability by using formula, probability= exp (logit)/ { 1+ exp(logit)} in the next column

4. In next column, calculate log likelihood by using formula : financial condition value (i.e. 1 or 0) * LN( probability calculated in previous column) + (1- financial condition value)* LN( 1- probability calculated in previous column)

5. take the total of the column values of log likelihood

6. use solver function in excel to change this total by putting max value of 0 and changing the variable cells containing assumed values of b0, b1 and b2 , by clicking on solve, you will get actual values of b0, b1 and b2

which comes out to be b0=-14.72, b1=89.83, b2= 8.37

therefore you will get logit as

-14.72+ 89.83* Total exp/assets+8.37*Total lns & lsses/ assets

With values given in the question as total exp/ assets= 0.11 and total loans & leases/ assets= 0.6 , we get

logit as -14.72+ 89.83* 0.11+ 8.37*0.6= 0.1833

exp (logit) = 1.20

Probability= 0.546

Loglikelihood= 1*LN(0.546)+0*LN(1-0.546)= LN(0.546)= -0.605


Related Solutions

At year end, a company has a defined benefit pension plan with a projected benefit obligation...
At year end, a company has a defined benefit pension plan with a projected benefit obligation of $350,000; a net gain of $140,000 that was not previously recognized in net periodic pension cost; and prior service cost of $210,000 that was not previously recognized in net periodic pension cost. What amount should be reported in accumulated other comprehensive income related to the company's defined benefit pension plan at year end? A credit balance of $420,000. A debit balance of $420,000....
What is the difference between a Defined Benefit Pension Plan and a Defined Contribution Pension Plan.?...
What is the difference between a Defined Benefit Pension Plan and a Defined Contribution Pension Plan.? Why have Defined Contribution Plans become more popular? Froman employees perspective, which one do you think is more attractive?
Panther Company currently sponsors a defined benefit pension plan for its employees. At the end of...
Panther Company currently sponsors a defined benefit pension plan for its employees. At the end of 2016, the plan had a projected benefit obligation of $1,456,000 and fair value of plan assets of $1,629,000. Panther recognized a net pension asset in its balance sheet of $173,000 at the end of 2016. Due to the plans overfunded position, Allison Costello, Panther's CFO, is interested in finding out if it is possible to settle or curtail the plan. Specifically, she is interested...
What are the advantages and disadvantages for defined benefit pension plan and a defined contribution pension...
What are the advantages and disadvantages for defined benefit pension plan and a defined contribution pension plan each compared to the other?
Thorp Inc. maintains a defined benefit pension plan for its employees. Pension plan balances as at...
Thorp Inc. maintains a defined benefit pension plan for its employees. Pension plan balances as at January 1, 2020 include: Projected Benefit Obligation (PBO), January 1, 2020 $ 600,000 Plan assets at market-related value, January 1, 2020 $ 550,000 Prior service cost (PSC- OCI)1 $ 150,000 Average remaining service period 15 years Service cost $ 90,000 Expected returns on plan assets 8% Actual returns earned on plan assets $40,000 Actuarial interest rate 4% Contributions paid $ 150,000 Benefits to retirees...
Thorp Inc. maintains a defined benefit pension plan for its employees. Pension plan balances as at...
Thorp Inc. maintains a defined benefit pension plan for its employees. Pension plan balances as at January 1, 2020 include:     Projected Benefit Obligation (PBO), January 1, 2020 $ 600,000     Plan assets at market-related value, January 1, 2020   $ 550,000     Prior service cost (PSC- OCI)1 $ 150,000 Average remaining service period 15 years    Service cost $ 90,000    Expected returns on plan assets   8% Actual returns earned on plan assets    $40,000 Actuarial interest rate   4%    Contributions paid $ 150,000 Benefits to retirees...
4. Johnson Corporation sponsors a defined benefit pension plan for its employees. On January 1, 2016,...
4. Johnson Corporation sponsors a defined benefit pension plan for its employees. On January 1, 2016, the     following balances relate to this plan. Plan assets                                                         $500,000 Defined benefit obligation 800,000 Pension asset/liability 300,000 As a result of the operation of the plan during 2016, the following additional data are provided by the actuary. Service cost for 2016                                                                                       $150,000 Discount (interest) rate 8% Actual return on plan assets in 2016 60,000 Unexpected loss from change in defined benefit obligation, due...
Pen Fen Corp has a defined benefit pension expense plan for its employees. In the year...
Pen Fen Corp has a defined benefit pension expense plan for its employees. In the year ended Dec 31, 2019, Pen Fen gathered the following information ( the company uses ASPE) Contributions ......................................................... $500,000 Expected & Actual Return on Plan Assets ....... 10% Interest rate on Obligations ................................ 12% Service costs relating to past services ............. $100,000 Actuarial Loss ....................................................... $40,000 Current Service costs .......................................... $630,000 DBO – Jan 1 ,2019................................................ $720,000 FV Plan Assets – Jan 1 , 2019...............................
Defined Benefit Plan Assignment The following information pertains to Company A's Year 5 defined benefit pension...
Defined Benefit Plan Assignment The following information pertains to Company A's Year 5 defined benefit pension plan: January 1, Year 5, fair value of plan assets $100,000    January 1, Year 5, projected benefit obligation (PBO) 200,000    Contribution to the plan (made on December 31, Year 5)    10,000 Benefits paid to employees (made on December 31, Year 5)    15,000 December 31, Year 5, fair value of plan assets    106,000    Discount Rate    5%    Expected...
The Jayson Company has had a defined benefit pension plan for several years. At the end...
The Jayson Company has had a defined benefit pension plan for several years. At the end of 2016, Jayson had the following balances related to the plan:            Projected benefit obligation                                                                            $980,000            Unrecognized prior service cost (remainder to be amortized over 10 years)             72,000            Unrecognized net loss                                                                                        128,000            Plan assets (at fair value)                                                                                   725,000            Pension liability                                                                                                255,000 On 1/1/17, Jayson amended the plan to provide an increased amount of pension benefits; the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT