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.
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 |
ABC Inc issues $500,000 of 11% bonds that are due in 10 years. These bonds pay...
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 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 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 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 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 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 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 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 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 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