Problem 1: What is the current value of a bond with the following terms: 15 years to maturity, $1000 Par, 6% coupon, annual interest, similar risk investments yield 7%.
Problem 2: What would be the value of the bond if semi-annual interest was paid instead?
Please help me to resolve these questions. Use excel please.