Answer:
89.66 years
Explanation:
In this question, we use the NPER formula which is shown in the spreadsheet.
The NPER represents the time period.
Given that,
Present value = $1,500
Future value = $4,000
Rate of interest = 1.1%
The formula is shown below:
= NPER(Rate;PMT;-PV;FV;type)
The present value come in negative
So, after solving this, the answer would be 89.66 years