Question

In: Accounting

A. Determine the issue price of the debt. B. Prepare the amortization table for the bond...

A. Determine the issue price of the debt.

B. Prepare the amortization table for the bond issue through January 1, 2021, assuming that Jones Road uses the effective interest rate method of amortization.

C. Prepare the journal entries to record the bond issue, the first interest entry, and payment of the bonds at maturity. Assume the company uses a premium or discount account if needed.

On January 1, 2018, the Jones Road Corporation issued $800,000 par value, 3%, 5-year bonds. Interest is payable semiannually each January 1 and July 1 with the first interest payment due at the end of the period on July 1, 2018. The market rate of interest on the date of the bond issue was 4%. The company's fiscal year ends on December 31.

A. Determine the issue price of the debt. (Use the present value and future value​ tables, a financial​ calculator, or a spreadsheet for your calculations. If using present and future value tables or the formula​ method, use factor amounts rounded to five decimal​ places, X.XXXXX. Round your final answers to the nearest whole​ dollar.)

The issue price of the debt is $?

B. Prepare the amortization table for the bond issue through January 1, 2021, assuming that Jones Road uses the effective interest rate method of amortization. (Round each calculation to the nearest whole number and then use the rounded value for each subsequent calculation in the​ table.)

Date Cash Interest Effective Interest Discount/Premium Amortization Carrying Value

Jan 1, 18 ?

Jul 1, 18 ? ? ?   ?

Jan 1, 19 ? ? ?   ?

Jul 1, 19 ? ? ?   ?

Jan 1, 20 ? ? ?   ?

Jul 1, 20 ? ? ?   ?

Jan 1, 21 ? ? ?   ?

C. Prepare the journal entries to record the bond issue, the first interest entry, and payment of the bonds maturity. Assume the company uses a premium or discount account if needed. (Round your answers to the nearest whole dollar. Record debits​ first, then credits. Exclude explanations from any journal​ entries.)

Begin by recording the issuance of the bonds payable.

Account January 1, 2018

? ? | ?

Record the first semiannual interest payment.

Account July 1, 2018

? ? | ?

Prepare the journal entry to record payment of the bonds at maturity.

Account January 1, 2023

? ? | ?

Solutions

Expert Solution

1 Issue price of bonds Period Cashflows Present value Calculation
1 $12,000 $11,765 (12000/(1+0.02)^1)
2 $12,000 $11,534 (12000/(1+0.02)^2)
3 $12,000 $11,308 (12000/(1+0.02)^3)
4 $12,000 $11,086 (12000/(1+0.02)^4)
5 $12,000 $10,869 (12000/(1+0.02)^5)
6 $12,000 $10,656 (12000/(1+0.02)^6)
7 $12,000 $10,447 (12000/(1+0.02)^7)
8 $12,000 $10,242 (12000/(1+0.02)^8)
9 $12,000 $10,041 (12000/(1+0.02)^9)
10 $812,000 $666,123 (812000/(1+0.02)^10)
Selling price of bonds $764,070
2 Amortisation schedule indicating Cromley's effetive interest expense
Payment Number Cash payment Effective interest Discount amortisation Oustanding balance
1 $                12,000 $              15,281 $                    3,281 $                           767,351
2 $                12,000 $              15,347 $                    3,347 $                           770,698
3 $                12,000 $              15,414 $                    3,414 $                           774,112
4 $                12,000 $              15,482 $                    3,482 $                           777,594
5 $                12,000 $              15,552 $                    3,552 $                           781,146
6 $                12,000 $              15,623 $                    3,623 $                           784,769
7 $                12,000 $              15,695 $                    3,695 $                           788,464
8 $                12,000 $              15,769 $                    3,769 $                           792,234
9 $                12,000 $              15,845 $                    3,845 $                           796,078
10 $              812,000 $              15,922 $             (796,078) $                                       -  
Totals $96,000 $124,164
3 Journal entry
Account titles and explaNetion Debit Credit
01-Jan-18 Cash $764,070
Discount on bonds payable $35,930
     Bonds payable $800,000
(Bonds issued at discount)
4 Journal entry in books of Cromley
Account titles and explaNetion Debit Credit
01-Jul-18 Interest expense $15,281
Discount on bonds payable $3,281
Cash $12,000
(interest expense booked for first payment)
01-Jan-23 Bonds payable $796,078
Interest expense $15,922
Cash $812,000
(Bond repaid)

