Analyzing and Reporting Financial Statement Effects of Bond Transactions
Assume that on January 1, Comcast issues $500,000 of 5-year, 10% coupon bonds payable, yielding an effective annual interest rate of 8%. Interest is payable semiannually on June 30 and December 31.
B) Complete Comcast’s financial statement effects template for
b. semiannual interest payment and premium amortization on Jun. 30 of the 1st year.
C. semiannual interest payment and premium amortization on Dec. 31 of the 1st year.
C) Prepare an amortization table for the bonds for five years.
price of bond = Using present value function in MS excel | pv(rate,nper,pmt,fv,type) rate = 4% nper = 10 pmt = 50 fv =1000 type =0 | PV(4%,10,50,1000,0) | ($1,081.1090) | |||
total value of bond issue | (500000*1081.109)/1000 | 540554.5 | ||||
Income statement | ||||||
For the period ending June 30 of Year 1 | ||||||
Interest expense | 21622.2 | |||||
Balance sheet - As on dec 31 Year 1 | ||||||
Liabilities | ||||||
Bonds payable | 540555-3377.8 | 537177.2 | ||||
Income statement | ||||||
For the period ending Dec. 31 of Year 1 | ||||||
Interest expense | 21487.088 | |||||
Balance sheet - As on dec 31 Year 1 | ||||||
Liabilities | ||||||
Bonds payable | 537177.2-3512.912 | 533664.288 | ||||
Amortization Schedule | ||||||
semi annual period | cash paid =face value*semi annual coupon rate | Interest expense = carrying value*semiannual effective annual interest | premium amortized = cash paid-interest expense | carrying value of premium on bonds payable = balance in carrying value of bond premium-premium amortized | Bonds payable | carrying value of bonds payable = carrying value of bonds payable-premium amortized |
0 | 40555 | 500000 | 540555 | |||
1 | 25000 | 21622.2 | 3377.8 | 37177.2 | 500000 | 537177.2 |
2 | 25000 | 21487.088 | 3512.912 | 33664.288 | 500000 | 533664.288 |
3 | 25000 | 21346.57152 | 3653.42848 | 30010.86 | 500000 | 530010.86 |
4 | 25000 | 21200.43438 | 3799.565619 | 26211.294 | 500000 | 526211.294 |
5 | 25000 | 21048.45176 | 3951.548244 | 22259.746 | 500000 | 522259.746 |
6 | 25000 | 20890.38983 | 4109.610174 | 18150.135 | 500000 | 518150.135 |
7 | 25000 | 20726.00542 | 4273.994581 | 13876.141 | 500000 | 513876.141 |
8 | 25000 | 20555.04564 | 4444.954364 | 9431.1865 | 500000 | 509431.187 |
9 | 25000 | 20377.24746 | 4622.752538 | 4808.434 | 500000 | 504808.434 |
10 | 25000 | 20192.33736 | 4807.66264 | 0.7713601 | 500000 | 500000.771 |
Analyzing and Reporting Financial Statement Effects of Bond Transactions Assume that on January 1, Comcast issues...
Analyzing and Reporting Financial Statement Effects of Bond Transactions Assume that on January 1, Comcast issues $500,000 of 5-year, 10% coupon bonds payable, yielding an effective annual interest rate of 8%. Interest is payable semiannually on June 30 and December 31. A) Compute the issue price. B) Complete Comcast’s financial statement effects template for a. bond issuance. b. semiannual interest payment and premium amortization on Jun. 30 of the 1st year. c. semiannual interest payment and premium amortization on Dec....
Analyzing and Reporting Financial Statement Effects of Bond Transactions Assume that on January 1, Xfinity issues $500,000 of 5-year, 8% coupon bonds payable, yielding an effective annual interest rate of 10%. Interest is payable semiannually on June 30 and December 31. D) Compute the issue price. E) Complete Comcast’s financial statement effects template for a. bond issuance. b. semiannual interest payment and premium amortization on Jun. 30 of the 1st year. c. semiannual interest payment and premium amortization on Dec....
3. Analyzing and Reporting Financial Statement Effects of Bond Transactions Assume that on January 1, Comcast issues $500,000 of 5-year, 10% coupon bonds payable, yielding an effective annual interest rate of 8%. Interest is payable semiannually on June 30 and December 31. A) Compute the issue price. B) Complete Comcast’s financial statement effects template for a. bond issuance.
Analyzing and Reporting Financial Statement Effects of Bond Transactions On January 1 of the current year, Shields Inc. issued $1,000,000 of 9%, 20-year bonds for $1,098,964, yielding a market (yield) rate of 8%. Semiannual interest is payable on June 30 and December 31 of each year. a. Show Excel inputs to confirm the bond issue price. Note: Round your answer to two decimal places. rate = 0 nper = 0 0 pmt = FV = 0 0 Answer = $...
Analyzing and Reporting Financial Statement Effects of Bond Transactions Lundholm, Inc., reports financial statements each December 31 and issues $400,000, 9%, 15-year bonds dated May 1, 2012, with interest payments on October 31 and April 30. Assuming the bonds are sold at par on May 1, 2012, complete the financial statement effects template to reflect the following events: (a) bond issuance, (b) the first semiannual interest payment, and (c) retirement of $200,000 of the bonds at 101 on November 1,...
*I just need help on the parts marked with an X! PLEASE include an explanation as well! This is only the practice version, so I need to do the graded version as well (which is the same questions with different numbers). Thank you! On January 1 of the current year, Banek Inc. issued $350,000 of 8%, nine‑year bonds for $309,086, which implies a market (yield) rate of 10%. Semiannual interest is payable on June 30 and December 31 of each year.a. Show...
Business Course * Return to course ! My Subscriptions Yosimar Huerta Question 4 Partially correct Mark 18.00 out of 24.00 P Flag question Bonds Payable Journal Entries; Effective Interest Amortization On December 31, 2017, Karen Company issued $400,000 of 10-year, ten percent bonds payable for $454,361, yielding an effective interest rate of eight percent. Interest is payable semiannually on June 30 and December 31. Prepare journal entries to reflect (a) the issuance of the bonds, (b) the semiannual interest payment...
Entries for Bonds Payable, including bond redemption The following transactions were completed by Montague Inc., whose fiscal year is the calendar year: 20Y1 July 1. Issued $55,000,000 of 10-year, 9% callable bonds dated July 1, 20Y1, at a market (effective) rate of 7%, receiving cash of $62,817,040. Interest is payable semiannually on December 31 and June 30. Dec. 31. Paid the semiannual interest on the bonds. The bond discount amortization of $390,852 is combined with the semiannual interest payment. 20Y2...
Learning Objectives 2,3 P14-33A Analyzing, journalizing, and reporting bond transactions Danny's Hamburgers issued 6%, 10-year bonds payable at 90 on December 31, 2018 At December 31, 2020, Danny reported the bonds payable as follows: 2. Discount 53,000 Long-term Liabilities: Bonds Payable Less: Discount on Bonds Payable $ 600,000 (48,000) $ 552,000 Danny's pays semiannual interest each June 30 and December 31. Requirements 1. Answer the following questions about Danny bonds payable: a. What is the maturity value of the bonds?...
Bonds Payable Journal Entries; Effective Interest Amortization On December 31, 2017, Blair Company issued $600,000 of 20‑year, 11 percent bonds payable for $554,861, yielding an effective interest rate of 12 percent. Interest is payable semiannually on June 30 and December 31. Prepare journal entries to reflect (a) the issuance of the bonds, (b) the semiannual interest payment and discount amortization (effective interest method) on June 30, 2018, and (c) the semiannual interest payment and discount amortization on December 31, 2018....