Answer:
4.20%
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,150
Future value = $1,067.50
Assuming Par value = $1,000
PMT = 1,000 × 6.35% = $63.50
NPER = 5 years
The formula is shown below:
= Rate(NPER;PMT;-PV;FV;type)
The present value come in negative
So, after solving this, the rate of return is 4.20%