Moon Software Inc is planning to issue two types of 25year n

Moon Software Inc. is planning to issue two types of 25-year, noncallable bonds to raise a total of $6 million, $3 million from each type of bond. First, 3,000 bonds with a 10% semiannual coupon will be sold at their $1,000 par value to raise $3,000,000. These are called \"par\" bonds. Second, Original Issue Discount (OID) bonds, also with a 25-year maturity and a $1,000 par value, will be sold, but these bonds will have a semiannual coupon of only 6.25%. The OID bonds must be offered at below par in order to provide investors with the same effective yield as the par bonds. How many OID bonds must the firm issue to raise $3,000,000? Disregard flotation costs, and round your final answer up to a whole number of bonds.

Solution

FV = 1000, PMT = 62.5/2, N = 50, rate = 5% (since 10% bond is at par the rate = 10%/2)

use PV function in Excel

price per bond = 657.7014

number of bonds = 3,000,000/657.7014 = 4,561