LO 2 (Learning Objective 2: Issue bonds payable (premium); record interest payment and the related bond amortization using the effective-interest method) On June 30, 2018, the market interest rate is 9%. Ramsey Corporation issues $550,000 of 12%, 20-yearbonds payable. The bonds pay interest on June 30 and December 31. The company amortizes bond premium using the effective-interest method. Requirements 1. Use the PV function in Excel to calculate the issue price of the bonds. 2. Prepare a bond amortization table for the term of the bonds using Excel. 3. Record the issuance of bonds payable on June 30, 2018; the payment of interest of December 31, 2018; and the payment of interest on June 30, 2019.
LO 2 (Learning Objective 2: Issue bonds payable (premium); record interest payment and the related bond amortization using the effective-interest method) On June 30, 2018, the market interest rate is 9%. Ramsey Corporation issues $550,000 of 12%, 20-yearbonds payable. The bonds pay interest on June 30 and December 31. The company amortizes bond premium using the effective-interest method. Requirements 1. Use the PV function in Excel to calculate the issue price of the bonds. 2. Prepare a bond amortization table for the term of the bonds using Excel. 3. Record the issuance of bonds payable on June 30, 2018; the payment of interest of December 31, 2018; and the payment of interest on June 30, 2019.
Solution Summary: The author explains how to calculate the issue price of bonds using PV function in excel.
(Learning Objective 2: Issue bonds payable (premium); record interest payment and the related bond amortization using the effective-interest method) On June 30, 2018, the market interest rate is 9%. Ramsey Corporation issues $550,000 of 12%, 20-yearbonds payable. The bonds pay interest on June 30 and December 31. The company amortizes bond premium using the effective-interest method.
Requirements
1. Use the PV function in Excel to calculate the issue price of the bonds.
2. Prepare a bond amortization table for the term of the bonds using Excel.
3. Record the issuance of bonds payable on June 30, 2018; the payment of interest of December 31, 2018; and the payment of interest on June 30, 2019.
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.