I need this to put into an excel spreed sheet: The following transactions were c

Question

I need this to put into an excel spreed sheet:

The following transactions were completed by Winklevoss Inc., whose fiscal year is the calendar year:

Required:

2016 July 1 Issued $32,300,000 of 20-year, 9% callable bonds dated July 1, 2016, at a market (effective) rate of 11%, receiving cash of $27,116,993. Interest is payable semiannually on December 31 and June 30. Oct. 1 Borrowed $430,000 by issuing a six-year, 4% installment note to Nicks Bank. The note requires annual payments of $82,028, with the first payment occurring on September 30, 2017. Dec. 31 Accrued $4,300 of interest on the installment note. The interest is payable on the date of the next installment note payment. 31 Paid the semiannual interest on the bonds. The bond discount amortization of $129,575 is combined with the semiannual interest payment. 31 Closed the interest expense account. 2017 June 30 Paid the semiannual interest on the bonds. The bond discount amortization of $129,575 is combined with the semiannual interest payment. Sept. 30 Paid the annual payment on the note, which consisted of interest of $17,200 and principal of $64,828. Dec. 31 Accrued $3,652 of interest on the installment note. The interest is payable on the date of the next installment note payment. 31 Paid the semiannual interest on the bonds. The bond discount amortization of $129,575 is combined with the semiannual interest payment. 31 Closed the interest expense account. 2018 June 30 Recorded the redemption of the bonds, which were called at 98. The balance in the bond discount account is $4,664,707 after payment of interest and amortization of discount have been recorded. (Record the redemption only.) Sept. 30 Paid the second annual payment on the note, which consisted of interest of $14,607 and principal of $67,421.

Explanation / Answer

Date Account title Debit Credit 2016 July 1 Cash 27116993 Discount on bonds payable 5183007 Bonds payable 32300000 2016 Oct 1 Cash 430000 6 year 4% instalment notes 430000 Dec-31 Interest on instalment note 4300 Interest accrued on instalment note   4300 3 months interest Dec-31 Interest on bonds 1453500 Discount on bonds payable 129575 cash 1323925 2017 Jun-30 Interest on bonds 1453500 Discount on bonds payable 129575 cash 1323925 Sep-30 Interest on instalment note 12900 Interest accrued on instalment note   4300 6 year 4% instalment notes 64828 Cash 82028 Dec-31 Interest on instalment note 3652 Interest accrued on instalment note   3652 Dec-31 Interest on bonds 1453500 Discount on bonds payable 129575 cash 1323925 2018 Jun-30 Interest on bonds 1453500 Discount on bonds payable 129575 cash 1323925 Jun-30 Bonds Payable 32300000 Loss on Early Retirement of Bonds 4018707 Discount on Bonds Payable 4664707 Cash 31654000 Sep-30 Interest on instalment note 10955 Interest accrued on instalment note   3652 6 year 4% instalment notes 67421 Cash 82028 Carrying value of the bond as on 31st December 2017 32300000 - 3 (129575) 31911275 Interest expense 2016 4300 + 1453500 1457800 Interest expense 2017 1453500 * 2 + 3652 + 12900 2923552 2

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.