Using "EXCEL" only. No FINANCIAL CALCULATOR

4. A\$100,000 - 20 year bond has a coupon rate of 6.5% semi - annually. Yesterday it tivas rated triple B with a market rate of 7.15%. Today it was upgraded to single A with a market rate of 6.4%. A. What was yesterday's bond price? B. What is today's bond price? 5. We purchased Walmart for $55 a share. At the time of purchase we issued a stop limit sale order at $50 a share. Yesterday the stock closed at $52 a share but this morning opened at $47 and continues to fall. What did the stop - limit order do for us? 6. You short 1,000 shares of McDonalds at $58 per share. A. What is the profit if you close the short when McDonalds is at $47 ? B. What is the profit if you close the short when McDonalds is at $65