Question

ABC Inc issues $500,000 of 11% bonds that are due in 10 years. These bonds pay...

ABC Inc issues $500,000 of 11% bonds that are due in 10 years. These bonds pay interest on a semi- annually basis. At the time of issue, the market rate for such bonds were 10%. Please calculate the bonds’ issue price. Excel spreadsheet function to be used.

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Price of bond is the present value of bonds cash flow which is calculated as follows:
Price of bond =-pv(rate,nper,pmt,fv) Where,
=-PV(5%,20,27500,500000) rate 5%
=$ 5,31,155.53 nper 20
pmt $           27,500
fv $       5,00,000
Add a comment
Know the answer?
Add Answer to:
ABC Inc issues $500,000 of 11% bonds that are due in 10 years. These bonds pay...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Bramble Corporation issues $400,000 of 11% bonds that are due in 9 years and pay interest...

    Bramble Corporation issues $400,000 of 11% bonds that are due in 9 years and pay interest semi-annually. At the time of issue, the market rate for such bonds is 10%. Click here to view the factor table PRESENT VALUE OF 1. Click here to view the factor table PRESENT VALUE OF AN ANNUITY OF 1. Calculate the bonds’ issue price by using (1) factor Tables A.2 and A.4, (2) a financial calculator, or (3) Excel function PV. (Hint: Refer to...

  • Mountain Excursions issues bonds due in 10 years with a stated interest rate of 11% and...

    Mountain Excursions issues bonds due in 10 years with a stated interest rate of 11% and a face value of $140,000. Interest payments are made semi- annually. The market rate for this type of bond is 12%. Using a financial calculator or Excel, calculate the issue price of the bonds. Multiple Choice $131,971 0 $148,724 0 $140,000 $88,583

  • Mountain Excursions issues bonds due in 15 years with a stated interest rate of 11% and...

    Mountain Excursions issues bonds due in 15 years with a stated interest rate of 11% and a face value of $180,000. Interest payments are made semi-annually. The market rate for this type of bond is 12%. Using a financial calculator or Excel, calculate the issue price of the bonds. Multiple Choice $193,835. $167,612. $180,000. $100,313.

  • Hillside Excursions issues bonds due in 12 years with a stated interest rate of 11% and...

    Hillside Excursions issues bonds due in 12 years with a stated interest rate of 11% and a face value of $100,000. Interest payments are made semi-annually. The market rate for this type of bond is 8%. Using a financial calculator or Excel, calculate the issue price of the bonds. A) 93,320 B) 106,592 C) 122,870 D) 100,000

  • Brief Exercise 14-3 Martinez Corporation issues $450,000 of 1190 bonds that are due in 8 years...

    Brief Exercise 14-3 Martinez Corporation issues $450,000 of 1190 bonds that are due in 8 years and pay interest semi-annually. At the time of issue, the market rate for such bonds is 10% lick here to view the factor table Using time value of money tables, a financial calculator, and computer spreadsheet functions, calculate the bonds issue price. (For calculation purposes, use 5 decimal places as splayed in the factor table provided and round final answer to 0 decimal places,...

  • Brief Exercise 14-3 Ayayai Corporation issues $400,000 of 9% bonds that are due in 8 years...

    Brief Exercise 14-3 Ayayai Corporation issues $400,000 of 9% bonds that are due in 8 years and pay interest semi-annually. At the time of issue, the market rate for such bonds is 8%. Click here to view the factor table PRESENT VALUE OF 1. Click here to view the factor table PRESENT VALUE OF AN ANNUITY OF 1. Calculate the bonds' issue price by using (1) factor Tables A.2 and A.4, (2) a financial calculator, or (3) Excel function PV....

  • Help Save & Ext Submit Hillside Excursions issues bonds due in 10 years with a stated...

    Help Save & Ext Submit Hillside Excursions issues bonds due in 10 years with a stated interest rate of 8% and a face value of $200,000. Interest payments are made semi-annually. The market rate for this type of bond is 6%. Using a financial calculator or Excel, calculate the issue price of the bonds. o $200,000. o $174,500. o О $229,755, o

  • Air Destinations issues bonds due in 10 years with a stated interest rate of 6% and...

    Air Destinations issues bonds due in 10 years with a stated interest rate of 6% and a face value of $500,000. Interest payments are made semi-annually. The market rate for this type of bond is 7%. Using present value tables, calculate the issue price of the bonds. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) Multiple Choice $537,194. $464,471. $359,528. $500,000.

  • Ocean Adventures issues bonds due in 10 years with a stated interest rate of 8% and...

    Ocean Adventures issues bonds due in 10 years with a stated interest rate of 8% and a face value of $450,000. Interest payments are made semi- annually. The market rate for this type of bond is 7%. Using a financial calculator or Excel, what is the issue price of the bonds? Multiple Choice Ο $450,000. Ο $420,732. Ο $490,934. Ο $481,978.

  • Mountain Excursions issues bonds due in 12 years with a stated interest rate of 12% and...

    Mountain Excursions issues bonds due in 12 years with a stated interest rate of 12% and a face value of $120,000. Interest payments are made semi-annually. The market rate for this type of bond is 13%. Using a financial calculator or Excel, calculate the issue price of the bonds. A) 70,292 B) 112,806 C) 127,891 D) 120,000

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT