Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. what is answer for the issue price of bond. formul

What is answer for the issue price of bond. Formula I need is for excel...

50.1K

Verified Solution

Question

Accounting

What is answer for the issue price of bond. Formula I need is for excel is =-pmt(rate, Nper,pmt, fv, type)? image
image
The Bridget Rittinghouse Company issues 6%, 4-year bonds with a par value of $410,000 and semiannual interest payments On the issue date, the annual market rate for these bonds is 7%. Enter a valid Excel formula or function in each of the yellow cells below. Formulas must refer to cells addresses. Entering a value will be marked as incorrect Par Value Term (years) Annual market 96 Annual contract % Payments per year $410,0 What is the amount of each semiannual interest payment? How many semiannual payments of $12,300 will be made in total? Using the PV function, calculate the issue price of the bond Make sure the formula returns a positive value. See the instructions tab for help on the PV function. $12 300 Complete the amortization schedule for these bonds Semiannual Cash Interest Bond Interest Discount Unamortized Interest Period Paid Carrying Value Expense Amortization Discount Instructions Bond1 Bond 2G dy Type here to search

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