Prepare spreadsheet to determine all the pension items

Assignment Help Accounting Basics
Reference no: EM132593546

Question - NOELLA Consultants Inc. has had a defined benefit pension plan since January 1, 2014.

The following represents beginning balances as at January 1, 2019:

Market value of Plan Asset $2,008,900; Defined Benefit Obligation $2,340,000; AOCI: Gain of $65,000

Additional Information is as follows:

Current Service cost is $221,000 for 2019 and $215,200 for 2020.

Company Funding/Contribution is $200,400 for 2019 and $212,700 for 2020. Funding is made on December 31 of each year.

Actual return on assets is $115,600 for 2019 and $117,400 for 2020.

There are payments made to retired employees equal to $63,900 in 2019 and for $90,300 in 2020.

Increase in obligation of $123,500 due to Past service cost from plan amendment dated December 31, 2019.

There is an increase in obligation for $64,510 due to changes in Actuarial assumptions at Dec 31, 2020.

The discount/interest rate is 6% for both years.

Required -

1. Prepare spreadsheet to determine all the pension items for both 2019 and 2020.

2. Prepare the required journal entries for both 2019 and 2020.

3. Prepare partial balance sheet and a partial income statement for both 2019 and 2020.

4. Prepare the notes to the financial statements for 2019 only.

Reference no: EM132593546

Questions Cloud

How much amortization expense should Co record : If Co's estimate of patent's useful life and salvage value have not changed, how much amortization expense should Co record for the patent in 2020
How do the properties of flow layering : What does Cottom say about the relationship between country authenticity and hip-hop authenticity in the success of hick-hop songs?
Determine the dollar amount that brunswick will report : Use this information to determine the dollar amount that Brunswick will report on its fiscal year 2018 Balance Sheet for Paid in Capital Treasury Stock
How could a through hazard analysis : How could a thorough hazard analysis, as a part of the Prevention through Design (PtD) process, have helped eliminate hazards in the structure?
Prepare spreadsheet to determine all the pension items : The discount/interest rate is 6% for both years. Prepare spreadsheet to determine all the pension items for both 2019 and 2020
Clothing to make more of bold statement : In the sixties, the youth culture began to rebel and wanted their clothing to make more of a bold statement.
Develop interpersonal skill that would allow one to work : Develop interpersonal skill that would allow one to work in groups effectively as Howard Gardner 7 Intelligences idea. Analyze different approaches to learning
How international students contribute to the us economy : How International students contribute to the U.S. economy? What will happen if student go back to study at their home country?
Mining and international sales of conflict diamonds : There have been numerous debates, articles, and even a movie (Blood Diamond) about the mining and international sales of "conflict diamonds."

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd