Answer:
7.76%
Step-by-step explanation:
In this question, we use the PMT formula which is shown in the spreadsheet.
The NPER represents the time period.
Given that,
Present value = $969
Future value = $1,000
Rate of interest = 8.1%
NPER = 17 years
The formula is shown below:
= PMT(Rate;NPER;-PV;FV;type)
The present value come in negative
So, after solving this, The PMT would be $77.58
The coupon rate is shown below:
= (Coupon payment ÷ par value) × 100
= ($77.58 ÷ $1,000) × 100
= 7.76%