Answer:
5.84%
Explanation:
We use the RATE function that is shown in the excel. Kindly find the attachment below:
The NPER shows the time period.
Given that,
Present value = $45
Future value or Face value = $47
PMT = $2
NPER = 3
The formula is shown below:
= Rate(NPER,PMT,-PV,FV,type)
So, the annual compound rate of return is 5.84%