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% Â Â Â Â Â Â