THIS QUESTION SHOULD BE ANSWERED IN AN EXCEL FILE. WHEN YOU HAVE ANSWERED THE QUESTION, NAME YOUR FILE YOUR LAST NAME_#8
Posted: Thu May 05, 2022 8:15 am
- This Question Should Be Answered In An Excel File When You Have Answered The Question Name Your File Your Last Name 8 1 (101 KiB) Viewed 45 times
THIS QUESTION SHOULD BE ANSWERED IN AN EXCEL FILE. WHEN YOU HAVE ANSWERED THE QUESTION, NAME YOUR FILE YOUR LAST NAME_#8 AND UPLOAD IT TO CANVAS. 8) An investor is considering purchasing a Verizon bond. The bond has a $1,000 face value, an 6.5% coupon rate and matures in 5 years. The bond is currently quoted at 98. a) If the investor decides to buy the bond today, how much will she pay, in dollars? b) If the investor has a discount rate of 5.0%, what is the Present Value of the bond? Make relevant calculations using Excel formulas so I can see all of your work. c) Based on your calculations, should the investor buy the bond or not? Explain your reasoning briefly.