Answer:
$993.01
Explanation:
In this question, we use the present value formula which is shown in the spreadsheet.
The NPER represents the time period.
Given that,
Future value = $1,000
Rate of interest = {1 + (5.75% ÷ 2)^2 - 1 = 5.83%
NPER = 12 years
PMT = $1,000 × 5.75 = $57.50
The formula is shown below:
= -PV(Rate;NPER;PMT;FV;type)
So, after solving this, the answer would be $993.01