BE17.4 - Using Excel to Prepare Entries for Debt Investments PROBLEM Student Work Area Required: Provide input into cells shaded in yellow in this template. Use cell references to the Problem area, with mathematical formulas to calculate any _amounts not given. Hendricks Corporation purchased trading investment bonds at par. Purchase price of bonds $ 50,000 The following data was provided by Hendricks at December 31. Prepare Hendricks' jourmal entries for: (a) The purchase of the investment (b) The interest received (c) The fair value adjustment Annual interest received $ 2,000 Fair value of the bonds 47,400 A zero balance exists in the Fair Value Adjustment account before the above activity. Debit Credit |(a) |(b) (c)

Financial Accounting
15th Edition
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Carl Warren, James M. Reeve, Jonathan Duchac
Chapter15: Investments And Fair Value Accounting
Section: Chapter Questions
Problem 1PB: Rekya Mart Inc. is a general merchandise retail company that began operations on January 1, Year 1....
icon
Related questions
Question

How do i do this?

Formula: Subtract; Cell Referencing
BE17.4 - Using Excel to Prepare Entries for Debt Investments
PROBLEM
Student Work Area
Required: Provide input into cells shaded in yellow in this template. Use cell
references to the Problem area, with mathematical formulas to calculate any
amounts not given.
Hendricks Corporation purchased trading investment bonds at par.
Purchase price of bonds
$ 50,000
The following data was provided by Hendricks at December 31.
Prepare Hendricks' journal entries for:
(a) The purchase of the investment
(b) The interest received
(c) The fair value adjustment
Annual interest received
$ 2,000
Fair value of the bonds
47,400
4A zero balance exists in the Fair Value Adjustment account before
5 the above activity.
Debit
Credit
(а)
(b)
(c)
Transcribed Image Text:Formula: Subtract; Cell Referencing BE17.4 - Using Excel to Prepare Entries for Debt Investments PROBLEM Student Work Area Required: Provide input into cells shaded in yellow in this template. Use cell references to the Problem area, with mathematical formulas to calculate any amounts not given. Hendricks Corporation purchased trading investment bonds at par. Purchase price of bonds $ 50,000 The following data was provided by Hendricks at December 31. Prepare Hendricks' journal entries for: (a) The purchase of the investment (b) The interest received (c) The fair value adjustment Annual interest received $ 2,000 Fair value of the bonds 47,400 4A zero balance exists in the Fair Value Adjustment account before 5 the above activity. Debit Credit (а) (b) (c)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Value Chain Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Financial Reporting, Financial Statement Analysis…
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning