Your friend Marvin is excited because he believes he’s found an investment bar- gain. A broker at QuickCash Investments has offered him an opportunity to buy a bond issued by Galveston Galleries Inc. at a very attractive price. The 30-year bond was issued ten years ago at a face value of $1,000, paying a coupon rate of 8%. Interest rates have risen recently driving bond prices down, but most economists think they’ll fall again soon driving prices back up. That makes Marvin and his broker think this bond may be a real money maker if he buys now, holds for a year or two, and then sells. The bonds of companies that were similar to Galveston at the time its bond was issued are now yielding 12%. Galveston’s bond is selling at $300 which the broker claims is a fantastic bargain. Marvin knows you’re a finance major and has asked your opinion of the opportunity. How would you advise him?
please do in excel with calculation....