BE17.4 - Using Excel to Prepare Entries for Debt Investments PROBLEM Hendricks Corporation purchased trading investment bonds at par. 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. Purchase price of bonds $ 50,000 The following data was provided by Hendricks at December 31. Prepare Hendricks' joumal 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 (а) Debt investments 50,000 Cash 50.000

BE17.4 - Using Excel to Prepare Entries for Debt Investments PROBLEM Hendricks Corporation purchased trading investment bonds at par. 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. Purchase price of bonds $ 50,000 The following data was provided by Hendricks at December 31. Prepare Hendricks' joumal 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 (а) Debt investments 50,000 Cash 50.000

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....

See similar textbooks

Similar questions

During 2021, Anthony Company purchased debt securities as a long-term investment and classified them as trading. All securities were purchased at par value. Pertinent data are as follows: The net holding gain or loss included in Anthonys income statement for the year should be: a. 0 b. 3,000 gain c. 9,000 loss d. 12,000 loss
On September 30, Franz Corporation notices a decline in value of its investment in held-to-maturity bonds. On that date, the carrying value of the bonds is 38,500 and the fair value is 22,980. Franz evaluation of this investment reveals that expected credit losses are 10,000. Prepare the journal entry to record the impairment.
Rekya Mart Inc. is a general merchandise retail company that began operations on January 1, Year 1. The following transactions relate to debt investments acquired by Rekya Mart Inc., which has a fiscal year ending on December 31: Instructions 1. Journalize the entries to record these transactions. 2. If the bond portfolio is classified as available for sale, what impact would this have on financial statement disclosure?
Soto Industries Inc. is an athletic footware company that began operations on January 1, Year 1. The following transactions relate to debt investments acquired by Soto Industries Inc., which has a fiscal year ending on December 31: Instructions 1. Journalize the entries to record these transactions. 2. If the bond portfolio is classified as available for sale, what impact would this have on financial statement disclosure?
Below is select information from two, independent companies. Additional information includes: On January 1, Company A issued a 5-year $1,500,000 bond with at 6% stated rate. Interest is paid semiannually and the bond was sold at 105.5055 to yield a market rate of 4.75%. On January 1, Company B sold $1,500,000 of common stock and paid dividends of $75,000. A. Prepare an income statement for each company (ignore taxes) B. Explain why the net income amounts are different, paying particular attention to the operational performance and financing performance of each company. (Hint: it may be helpful for you to create an amortization table).
G’s investment account relates to its debt investments and its equity investments. For balance sheet presentation, G includes any separate investment-related adjustment accounts with the investment account. Information about G’s investments follows: o On 06-30-21, G purchased 45, $1,000 3% bonds when similar bonds were paying 3.5%. G incurred and paid $600 of bond purchase-related costs. The bonds were dated 06-30-21, pay interest each June 30 and December 31, and mature on 06-30-25. G classified the bonds as a trading investment. As of 12-31-21, the bonds traded at 99. o On 06-30-19, G purchased 40, $1,000 5% bonds when similar bonds were paying 5%. G incurred and paid $400 of bond purchase-related costs. The bonds were dated 06-30-19 and pay interest each June 30 and December 31 and mature on 06-30-24. G classified these bonds as an available-for-sale investment. The bonds were trading at the following amounts as of the following dates:12-31-19 10012-31-20 10212-31-21 101
Paris Inc. began operations in Year 1. Following is a series of transactions and events involving its longterm debt investments in available-for-sale securities. Year 1 Mar. 10 Purchased Apple bonds for $30,600. Apr. 7 Purchased Ford notes for $56,250. Sep. 1 Purchased Polaroid bonds for $28,200. Dec. 31 Fair values for debt in the portfolio are Apple, $33,000; Ford, $54,600; and Polaroid, $29,400. Year 2 Apr. 26 Sold all of the Ford notes for $51,250. June 2 Purchased Duracell bonds for $34,650. June 14 Purchased Sears notes for $25,200. Nov. 27 Sold all of the Polaroid bonds for $30,600. Dec. 31 Fair values for debt in the portfolio are Apple, $31,000; Duracell, $32,400; and Sears, $27,600. Year 3 Jan. 28 Purchased Coca-Cola bonds for $40,000. Aug. 22 Sold all of the Apple bonds for $25,800. Sep. 3 Purchased Motorola notes for $84,000. Oct. 9 Sold all of the Sears notes for $28,800. Oct. 31 Sold all of the Duracell bonds for $27,000. Dec. 31 Fair values for debt in the portfolio are…
Mead Incorporated began operations in Year 1. Following is a series of transactions and events involving its long-term debt investments in available-for-sale securities. Year 1 January 20 Purchased Johnson & Johnson bonds for $28,500. February 9 Purchased Sony notes for $62,640. June 12 Purchased Mattel bonds for $48,500. December 31 Fair values for debt in the portfolio are Johnson & Johnson, $31,100; Sony, $53,150; and Mattel, $56,950. Year 2 April 15 Sold all of the Johnson & Johnson bonds for $31,500. July 5 Sold all of the Mattel bonds for $41,450. July 22 Purchased Sara Lee notes for $19,900. August 19 Purchased Kodak bonds for $20,900. December 31 Fair values for debt in the portfolio are Kodak, $22,125; Sara Lee, $20,000; and Sony, $64,000. Year 3 February 27 Purchased Microsoft bonds for $159,600. June 21 Sold all of the Sony notes for $64,000. June 30 Purchased Black & Decker bonds for $58,400. August 3 Sold all of the Sara…
Mead Incorporated began operations in Year 1. Following is a series of transactions and events involving its long-term debt investments in available-for-sale securities.Year 1 January 20 Purchased Johnson & Johnson bonds for $25,000. February 9 Purchased Sony notes for $59,490. June 12 Purchased Mattel bonds for $45,000. December 31 Fair values for debt in the portfolio are Johnson & Johnson, $26,900; Sony, $49,050; and Mattel, $55,950. Year 2 April 15 Sold all of the Johnson & Johnson bonds for $28,000. July 5 Sold all of the Mattel bonds for $39,000. July 22 Purchased Sara Lee notes for $17,100. August 19 Purchased Kodak bonds for $18,450. December 31 Fair values for debt in the portfolio are Kodak, $18,900; Sara Lee, $16,500; and Sony, $63,000. Year 3 February 27 Purchased Microsoft bonds for $161,000. June 21 Sold all of the Sony notes for $61,200. June 30 Purchased Black & Decker bonds for $54,900. August 3 Sold all of the Sara…
Mead Incorporated began operations in Year 1. Following is a series of transactions and events involving its long-term debt investments in available-for-sale securities.Year 1 January 20 Purchased Johnson & Johnson bonds for $20,500. February 9 Purchased Sony notes for $55,440. June 12 Purchased Mattel bonds for $40,500. December 31 Fair values for debt in the portfolio are Johnson & Johnson, $21,500; Sony, $52,500; and Mattel, $46,350. Year 2 April 15 Sold all of the Johnson & Johnson bonds for $23,500. July 5 Sold all of the Mattel bonds for $35,850. July 22 Purchased Sara Lee notes for $13,500. August 19 Purchased Kodak bonds for $15,300. December 31 Fair values for debt in the portfolio are Kodak, $17,325; Sara Lee, $12,000; and Sony, $60,000. Year 3 February 27 Purchased Microsoft bonds for $160,800. June 21 Sold all of the Sony notes for $57,600. June 30 Purchased Black & Decker bonds for $50,400. August 3 Sold all of the Sara…
Accounting for debt investments On February 1, 2018, Bell Co. decides to invest excess cash of $16,800 by purchasing a Grant, Inc. bond at face value. At year-end, December 31, 2018, the fair value of the Grant bond was $19,600. The investment is categorized as a trading debt investment. Requirements Journalize the transactions for Bell’s investment in Grant, Inc. for 2018. In what category and at what value would Bell report the asset on the December 31, 2018, balance sheet? In what account would the market price change in Grant’s bond be reported, if at all? What was the net effect of the investment on Bell’s net income for the year ended December 31, 2018?
) On October 1, 2018, North Co. invested excess cash of $80,000 by purchasing bonds of South Inc. At year-end, December 31, 2018, the market price of the bonds was $77,000. The investment is categorized as a trading debt investment. Journalize the adjusting entry needed at December 31, 2018. Omit explanation