(Solution) 17-57 Cumulative Spreadsheet Analysis This Assignment Is A Detailed Examination Of Skywalker's Pension-related Items. As Of December 31, 2013, The | Snapessays.com


(Solution) 17-57 Cumulative Spreadsheet Analysis This assignment is a detailed examination of Skywalker's pension-related items. As of December 31, 2013, the


17-57 Cumulative Spreadsheet Analysis

 

This assignment is a detailed examination of Skywalker’s pension-related items. As of December 31, 2013, the $253 in “Other long-term liabilities” reported by Skywalker included an amount for a net pension liability. In addition, Skywalker’s $456 in “Other operating expenses” for 2013 included an amount for net pension expense.

 

The following information relates to Skywalker’s pension plan as of December 31, 2013.

 

Fair value of pension fund assets $200

 

Discount rate used in valuing the PBO 7%

 

Long-term expected rate of return on pension fund assets 9%

 

Total annual pension payment earned by Skywalker’s employees so far $50

 

Number of years that employees are expected to receive pension payments after retirement 30 years

 

Number of years until first pension payment is to be received 11 years

 

Construct a spreadsheet to calculate the following:

 

1. Given the information above, compute the net pension liability that Skywalker will report as of December 31, 2013. (Note: Be careful in computing the PBO; remember that the standard annuity formula yields the present value of the annuity one year before the first payment is received.)

 

2. Compute a forecast of Skywalker’s net pension liability as of December 31, 2014, and net pension expense for 2014 using the following information:

 

• By working an extra year in 2014, the total annual pension payment earned by Skywalker’s employees is expected to increase from $50 to $55.

 

• Skywalker’s employees will be one year closer to receiving the first pension payment.

 

• No pension benefits are expected to be paid to employee in 2014.

 

• Skywalker expects to contribute $50 to the pension plan during 2014.

 

• Skywalker’s best estimate is that the pension fund assets will earn in 2014 an amount equal to the long-term expected rate of return

 

3.Repeat (1) and (2) using the following information:

 

a)The discount rate is 8%, and the long-term expected rate of return on the pension fund assets is 12%

 

b)The discount rate is 5%, and the long-term expected rate of return on the pension fund assets is 11%

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: May 23, 2022

Solution~00021147602896.zip (25.37 KB)


This attachment is locked

Our expert Writers have done this assignment before, you can reorder for a fresh, original and plagiarism-free copy and it will be redone much faster (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

May 23, 2022

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • ■ As a reference for in-depth understanding of the subject.
  • ■ As a source of ideas / reasoning for your own research (if properly referenced)
  • ■ For editing and paraphrasing.

This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

Get Free Price Quote