Related Solutions

Computing Bond Issue Price and Preparing an Amortization Table in Excel On December 31, 2015, Kaplan,...
Computing Bond Issue Price and Preparing an Amortization Table in Excel On December 31, 2015, Kaplan, Inc., issues $300,000 of 9% bonds that pay interest semiannually and mature in 10 years (December 31, 2025). a. Using the Excel PV worksheet function, compute the issue price assuming that the bonds' market rate is 8% per year compounded semiannually. (Refer to Appendix A for illustration.) Round answer to two decimal places. Issue price $Answer b. Prepare an amortization table in Excel to...
How to determine the price for a floating bond issue?
How to determine the price for a floating bond issue?
Use Excel to prepare a Bond Interest and Discount Amortization Table using the following information: $50,000,000...
Use Excel to prepare a Bond Interest and Discount Amortization Table using the following information: $50,000,000 face value coupon rate of interest - 6% market rate of interest - 7% term - 10 years payable semi-annually First calculate the proceeds received upon issuance and the amount of the discount
Bond issue price and premium amortization On January 1, 2013, Piper Co. issued ten-year bonds with...
Bond issue price and premium amortization On January 1, 2013, Piper Co. issued ten-year bonds with a face value of $4,000,000 and a stated interest rate of 10%, payable semiannually on June 30 and December 31. The bonds were sold to yield 12%. Table values are: Present value of 1 for 10 periods at 10%.................. .386 Present value of 1 for 10 periods at 12%.................. .322 Present value of 1 for 20 periods at 5%.................... .377 Present value of 1...
Prepare an amortization table for the calculation of interest and payment of the Document payable to...
Prepare an amortization table for the calculation of interest and payment of the Document payable to a natural person, for $ 2,000,000 at the annual rate of 12%, payable in 3 years. The interest plus the payment of the document will be made at the end of the 3 years. Calculate with simple interest and also calculate cost with compound interest
Bond Amortization and adjusting entry. Use excel to create an amortization table for 10 years and...
Bond Amortization and adjusting entry. Use excel to create an amortization table for 10 years and show the adjusting entry for the bond payable for the June payment. Show calculations. Had issued $1,500,000 of 4%, 10-year bond, dated 1/1/18 for $1,383,079 when the market rate was 5%. Interest is paid on June 30 and January 1 using the effective interest rate method. The June payment is included in the Dec. 1 TB. Trial Balance December 1, 2021 Description Debit Credit...
Complete the below table to calculate the price of a $1 million bond issue under each...
Complete the below table to calculate the price of a $1 million bond issue under each of the following independent assumptions (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.): 1. Maturity 10 years, interest paid annually, stated rate 10%, effective (market) rate 12% 2. Maturity 10 years, interest paid semiannually, stated rate 10%, effective (market) rate 12% 3. Maturity 10 years, interest...
Complete the below table to calculate the price of a $1.2 million bond issue under each...
Complete the below table to calculate the price of a $1.2 million bond issue under each of the following independent assumptions 1. Maturity 10 years, interest paid annually, stated rate 10%, effective (market) rate 12%. 2. Maturity 10 years, interest paid semiannually, stated rate 10%, effective (market) rate 12%. 3. Maturity 5 years, interest paid semiannually, stated rate 12%, effective (market) rate 10%. 4. Maturity 10 years, interest paid semiannually, stated rate 12%, effective (market) rate 10%. 5. Maturity 10...
Complete the below table to calculate the price of a $1.5 million bond issue under each...
Complete the below table to calculate the price of a $1.5 million bond issue under each of the following independent assumptions (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1): 1. Maturity 15 years, interest paid annually, stated rate 10%, effective (market) rate 12%. 2. Maturity 15 years, interest paid semiannually, stated rate 10%, effective (market) rate 12%. 3. Maturity 5 years, interest paid semiannually, stated rate 12%, effective (market)...
Complete the below table to calculate the price of a $1.5 million bond issue under each...
Complete the below table to calculate the price of a $1.5 million bond issue under each of the following independent assumptions (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1): 1. Maturity 15 years, interest paid annually, stated rate 8%, effective (market) rate 10%. 2. Maturity 15 years, interest paid semiannually, stated rate 8%, effective (market) rate 10%. 3. Maturity 5 years, interest paid semiannually, stated rate 10%, effective (market)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT