Last year Janet purchased a $1,000 face value corporate bond with an 7% annual coupon rate and a 30-year maturity. At the time of the purchase, it had an expected yield to maturity of 12.74%. If Janet sold the bond today for $1,074.57, what rate of return would she have earned for the past year? Do not round intermediate calculations. Round your answer to two decimal places.
Put into a excel spreadsheet please to see calculations.