Bond Valuation... PLEASE HELP!!! I am in need of assistance with this assignment! Thank you in advance!

Bob is managing a bond issue for the company. You receive an urgent voice mail from him. Bob: As you know, I'm managing a bond issue for the company. This morningthe day the bond issue is to go to market to let me know that two other similar issues are being marketed. Our issue is for $50 million, carrying a 5.9% coupon that we price our issue to yield 6.12%. I need to make a recommendation on how to price our issue. Since the CFO m with the issue, this is of the utmost urgency. Deliverables 1. Calculate the cost of repricing the bond issue. 2. Please provide the expected additional cost associated with Karen's recommendation of pricing the issue to yie 3. Provide the additional cost to the company. Support your answer by showing the calculations. Submit your ana issue is to go to marketKaren, one of our investment bankers, called n, carrying a 5.9% coupon and a 25-year maturity. Karen recommends our issue. Since the CFO must make the final decision to proceed or not of pricing the issue to yield the more competitive return. ulations. Submit your analysis in my drop box. Activity 1: Solution: Apply the traditional bond valuation model in pricing the issue at the recommended market rate: Vo = ?? What is the YTM of this bond? You would determine that largely by reviewing the coupon rate payment. Please keep in mind that the bond face value is a To yield X%, the bond must be discounted to price at .... This represents a $Y discount per bond. There are 50,000 bonds in To determine the price of a bond, if you know the YTM and the coupon, please use either a bond financial calculator (show use the wizard within Excel, if not comfortable with this function. ind that the bond face value is assumed to be the standard $1,000. ond. There are 50,000 bonds in the $50 million issue resulting in a cost to the firm of $xxx, definitely not a deal killer. bond financial calculator (showing all the steps) or an Excel spreadsheet and the financial function -PV. I would suggest you ot a deal killer. V. I would suggest you