Answer:
B.) 12.53 years
Explanation:
In this question, we use the NPER formula which is shown in the spreadsheet.
The NPER represents the time period. inv
Given that,
Present value = $1,023.46
Future value = $1,000
PMT = $1,000 × 7% ÷ 2 = $35
Rate of interest = 6.72% ÷ 2 =3.36%
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 12.53 years