5On January 1, Ruiz Company issued bonds as follows:Face Value:Number of Years:Stated Interest Rate:Interest payments per year7B9012AWNIC$500,000a)Required:1) Calculate the bond selling price given the two market interest rates below.Use formulas that reference data from this worksheet and from the appropriate future or present value tables (found by clicking the tabs at the bottothis worksheet).Note: Rounding is not required.157%2Annual Market RateSemiannual Interest Payment:PV of Face Value:+PV of Interest Payments:Bond Selling Price:Annual Market RateSemiannual Interest Payment:PV of Face Value:+PV of Interest Payments:= Bond Selling Price:9%$17,500133,500.01285,055.55418,555.566.00%$17,500205,993.385343,007.72$549,001.10+

Bonds are the securities issued by an entity on the market. These are an obligation for the entity.…

Answered: On January 1, Ruiz Company issued bonds…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter11: Bond Pricing And Amortization (bonds)

Section: Chapter Questions

Problem 7R

See similar textbooks

Similar questions

On January 1, Ruiz Company issued bonds as follows: Face Value: $500,000 Number of Years: 15 Stated Interest Rate: 7% Interest payments per year 2 Question: 1) Calculate the bond selling price given the two market interest rates below. Use formulas that reference data from this worksheet and from the appropriate future or present value tables (found by clicking the tabs at the bottom of this worksheet). Note: Rounding is not required. Use (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1.)
tELLiy, you must enter your ID number on the first sheet! On January 1, 2020 Omsk Corporation issued Bonds pay interest each July 1 and January 1. 150,000 of 5 % bonds, due in 17 years 12 % market rate of interest. Assume Requirements (Round to 0 decimals, Rounding errors do not matter): 1. Compute market price of bonds. Provide detailed computation. Use functions in Excel 2. What is an amount of discount /premium? Indicate, what it is (discount or premium). Computation. 3. Prepare amortization schedule for first 5 years. Use formulas in Excel. 4. Prepare journal entry to record bond issue. 5. Prepare journal entry on July 1, 2020. 6. Prepare journal entry on December 31, 2020. 7. Prepare journal entry on January 1, 2021
The notes to the Thorson Ltd.financial statements reported the following data on December 31, Year 1 (end of the fiscal year): Thorson amortizes bond discounts using the effective-interest method and pays all interestamounts at December 31. Requirements1. Assume the market interest rate is 6% on January 1 of year 1, the date the bonds are issued.a. Using the PV function in Excel, what is the issue price of the bonds?b. What is the maturity value of the bonds?c. What is Thorson’s annual cash interest payment on the bonds?d. What is the carrying amount of the bonds at December 31, year 1?2. Prepare an amortization table through the maturity date for the bonds using Excel. (Roundall amounts to the nearest dollar.) How much is Thorson’s interest expense on the bonds forthe year ended December 31, Year 4?3. Show how Thorson would report these bonds and notes at December 31, Year 4.
1. Journalize the entry to record the amount of cash proceeds from the issuance of the bonds on July 1, 20Y1. 2a. Journalize the entry to record the first semiannual interest payment on December 31, 20Y1, and the amortization of the bond premium, using the straight-line method.Compute the price of $42,601,480 received for the bonds by using the present value tables
5. Compute the price of $94,580,761 received for the bonds by using the tables shown in Present Value Tables. (Round to the nearest dollar.) Present value of the face amount Present value of the semiannual interest payments Price received for the bonds
[The following information applies to the questions displayed below.] Hillside issues $4,000,000 of 6%, 15-year bonds dated January 1, 2021, that pay interest semiannually on June 30 and December 31. The bonds are issued at a price of $3,456,448. Required: 1. Prepare the January 1 journal entry to record the bonds' issuance. 2(a) For each semiannual period, complete the table below to calculate the cash payment. 2(b) For each semiannual period, complete the table below to calculate the straight-line discount amortization. 2(c) For each semiannual period, complete the table below to calculate the bond interest expense. 3. Complete the below table to calculate the total bond interest expense to be recognized over the bonds' life. 4. Prepare the first two years of a straight-line amortization table. 5. Prepare the journal entries to record the first two interest payments. Complete this question by entering your answers in the tabs below. Req 1 Req 2A to 2C Req 3 Req 4 Req 5 For each…
Calculate the purchase price of the $1,000 face value bond using the information given below. (Do not round the intermediate calculations. Round your final answer to 2 decimal places.) Issue date Maturity date Purchase date Coupon rate (%) Market rate (%) Dec 15, 1992 Dec 15, 2027 June 15, 2008 5.75 7.9 Assume that Bond interest is paid semiannually. The bond was originally issued at its face value. Bonds are redeemed at their face value at maturity. Market rates of return are compounded
The table below shows current and expected future one-year interest rates, as well as current interest rates on multiyear bonds. Use the table to calculate the liquidity premium for each multiyear bond. One-Year Bond Rate 2.00% 3.00% 4.00% 7.00% 10.00% 11 =% 21 = 131 The liquidity premiums for each year are given as: (Enter your responses rounded to two decimal places.) 141 151 = = = Year 1 2 3 4 5 % % % % Multiyear Bond Rate 2.00% 3.00% 6.00% 8.00% 11.00%
Calculate the purchase price of the $1,000 face value bond using the information given below. (Do not round the intermediate calculations. Round your final answer to 2 decimal places.) Issue date Maturity date Purchase date Coupon rate (%) Market rate (%) Dec 15, 1992 Dec 15, 2022 June 15, 2010 5.40 7.2 Assume that Bond interest is paid semiannually. The bond was originally issued at its face value. Bonds are redeemed at their face value at maturity. Market rates of return are compounded semiannually. Bond price $
Review the following three bonds payable assumptions: (Click the icon to view the bond assumptions.) Journalize issuance of the bond and the first semiannual interest payment under each of the three assumptions. The company amortizes bond premium and discount by the effective-interest amortization method. Explanations are not required. (Record debits first, then credits. Exclude explanations from any journal entries. Round your final answers to the nearest whole dollar.) More Info - X Jaid semiannually. The market rate of interest is 10% at issuance. The present value of the bonds at issuance is $86.0000. 1. Seven-year bonds payable with face value of $86,000 and stated interest rate of 10%, paid semiannually. The market rate of interest is 10% at issuance. The present value of the bonds at issuance is $86.000. 2. Same bonds payable as in assumption 1, but the market interest rate is 12%. The present value of the bonds at issuance is $77,981. 3. Same bonds payable as in assumption 1,…
Review the following three bonds payable assumptions: 1 (Click the icon to view the bond assumptions.) Journalize issuance of the bond and the first semiannual interest payment under each of the three assumptions. The company amortizes bond premium and discount by the effective-interest amortization method. Explanations are not required. (Record debits first, then credits. Exclude explanations from any journal entries. Round your final answers to the nearest whole dollar.) O More Info semiannually. 1. Ten-year bonds payable with face value of $89,000 and stated interest rate of 14%, paid semiannually. The market rate of interest is 14% at issuance. The present value of the bonds at issuance is $89,000. 2. Same bonds payable as in assumption 1, but the market interest rate is 16%. The present value of the bonds at issuance is $80,301. 3. Same bonds payable as in assumption 1, but the market interest rate is 12%. The present value of the bonds at issuance is $99,226. Print Done
Devin Company computes the following bond interest amortization table for bonds issued on January 1, 2021. Use the information on this table to answer the questions below. Interest Cash Payment Payment Interest Decrease in Вook Date Amount Discount Value Expense $441,068 $444,310 $447,683 $451,190 $454,838 $458,631 $462,577 $466,680 $470,947 $475,385 Discount $360,000 $360,000 $360,000 $360,000 $360,000 $360,000 $360,000 $360,000 $360,000 $360,000 $81,068 $84,310 $87,683 $91,190 $94,838 $98,631 $102,577 $106,680 $110,947 $115,385 $892,240 $807,929 $720,247 $629,056 $534,219 $435,587 $333,011 $226,331 $115,385 $0 $11,107,760 $11,192,071 $11,279,753 $11,370,944 $11,465,781 $11,564,413 $11,666,989 $11,773,669 $11,884,615 $12,000,000 June 30, 2021 Dec 31, 2021 June 30, 2022 Dec 31, 2022 June 30, 2023 Dec 31, 2023 June 30, 2024 Dec 31, 2024 June 30, 2025 Dec 31, 2025

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Financial Accounting: The Impact on Decision Make…

Accounting

ISBN:

9781305654174

Author:

Gary A. Porter, Curtis L. Norton

Publisher:

Cengage Learning

Principles of Accounting Volume 1

Accounting

ISBN:

9781947172685

Author:

OpenStax

Publisher:

OpenStax College

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Financial Accounting: The Impact on Decision Make…

Accounting

ISBN:

9781305654174

Author:

Gary A. Porter, Curtis L. Norton

Publisher:

Cengage Learning

Principles of Accounting Volume 1

Accounting

ISBN:

9781947172685

Author:

OpenStax

Publisher:

OpenStax College

SEE MORE TEXTBOOKS