The problem requires you to use spreadsheet Case Study$3-$Excel File.xlsx to solve this problem.

Jenna bought a bond that was issued by Sherlock Watson Industries $($SWI$)$ three years ago. The bond

has a $$1,000$ maturity value, a coupon rate equal to $9$ percent, and it matures in $17$ years. Interest is paid

every six months; the next interest payment is scheduled for six months from today.

a$.$ If the yield on similar risk investments is $11$ percent, what is the current market value $($price$)$ of the

bond? tell in detail formula and answer