Answer:
- 3.21%
Explanation:
In this question, we use the PV formula which is shown in the spreadsheet.
The NPER represents the time period.
Given that,
Future value = $1,000
PMT = 1,000 × 5% = 50
NPER = 34 years - 1 year = 33 year
Rate of interest = 9%
The formula is shown below:
= -PV(Rate;NPER;PMT;FV;type)
So, after solving this, the present value would be $581.42
Now the return would be
= Sale price + interest - purchase price
= $581.42 + $50 - $652.39
= -$20.97
And, the total return would be
= Return ÷ purchase price
= -$20.97 ÷ $652.39
= - 3.21%