Answer:
8.83%
Explanation:
For this question, we use the Rate formula which is shown in the attached spreadsheet
Given that,
Present value = $935
Future value or Face value = $980
PMT = $75
NPER = 5 years
The formula is shown below:
= Rate(NPER,PMT,-PV,FV,type)
The present value come in negative
So, the realized rate of return earned on this bond is 8.83%