# Question: It is currently the beginning of 2010 A city labeled

It is currently the beginning of 2010. A city (labeled C for convenience) is trying to sell municipal bonds to support improvements in recreational facilities and highways. The face values (in thousands of dollars) of the bonds and the due dates at which principal comes due are listed in the file S14_104.xlsx. (The due dates are the beginnings of the years listed.) An underwriting company (U) wants to underwrite C’s bonds. A proposal to C for underwriting this issue consists of the following:

(1) An interest rate, 3%, 4%, 5%, 6%, or 7%, for each bond, where coupons are paid annually, and

(2) An up-front premium paid by U to C. U has determined the set of fair prices (in thousands of dollars) for the bonds listed in the same file.

For example, if U underwrites bond 2 maturing in 2013 at 5%, it will charge C $444,000 for that bond.

U is constrained to use at most three different interest rates. U wants to make a profit of at least $46,000, where its profit is equal to the sale price of the bonds minus the face value of the bonds minus the premium U pays to C. To maximize the chance that U will get C’s business, U wants to minimize the total cost of the bond issue to C, which is equal to the total interest on the bonds minus the premium paid by U. For example, if the year 2012 bond (bond 1) is issued at a 4% rate, then C must pay two years of coupon interest: 2(0.04)($700,000) = $56,000. What assignment of interest rates to each bond and up-front premiums ensure that U will make the desired profit (assuming it gets the contract) and maximize the chance of U getting C’s business? To maximize this chance, you can assume that U minimizes the net cost to C, that is, the cost of its coupon payments minus the premium from U to C.

(1) An interest rate, 3%, 4%, 5%, 6%, or 7%, for each bond, where coupons are paid annually, and

(2) An up-front premium paid by U to C. U has determined the set of fair prices (in thousands of dollars) for the bonds listed in the same file.

For example, if U underwrites bond 2 maturing in 2013 at 5%, it will charge C $444,000 for that bond.

U is constrained to use at most three different interest rates. U wants to make a profit of at least $46,000, where its profit is equal to the sale price of the bonds minus the face value of the bonds minus the premium U pays to C. To maximize the chance that U will get C’s business, U wants to minimize the total cost of the bond issue to C, which is equal to the total interest on the bonds minus the premium paid by U. For example, if the year 2012 bond (bond 1) is issued at a 4% rate, then C must pay two years of coupon interest: 2(0.04)($700,000) = $56,000. What assignment of interest rates to each bond and up-front premiums ensure that U will make the desired profit (assuming it gets the contract) and maximize the chance of U getting C’s business? To maximize this chance, you can assume that U minimizes the net cost to C, that is, the cost of its coupon payments minus the premium from U to C.

**View Solution:**## Answer to relevant Questions

This problem deals with strategic planning issues for a large company.18 The main issue is planning the company’s production capacity for the coming year. At issue is the overall level of capacity and the type of ...Use @RISK to draw a normal distribution with mean 500 and standard deviation 100. Then answer the following questions.a. What is the probability that a random number from this distribution is less than 450?b. What is the ...Suppose you own an expensive car and purchase auto insurance. This insurance has a $1000 deductible, so that if you have an accident and the damage is less than $1000, you pay for it out of your pocket. However, if the ...In Problem 12 of the previous section, suppose that the demand for cars is normally distributed with mean 100 and standard deviation 15. Use @RISK to determine the “best” order quantity—in this case, the one with the ...The Business School at State University currently has three parking lots, each containing 155 spaces. Two hundred faculty members have been assigned to each lot. On a peak day, an average of 70% of all lot 1 parking sticker ...Post your question