Please use the PV function in Excel and take a screen shot of it ...

80.2K

Verified Solution

Question

Accounting

image

image

Please use the PV function in Excel and take a screen shot of it

Cowen Corporation issued $660,000 of 6%, 15-year bonds payable on March 31, 2019. The market interest rate at the date of issuance was 9%, and the bonds pay interest semiannually, Cowen Corporation's year-end is March 31, Read the requirements. 1. Using the PV function in Excel, calculate the issue price of the bonds. (Round your answer to the nearest whole dollar.) The issue price of the bonds is $ 2. Prepare an effective-interest amortization table for the bond through the first three interest payments. Round amounts to the nearest dollar Discount Bond Interest Interest Discount Amortization Account Balance Carrying Amount Payment Expense Semiannual Interest Date Mar 31, 2019 Sep 30, 2019 Mar 31, 2020 Sep 30, 2020 3. Record Cowen Corporation's issuance of the bonds on March 31, 2019, and payment of the first semiannual interest amount and amortization of the bond discount on September 30, 2019. (Record debits first, then credits. Exclude explanations from any joumal entries.) Start by recording the issuance of bonde March 31, 2019 Journal Entry Accounts Debit Credit Mar Dato 31 Accounts Payable Bonds Payable Cowen Corporation issued $680,000 of 6%, 15-year bonds payable on March 31, 2019. The market interest rate at the date of issuance was 9%, and the bonds pay interest semiannually. Cowen Corporation's year-end is March 31. Read the requirements. -- Sep 30, 2019 Mar 31, 2020 Sep 30, 2020 3. Record Cowen Corporation's issuance of the bonds March 31, 2019, and payment of the first semiannual interest amount and amortization of the bond discount on September 30, 2019. (Record debits first, then credits. Exclude explanations from any joumal entries.) Start by recording the issuance bonds on March 31, 2019. Journal Entry Date Accounts Debit Credit Mar 31 Now record the payment of the first semiannual interest amount and amorlization of the bond discount on September 30, 2019 Journal Entry Date Accounts Debit Credit Sep 30

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students