Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
On January 2, HONDA Motors, Inc
On January 2, HONDA Motors, Inc. issued 1,000, $1,000 bonds to finance a new showroom. The bonds are 5-year, 6% bonds that pay interest on December 31 each year. When issued, investors required 7% interest and the bonds are due December 31, Year 5. How much is the selling price of the bonds? *
Expert Solution
Computation of Selling Price of Bonds using PV Function in Excel:
=-pv(rate,nper,pmt,fv)
Here,
PV = Selling Price = ?
Rate = 7%
Nper = 5 years
PMT = $1,000*6% = $60
FV = $1,000
Substituting the values in formula:
=-pv(7%,5,60,1000)
PV or Selling Price = $959
So, Selling Price of Bonds = $959*1,000 = $959,000
Archived Solution
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.





