Answer:
7.96%
Explanation:
We have to use the RATE formula that is shown in the spreadsheet.
Provided that,
Present value = $1,000
Assuming figure - Future value or Face value = $1,070
PMT = 1,000 × 7% = $70
NPER = 6 years
The formula is shown below:
= Rate(NPER,PMT,-PV,FV,type)
The present value come in negative
Therefore, the realized rate of return is 7.96%