Question

2 3 On January 1, 2020, JWS Corporation issued $600,000 of 7% bonds, due in 10 years. The bonds pay interest each July 1 and

use excel please

0 0
Add a comment Improve this question Transcribed image text
Answer #1
In this question the issue price of the bond is not given, we have to calculate the issue price considering the effective rate of interest
Effective rate of interest = 6%
Semi-annual rate of interest = 6%/2 = 3%
Bond term = 10 Years
Bond term semi annual = 10*2 = 20 years
Interest on bond = 7%
Semi-annual interest= 7/2 = 3.5%
Interest Payment = 600000*3.5%
Interest Payment = А F G Н. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 B C D E Amortisation Schedule Date Interest payment Interest expense AmortisatioA B D E F G Н. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Amortisation Schedule Date Interest payment 43831 44013 21021000
Issue price = Present value of future interest payment + Present value of its repayment
Present value annuity factor at 3% semi-annual for 20 terms is 14.8775
Present value factor at 3% at 20th terms is 0.55368
Issue price = (21000 X 14.8775)+(600000*0.55368)

Issue price = 644636

Amortisation Schedule ia attached in the image along with the table showing the excel formula

Below is the Journal entries

Journal Entries
Date Particulars Debit Credit
Jan 1st Cash        644,636
          Bonds payable        600,000
          Premium on bonds payable (644636-600000)           44,636
July 1st Interest Expense (Refer amortisation table)           19,339
Premium on bond payable (Refer amortisation table)             1,661
                 Cash           21,000
Dec 31st Interest Expense (Refer amortisation table)           19,289
Premium on bond payable (Refer amortisation table)             1,711
                 Interest Payable           21,000
Add a comment
Know the answer?
Add Answer to:
use excel please 2 3 On January 1, 2020, JWS Corporation issued $600,000 of 7% bonds,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • On January 1, 2020, JWS Corporation issued $600,000 of 7% bonds,due in 10 years. The...

    On January 1, 2020, JWS Corporation issued $600,000 of 7% bonds, due in 10 years. The bonds were issued for $559,231, and pay interest each July 1 and January 1. JWS uses the effective-interest method.Prepare the company’s journal entries for (a) the January 1 issuance, (b) the July 1 interest payment, and (c) the December 31 adjusting entry. Assume an effective-interest rate of 8%.(Round intermediate calculations to 6 decimal places, e.g. 1.251247 and final answer to 0 decimal places, e.g....

  • on January 1, 2017, JWS Corporation issued $600,000 of 7% bonds, due in 10 years. The...

    on January 1, 2017, JWS Corporation issued $600,000 of 7% bonds, due in 10 years. The tonds were issued fr ssss 224, and pay interest each Mi a d lanuary 1 MS uses the emot enternt method. Prepare the company's journal entries for (a) the January 1 Issuance, (b) the July 1 interest payment, and (e) the December 31 adjusting entry. Assume an effective-Interest rate of 8% (Round interasediate calculations to & de answer to O decimaง places eq. 38,548....

  • On January 1, 2013, JWS Corporation issued $677,000 of 9% bonds, due in 10 years. The...

    On January 1, 2013, JWS Corporation issued $677,000 of 9% bonds, due in 10 years. The bonds were issued for $634,816, and pay interest each July 1 and January 1. JWS uses the effective-interest method. Prepare the company’s journal entries for (a) the January 1 issuance, (b) the July 1 interest payment, and (c) the December 31 adjusting entry. Assume an effective-interest rate of 10%.

  • c) December 31. Assume The Colson Company records straight-line amortization semiannually. 14-5 (L01) Devers Corporation issued...

    c) December 31. Assume The Colson Company records straight-line amortization semiannually. 14-5 (L01) Devers Corporation issued $400.000 of 6% bonds on May 1, 2017. The bonds were dated January 1, 2017, and mature January 1, 2020, with interest payable July 1 and January 1. The bonds were issued at face value plus accrued interest. Prepare es s journal entries for (a) the May 1 issuance, (b) the July 1 interest payment, and (c) the December 31 adjusting entry. BE14-6 (L01)...

  • On January 1, 2020, Pearl Corporation issued $610,000 of 9% bonds, due in 10 years. The...

    On January 1, 2020, Pearl Corporation issued $610,000 of 9% bonds, due in 10 years. The bonds were issued for $571,991, and pay interest each July 1 and January 1. Pearl uses the effective-interest method. Prepare the company’s journal entries for (a) the January 1 issuance, (b) the July 1 interest payment, and (c) the December 31 adjusting entry. Assume an effective-interest rate of 10%.

  • On January 1, 2020, Bridgeport Corporation issued $670,000 of 9% bonds, due in 10 years. The...

    On January 1, 2020, Bridgeport Corporation issued $670,000 of 9% bonds, due in 10 years. The bonds were issued for $628,252, and pay interest each July 1 and January 1. Bridgeport uses the effective interest method. Prepare the company's journal entries for (a) the January 1 Issuance, (b) the July 1 interest payment, and (c) the December 31 adjusting entry. Assume an effective-interest rate of 10%. (Round intermediate calculations to 6 decimal places, e.g. 1.251247 and final answer to o...

  • On January 1, 2020, Whispering Corporation issued $670,000 of 9% bonds, due in 10 years. The...

    On January 1, 2020, Whispering Corporation issued $670,000 of 9% bonds, due in 10 years. The bonds were issued for $715,529, and pay interest each July 1 and January 1. The effective interest rate is 8%. Prepare the company's journal entries for (a) the January 1 issuance, (b) the July 1 interest payment, and (c) the December 31 adjusting entry Whispering uses the effective interest method. (Round Intermediate calculations to 6 decimal places, e.g. 1.251247 and final answer to O...

  • Brief Exercise 14-06 On January 1, 2020, Oriole Corporation issued $500,000 of 7% bonds, due in...

    Brief Exercise 14-06 On January 1, 2020, Oriole Corporation issued $500,000 of 7% bonds, due in 10 years. The bonds were issued for $466,026, and pay interest each July 1 and January 1. Oriole uses the effective-interest method. Prepare the company's journal entries for (a) the January 1 issuance, (b) the July 1 interest payment, and (c) the December 31 adjusting entry. Assume an effective-interest rate of 8%. (Round intermediate calculations to 6 decimal places, e.g. 1.251247 and final answer...

  • On January 1, 2017, Sandhill Corporation issued $550,000 of 7% bonds, due in 8 years. The...

    On January 1, 2017, Sandhill Corporation issued $550,000 of 7% bonds, due in 8 years. The bonds were issued for $517,958, and pay interest each July 1 and January 1. Sandhill uses the effective-interest method. Prepare the company’s journal entries for (a) the January 1 issuance, (b) the July 1 interest payment, and (c) the December 31 adjusting entry. Assume an effective-interest rate of 8%.

  • On January 1, 2020, Carla Corporation issued $660,000 of 9% bonds, due in 8 years. The...

    On January 1, 2020, Carla Corporation issued $660,000 of 9% bonds, due in 8 years. The bonds were issued for $698,454, and pay interest each July 1 and January 1. The effective-interest rate is 8%. Prepare the company's journal entries for (a) the January 1 issuance, (b) the July 1 interest payment, and (c) the December 31 adjusting entry. Carla uses the effective-interest method. (Round intermediate calculations to 6 decimal places, e.g. 1.251247 and final answer to 0 decimal places,...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT