Using Excel to Account for Pensions PROBLEM Uvo Corporation is a private company with a defined benefit pension plan. The following information is available for Uvo Corporation for 2023. Opening balance, DBO Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem and work areas as indicated. $ 210,000 Opening balance, plan assets 200,000 Service cost 58,000 Employer contributions paid evenly through 2023 77,000 Applicable interest or discount rate 10% Actual return on plan assets $ 25,000 Actuarial loss due to change in actuarial assumptions 14,000 Assuming that Uvo follows IFRS, determine the 2023 effect of the pension plan on pension expense and the company's shareholders' equity. Display amounts to be subtracted as negative amounts. Average plan assets Defined benefit expense: Current service cost Defined benefit expense Remeasurement gain or loss (OCI): ་ Effect on shareholders' equity

Using Excel to Account for Pensions PROBLEM Uvo Corporation is a private company with a defined benefit pension plan. The following information is available for Uvo Corporation for 2023. Opening balance, DBO Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem and work areas as indicated. $ 210,000 Opening balance, plan assets 200,000 Service cost 58,000 Employer contributions paid evenly through 2023 77,000 Applicable interest or discount rate 10% Actual return on plan assets $ 25,000 Actuarial loss due to change in actuarial assumptions 14,000 Assuming that Uvo follows IFRS, determine the 2023 effect of the pension plan on pension expense and the company's shareholders' equity. Display amounts to be subtracted as negative amounts. Average plan assets Defined benefit expense: Current service cost Defined benefit expense Remeasurement gain or loss (OCI): ་ Effect on shareholders' equity

Financial Accounting Intro Concepts Meth/Uses

14th Edition

ISBN:9781285595047

Author:Weil

Publisher:Weil

Chapter12: Liabilities: Off-balance-sheet Financing, Retirement Benefits, And Income Taxes

Section: Chapter Questions

Problem 21E

See similar textbooks

Similar questions

