how did you get the value of the bond, show all your work and show the formulas that you used to get these answers.

show the formulas in excel

Question 2 You are an auditor with a major accounting firm. You have been assigned to put a value on the bonds being held by a major investor in a hedge fund. The hedge fund is looking for a major line of credit and their financial position needs to be reviewed. The Bonds being held have the following terms: 10 Maturity: 11.696 YTM: $1,000 Par Value: 7.5% Coupon Rate: What is the value of this Bond at this time