James Bond

Six years ago, you bought a corporate bond issued by James Corporation, James Bond Series $007.$

That bond has a yield of $7\mathrm{.}6\%$ and had following characteristics: Coupon $=6\%$ quarterly, Term $=30$

years, Face Value $=$$$8,000.$ Today, the same bond has a yield of $8\mathrm{.}4\%.$ Today, you sell the bond to Tom Brady. Tom Brady will own it for $9$ years $($measured from today$)$ and sells it Michael Jordan for

$$1,080.$ Determine the following.

A$)$ Your HPY

B$)$ Tom Brady's HPY

C$)$ Jordan's Yield to Maturity

D$)$ Tom Brady's Current Yield

Can you use Excel formulas please