A partial pension worksheet for Sunland Corporation is shown below. Items Balance, Jan. 1, 2025 (a) Service Cost (b) Interest Cost (c) Actual Return (d) Contributions (e) Benefits Journal Entry for 2025 Balance, Dec. 31, 2025 Annual Pension Expense The service cost for 2025 is ?? General Journal Entries $69000 dr 28000 dr 29000 cr Sunland Corporation Pension Worksheet Cash $69000 cr ?? Pension Asset/ Liability $- ?? Memo Record Projected Benefit Obligation $128000 cr $128000 dr ?? Plan Assets ??
education.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F#/activity/question ter 15, 16, and 176 Saved Help Save & Exit Data for 2024 were as follows: PBO, January 1, $248,000 and December 31, $271,000; pension plan assets (fair value) January 1, $182,000, and December 31, $233,000. The projected benefit obligation was underfunded at the end of 2024 by: Multiple Choice e here to search W X $30,000 $38,000 $47,000. H 9:03 PM 76°F Clear ^ (4) 4/14/2024 N M F10 F12 PrtScr insert Delete Calc Alt Ctrl Backspace Enter
The pension worksheet for Pharoah Company is shown below. Pharoah Company Items Balance, Jan. 1, 2025 Pension Worksheet General Journal Entries Memo Record Annual Pension Expense Pension Asset/ Projected Benefit Plan Cash Liability Obligation Assets ?? $184000 cr $137000 dr (a) Service Cost $52000 dr (b) Interest Cost 32000 dr (c) Actual Return 29000 cr (d) Contributions $57000 cr 57000 dr (e) Benefits 27000 dr 27000 cr Journal Entry for 2025 $55000 dr $57000 cr Balance, Dec. 31, 2025 ?? $211000 $167000 What is the Pension Asset/Liability balance on January 1, 2025? $44000 Liability $89000 Liability O $47000 Liability O $47000 Asset
Items Balance, Jan. 1, 2025 (a) Service Cost (b) Interest Cost (c) Actual Return (d) Contributions (e) Benefits Journal Entry for 2025 Balance, Dec. 31, 2025 The service cost for 2025 is O $115000. O $6000. O $37000. O $38000. Annual Pension Expense ?? dr 15000 dr General Journal Entries 16000 cr $37000 Pharoah Corporation Pension Worksheet Cash $37000 cr ?? Show Transcribed Text Pension Asset/ Liability ?? Memo Record Projected Benefit Obligation $115000 cr $115000 dr ?? Plan Assets ??
Stanley-Morgan Industries adopted a defined benefit pension plan on April 12, 2024. The provisions of the plan were not made retroactive to prior years. A local bank, engaged as trustee for the plan assets, expects plan assets to earn a 10% rate of return. The actual return was also 10% in 2024 and 2025. A consulting firm, engaged as actuary, recommends 6% as the appropriate discount rate. The service cost is $150,000 for 2024 and $200,000 for 2025. Year-end funding is $160,000 for 2024 and $170,000 for 2025, No assumptions or estimates were revised during 2024. "We assume the estimated return was based on the actual return on similar investments at the inception of the plan and that, since the estimate didn't change, that also was the actual rate in 2025. Required: Calculate each of the following amounts as of both December 31, 2024, and December 31, 2025; Note: Enter your answers in thousands (i.e., 200,000 should be entered as 200). Enter a liability as a negative amount.
Determine the missing amounts in the 2020 pension worksheet, indicating whether the amounts are debits or credits. (Enter all amounts as positive.) Pension Worksheet—Riverbed Inc. General Journal Entries Memo Record Annual PensionExpense Cash OCI—PriorService Cost OCI—Gain/Loss Pension Asset/Liability Projected BenefitObligation PlanAssets Balance, Jan. 1, 2020 $1,298 Cr. $3,304 $2,006 Service cost $ 590 Interest cost 330…
Please need answer for all with full working please answer all with steps computation explanation formula please answer all Stanley-Morgan Industries adopted a defined benefit pension plan on April 12, 2024. The provisions of the plan were not made retroactive to prior years. A local bank, engaged as trustee for the plan assets, expects plan assets to earn a 10% rate of return. The actual return was also 10% in 2024 and 2025.* A consulting firm, engaged as actuary, recommends 5% as the appropriate discount rate. The service cost is $160,000 for 2024 and $210,000 for 2025. Year-end funding is $170,000 for 2024 and $180,000 for 2025. No assumptions or estimates were revised during 2024. *We assume the estimated return was based on the actual return on similar investments at the inception of the plan and that, since the estimate didn't change, that also was the actual rate in 2025. Required: Calculate each of the following amounts as of both December 31, 2024, and December 31, 2025:…
The following facts apply to the pension plan of Cullumber Inc. for the year 2025. Plan assets, January 1, 2025 Projected benefit obligation, January 1, 2025 Settlement rate Service cost Contributions (funding) Actual and expected return on plan assets Benefits paid to retirees Items Balance, January 1, 2025 $490,400 490,400 Using this data, compute pension expense for the year 2025. As part of your solution, prepare a perision worksheet that shows the journal entry for pension expense for 2025 and the year-end balances in the related pension accounts. (Enter all amounts as positive) Service cost 8% 38,500 27,300 48.000 32.500 Annual Pension Expense General Journal Entries Cash CULLUMBE Pension Works!
Assume the following pension data for year 2019: Service cost $105,000 Contribution $90,000 Actual return $70,000 Benefits $40,000 Plan assets 1/1/19 $700,000 PBO 1/1/19 $810,000 Interest rate 10% Compute pension expense, PBO 12/31/19 and PA 12/31/19. Prepare all journal entries. Show all computations. I recommend using a pension worksheet, but you can do it without one.
The following refers to the pension spreadsheet (columns have missing amounts) for the current year for Ng Enterprises. ($ in millions) Debit(Credit) PBO Plan Assets Prior Service Cost Net (Gain)/Loss Pension Expense Cash Net Pension (Liability)/Asset Beginning balance 450 60 55 50 Service cost (85) Interest cost (25) Expected return on assets 55 Gain/loss on assets 3 Amortization of: Prior service cost Net gain/loss (1) Loss on PBO (65) Contributions to fund 40 Retiree benefits paid Ending balance (530) 54 122 What were the retiree benefits paid?
The following information is available for the pension plan of Wildhorse Company for the year 2020. Actual and expected return on plan assets $ 15,800 Benefits paid to retirees 39,500 Contributions (funding) 88,700 Interest/discount rate 11 % Prior service cost amortization 7,600 Projected benefit obligation, January 1, 2020 548,000 Service cost 60,000 (a) Correct answer icon Your answer is correct. Compute pension expense for the year 2020. Pension expense for 2020 $enter pension expense for 2017 in dollars eTextbook and Media List of Accounts Attempts: 1 of 3 used (b) Prepare the journal entry to record pension expense and the employer’s contribution to the pension plan in 2020. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account…
The following information is available for the pension pan of Ivanhoe Company for the year 2020. Actual and expected return on plan assets Benefits paid to retirees Contributions (funding) Interest/discount rate Prior service cost amortization Projected benefit obligation, January 1, 2020 Service cost (a) Your answer is correct. Compute pension expense for the year 2020. Pension expense for 2020 eTextbook and Medial List of Accounts $ $13.800 36,600 88,000 11 % 7,900 502,000 59,000 108320