Assume each bond pays semi-annual interest (if it has a 10% contract rate it pays $100 per year or $50 every six months). Use the PV function to find bond values and the RATE function to find yield to maturity or yield to call (remember that the rate obtained is the rate for a six month period and an annual rate is normally reported).
Click on the link below to download the Excel file needed to complete this assignment. The following questions/problems are included in this assignment: Chapter 2: Questions 2, 3, 4, 5 (p. 83) Chapter 2: Problems 1, 2, 7, 8, 9, 10 (pp. 84-85) Chapter 3: Problem 5 (p. 123) Chapter 3: Supplemental Problem Chapter 4: Questions 2, 3, 4 (p. 169) Chapter 4: Problems 2, […]