Answer:
$937.59
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.76% ÷ 2 = $28.80
NPER = 21 years × 2 = 42 years
Rate of interest = 6.3% ÷ 2 = 3.15%
The formula is shown below:
= -PV(Rate;NPER;PMT;FV;type)
So, after solving this, the present value would be $937.59