Answer:
7.82%
Explanation:
In this question, we use the Rate formula which is shown in the spreadsheet. Â
The NPER represents the time period. Â
Given that, Â
Present value = $1,131
Future value or Face value = $1,000 Â
PMT = 1,000 × 9.1% ÷ 2 = $45.5
NPER = 21 years × 2 = 42 years
The formula is shown below: Â
= Rate(NPER;PMT;-PV;FV;type) Â
The present value come in negative Â
So, after solving this, Â the coupon rate would be 7.82%