Answer:
9.53%
Step-by-step explanation:
In this question, we use the Rate formula which is shown in the spreadsheet.
The NPER represents the time period.
Given that,
NPER - 9 years
PMT - $1,000 × 8% = $80
Present value = $910.40
Future value = $1,000
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 9.53%