Answer:
3.56%
Explanation:
In this question, we use the Rate formula which is shown in the spreadsheet.
The NPER represents the time period.
Given that,
NPER = 11 × 2 = 22 years
Present value = $1,000 × 104% = $1,040
Future value = $1,000
PMT = 1,000 × 4% × (6 months ÷ 12 months) = $20
The formula is shown below:
= Rate(NPER;PMT;-PV;FV;type)
The present value come in negative
So, after solving this, the answer would be 3.56% ( 1.78 × 2)
