1. Use the PV function in Excel to calculate the issue price of the bonds. 2....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Use the PV function in Excel to calculate the issue price of the bonds. 2. Prepare an effective-interest method amortization table for the first four semiannual interest periods. 3. Journalize the following transactions: a. Issuance of the bonds on December 31, 2018. Credit Convertible Bonds Payable. b. Payment of interest and amortization of the bond discount on June 30, 2019. c. Payment of interest and amortization of the bond discount on December 31, 2019. d. Conversion by the bondholders on July 1, 2020, of bonds with a total face value of $600,000 into 40,000 shares of Caraboo's $1-par common stock. 4. Show how Caraboo would report the remaining bonds payable on its balance sheet at December 31, 2020. On December 31, 2018, Caraboo Corporation issues 5%, 10-year convertible bonds payable with a face value of $1,500,000. The semiannual interest dates are June 30 and December 31. The market interest rate is 12%. Caraboo amortizes bond discounts using the effective-interest method. Read the equirements. Requirement 1. Use the PV function in Excel® to calculate the issue price of the bonds. (Round your answer to the nearest whole dollar.) The issue price of the bonds is $ Requirement 2. Prepare an effective-interest method amortization table for the first four semiannual interest periods. (Round your answers to the nearest whole dollar.) Caraboo Corporation Amortization Table Semiannual Interest Discount Discount Acount Bond Carrying Interest Date Payment Interest Expense Amortization Balance Amount 12-31-2018 6-30-2019 12-31-2019 6-30-2020 12-31-2020 Requirement 3. Journalize the following transactions. (Record debits first, then credits. Exclude explanations from all journal entries.) a. Record the issuance of the bonds on December 31, 2018. Credit Convertible Bonds Payable. (Round your answers to the nearest whole dollar.) Journal Entry Date Accounts Debit Credit 2018 Dec 31 b. Record the payment of interest and amortization of the bonds on June 30, 2019. (Round your answers to the nearest whole dollar.) Journal Entry Date Accounts Debit Credit 2019 Jun 30 c. Record the payment of interest and amortization of the bonds on December 31, 2019. (Round your answers to the nearest whole dollar.) Journal Entry Date Accounts Debit Credit 2019 Dec 31 d. Record the conversion by the bondholders on July 1, 2020, of bonds with a total face value of $600,000 into 40,000 shares of Caraboo's $1-par common stock. (Round your answers to the nearest whole dollar.) Journal Entry Date Accounts Debit Credit 2020 Jul 1 Requirement 4. Show how Caraboo would report the remaining bonds payable on its balance sheet at December 31, 2020. (Calculate the discount by multiplying the discount calculated in the original amortization table by the fraction of bonds remaining. Round your answers to the nearest whole dollar.) Caraboo Corporation Partial Balance Sheet December 31, 2020 Less: 1. Use the PV function in Excel to calculate the issue price of the bonds. 2. Prepare an effective-interest method amortization table for the first four semiannual interest periods. 3. Journalize the following transactions: a. Issuance of the bonds on December 31, 2018. Credit Convertible Bonds Payable. b. Payment of interest and amortization of the bond discount on June 30, 2019. c. Payment of interest and amortization of the bond discount on December 31, 2019. d. Conversion by the bondholders on July 1, 2020, of bonds with a total face value of $600,000 into 40,000 shares of Caraboo's $1-par common stock. 4. Show how Caraboo would report the remaining bonds payable on its balance sheet at December 31, 2020. On December 31, 2018, Caraboo Corporation issues 5%, 10-year convertible bonds payable with a face value of $1,500,000. The semiannual interest dates are June 30 and December 31. The market interest rate is 12%. Caraboo amortizes bond discounts using the effective-interest method. Read the equirements. Requirement 1. Use the PV function in Excel® to calculate the issue price of the bonds. (Round your answer to the nearest whole dollar.) The issue price of the bonds is $ Requirement 2. Prepare an effective-interest method amortization table for the first four semiannual interest periods. (Round your answers to the nearest whole dollar.) Caraboo Corporation Amortization Table Semiannual Interest Discount Discount Acount Bond Carrying Interest Date Payment Interest Expense Amortization Balance Amount 12-31-2018 6-30-2019 12-31-2019 6-30-2020 12-31-2020 Requirement 3. Journalize the following transactions. (Record debits first, then credits. Exclude explanations from all journal entries.) a. Record the issuance of the bonds on December 31, 2018. Credit Convertible Bonds Payable. (Round your answers to the nearest whole dollar.) Journal Entry Date Accounts Debit Credit 2018 Dec 31 b. Record the payment of interest and amortization of the bonds on June 30, 2019. (Round your answers to the nearest whole dollar.) Journal Entry Date Accounts Debit Credit 2019 Jun 30 c. Record the payment of interest and amortization of the bonds on December 31, 2019. (Round your answers to the nearest whole dollar.) Journal Entry Date Accounts Debit Credit 2019 Dec 31 d. Record the conversion by the bondholders on July 1, 2020, of bonds with a total face value of $600,000 into 40,000 shares of Caraboo's $1-par common stock. (Round your answers to the nearest whole dollar.) Journal Entry Date Accounts Debit Credit 2020 Jul 1 Requirement 4. Show how Caraboo would report the remaining bonds payable on its balance sheet at December 31, 2020. (Calculate the discount by multiplying the discount calculated in the original amortization table by the fraction of bonds remaining. Round your answers to the nearest whole dollar.) Caraboo Corporation Partial Balance Sheet December 31, 2020 Less:
Expert Answer:
Answer rating: 100% (QA)
Issue price of bonds is calculated by using market interest rate Calculation of Issue Price of Bonds using PV function of Excel Face Value of bonds 15... View the full answer
Related Book For
Cost management a strategic approach
ISBN: 978-0073526942
5th edition
Authors: Edward J. Blocher, David E. Stout, Gary Cokins
Posted Date:
Students also viewed these accounting questions
-
Use the appropriate function in Excel to calculate the annual straight-line (SL) depreciation charge for an asset that has a $10,000 acquisition cost, a salvage value of $500, and a useful life of...
-
How do we calculate the issue price of bonds? Is it equal to the present value of the principal? Explain.
-
The company has bonds payable with a total face value of $150,000 and a carrying value of $142,000. In addition, unpaid interest on the bonds has been accrued in the amount of $8,000. The lender has...
-
discusses how a reseller can service both a consumer and an industrial market from the same store location. Provide an example of a retailer and detail the differences in their marketing activities.
-
Glencove Co. makes one model of radar gun used by law enforcement officers. All direct materials are added at the beginning of the manufacturing process. Information for the month of September...
-
Jones County Senior Services is a nonprofit organization devoted to providing essential services to seniors who live in their own homes within the Atlantic County area. Three services are provided...
-
Consider the gasoline mileage performance data in Table B.3. a. Use the all-possible-regressions approach to find an appropriate regression model. b. Use stepwise regression to specify a subset...
-
A long, straight, solid cy1inder, oriented with its axis in the z-direction, carries a current whose current density is J. The current density, although symmetrical about the cylinder axis, is not...
-
Constructing Balance Sheets and Determining Income Following is balance sheet information for Lynch Services at the end of Year 2 (the most recent year) and Year 1. December 31,Year 2 December...
-
When Pablo Gonzalez died unmarried in 2018, he left an estate valued at $7,850,000. His trust directed distribution as follows: $20,000 to local hospital, $160,000 to his alma mater, and the...
-
How would you define ACH?
-
Identify and describe the 4 barriers to health care information systems adoption outside of hospital settings. Assess the impact of new care delivery models (for example Hospital at Home, virtual...
-
Alternative Bid Accepted Bid Rejected Buy 1 machine $ 10 $5 Buy 2 machines $30 $4 Buy 3 machines $40 $2 Refer to the information above. Assume that based on historical bids with the defense...
-
You are the newly appointed director of human resource management for the fire department of a city in the northeastern United States. Your organization has struggled to hire new firefighters for...
-
You are an independent consultant, counseling companies on corporate governance issues. You have been engaged by JKL Renew Pty Ltd (JKL) to advise them on their corporate governance structures. JKL...
-
Discuss strategies to manage groups, especially during the early stages of forming and storming, and what strategies could you use as a Team Leader or Project Manager to transition from storming to...
-
Mary experienced a ransomware incident on her computer. There was no personally identifiable information that was accessed or acquired during the ransomware incident. Mary wants to determine whether...
-
The sales department of P. Gillen Manufacturing Company has forecast sales in March to be 20,000 units. Additional information follows: Finished goods inventory, March 1 . . . . . . . . . . . . . . ....
-
How important to profitability are customer referrals? What customers feel about your company (and you) and what they are prepared to tell others about you can be just as important as what your...
-
Specify the advantage of the weighted-average method of process costing in contrast to the FIFO method.
-
Cisneros Company uses a job costing system for its production costs and a predetermined factory overhead rate based on direct labor costs to apply factory overhead to all jobs. During the month of...
-
The result from problem 5.21 shows that the reservoir temperature for a Mach 20 helium tunnel can be very reasonable. This is why several very high Mach number helium hypersonic wind tunnels exist....
-
Write the \(z\) component of Eq. (6.7), and use it to derive Eq. (6.13). Equation 6.13: \(\frac{\partial(ho w)}{\partial t}+abla \cdot(ho w \mathbf{V})=-\frac{\partial p}{\partial z}+ho f_z\) pf d V...
-
Prepare a balanced scorecard for HSBC Bank (http://www.hsbc.com).
Study smarter with the SolutionInn App